30:
31: CURSOR DeliveryInfo ( C_Form_Header_ID NUMBER ) IS
32: SELECT wd.name
33: , o.name
34: FROM oke_k_form_headers kfh
35: , wsh_deliveries wd
36: , hr_all_organization_units_tl o
37: WHERE kfh.form_header_id = C_Form_Header_ID
38: AND wd.delivery_id = kfh.reference1
105: , AValue => Requestor );
106:
107: --
108: -- Finally, get Shipping information from the reference column in
109: -- OKE_K_FORM_HEADERS
110: --
111: FormHeaderID := WF_ENGINE.GetItemAttrText
112: ( ItemType => ItemType
113: , ItemKey => ItemKey
232: SELECT form_header_number
233: , print_form_code
234: , k_header_id
235: , fnd_attached_documents_s.nextval attached_document_id
236: FROM oke_k_form_headers
237: WHERE form_header_id = FormHeaderID;
238: frec f%rowtype;
239:
240: BEGIN
271:
272: SELECT nvl(max(seq_num) , 0) + 1
273: INTO SeqNum
274: FROM fnd_attached_documents
275: WHERE entity_name = 'OKE_K_FORM_HEADERS'
276: AND pk1_value = frec.print_form_code
277: AND pk2_value = to_char(frec.k_header_id)
278: AND pk3_value is null;
279:
296: , X_LAST_UPDATE_DATE => sysdate
297: , X_LAST_UPDATED_BY => fnd_global.user_id
298: , X_LAST_UPDATE_LOGIN => fnd_global.login_id
299: , X_SEQ_NUM => SeqNum
300: , X_ENTITY_NAME => 'OKE_K_FORM_HEADERS'
301: , X_COLUMN1 => NULL
302: , X_PK1_VALUE => frec.print_form_code
303: , X_PK2_VALUE => frec.k_header_id
304: , X_PK3_VALUE => NULL