APPS.EGO_PUB_WS_DEST dependencies on FND_USER

Line 6: ,p_fnd_user_name IN VARCHAR2

2: /* $Header: EGOPDESB.pls 120.1 2011/06/09 19:18:53 vijoshi noship $ */
3:
4: FUNCTION Trigger_Import_Program(
5: p_set_process_id IN NUMBER
6: ,p_fnd_user_name IN VARCHAR2
7: ,p_resp_name IN VARCHAR2
8: ,p_resp_appl_name IN VARCHAR2
9: ,x_request_id OUT NOCOPY NUMBER
10: ) RETURN VARCHAR2 IS

Line 20: l_fnd_user_id NUMBER;

16: l_status VARCHAR2(15);
17: l_dev_phase VARCHAR2(15);
18: l_dev_status VARCHAR2(15);
19: l_message VARCHAR2(240);--FND_CONCURRENT_REQUESTS%COMPLETION_TEXT;
20: l_fnd_user_id NUMBER;
21: l_resp_id NUMBER;
22: l_resp_appl_id NUMBER;
23: l_param_valid VARCHAR2(1);
24:

Line 30: l_fnd_user_id :=0;

26: BEGIN
27: l_req_id :=0;
28: l_req_succeeded :='N';
29: l_req_status :=FALSE;
30: l_fnd_user_id :=0;
31: l_resp_id :=0;
32: l_resp_appl_id :=0;
33: l_param_valid :='Y';
34: x_request_id := -1;

Line 38: INTO l_fnd_user_id

34: x_request_id := -1;
35:
36: BEGIN
37: SELECT USER_ID
38: INTO l_fnd_user_id
39: FROM FND_USER
40: WHERE USER_NAME = p_fnd_user_name;
41: EXCEPTION
42: WHEN OTHERS THEN

Line 39: FROM FND_USER

35:
36: BEGIN
37: SELECT USER_ID
38: INTO l_fnd_user_id
39: FROM FND_USER
40: WHERE USER_NAME = p_fnd_user_name;
41: EXCEPTION
42: WHEN OTHERS THEN
43: l_param_valid := 'P';

Line 40: WHERE USER_NAME = p_fnd_user_name;

36: BEGIN
37: SELECT USER_ID
38: INTO l_fnd_user_id
39: FROM FND_USER
40: WHERE USER_NAME = p_fnd_user_name;
41: EXCEPTION
42: WHEN OTHERS THEN
43: l_param_valid := 'P';
44: END;

Line 78: fnd_global.apps_initialize(user_id => l_fnd_user_id

74: RETURN l_param_valid;
75: END IF;
76:
77: /* Initiate an APPS session */
78: fnd_global.apps_initialize(user_id => l_fnd_user_id
79: ,resp_id => l_resp_id
80: ,resp_appl_id => l_resp_appl_id );
81: --
82: -- Submit the concurrent Request