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 21: Used Autonomous transaction as po_line_locations_all needs to be queried

17:
18: /*
19: Bug 8586635 - Added the procedure to get the quantity from the parent Shipment
20: line to split the taxes in the child lines
21: Used Autonomous transaction as po_line_locations_all needs to be queried
22: */
23: PROCEDURE ja_in_po_get_lineloc_p
24: (
25: p_line_loc_id IN NUMBER,

Line 31: from po_line_locations_all

27: ) IS
28: PRAGMA AUTONOMOUS_TRANSACTION;
29: BEGIN
30: select quantity into p_prev_quantity
31: from po_line_locations_all
32: where line_location_id = p_line_loc_id;
33: END;
34:
35: /*

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

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

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

442: -- RETURN;
443: -- END IF;
444:
445: -- Start, Vijay Shankar for Bug# 3570189
446: 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
447: pr_new.LINE_LOCATION_ID ,
448: pr_new.PO_HEADER_ID ,
449: pr_new.PO_LINE_ID ,
450: pr_new.QUANTITY ,

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

943: v_exist NUMBER ; --File.Sql.35 Cbabu := 0 ;
944: v_hook_value VARCHAR2(10);/*added by rchandan for paddr elimination*/
945:
946: -- Start of bug 3037284
947: v_quantity_received PO_LINE_LOCATIONS_ALL.QUANTITY_RECEIVED%TYPE ; --File.Sql.35 Cbabu := nvl(pr_new.quantity_received,0) ;
948: v_quantity_cancelled PO_LINE_LOCATIONS_ALL.QUANTITY_CANCELLED%TYPE ; --File.Sql.35 Cbabu := pr_new.quantity_cancelled ;
949: v_style_id po_headers_all.style_id%TYPE;
950:
951: CURSOR rec_get_tax_amount

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

944: v_hook_value VARCHAR2(10);/*added by rchandan for paddr elimination*/
945:
946: -- Start of bug 3037284
947: v_quantity_received PO_LINE_LOCATIONS_ALL.QUANTITY_RECEIVED%TYPE ; --File.Sql.35 Cbabu := nvl(pr_new.quantity_received,0) ;
948: v_quantity_cancelled PO_LINE_LOCATIONS_ALL.QUANTITY_CANCELLED%TYPE ; --File.Sql.35 Cbabu := pr_new.quantity_cancelled ;
949: v_style_id po_headers_all.style_id%TYPE;
950:
951: CURSOR rec_get_tax_amount
952: IS

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

1140: Calculate the tax_amount in the table JAI_PO_LINE_LOCATIONS as a sum of all records
1141: in the table JAI_PO_TAXES for that line_locations_id excluding 'TDS'
1142: type of taxes.
1143: The total amount in JAI_PO_LINE_LOCATIONS is calculated as
1144: (po_line_locations_all.quantity_received * po_line_locations_all.price_override)
1145: +
1146: sum of all taxes from JAI_PO_TAXES for that line_location_id .
1147:
1148: 2 15/10/2003 Vijay Shankar for Bug #3184673, File version 618.1

Line 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

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
1291: pr_new.LINE_LOCATION_ID ,
1292: pr_new.PO_HEADER_ID ,
1293: pr_new.PO_LINE_ID ,
1294: pr_new.QUANTITY ,

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

1483:
1484: ELSIF nvl(v_quantity_cancelled,-9999) < nvl(v_qty,0) THEN
1485: /*
1486: Indicating that a partial receipt has been made for the line and then the line has been cancelled.
1487: In such a case the cancelled quantity would be lesser than the quantity in table po_line_locations_all.
1488: Now in this scenario update the line and the associated apportioned taxes in the table JAI_PO_LINE_LOCATIONS
1489: and JAI_PO_TAXES
1490: */
1491:

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

1555: IF NOT found THEN
1556: RETURN;
1557: END IF;*//*commented by rchandan for bug#4479131*/
1558: IF v_type_lookup_code IN ( 'RFQ', 'QUOTATION', 'STANDARD', 'PLANNED', 'CONTRACT', 'BLANKET' ) THEN
1559: 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
1560: pr_new.LINE_LOCATION_ID ,
1561: pr_new.PO_HEADER_ID ,
1562: pr_new.PO_LINE_ID ,
1563: pr_new.QUANTITY ,