1: PACKAGE BODY jai_po_osp_pkg AS
2: /* $Header: jai_po_osp.plb 120.22 2012/05/23 08:22:31 zxin ship $ */
3:
4: /* --------------------------------------------------------------------------------------
5: Filename:
54: p_vendor_site_id po_vendor_sites_all.vendor_site_id%type,
55: p_called_from varchar2
56: )
57: is
58: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_po_osp_pkg.ja_in_57F4_process_header';
59:
60: lv_called_release VARCHAR2(10);
61: lv_called_po VARCHAR2(10);
62: begin
61: lv_called_po VARCHAR2(10);
62: begin
63: /*
64: ----------------------------------------------------------------------------------------------------------------------
65: CHANGE HISTORY: FILENAME: jai_po_osp_pkg.sql
66: S.No Date Author and Details
67: ------------------------------------------------------------------------------------------------------------------------
68:
69: 1. 08/03/2005 Bug# 4218628 File Version 116.0 (115.1)
382:
383: ln_usage_rate number; */
384: /*end bug 9626826 by nprashar */
385:
386: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_po_osp_pkg.ja_in_57f4_lines_insert';
387:
388: -- Bug 7028169. Added by Lakshmi Gopalsami
389: r_get_po_item_details c_get_item_details%ROWTYPE;
390: r_get_comp_item_details c_get_item_details%ROWTYPE;
1230:
1231: EXCEPTION
1232: WHEN OTHERS THEN
1233: p_process_status := jai_constants.unexpected_error;
1234: p_process_message := 'Error in jai_po_osp_pkg.create_rcv_57f4. Stmt:'||lv_statement_id
1235: ||', MSG:'||SQLERRM;
1236:
1237: END create_rcv_57f4;
1238: /*------------------------------------------------------------------------------------------------------------*/
1428: vQtyRemaining cNumberTable;
1429: v_fun_ret_value NUMBER;
1430: v_quantity_applied NUMBER;
1431:
1432: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_po_osp_pkg.update_57f4_on_receiving';
1433:
1434: /* Bug 7028169. Added by Lakshmi Gopalsami */
1435: CURSOR c_get_item_details(cp_org_id NUMBER, cp_item_id NUMBER) IS
1436: SELECT *
2128: app_exception.raise_exception;
2129:
2130: END update_57f4_on_receiving;
2131:
2132: END jai_po_osp_pkg;