DBA Data[Home] [Help]

APPS.POS_SUPPLIER_USER_REG_PKG dependencies on FND_GLOBAL

Line 89: fnd_global.user_id,

85: (p_resp_id,
86: p_resp_appl_id,
87: p_sec_attr_code,
88: p_sec_attr_appl_id,
89: fnd_global.user_id,
90: Sysdate,
91: fnd_global.user_id,
92: Sysdate,
93: fnd_global.login_id

Line 91: fnd_global.user_id,

87: p_sec_attr_code,
88: p_sec_attr_appl_id,
89: fnd_global.user_id,
90: Sysdate,
91: fnd_global.user_id,
92: Sysdate,
93: fnd_global.login_id
94: );
95:

Line 93: fnd_global.login_id

89: fnd_global.user_id,
90: Sysdate,
91: fnd_global.user_id,
92: Sysdate,
93: fnd_global.login_id
94: );
95:
96:
97: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 378: WHERE user_id = fnd_global.user_id;

374: IS
375: CURSOR l_cur IS
376: SELECT email_address
377: FROM fnd_user
378: WHERE user_id = fnd_global.user_id;
379:
380: l_email fnd_user.email_address%TYPE;
381: BEGIN
382: OPEN l_cur;

Line 1390: last_update_login = fnd_global.login_id,

1386:
1387: UPDATE fnd_registrations
1388: SET registration_status = 'APPROVED',
1389: last_update_date = Sysdate,
1390: last_update_login = fnd_global.login_id,
1391: last_updated_by = fnd_global.user_id
1392: WHERE registration_id = p_registration_id;
1393:
1394: send_approval_ntf

Line 1391: last_updated_by = fnd_global.user_id

1387: UPDATE fnd_registrations
1388: SET registration_status = 'APPROVED',
1389: last_update_date = Sysdate,
1390: last_update_login = fnd_global.login_id,
1391: last_updated_by = fnd_global.user_id
1392: WHERE registration_id = p_registration_id;
1393:
1394: send_approval_ntf
1395: (p_registration_id => p_registration_id,

Line 1433: last_update_login = fnd_global.login_id,

1429: SAVEPOINT supplier_user_reject_sp;
1430: UPDATE fnd_registrations
1431: SET registration_status = 'REJECTED',
1432: last_update_date = Sysdate,
1433: last_update_login = fnd_global.login_id,
1434: last_updated_by = fnd_global.user_id
1435: WHERE registration_id = p_registration_id;
1436:
1437: SELECT email, language_code

Line 1434: last_updated_by = fnd_global.user_id

1430: UPDATE fnd_registrations
1431: SET registration_status = 'REJECTED',
1432: last_update_date = Sysdate,
1433: last_update_login = fnd_global.login_id,
1434: last_updated_by = fnd_global.user_id
1435: WHERE registration_id = p_registration_id;
1436:
1437: SELECT email, language_code
1438: INTO l_email, l_language_code

Line 1480: last_update_login = fnd_global.login_id,

1476: SAVEPOINT supplier_user_invite_sp;
1477: UPDATE fnd_registrations
1478: SET registration_status = 'INVITED',
1479: last_update_date = Sysdate,
1480: last_update_login = fnd_global.login_id,
1481: last_updated_by = fnd_global.user_id
1482: WHERE registration_id = p_registration_id;
1483:
1484: SELECT email, language_code, registration_key

Line 1481: last_updated_by = fnd_global.user_id

1477: UPDATE fnd_registrations
1478: SET registration_status = 'INVITED',
1479: last_update_date = Sysdate,
1480: last_update_login = fnd_global.login_id,
1481: last_updated_by = fnd_global.user_id
1482: WHERE registration_id = p_registration_id;
1483:
1484: SELECT email, language_code, registration_key
1485: INTO l_email, l_language_code, l_reg_key

Line 1535: last_update_login = fnd_global.login_id,

1531: SAVEPOINT supplier_user_respond_sp;
1532: UPDATE fnd_registrations
1533: SET registration_status = 'REGISTERED',
1534: last_update_date = Sysdate,
1535: last_update_login = fnd_global.login_id,
1536: last_updated_by = fnd_global.user_id
1537: WHERE registration_id = p_registration_id;
1538:
1539: OPEN l_cur;

Line 1536: last_updated_by = fnd_global.user_id

1532: UPDATE fnd_registrations
1533: SET registration_status = 'REGISTERED',
1534: last_update_date = Sysdate,
1535: last_update_login = fnd_global.login_id,
1536: last_updated_by = fnd_global.user_id
1537: WHERE registration_id = p_registration_id;
1538:
1539: OPEN l_cur;
1540: FETCH l_cur INTO l_rec;

Line 1770: NL VARCHAR2(1) := fnd_global.newline;

1766: document IN OUT NOCOPY CLOB,
1767: document_type IN OUT NOCOPY VARCHAR2)
1768: IS
1769:
1770: NL VARCHAR2(1) := fnd_global.newline;
1771: l_document VARCHAR2(32000) := '';
1772: l_note VARCHAR2(32000) := '';
1773: l_enterprisename VARCHAR2(1000) := '';
1774: l_url VARCHAR2(3000) := '';