DBA Data[Home] [Help]

APPS.JAI_PO_LA_TRIGGER_PKG dependencies on STANDARD

Line 690: ELSIF v_type_lookup_code IN ( 'STANDARD', 'PLANNED', 'CONTRACT', 'BLANKET' ) THEN

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:
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*/

Line 695: IF v_type_lookup_code IN ('STANDARD', 'PLANNED') Then /*Added by nprashar for bug # 9362704*/

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*/
696: If v_from_header_id is NOT NULL and v_from_line_id is NOT NULL
697: Then
698:
699: OPEN Fetch_UOMCode_Cur( v_line_uom);

Line 729: IF v_type_lookup_code IN ( 'RFQ', 'QUOTATION' ,'STANDARD', 'PLANNED', 'CONTRACT', 'BLANKET' ) THEN

725: End IF;
726: End IF; /*Added by nprashar for bug # 9362704 Ends here*/
727: End IF;
728:
729: IF v_type_lookup_code IN ( 'RFQ', 'QUOTATION' ,'STANDARD', 'PLANNED', 'CONTRACT', 'BLANKET' ) THEN
730: v_hook_value := jai_cmn_hook_pkg.Ja_In_po_lines_all (
731: P_PO_LINE_ID =>pr_new.PO_LINE_ID ,
732: P_PO_HEADER_ID =>pr_new.PO_HEADER_ID ,
733: P_LINE_TYPE_ID =>pr_new.LINE_TYPE_ID ,