DBA Data[Home] [Help]

APPS.PAY_BALANCE_PKG dependencies on PAY_CORE_UTILS

Line 4317: pay_core_utils.assert_condition('get_new_latest_bal_value:1', false);

4313: elsif (l_cnt = 1) then
4314: p_found := l_found;
4315: p_balance_value := l_balance_value;
4316: else
4317: pay_core_utils.assert_condition('get_new_latest_bal_value:1', false);
4318: end if;
4319: --
4320: end get_new_latest_bal_value;
4321: --

Line 4354: pay_core_utils.get_upgrade_status(l_business_group_id,

4350: pay_assignment_actions paa
4351: where ppa.payroll_action_id = paa.payroll_action_id
4352: and paa.assignment_action_id = p_assignment_action_id;
4353: --
4354: pay_core_utils.get_upgrade_status(l_business_group_id,
4355: 'SINGLE_BAL_TABLE',
4356: l_status);
4357: --
4358: if (l_status = 'Y') then

Line 6162: pay_core_utils.get_leg_context_iv_name(p_context_name,

6158: begin
6159: --
6160: get_run_result_info(p_context_id, l_rr_rec);
6161: --
6162: pay_core_utils.get_leg_context_iv_name(p_context_name,
6163: l_rr_rec.legislation_code,
6164: l_inp_val_name,
6165: l_found
6166: );

Line 6687: pay_core_utils.get_leg_context_iv_name('SOURCE_ID',

6683: g_sn2_needed_chr := 'N';
6684: g_org_needed_chr := 'N';
6685: for bgrec in get_bg(p_payroll_action_id) loop
6686: --
6687: pay_core_utils.get_leg_context_iv_name('SOURCE_ID',
6688: bgrec.legislation_code,
6689: l_inp_val_name,
6690: l_found
6691: );

Line 6696: pay_core_utils.get_leg_context_iv_name('SOURCE_TEXT',

6692: if (l_found = TRUE) then
6693: g_si_needed_chr := 'Y';
6694: end if;
6695: --
6696: pay_core_utils.get_leg_context_iv_name('SOURCE_TEXT',
6697: bgrec.legislation_code,
6698: l_inp_val_name,
6699: l_found
6700: );

Line 6705: pay_core_utils.get_leg_context_iv_name('SOURCE_NUMBER',

6701: if (l_found = TRUE) then
6702: g_st_needed_chr := 'Y';
6703: end if;
6704: --
6705: pay_core_utils.get_leg_context_iv_name('SOURCE_NUMBER',
6706: bgrec.legislation_code,
6707: l_inp_val_name,
6708: l_found
6709: );

Line 6714: pay_core_utils.get_leg_context_iv_name('SOURCE_TEXT2',

6710: if (l_found = TRUE) then
6711: g_sn_needed_chr := 'Y';
6712: end if;
6713: --
6714: pay_core_utils.get_leg_context_iv_name('SOURCE_TEXT2',
6715: bgrec.legislation_code,
6716: l_inp_val_name,
6717: l_found
6718: );

Line 6723: pay_core_utils.get_leg_context_iv_name('SOURCE_NUMBER2',

6719: if (l_found = TRUE) then
6720: g_st2_needed_chr := 'Y';
6721: end if;
6722: --
6723: pay_core_utils.get_leg_context_iv_name('SOURCE_NUMBER2',
6724: bgrec.legislation_code,
6725: l_inp_val_name,
6726: l_found
6727: );

Line 6732: pay_core_utils.get_leg_context_iv_name('ORGANIZATION_ID',

6728: if (l_found = TRUE) then
6729: g_sn2_needed_chr := 'Y';
6730: end if;
6731: --
6732: pay_core_utils.get_leg_context_iv_name('ORGANIZATION_ID',
6733: bgrec.legislation_code,
6734: l_inp_val_name,
6735: l_found
6736: );

Line 7315: pay_core_utils.get_legislation_rule

7311:
7312: --
7313: -- Check SAVE_ASG_RUN_BAL legislation rule.
7314: --
7315: pay_core_utils.get_legislation_rule
7316: (p_legrul_name => 'SAVE_ASG_RUN_BAL'
7317: ,p_legislation => l_rr_info.legislation_code
7318: ,p_legrul_value => l_save_run_bal_flag
7319: ,p_found => l_legrule_found

Line 7565: pay_core_utils.get_leg_context_iv_name('SOURCE_ID',

7561: l_sn2_needed_chr := 'N';
7562: l_org_needed_chr := 'N';
7563: for bgrec in get_bg(p_asgact_id) loop
7564: --
7565: pay_core_utils.get_leg_context_iv_name('SOURCE_ID',
7566: bgrec.legislation_code,
7567: l_inp_val_name,
7568: l_found
7569: );

Line 7574: pay_core_utils.get_leg_context_iv_name('SOURCE_TEXT',

7570: if (l_found = TRUE) then
7571: l_si_needed_chr := 'Y';
7572: end if;
7573: --
7574: pay_core_utils.get_leg_context_iv_name('SOURCE_TEXT',
7575: bgrec.legislation_code,
7576: l_inp_val_name,
7577: l_found
7578: );

Line 7583: pay_core_utils.get_leg_context_iv_name('SOURCE_NUMBER',

7579: if (l_found = TRUE) then
7580: l_st_needed_chr := 'Y';
7581: end if;
7582: --
7583: pay_core_utils.get_leg_context_iv_name('SOURCE_NUMBER',
7584: bgrec.legislation_code,
7585: l_inp_val_name,
7586: l_found
7587: );

Line 7592: pay_core_utils.get_leg_context_iv_name('SOURCE_TEXT2',

7588: if (l_found = TRUE) then
7589: l_sn_needed_chr := 'Y';
7590: end if;
7591: --
7592: pay_core_utils.get_leg_context_iv_name('SOURCE_TEXT2',
7593: bgrec.legislation_code,
7594: l_inp_val_name,
7595: l_found
7596: );

Line 7601: pay_core_utils.get_leg_context_iv_name('SOURCE_NUMBER2',

7597: if (l_found = TRUE) then
7598: l_st2_needed_chr := 'Y';
7599: end if;
7600: --
7601: pay_core_utils.get_leg_context_iv_name('SOURCE_NUMBER2',
7602: bgrec.legislation_code,
7603: l_inp_val_name,
7604: l_found
7605: );

Line 7610: pay_core_utils.get_leg_context_iv_name('ORGANIZATION_ID',

7606: if (l_found = TRUE) then
7607: l_sn2_needed_chr := 'Y';
7608: end if;
7609: --
7610: pay_core_utils.get_leg_context_iv_name('ORGANIZATION_ID',
7611: bgrec.legislation_code,
7612: l_inp_val_name,
7613: l_found
7614: );

Line 8338: pay_core_utils.assert_condition('create_all_grp_balances_full:1', false);

8334: end loop;
8335: --
8336: else -- p_load_type <> TRUSTED
8337: --
8338: pay_core_utils.assert_condition('create_all_grp_balances_full:1', false);
8339: end if;
8340: else -- p_delta is Y thus in Delta mode
8341: --
8342: if g_debug then

Line 8406: pay_core_utils.get_leg_context_iv_name('SOURCE_ID',

8402: l_sn2_needed_chr := 'N';
8403: l_org_needed_chr := 'N';
8404: for bgrec in get_bg(p_pact_id) loop
8405: --
8406: pay_core_utils.get_leg_context_iv_name('SOURCE_ID',
8407: bgrec.legislation_code,
8408: l_inp_val_name,
8409: l_found
8410: );

Line 8415: pay_core_utils.get_leg_context_iv_name('SOURCE_TEXT',

8411: if (l_found = TRUE) then
8412: l_si_needed_chr := 'Y';
8413: end if;
8414: --
8415: pay_core_utils.get_leg_context_iv_name('SOURCE_TEXT',
8416: bgrec.legislation_code,
8417: l_inp_val_name,
8418: l_found
8419: );

Line 8424: pay_core_utils.get_leg_context_iv_name('SOURCE_NUMBER',

8420: if (l_found = TRUE) then
8421: l_st_needed_chr := 'Y';
8422: end if;
8423: --
8424: pay_core_utils.get_leg_context_iv_name('SOURCE_NUMBER',
8425: bgrec.legislation_code,
8426: l_inp_val_name,
8427: l_found
8428: );

Line 8433: pay_core_utils.get_leg_context_iv_name('SOURCE_TEXT2',

8429: if (l_found = TRUE) then
8430: l_sn_needed_chr := 'Y';
8431: end if;
8432: --
8433: pay_core_utils.get_leg_context_iv_name('SOURCE_TEXT2',
8434: bgrec.legislation_code,
8435: l_inp_val_name,
8436: l_found
8437: );

Line 8442: pay_core_utils.get_leg_context_iv_name('SOURCE_NUMBER2',

8438: if (l_found = TRUE) then
8439: l_st2_needed_chr := 'Y';
8440: end if;
8441: --
8442: pay_core_utils.get_leg_context_iv_name('SOURCE_NUMBER2',
8443: bgrec.legislation_code,
8444: l_inp_val_name,
8445: l_found
8446: );

Line 8451: pay_core_utils.get_leg_context_iv_name('ORGANIZATION_ID',

8447: if (l_found = TRUE) then
8448: l_sn2_needed_chr := 'Y';
8449: end if;
8450: --
8451: pay_core_utils.get_leg_context_iv_name('ORGANIZATION_ID',
8452: bgrec.legislation_code,
8453: l_inp_val_name,
8454: l_found
8455: );

Line 9179: pay_core_utils.assert_condition('create_all_asg_balances_full:1', false);

9175: end loop;
9176: --
9177: else -- p_load_type <> TRUSTED
9178: --
9179: pay_core_utils.assert_condition('create_all_asg_balances_full:1', false);
9180: end if;
9181: else -- p_delta is Y thus in DELTA mode
9182: --
9183: if g_debug then

Line 9249: pay_core_utils.get_leg_context_iv_name('SOURCE_ID',

9245: l_sn2_needed_chr := 'N';
9246: l_org_needed_chr := 'N';
9247: for bgrec in get_bg(p_asgact_id) loop
9248: --
9249: pay_core_utils.get_leg_context_iv_name('SOURCE_ID',
9250: bgrec.legislation_code,
9251: l_inp_val_name,
9252: l_found
9253: );

Line 9258: pay_core_utils.get_leg_context_iv_name('SOURCE_TEXT',

9254: if (l_found = TRUE) then
9255: l_si_needed_chr := 'Y';
9256: end if;
9257: --
9258: pay_core_utils.get_leg_context_iv_name('SOURCE_TEXT',
9259: bgrec.legislation_code,
9260: l_inp_val_name,
9261: l_found
9262: );

Line 9267: pay_core_utils.get_leg_context_iv_name('SOURCE_NUMBER',

9263: if (l_found = TRUE) then
9264: l_st_needed_chr := 'Y';
9265: end if;
9266: --
9267: pay_core_utils.get_leg_context_iv_name('SOURCE_NUMBER',
9268: bgrec.legislation_code,
9269: l_inp_val_name,
9270: l_found
9271: );

Line 9276: pay_core_utils.get_leg_context_iv_name('SOURCE_TEXT2',

9272: if (l_found = TRUE) then
9273: l_sn_needed_chr := 'Y';
9274: end if;
9275: --
9276: pay_core_utils.get_leg_context_iv_name('SOURCE_TEXT2',
9277: bgrec.legislation_code,
9278: l_inp_val_name,
9279: l_found
9280: );

Line 9285: pay_core_utils.get_leg_context_iv_name('SOURCE_NUMBER2',

9281: if (l_found = TRUE) then
9282: l_st2_needed_chr := 'Y';
9283: end if;
9284: --
9285: pay_core_utils.get_leg_context_iv_name('SOURCE_NUMBER2',
9286: bgrec.legislation_code,
9287: l_inp_val_name,
9288: l_found
9289: );

Line 9294: pay_core_utils.get_leg_context_iv_name('ORGANIZATION_ID',

9290: if (l_found = TRUE) then
9291: l_sn2_needed_chr := 'Y';
9292: end if;
9293: --
9294: pay_core_utils.get_leg_context_iv_name('ORGANIZATION_ID',
9295: bgrec.legislation_code,
9296: l_inp_val_name,
9297: l_found
9298: );

Line 9477: pay_core_utils.get_action_parameter('BAL_RETRIEVAL_BUFFER_SIZE',

9473: --
9474: l_balance_lst.delete;
9475: --
9476: /* Get the buffer size */
9477: pay_core_utils.get_action_parameter('BAL_RETRIEVAL_BUFFER_SIZE',
9478: l_param_value,
9479: l_found);
9480: if (l_found = TRUE) then
9481: bal_ret_buffer_sz := to_number(l_param_value);

Line 9665: pay_core_utils.get_leg_context_iv_name('SOURCE_ID',

9661: l_sn2_needed_chr := 'N';
9662: l_org_needed_chr := 'N';
9663: for bgrec in get_bg(p_pact_id) loop
9664: --
9665: pay_core_utils.get_leg_context_iv_name('SOURCE_ID',
9666: bgrec.legislation_code,
9667: l_inp_val_name,
9668: l_found
9669: );

Line 9674: pay_core_utils.get_leg_context_iv_name('SOURCE_TEXT',

9670: if (l_found = TRUE) then
9671: l_si_needed_chr := 'Y';
9672: end if;
9673: --
9674: pay_core_utils.get_leg_context_iv_name('SOURCE_TEXT',
9675: bgrec.legislation_code,
9676: l_inp_val_name,
9677: l_found
9678: );

Line 9683: pay_core_utils.get_leg_context_iv_name('SOURCE_NUMBER',

9679: if (l_found = TRUE) then
9680: l_st_needed_chr := 'Y';
9681: end if;
9682: --
9683: pay_core_utils.get_leg_context_iv_name('SOURCE_NUMBER',
9684: bgrec.legislation_code,
9685: l_inp_val_name,
9686: l_found
9687: );

Line 9692: pay_core_utils.get_leg_context_iv_name('SOURCE_TEXT2',

9688: if (l_found = TRUE) then
9689: l_sn_needed_chr := 'Y';
9690: end if;
9691: --
9692: pay_core_utils.get_leg_context_iv_name('SOURCE_TEXT2',
9693: bgrec.legislation_code,
9694: l_inp_val_name,
9695: l_found
9696: );

Line 9701: pay_core_utils.get_leg_context_iv_name('SOURCE_NUMBER2',

9697: if (l_found = TRUE) then
9698: l_st2_needed_chr := 'Y';
9699: end if;
9700: --
9701: pay_core_utils.get_leg_context_iv_name('SOURCE_NUMBER2',
9702: bgrec.legislation_code,
9703: l_inp_val_name,
9704: l_found
9705: );

Line 9710: pay_core_utils.get_leg_context_iv_name('ORGANIZATION_ID',

9706: if (l_found = TRUE) then
9707: l_sn2_needed_chr := 'Y';
9708: end if;
9709: --
9710: pay_core_utils.get_leg_context_iv_name('ORGANIZATION_ID',
9711: bgrec.legislation_code,
9712: l_inp_val_name,
9713: l_found
9714: );

Line 9923: pay_core_utils.get_action_parameter('BAL_RETRIEVAL_BUFFER_SIZE',

9919: --
9920: l_balance_lst.delete;
9921: --
9922: /* Get the buffer size */
9923: pay_core_utils.get_action_parameter('BAL_RETRIEVAL_BUFFER_SIZE',
9924: l_param_value,
9925: l_found);
9926: if (l_found = TRUE) then
9927: bal_ret_buffer_sz := to_number(l_param_value);

Line 10467: pay_core_utils.get_leg_context_iv_name('SOURCE_ID'

10463: hr_utility.set_location('hrassact.reversal', 80);
10464: end if;
10465: --
10466: hr_utility.trace('leg_code: '||leg_code);
10467: pay_core_utils.get_leg_context_iv_name('SOURCE_ID'
10468: ,leg_code
10469: ,l_src_iv
10470: ,l_iv_found);
10471: if (not l_iv_found) then

Line 10478: pay_core_utils.get_leg_context_iv_name('SOURCE_NUMBER'

10474: l_si_needed := 'Y';
10475: hr_utility.trace('l_src_iv: '||l_src_iv);
10476: end if;
10477: --
10478: pay_core_utils.get_leg_context_iv_name('SOURCE_NUMBER'
10479: ,leg_code
10480: ,l_src_num
10481: ,l_num_found);
10482: if (not l_num_found) then

Line 10489: pay_core_utils.get_leg_context_iv_name('SOURCE_NUMBER2'

10485: l_sn_needed := 'Y';
10486: hr_utility.trace('l_src_num: '||l_src_num);
10487: end if;
10488: --
10489: pay_core_utils.get_leg_context_iv_name('SOURCE_NUMBER2'
10490: ,leg_code
10491: ,l_src_num2
10492: ,l_num_found);
10493: if (not l_num_found) then

Line 10499: pay_core_utils.get_leg_context_iv_name('ORGANIZATION_ID'

10495: else
10496: l_sn2_needed := 'Y';
10497: hr_utility.trace('l_src_num2: '||l_src_num2);
10498: end if;
10499: pay_core_utils.get_leg_context_iv_name('ORGANIZATION_ID'
10500: ,leg_code
10501: ,l_org_id_iv
10502: ,l_num_found);
10503: if (not l_num_found) then

Line 10510: pay_core_utils.get_leg_context_iv_name('SOURCE_TEXT',

10506: l_org_needed := 'Y';
10507: hr_utility.trace('l_org_id_iv: '||l_org_id_iv);
10508: end if;
10509:
10510: pay_core_utils.get_leg_context_iv_name('SOURCE_TEXT',
10511: leg_code,
10512: l_inp_val_name,
10513: l_found
10514: );

Line 10519: pay_core_utils.get_leg_context_iv_name('SOURCE_TEXT2',

10515: if (l_found = TRUE) then
10516: l_st_needed := 'Y';
10517: end if;
10518:
10519: pay_core_utils.get_leg_context_iv_name('SOURCE_TEXT2',
10520: leg_code,
10521: l_inp_val_name,
10522: l_found
10523: );