APPS.OKC_SBCR_DT_PKG dependencies on OKC_REP_CONTRACTS_ALL_EXT_B

Line 19: p_object_name := 'OKC_REP_CONTRACTS_ALL_EXT_B';

15: l_sql varchar2(1000);
16:
17: BEGIN
18: p_attr_group_type := 'OKC_REP_CONTRACT_HDR_EXT_ATTRS';
19: p_object_name := 'OKC_REP_CONTRACTS_ALL_EXT_B';
20: p_pk1_column_name := 'CONTRACT_ID';
21:
22: IF (p_data_type = 'C' or p_data_type = 'A' ) then
23: l_sql := ' EGO_USER_ATTRS_DATA_PVT.Get_Attr_Disp_Val_From_VSet ( ' ||

Line 67: WHERE ag.attr_group_id IN (SELECT DISTINCT ext.attr_group_id FROM okc_rep_contracts_all_ext_b ext WHERE ext.contract_id = p_contract_id)

63: SELECT ag.descriptive_flex_context_code attr_group,
64: ag.attr_group_id attr_group_id,
65: ag.descriptive_flexfield_name desc_flexfld_name
66: FROM ego_fnd_dsc_flx_ctx_ext ag
67: WHERE ag.attr_group_id IN (SELECT DISTINCT ext.attr_group_id FROM okc_rep_contracts_all_ext_b ext WHERE ext.contract_id = p_contract_id)
68: AND ag.multi_row = 'N';
69:
70: CURSOR C_ATTR(p_attr_group VARCHAR2, p_desc_flexfld_name VARCHAR2) IS
71: SELECT efdfce.attr_id,

Line 162: l_sql := 'SELECT lkup.lookup_code, nvl2(ext.' || l_rec_type_col_name || ', ''Y'', ''N''), ext.' || l_rec_percent_col_name || ' FROM okc_rep_contracts_all_ext_b ext, fnd_lookups lkup' ||

158: FROM ego_fnd_dsc_flx_ctx_ext
159: WHERE descriptive_flexfield_name = 'OKC_REP_CONTRACT_HDR_EXT_ATTRS'
160: AND descriptive_flex_context_code = 'SBCR_REC_AG';
161:
162: l_sql := 'SELECT lkup.lookup_code, nvl2(ext.' || l_rec_type_col_name || ', ''Y'', ''N''), ext.' || l_rec_percent_col_name || ' FROM okc_rep_contracts_all_ext_b ext, fnd_lookups lkup' ||
163: ' WHERE ext.contract_id(+) = ' || p_contract_id || ' AND ext.attr_group_id (+) = ' || l_attr_group_id ||
164: ' AND lkup.lookup_type = ''OKC_REP_SBCR_REC_SET_ASIDE'' AND lkup.enabled_flag = ''Y''' ||
165: ' AND TRUNC(SYSDATE) BETWEEN lkup.start_date_active AND nvl(lkup.end_date_active, SYSDATE)' ||
166: ' AND lkup.lookup_code = ext.' || l_rec_type_col_name || '(+)';

Line 223: ' FROM okc_rep_contracts_all_ext_b' ||

219: WHERE descriptive_flexfield_name = 'OKC_REP_CONTRACT_HDR_EXT_ATTRS'
220: AND descriptive_flex_context_code = 'SBCR_PRE_ACQ';
221:
222: l_sql := 'SELECT ' || l_prev_acq_type_col_name || ', ' || l_prev_acq_cmt_col_name ||
223: ' FROM okc_rep_contracts_all_ext_b' ||
224: ' WHERE contract_id = ' || p_contract_id ||
225: ' AND attr_group_id = ' || l_attr_group_id ||
226: ' AND ' || l_prev_acq_type_col_name || ' IS NOT NULL';
227:

Line 279: ' FROM okc_rep_contracts_all_ext_b' ||

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%''';
283:

Line 294: ' FROM okc_rep_contracts_all_ext_b' ||

290: 'SBCR_PROC_INFO_AG', --attr_group_name
291: l_attr_id );
292:
293: l_sql_desc := 'SELECT ' || l_sql_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;

Line 338: ' FROM okc_rep_contracts_all_ext_b' ||

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 ''%$%''';
342:

Line 353: ' FROM okc_rep_contracts_all_ext_b' ||

349: 'SBCR_PROC_INFO_AG', --attr_group_name
350: l_attr_id );
351:
352: l_sql_desc := 'SELECT ' || l_sql_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;

Line 388: ' FROM okc_rep_contracts_all_ext_b' ||

384: WHERE descriptive_flexfield_name = 'OKC_REP_CONTRACT_HDR_EXT_ATTRS'
385: AND descriptive_flex_context_code = 'SBCR_REC_AG';
386:
387: l_sql := 'SELECT ''Y''' ||
388: ' FROM okc_rep_contracts_all_ext_b' ||
389: ' WHERE contract_id = ' || p_contract_id ||
390: ' AND attr_group_id = ' || l_attr_group_id ||
391: ' AND ' || l_rec_type_col_name || ' like ''SEC8A%''';
392: