[Home] [Help]
3548: and balance_type_id = l_bal_id;
3549:
3550: IF already_exists = 0 THEN
3551:
3552: hr_balances.ins_balance_feed(
3553: p_option => 'INS_MANUAL_FEED',
3554: p_input_value_id => g_reduce_sal_pay_inpval_id,
3555: p_element_type_id => NULL,
3556: p_primary_classification_id => NULL,
3601: and balance_type_id = l_bal_id;
3602:
3603: IF already_exists = 0 THEN
3604:
3605: hr_balances.ins_balance_feed(
3606: p_option => 'INS_MANUAL_FEED',
3607: p_input_value_id => g_reduce_wag_pay_inpval_id,
3608: p_element_type_id => NULL,
3609: p_primary_classification_id => NULL,
3688: and balance_type_id = l_bal_id;
3689:
3690: IF already_exists = 0 THEN
3691:
3692: hr_balances.ins_balance_feed(
3693: p_option => 'INS_MANUAL_FEED',
3694: p_input_value_id => p_iv_id,
3695: p_element_type_id => NULL,
3696: p_primary_classification_id => NULL,
3741: and balance_type_id = l_bal_id;
3742:
3743: IF already_exists = 0 THEN
3744:
3745: hr_balances.ins_balance_feed(
3746: p_option => 'INS_MANUAL_FEED',
3747: p_input_value_id => p_iv_id,
3748: p_element_type_id => NULL,
3749: p_primary_classification_id => NULL,
4713: --
4714: -- check for existence of balance feed before creating...return bal feed id if already exists...
4715: --
4716:
4717: hr_balances.ins_balance_feed(
4718: p_option => 'INS_MANUAL_FEED',
4719: p_input_value_id => v_payval_id,
4720: p_element_type_id => NULL,
4721: p_primary_classification_id => NULL,
4752: -- Note, there is a packaged function "chk_ins_balance_feed" in pybalnce.pkb.
4753: -- Since this is definitely a new balance feed for a new element and balance,
4754: -- there is no chance for duplicating an existing feed.
4755: hr_utility.set_location('pyusuiet',1075);
4756: hr_balances.ins_balance_feed(
4757: p_option => 'INS_MANUAL_FEED',
4758: p_input_value_id => g_neg_earn_inpval_id,
4759: p_element_type_id => NULL,
4760: p_primary_classification_id => NULL,
4788: -- there is no chance for duplicating an existing feed.
4789:
4790:
4791: hr_utility.set_location('pyusuiet',1084);
4792: hr_balances.ins_balance_feed(
4793: p_option => 'INS_MANUAL_FEED',
4794: p_input_value_id => g_addl_inpval_id,
4795: p_element_type_id => NULL,
4796: p_primary_classification_id => NULL,
4803: p_legislation_code => NULL,
4804: p_mode => 'USER');
4805:
4806: hr_utility.set_location('pyusuiet',1085);
4807: hr_balances.ins_balance_feed(
4808: p_option => 'INS_MANUAL_FEED',
4809: p_input_value_id => gi_addl_inpval_id,
4810: p_element_type_id => NULL,
4811: p_primary_classification_id => NULL,
4831: -- Note, there is a packaged function "chk_ins_balance_feed" in pybalnce.pkb.
4832: -- Since this is definitely a new balance feed for a new element and balance,
4833: -- there is no chance for duplicating an existing feed.
4834: hr_utility.set_location('pyusuiet',1090);
4835: hr_balances.ins_balance_feed(
4836: p_option => 'INS_MANUAL_FEED',
4837: p_input_value_id => g_repl_inpval_id,
4838: p_element_type_id => NULL,
4839: p_primary_classification_id => NULL,
4846: p_legislation_code => NULL,
4847: p_mode => 'USER');
4848:
4849: hr_utility.set_location('pyusuiet',1095);
4850: hr_balances.ins_balance_feed(
4851: p_option => 'INS_MANUAL_FEED',
4852: p_input_value_id => gi_repl_inpval_id,
4853: p_element_type_id => NULL,
4854: p_primary_classification_id => NULL,
4884: AND business_group_id IS NULL
4885: AND legislation_code = 'US';
4886:
4887: hr_utility.set_location('pyusuiet',1105);
4888: hr_balances.ins_balance_feed(
4889: p_option => 'INS_MANUAL_FEED',
4890: p_input_value_id => v_payval_id,
4891: p_element_type_id => NULL,
4892: p_primary_classification_id => NULL,
4917: AND business_group_id IS NULL
4918: AND legislation_code = 'US';
4919:
4920: hr_utility.set_location('pyusuiet',1115);
4921: hr_balances.ins_balance_feed(
4922: p_option => 'INS_MANUAL_FEED',
4923: p_input_value_id => v_payval_id,
4924: p_element_type_id => NULL,
4925: p_primary_classification_id => NULL,
4968: AND business_group_id = p_bg_id
4969: AND name = 'Hours';
4970:
4971: hr_utility.set_location('pyusuiet',1140);
4972: hr_balances.ins_balance_feed(
4973: p_option => 'INS_MANUAL_FEED',
4974: p_input_value_id => v_hrs_inpval_id,
4975: p_element_type_id => NULL,
4976: p_primary_classification_id => NULL,
5015: AND business_group_id = p_bg_id
5016: AND name = 'Hours';
5017:
5018: hr_utility.set_location('pyusuiet',1160);
5019: hr_balances.ins_balance_feed(
5020: p_option => 'INS_MANUAL_FEED',
5021: p_input_value_id => v_hrs_inpval_id,
5022: p_element_type_id => NULL,
5023: p_primary_classification_id => NULL,
5060: and business_group_id is null
5061: and legislation_code = 'US';
5062:
5063: hr_utility.set_location('pyusuiet',1175);
5064: hr_balances.ins_balance_feed(
5065: p_option => 'INS_MANUAL_FEED',
5066: p_input_value_id => v_hrs_inpval_id,
5067: p_element_type_id => NULL,
5068: p_primary_classification_id => NULL,
5121: and business_group_id is null
5122: and legislation_code = 'US';
5123: */
5124: hr_utility.set_location('pyusuiet',1190);
5125: hr_balances.ins_balance_feed(
5126: p_option => 'INS_MANUAL_FEED',
5127: p_input_value_id => g_reduce_hrs_inpval_id,
5128: p_element_type_id => NULL,
5129: p_primary_classification_id => NULL,
5156: and business_group_id is null
5157: and legislation_code = 'US';
5158:
5159: hr_utility.set_location('pyusuiet',1205);
5160: hr_balances.ins_balance_feed(
5161: p_option => 'INS_MANUAL_FEED',
5162: p_input_value_id => g_reduce_sal_hrs_inpval_id,
5163: p_element_type_id => NULL,
5164: p_primary_classification_id => NULL,
5191: and business_group_id is null
5192: and legislation_code = 'US';
5193:
5194: hr_utility.set_location('pyusuiet',1210);
5195: hr_balances.ins_balance_feed(
5196: p_option => 'INS_MANUAL_FEED',
5197: p_input_value_id => g_reduce_wag_hrs_inpval_id,
5198: p_element_type_id => NULL,
5199: p_primary_classification_id => NULL,
5497: -- Primary Balance
5498: IF p_ele_info_10 IS NOT NULL THEN
5499:
5500: hr_utility.set_location('pyusuiet',1260);
5501: hr_balances.del_balance_type_cascade (
5502: p_balance_type_id => fnd_number.canonical_to_number(p_ele_info_10),
5503: p_legislation_code => g_template_leg_code,
5504: p_mode => v_del_mode);
5505:
5512: -- Hours Balance
5513: IF p_ele_info_12 IS NOT NULL THEN
5514:
5515: hr_utility.set_location('pyusuiet', 1262);
5516: hr_balances.del_balance_type_cascade (
5517: p_balance_type_id => fnd_number.canonical_to_number(p_ele_info_12),
5518: p_legislation_code => g_template_leg_code,
5519: p_mode => v_del_mode);
5520:
5542: where balance_name = v_negearn_bal_name and
5543: business_group_id + 0 = p_business_group_id ;
5544:
5545: hr_utility.set_location('pyusuiet',164);
5546: hr_balances.del_balance_type_cascade (
5547: p_balance_type_id => v_negearn_bal_type_id,
5548: p_legislation_code => g_template_leg_code,
5549: p_mode => v_del_mode);
5550:
5574: where balance_name = v_addl_bal_name and
5575: business_group_id + 0 = p_business_group_id ;
5576:
5577: hr_utility.set_location('pyusuiet',1268);
5578: hr_balances.del_balance_type_cascade (
5579: p_balance_type_id => v_addl_bal_type_id,
5580: p_legislation_code => g_template_leg_code,
5581: p_mode => v_del_mode);
5582:
5607: where balance_name = v_repl_bal_name and
5608: business_group_id + 0 = p_business_group_id ;
5609:
5610: hr_utility.set_location('pyusuiet',1275);
5611: hr_balances.del_balance_type_cascade (
5612: p_balance_type_id => v_repl_bal_type_id,
5613: p_legislation_code => g_template_leg_code,
5614: p_mode => v_del_mode);
5615: