APPS.JAI_PO_OSP_PKG dependencies on JAI_PO_OSP_PKG

Line 1: PACKAGE BODY jai_po_osp_pkg AS

1: PACKAGE BODY jai_po_osp_pkg AS
2: /* $Header: jai_po_osp.plb 120.4.12010000.2 2008/08/10 08:53:49 lgopalsa ship $ */
3:
4: /* --------------------------------------------------------------------------------------
5: Filename:

Line 27: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_po_osp_pkg.ja_in_57F4_process_header';

23: p_vendor_site_id po_vendor_sites_all.vendor_site_id%type,
24: p_called_from varchar2
25: )
26: is
27: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_po_osp_pkg.ja_in_57F4_process_header';
28:
29: lv_called_release VARCHAR2(10);
30: lv_called_po VARCHAR2(10);
31: begin

Line 34: CHANGE HISTORY: FILENAME: jai_po_osp_pkg.sql

30: lv_called_po VARCHAR2(10);
31: begin
32: /*
33: ----------------------------------------------------------------------------------------------------------------------
34: CHANGE HISTORY: FILENAME: jai_po_osp_pkg.sql
35: S.No Date Author and Details
36: ------------------------------------------------------------------------------------------------------------------------
37:
38: 1. 08/03/2005 Bug# 4218628 File Version 116.0 (115.1)

Line 312: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_po_osp_pkg.ja_in_57f4_lines_insert';

308: ln_routing_ctr number;
309: ln_ja_ctr NUMBER;
310: ln_reqmt_op_ctr NUMBER;
311:
312: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_po_osp_pkg.ja_in_57f4_lines_insert';
313:
314: -- Bug 7028169. Added by Lakshmi Gopalsami
315: r_get_po_item_details c_get_item_details%ROWTYPE;
316: r_get_comp_item_details c_get_item_details%ROWTYPE;

Line 1111: p_process_message := 'Error in jai_po_osp_pkg.create_rcv_57f4. Stmt:'||lv_statement_id

1107:
1108: EXCEPTION
1109: WHEN OTHERS THEN
1110: p_process_status := jai_constants.unexpected_error;
1111: p_process_message := 'Error in jai_po_osp_pkg.create_rcv_57f4. Stmt:'||lv_statement_id
1112: ||', MSG:'||SQLERRM;
1113:
1114: END create_rcv_57f4;
1115: /*------------------------------------------------------------------------------------------------------------*/

Line 1283: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_po_osp_pkg.update_57f4_on_receiving';

1279: vQtyRemaining cNumberTable;
1280: v_fun_ret_value NUMBER;
1281: v_quantity_applied NUMBER;
1282:
1283: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_po_osp_pkg.update_57f4_on_receiving';
1284:
1285: /* Bug 7028169. Added by Lakshmi Gopalsami */
1286: CURSOR c_get_item_details(cp_org_id NUMBER, cp_item_id NUMBER) IS
1287: SELECT *

Line 1839: END jai_po_osp_pkg;

1835: app_exception.raise_exception;
1836:
1837: END update_57f4_on_receiving;
1838:
1839: END jai_po_osp_pkg;