DBA Data[Home] [Help]

APPS.IGF_AW_COA_UPDATE dependencies on IGF_AP_SS_PKG

Line 204: -- call to igf_ap_ss_pkg.get_pid

200:
201: -- Change History:
202: -- Who When What
203: -- ridas 08-Feb-2006 Bug #5021084. Added new parameter 'lv_group_type' in
204: -- call to igf_ap_ss_pkg.get_pid
205: --------------------------------------------------------------------------------
206:
207: -- Variables for the dynamic person id group
208: lv_status VARCHAR2(1);

Line 284: lv_sql_stmt := igf_ap_ss_pkg.get_pid(l_grp_id.group_id,lv_status,lv_group_type);

280:
281: IF l_grp_id.group_id IS NOT NULL THEN
282: -- To check whether the person exist in the group or not
283: -- Bug #5021084
284: lv_sql_stmt := igf_ap_ss_pkg.get_pid(l_grp_id.group_id,lv_status,lv_group_type);
285:
286: --Bug #5021084. Passing Group ID if the group type is STATIC.
287: IF lv_group_type = 'STATIC' THEN
288: OPEN c_chk_per_exist FOR 'SELECT 1

Line 728: -- call to igf_ap_ss_pkg.get_pid

724:
725: -- Change History:
726: -- Who When What
727: -- ridas 08-Feb-2006 Bug #5021084. Added new parameter 'lv_group_type' in
728: -- call to igf_ap_ss_pkg.get_pid
729: -- tsailaja 13/Jan/2006 Bug 4947880 Added invocation of igf_aw_gen.set_org_id(NULL);
730: --------------------------------------------------------------------------------
731:
732: param_exception EXCEPTION;

Line 970: lv_sql_stmt := igf_ap_ss_pkg.get_pid(p_pid_group,lv_status,lv_group_type);

966:
967: --COMPUTATION FOR ALL PERSONS IN THE PERSON ID GROUP
968: ELSIF (p_run_type = 'P' AND p_pid_group IS NOT NULL) THEN
969: --Bug #5021084
970: lv_sql_stmt := igf_ap_ss_pkg.get_pid(p_pid_group,lv_status,lv_group_type);
971:
972: --Bug #5021084. Passing Group ID if the group type is STATIC.
973: IF lv_group_type = 'STATIC' THEN
974: OPEN cur_per_grp FOR