APPS.OE_PROFILE dependencies on OE_SYS_PARAMETERS

Line 87: VAL := OE_Sys_Parameters.VALUE(param_name => 'MASTER_ORGANIZATION_ID');

83: BEGIN
84:
85: IF UPPER(NAME) = 'SO_ORGANIZATION_ID' or UPPER(NAME) = 'OE_ORGANIZATION_ID' THEN
86:
87: VAL := OE_Sys_Parameters.VALUE(param_name => 'MASTER_ORGANIZATION_ID');
88:
89: ELSIF UPPER(NAME) = 'SO_SET_OF_BOOKS_ID' OR UPPER(NAME) = 'OE_SET_OF_BOOKS_ID' THEN
90:
91: VAL := OE_Sys_Parameters.VALUE(param_name => 'SET_OF_BOOKS_ID');

Line 91: VAL := OE_Sys_Parameters.VALUE(param_name => 'SET_OF_BOOKS_ID');

87: VAL := OE_Sys_Parameters.VALUE(param_name => 'MASTER_ORGANIZATION_ID');
88:
89: ELSIF UPPER(NAME) = 'SO_SET_OF_BOOKS_ID' OR UPPER(NAME) = 'OE_SET_OF_BOOKS_ID' THEN
90:
91: VAL := OE_Sys_Parameters.VALUE(param_name => 'SET_OF_BOOKS_ID');
92:
93: ELSE
94:
95: l_active_profile := Get_Active_Profile_Name(NAME);

Line 115: l_profile_value := OE_Sys_Parameters.VALUE(param_name => 'MASTER_ORGANIZATION_ID', p_org_id => ORG_ID);

111: BEGIN
112:
113: IF UPPER(NAME) = 'SO_ORGANIZATION_ID' or UPPER(NAME) = 'OE_ORGANIZATION_ID' THEN
114:
115: l_profile_value := OE_Sys_Parameters.VALUE(param_name => 'MASTER_ORGANIZATION_ID', p_org_id => ORG_ID);
116:
117: ELSIF UPPER(NAME) = 'SO_SET_OF_BOOKS_ID' OR UPPER(NAME) = 'OE_SET_OF_BOOKS_ID' THEN
118: l_profile_value := OE_Sys_Parameters.VALUE(param_name => 'SET_OF_BOOKS_ID', p_org_id => ORG_ID);
119:

Line 118: l_profile_value := OE_Sys_Parameters.VALUE(param_name => 'SET_OF_BOOKS_ID', p_org_id => ORG_ID);

114:
115: l_profile_value := OE_Sys_Parameters.VALUE(param_name => 'MASTER_ORGANIZATION_ID', p_org_id => ORG_ID);
116:
117: ELSIF UPPER(NAME) = 'SO_SET_OF_BOOKS_ID' OR UPPER(NAME) = 'OE_SET_OF_BOOKS_ID' THEN
118: l_profile_value := OE_Sys_Parameters.VALUE(param_name => 'SET_OF_BOOKS_ID', p_org_id => ORG_ID);
119:
120: ELSE
121:
122: l_active_profile := Get_Active_Profile_Name(NAME);

Line 145: l_profile_value := OE_Sys_Parameters.VALUE_WNPS(param_name => 'MASTER_ORGANIZATION_ID', p_org_id => ORG_ID);

141: BEGIN
142:
143: IF UPPER(NAME) = 'SO_ORGANIZATION_ID' or UPPER(NAME) = 'OE_ORGANIZATION_ID' THEN
144:
145: l_profile_value := OE_Sys_Parameters.VALUE_WNPS(param_name => 'MASTER_ORGANIZATION_ID', p_org_id => ORG_ID);
146:
147: ELSIF UPPER(NAME) = 'SO_SET_OF_BOOKS_ID' OR UPPER(NAME) = 'OE_SET_OF_BOOKS_ID' THEN
148: l_profile_value := OE_Sys_Parameters.VALUE_WNPS(param_name => 'SET_OF_BOOKS_ID', p_org_id => ORG_ID);
149:

Line 148: l_profile_value := OE_Sys_Parameters.VALUE_WNPS(param_name => 'SET_OF_BOOKS_ID', p_org_id => ORG_ID);

144:
145: l_profile_value := OE_Sys_Parameters.VALUE_WNPS(param_name => 'MASTER_ORGANIZATION_ID', p_org_id => ORG_ID);
146:
147: ELSIF UPPER(NAME) = 'SO_SET_OF_BOOKS_ID' OR UPPER(NAME) = 'OE_SET_OF_BOOKS_ID' THEN
148: l_profile_value := OE_Sys_Parameters.VALUE_WNPS(param_name => 'SET_OF_BOOKS_ID', p_org_id => ORG_ID);
149:
150: ELSE
151: l_active_profile := Get_Active_Profile_Name(NAME);
152:

Line 177: l_profile_value := OE_Sys_Parameters.VALUE(

173: BEGIN
174:
175: IF UPPER(NAME) = 'SO_ORGANIZATION_ID' or UPPER(NAME) = 'OE_ORGANIZATION_ID' THEN
176: IF (USER_ID IS NULL AND RESPONSIBILITY_ID IS NULL AND APPLICATION_ID IS NULL) THEN
177: l_profile_value := OE_Sys_Parameters.VALUE(
178: param_name => 'MASTER_ORGANIZATION_ID');
179: -- removing ELSE clause as part of MOAC project as we should not be looking at the ORG_ID profile.
180: -- this can be taken out NOCOPY /* file.sql.39 change */ completely as no caller is populating the user/app/resp when calling this procedure
181: /*

Line 185: l_profile_value := OE_Sys_Parameters.VALUE(

181: /*
182: ELSE
183: l_org_id := TO_NUMBER(FND_PROFILE.Value_Specific('ORG_ID',
184: USER_ID, RESPONSIBILITY_ID, APPLICATION_ID));
185: l_profile_value := OE_Sys_Parameters.VALUE(
186: param_name => 'MASTER_ORGANIZATION_ID',
187: p_org_id => l_org_id);
188: */
189: END IF;

Line 193: l_profile_value := OE_Sys_Parameters.VALUE(

189: END IF;
190:
191: ELSIF UPPER(NAME) = 'SO_SET_OF_BOOKS_ID' OR UPPER(NAME) = 'OE_SET_OF_BOOKS_ID' THEN
192: IF (USER_ID IS NULL AND RESPONSIBILITY_ID IS NULL AND APPLICATION_ID IS NULL) THEN
193: l_profile_value := OE_Sys_Parameters.VALUE(
194: param_name => 'SET_OF_BOOKS_ID');
195: -- removing ELSE clause as part of MOAC project as we should not be looking at the ORG_ID profile.
196: -- this can be taken out NOCOPY /* file.sql.39 change */ completely as no caller is populating the user/app/resp when calling this procedure
197: /*

Line 201: l_profile_value := OE_Sys_Parameters.VALUE(

197: /*
198: ELSE
199: l_org_id := TO_NUMBER(FND_PROFILE.Value_Specific('ORG_ID',
200: USER_ID, RESPONSIBILITY_ID, APPLICATION_ID));
201: l_profile_value := OE_Sys_Parameters.VALUE(
202: param_name => 'SET_OF_BOOKS_ID',
203: p_org_id => l_org_id);
204: */
205: END IF;