APPS.IGS_AD_GEN_016 dependencies on IGS_AD_SOURCE_CAT_ALL

Line 259: lv_include_ind igs_ad_source_cat_all.include_ind%TYPE;

255: p_category IN VARCHAR2)
256: RETURN BOOLEAN
257: IS
258: lv_ret_success VARCHAR2(5);
259: lv_include_ind igs_ad_source_cat_all.include_ind%TYPE;
260: lv_detail_level_ind igs_ad_source_cat_all.detail_level_ind%TYPE;
261: lv_discrepancy_rule_cd igs_ad_source_cat_all.discrepancy_rule_cd%TYPE;
262: BEGIN
263: lv_include_ind := 'Y';

Line 260: lv_detail_level_ind igs_ad_source_cat_all.detail_level_ind%TYPE;

256: RETURN BOOLEAN
257: IS
258: lv_ret_success VARCHAR2(5);
259: lv_include_ind igs_ad_source_cat_all.include_ind%TYPE;
260: lv_detail_level_ind igs_ad_source_cat_all.detail_level_ind%TYPE;
261: lv_discrepancy_rule_cd igs_ad_source_cat_all.discrepancy_rule_cd%TYPE;
262: BEGIN
263: lv_include_ind := 'Y';
264: lv_ret_success := get_srccat (p_source_type_id => p_source_type_id,

Line 261: lv_discrepancy_rule_cd igs_ad_source_cat_all.discrepancy_rule_cd%TYPE;

257: IS
258: lv_ret_success VARCHAR2(5);
259: lv_include_ind igs_ad_source_cat_all.include_ind%TYPE;
260: lv_detail_level_ind igs_ad_source_cat_all.detail_level_ind%TYPE;
261: lv_discrepancy_rule_cd igs_ad_source_cat_all.discrepancy_rule_cd%TYPE;
262: BEGIN
263: lv_include_ind := 'Y';
264: lv_ret_success := get_srccat (p_source_type_id => p_source_type_id,
265: p_category_name => p_category,

Line 282: lv_include_ind igs_ad_source_cat_all.include_ind%TYPE;

278: p_category IN VARCHAR2)
279: RETURN VARCHAR2
280: IS
281: lv_ret_success VARCHAR2(5);
282: lv_include_ind igs_ad_source_cat_all.include_ind%TYPE;
283: lv_detail_level_ind igs_ad_source_cat_all.detail_level_ind%TYPE;
284: lv_discrepancy_rule_cd igs_ad_source_cat_all.discrepancy_rule_cd%TYPE;
285: BEGIN
286: lv_ret_success := get_srccat (p_source_type_id => p_source_type_id,

Line 283: lv_detail_level_ind igs_ad_source_cat_all.detail_level_ind%TYPE;

279: RETURN VARCHAR2
280: IS
281: lv_ret_success VARCHAR2(5);
282: lv_include_ind igs_ad_source_cat_all.include_ind%TYPE;
283: lv_detail_level_ind igs_ad_source_cat_all.detail_level_ind%TYPE;
284: lv_discrepancy_rule_cd igs_ad_source_cat_all.discrepancy_rule_cd%TYPE;
285: BEGIN
286: lv_ret_success := get_srccat (p_source_type_id => p_source_type_id,
287: p_category_name => p_category,

Line 284: lv_discrepancy_rule_cd igs_ad_source_cat_all.discrepancy_rule_cd%TYPE;

280: IS
281: lv_ret_success VARCHAR2(5);
282: lv_include_ind igs_ad_source_cat_all.include_ind%TYPE;
283: lv_detail_level_ind igs_ad_source_cat_all.detail_level_ind%TYPE;
284: lv_discrepancy_rule_cd igs_ad_source_cat_all.discrepancy_rule_cd%TYPE;
285: BEGIN
286: lv_ret_success := get_srccat (p_source_type_id => p_source_type_id,
287: p_category_name => p_category,
288: p_include_ind => lv_include_ind,

Line 300: lv_detail_level_ind igs_ad_source_cat_all.detail_level_ind%TYPE;

296: p_category_name IN VARCHAR2,
297: p_include_ind IN VARCHAR2 DEFAULT NULL)
298: RETURN VARCHAR2 -- Returns TRUE/FALSE
299: IS
300: lv_detail_level_ind igs_ad_source_cat_all.detail_level_ind%TYPE;
301: lv_discrepancy_rule_cd igs_ad_source_cat_all.discrepancy_rule_cd%TYPE;
302: BEGIN
303: RETURN (get_srccat (p_source_type_id => p_source_type_id,
304: p_category_name => p_category_name,

Line 301: lv_discrepancy_rule_cd igs_ad_source_cat_all.discrepancy_rule_cd%TYPE;

297: p_include_ind IN VARCHAR2 DEFAULT NULL)
298: RETURN VARCHAR2 -- Returns TRUE/FALSE
299: IS
300: lv_detail_level_ind igs_ad_source_cat_all.detail_level_ind%TYPE;
301: lv_discrepancy_rule_cd igs_ad_source_cat_all.discrepancy_rule_cd%TYPE;
302: BEGIN
303: RETURN (get_srccat (p_source_type_id => p_source_type_id,
304: p_category_name => p_category_name,
305: p_include_ind => p_include_ind,

Line 325: FROM igs_ad_source_cat_all

321:
322: CURSOR c_srccat (ln_source_type_id NUMBER)
323: IS
324: SELECT category_name, include_ind, detail_level_ind, discrepancy_rule_cd
325: FROM igs_ad_source_cat_all
326: WHERE source_type_id = ln_source_type_id;
327:
328: lr_fetched_srccat c_srccat%ROWTYPE;
329: