APPS.JAI_PO_LA_TRIGGER_PKG dependencies on JAI_PO_CMN_PKG

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

438: v_tax_modified_flag := 'N';
439: END IF;
440:
441: -- 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)
442: jai_po_cmn_pkg.insert_line( 'CATALOG', NULL,
443: v_po_hdr_id, v_po_line_id, v_cre_dt,
444: v_cre_by, v_last_upd_dt, v_last_upd_by, v_last_upd_login, 'I'
445: );
446:

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

685:
686: -- POC
687:
688: /* IF v_type_lookup_code IN ( 'RFQ', 'QUOTATION' ) THEN
689: jai_po_cmn_pkg.query_locator_for_line( v_po_hdr_id, 'JAINRFQQ', found );
690: ELSIF v_type_lookup_code IN ( 'STANDARD', 'PLANNED', 'CONTRACT', 'BLANKET' ) THEN
691: jai_po_cmn_pkg.query_locator_for_line( v_po_hdr_id, 'JAINPO', found );
692: END IF;*//*commented by rchandan for bug#4479131*/
693:

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

687:
688: /* IF v_type_lookup_code IN ( 'RFQ', 'QUOTATION' ) THEN
689: jai_po_cmn_pkg.query_locator_for_line( v_po_hdr_id, 'JAINRFQQ', found );
690: ELSIF v_type_lookup_code IN ( 'STANDARD', 'PLANNED', 'CONTRACT', 'BLANKET' ) THEN
691: jai_po_cmn_pkg.query_locator_for_line( v_po_hdr_id, 'JAINPO', found );
692: END IF;*//*commented by rchandan for bug#4479131*/
693:
694: IF nvl(pr_new.from_header_id,0) <> nvl(pr_old.from_header_id,0) and nvl(pr_new.from_line_id,0) <> nvl(pr_old.from_line_id,0) Then /*Added by nprashar for bug # 9362704*/
695: IF v_type_lookup_code IN ('STANDARD', 'PLANNED') Then /*Added by nprashar for bug # 9362704*/

Line 853: jai_po_cmn_pkg.insert_line( 'CATALOG',

849:
850: DELETE FROM JAI_PO_TAXES
851: WHERE Line_Location_Id = v_line_loc_id;
852:
853: jai_po_cmn_pkg.insert_line( 'CATALOG',
854: v_line_loc_id,
855: v_po_hdr_id,
856: v_po_line_id,
857: v_cre_dt,