DBA Data[Home] [Help]

APPS.PO_CLM_CLO_UTIL dependencies on FND_GLOBAL

Line 10: if checkCLMResp (fnd_global.user_id, fnd_global.resp_id,fnd_global.resp_appl_id) ='Y' THEN

6:
7: FUNCTION getCLMStatus RETURN VARCHAR2
8: IS
9: BEGIN
10: if checkCLMResp (fnd_global.user_id, fnd_global.resp_id,fnd_global.resp_appl_id) ='Y' THEN
11: RETURN 'Y';
12: ELSE
13: RETURN 'N';
14: END IF;

Line 744: p_user_id := fnd_global.user_id;

740: p_appl_id NUMBER;
741: p_emp_id NUMBER;
742: p_proc_name VARCHAR2(100) := 'PO.PLSQL.PO_HEADERS_ALL_DATA_SEC';
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:

Line 745: p_resp_id := fnd_global.resp_id;

741: p_emp_id NUMBER;
742: p_proc_name VARCHAR2(100) := 'PO.PLSQL.PO_HEADERS_ALL_DATA_SEC';
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

Line 746: p_appl_id := fnd_global.resp_appl_id;

742: p_proc_name VARCHAR2(100) := 'PO.PLSQL.PO_HEADERS_ALL_DATA_SEC';
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');

Line 789: p_user_id := fnd_global.user_id;

785: p_appl_id NUMBER;
786: p_emp_id NUMBER;
787: p_proc_name VARCHAR2(100) := 'OKC.PLSQL.OKC_BUS_DOC_TYPES_DATA_SEC';
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:

Line 790: p_resp_id := fnd_global.resp_id;

786: p_emp_id NUMBER;
787: p_proc_name VARCHAR2(100) := 'OKC.PLSQL.OKC_BUS_DOC_TYPES_DATA_SEC';
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

Line 791: p_appl_id := fnd_global.resp_appl_id;

787: p_proc_name VARCHAR2(100) := 'OKC.PLSQL.OKC_BUS_DOC_TYPES_DATA_SEC';
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');

Line 842: p_user_id := fnd_global.user_id;

838: p_appl_id NUMBER;
839: p_emp_id NUMBER;
840: p_proc_name VARCHAR2(100) := 'OKC.PLSQL.OKC_DELIVERABLES_DATA_SEC';
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:

Line 843: p_resp_id := fnd_global.resp_id;

839: p_emp_id NUMBER;
840: p_proc_name VARCHAR2(100) := 'OKC.PLSQL.OKC_DELIVERABLES_DATA_SEC';
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

Line 844: p_appl_id := fnd_global.resp_appl_id;

840: p_proc_name VARCHAR2(100) := 'OKC.PLSQL.OKC_DELIVERABLES_DATA_SEC';
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');