DBA Data[Home] [Help]

APPS.OKE_FORM_DD250 dependencies on OKE_K_FORM_HEADERS

Line 130: FROM oke_k_form_headers

126: WHERE organization_id = P_Inv_Org_ID;
127:
128: CURSOR ShipNum IS
129: SELECT MAX(Form_Header_Number)
130: FROM oke_k_form_headers
131: WHERE k_header_id = P_K_Header_ID
132: AND print_form_code = 'DD250'
133: AND substr(form_header_number , 1 , 3 ) = ShipNumPfx;
134:

Line 264: FROM oke_k_form_headers

260: ( C_K_Header_ID NUMBER
261: , C_Shipment_Num VARCHAR2
262: ) IS
263: SELECT Form_Header_ID
264: FROM oke_k_form_headers
265: WHERE k_header_id = C_K_Header_ID
266: AND print_form_code = 'DD250'
267: AND form_header_number = C_Shipment_Num;
268:

Line 571: FROM oke_k_form_headers

567: , C_Delivery_ID NUMBER
568: , C_Inv_Org_ID NUMBER
569: ) IS
570: SELECT Form_Header_Number
571: FROM oke_k_form_headers
572: WHERE k_header_id = C_K_Header_ID
573: AND print_form_code = 'DD250'
574: AND reference1 = C_Delivery_ID
575: AND reference2 = C_Inv_Org_ID;

Line 1164: fnd_file.put_line(fnd_file.log , '... Inserting into OKE_K_FORM_HEADERS');

1160: line_tbl(i).Reference5 := NULL;
1161:
1162: END LOOP;
1163:
1164: fnd_file.put_line(fnd_file.log , '... Inserting into OKE_K_FORM_HEADERS');
1165:
1166: Create_DD250
1167: ( P_Commit => FND_API.G_FALSE
1168: , P_Hdr_Rec => hdr_rec