APPS.HR_DELTA_SYNC_MESSAGES dependencies on WF_PARAMETER_LIST_T

Line 87: l_params WF_PARAMETER_LIST_T;

83: p_cntry_code fnd_territories_vl.territory_code%type;
84: p_cntry_desc fnd_territories_vl.territory_short_name%type;
85: p_obs_flag fnd_territories_vl.obsolete_flag%type;
86: p_effective_date date default sysdate;
87: l_params WF_PARAMETER_LIST_T;
88: p_last_update_date date;
89: p_unique_key number;
90: p_row_id rowid;
91: p_gen_msg VARCHAR2(4000);

Line 298: l_params WF_PARAMETER_LIST_T;

294: p_state_code fnd_common_lookups.lookup_code%type;
295: p_state_desc fnd_common_lookups.meaning%type;
296: p_enable_flag fnd_common_lookups.enabled_flag%type;
297: p_effective_date date default sysdate;
298: l_params WF_PARAMETER_LIST_T;
299: p_unique_key number;
300: p_last_update_date date;
301: p_gen_msg VARCHAR2(4000);
302: p_gen_status varchar2(10);

Line 532: l_params WF_PARAMETER_LIST_T;

528: p_loc_info_18 hr_locations_all.LOC_INFORMATION18%type;
529: p_loc_info_19 hr_locations_all.LOC_INFORMATION19%type;
530: p_loc_info_20 hr_locations_all.LOC_INFORMATION20%type;
531: p_effective_date date default sysdate;
532: l_params WF_PARAMETER_LIST_T;
533: p_unique_key number;
534: p_last_update_date date;
535: p_gen_msg VARCHAR2(4000);
536: p_gen_status varchar2(10);

Line 1162: l_params WF_PARAMETER_LIST_T;

1158: l_dummy number;
1159: l_sync_date date;
1160: l_current_date date;
1161: p_unique_key number;
1162: l_params WF_PARAMETER_LIST_T;
1163:
1164: begin
1165: open fet_psft_sync;
1166: fetch fet_psft_sync into l_dummy;

Line 1428: l_params WF_PARAMETER_LIST_T;

1424: workforce_delta workforce;
1425: workforce_deltaq workforce;
1426:
1427: p_cnt number := 0;
1428: l_params WF_PARAMETER_LIST_T;
1429: p_unique_key number;
1430: p_effective_date date default sysdate;
1431: p_gen_msg VARCHAR2(4000);
1432: p_gen_status varchar2(10);

Line 1849: l_params WF_PARAMETER_LIST_T;

1845: jobcode_delta jobcode;
1846: jobcode_deltaq jobcode;
1847:
1848: p_cnt number := 0;
1849: l_params WF_PARAMETER_LIST_T;
1850: p_unique_key number;
1851: p_effective_date date default sysdate;
1852:
1853: cursor fet_psft_run_dt is

Line 2148: l_params WF_PARAMETER_LIST_T;

2144: p_full_name per_org_manager_v.full_name%type;
2145: p_bg_name hr_all_organization_units.name%type;
2146: p_eff_status varchar2(10);
2147: p_effective_date date default sysdate;
2148: l_params WF_PARAMETER_LIST_T;
2149: p_last_update_date date;
2150: p_unique_key number;
2151: p_row_id rowid;
2152: p_gen_msg VARCHAR2(4000);

Line 2414: l_params WF_PARAMETER_LIST_T;

2410: p_bg_name PER_BUSINESS_GROUPS.name%type;
2411: p_eff_status varchar2(10);
2412: p_eff_date date;
2413: p_effective_date date default sysdate;
2414: l_params WF_PARAMETER_LIST_T;
2415: p_last_update_date date;
2416: p_unique_key number;
2417: p_gen_msg VARCHAR2(4000);
2418: p_gen_status varchar2(10);

Line 2631: l_params WF_PARAMETER_LIST_T;

2627: p_bg_id pay_all_payrolls_f.business_group_id%type;
2628: p_eff_date date;
2629: p_eff_status varchar2(10);
2630: p_effective_date date default sysdate;
2631: l_params WF_PARAMETER_LIST_T;
2632: p_last_update_date date;
2633: p_unique_key number;
2634: p_gen_msg VARCHAR2(4000);
2635: p_gen_status varchar2(10);