DBA Data[Home] [Help]

APPS.PAY_JP_ISDF_SS_PKG dependencies on PAY_JP_ISDF_ASSACT_DML_V

Line 1177: update pay_jp_isdf_assact_dml_v

1173: -- p_admin_comments => l_assact_rec.admin_comments,
1174: -- p_transfer_status => l_assact_rec.transfer_status,
1175: -- p_transfer_date => l_assact_rec.transfer_date,
1176: -- p_expiry_date => l_assact_rec.expiry_date);
1177: update pay_jp_isdf_assact_dml_v
1178: set object_version_number = p_object_version_number,
1179: transaction_status = 'N'
1180: where row_id = l_assact_rec.row_id;
1181: --

Line 1242: update pay_jp_isdf_assact_dml_v

1238: -- p_admin_comments => l_assact_rec.admin_comments,
1239: -- p_transfer_status => l_assact_rec.transfer_status,
1240: -- p_transfer_date => l_assact_rec.transfer_date,
1241: -- p_expiry_date => l_assact_rec.expiry_date);
1242: update pay_jp_isdf_assact_dml_v
1243: set object_version_number = p_object_version_number
1244: where row_id = l_assact_rec.row_id;
1245: --
1246: if g_debug then

Line 2975: update pay_jp_isdf_assact_dml_v

2971: -- p_admin_comments => l_assact_rec.admin_comments,
2972: -- p_transfer_status => l_assact_rec.transfer_status,
2973: -- p_transfer_date => l_assact_rec.transfer_date,
2974: -- p_expiry_date => l_assact_rec.expiry_date);
2975: update pay_jp_isdf_assact_dml_v
2976: set object_version_number = p_object_version_number,
2977: transaction_status = 'F',
2978: finalized_date = fnd_date.date_to_canonical(l_submission_date),
2979: finalized_by = fnd_number.number_to_canonical(fnd_global.user_id),

Line 3062: update pay_jp_isdf_assact_dml_v

3058: -- p_admin_comments => p_admin_comments,
3059: -- p_transfer_status => l_assact_rec.transfer_status,
3060: -- p_transfer_date => l_assact_rec.transfer_date,
3061: -- p_expiry_date => l_assact_rec.expiry_date);
3062: update pay_jp_isdf_assact_dml_v
3063: set object_version_number = p_object_version_number,
3064: transaction_status = 'U',
3065: finalized_date = null,
3066: finalized_by = null,

Line 3143: update pay_jp_isdf_assact_dml_v

3139: -- p_admin_comments => p_admin_comments,
3140: -- p_transfer_status => l_assact_rec.transfer_status,
3141: -- p_transfer_date => l_assact_rec.transfer_date,
3142: -- p_expiry_date => l_assact_rec.expiry_date);
3143: update pay_jp_isdf_assact_dml_v
3144: set object_version_number = p_object_version_number,
3145: transaction_status = 'N',
3146: finalized_date = null,
3147: finalized_by = null,

Line 3212: update pay_jp_isdf_assact_dml_v

3208: -- p_admin_comments => l_assact_rec.admin_comments,
3209: -- p_transfer_status => l_assact_rec.transfer_status,
3210: -- p_transfer_date => l_assact_rec.transfer_date,
3211: -- p_expiry_date => l_assact_rec.expiry_date);
3212: update pay_jp_isdf_assact_dml_v
3213: set object_version_number = p_object_version_number,
3214: transaction_status = 'A'
3215: where row_id = l_assact_rec.row_id;
3216: --

Line 4615: update pay_jp_isdf_assact_dml_v

4611: -- p_admin_comments => l_assact_rec.admin_comments,
4612: -- p_transfer_status => 'T',
4613: -- p_transfer_date => fnd_date.date_to_canonical(l_effective_date),
4614: -- p_expiry_date => l_assact_rec.expiry_date);
4615: update pay_jp_isdf_assact_dml_v
4616: set object_version_number = p_object_version_number,
4617: transfer_status = 'T',
4618: transfer_date = fnd_date.date_to_canonical(l_effective_date)
4619: where row_id = l_assact_rec.row_id;

Line 4819: update pay_jp_isdf_assact_dml_v

4815: -- p_admin_comments => l_assact_rec.admin_comments,
4816: -- p_transfer_status => 'E',
4817: -- p_transfer_date => l_assact_rec.transfer_date,
4818: -- p_expiry_date => fnd_date.date_to_canonical(p_expiry_date));
4819: update pay_jp_isdf_assact_dml_v
4820: set object_version_number = p_object_version_number,
4821: transfer_status = 'E',
4822: expiry_date = fnd_date.date_to_canonical(p_expiry_date)
4823: where row_id = l_assact_rec.row_id;