DBA Data[Home] [Help]

APPS.PAY_BALANCE_PKG dependencies on PAY_CORE_UTILS

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

4610: elsif (l_cnt = 1) then
4611: p_found := l_found;
4612: p_balance_value := l_balance_value;
4613: else
4614: pay_core_utils.assert_condition('get_new_latest_bal_value:1', false);
4615: end if;
4616: --
4617: end get_new_latest_bal_value;
4618: --

Line 4651: pay_core_utils.get_upgrade_status(l_business_group_id,

4647: pay_assignment_actions paa
4648: where ppa.payroll_action_id = paa.payroll_action_id
4649: and paa.assignment_action_id = p_assignment_action_id;
4650: --
4651: pay_core_utils.get_upgrade_status(l_business_group_id,
4652: 'SINGLE_BAL_TABLE',
4653: l_status);
4654: --
4655: if (l_status = 'Y') then

Line 6616: pay_core_utils.get_leg_context_iv_name(p_context_name,

6612: -- hr_utility.trace('entering find_context. p_context_name:'||p_context_name);
6613:
6614: get_run_result_info(p_context_id, l_rr_rec);
6615: --
6616: pay_core_utils.get_leg_context_iv_name(p_context_name,
6617: l_rr_rec.legislation_code,
6618: l_inp_val_name,
6619: l_found
6620: );

Line 7181: pay_core_utils.get_leg_context_iv_name('SOURCE_ID',

7177: g_sn2_needed_chr := 'N';
7178: g_org_needed_chr := 'N';
7179: for bgrec in get_bg(p_payroll_action_id) loop
7180: --
7181: pay_core_utils.get_leg_context_iv_name('SOURCE_ID',
7182: bgrec.legislation_code,
7183: l_inp_val_name,
7184: l_found
7185: );

Line 7190: pay_core_utils.get_leg_context_iv_name('SOURCE_TEXT',

7186: if (l_found = TRUE) then
7187: g_si_needed_chr := 'Y';
7188: end if;
7189: --
7190: pay_core_utils.get_leg_context_iv_name('SOURCE_TEXT',
7191: bgrec.legislation_code,
7192: l_inp_val_name,
7193: l_found
7194: );

Line 7199: pay_core_utils.get_leg_context_iv_name('SOURCE_NUMBER',

7195: if (l_found = TRUE) then
7196: g_st_needed_chr := 'Y';
7197: end if;
7198: --
7199: pay_core_utils.get_leg_context_iv_name('SOURCE_NUMBER',
7200: bgrec.legislation_code,
7201: l_inp_val_name,
7202: l_found
7203: );

Line 7208: pay_core_utils.get_leg_context_iv_name('SOURCE_TEXT2',

7204: if (l_found = TRUE) then
7205: g_sn_needed_chr := 'Y';
7206: end if;
7207: --
7208: pay_core_utils.get_leg_context_iv_name('SOURCE_TEXT2',
7209: bgrec.legislation_code,
7210: l_inp_val_name,
7211: l_found
7212: );

Line 7217: pay_core_utils.get_leg_context_iv_name('SOURCE_NUMBER2',

7213: if (l_found = TRUE) then
7214: g_st2_needed_chr := 'Y';
7215: end if;
7216: --
7217: pay_core_utils.get_leg_context_iv_name('SOURCE_NUMBER2',
7218: bgrec.legislation_code,
7219: l_inp_val_name,
7220: l_found
7221: );

Line 7226: pay_core_utils.get_leg_context_iv_name('ORGANIZATION_ID',

7222: if (l_found = TRUE) then
7223: g_sn2_needed_chr := 'Y';
7224: end if;
7225: --
7226: pay_core_utils.get_leg_context_iv_name('ORGANIZATION_ID',
7227: bgrec.legislation_code,
7228: l_inp_val_name,
7229: l_found
7230: );

Line 7888: pay_core_utils.get_legislation_rule

7884:
7885: --
7886: -- Check SAVE_ASG_RUN_BAL legislation rule.
7887: --
7888: pay_core_utils.get_legislation_rule
7889: (p_legrul_name => 'SAVE_ASG_RUN_BAL'
7890: ,p_legislation => l_rr_info.legislation_code
7891: ,p_legrul_value => l_save_run_bal_flag
7892: ,p_found => l_legrule_found

Line 8138: pay_core_utils.get_leg_context_iv_name('SOURCE_ID',

8134: l_sn2_needed_chr := 'N';
8135: l_org_needed_chr := 'N';
8136: for bgrec in get_bg(p_asgact_id) loop
8137: --
8138: pay_core_utils.get_leg_context_iv_name('SOURCE_ID',
8139: bgrec.legislation_code,
8140: l_inp_val_name,
8141: l_found
8142: );

Line 8147: pay_core_utils.get_leg_context_iv_name('SOURCE_TEXT',

8143: if (l_found = TRUE) then
8144: l_si_needed_chr := 'Y';
8145: end if;
8146: --
8147: pay_core_utils.get_leg_context_iv_name('SOURCE_TEXT',
8148: bgrec.legislation_code,
8149: l_inp_val_name,
8150: l_found
8151: );

Line 8156: pay_core_utils.get_leg_context_iv_name('SOURCE_NUMBER',

8152: if (l_found = TRUE) then
8153: l_st_needed_chr := 'Y';
8154: end if;
8155: --
8156: pay_core_utils.get_leg_context_iv_name('SOURCE_NUMBER',
8157: bgrec.legislation_code,
8158: l_inp_val_name,
8159: l_found
8160: );

Line 8165: pay_core_utils.get_leg_context_iv_name('SOURCE_TEXT2',

8161: if (l_found = TRUE) then
8162: l_sn_needed_chr := 'Y';
8163: end if;
8164: --
8165: pay_core_utils.get_leg_context_iv_name('SOURCE_TEXT2',
8166: bgrec.legislation_code,
8167: l_inp_val_name,
8168: l_found
8169: );

Line 8174: pay_core_utils.get_leg_context_iv_name('SOURCE_NUMBER2',

8170: if (l_found = TRUE) then
8171: l_st2_needed_chr := 'Y';
8172: end if;
8173: --
8174: pay_core_utils.get_leg_context_iv_name('SOURCE_NUMBER2',
8175: bgrec.legislation_code,
8176: l_inp_val_name,
8177: l_found
8178: );

Line 8183: pay_core_utils.get_leg_context_iv_name('ORGANIZATION_ID',

8179: if (l_found = TRUE) then
8180: l_sn2_needed_chr := 'Y';
8181: end if;
8182: --
8183: pay_core_utils.get_leg_context_iv_name('ORGANIZATION_ID',
8184: bgrec.legislation_code,
8185: l_inp_val_name,
8186: l_found
8187: );

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

8961: end loop;
8962: --
8963: else -- p_load_type <> TRUSTED
8964: --
8965: pay_core_utils.assert_condition('create_all_grp_balances_full:1', false);
8966: end if;
8967: else -- p_delta is Y thus in Delta mode
8968: --
8969: if g_debug then

Line 9033: pay_core_utils.get_leg_context_iv_name('SOURCE_ID',

9029: l_sn2_needed_chr := 'N';
9030: l_org_needed_chr := 'N';
9031: for bgrec in get_bg(p_pact_id) loop
9032: --
9033: pay_core_utils.get_leg_context_iv_name('SOURCE_ID',
9034: bgrec.legislation_code,
9035: l_inp_val_name,
9036: l_found
9037: );

Line 9042: pay_core_utils.get_leg_context_iv_name('SOURCE_TEXT',

9038: if (l_found = TRUE) then
9039: l_si_needed_chr := 'Y';
9040: end if;
9041: --
9042: pay_core_utils.get_leg_context_iv_name('SOURCE_TEXT',
9043: bgrec.legislation_code,
9044: l_inp_val_name,
9045: l_found
9046: );

Line 9051: pay_core_utils.get_leg_context_iv_name('SOURCE_NUMBER',

9047: if (l_found = TRUE) then
9048: l_st_needed_chr := 'Y';
9049: end if;
9050: --
9051: pay_core_utils.get_leg_context_iv_name('SOURCE_NUMBER',
9052: bgrec.legislation_code,
9053: l_inp_val_name,
9054: l_found
9055: );

Line 9060: pay_core_utils.get_leg_context_iv_name('SOURCE_TEXT2',

9056: if (l_found = TRUE) then
9057: l_sn_needed_chr := 'Y';
9058: end if;
9059: --
9060: pay_core_utils.get_leg_context_iv_name('SOURCE_TEXT2',
9061: bgrec.legislation_code,
9062: l_inp_val_name,
9063: l_found
9064: );

Line 9069: pay_core_utils.get_leg_context_iv_name('SOURCE_NUMBER2',

9065: if (l_found = TRUE) then
9066: l_st2_needed_chr := 'Y';
9067: end if;
9068: --
9069: pay_core_utils.get_leg_context_iv_name('SOURCE_NUMBER2',
9070: bgrec.legislation_code,
9071: l_inp_val_name,
9072: l_found
9073: );

Line 9078: pay_core_utils.get_leg_context_iv_name('ORGANIZATION_ID',

9074: if (l_found = TRUE) then
9075: l_sn2_needed_chr := 'Y';
9076: end if;
9077: --
9078: pay_core_utils.get_leg_context_iv_name('ORGANIZATION_ID',
9079: bgrec.legislation_code,
9080: l_inp_val_name,
9081: l_found
9082: );

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

9862: );
9863: --
9864: else -- p_load_type <> TRUSTED
9865: --
9866: pay_core_utils.assert_condition('create_all_asg_balances_full:1', false);
9867: end if;
9868: else -- p_delta is Y thus in DELTA mode
9869: --
9870: if g_debug then

Line 9936: pay_core_utils.get_leg_context_iv_name('SOURCE_ID',

9932: l_sn2_needed_chr := 'N';
9933: l_org_needed_chr := 'N';
9934: for bgrec in get_bg(p_asgact_id) loop
9935: --
9936: pay_core_utils.get_leg_context_iv_name('SOURCE_ID',
9937: bgrec.legislation_code,
9938: l_inp_val_name,
9939: l_found
9940: );

Line 9945: pay_core_utils.get_leg_context_iv_name('SOURCE_TEXT',

9941: if (l_found = TRUE) then
9942: l_si_needed_chr := 'Y';
9943: end if;
9944: --
9945: pay_core_utils.get_leg_context_iv_name('SOURCE_TEXT',
9946: bgrec.legislation_code,
9947: l_inp_val_name,
9948: l_found
9949: );

Line 9954: pay_core_utils.get_leg_context_iv_name('SOURCE_NUMBER',

9950: if (l_found = TRUE) then
9951: l_st_needed_chr := 'Y';
9952: end if;
9953: --
9954: pay_core_utils.get_leg_context_iv_name('SOURCE_NUMBER',
9955: bgrec.legislation_code,
9956: l_inp_val_name,
9957: l_found
9958: );

Line 9963: pay_core_utils.get_leg_context_iv_name('SOURCE_TEXT2',

9959: if (l_found = TRUE) then
9960: l_sn_needed_chr := 'Y';
9961: end if;
9962: --
9963: pay_core_utils.get_leg_context_iv_name('SOURCE_TEXT2',
9964: bgrec.legislation_code,
9965: l_inp_val_name,
9966: l_found
9967: );

Line 9972: pay_core_utils.get_leg_context_iv_name('SOURCE_NUMBER2',

9968: if (l_found = TRUE) then
9969: l_st2_needed_chr := 'Y';
9970: end if;
9971: --
9972: pay_core_utils.get_leg_context_iv_name('SOURCE_NUMBER2',
9973: bgrec.legislation_code,
9974: l_inp_val_name,
9975: l_found
9976: );

Line 9981: pay_core_utils.get_leg_context_iv_name('ORGANIZATION_ID',

9977: if (l_found = TRUE) then
9978: l_sn2_needed_chr := 'Y';
9979: end if;
9980: --
9981: pay_core_utils.get_leg_context_iv_name('ORGANIZATION_ID',
9982: bgrec.legislation_code,
9983: l_inp_val_name,
9984: l_found
9985: );

Line 10184: pay_core_utils.get_action_parameter('BAL_RETRIEVAL_BUFFER_SIZE',

10180: --
10181: l_balance_lst.delete;
10182: --
10183: /* Get the buffer size */
10184: pay_core_utils.get_action_parameter('BAL_RETRIEVAL_BUFFER_SIZE',
10185: l_param_value,
10186: l_found);
10187: if (l_found = TRUE) then
10188: bal_ret_buffer_sz := to_number(l_param_value);

Line 10372: pay_core_utils.get_leg_context_iv_name('SOURCE_ID',

10368: l_sn2_needed_chr := 'N';
10369: l_org_needed_chr := 'N';
10370: for bgrec in get_bg(p_pact_id) loop
10371: --
10372: pay_core_utils.get_leg_context_iv_name('SOURCE_ID',
10373: bgrec.legislation_code,
10374: l_inp_val_name,
10375: l_found
10376: );

Line 10381: pay_core_utils.get_leg_context_iv_name('SOURCE_TEXT',

10377: if (l_found = TRUE) then
10378: l_si_needed_chr := 'Y';
10379: end if;
10380: --
10381: pay_core_utils.get_leg_context_iv_name('SOURCE_TEXT',
10382: bgrec.legislation_code,
10383: l_inp_val_name,
10384: l_found
10385: );

Line 10390: pay_core_utils.get_leg_context_iv_name('SOURCE_NUMBER',

10386: if (l_found = TRUE) then
10387: l_st_needed_chr := 'Y';
10388: end if;
10389: --
10390: pay_core_utils.get_leg_context_iv_name('SOURCE_NUMBER',
10391: bgrec.legislation_code,
10392: l_inp_val_name,
10393: l_found
10394: );

Line 10399: pay_core_utils.get_leg_context_iv_name('SOURCE_TEXT2',

10395: if (l_found = TRUE) then
10396: l_sn_needed_chr := 'Y';
10397: end if;
10398: --
10399: pay_core_utils.get_leg_context_iv_name('SOURCE_TEXT2',
10400: bgrec.legislation_code,
10401: l_inp_val_name,
10402: l_found
10403: );

Line 10408: pay_core_utils.get_leg_context_iv_name('SOURCE_NUMBER2',

10404: if (l_found = TRUE) then
10405: l_st2_needed_chr := 'Y';
10406: end if;
10407: --
10408: pay_core_utils.get_leg_context_iv_name('SOURCE_NUMBER2',
10409: bgrec.legislation_code,
10410: l_inp_val_name,
10411: l_found
10412: );

Line 10417: pay_core_utils.get_leg_context_iv_name('ORGANIZATION_ID',

10413: if (l_found = TRUE) then
10414: l_sn2_needed_chr := 'Y';
10415: end if;
10416: --
10417: pay_core_utils.get_leg_context_iv_name('ORGANIZATION_ID',
10418: bgrec.legislation_code,
10419: l_inp_val_name,
10420: l_found
10421: );

Line 10644: pay_core_utils.get_action_parameter('BAL_RETRIEVAL_BUFFER_SIZE',

10640: --
10641: l_balance_lst.delete;
10642: --
10643: /* Get the buffer size */
10644: pay_core_utils.get_action_parameter('BAL_RETRIEVAL_BUFFER_SIZE',
10645: l_param_value,
10646: l_found);
10647: if (l_found = TRUE) then
10648: bal_ret_buffer_sz := to_number(l_param_value);

Line 11190: pay_core_utils.get_leg_context_iv_name('SOURCE_ID'

11186: hr_utility.set_location('hrassact.reversal', 80);
11187: end if;
11188: --
11189: hr_utility.trace('leg_code: '||leg_code);
11190: pay_core_utils.get_leg_context_iv_name('SOURCE_ID'
11191: ,leg_code
11192: ,l_src_iv
11193: ,l_iv_found);
11194: if (not l_iv_found) then

Line 11201: pay_core_utils.get_leg_context_iv_name('SOURCE_NUMBER'

11197: l_si_needed := 'Y';
11198: hr_utility.trace('l_src_iv: '||l_src_iv);
11199: end if;
11200: --
11201: pay_core_utils.get_leg_context_iv_name('SOURCE_NUMBER'
11202: ,leg_code
11203: ,l_src_num
11204: ,l_num_found);
11205: if (not l_num_found) then

Line 11212: pay_core_utils.get_leg_context_iv_name('SOURCE_NUMBER2'

11208: l_sn_needed := 'Y';
11209: hr_utility.trace('l_src_num: '||l_src_num);
11210: end if;
11211: --
11212: pay_core_utils.get_leg_context_iv_name('SOURCE_NUMBER2'
11213: ,leg_code
11214: ,l_src_num2
11215: ,l_num_found);
11216: if (not l_num_found) then

Line 11222: pay_core_utils.get_leg_context_iv_name('ORGANIZATION_ID'

11218: else
11219: l_sn2_needed := 'Y';
11220: hr_utility.trace('l_src_num2: '||l_src_num2);
11221: end if;
11222: pay_core_utils.get_leg_context_iv_name('ORGANIZATION_ID'
11223: ,leg_code
11224: ,l_org_id_iv
11225: ,l_num_found);
11226: if (not l_num_found) then

Line 11233: pay_core_utils.get_leg_context_iv_name('SOURCE_TEXT',

11229: l_org_needed := 'Y';
11230: hr_utility.trace('l_org_id_iv: '||l_org_id_iv);
11231: end if;
11232:
11233: pay_core_utils.get_leg_context_iv_name('SOURCE_TEXT',
11234: leg_code,
11235: l_inp_val_name,
11236: l_found
11237: );

Line 11242: pay_core_utils.get_leg_context_iv_name('SOURCE_TEXT2',

11238: if (l_found = TRUE) then
11239: l_st_needed := 'Y';
11240: end if;
11241:
11242: pay_core_utils.get_leg_context_iv_name('SOURCE_TEXT2',
11243: leg_code,
11244: l_inp_val_name,
11245: l_found
11246: );