DBA Data[Home] [Help]

APPS.CS_WF_ACTIVITIES_PKG dependencies on FND_GLOBAL

Line 185: IF (NVL(l_user_id,-999) <> FND_GLOBAL.user_id OR

181: );
182:
183: -- Set the database session context
184:
185: IF (NVL(l_user_id,-999) <> FND_GLOBAL.user_id OR
186: NVL(l_resp_id,-999) <> FND_GLOBAL.resp_id OR
187: NVL(l_resp_appl_id,-999) <> FND_GLOBAL.resp_appl_id) THEN
188:
189: FND_GLOBAL.Apps_Initialize(l_user_id, l_resp_id, l_resp_appl_id);

Line 186: NVL(l_resp_id,-999) <> FND_GLOBAL.resp_id OR

182:
183: -- Set the database session context
184:
185: IF (NVL(l_user_id,-999) <> FND_GLOBAL.user_id OR
186: NVL(l_resp_id,-999) <> FND_GLOBAL.resp_id OR
187: NVL(l_resp_appl_id,-999) <> FND_GLOBAL.resp_appl_id) THEN
188:
189: FND_GLOBAL.Apps_Initialize(l_user_id, l_resp_id, l_resp_appl_id);
190:

Line 187: NVL(l_resp_appl_id,-999) <> FND_GLOBAL.resp_appl_id) THEN

183: -- Set the database session context
184:
185: IF (NVL(l_user_id,-999) <> FND_GLOBAL.user_id OR
186: NVL(l_resp_id,-999) <> FND_GLOBAL.resp_id OR
187: NVL(l_resp_appl_id,-999) <> FND_GLOBAL.resp_appl_id) THEN
188:
189: FND_GLOBAL.Apps_Initialize(l_user_id, l_resp_id, l_resp_appl_id);
190:
191: END IF ;

Line 189: FND_GLOBAL.Apps_Initialize(l_user_id, l_resp_id, l_resp_appl_id);

185: IF (NVL(l_user_id,-999) <> FND_GLOBAL.user_id OR
186: NVL(l_resp_id,-999) <> FND_GLOBAL.resp_id OR
187: NVL(l_resp_appl_id,-999) <> FND_GLOBAL.resp_appl_id) THEN
188:
189: FND_GLOBAL.Apps_Initialize(l_user_id, l_resp_id, l_resp_appl_id);
190:
191: END IF ;
192:
193: result := 'COMPLETE';

Line 214: l_g_user_id := fnd_global.user_id;

210: aname => 'RESP_APPL_ID'
211: );
212:
213:
214: l_g_user_id := fnd_global.user_id;
215: l_g_resp_id := fnd_global.resp_id;
216: l_g_resp_appl_id := fnd_global.resp_appl_id;
217:
218: -- result := 'COMPLETE';

Line 215: l_g_resp_id := fnd_global.resp_id;

211: );
212:
213:
214: l_g_user_id := fnd_global.user_id;
215: l_g_resp_id := fnd_global.resp_id;
216: l_g_resp_appl_id := fnd_global.resp_appl_id;
217:
218: -- result := 'COMPLETE';
219: IF l_g_user_id = l_user_id

Line 216: l_g_resp_appl_id := fnd_global.resp_appl_id;

212:
213:
214: l_g_user_id := fnd_global.user_id;
215: l_g_resp_id := fnd_global.resp_id;
216: l_g_resp_appl_id := fnd_global.resp_appl_id;
217:
218: -- result := 'COMPLETE';
219: IF l_g_user_id = l_user_id
220: and l_g_resp_id = l_resp_id

Line 892: WHERE login_id = FND_GLOBAL.LOGIN_ID

888:
889: BEGIN
890: SELECT login_id INTO l_login_id
891: FROM fnd_logins
892: WHERE login_id = FND_GLOBAL.LOGIN_ID
893: AND user_id = l_user_id;
894: EXCEPTION
895: WHEN OTHERS THEN
896: l_login_id := NULL;

Line 917: IF (fnd_global.resp_id is null OR fnd_global.resp_id = -1) THEN

913: -- Commented out. Fix for bug 3065468. rmanabat 07/24/03
914: --l_new_owner_id := l_resource_id;
915:
916:
917: IF (fnd_global.resp_id is null OR fnd_global.resp_id = -1) THEN
918: l_resp_id := WF_ENGINE.GetItemAttrNumber(
919: itemtype => itemtype,
920: itemkey => itemkey,
921: aname => 'RESP_ID' );

Line 927: l_resp_id := fnd_global.resp_id;

923: itemtype => itemtype,
924: itemkey => itemkey,
925: aname => 'RESP_APPL_ID' );
926: ELSE
927: l_resp_id := fnd_global.resp_id;
928: l_resp_appl_id := fnd_global.resp_appl_id;
929: END IF;
930:
931: CS_ServiceRequest_PUB.Update_Owner (

Line 928: l_resp_appl_id := fnd_global.resp_appl_id;

924: itemkey => itemkey,
925: aname => 'RESP_APPL_ID' );
926: ELSE
927: l_resp_id := fnd_global.resp_id;
928: l_resp_appl_id := fnd_global.resp_appl_id;
929: END IF;
930:
931: CS_ServiceRequest_PUB.Update_Owner (
932: p_api_version => 2.0,

Line 1129: 3) Else, use fnd_global.user_id

1125: Fix for bug 2843395
1126:
1127: 1) See if fnd_profile.valuw returns an id
1128: 2) Else, see if the incident_owner_id(source_id) of the sr has a valid value
1129: 3) Else, use fnd_global.user_id
1130: */
1131: l_user_id := fnd_profile.value('USER_ID');
1132:
1133: IF (l_user_id IS NULL) THEN

Line 1152: l_user_id := fnd_global.USER_ID();

1148: l_errmsg_name := 'CS_WF_SR_GET_EMP_USER_ID';
1149: raise l_API_ERROR;
1150: END IF;
1151: ELSE
1152: l_user_id := fnd_global.USER_ID();
1153: END IF;
1154: END IF;
1155:
1156: -- Get the workflow process ID

Line 1212: WHERE login_id = FND_GLOBAL.LOGIN_ID

1208:
1209: BEGIN
1210: SELECT login_id INTO l_login_id
1211: FROM fnd_logins
1212: WHERE login_id = FND_GLOBAL.LOGIN_ID
1213: AND user_id = l_user_id;
1214: EXCEPTION
1215: WHEN OTHERS THEN
1216: l_login_id := NULL;

Line 1279: IF (fnd_global.resp_id is null OR fnd_global.resp_id = -1) THEN

1275:
1276: -- Added mandatory parameter last_update_program_code .11/19/02 rmanabat
1277: l_service_request_rec.last_update_program_code := 'SUPPORT.WF';
1278:
1279: IF (fnd_global.resp_id is null OR fnd_global.resp_id = -1) THEN
1280: l_resp_id := WF_ENGINE.GetItemAttrNumber(
1281: itemtype => itemtype,
1282: itemkey => itemkey,
1283: aname => 'RESP_ID' );

Line 1289: l_resp_id := fnd_global.resp_id;

1285: itemtype => itemtype,
1286: itemkey => itemkey,
1287: aname => 'RESP_APPL_ID' );
1288: ELSE
1289: l_resp_id := fnd_global.resp_id;
1290: l_resp_appl_id := fnd_global.resp_appl_id;
1291: END IF;
1292:
1293:

Line 1290: l_resp_appl_id := fnd_global.resp_appl_id;

1286: itemkey => itemkey,
1287: aname => 'RESP_APPL_ID' );
1288: ELSE
1289: l_resp_id := fnd_global.resp_id;
1290: l_resp_appl_id := fnd_global.resp_appl_id;
1291: END IF;
1292:
1293:
1294: CS_ServiceRequest_PVT.Update_ServiceRequest

Line 1655: FND_GLOBAL.Apps_Initialize(l_user_id, l_resp_id, l_resp_appl_id);

1651: aname => 'RESP_APPL_ID'
1652: );
1653:
1654: -- Set the database session context
1655: FND_GLOBAL.Apps_Initialize(l_user_id, l_resp_id, l_resp_appl_id);
1656:
1657: result := 'COMPLETE';
1658:
1659: -- Notification Viewer form calls TEST_CTX just before launching a form

Line 2326: FND_GLOBAL.user_id,

2322: problem_summary)
2323: VALUES(
2324: l_fs_interface_id,
2325: sysdate,
2326: FND_GLOBAL.user_id,
2327: sysdate,
2328: FND_GLOBAL.user_id,
2329: FND_GLOBAL.login_id,
2330: '1',

Line 2328: FND_GLOBAL.user_id,

2324: l_fs_interface_id,
2325: sysdate,
2326: FND_GLOBAL.user_id,
2327: sysdate,
2328: FND_GLOBAL.user_id,
2329: FND_GLOBAL.login_id,
2330: '1',
2331: NULL,
2332: action_rec.incident_number,

Line 2329: FND_GLOBAL.login_id,

2325: sysdate,
2326: FND_GLOBAL.user_id,
2327: sysdate,
2328: FND_GLOBAL.user_id,
2329: FND_GLOBAL.login_id,
2330: '1',
2331: NULL,
2332: action_rec.incident_number,
2333: action_rec.action_num,

Line 2481: LAST_UPDATED_BY = FND_GLOBAL.user_id,

2477:
2478: UPDATE CS_MFS_INTERFACE
2479: SET
2480: LAST_UPDATE_DATE = sysdate,
2481: LAST_UPDATED_BY = FND_GLOBAL.user_id,
2482: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
2483: STATUS_FLAG = 1,
2484: INCIDENT_NUMBER =action_rec.incident_number,
2485: ACTION_NUM =action_rec.action_num,

Line 2482: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,

2478: UPDATE CS_MFS_INTERFACE
2479: SET
2480: LAST_UPDATE_DATE = sysdate,
2481: LAST_UPDATED_BY = FND_GLOBAL.user_id,
2482: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
2483: STATUS_FLAG = 1,
2484: INCIDENT_NUMBER =action_rec.incident_number,
2485: ACTION_NUM =action_rec.action_num,
2486: INCIDENT_DATE =action_rec.incident_date,