APPS.IGS_AD_IMP_023 dependencies on IGS_AD_SOURCE_CAT

Line 31: FROM igs_ad_source_cat

27: SELECT discrepancy_rule_cd
28: FROM igs_ad_dscp_attr
29: WHERE UPPER(attribute_name) = UPPER(p_attribute_name)
30: AND src_cat_id = (SELECT src_cat_id
31: FROM igs_ad_source_cat
32: WHERE source_type_id = p_source_type_id
33: AND category_name = p_category);
34: get_discrepancy_rule_rec get_discrepancy_rule_cur%ROWTYPE;
35:

Line 82: FROM igs_ad_source_cat

78: SELECT discrepancy_rule_cd
79: FROM igs_ad_dscp_attr
80: WHERE UPPER(attribute_name) = UPPER(p_attribute_name)
81: AND src_cat_id = (SELECT src_cat_id
82: FROM igs_ad_source_cat
83: WHERE source_type_id = p_source_type_id
84: AND category_name = p_category);
85: get_discrepancy_rule_rec get_discrepancy_rule_cur%ROWTYPE;
86:

Line 133: FROM igs_ad_source_cat

129: SELECT discrepancy_rule_cd
130: FROM igs_ad_dscp_attr
131: WHERE UPPER(attribute_name) = UPPER(p_attribute_name)
132: AND src_cat_id = (SELECT src_cat_id
133: FROM igs_ad_source_cat
134: WHERE source_type_id = p_source_type_id
135: AND category_name = p_category);
136: get_discrepancy_rule_rec get_discrepancy_rule_cur%ROWTYPE;
137:

Line 248: -- Get the SRC_CAT_ID, AD_TAB_NAME, INT_TAB_NAME from igs_ad_source_cat table.

244: l_prog_label VARCHAR2(100) := 'igs.plsql.igs_ad_imp_002.prc_pe_dtls';
245: l_label VARCHAR2(100) := 'igs.plsql.igs_ad_imp_023.find_detail_discrepancy_rule.';
246: l_debug_str VARCHAR2(10000);
247:
248: -- Get the SRC_CAT_ID, AD_TAB_NAME, INT_TAB_NAME from igs_ad_source_cat table.
249: CURSOR source_cat_cur IS
250: SELECT *
251: FROM igs_ad_source_cat
252: WHERE source_type_id = p_source_type_id

Line 251: FROM igs_ad_source_cat

247:
248: -- Get the SRC_CAT_ID, AD_TAB_NAME, INT_TAB_NAME from igs_ad_source_cat table.
249: CURSOR source_cat_cur IS
250: SELECT *
251: FROM igs_ad_source_cat
252: WHERE source_type_id = p_source_type_id
253: AND category_name = p_category;
254:
255: source_cat_rec source_cat_cur%ROWTYPE;

Line 258: CURSOR detail_discrepancy_cur(cp_src_cat_id igs_ad_source_cat.src_cat_id%TYPE) IS

254:
255: source_cat_rec source_cat_cur%ROWTYPE;
256:
257: -- Get the ATTRIBUTE_NAME for which discrepancy rule is marked for Review.
258: CURSOR detail_discrepancy_cur(cp_src_cat_id igs_ad_source_cat.src_cat_id%TYPE) IS
259: SELECT *
260: FROM igs_ad_dscp_attr
261: WHERE src_cat_id = cp_src_cat_id
262: AND NVL(discrepancy_rule_cd,'I') = 'R';

Line 402: FROM igs_ad_source_cat

398: CURSOR check_dtl_for_rev_cur IS
399: SELECT count(ROWID)
400: FROM igs_ad_dscp_attr
401: WHERE src_cat_id = (SELECT src_cat_id
402: FROM igs_ad_source_cat
403: WHERE category_name = p_category
404: AND source_type_id = p_Source_type_id)
405: AND NVL(discrepancy_rule_cd,'E') = 'R';
406:

Line 412: FROM igs_ad_source_cat

408: CURSOR check_dtl_for_import_cur IS
409: SELECT count(ROWID)
410: FROM igs_ad_dscp_attr
411: WHERE src_cat_id = (SELECT src_cat_id
412: FROM igs_ad_source_cat
413: WHERE category_name = p_category
414: AND source_type_id = p_Source_type_id)
415: AND NVL(discrepancy_rule_cd,'E') = 'I';
416: