APPS.IGS_PS_VALIDATE_LGCY_PKG dependencies on IGS_OR_GEN_012_PKG

Line 443: igs_or_gen_012_pkg.get_where_clause_api1('UNIT_VERSION_LGCY',l_c_where_clause);

439: END IF;
440:
441: --Validate Org unit filter integration
442: --Bug #2972950. As a part of Binding issues, using bind variable in the ref cursor.Original sql bind fix bug is 2941266
443: igs_or_gen_012_pkg.get_where_clause_api1('UNIT_VERSION_LGCY',l_c_where_clause);
444: IF l_c_where_clause IS NOT NULL THEN
445: l_c_cur_stat :='SELECT '||''''||'X'||''''||' FROM IGS_OR_INST_ORG_BASE_V WHERE party_number = :p_c_org_unit_cd AND '|| l_c_where_clause;
446: OPEN c_org_cur FOR l_c_cur_stat USING p_unit_ver_rec.owner_org_unit_cd,l_func_name ;
447: ELSE

Line 2878: igs_or_gen_012_pkg.get_where_clause_api1( p_c_object_name, l_c_where_clause );

2874: l_n_rec_found NUMBER(1);
2875:
2876: BEGIN
2877:
2878: igs_or_gen_012_pkg.get_where_clause_api1( p_c_object_name, l_c_where_clause );
2879: IF l_c_where_clause IS NULL THEN
2880: l_c_cur_stat := 'SELECT 1 FROM igs_or_inst_org_base_v WHERE party_number = :p_c_org_unit_cd ';
2881: OPEN c_org_cur FOR l_c_cur_stat USING p_c_org_unit_cd;
2882: ELSE