APPS.JAI_PO_CMN_PKG dependencies on JAI_PO_CMN_PKG

Line 1: PACKAGE BODY jai_po_cmn_pkg AS

1: PACKAGE BODY jai_po_cmn_pkg AS
2: /* $Header: jai_po_cmn.plb 120.7.12010000.2 2009/03/03 12:47:39 mbremkum ship $ */
3: v_conv_rate NUMBER;
4: v_inv_org_id NUMBER;
5:

Line 257: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_po_cmn_pkg.insert_line';

253: CURSOR Fetch_Focus_Id IS SELECT JAI_PO_LINE_LOCATIONS_S.NEXTVAL
254: FROM Dual;
255:
256: ------------------------------>
257: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_po_cmn_pkg.insert_line';
258: BEGIN
259:
260: OPEN Fetch_Focus_Id;
261: FETCH Fetch_Focus_Id INTO v_seq_val;

Line 322: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_po_cmn_pkg.ja_in_po_get_func_curr';

318: * Get_Func_Curr_Cur and implemented caching logic
319: * for getting SOB and SOB curr.
320: */
321:
322: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_po_cmn_pkg.ja_in_po_get_func_curr';
323:
324: /* Bug 5243532. Added by Lakshmi Gopalsami
325: * Defined variable for implementing caching logic.
326: */

Line 406: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_po_cmn_pkg.ja_in_po_assessable_val_conv';

402: SELECT Rate, Rate_Date, Rate_Type
403: FROM Po_Headers_All
404: WHERE Po_Header_Id = p_po_header_id;
405:
406: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_po_cmn_pkg.ja_in_po_assessable_val_conv';
407:
408: /* Bug 5243532. Added by Lakshmi Gopalsami
409: * Defined variable for implementing caching logic.
410: */

Line 468: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_po_cmn_pkg.ja_in_po_func_curr';

464: p_rate IN NUMBER DEFAULT NULL,
465: p_rate_date IN DATE DEFAULT NULL,
466: p_rate_type IN VARCHAR2 DEFAULT NULL
467: ) IS
468: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_po_cmn_pkg.ja_in_po_func_curr';
469: BEGIN
470:
471: p_assessable_val := jai_po_cmn_pkg.ja_in_po_assessable_val_conv
472: ( p_po_header_id, p_assessable_val,

Line 471: p_assessable_val := jai_po_cmn_pkg.ja_in_po_assessable_val_conv

467: ) IS
468: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_po_cmn_pkg.ja_in_po_func_curr';
469: BEGIN
470:
471: p_assessable_val := jai_po_cmn_pkg.ja_in_po_assessable_val_conv
472: ( p_po_header_id, p_assessable_val,
473: jai_po_cmn_pkg.ja_in_po_get_func_curr( p_po_header_id ),
474: p_doc_curr
475: );

Line 473: jai_po_cmn_pkg.ja_in_po_get_func_curr( p_po_header_id ),

469: BEGIN
470:
471: p_assessable_val := jai_po_cmn_pkg.ja_in_po_assessable_val_conv
472: ( p_po_header_id, p_assessable_val,
473: jai_po_cmn_pkg.ja_in_po_get_func_curr( p_po_header_id ),
474: p_doc_curr
475: );
476: p_conv_rate := v_conv_rate;
477: EXCEPTION

Line 541: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_po_cmn_pkg.locate_source_line';

537: SELECT COUNT( * )
538: FROM Po_Line_Locations_All
539: WHERE Po_Line_Id = v_po_line_id;
540:
541: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_po_cmn_pkg.locate_source_line';
542:
543: BEGIN
544:
545: /*----------------------------------------------------------------------------------------------------------

Line 693: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_po_cmn_pkg.process_release_shipment';

689: FROM JAI_PO_LINE_LOCATIONS
690: WHERE line_location_id = p_line_location_id;
691: -- End, cbabu for EnhancementBug# 2427465
692:
693: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_po_cmn_pkg.process_release_shipment';
694:
695: BEGIN
696: /*-----------------------------------------------------------------------------------------------------------------------
697: CHANGE HISTORY: FILENAME: ja_in_po_releases_p.sql

Line 843: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_po_cmn_pkg.get_functional_curr';

839: * and implemented caching logic
840: * Removed the unused cursor Fetch_SET_Of_Books_Id_Cur
841: */
842:
843: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_po_cmn_pkg.get_functional_curr';
844: /* Bug 5243532. Added by Lakshmi Gopalsami
845: * Defined variable for implementing caching logic.
846: */
847: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;

Line 894: END jai_po_cmn_pkg;

890: END get_functional_curr;
891:
892: /*------------------------------------------------------------------------------------------------------------*/
893:
894: END jai_po_cmn_pkg;