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 1372: last_update_login = fnd_global.login_id,

1368:
1369: UPDATE fnd_registrations
1370: SET registration_status = 'APPROVED',
1371: last_update_date = Sysdate,
1372: last_update_login = fnd_global.login_id,
1373: last_updated_by = fnd_global.user_id
1374: WHERE registration_id = p_registration_id;
1375:
1376: send_approval_ntf

Line 1373: last_updated_by = fnd_global.user_id

1369: UPDATE fnd_registrations
1370: SET registration_status = 'APPROVED',
1371: last_update_date = Sysdate,
1372: last_update_login = fnd_global.login_id,
1373: last_updated_by = fnd_global.user_id
1374: WHERE registration_id = p_registration_id;
1375:
1376: send_approval_ntf
1377: (p_registration_id => p_registration_id,

Line 1414: last_update_login = fnd_global.login_id,

1410: SAVEPOINT supplier_user_reject_sp;
1411: UPDATE fnd_registrations
1412: SET registration_status = 'REJECTED',
1413: last_update_date = Sysdate,
1414: last_update_login = fnd_global.login_id,
1415: last_updated_by = fnd_global.user_id
1416: WHERE registration_id = p_registration_id;
1417:
1418: SELECT email, language_code

Line 1415: last_updated_by = fnd_global.user_id

1411: UPDATE fnd_registrations
1412: SET registration_status = 'REJECTED',
1413: last_update_date = Sysdate,
1414: last_update_login = fnd_global.login_id,
1415: last_updated_by = fnd_global.user_id
1416: WHERE registration_id = p_registration_id;
1417:
1418: SELECT email, language_code
1419: INTO l_email, l_language_code

Line 1455: last_update_login = fnd_global.login_id,

1451: SAVEPOINT supplier_user_invite_sp;
1452: UPDATE fnd_registrations
1453: SET registration_status = 'INVITED',
1454: last_update_date = Sysdate,
1455: last_update_login = fnd_global.login_id,
1456: last_updated_by = fnd_global.user_id
1457: WHERE registration_id = p_registration_id;
1458:
1459: SELECT email, language_code, registration_key

Line 1456: last_updated_by = fnd_global.user_id

1452: UPDATE fnd_registrations
1453: SET registration_status = 'INVITED',
1454: last_update_date = Sysdate,
1455: last_update_login = fnd_global.login_id,
1456: last_updated_by = fnd_global.user_id
1457: WHERE registration_id = p_registration_id;
1458:
1459: SELECT email, language_code, registration_key
1460: INTO l_email, l_language_code, l_reg_key

Line 1510: last_update_login = fnd_global.login_id,

1506: SAVEPOINT supplier_user_respond_sp;
1507: UPDATE fnd_registrations
1508: SET registration_status = 'REGISTERED',
1509: last_update_date = Sysdate,
1510: last_update_login = fnd_global.login_id,
1511: last_updated_by = fnd_global.user_id
1512: WHERE registration_id = p_registration_id;
1513:
1514: OPEN l_cur;

Line 1511: last_updated_by = fnd_global.user_id

1507: UPDATE fnd_registrations
1508: SET registration_status = 'REGISTERED',
1509: last_update_date = Sysdate,
1510: last_update_login = fnd_global.login_id,
1511: last_updated_by = fnd_global.user_id
1512: WHERE registration_id = p_registration_id;
1513:
1514: OPEN l_cur;
1515: FETCH l_cur INTO l_rec;