DBA Data[Home] [Help]

APPS.CS_WF_EVENT_SUBSCRIPTIONS_PKG dependencies on FND_GLOBAL

Line 84: l_user_id := NVL(c_sr_task_sr_closure_rec.last_updated_by,FND_GLOBAL.USER_ID);

80: END IF;
81: IF (NVL(c_sr_task_sr_closure_rec.open_flag ,'X') = 'N') THEN
82: l_status_prop_flag := 'Y';
83: l_request_id := c_sr_task_sr_closure_rec.source_object_id;
84: l_user_id := NVL(c_sr_task_sr_closure_rec.last_updated_by,FND_GLOBAL.USER_ID);
85: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
86: l_login_id := NVL(c_sr_task_sr_closure_rec.last_update_login,FND_GLOBAL.LOGIN_ID) ;
87: END IF;
88: END IF;

Line 85: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;

81: IF (NVL(c_sr_task_sr_closure_rec.open_flag ,'X') = 'N') THEN
82: l_status_prop_flag := 'Y';
83: l_request_id := c_sr_task_sr_closure_rec.source_object_id;
84: l_user_id := NVL(c_sr_task_sr_closure_rec.last_updated_by,FND_GLOBAL.USER_ID);
85: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
86: l_login_id := NVL(c_sr_task_sr_closure_rec.last_update_login,FND_GLOBAL.LOGIN_ID) ;
87: END IF;
88: END IF;
89: --End Bug 7118071

Line 86: l_login_id := NVL(c_sr_task_sr_closure_rec.last_update_login,FND_GLOBAL.LOGIN_ID) ;

82: l_status_prop_flag := 'Y';
83: l_request_id := c_sr_task_sr_closure_rec.source_object_id;
84: l_user_id := NVL(c_sr_task_sr_closure_rec.last_updated_by,FND_GLOBAL.USER_ID);
85: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
86: l_login_id := NVL(c_sr_task_sr_closure_rec.last_update_login,FND_GLOBAL.LOGIN_ID) ;
87: END IF;
88: END IF;
89: --End Bug 7118071
90:

Line 116: l_user_id := NVL(c_sr_task_sr_closure_rec.last_updated_by,FND_GLOBAL.USER_ID);

112: IF (c_sr_task_status_audit_rec.new_task_status_id <> c_sr_task_status_audit_rec.old_task_status_id) THEN
113:
114: l_status_prop_flag := 'Y';
115: l_request_id := c_sr_task_sr_closure_rec.source_object_id;
116: l_user_id := NVL(c_sr_task_sr_closure_rec.last_updated_by,FND_GLOBAL.USER_ID);
117: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
118: l_login_id := NVL(c_sr_task_sr_closure_rec.last_update_login,FND_GLOBAL.LOGIN_ID) ;
119: END IF ;
120: END IF ;

Line 117: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;

113:
114: l_status_prop_flag := 'Y';
115: l_request_id := c_sr_task_sr_closure_rec.source_object_id;
116: l_user_id := NVL(c_sr_task_sr_closure_rec.last_updated_by,FND_GLOBAL.USER_ID);
117: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
118: l_login_id := NVL(c_sr_task_sr_closure_rec.last_update_login,FND_GLOBAL.LOGIN_ID) ;
119: END IF ;
120: END IF ;
121: END IF;

Line 118: l_login_id := NVL(c_sr_task_sr_closure_rec.last_update_login,FND_GLOBAL.LOGIN_ID) ;

114: l_status_prop_flag := 'Y';
115: l_request_id := c_sr_task_sr_closure_rec.source_object_id;
116: l_user_id := NVL(c_sr_task_sr_closure_rec.last_updated_by,FND_GLOBAL.USER_ID);
117: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
118: l_login_id := NVL(c_sr_task_sr_closure_rec.last_update_login,FND_GLOBAL.LOGIN_ID) ;
119: END IF ;
120: END IF ;
121: END IF;
122:

Line 130: l_login_id := FND_GLOBAL.LOGIN_ID;

126: l_status_prop_flag := 'Y';
127: l_request_id := p_event.GetValueForParameter('INCIDENT_ID');
128: l_user_id := p_event.GetValueForParameter('USER_ID');
129: l_resp_appl_id := p_event.GetValueForParameter('RESP_APPL_ID');
130: l_login_id := FND_GLOBAL.LOGIN_ID;
131:
132: END IF;
133:
134: IF l_status_prop_flag = 'Y' THEN