eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_JP_ISDF_SS_PKG dependencies on PAY_JP_ISDF_DML_PKG

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

1493: hr_utility.set_location(l_proc,10);
1494: hr_utility.trace('submission_date : '||fnd_date.date_to_canonical(l_submission_date));
1495: end if;
1496: --
1497: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
1498: --
1499: if l_assact_rec.transaction_status not in ('U', 'N') then
1500: fnd_message.set_name('PAY','PAY_JP_DEF_INVALID_TXN_STATUS');
1501: fnd_message.raise_error;

Line 1567: --pay_jp_isdf_dml_pkg.update_assact(

1563: --
1564: p_object_version_number := l_assact_rec.object_version_number + 1;
1565: --
1566: --api is disable because assact has been locked.
1567: --pay_jp_isdf_dml_pkg.update_assact(
1568: -- p_action_information_id => l_assact_rec.assignment_action_id,
1569: -- p_object_version_number => p_object_version_number,
1570: -- p_transaction_status => 'N',
1571: -- p_finalized_date => l_assact_rec.finalized_date,

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

1609: hr_utility.set_location(l_proc,10);
1610: hr_utility.trace('submission_date : '||fnd_date.date_to_canonical(l_submission_date));
1611: end if;
1612: --
1613: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
1614: --
1615: if l_assact_rec.transaction_status <> 'N' then
1616: fnd_message.set_name('PAY','PAY_JP_DEF_INVALID_TXN_STATUS');
1617: fnd_message.raise_error;

Line 1632: --pay_jp_isdf_dml_pkg.update_assact(

1628: --
1629: p_object_version_number := l_assact_rec.object_version_number + 1;
1630: --
1631: --api is disable because assact has been locked.
1632: --pay_jp_isdf_dml_pkg.update_assact(
1633: -- p_action_information_id => l_assact_rec.assignment_action_id,
1634: -- p_object_version_number => p_object_version_number,
1635: -- p_transaction_status => l_assact_rec.transaction_status,
1636: -- p_finalized_date => l_assact_rec.finalized_date,

Line 3155: pay_jp_isdf_dml_pkg.create_calc_dct(

3151: select pay_action_information_s.nextval
3152: into l_action_information_id
3153: from dual;
3154: --
3155: pay_jp_isdf_dml_pkg.create_calc_dct(
3156: p_action_information_id => l_action_information_id,
3157: p_assignment_action_id => l_assact_rec.assignment_action_id,
3158: p_action_context_type => 'AAP',
3159: p_assignment_id => l_assact_rec.assignment_id,

Line 3200: pay_jp_isdf_dml_pkg.update_calc_dct(

3196: l_action_information_id := l_csr_calc_dct.action_information_id;
3197: l_object_version_number := l_csr_calc_dct.object_version_number;
3198: --
3199: -- calc_dct is always insert mode because no initial archive data.
3200: pay_jp_isdf_dml_pkg.update_calc_dct(
3201: p_action_information_id => l_action_information_id,
3202: p_object_version_number => l_object_version_number,
3203: p_status => 'I',
3204: p_life_gen_ins_prem => l_calc_dct_rec.life_gen_ins_prem,

Line 3246: pay_jp_isdf_dml_pkg.create_calc_dct2(

3242: select pay_action_information_s.nextval
3243: into l_action_information_id
3244: from dual;
3245: --
3246: pay_jp_isdf_dml_pkg.create_calc_dct2(
3247: p_action_information_id => l_action_information_id,
3248: p_assignment_action_id => l_assact_rec.assignment_action_id,
3249: p_action_context_type => 'AAP',
3250: p_assignment_id => l_assact_rec.assignment_id,

Line 3264: pay_jp_isdf_dml_pkg.update_calc_dct2(

3260: l_action_information_id := l_csr_calc_dct2.action_information_id;
3261: l_object_version_number := l_csr_calc_dct2.object_version_number;
3262: --
3263: -- calc_dct is always insert mode because no initial archive data.
3264: pay_jp_isdf_dml_pkg.update_calc_dct2(
3265: p_action_information_id => l_action_information_id,
3266: p_object_version_number => l_object_version_number,
3267: p_status => 'I',
3268: p_care_med_new_ins_prem => l_calc_dct_rec.care_med_new_ins_prem,

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

3337: hr_utility.set_location(l_proc,10);
3338: hr_utility.trace('submission_date : '||fnd_date.date_to_canonical(l_submission_date));
3339: end if;
3340: --
3341: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
3342: --
3343: if l_assact_rec.transaction_status <> 'N' then
3344: fnd_message.set_name('PAY','PAY_JP_DEF_INVALID_TXN_STATUS');
3345: fnd_message.raise_error;

Line 3371: pay_jp_isdf_dml_pkg.create_calc_dct(

3367: select pay_action_information_s.nextval
3368: into l_action_information_id
3369: from dual;
3370: --
3371: pay_jp_isdf_dml_pkg.create_calc_dct(
3372: p_action_information_id => l_action_information_id,
3373: p_assignment_action_id => l_assact_rec.assignment_action_id,
3374: p_action_context_type => 'AAP',
3375: p_assignment_id => l_assact_rec.assignment_id,

Line 3416: pay_jp_isdf_dml_pkg.update_calc_dct(

3412: l_action_information_id := l_csr_calc_dct.action_information_id;
3413: l_object_version_number := l_csr_calc_dct.object_version_number;
3414: --
3415: -- calc_dct is always insert mode because no initial archive data.
3416: pay_jp_isdf_dml_pkg.update_calc_dct(
3417: p_action_information_id => l_action_information_id,
3418: p_object_version_number => l_object_version_number,
3419: p_status => 'I',
3420: p_life_gen_ins_prem => l_calc_dct_rec.life_gen_ins_prem,

Line 3462: pay_jp_isdf_dml_pkg.create_calc_dct2(

3458: select pay_action_information_s.nextval
3459: into l_action_information_id
3460: from dual;
3461: --
3462: pay_jp_isdf_dml_pkg.create_calc_dct2(
3463: p_action_information_id => l_action_information_id,
3464: p_assignment_action_id => l_assact_rec.assignment_action_id,
3465: p_action_context_type => 'AAP',
3466: p_assignment_id => l_assact_rec.assignment_id,

Line 3480: pay_jp_isdf_dml_pkg.update_calc_dct2(

3476: l_action_information_id := l_csr_calc_dct2.action_information_id;
3477: l_object_version_number := l_csr_calc_dct2.object_version_number;
3478: --
3479: -- calc_dct is always insert mode because no initial archive data.
3480: pay_jp_isdf_dml_pkg.update_calc_dct2(
3481: p_action_information_id => l_action_information_id,
3482: p_object_version_number => l_object_version_number,
3483: p_status => 'I',
3484: p_care_med_new_ins_prem => l_calc_dct_rec.care_med_new_ins_prem,

Line 3505: pay_jp_isdf_dml_pkg.create_entry(

3501: select pay_action_information_s.nextval
3502: into l_action_information_id
3503: from dual;
3504: --
3505: pay_jp_isdf_dml_pkg.create_entry(
3506: p_action_information_id => l_action_information_id,
3507: p_assignment_action_id => l_assact_rec.assignment_action_id,
3508: p_action_context_type => 'AAP',
3509: p_assignment_id => l_assact_rec.assignment_id,

Line 3557: pay_jp_isdf_dml_pkg.update_entry(

3553: --
3554: if l_csr_entry.ins_element_entry_id is not null
3555: or l_csr_entry.is_element_entry_id is not null then
3556: --
3557: pay_jp_isdf_dml_pkg.update_entry(
3558: p_action_information_id => l_action_information_id,
3559: p_object_version_number => l_object_version_number,
3560: p_status => 'Q',
3561: p_life_gen_ins_prem => l_calc_dct_rec.life_gen_ins_prem,

Line 3585: pay_jp_isdf_dml_pkg.update_entry(

3581: p_care_med_ins_prem_new => l_calc_dct_rec.care_med_new_ins_prem);
3582: --
3583: else
3584: --
3585: pay_jp_isdf_dml_pkg.update_entry(
3586: p_action_information_id => l_action_information_id,
3587: p_object_version_number => l_object_version_number,
3588: p_status => 'I',
3589: p_life_gen_ins_prem => l_calc_dct_rec.life_gen_ins_prem,

Line 3631: --pay_jp_isdf_dml_pkg.update_assact(

3627: --
3628: p_object_version_number := l_assact_rec.object_version_number + 1;
3629: --
3630: --api is disable because assact has been locked.
3631: --pay_jp_isdf_dml_pkg.update_assact(
3632: -- p_action_information_id => l_assact_rec.assignment_action_id,
3633: -- p_object_version_number => p_object_version_number,
3634: -- p_transaction_status => 'F',
3635: -- p_finalized_date => fnd_date.date_to_canonical(l_submission_date),

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

3679: hr_utility.set_location(l_proc,10);
3680: hr_utility.trace('submission_date : '||fnd_date.date_to_canonical(l_submission_date));
3681: end if;
3682: --
3683: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
3684: --
3685: if l_assact_rec.transaction_status not in ('F', 'A') then
3686: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
3687: fnd_message.raise_error;

Line 3718: --pay_jp_isdf_dml_pkg.update_assact(

3714: --
3715: p_object_version_number := l_assact_rec.object_version_number + 1;
3716: --
3717: --api is disable because assact has been locked.
3718: --pay_jp_isdf_dml_pkg.update_assact(
3719: -- p_action_information_id => l_assact_rec.assignment_action_id,
3720: -- p_object_version_number => p_object_version_number,
3721: -- p_transaction_status => 'U',
3722: -- p_finalized_date => null,

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

3766: hr_utility.set_location(l_proc,10);
3767: hr_utility.trace('submission_date : '||fnd_date.date_to_canonical(l_submission_date));
3768: end if;
3769: --
3770: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
3771: --
3772: if l_assact_rec.transaction_status not in ('F', 'A') then
3773: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
3774: fnd_message.raise_error;

Line 3799: --pay_jp_isdf_dml_pkg.update_assact(

3795: --
3796: p_object_version_number := l_assact_rec.object_version_number + 1;
3797: --
3798: --api is disable because assact has been locked.
3799: --pay_jp_isdf_dml_pkg.update_assact(
3800: -- p_action_information_id => l_assact_rec.assignment_action_id,
3801: -- p_object_version_number => p_object_version_number,
3802: -- p_transaction_status => 'N',
3803: -- p_finalized_date => null,

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

3838: if g_debug then
3839: hr_utility.set_location(l_proc,0);
3840: end if;
3841: --
3842: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
3843: --
3844: if l_assact_rec.transaction_status <> 'F' then
3845: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
3846: fnd_message.raise_error;

Line 3868: --pay_jp_isdf_dml_pkg.update_assact(

3864: --
3865: p_object_version_number := l_assact_rec.object_version_number + 1;
3866: --
3867: --api is disable because assact has been locked.
3868: --pay_jp_isdf_dml_pkg.update_assact(
3869: -- p_action_information_id => l_assact_rec.assignment_action_id,
3870: -- p_object_version_number => p_object_version_number,
3871: -- p_transaction_status => 'A',
3872: -- p_finalized_date => l_assact_rec.finalized_date,

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

5403: end if;
5404: --
5405: hr_api.mandatory_arg_error(l_proc, 'transfer_date', p_transfer_date);
5406: --
5407: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
5408: --
5409: if l_assact_rec.transaction_status <> 'A' then
5410: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
5411: fnd_message.raise_error;

Line 5530: --pay_jp_isdf_dml_pkg.update_assact(

5526: --
5527: p_object_version_number := l_assact_rec.object_version_number + 1;
5528: --
5529: --api is disable because assact has been locked.
5530: --pay_jp_isdf_dml_pkg.update_assact(
5531: -- p_action_information_id => l_assact_rec.assignment_action_id,
5532: -- p_object_version_number => p_object_version_number,
5533: -- p_transaction_status => l_assact_rec.transaction_status,
5534: -- p_finalized_date => l_assact_rec.finalized_date,

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

5606: end if;
5607: --
5608: hr_api.mandatory_arg_error(l_proc,'expiry_date',p_expiry_date);
5609: --
5610: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
5611: --
5612: if l_assact_rec.transaction_status = 'U' then
5613: fnd_message.set_name('PAY', 'PAY_JP_DEF_NOT_TRANSFERRED_YET');
5614: fnd_message.raise_error;

Line 5734: --pay_jp_isdf_dml_pkg.update_assact(

5730: --
5731: p_object_version_number := l_assact_rec.object_version_number + 1;
5732: --
5733: --api is disable because assact has been locked.
5734: --pay_jp_isdf_dml_pkg.update_assact(
5735: -- p_action_information_id => l_assact_rec.assignment_action_id,
5736: -- p_object_version_number => p_object_version_number,
5737: -- p_transaction_status => l_assact_rec.transaction_status,
5738: -- p_finalized_date => l_assact_rec.finalized_date,