DBA Data[Home] [Help]

APPS.PAY_BALANCES_UPLOAD_PKG dependencies on HR_GENERAL2

Line 138: hr_general2.init_fndload(800,1);

134: l_legislation_code,l_business_group_id,l_ovn,l_owner;
135: if(csr_sel_bal_category_all%found) then
136: --need to perform a date-track correction or row already exists
137: if(p_OWNER='SEED') then
138: hr_general2.init_fndload(800,1);
139: else
140: hr_general2.init_fndload(800,-1);
141: end if;
142: update pay_balance_categories_f

Line 140: hr_general2.init_fndload(800,-1);

136: --need to perform a date-track correction or row already exists
137: if(p_OWNER='SEED') then
138: hr_general2.init_fndload(800,1);
139: else
140: hr_general2.init_fndload(800,-1);
141: end if;
142: update pay_balance_categories_f
143: set
144: save_run_balance_enabled = p_SAVE_RUN_BALANCE_ENABLED

Line 190: hr_general2.init_fndload(800,1);

186: l_legislation_code,l_business_group_id,l_ovn,l_owner;
187: if(csr_sel_bal_category_mid%found) then
188: --need to perform a date-track update
189: if(p_OWNER='SEED') then
190: hr_general2.init_fndload(800,1);
191: else
192: hr_general2.init_fndload(800,-1);
193: end if;
194: update pay_balance_categories_f

Line 192: hr_general2.init_fndload(800,-1);

188: --need to perform a date-track update
189: if(p_OWNER='SEED') then
190: hr_general2.init_fndload(800,1);
191: else
192: hr_general2.init_fndload(800,-1);
193: end if;
194: update pay_balance_categories_f
195: set
196: effective_end_date = to_date(p_EFFECTIVE_END_DATE,'YYYY/MM/DD')

Line 235: hr_general2.init_fndload(800,1);

231: where balance_category_id = l_balance_category_id;
232: else
233: --need to insert the new date-track row.
234: if(p_OWNER='SEED') then
235: hr_general2.init_fndload(800,1);
236: else
237: hr_general2.init_fndload(800,-1);
238: end if;
239: insert into

Line 237: hr_general2.init_fndload(800,-1);

233: --need to insert the new date-track row.
234: if(p_OWNER='SEED') then
235: hr_general2.init_fndload(800,1);
236: else
237: hr_general2.init_fndload(800,-1);
238: end if;
239: insert into
240: pay_balance_categories_f(balance_category_id,category_name,
241: effective_start_date,effective_end_date,legislation_code,

Line 278: hr_general2.init_fndload(800,1);

274: end if;
275: else
276: --row does not exist in the table. so insert the new row into the table
277: if(p_OWNER='SEED') then
278: hr_general2.init_fndload(800,1);
279: else
280: hr_general2.init_fndload(800,-1);
281: end if;
282:

Line 280: hr_general2.init_fndload(800,-1);

276: --row does not exist in the table. so insert the new row into the table
277: if(p_OWNER='SEED') then
278: hr_general2.init_fndload(800,1);
279: else
280: hr_general2.init_fndload(800,-1);
281: end if;
282:
283: insert into
284: pay_balance_categories_f(balance_category_id,category_name,

Line 383: hr_general2.init_fndload(800,1);

379: fetch csr_sel_bal_cat_id into l_balance_category_id;
380: if(csr_sel_bal_cat_id%found) then
381:
382: if(p_OWNER='SEED') then
383: hr_general2.init_fndload(800,1);
384: else
385: hr_general2.init_fndload(800,-1);
386: end if;
387:

Line 385: hr_general2.init_fndload(800,-1);

381:
382: if(p_OWNER='SEED') then
383: hr_general2.init_fndload(800,1);
384: else
385: hr_general2.init_fndload(800,-1);
386: end if;
387:
388: update pay_balance_types
389: set balance_category_id =l_balance_category_id

Line 468: hr_general2.init_fndload(800,1);

464: else
465: hr_startup_data_api_support.enable_startup_mode('STARTUP');
466: end if ;
467: --Need to set the AOL WHO columns properly. Hence call this
468: hr_general2.init_fndload(800,1);
469:
470: elsif (p_OWNER='CUSTOM') then
471:
472: if(p_BUSINESS_GROUP_NAME is null AND p_LEGISLATION_CODE is null)then

Line 483: hr_general2.init_fndload(800,-1);

479: hr_startup_data_api_support.enable_startup_mode('USER');
480:
481: end if;
482: --Need to set the AOL WHO columns properly. Hence call this
483: hr_general2.init_fndload(800,-1);
484: end if;--Close end if for OWNER
485:
486: open csr_bg_id(p_BUSINESS_GROUP_NAME);
487: fetch csr_bg_id into l_business_group_id;

Line 654: hr_general2.init_fndload(800,1);

650: if (p_OWNER ='SEED') then
651:
652: hr_startup_data_api_support.enable_startup_mode('STARTUP');
653: --Need to set the AOL WHO columns properly. Hence call this
654: hr_general2.init_fndload(800,1);
655:
656: elsif (p_OWNER='CUSTOM') then
657:
658: if(p_BUSINESS_GROUP_NAME is null AND p_LEGISLATION_CODE is null) then

Line 669: hr_general2.init_fndload(800,-1);

665: hr_startup_data_api_support.enable_startup_mode('USER');
666:
667: end if;
668: --Need to set the AOL WHO columns properly. Hence call this
669: hr_general2.init_fndload(800,-1);
670: end if;
671:
672: open csr_bg_id(p_BUSINESS_GROUP_NAME);
673: fetch csr_bg_id into l_business_group_id;

Line 854: hr_general2.init_fndload(800,1);

850: if (p_OWNER ='SEED') then
851:
852: hr_startup_data_api_support.enable_startup_mode('STARTUP');
853: --Need to set the AOL WHO columns properly. Hence call this
854: hr_general2.init_fndload(800,1);
855:
856: elsif (p_OWNER='CUSTOM') then
857:
858: if(p_BUSINESS_GROUP_NAME is null AND p_LEGISLATION_CODE is null) then

Line 868: hr_general2.init_fndload(800,-1);

864: hr_startup_data_api_support.enable_startup_mode('USER');
865:
866: end if;
867: --Need to set the AOL WHO columns properly. Hence call this
868: hr_general2.init_fndload(800,-1);
869: end if;
870:
871: open csr_bg_id(p_BUSINESS_GROUP_NAME);
872: fetch csr_bg_id into l_business_group_id;

Line 1006: hr_general2.init_fndload(800,1);

1002: --
1003: -- now determine what the who columns will be
1004: --
1005: if p_owner = 'SEED' then
1006: hr_general2.init_fndload(800,1);
1007: else
1008: hr_general2.init_fndload(800,-1);
1009: end if;
1010: --

Line 1008: hr_general2.init_fndload(800,-1);

1004: --
1005: if p_owner = 'SEED' then
1006: hr_general2.init_fndload(800,1);
1007: else
1008: hr_general2.init_fndload(800,-1);
1009: end if;
1010: --
1011: update pay_balance_categories_f
1012: set user_category_name = p_user_category_name

Line 1063: hr_general2.init_fndload(800,1);

1059: --
1060: -- now determine what the who columns will be
1061: --
1062: if p_owner = 'SEED' then
1063: hr_general2.init_fndload(800,1);
1064: else
1065: hr_general2.init_fndload(800,-1);
1066: end if;
1067: --

Line 1065: hr_general2.init_fndload(800,-1);

1061: --
1062: if p_owner = 'SEED' then
1063: hr_general2.init_fndload(800,1);
1064: else
1065: hr_general2.init_fndload(800,-1);
1066: end if;
1067: --
1068: update pay_bal_attribute_definitions
1069: set user_attribute_name = p_user_attribute_name