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 317: 1. Commented rel_found and call to jai_po_cmn_pkg.query_locator_for_release

313: 9 13-Jun-2005 File Version: 116.3
314: Ramananda for bug#4428980. Removal of SQL LITERALs is done
315:
316: 10 06-Jul-2005 rallamse for bug# PADDR Elimination
317: 1. Commented rel_found and call to jai_po_cmn_pkg.query_locator_for_release
318:
319: 11. 08-Jul-2005 Sanjikum for Bug#4483042
320: 1) Added a call to jai_cmn_utils_pkg.validate_po_type, to check whether for the current PO
321: IL functionality should work or not.

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

496: END IF;
497: -- End, 3570189
498:
499: -- Commented by Vijay Shankar for bugs# 3570189
500: -- jai_po_cmn_pkg.query_locator_for_release( pr_new.Po_Release_Id, rel_found );
501:
502: OPEN Check_Rfq_Quot_Cur;
503: FETCH Check_Rfq_Quot_Cur INTO v_from_type_lookup_code, v_quot_from_hdr_id, v_type_lookup_code, v_Quot_Class_Code,
504: v_vendor_id, v_vendor_site_id, v_curr, v_ship_loc_id,

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

541: END IF;
542:
543: /* commented by Vijay Shankar for bugs# 3570189
544: IF v_type_lookup_code = 'QUOTATION' THEN
545: jai_po_cmn_pkg.query_locator_for_line( v_po_hdr_id, 'JAINRFQQ', found );
546: IF NOT found AND y IS NULL THEN
547: RETURN;
548: END IF;
549: END IF;

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

638: END IF;
639:
640: IF v_type_lookup_code = 'QUOTATION' THEN
641:
642: jai_po_cmn_pkg.insert_line( 'CATALOG', v_line_loc_id, v_po_hdr_id, v_po_line_id, v_cre_dt,
643: v_cre_by, v_last_upd_dt, v_last_upd_by, v_last_upd_login, 'I' , v_service_type_code -- 5879769, brathod
644: );
645:
646: -- added by Vijay Shankar for Bug# 3184418

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

671: END IF;
672:
673: /* commented by Vijay Shankar for bugs# 3570189
674: IF v_type_lookup_code = 'RFQ' THEN
675: jai_po_cmn_pkg.query_locator_for_line( v_po_hdr_id, 'JAINRFQQ', found );
676: success := 1;
677:
678: ELSIF v_type_lookup_code IN ( 'STANDARD', 'PLANNED', 'CONTRACT', 'BLANKET' ) THEN
679: jai_po_cmn_pkg.query_locator_for_line( v_po_hdr_id, 'JAINPO', found );

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

675: jai_po_cmn_pkg.query_locator_for_line( v_po_hdr_id, 'JAINRFQQ', found );
676: success := 1;
677:
678: ELSIF v_type_lookup_code IN ( 'STANDARD', 'PLANNED', 'CONTRACT', 'BLANKET' ) THEN
679: jai_po_cmn_pkg.query_locator_for_line( v_po_hdr_id, 'JAINPO', found );
680: success := 1;
681: END IF;
682:
683: IF NOT found AND v_type_lookup_code <> 'RFQ' THEN

Line 694: 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,

690: success := 1;
691:
692: IF v_type_lookup_code <> 'QUOTATION' THEN
693:
694: 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,
695: v_cre_by, v_last_upd_dt, v_last_upd_by, v_last_upd_login, 'I' ,v_service_type_code -- 5879769, brathod
696: );
697:
698: END IF;

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

722:
723: -- Vijay Shankar for Bug# 3570189
724:
725: /* Commented rallamse bug#4479131 PADDR Elimination
726: jai_po_cmn_pkg.query_locator_for_release( pr_new.Po_Release_Id, rel_found );
727: */
728:
729: jai_po_cmn_pkg.process_release_shipment (
730: v_shipment_type, v_src_ship_id, v_line_loc_id, v_po_line_id, v_po_hdr_id,

Line 729: jai_po_cmn_pkg.process_release_shipment (

725: /* Commented rallamse bug#4479131 PADDR Elimination
726: jai_po_cmn_pkg.query_locator_for_release( pr_new.Po_Release_Id, rel_found );
727: */
728:
729: jai_po_cmn_pkg.process_release_shipment (
730: v_shipment_type, v_src_ship_id, v_line_loc_id, v_po_line_id, v_po_hdr_id,
731: v_qty, v_po_rel_id, v_cre_dt, v_cre_by,
732: v_last_upd_dt, v_last_upd_by, v_last_upd_login, 'I'
733: );

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

1120: -- END IF;
1121:
1122: -- POC for Releases ONLY
1123:
1124: /* jai_po_cmn_pkg.query_locator_for_release( pr_new.Po_Release_Id, rel_found );*//*commented by rchandan for bug#4479131*/
1125:
1126: /*added by rchandan for bug#4479131*/
1127:
1128: 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 1388: jai_po_cmn_pkg.query_locator_for_line( v_po_hdr_id, 'JAINRFQQ', found );

1384:
1385: IF v_shipment_type NOT IN ( 'SCHEDULED', 'BLANKET' ) THEN
1386:
1387: /*IF v_type_lookup_code IN ( 'RFQ', 'QUOTATION' ) THEN
1388: jai_po_cmn_pkg.query_locator_for_line( v_po_hdr_id, 'JAINRFQQ', found );
1389: ELSIF v_type_lookup_code IN ( 'STANDARD', 'PLANNED', 'CONTRACT', 'BLANKET' ) and v_exist <> 1 THEN
1390: jai_po_cmn_pkg.query_locator_for_line( v_po_hdr_id, 'JAINPO', found );
1391: END IF;
1392:

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

1386:
1387: /*IF v_type_lookup_code IN ( 'RFQ', 'QUOTATION' ) THEN
1388: jai_po_cmn_pkg.query_locator_for_line( v_po_hdr_id, 'JAINRFQQ', found );
1389: ELSIF v_type_lookup_code IN ( 'STANDARD', 'PLANNED', 'CONTRACT', 'BLANKET' ) and v_exist <> 1 THEN
1390: jai_po_cmn_pkg.query_locator_for_line( v_po_hdr_id, 'JAINPO', found );
1391: END IF;
1392:
1393: IF NOT found THEN
1394: RETURN;

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

1534: );
1535: IF NVL( v_assessable_value, 0 ) > 0 THEN
1536: -- The Assessable value is greater than 0
1537: v_assessable_value := v_assessable_value * v_qty;
1538: jai_po_cmn_pkg.Ja_In_Po_Func_Curr( v_po_hdr_id, v_assessable_value, v_curr, v_curr_conv_factor );
1539: ELSE
1540: v_assessable_value := v_price*v_qty;
1541: END IF;
1542:

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

1554:
1555:
1556: IF ln_vat_assess_value <> v_price THEN
1557: ln_vat_assess_value := ln_vat_assess_value * v_qty ;
1558: jai_po_cmn_pkg.Ja_In_Po_Func_Curr( v_po_hdr_id, ln_vat_assess_value, v_curr, v_curr_conv_factor );
1559: ELSE
1560: ln_vat_assess_value := ln_vat_assess_value * v_qty ;
1561: END IF ;
1562:

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

1561: END IF ;
1562:
1563: --ended, Harshita for bug #4245062
1564:
1565: jai_po_cmn_pkg.Ja_In_Po_Func_Curr( v_po_hdr_id, dummy, v_curr, v_curr_conv_factor );
1566:
1567:
1568:
1569:

Line 1646: jai_po_cmn_pkg.process_release_shipment ( v_shipment_type,

1642: END IF;
1643:
1644: IF v_shipment_type IN ( 'SCHEDULED', 'BLANKET' ) THEN
1645:
1646: jai_po_cmn_pkg.process_release_shipment ( v_shipment_type,
1647: v_src_ship_id,
1648: v_line_loc_id,
1649: v_po_line_id,
1650: v_po_hdr_id,

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

1661:
1662: RETURN;
1663: ELSE
1664:
1665: jai_po_cmn_pkg.insert_line( 'CATALOG', v_line_loc_id, v_po_hdr_id, v_po_line_id, v_cre_dt,
1666: v_cre_by,
1667: v_last_upd_dt,
1668: v_last_upd_by,
1669: v_last_upd_login,