DBA Data[Home] [Help]

APPS.IBY_CREDITCARD_PKG dependencies on FND_GLOBAL

Line 250: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,

246: attribute16, attribute17, attribute18, attribute19, attribute20,
247: attribute21, attribute22, attribute23, attribute24, attribute25,
248: attribute26, attribute27, attribute28, attribute29, attribute30,
249: request_id, program_application_id, program_id, program_update_date,
250: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
251: fnd_global.login_id, 1
252: FROM iby_creditcard
253: WHERE (instrid = p_instr_id);
254:

Line 251: fnd_global.login_id, 1

247: attribute21, attribute22, attribute23, attribute24, attribute25,
248: attribute26, attribute27, attribute28, attribute29, attribute30,
249: request_id, program_application_id, program_id, program_update_date,
250: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
251: fnd_global.login_id, 1
252: FROM iby_creditcard
253: WHERE (instrid = p_instr_id);
254:
255: IF FND_API.To_Boolean(p_commit) THEN

Line 720: sysdate, nvl(p_user_id, fnd_global.user_id), sysdate,

716: lx_card_issuer, lx_issuer_range, l_card_len,
717: p_desc, p_fi_name, l_encrypted, lx_sec_segment_id,
718: NVL(p_single_use,'N'), NVL(p_info_only,'N'), p_purpose,
719: NVL(p_active_flag,'Y'), p_inactive_date,
720: sysdate, nvl(p_user_id, fnd_global.user_id), sysdate,
721: decode(p_user_id,-1,fnd_global.user_id,p_user_id),
722: decode(p_login_id,-1,fnd_global.login_id,p_login_id), 1,
723: p_attribute_category,
724: p_attribute1,p_attribute2,p_attribute3,p_attribute4,p_attribute5,

Line 721: decode(p_user_id,-1,fnd_global.user_id,p_user_id),

717: p_desc, p_fi_name, l_encrypted, lx_sec_segment_id,
718: NVL(p_single_use,'N'), NVL(p_info_only,'N'), p_purpose,
719: NVL(p_active_flag,'Y'), p_inactive_date,
720: sysdate, nvl(p_user_id, fnd_global.user_id), sysdate,
721: decode(p_user_id,-1,fnd_global.user_id,p_user_id),
722: decode(p_login_id,-1,fnd_global.login_id,p_login_id), 1,
723: p_attribute_category,
724: p_attribute1,p_attribute2,p_attribute3,p_attribute4,p_attribute5,
725: p_attribute6,p_attribute7,p_attribute8,p_attribute9,p_attribute10,

Line 722: decode(p_login_id,-1,fnd_global.login_id,p_login_id), 1,

718: NVL(p_single_use,'N'), NVL(p_info_only,'N'), p_purpose,
719: NVL(p_active_flag,'Y'), p_inactive_date,
720: sysdate, nvl(p_user_id, fnd_global.user_id), sysdate,
721: decode(p_user_id,-1,fnd_global.user_id,p_user_id),
722: decode(p_login_id,-1,fnd_global.login_id,p_login_id), 1,
723: p_attribute_category,
724: p_attribute1,p_attribute2,p_attribute3,p_attribute4,p_attribute5,
725: p_attribute6,p_attribute7,p_attribute8,p_attribute9,p_attribute10,
726: p_attribute11,p_attribute12,p_attribute13,p_attribute14,p_attribute15,

Line 1051: last_updated_by = fnd_global.user_id,

1047: inactive_date = DECODE(p_inactive_date, FND_API.G_MISS_DATE,NULL,
1048: NULL,inactive_date, p_inactive_date),
1049: object_version_number = object_version_number + 1,
1050: last_update_date = sysdate,
1051: last_updated_by = fnd_global.user_id,
1052: last_update_login = fnd_global.login_id,
1053: attribute_category = p_Attribute_category,
1054: attribute1 = DECODE(p_attribute1,FND_API.G_MISS_CHAR,NULL,NULL,attribute1, p_attribute1),
1055: attribute2 = DECODE(p_attribute2,FND_API.G_MISS_CHAR,NULL,NULL,attribute2, p_attribute2),

Line 1052: last_update_login = fnd_global.login_id,

1048: NULL,inactive_date, p_inactive_date),
1049: object_version_number = object_version_number + 1,
1050: last_update_date = sysdate,
1051: last_updated_by = fnd_global.user_id,
1052: last_update_login = fnd_global.login_id,
1053: attribute_category = p_Attribute_category,
1054: attribute1 = DECODE(p_attribute1,FND_API.G_MISS_CHAR,NULL,NULL,attribute1, p_attribute1),
1055: attribute2 = DECODE(p_attribute2,FND_API.G_MISS_CHAR,NULL,NULL,attribute2, p_attribute2),
1056: attribute3 = DECODE(p_attribute3,FND_API.G_MISS_CHAR,NULL,NULL,attribute3, p_attribute3),

Line 1381: last_updated_by = fnd_global.user_id,

1377: chname_mask_setting = NULL,
1378: chname_unmask_length = NULL,
1379: object_version_number = object_version_number + 1,
1380: last_update_date = sysdate,
1381: last_updated_by = fnd_global.user_id,
1382: last_update_login = fnd_global.login_id
1383: WHERE (instrid = c_card_rec.instrid);
1384:
1385: DELETE iby_security_segments

Line 1382: last_update_login = fnd_global.login_id

1378: chname_unmask_length = NULL,
1379: object_version_number = object_version_number + 1,
1380: last_update_date = sysdate,
1381: last_updated_by = fnd_global.user_id,
1382: last_update_login = fnd_global.login_id
1383: WHERE (instrid = c_card_rec.instrid);
1384:
1385: DELETE iby_security_segments
1386: WHERE (sec_segment_id IN (c_card_rec.cc_num_sec_segment_id,

Line 1529: last_updated_by = fnd_global.user_id,

1525: expirydate = l_exp_date,
1526: expired_flag = l_expired_flag,
1527: object_version_number = object_version_number + 1,
1528: last_update_date = sysdate,
1529: last_updated_by = fnd_global.user_id,
1530: last_update_login = fnd_global.login_id
1531: WHERE (instrid = c_card_rec.instrid);
1532: ELSE
1533: iby_debug_pub.add('Could not encrypt the record ' || c_card_rec.instrid,IBY_DEBUG_PUB.G_LEVEL_INFO,l_dbg_mod);

Line 1530: last_update_login = fnd_global.login_id

1526: expired_flag = l_expired_flag,
1527: object_version_number = object_version_number + 1,
1528: last_update_date = sysdate,
1529: last_updated_by = fnd_global.user_id,
1530: last_update_login = fnd_global.login_id
1531: WHERE (instrid = c_card_rec.instrid);
1532: ELSE
1533: iby_debug_pub.add('Could not encrypt the record ' || c_card_rec.instrid,IBY_DEBUG_PUB.G_LEVEL_INFO,l_dbg_mod);
1534: END IF;

Line 1678: last_updated_by = fnd_global.user_id,

1674: chname_mask_setting = l_chname_mask_setting,
1675: chname_unmask_length = l_chname_unmask_len,
1676: object_version_number = object_version_number + 1,
1677: last_update_date = sysdate,
1678: last_updated_by = fnd_global.user_id,
1679: last_update_login = fnd_global.login_id
1680: WHERE (instrid = c_card_rec.instrid);
1681: END LOOP;
1682:

Line 1679: last_update_login = fnd_global.login_id

1675: chname_unmask_length = l_chname_unmask_len,
1676: object_version_number = object_version_number + 1,
1677: last_update_date = sysdate,
1678: last_updated_by = fnd_global.user_id,
1679: last_update_login = fnd_global.login_id
1680: WHERE (instrid = c_card_rec.instrid);
1681: END LOOP;
1682:
1683: IF FND_API.to_Boolean( p_commit ) THEN

Line 2221: last_updated_by = fnd_global.user_id,

2217: expiry_sec_segment_id = l_exp_segment_id,
2218: expired_flag = l_expired_flag,
2219: object_version_number = object_version_number + 1,
2220: last_update_date = sysdate,
2221: last_updated_by = fnd_global.user_id,
2222: last_update_login = fnd_global.login_id
2223: WHERE (instrid = c_card_rec.instrid);
2224: no_cc := no_cc + 1;
2225: -- flush the variables before iterating into the next record

Line 2222: last_update_login = fnd_global.login_id

2218: expired_flag = l_expired_flag,
2219: object_version_number = object_version_number + 1,
2220: last_update_date = sysdate,
2221: last_updated_by = fnd_global.user_id,
2222: last_update_login = fnd_global.login_id
2223: WHERE (instrid = c_card_rec.instrid);
2224: no_cc := no_cc + 1;
2225: -- flush the variables before iterating into the next record
2226: l_masked_chname := null;

Line 2409: req_id := fnd_global.CONC_REQUEST_ID;

2405: l_dev_status VARCHAR2(30);
2406: l_message VARCHAR2(500);
2407: BEGIN
2408: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Enter.');
2409: req_id := fnd_global.CONC_REQUEST_ID;
2410: BEGIN
2411: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Invoking APXCCUPGMGR. Timestamp: '|| TO_CHAR(systimestamp,'SSSSS.FF'));
2412: BEGIN
2413: x_req_id := fnd_request.submit_request(