APPS.JL_GLOBE_UTIL_PKG dependencies on PO_SYSTEM_PARAMETERS

Line 52: FROM po_system_parameters

48: ELSE
49: BEGIN
50: SELECT global_attribute1
51: INTO l_trx_reason_code
52: FROM po_system_parameters
53: WHERE ROWNUM = 1;
54: EXCEPTION
55: WHEN NO_DATA_FOUND
56: THEN

Line 97: -- Determine which organization to use from po system parameters

93:
94: --
95: -- get transaction reason code from mtl system items if
96: -- item is known.
97: -- Determine which organization to use from po system parameters
98: -- and then fetch transaction reason accordingly.
99: --
100: IF p_item_id IS NOT NULL
101: THEN

Line 104: FROM po_system_parameters_all

100: IF p_item_id IS NOT NULL
101: THEN
102: SELECT global_attribute3
103: INTO l_trx_reason_def_rule
104: FROM po_system_parameters_all
105: WHERE org_id = p_org_id;
106:
107: IF NVL (l_trx_reason_def_rule, 'MASTER INVENTORY ORGANIZATION') =
108: 'INVENTORY ORGANIZATION'

Line 175: -- PO system parameters

171: -- p_item_id is NULL or
172: -- p_item_id is not NULL but trx reason code is
173: -- not available for Local/Master org
174: -- need to get trx reason code from
175: -- PO system parameters
176: --
177: SELECT global_attribute1
178: INTO l_txn_reason_code
179: FROM po_system_parameters_all

Line 179: FROM po_system_parameters_all

175: -- PO system parameters
176: --
177: SELECT global_attribute1
178: INTO l_txn_reason_code
179: FROM po_system_parameters_all
180: WHERE org_id = p_org_id;
181:
182: RETURN l_txn_reason_code;
183: DEBUG ('End populate_icx_trx_reason_code');