APPS.INV_RCV_STD_INSPECT_APIS dependencies on INV_RCV_STD_INSPECT_APIS

Line 1: PACKAGE BODY inv_rcv_std_inspect_apis AS

1: PACKAGE BODY inv_rcv_std_inspect_apis AS
2: /* $Header: INVSTDIB.pls 120.9.12010000.4 2009/01/07 06:07:09 vssrivat ship $ */
3:
4: /*
5: ** -------------------------------------------------------------------------

Line 21: g_pkg_name CONSTANT VARCHAR2(30) := 'INV_RCV_STD_INSPECT_APIS';

17: **
18: ** Returns:
19: ** --------------------------------------------------------------------------
20: */
21: g_pkg_name CONSTANT VARCHAR2(30) := 'INV_RCV_STD_INSPECT_APIS';
22:
23: g_to_be_inspected CONSTANT NUMBER := 1;
24: g_accept CONSTANT NUMBER := 2;
25: g_reject CONSTANT NUMBER := 3;

Line 4481: return inv_rcv_std_inspect_apis.get_inspection_qty(

4477:
4478: IF (p_type = 'LPN') THEN
4479: --print_debug('Inside LPN...', 4);
4480:
4481: return inv_rcv_std_inspect_apis.get_inspection_qty(
4482: p_type => p_type
4483: , p_lpn_id => p_id1
4484: , p_po_header_id => NULL
4485: , p_po_release_id => NULL

Line 4499: return inv_rcv_std_inspect_apis.get_inspection_qty(

4495:
4496: ELSE IF (p_type = 'RMA') THEN
4497: --print_debug('Inside RMA...', 4);
4498:
4499: return inv_rcv_std_inspect_apis.get_inspection_qty(
4500: p_type => p_type
4501: , p_lpn_id => NULL
4502: , p_po_header_id => NULL
4503: , p_po_release_id => NULL

Line 4519: return inv_rcv_std_inspect_apis.get_inspection_qty(

4515: --print_debug('Inside Intship/Receipt...', 4);
4516:
4517: --print_debug('p_shipment_header_id=p_id1 is ' || to_char(p_id1), 4);
4518:
4519: return inv_rcv_std_inspect_apis.get_inspection_qty(
4520: p_type => p_type
4521: , p_lpn_id => NULL
4522: , p_po_header_id => NULL
4523: , p_po_release_id => NULL

Line 4537: return inv_rcv_std_inspect_apis.get_inspection_qty(

4533:
4534: ELSE IF (p_type = 'PO') THEN
4535: --print_debug('Inside PO...', 4);
4536:
4537: return inv_rcv_std_inspect_apis.get_inspection_qty(
4538: p_type => p_type
4539: , p_lpn_id => NULL
4540: , p_po_header_id => p_id1
4541: , p_po_release_id => p_id2

Line 4854: inv_mobile_helper_functions.sql_error('inv_rcv_std_inspect_apis.obtain_receiving_information', l_progress, SQLCODE);

4850:
4851: exception
4852: when others then
4853: IF SQLCODE IS NOT NULL THEN
4854: inv_mobile_helper_functions.sql_error('inv_rcv_std_inspect_apis.obtain_receiving_information', l_progress, SQLCODE);
4855: END IF;
4856:
4857:
4858:

Line 4941: end inv_rcv_std_inspect_apis;

4937: RETURN l_count;
4938: END is_revision_required;
4939:
4940:
4941: end inv_rcv_std_inspect_apis;