eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_SBCR_DT_PKG dependencies on STANDARD

Line 251: l_sbcr_size_standard_col_name VARCHAR2(30);

247: END get_prev_acqs_history;
248:
249: FUNCTION get_sbss_employees_size(p_contract_id NUMBER) RETURN VARCHAR2 IS
250:
251: l_sbcr_size_standard_col_name VARCHAR2(30);
252: l_sbcr_size_standard VARCHAR2(150);
253: l_sbcr_size_standard_desc VARCHAR2(32567) := NULL;
254: l_attr_group_id NUMBER;
255: l_attr_id NUMBER;

Line 252: l_sbcr_size_standard VARCHAR2(150);

248:
249: FUNCTION get_sbss_employees_size(p_contract_id NUMBER) RETURN VARCHAR2 IS
250:
251: l_sbcr_size_standard_col_name VARCHAR2(30);
252: l_sbcr_size_standard VARCHAR2(150);
253: l_sbcr_size_standard_desc VARCHAR2(32567) := NULL;
254: l_attr_group_id NUMBER;
255: l_attr_id NUMBER;
256: l_attr_data_type VARCHAR2(30);

Line 253: l_sbcr_size_standard_desc VARCHAR2(32567) := NULL;

249: FUNCTION get_sbss_employees_size(p_contract_id NUMBER) RETURN VARCHAR2 IS
250:
251: l_sbcr_size_standard_col_name VARCHAR2(30);
252: l_sbcr_size_standard VARCHAR2(150);
253: l_sbcr_size_standard_desc VARCHAR2(32567) := NULL;
254: l_attr_group_id NUMBER;
255: l_attr_id NUMBER;
256: l_attr_data_type VARCHAR2(30);
257: l_sql VARCHAR2(1000);

Line 263: INTO l_sbcr_size_standard_col_name, l_attr_id, l_attr_data_type

259:
260: BEGIN
261:
262: SELECT fcu.application_column_name, efdfce.attr_id, efdfce.data_type
263: INTO l_sbcr_size_standard_col_name, l_attr_id, l_attr_data_type
264: FROM fnd_descr_flex_column_usages fcu,
265: ego_fnd_df_col_usgs_ext efdfce
266: WHERE fcu.descriptive_flexfield_name = 'OKC_REP_CONTRACT_HDR_EXT_ATTRS'
267: AND fcu.descriptive_flex_context_code = 'SBCR_PROC_INFO_AG'

Line 268: AND fcu.end_user_column_name = 'SBCR_SBSS_SIZE_STANDARD'

264: FROM fnd_descr_flex_column_usages fcu,
265: ego_fnd_df_col_usgs_ext efdfce
266: WHERE fcu.descriptive_flexfield_name = 'OKC_REP_CONTRACT_HDR_EXT_ATTRS'
267: AND fcu.descriptive_flex_context_code = 'SBCR_PROC_INFO_AG'
268: AND fcu.end_user_column_name = 'SBCR_SBSS_SIZE_STANDARD'
269: AND efdfce.descriptive_flexfield_name = fcu.descriptive_flexfield_name
270: AND efdfce.descriptive_flex_context_code = fcu.descriptive_flex_context_code
271: AND efdfce.application_column_name = fcu.application_column_name;
272:

Line 278: l_sql := 'SELECT ' || l_sbcr_size_standard_col_name ||

274: FROM ego_fnd_dsc_flx_ctx_ext
275: WHERE descriptive_flexfield_name = 'OKC_REP_CONTRACT_HDR_EXT_ATTRS'
276: AND descriptive_flex_context_code = 'SBCR_PROC_INFO_AG';
277:
278: l_sql := 'SELECT ' || l_sbcr_size_standard_col_name ||
279: ' FROM okc_rep_contracts_all_ext_b' ||
280: ' WHERE contract_id = ' || p_contract_id ||
281: ' AND attr_group_id = ' || l_attr_group_id ||
282: ' AND ' || l_sbcr_size_standard_col_name || ' like ''%EMP%''';

Line 282: ' AND ' || l_sbcr_size_standard_col_name || ' like ''%EMP%''';

278: l_sql := 'SELECT ' || l_sbcr_size_standard_col_name ||
279: ' FROM okc_rep_contracts_all_ext_b' ||
280: ' WHERE contract_id = ' || p_contract_id ||
281: ' AND attr_group_id = ' || l_attr_group_id ||
282: ' AND ' || l_sbcr_size_standard_col_name || ' like ''%EMP%''';
283:
284: EXECUTE IMMEDIATE l_sql INTO l_sbcr_size_standard;
285:
286: l_sql_desc := get_uda_attr_desc_sql(p_contract_id,

Line 284: EXECUTE IMMEDIATE l_sql INTO l_sbcr_size_standard;

280: ' WHERE contract_id = ' || p_contract_id ||
281: ' AND attr_group_id = ' || l_attr_group_id ||
282: ' AND ' || l_sbcr_size_standard_col_name || ' like ''%EMP%''';
283:
284: EXECUTE IMMEDIATE l_sql INTO l_sbcr_size_standard;
285:
286: l_sql_desc := get_uda_attr_desc_sql(p_contract_id,
287: l_attr_data_type,
288: l_sbcr_size_standard_col_name, --application_column_name

Line 288: l_sbcr_size_standard_col_name, --application_column_name

284: EXECUTE IMMEDIATE l_sql INTO l_sbcr_size_standard;
285:
286: l_sql_desc := get_uda_attr_desc_sql(p_contract_id,
287: l_attr_data_type,
288: l_sbcr_size_standard_col_name, --application_column_name
289: 'SBCR_SBSS_SIZE_STANDARD', --end_user_column_name
290: 'SBCR_PROC_INFO_AG', --attr_group_name
291: l_attr_id );
292:

Line 289: 'SBCR_SBSS_SIZE_STANDARD', --end_user_column_name

285:
286: l_sql_desc := get_uda_attr_desc_sql(p_contract_id,
287: l_attr_data_type,
288: l_sbcr_size_standard_col_name, --application_column_name
289: 'SBCR_SBSS_SIZE_STANDARD', --end_user_column_name
290: 'SBCR_PROC_INFO_AG', --attr_group_name
291: l_attr_id );
292:
293: l_sql_desc := 'SELECT ' || l_sql_desc ||

Line 298: EXECUTE IMMEDIATE l_sql_desc INTO l_sbcr_size_standard_desc;

294: ' FROM okc_rep_contracts_all_ext_b' ||
295: ' WHERE contract_id = ' || p_contract_id ||
296: ' AND attr_group_id = ' || l_attr_group_id;
297:
298: EXECUTE IMMEDIATE l_sql_desc INTO l_sbcr_size_standard_desc;
299:
300: RETURN (l_sbcr_size_standard_desc);
301: EXCEPTION
302: WHEN No_Data_Found THEN

Line 300: RETURN (l_sbcr_size_standard_desc);

296: ' AND attr_group_id = ' || l_attr_group_id;
297:
298: EXECUTE IMMEDIATE l_sql_desc INTO l_sbcr_size_standard_desc;
299:
300: RETURN (l_sbcr_size_standard_desc);
301: EXCEPTION
302: WHEN No_Data_Found THEN
303: RETURN l_sbcr_size_standard_desc;
304: WHEN OTHERS THEN

Line 303: RETURN l_sbcr_size_standard_desc;

299:
300: RETURN (l_sbcr_size_standard_desc);
301: EXCEPTION
302: WHEN No_Data_Found THEN
303: RETURN l_sbcr_size_standard_desc;
304: WHEN OTHERS THEN
305: RAISE;
306: END get_sbss_employees_size;
307:

Line 310: l_sbcr_size_standard_col_name VARCHAR2(30);

306: END get_sbss_employees_size;
307:
308: FUNCTION get_sbss_dollars_size(p_contract_id NUMBER) RETURN VARCHAR2 IS
309:
310: l_sbcr_size_standard_col_name VARCHAR2(30);
311: l_sbcr_size_standard VARCHAR2(150);
312: l_sbcr_size_standard_desc VARCHAR2(32567) := NULL;
313: l_attr_group_id NUMBER;
314: l_attr_id NUMBER;

Line 311: l_sbcr_size_standard VARCHAR2(150);

307:
308: FUNCTION get_sbss_dollars_size(p_contract_id NUMBER) RETURN VARCHAR2 IS
309:
310: l_sbcr_size_standard_col_name VARCHAR2(30);
311: l_sbcr_size_standard VARCHAR2(150);
312: l_sbcr_size_standard_desc VARCHAR2(32567) := NULL;
313: l_attr_group_id NUMBER;
314: l_attr_id NUMBER;
315: l_attr_data_type VARCHAR2(30);

Line 312: l_sbcr_size_standard_desc VARCHAR2(32567) := NULL;

308: FUNCTION get_sbss_dollars_size(p_contract_id NUMBER) RETURN VARCHAR2 IS
309:
310: l_sbcr_size_standard_col_name VARCHAR2(30);
311: l_sbcr_size_standard VARCHAR2(150);
312: l_sbcr_size_standard_desc VARCHAR2(32567) := NULL;
313: l_attr_group_id NUMBER;
314: l_attr_id NUMBER;
315: l_attr_data_type VARCHAR2(30);
316: l_sql VARCHAR2(1000);

Line 322: INTO l_sbcr_size_standard_col_name, l_attr_id, l_attr_data_type

318:
319: BEGIN
320:
321: SELECT fcu.application_column_name, efdfce.attr_id, efdfce.data_type
322: INTO l_sbcr_size_standard_col_name, l_attr_id, l_attr_data_type
323: FROM fnd_descr_flex_column_usages fcu,
324: ego_fnd_df_col_usgs_ext efdfce
325: WHERE fcu.descriptive_flexfield_name = 'OKC_REP_CONTRACT_HDR_EXT_ATTRS'
326: AND fcu.descriptive_flex_context_code = 'SBCR_PROC_INFO_AG'

Line 327: AND fcu.end_user_column_name = 'SBCR_SBSS_SIZE_STANDARD'

323: FROM fnd_descr_flex_column_usages fcu,
324: ego_fnd_df_col_usgs_ext efdfce
325: WHERE fcu.descriptive_flexfield_name = 'OKC_REP_CONTRACT_HDR_EXT_ATTRS'
326: AND fcu.descriptive_flex_context_code = 'SBCR_PROC_INFO_AG'
327: AND fcu.end_user_column_name = 'SBCR_SBSS_SIZE_STANDARD'
328: AND efdfce.descriptive_flexfield_name = fcu.descriptive_flexfield_name
329: AND efdfce.descriptive_flex_context_code = fcu.descriptive_flex_context_code
330: AND efdfce.application_column_name = fcu.application_column_name;
331:

Line 337: l_sql := 'SELECT ' || l_sbcr_size_standard_col_name ||

333: FROM ego_fnd_dsc_flx_ctx_ext
334: WHERE descriptive_flexfield_name = 'OKC_REP_CONTRACT_HDR_EXT_ATTRS'
335: AND descriptive_flex_context_code = 'SBCR_PROC_INFO_AG';
336:
337: l_sql := 'SELECT ' || l_sbcr_size_standard_col_name ||
338: ' FROM okc_rep_contracts_all_ext_b' ||
339: ' WHERE contract_id = ' || p_contract_id ||
340: ' AND attr_group_id = ' || l_attr_group_id ||
341: ' AND ' || l_sbcr_size_standard_col_name || ' like ''%$%''';

Line 341: ' AND ' || l_sbcr_size_standard_col_name || ' like ''%$%''';

337: l_sql := 'SELECT ' || l_sbcr_size_standard_col_name ||
338: ' FROM okc_rep_contracts_all_ext_b' ||
339: ' WHERE contract_id = ' || p_contract_id ||
340: ' AND attr_group_id = ' || l_attr_group_id ||
341: ' AND ' || l_sbcr_size_standard_col_name || ' like ''%$%''';
342:
343: EXECUTE IMMEDIATE l_sql INTO l_sbcr_size_standard;
344:
345: l_sql_desc := get_uda_attr_desc_sql(p_contract_id,

Line 343: EXECUTE IMMEDIATE l_sql INTO l_sbcr_size_standard;

339: ' WHERE contract_id = ' || p_contract_id ||
340: ' AND attr_group_id = ' || l_attr_group_id ||
341: ' AND ' || l_sbcr_size_standard_col_name || ' like ''%$%''';
342:
343: EXECUTE IMMEDIATE l_sql INTO l_sbcr_size_standard;
344:
345: l_sql_desc := get_uda_attr_desc_sql(p_contract_id,
346: l_attr_data_type,
347: l_sbcr_size_standard_col_name, --application_column_name

Line 347: l_sbcr_size_standard_col_name, --application_column_name

343: EXECUTE IMMEDIATE l_sql INTO l_sbcr_size_standard;
344:
345: l_sql_desc := get_uda_attr_desc_sql(p_contract_id,
346: l_attr_data_type,
347: l_sbcr_size_standard_col_name, --application_column_name
348: 'SBCR_SBSS_SIZE_STANDARD', --end_user_column_name
349: 'SBCR_PROC_INFO_AG', --attr_group_name
350: l_attr_id );
351:

Line 348: 'SBCR_SBSS_SIZE_STANDARD', --end_user_column_name

344:
345: l_sql_desc := get_uda_attr_desc_sql(p_contract_id,
346: l_attr_data_type,
347: l_sbcr_size_standard_col_name, --application_column_name
348: 'SBCR_SBSS_SIZE_STANDARD', --end_user_column_name
349: 'SBCR_PROC_INFO_AG', --attr_group_name
350: l_attr_id );
351:
352: l_sql_desc := 'SELECT ' || l_sql_desc ||

Line 357: EXECUTE IMMEDIATE l_sql_desc INTO l_sbcr_size_standard_desc;

353: ' FROM okc_rep_contracts_all_ext_b' ||
354: ' WHERE contract_id = ' || p_contract_id ||
355: ' AND attr_group_id = ' || l_attr_group_id;
356:
357: EXECUTE IMMEDIATE l_sql_desc INTO l_sbcr_size_standard_desc;
358:
359: RETURN (l_sbcr_size_standard_desc);
360: EXCEPTION
361: WHEN No_Data_Found THEN

Line 359: RETURN (l_sbcr_size_standard_desc);

355: ' AND attr_group_id = ' || l_attr_group_id;
356:
357: EXECUTE IMMEDIATE l_sql_desc INTO l_sbcr_size_standard_desc;
358:
359: RETURN (l_sbcr_size_standard_desc);
360: EXCEPTION
361: WHEN No_Data_Found THEN
362: RETURN l_sbcr_size_standard_desc;
363: WHEN OTHERS THEN

Line 362: RETURN l_sbcr_size_standard_desc;

358:
359: RETURN (l_sbcr_size_standard_desc);
360: EXCEPTION
361: WHEN No_Data_Found THEN
362: RETURN l_sbcr_size_standard_desc;
363: WHEN OTHERS THEN
364: RAISE;
365: END get_sbss_dollars_size;
366: