DBA Data[Home] [Help]

APPS.IBY_CREDITCARD_PKG dependencies on FND_GLOBAL

Line 188: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,

184: attribute16, attribute17, attribute18, attribute19, attribute20,
185: attribute21, attribute22, attribute23, attribute24, attribute25,
186: attribute26, attribute27, attribute28, attribute29, attribute30,
187: request_id, program_application_id, program_id, program_update_date,
188: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
189: fnd_global.login_id, 1
190: FROM iby_creditcard
191: WHERE (instrid = p_instr_id);
192:

Line 189: fnd_global.login_id, 1

185: attribute21, attribute22, attribute23, attribute24, attribute25,
186: attribute26, attribute27, attribute28, attribute29, attribute30,
187: request_id, program_application_id, program_id, program_update_date,
188: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
189: fnd_global.login_id, 1
190: FROM iby_creditcard
191: WHERE (instrid = p_instr_id);
192:
193: IF FND_API.To_Boolean(p_commit) THEN

Line 597: sysdate, fnd_global.user_id, sysdate,

593: lx_card_issuer, lx_issuer_range, l_card_len,
594: p_desc, p_fi_name, l_encrypted, lx_sec_segment_id,
595: NVL(p_single_use,'N'), NVL(p_info_only,'N'), p_purpose,
596: NVL(p_active_flag,'Y'), p_inactive_date,
597: sysdate, fnd_global.user_id, sysdate,
598: fnd_global.user_id, 1,
599: p_attribute_category,
600: p_attribute1,p_attribute2,p_attribute3,p_attribute4,p_attribute5,
601: p_attribute6,p_attribute7,p_attribute8,p_attribute9,p_attribute10,

Line 598: fnd_global.user_id, 1,

594: p_desc, p_fi_name, l_encrypted, lx_sec_segment_id,
595: NVL(p_single_use,'N'), NVL(p_info_only,'N'), p_purpose,
596: NVL(p_active_flag,'Y'), p_inactive_date,
597: sysdate, fnd_global.user_id, sysdate,
598: fnd_global.user_id, 1,
599: p_attribute_category,
600: p_attribute1,p_attribute2,p_attribute3,p_attribute4,p_attribute5,
601: p_attribute6,p_attribute7,p_attribute8,p_attribute9,p_attribute10,
602: p_attribute11,p_attribute12,p_attribute13,p_attribute14,p_attribute15,

Line 829: last_updated_by = fnd_global.user_id,

825: inactive_date = DECODE(p_inactive_date, FND_API.G_MISS_DATE,NULL,
826: NULL,inactive_date, p_inactive_date),
827: object_version_number = object_version_number + 1,
828: last_update_date = sysdate,
829: last_updated_by = fnd_global.user_id,
830: last_update_login = fnd_global.login_id,
831: attribute_category = p_Attribute_category,
832: attribute1 = p_attribute1,
833: attribute2 = p_attribute2,

Line 830: last_update_login = fnd_global.login_id,

826: NULL,inactive_date, p_inactive_date),
827: object_version_number = object_version_number + 1,
828: last_update_date = sysdate,
829: last_updated_by = fnd_global.user_id,
830: last_update_login = fnd_global.login_id,
831: attribute_category = p_Attribute_category,
832: attribute1 = p_attribute1,
833: attribute2 = p_attribute2,
834: attribute3 = p_attribute3,

Line 1071: last_updated_by = fnd_global.user_id,

1067: chname = l_chname,
1068: chname_sec_segment_id = NULL,
1069: object_version_number = object_version_number + 1,
1070: last_update_date = sysdate,
1071: last_updated_by = fnd_global.user_id,
1072: last_update_login = fnd_global.login_id
1073: WHERE (instrid = c_card_rec.instrid);
1074:
1075: DELETE iby_security_segments

Line 1072: last_update_login = fnd_global.login_id

1068: chname_sec_segment_id = NULL,
1069: object_version_number = object_version_number + 1,
1070: last_update_date = sysdate,
1071: last_updated_by = fnd_global.user_id,
1072: last_update_login = fnd_global.login_id
1073: WHERE (instrid = c_card_rec.instrid);
1074:
1075: DELETE iby_security_segments
1076: WHERE (sec_segment_id IN (c_card_rec.cc_num_sec_segment_id,

Line 1188: last_updated_by = fnd_global.user_id,

1184: --encrypted_date_format = l_encrypted_date_format,
1185: expirydate = l_exp_date,
1186: object_version_number = object_version_number + 1,
1187: last_update_date = sysdate,
1188: last_updated_by = fnd_global.user_id,
1189: last_update_login = fnd_global.login_id
1190: WHERE (instrid = c_card_rec.instrid);
1191: END LOOP;
1192:

Line 1189: last_update_login = fnd_global.login_id

1185: expirydate = l_exp_date,
1186: object_version_number = object_version_number + 1,
1187: last_update_date = sysdate,
1188: last_updated_by = fnd_global.user_id,
1189: last_update_login = fnd_global.login_id
1190: WHERE (instrid = c_card_rec.instrid);
1191: END LOOP;
1192:
1193: IF FND_API.to_Boolean( p_commit ) THEN

Line 1294: last_updated_by = fnd_global.user_id,

1290: card_mask_setting = lx_mask_option,
1291: card_unmask_length = lx_unmask_len,
1292: object_version_number = object_version_number + 1,
1293: last_update_date = sysdate,
1294: last_updated_by = fnd_global.user_id,
1295: last_update_login = fnd_global.login_id
1296: WHERE (instrid = c_card_rec.instrid);
1297: END LOOP;
1298:

Line 1295: last_update_login = fnd_global.login_id

1291: card_unmask_length = lx_unmask_len,
1292: object_version_number = object_version_number + 1,
1293: last_update_date = sysdate,
1294: last_updated_by = fnd_global.user_id,
1295: last_update_login = fnd_global.login_id
1296: WHERE (instrid = c_card_rec.instrid);
1297: END LOOP;
1298:
1299: IF FND_API.to_Boolean( p_commit ) THEN