DBA Data[Home] [Help]

APPS.JL_ZZ_SYS_OPTIONS_PKG dependencies on AP_SYSTEM_PARAMETERS_ALL

Line 52: x_payment_action ap_system_parameters_all.global_attribute6%type;

48: (
49: p_org_id IN NUMBER
50: ) RETURN VARCHAR2 IS
51:
52: x_payment_action ap_system_parameters_all.global_attribute6%type;
53:
54: BEGIN
55:
56: BEGIN

Line 61: From ap_system_parameters_all

57:
58: /* 1-Anticipate; 2-Postpone; 3-Change Manually (previously Keep) */
59: Select global_attribute6
60: Into x_payment_action
61: From ap_system_parameters_all
62: Where nvl(org_id,-99) = nvl(p_org_id,-99);
63: Exception
64: when others THEN
65: x_payment_action := NULL;

Line 112: x_payment_location ap_system_parameters_all.global_attribute7%type;

108: (
109: p_org_id IN NUMBER
110: ) RETURN VARCHAR2 IS
111:
112: x_payment_location ap_system_parameters_all.global_attribute7%type;
113:
114: BEGIN
115:
116: BEGIN

Line 121: From ap_system_parameters_all

117:
118: /* 1-Company; 2-Supplier; 3-Customer */
119: Select global_attribute7
120: Into x_payment_location
121: From ap_system_parameters_all
122: Where nvl(org_id,-99) = nvl(p_org_id,-99);
123: Exception
124: when others THEN
125: x_payment_location := NULL;

Line 190: x_change_date_automatically ap_system_parameters_all.global_attribute8%type;

186: (
187: p_org_id IN NUMBER
188: ) RETURN VARCHAR2 IS
189:
190: x_change_date_automatically ap_system_parameters_all.global_attribute8%type;
191:
192: BEGIN
193:
194: BEGIN

Line 199: From ap_system_parameters_all

195:
196: /* Y-Yes; N-No */
197: Select global_attribute8
198: Into x_change_date_automatically
199: From ap_system_parameters_all
200: Where nvl(org_id,-99) = nvl(p_org_id,-99);
201: Exception
202: when others THEN
203: x_change_date_automatically := NULL;