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 PO_LINE_LOCATIONS_ALL

Line 290: jai_cmn_hook_pkg.Ja_In_po_line_locations_all procedure. Also Locator related code is removed except for RELEASES

286: Hence this is a certain dependency issue and should be carefully handled
287:
288: 4 14/04/2004 Vijay Shankar for bugs# 3570189, Version : 619.1
289: PO Hook Functionality is made compatible with 11.5.3 Base Applications by removing last 12 params in call too
290: jai_cmn_hook_pkg.Ja_In_po_line_locations_all procedure. Also Locator related code is removed except for RELEASES
291: as defaultation happens whether the user navigated from localization form or not.
292: Tax defaultation is driven by jai_cmn_hook_pkg. By default taxes are defaulted for all PO's created in
293: Indian OU's (INR as Functional Currency)
294:

Line 395: 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

391: -- RETURN;
392: -- END IF;
393:
394: -- Start, Vijay Shankar for Bug# 3570189
395: 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
396: pr_new.LINE_LOCATION_ID ,
397: pr_new.PO_HEADER_ID ,
398: pr_new.PO_LINE_ID ,
399: pr_new.QUANTITY ,

Line 796: v_quantity_received PO_LINE_LOCATIONS_ALL.QUANTITY_RECEIVED%TYPE ; --File.Sql.35 Cbabu := nvl(pr_new.quantity_received,0) ;

792: v_exist NUMBER ; --File.Sql.35 Cbabu := 0 ;
793: v_hook_value VARCHAR2(10);/*added by rchandan for paddr elimination*/
794:
795: -- Start of bug 3037284
796: v_quantity_received PO_LINE_LOCATIONS_ALL.QUANTITY_RECEIVED%TYPE ; --File.Sql.35 Cbabu := nvl(pr_new.quantity_received,0) ;
797: v_quantity_cancelled PO_LINE_LOCATIONS_ALL.QUANTITY_CANCELLED%TYPE ; --File.Sql.35 Cbabu := pr_new.quantity_cancelled ;
798: v_style_id po_headers_all.style_id%TYPE;
799:
800: CURSOR rec_get_tax_amount

Line 797: v_quantity_cancelled PO_LINE_LOCATIONS_ALL.QUANTITY_CANCELLED%TYPE ; --File.Sql.35 Cbabu := pr_new.quantity_cancelled ;

793: v_hook_value VARCHAR2(10);/*added by rchandan for paddr elimination*/
794:
795: -- Start of bug 3037284
796: v_quantity_received PO_LINE_LOCATIONS_ALL.QUANTITY_RECEIVED%TYPE ; --File.Sql.35 Cbabu := nvl(pr_new.quantity_received,0) ;
797: v_quantity_cancelled PO_LINE_LOCATIONS_ALL.QUANTITY_CANCELLED%TYPE ; --File.Sql.35 Cbabu := pr_new.quantity_cancelled ;
798: v_style_id po_headers_all.style_id%TYPE;
799:
800: CURSOR rec_get_tax_amount
801: IS

Line 993: (po_line_locations_all.quantity_received * po_line_locations_all.price_override)

989: Calculate the tax_amount in the table JAI_PO_LINE_LOCATIONS as a sum of all records
990: in the table JAI_PO_TAXES for that line_locations_id excluding 'TDS'
991: type of taxes.
992: The total amount in JAI_PO_LINE_LOCATIONS is calculated as
993: (po_line_locations_all.quantity_received * po_line_locations_all.price_override)
994: +
995: sum of all taxes from JAI_PO_TAXES for that line_location_id .
996:
997: 2 15/10/2003 Vijay Shankar for Bug #3184673, File version 618.1

Line 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

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
1129: pr_new.LINE_LOCATION_ID ,
1130: pr_new.PO_HEADER_ID ,
1131: pr_new.PO_LINE_ID ,
1132: pr_new.QUANTITY ,

Line 1325: In such a case the cancelled quantity would be lesser than the quantity in table po_line_locations_all.

1321:
1322: ELSIF nvl(v_quantity_cancelled,-9999) < nvl(v_qty,0) THEN
1323: /*
1324: Indicating that a partial receipt has been made for the line and then the line has been cancelled.
1325: In such a case the cancelled quantity would be lesser than the quantity in table po_line_locations_all.
1326: Now in this scenario update the line and the associated apportioned taxes in the table JAI_PO_LINE_LOCATIONS
1327: and JAI_PO_TAXES
1328: */
1329:

Line 1397: 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

1393: IF NOT found THEN
1394: RETURN;
1395: END IF;*//*commented by rchandan for bug#4479131*/
1396: IF v_type_lookup_code IN ( 'RFQ', 'QUOTATION', 'STANDARD', 'PLANNED', 'CONTRACT', 'BLANKET' ) THEN
1397: 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
1398: pr_new.LINE_LOCATION_ID ,
1399: pr_new.PO_HEADER_ID ,
1400: pr_new.PO_LINE_ID ,
1401: pr_new.QUANTITY ,