DBA Data[Home] [Help]

APPS.JE_ZZ_SYS_OPTIONS_PKG dependencies on AP_SYSTEM_PARAMETERS_ALL

Line 14: x_pymt_sepr ap_system_parameters_all.global_attribute1%type;

10: (
11: p_org_id IN NUMBER
12: ) RETURN VARCHAR2 IS
13:
14: x_pymt_sepr ap_system_parameters_all.global_attribute1%type;
15:
16: BEGIN
17: /* Y = Yes , N = No */
18: BEGIN

Line 21: From ap_system_parameters_all

17: /* Y = Yes , N = No */
18: BEGIN
19: Select global_attribute1
20: Into x_pymt_sepr
21: From ap_system_parameters_all
22: Where nvl(org_id,-99) = nvl(p_org_id,-99);
23: Exception
24: when others THEN
25: x_pymt_sepr := NULL;

Line 41: x_exempt_ttag ap_system_parameters_all.global_attribute1%type;

37: (
38: p_org_id IN NUMBER
39: ) RETURN VARCHAR2 IS
40:
41: x_exempt_ttag ap_system_parameters_all.global_attribute1%type;
42:
43: BEGIN
44:
45: BEGIN

Line 49: From ap_system_parameters_all

45: BEGIN
46:
47: Select global_attribute1
48: Into x_exempt_ttag
49: From ap_system_parameters_all
50: Where nvl(org_id,-99) = nvl(p_org_id,-99);
51: Exception
52: when others THEN
53: x_exempt_ttag := NULL;