DBA Data[Home] [Help]

APPS.PO_CLM_CLO_UTIL dependencies on FND_USER

Line 747: SELECT Nvl(employee_id,-999) INTO p_emp_id FROM fnd_user WHERE user_id = p_user_id;

743: BEGIN
744: p_user_id := fnd_global.user_id;
745: p_resp_id := fnd_global.resp_id;
746: p_appl_id := fnd_global.resp_appl_id;
747: SELECT Nvl(employee_id,-999) INTO p_emp_id FROM fnd_user WHERE user_id = p_user_id;
748:
749: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
750: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'Enter PO_HEADERS_ALL_DATA_SEC Procedure');
751: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'p_user_id : ' || p_user_id);

Line 792: SELECT Nvl(employee_id,-999) INTO p_emp_id FROM fnd_user WHERE user_id = p_user_id;

788: BEGIN
789: p_user_id := fnd_global.user_id;
790: p_resp_id := fnd_global.resp_id;
791: p_appl_id := fnd_global.resp_appl_id;
792: SELECT Nvl(employee_id,-999) INTO p_emp_id FROM fnd_user WHERE user_id = p_user_id;
793:
794: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
795: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'Enter OKC_BUS_DOC_TYPES_DATA_SEC Procedure');
796: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'p_user_id : ' || p_user_id);

Line 845: SELECT Nvl(employee_id,-999) INTO p_emp_id FROM fnd_user WHERE user_id = p_user_id;

841: BEGIN
842: p_user_id := fnd_global.user_id;
843: p_resp_id := fnd_global.resp_id;
844: p_appl_id := fnd_global.resp_appl_id;
845: SELECT Nvl(employee_id,-999) INTO p_emp_id FROM fnd_user WHERE user_id = p_user_id;
846:
847: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
848: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'Enter OKC_DELIVERABLES_DATA_SEC Procedure');
849: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'p_user_id : ' || p_user_id);