eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_PO_LLA_TRIGGER_PKG dependencies on JAI_PO_CMN_PKG

Line 354: 1. Commented rel_found and call to jai_po_cmn_pkg.query_locator_for_release

350: 9 13-Jun-2005 File Version: 116.3
351: Ramananda for bug#4428980. Removal of SQL LITERALs is done
352:
353: 10 06-Jul-2005 rallamse for bug# PADDR Elimination
354: 1. Commented rel_found and call to jai_po_cmn_pkg.query_locator_for_release
355:
356: 11. 08-Jul-2005 Sanjikum for Bug#4483042
357: 1) Added a call to jai_cmn_utils_pkg.validate_po_type, to check whether for the current PO
358: IL functionality should work or not.

Line 551: -- jai_po_cmn_pkg.query_locator_for_release( pr_new.Po_Release_Id, rel_found );

547: END IF;
548: -- End, 3570189
549:
550: -- Commented by Vijay Shankar for bugs# 3570189
551: -- jai_po_cmn_pkg.query_locator_for_release( pr_new.Po_Release_Id, rel_found );
552:
553: OPEN Check_Rfq_Quot_Cur;
554: FETCH Check_Rfq_Quot_Cur INTO v_from_type_lookup_code, v_quot_from_hdr_id, v_type_lookup_code, v_Quot_Class_Code,
555: v_vendor_id, v_vendor_site_id, v_curr, v_ship_loc_id,

Line 580: jai_po_cmn_pkg.insert_line

576:
577: /*Get the Quantity of the parent Line in an Autonomous Transaction*/
578: ja_in_po_get_lineloc_p (v_orig_ship_id, l_prev_quantity);
579: /*Insert into JAI_PO_LINE_LOCATIONS*/
580: jai_po_cmn_pkg.insert_line
581: ( v_type_lookup_code,
582: v_line_loc_id,
583: r_get_po_line_loc_details.po_header_id,
584: r_get_po_line_loc_details.po_line_id,

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

660: END IF;
661:
662: /* commented by Vijay Shankar for bugs# 3570189
663: IF v_type_lookup_code = 'QUOTATION' THEN
664: jai_po_cmn_pkg.query_locator_for_line( v_po_hdr_id, 'JAINRFQQ', found );
665: IF NOT found AND y IS NULL THEN
666: RETURN;
667: END IF;
668: END IF;

Line 773: jai_po_cmn_pkg.insert_line( 'CATALOG', v_line_loc_id, v_po_hdr_id, v_po_line_id, v_cre_dt,

769: );
770: -------------------------------------------------------------------------------------------
771: -- Added by Jia for bug#8745089 on 2009-08-14, End
772:
773: jai_po_cmn_pkg.insert_line( 'CATALOG', v_line_loc_id, v_po_hdr_id, v_po_line_id, v_cre_dt,
774: v_cre_by, v_last_upd_dt, v_last_upd_by, v_last_upd_login, 'I' , v_service_type_code -- 5879769, brathod
775: );
776:
777: -- added by Vijay Shankar for Bug# 3184418

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

802: END IF;
803:
804: /* commented by Vijay Shankar for bugs# 3570189
805: IF v_type_lookup_code = 'RFQ' THEN
806: jai_po_cmn_pkg.query_locator_for_line( v_po_hdr_id, 'JAINRFQQ', found );
807: success := 1;
808:
809: ELSIF v_type_lookup_code IN ( 'STANDARD', 'PLANNED', 'CONTRACT', 'BLANKET' ) THEN
810: jai_po_cmn_pkg.query_locator_for_line( v_po_hdr_id, 'JAINPO', found );

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

806: jai_po_cmn_pkg.query_locator_for_line( v_po_hdr_id, 'JAINRFQQ', found );
807: success := 1;
808:
809: ELSIF v_type_lookup_code IN ( 'STANDARD', 'PLANNED', 'CONTRACT', 'BLANKET' ) THEN
810: jai_po_cmn_pkg.query_locator_for_line( v_po_hdr_id, 'JAINPO', found );
811: success := 1;
812: END IF;
813:
814: IF NOT found AND v_type_lookup_code <> 'RFQ' THEN

Line 825: jai_po_cmn_pkg.insert_line( v_type_lookup_code, v_line_loc_id, v_po_hdr_id, v_po_line_id, v_cre_dt,

821: success := 1;
822:
823: IF v_type_lookup_code <> 'QUOTATION' THEN
824:
825: jai_po_cmn_pkg.insert_line( v_type_lookup_code, v_line_loc_id, v_po_hdr_id, v_po_line_id, v_cre_dt,
826: v_cre_by, v_last_upd_dt, v_last_upd_by, v_last_upd_login, 'I' ,v_service_type_code -- 5879769, brathod
827: );
828:
829: END IF;

Line 872: jai_po_cmn_pkg.query_locator_for_release( pr_new.Po_Release_Id, rel_found );

868:
869: -- Vijay Shankar for Bug# 3570189
870:
871: /* Commented rallamse bug#4479131 PADDR Elimination
872: jai_po_cmn_pkg.query_locator_for_release( pr_new.Po_Release_Id, rel_found );
873: */
874:
875: jai_po_cmn_pkg.process_release_shipment (
876: v_shipment_type, v_src_ship_id, v_line_loc_id, v_po_line_id, v_po_hdr_id,

Line 875: jai_po_cmn_pkg.process_release_shipment (

871: /* Commented rallamse bug#4479131 PADDR Elimination
872: jai_po_cmn_pkg.query_locator_for_release( pr_new.Po_Release_Id, rel_found );
873: */
874:
875: jai_po_cmn_pkg.process_release_shipment (
876: v_shipment_type, v_src_ship_id, v_line_loc_id, v_po_line_id, v_po_hdr_id,
877: v_qty, v_po_rel_id, v_cre_dt, v_cre_by,
878: v_last_upd_dt, v_last_upd_by, v_last_upd_login, 'I'
879: );

Line 1286: /* jai_po_cmn_pkg.query_locator_for_release( pr_new.Po_Release_Id, rel_found );//commented by rchandan for bug#4479131*/

1282: -- END IF;
1283:
1284: -- POC for Releases ONLY
1285:
1286: /* jai_po_cmn_pkg.query_locator_for_release( pr_new.Po_Release_Id, rel_found );*//*commented by rchandan for bug#4479131*/
1287:
1288: /*added by rchandan for bug#4479131*/
1289:
1290: v_hook_value := jai_cmn_hook_pkg.Ja_In_po_line_locations_all( -- added the hook call for bug 3438863 to customize the code for deciding on India loc Tax defaultation

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

1546:
1547: IF v_shipment_type NOT IN ( 'SCHEDULED', 'BLANKET' ) THEN
1548:
1549: /*IF v_type_lookup_code IN ( 'RFQ', 'QUOTATION' ) THEN
1550: jai_po_cmn_pkg.query_locator_for_line( v_po_hdr_id, 'JAINRFQQ', found );
1551: ELSIF v_type_lookup_code IN ( 'STANDARD', 'PLANNED', 'CONTRACT', 'BLANKET' ) and v_exist <> 1 THEN
1552: jai_po_cmn_pkg.query_locator_for_line( v_po_hdr_id, 'JAINPO', found );
1553: END IF;
1554:

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

1548:
1549: /*IF v_type_lookup_code IN ( 'RFQ', 'QUOTATION' ) THEN
1550: jai_po_cmn_pkg.query_locator_for_line( v_po_hdr_id, 'JAINRFQQ', found );
1551: ELSIF v_type_lookup_code IN ( 'STANDARD', 'PLANNED', 'CONTRACT', 'BLANKET' ) and v_exist <> 1 THEN
1552: jai_po_cmn_pkg.query_locator_for_line( v_po_hdr_id, 'JAINPO', found );
1553: END IF;
1554:
1555: IF NOT found THEN
1556: RETURN;

Line 1700: jai_po_cmn_pkg.Ja_In_Po_Func_Curr( v_po_hdr_id, v_assessable_value, v_curr, v_curr_conv_factor );

1696: );
1697: IF NVL( v_assessable_value, 0 ) > 0 THEN
1698: -- The Assessable value is greater than 0
1699: v_assessable_value := v_assessable_value * v_qty;
1700: jai_po_cmn_pkg.Ja_In_Po_Func_Curr( v_po_hdr_id, v_assessable_value, v_curr, v_curr_conv_factor );
1701: ELSE
1702: v_assessable_value := v_price*v_qty;
1703: END IF;
1704:

Line 1720: jai_po_cmn_pkg.Ja_In_Po_Func_Curr( v_po_hdr_id, ln_vat_assess_value, v_curr, v_curr_conv_factor );

1716:
1717:
1718: IF ln_vat_assess_value <> v_price THEN
1719: ln_vat_assess_value := ln_vat_assess_value * v_qty ;
1720: jai_po_cmn_pkg.Ja_In_Po_Func_Curr( v_po_hdr_id, ln_vat_assess_value, v_curr, v_curr_conv_factor );
1721: ELSE
1722: ln_vat_assess_value := ln_vat_assess_value * v_qty ;
1723: END IF ;
1724:

Line 1744: jai_po_cmn_pkg.Ja_In_Po_Func_Curr( v_po_hdr_id, ln_gst_assessable_value, v_curr, v_curr_conv_factor );

1740:
1741:
1742: IF ln_gst_assessable_value <> v_price THEN
1743: ln_gst_assessable_value := ln_gst_assessable_value * v_qty ;
1744: jai_po_cmn_pkg.Ja_In_Po_Func_Curr( v_po_hdr_id, ln_gst_assessable_value, v_curr, v_curr_conv_factor );
1745: ELSE
1746: ln_gst_assessable_value := ln_gst_assessable_value * v_qty ;
1747: END IF ;
1748: */

Line 1752: jai_po_cmn_pkg.Ja_In_Po_Func_Curr( v_po_hdr_id, dummy, v_curr, v_curr_conv_factor );

1748: */
1749: ---------------------------------------------------------------------------
1750: -- Added by Jia for GST Bug#10043656 on 2010/09/10, End
1751:
1752: jai_po_cmn_pkg.Ja_In_Po_Func_Curr( v_po_hdr_id, dummy, v_curr, v_curr_conv_factor );
1753:
1754: -- Start, Vijay Shankar for Bug #3184673
1755: IF v_old_qty IS NULL OR v_old_qty = 0 THEN
1756: v_old_qty := 1;

Line 1833: jai_po_cmn_pkg.process_release_shipment ( v_shipment_type,

1829: END IF;
1830:
1831: IF v_shipment_type IN ( 'SCHEDULED', 'BLANKET' ) THEN
1832:
1833: jai_po_cmn_pkg.process_release_shipment ( v_shipment_type,
1834: v_src_ship_id,
1835: v_line_loc_id,
1836: v_po_line_id,
1837: v_po_hdr_id,

Line 1852: jai_po_cmn_pkg.insert_line( 'CATALOG', v_line_loc_id, v_po_hdr_id, v_po_line_id, v_cre_dt,

1848:
1849: RETURN;
1850: ELSE
1851:
1852: jai_po_cmn_pkg.insert_line( 'CATALOG', v_line_loc_id, v_po_hdr_id, v_po_line_id, v_cre_dt,
1853: v_cre_by,
1854: v_last_upd_dt,
1855: v_last_upd_by,
1856: v_last_upd_login,