API Oe_Fnd_Attachments_Pub s\u0142u\u017cy do tworzenia i dodawania za\u0142\u0105cznik\u00f3w.<\/p>\n
1. Dodanie za\u0142\u0105cznika do formatki.
\n – Oe_Fnd_Attachments_Pub.Create_Short_Text_Document – utworzenie z\u0142\u0105cznika
\n – OE_FND_ATTACHMENTS_PUB.Add_Attachment – dodanie za\u0142\u0105cznika do formatki<\/p>\n
2. Kopiowanie za\u0142\u0105cznik\u00f3w z formatki na inna formatk\u0119.
\n – pseudo kod<\/p>\n
\r\n l_OEXOEORD VARCHAR2(100):='OE_ORDER_HEADERS';\r\n l_ARXTWMAI VARCHAR2(100):='RA_CUSTOMER_TRX';\r\n v_tab oe_fnd_attachments_pub.Copy_Attachments_Tbl_Type;\r\nFOR rec IN get_invoices(l_request_id)\r\n LOOP\r\n v_tab(1).from_entity_name:=l_OEXOEORD;\r\n v_tab(1).from_pk1_value :=rec.header_id;\r\n v_tab(1).to_entity_name :=l_ARXTWMAI;\r\n v_tab(1).to_pk1_value :=rec.customer_trx_id;\r\n Oe_Fnd_Attachments_Pub.Copy_Attachments( p_api_version => 1.0, p_copy_attachments_tbl =>v_tab );\r\n commit;\r\n END LOOP;\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"API Oe_Fnd_Attachments_Pub s\u0142u\u017cy do tworzenia i dodawania za\u0142\u0105cznik\u00f3w. 1. Dodanie za\u0142\u0105cznika do formatki. – Oe_Fnd_Attachments_Pub.Create_Short_Text_Document – utworzenie z\u0142\u0105cznika – OE_FND_ATTACHMENTS_PUB.Add_Attachment – dodanie za\u0142\u0105cznika do formatki 2. Kopiowanie za\u0142\u0105cznik\u00f3w z formatki na inna formatk\u0119. – pseudo kod l_OEXOEORD VARCHAR2(100):=’OE_ORDER_HEADERS’; l_ARXTWMAI VARCHAR2(100):=’RA_CUSTOMER_TRX’; … Czytaj dalej