DBA Data[Home] [Help]

APPS.OKE_MILPAC_INTG_WF dependencies on OKE_K_FORM_HEADERS

Line 34: FROM oke_k_form_headers kfh

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

Line 109: -- OKE_K_FORM_HEADERS

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

Line 236: FROM oke_k_form_headers

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

Line 275: WHERE entity_name = 'OKE_K_FORM_HEADERS'

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:

Line 300: , X_ENTITY_NAME => 'OKE_K_FORM_HEADERS'

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