APPS.JAI_RCV_UTILS_PKG dependencies on JAI_RCV_UTILS_PKG

Line 1: PACKAGE BODY jai_rcv_utils_pkg AS

1: PACKAGE BODY jai_rcv_utils_pkg AS
2: /* $Header: jai_rcv_utils.plb 120.2 2006/05/26 11:58:32 lgopalsa ship $ */
3:
4: /* --------------------------------------------------------------------------------------
5: Filename:

Line 29: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_rcv_utils_pkg.get_orgn_type_flags';

25: p_subinventory varchar2)
26: RETURN VARCHAR2 IS
27: v_rg_location_id number;
28: v_subinv varchar2(3);
29: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_rcv_utils_pkg.get_orgn_type_flags';
30: BEGIN
31:
32: /*----------------------------------------------------------------------------------------------------------------------
33: FILENAME: get_orgn_type_flags.sql

Line 46: jai_rcv_utils_pkg.get_rg1_location (p_location_id,

42: 3 characters. Hence the call to this function went into
43: a Numeric or Value Error. Hence changed this to NN.
44:
45: */
46: jai_rcv_utils_pkg.get_rg1_location (p_location_id,
47: p_organization_id,
48: p_subinventory,
49: v_rg_location_id);
50: For loc_rec IN (SELECT manufacturing,

Line 197: END jai_rcv_utils_pkg;

193:
194:
195:
196:
197: END jai_rcv_utils_pkg;