DBA Data[Home] [Help]

APPS.PAY_JP_ISDF_SS_PKG dependencies on PAY_JP_ISDF_DML_PKG

Line 1096: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);

1092: hr_utility.set_location(l_proc,10);
1093: hr_utility.trace('submission_date : '||fnd_date.date_to_canonical(l_submission_date));
1094: end if;
1095: --
1096: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
1097: --
1098: if l_assact_rec.transaction_status not in ('U', 'N') then
1099: fnd_message.set_name('PAY','PAY_JP_DEF_INVALID_TXN_STATUS');
1100: fnd_message.raise_error;

Line 1166: --pay_jp_isdf_dml_pkg.update_assact(

1162: --
1163: p_object_version_number := l_assact_rec.object_version_number + 1;
1164: --
1165: --api is disable because assact has been locked.
1166: --pay_jp_isdf_dml_pkg.update_assact(
1167: -- p_action_information_id => l_assact_rec.assignment_action_id,
1168: -- p_object_version_number => p_object_version_number,
1169: -- p_transaction_status => 'N',
1170: -- p_finalized_date => l_assact_rec.finalized_date,

Line 1212: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);

1208: hr_utility.set_location(l_proc,10);
1209: hr_utility.trace('submission_date : '||fnd_date.date_to_canonical(l_submission_date));
1210: end if;
1211: --
1212: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
1213: --
1214: if l_assact_rec.transaction_status <> 'N' then
1215: fnd_message.set_name('PAY','PAY_JP_DEF_INVALID_TXN_STATUS');
1216: fnd_message.raise_error;

Line 1231: --pay_jp_isdf_dml_pkg.update_assact(

1227: --
1228: p_object_version_number := l_assact_rec.object_version_number + 1;
1229: --
1230: --api is disable because assact has been locked.
1231: --pay_jp_isdf_dml_pkg.update_assact(
1232: -- p_action_information_id => l_assact_rec.assignment_action_id,
1233: -- p_object_version_number => p_object_version_number,
1234: -- p_transaction_status => l_assact_rec.transaction_status,
1235: -- p_finalized_date => l_assact_rec.finalized_date,

Line 2598: pay_jp_isdf_dml_pkg.create_calc_dct(

2594: select pay_action_information_s.nextval
2595: into l_action_information_id
2596: from dual;
2597: --
2598: pay_jp_isdf_dml_pkg.create_calc_dct(
2599: p_action_information_id => l_action_information_id,
2600: p_assignment_action_id => l_assact_rec.assignment_action_id,
2601: p_action_context_type => 'AAP',
2602: p_assignment_id => l_assact_rec.assignment_id,

Line 2639: pay_jp_isdf_dml_pkg.update_calc_dct(

2635: l_action_information_id := l_csr_calc_dct.action_information_id;
2636: l_object_version_number := l_csr_calc_dct.object_version_number;
2637: --
2638: -- calc_dct is always insert mode because no initial archive data.
2639: pay_jp_isdf_dml_pkg.update_calc_dct(
2640: p_action_information_id => l_action_information_id,
2641: p_object_version_number => l_object_version_number,
2642: p_status => 'I',
2643: p_life_gen_ins_prem => l_calc_dct_rec.life_gen_ins_prem,

Line 2729: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);

2725: hr_utility.set_location(l_proc,10);
2726: hr_utility.trace('submission_date : '||fnd_date.date_to_canonical(l_submission_date));
2727: end if;
2728: --
2729: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
2730: --
2731: if l_assact_rec.transaction_status <> 'N' then
2732: fnd_message.set_name('PAY','PAY_JP_DEF_INVALID_TXN_STATUS');
2733: fnd_message.raise_error;

Line 2758: pay_jp_isdf_dml_pkg.create_calc_dct(

2754: select pay_action_information_s.nextval
2755: into l_action_information_id
2756: from dual;
2757: --
2758: pay_jp_isdf_dml_pkg.create_calc_dct(
2759: p_action_information_id => l_action_information_id,
2760: p_assignment_action_id => l_assact_rec.assignment_action_id,
2761: p_action_context_type => 'AAP',
2762: p_assignment_id => l_assact_rec.assignment_id,

Line 2799: pay_jp_isdf_dml_pkg.update_calc_dct(

2795: l_action_information_id := l_csr_calc_dct.action_information_id;
2796: l_object_version_number := l_csr_calc_dct.object_version_number;
2797: --
2798: -- calc_dct is always insert mode because no initial archive data.
2799: pay_jp_isdf_dml_pkg.update_calc_dct(
2800: p_action_information_id => l_action_information_id,
2801: p_object_version_number => l_object_version_number,
2802: p_status => 'I',
2803: p_life_gen_ins_prem => l_calc_dct_rec.life_gen_ins_prem,

Line 2847: pay_jp_isdf_dml_pkg.create_entry(

2843: select pay_action_information_s.nextval
2844: into l_action_information_id
2845: from dual;
2846: --
2847: pay_jp_isdf_dml_pkg.create_entry(
2848: p_action_information_id => l_action_information_id,
2849: p_assignment_action_id => l_assact_rec.assignment_action_id,
2850: p_action_context_type => 'AAP',
2851: p_assignment_id => l_assact_rec.assignment_id,

Line 2896: pay_jp_isdf_dml_pkg.update_entry(

2892: --
2893: if l_csr_entry.ins_element_entry_id is not null
2894: or l_csr_entry.is_element_entry_id is not null then
2895: --
2896: pay_jp_isdf_dml_pkg.update_entry(
2897: p_action_information_id => l_action_information_id,
2898: p_object_version_number => l_object_version_number,
2899: p_status => 'Q',
2900: p_life_gen_ins_prem => l_calc_dct_rec.life_gen_ins_prem,

Line 2921: pay_jp_isdf_dml_pkg.update_entry(

2917: p_national_pens_ins_prem_o => l_csr_entry.national_pens_ins_prem);
2918: --
2919: else
2920: --
2921: pay_jp_isdf_dml_pkg.update_entry(
2922: p_action_information_id => l_action_information_id,
2923: p_object_version_number => l_object_version_number,
2924: p_status => 'I',
2925: p_life_gen_ins_prem => l_calc_dct_rec.life_gen_ins_prem,

Line 2964: --pay_jp_isdf_dml_pkg.update_assact(

2960: --
2961: p_object_version_number := l_assact_rec.object_version_number + 1;
2962: --
2963: --api is disable because assact has been locked.
2964: --pay_jp_isdf_dml_pkg.update_assact(
2965: -- p_action_information_id => l_assact_rec.assignment_action_id,
2966: -- p_object_version_number => p_object_version_number,
2967: -- p_transaction_status => 'F',
2968: -- p_finalized_date => fnd_date.date_to_canonical(l_submission_date),

Line 3016: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);

3012: hr_utility.set_location(l_proc,10);
3013: hr_utility.trace('submission_date : '||fnd_date.date_to_canonical(l_submission_date));
3014: end if;
3015: --
3016: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
3017: --
3018: if l_assact_rec.transaction_status not in ('F', 'A') then
3019: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
3020: fnd_message.raise_error;

Line 3051: --pay_jp_isdf_dml_pkg.update_assact(

3047: --
3048: p_object_version_number := l_assact_rec.object_version_number + 1;
3049: --
3050: --api is disable because assact has been locked.
3051: --pay_jp_isdf_dml_pkg.update_assact(
3052: -- p_action_information_id => l_assact_rec.assignment_action_id,
3053: -- p_object_version_number => p_object_version_number,
3054: -- p_transaction_status => 'U',
3055: -- p_finalized_date => null,

Line 3103: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);

3099: hr_utility.set_location(l_proc,10);
3100: hr_utility.trace('submission_date : '||fnd_date.date_to_canonical(l_submission_date));
3101: end if;
3102: --
3103: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
3104: --
3105: if l_assact_rec.transaction_status not in ('F', 'A') then
3106: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
3107: fnd_message.raise_error;

Line 3132: --pay_jp_isdf_dml_pkg.update_assact(

3128: --
3129: p_object_version_number := l_assact_rec.object_version_number + 1;
3130: --
3131: --api is disable because assact has been locked.
3132: --pay_jp_isdf_dml_pkg.update_assact(
3133: -- p_action_information_id => l_assact_rec.assignment_action_id,
3134: -- p_object_version_number => p_object_version_number,
3135: -- p_transaction_status => 'N',
3136: -- p_finalized_date => null,

Line 3175: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);

3171: if g_debug then
3172: hr_utility.set_location(l_proc,0);
3173: end if;
3174: --
3175: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
3176: --
3177: if l_assact_rec.transaction_status <> 'F' then
3178: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
3179: fnd_message.raise_error;

Line 3201: --pay_jp_isdf_dml_pkg.update_assact(

3197: --
3198: p_object_version_number := l_assact_rec.object_version_number + 1;
3199: --
3200: --api is disable because assact has been locked.
3201: --pay_jp_isdf_dml_pkg.update_assact(
3202: -- p_action_information_id => l_assact_rec.assignment_action_id,
3203: -- p_object_version_number => p_object_version_number,
3204: -- p_transaction_status => 'A',
3205: -- p_finalized_date => l_assact_rec.finalized_date,

Line 4487: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);

4483: end if;
4484: --
4485: hr_api.mandatory_arg_error(l_proc, 'transfer_date', p_transfer_date);
4486: --
4487: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
4488: --
4489: if l_assact_rec.transaction_status <> 'A' then
4490: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
4491: fnd_message.raise_error;

Line 4604: --pay_jp_isdf_dml_pkg.update_assact(

4600: --
4601: p_object_version_number := l_assact_rec.object_version_number + 1;
4602: --
4603: --api is disable because assact has been locked.
4604: --pay_jp_isdf_dml_pkg.update_assact(
4605: -- p_action_information_id => l_assact_rec.assignment_action_id,
4606: -- p_object_version_number => p_object_version_number,
4607: -- p_transaction_status => l_assact_rec.transaction_status,
4608: -- p_finalized_date => l_assact_rec.finalized_date,

Line 4684: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);

4680: end if;
4681: --
4682: hr_api.mandatory_arg_error(l_proc,'expiry_date',p_expiry_date);
4683: --
4684: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
4685: --
4686: if l_assact_rec.transaction_status = 'U' then
4687: fnd_message.set_name('PAY', 'PAY_JP_DEF_NOT_TRANSFERRED_YET');
4688: fnd_message.raise_error;

Line 4808: --pay_jp_isdf_dml_pkg.update_assact(

4804: --
4805: p_object_version_number := l_assact_rec.object_version_number + 1;
4806: --
4807: --api is disable because assact has been locked.
4808: --pay_jp_isdf_dml_pkg.update_assact(
4809: -- p_action_information_id => l_assact_rec.assignment_action_id,
4810: -- p_object_version_number => p_object_version_number,
4811: -- p_transaction_status => l_assact_rec.transaction_status,
4812: -- p_finalized_date => l_assact_rec.finalized_date,