DBA Data[Home] [Help]

APPS.CS_WF_EVENT_SUBSCRIPTIONS_PKG dependencies on FND_GLOBAL

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

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

Line 86: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;

82: IF (NVL(c_sr_task_sr_closure_rec.open_flag ,'X') = 'N') THEN
83: l_status_prop_flag := 'Y';
84: l_request_id := c_sr_task_sr_closure_rec.source_object_id;
85: l_user_id := NVL(c_sr_task_sr_closure_rec.last_updated_by,FND_GLOBAL.USER_ID);
86: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
87: l_login_id := NVL(c_sr_task_sr_closure_rec.last_update_login,FND_GLOBAL.LOGIN_ID) ;
88:
89: --Added below code for bug 9706346
90: l_user_id := NVL(c_sr_task_sr_closure_rec.last_updated_by,p_event.GetValueForParameter('USERID'));

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

83: l_status_prop_flag := 'Y';
84: l_request_id := c_sr_task_sr_closure_rec.source_object_id;
85: l_user_id := NVL(c_sr_task_sr_closure_rec.last_updated_by,FND_GLOBAL.USER_ID);
86: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
87: l_login_id := NVL(c_sr_task_sr_closure_rec.last_update_login,FND_GLOBAL.LOGIN_ID) ;
88:
89: --Added below code for bug 9706346
90: l_user_id := NVL(c_sr_task_sr_closure_rec.last_updated_by,p_event.GetValueForParameter('USERID'));
91: l_resp_id := p_event.GetValueForParameter('RESPID');

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

118: IF (c_sr_task_status_audit_rec.new_task_status_id <> c_sr_task_status_audit_rec.old_task_status_id) THEN
119:
120: l_status_prop_flag := 'Y';
121: l_request_id := c_sr_task_sr_closure_rec.source_object_id;
122: l_user_id := NVL(c_sr_task_sr_closure_rec.last_updated_by,FND_GLOBAL.USER_ID);
123: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
124: l_login_id := NVL(c_sr_task_sr_closure_rec.last_update_login,FND_GLOBAL.LOGIN_ID) ;
125: --Added below code for bug 9706346
126: l_user_id := NVL(c_sr_task_sr_closure_rec.last_updated_by,p_event.GetValueForParameter('USERID'));

Line 123: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;

119:
120: l_status_prop_flag := 'Y';
121: l_request_id := c_sr_task_sr_closure_rec.source_object_id;
122: l_user_id := NVL(c_sr_task_sr_closure_rec.last_updated_by,FND_GLOBAL.USER_ID);
123: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
124: l_login_id := NVL(c_sr_task_sr_closure_rec.last_update_login,FND_GLOBAL.LOGIN_ID) ;
125: --Added below code for bug 9706346
126: l_user_id := NVL(c_sr_task_sr_closure_rec.last_updated_by,p_event.GetValueForParameter('USERID'));
127: l_resp_id := p_event.GetValueForParameter('RESPID');

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

120: l_status_prop_flag := 'Y';
121: l_request_id := c_sr_task_sr_closure_rec.source_object_id;
122: l_user_id := NVL(c_sr_task_sr_closure_rec.last_updated_by,FND_GLOBAL.USER_ID);
123: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
124: l_login_id := NVL(c_sr_task_sr_closure_rec.last_update_login,FND_GLOBAL.LOGIN_ID) ;
125: --Added below code for bug 9706346
126: l_user_id := NVL(c_sr_task_sr_closure_rec.last_updated_by,p_event.GetValueForParameter('USERID'));
127: l_resp_id := p_event.GetValueForParameter('RESPID');
128: l_resp_appl_id := p_event.GetValueForParameter('APPLID');

Line 142: l_login_id := FND_GLOBAL.LOGIN_ID;

138: l_user_id := p_event.GetValueForParameter('USER_ID');
139: -- Bug 10330666
140: l_resp_appl_id := p_event.GetValueForParameter('APPLID');
141: --l_resp_appl_id := p_event.GetValueForParameter('RESP_APPL_ID');
142: l_login_id := FND_GLOBAL.LOGIN_ID;
143:
144: END IF;
145:
146: IF l_status_prop_flag = 'Y' THEN