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.20.12020000.4 2013/01/30 06:46:33 jianpyu 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 985: p_serial_tbl IN inv_rcv_std_inspect_apis.t_serial_rec_tbl

981: p_attribute13 IN VARCHAR2 DEFAULT NULL,
982: p_attribute14 IN VARCHAR2 DEFAULT NULL,
983: p_attribute15 IN VARCHAR2 DEFAULT NULL,
984: p_secondary_qty IN NUMBER DEFAULT NULL,
985: p_serial_tbl IN inv_rcv_std_inspect_apis.t_serial_rec_tbl
986: )
987: IS
988: l_inventory_item_id NUMBER := p_inventory_item_id;
989: l_organization_id NUMBER := p_organization_id;

Line 3212: --l_serial_tbl inv_rcv_std_inspect_apis.t_serial_rec_tbl;

3208: -- Increased lot size to 80 Char - 3ercy Thomas - B4625329
3209: l_lot_number VARCHAR2 (80);
3210: l_debug NUMBER
3211: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
3212: --l_serial_tbl inv_rcv_std_inspect_apis.t_serial_rec_tbl;
3213: BEGIN
3214: x_return_status := fnd_api.g_ret_sts_success;
3215: SAVEPOINT process_sl_sp;
3216:

Line 6380: return inv_rcv_std_inspect_apis.get_inspection_qty(

6376:
6377: IF (p_type = 'LPN') THEN
6378: --print_debug('Inside LPN...', 4);
6379:
6380: return inv_rcv_std_inspect_apis.get_inspection_qty(
6381: p_type => p_type
6382: , p_lpn_id => p_id1
6383: , p_po_header_id => NULL
6384: , p_po_release_id => NULL

Line 6398: return inv_rcv_std_inspect_apis.get_inspection_qty(

6394:
6395: ELSE IF (p_type = 'RMA') THEN
6396: --print_debug('Inside RMA...', 4);
6397:
6398: return inv_rcv_std_inspect_apis.get_inspection_qty(
6399: p_type => p_type
6400: , p_lpn_id => NULL
6401: , p_po_header_id => NULL
6402: , p_po_release_id => NULL

Line 6418: return inv_rcv_std_inspect_apis.get_inspection_qty(

6414: --print_debug('Inside Intship/Receipt...', 4);
6415:
6416: --print_debug('p_shipment_header_id=p_id1 is ' || to_char(p_id1), 4);
6417:
6418: return inv_rcv_std_inspect_apis.get_inspection_qty(
6419: p_type => p_type
6420: , p_lpn_id => NULL
6421: , p_po_header_id => NULL
6422: , p_po_release_id => NULL

Line 6436: return inv_rcv_std_inspect_apis.get_inspection_qty(

6432:
6433: ELSE IF (p_type = 'PO') THEN
6434: --print_debug('Inside PO...', 4);
6435:
6436: return inv_rcv_std_inspect_apis.get_inspection_qty(
6437: p_type => p_type
6438: , p_lpn_id => NULL
6439: , p_po_header_id => p_id1
6440: , p_po_release_id => p_id2

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

6749:
6750: exception
6751: when others then
6752: IF SQLCODE IS NOT NULL THEN
6753: inv_mobile_helper_functions.sql_error('inv_rcv_std_inspect_apis.obtain_receiving_information', l_progress, SQLCODE);
6754: END IF;
6755:
6756:
6757:

Line 6840: end inv_rcv_std_inspect_apis;

6836: RETURN l_count;
6837: END is_revision_required;
6838:
6839:
6840: end inv_rcv_std_inspect_apis;