APPS.JAI_PO_LA_TRIGGER_PKG dependencies on JAI_PO_CMN_PKG

Line 437: jai_po_cmn_pkg.insert_line( 'CATALOG', NULL,

433: v_tax_modified_flag := 'N';
434: END IF;
435:
436: -- this call is moved here which is previously called after the check (IF v_type_lookup_code = 'BLANKET' OR v_quot_class_code = 'CATALOG' THEN)
437: jai_po_cmn_pkg.insert_line( 'CATALOG', NULL,
438: v_po_hdr_id, v_po_line_id, v_cre_dt,
439: v_cre_by, v_last_upd_dt, v_last_upd_by, v_last_upd_login, 'I'
440: );
441:

Line 668: jai_po_cmn_pkg.query_locator_for_line( v_po_hdr_id, 'JAINRFQQ', found );

664:
665: -- POC
666:
667: /* IF v_type_lookup_code IN ( 'RFQ', 'QUOTATION' ) THEN
668: jai_po_cmn_pkg.query_locator_for_line( v_po_hdr_id, 'JAINRFQQ', found );
669: ELSIF v_type_lookup_code IN ( 'STANDARD', 'PLANNED', 'CONTRACT', 'BLANKET' ) THEN
670: jai_po_cmn_pkg.query_locator_for_line( v_po_hdr_id, 'JAINPO', found );
671: END IF;*//*commented by rchandan for bug#4479131*/
672: IF v_type_lookup_code IN ( 'RFQ', 'QUOTATION' ,'STANDARD', 'PLANNED', 'CONTRACT', 'BLANKET' ) THEN

Line 670: jai_po_cmn_pkg.query_locator_for_line( v_po_hdr_id, 'JAINPO', found );

666:
667: /* IF v_type_lookup_code IN ( 'RFQ', 'QUOTATION' ) THEN
668: jai_po_cmn_pkg.query_locator_for_line( v_po_hdr_id, 'JAINRFQQ', found );
669: ELSIF v_type_lookup_code IN ( 'STANDARD', 'PLANNED', 'CONTRACT', 'BLANKET' ) THEN
670: jai_po_cmn_pkg.query_locator_for_line( v_po_hdr_id, 'JAINPO', found );
671: END IF;*//*commented by rchandan for bug#4479131*/
672: IF v_type_lookup_code IN ( 'RFQ', 'QUOTATION' ,'STANDARD', 'PLANNED', 'CONTRACT', 'BLANKET' ) THEN
673: v_hook_value := jai_cmn_hook_pkg.Ja_In_po_lines_all (
674: P_PO_LINE_ID =>pr_new.PO_LINE_ID ,

Line 796: jai_po_cmn_pkg.insert_line( 'CATALOG',

792:
793: DELETE FROM JAI_PO_TAXES
794: WHERE Line_Location_Id = v_line_loc_id;
795:
796: jai_po_cmn_pkg.insert_line( 'CATALOG',
797: v_line_loc_id,
798: v_po_hdr_id,
799: v_po_line_id,
800: v_cre_dt,