DBA Data[Home] [Help]

APPS.PAY_JP_ISDF_SS_PKG dependencies on PAY_JP_ISDF_ASSACT_DML_V

Line 1578: update pay_jp_isdf_assact_dml_v

1574: -- p_admin_comments => l_assact_rec.admin_comments,
1575: -- p_transfer_status => l_assact_rec.transfer_status,
1576: -- p_transfer_date => l_assact_rec.transfer_date,
1577: -- p_expiry_date => l_assact_rec.expiry_date);
1578: update pay_jp_isdf_assact_dml_v
1579: set object_version_number = p_object_version_number,
1580: transaction_status = 'N'
1581: where row_id = l_assact_rec.row_id;
1582: --

Line 1643: update pay_jp_isdf_assact_dml_v

1639: -- p_admin_comments => l_assact_rec.admin_comments,
1640: -- p_transfer_status => l_assact_rec.transfer_status,
1641: -- p_transfer_date => l_assact_rec.transfer_date,
1642: -- p_expiry_date => l_assact_rec.expiry_date);
1643: update pay_jp_isdf_assact_dml_v
1644: set object_version_number = p_object_version_number
1645: where row_id = l_assact_rec.row_id;
1646: --
1647: if g_debug then

Line 3642: update pay_jp_isdf_assact_dml_v

3638: -- p_admin_comments => l_assact_rec.admin_comments,
3639: -- p_transfer_status => l_assact_rec.transfer_status,
3640: -- p_transfer_date => l_assact_rec.transfer_date,
3641: -- p_expiry_date => l_assact_rec.expiry_date);
3642: update pay_jp_isdf_assact_dml_v
3643: set object_version_number = p_object_version_number,
3644: transaction_status = 'F',
3645: finalized_date = fnd_date.date_to_canonical(l_submission_date),
3646: finalized_by = fnd_number.number_to_canonical(fnd_global.user_id),

Line 3729: update pay_jp_isdf_assact_dml_v

3725: -- p_admin_comments => p_admin_comments,
3726: -- p_transfer_status => l_assact_rec.transfer_status,
3727: -- p_transfer_date => l_assact_rec.transfer_date,
3728: -- p_expiry_date => l_assact_rec.expiry_date);
3729: update pay_jp_isdf_assact_dml_v
3730: set object_version_number = p_object_version_number,
3731: transaction_status = 'U',
3732: finalized_date = null,
3733: finalized_by = null,

Line 3810: update pay_jp_isdf_assact_dml_v

3806: -- p_admin_comments => p_admin_comments,
3807: -- p_transfer_status => l_assact_rec.transfer_status,
3808: -- p_transfer_date => l_assact_rec.transfer_date,
3809: -- p_expiry_date => l_assact_rec.expiry_date);
3810: update pay_jp_isdf_assact_dml_v
3811: set object_version_number = p_object_version_number,
3812: transaction_status = 'N',
3813: finalized_date = null,
3814: finalized_by = null,

Line 3879: update pay_jp_isdf_assact_dml_v

3875: -- p_admin_comments => l_assact_rec.admin_comments,
3876: -- p_transfer_status => l_assact_rec.transfer_status,
3877: -- p_transfer_date => l_assact_rec.transfer_date,
3878: -- p_expiry_date => l_assact_rec.expiry_date);
3879: update pay_jp_isdf_assact_dml_v
3880: set object_version_number = p_object_version_number,
3881: transaction_status = 'A'
3882: where row_id = l_assact_rec.row_id;
3883: --

Line 5541: update pay_jp_isdf_assact_dml_v

5537: -- p_admin_comments => l_assact_rec.admin_comments,
5538: -- p_transfer_status => 'T',
5539: -- p_transfer_date => fnd_date.date_to_canonical(l_effective_date),
5540: -- p_expiry_date => l_assact_rec.expiry_date);
5541: update pay_jp_isdf_assact_dml_v
5542: set object_version_number = p_object_version_number,
5543: transfer_status = 'T',
5544: transfer_date = fnd_date.date_to_canonical(l_effective_date)
5545: where row_id = l_assact_rec.row_id;

Line 5745: update pay_jp_isdf_assact_dml_v

5741: -- p_admin_comments => l_assact_rec.admin_comments,
5742: -- p_transfer_status => 'E',
5743: -- p_transfer_date => l_assact_rec.transfer_date,
5744: -- p_expiry_date => fnd_date.date_to_canonical(p_expiry_date));
5745: update pay_jp_isdf_assact_dml_v
5746: set object_version_number = p_object_version_number,
5747: transfer_status = 'E',
5748: expiry_date = fnd_date.date_to_canonical(p_expiry_date)
5749: where row_id = l_assact_rec.row_id;