APPS.CSFW_DEBRIEF_PUB dependencies on FND_GLOBAL

Line 36: l_user := FND_GLOBAL.user_id;

32: open c_header_number;
33: fetch c_header_number into l_debrief_number;
34: close c_header_number;
35:
36: l_user := FND_GLOBAL.user_id;
37:
38: P_DEBRIEF_Rec.DEBRIEF_HEADER_ID := l_header_id ;
39: P_DEBRIEF_Rec.DEBRIEF_NUMBER := to_char(l_debrief_number);
40: P_DEBRIEF_Rec.DEBRIEF_DATE := sysdate;

Line 186: and a.user_id = FND_GLOBAL.USER_ID;

182: cursor find_resource is
183: select a.resource_id resource_id, b.resource_type resource_type
184: from CSP_RS_RESOURCES_V b, jtf_rs_resource_extns a
185: where a.resource_id =b.resource_id
186: and a.user_id = FND_GLOBAL.USER_ID;
187:
188: r_find_resource find_resource%ROWTYPE;
189:
190:

Line 306: l_user := FND_GLOBAL.user_id ;

302: l_order_header_id := 0;
303: p_error_id := 0; --Assume success
304: l_header_id := p_debrief_header_id;
305:
306: l_user := FND_GLOBAL.user_id ;
307:
308: open c_dbf_line_id;
309: fetch c_dbf_line_id into l_dbf_line_id;
310: close c_dbf_line_id;

Line 679: l_user := FND_GLOBAL.user_id ;

675: open c_dbf_lineId;
676: fetch c_dbf_lineId into l_dbf_line_id;
677: close c_dbf_lineId;
678:
679: l_user := FND_GLOBAL.user_id ;
680:
681: FND_PROFILE.GET ( 'CS_INV_VALIDATION_ORG' , l_organization_id);
682:
683: open c_uom_code (l_organization_id, p_inventory_item_id);

Line 968: l_user := FND_GLOBAL.user_id ;

964: open c_DEBRIEF_HEADER_ID(p_debrief_line_id);
965: fetch c_DEBRIEF_HEADER_ID into l_header_id;
966: close c_DEBRIEF_HEADER_ID;
967:
968: l_user := FND_GLOBAL.user_id ;
969:
970: FND_PROFILE.GET ( 'CS_INV_VALIDATION_ORG' , l_organization_id);
971:
972: open c_uom_code (l_organization_id, p_inventory_item_id);

Line 1169: and a.user_id = FND_GLOBAL.USER_ID;

1165: cursor find_resource is
1166: select a.resource_id resource_id, b.resource_type resource_type
1167: from CSP_RS_RESOURCES_V b, jtf_rs_resource_extns a
1168: where a.resource_id =b.resource_id
1169: and a.user_id = FND_GLOBAL.USER_ID;
1170:
1171: r_find_resource find_resource%ROWTYPE;
1172:
1173: BEGIN

Line 1279: --select FND_GLOBAL.user_id into l_user from dual;

1275: fetch c_DEBRIEF_HEADER_ID into l_header_id;
1276: close c_DEBRIEF_HEADER_ID;
1277:
1278:
1279: --select FND_GLOBAL.user_id into l_user from dual;
1280: l_user :=FND_GLOBAL.user_id ;
1281:
1282: FND_PROFILE.GET ( 'CS_INV_VALIDATION_ORG' , l_organization_id);
1283:

Line 1280: l_user :=FND_GLOBAL.user_id ;

1276: close c_DEBRIEF_HEADER_ID;
1277:
1278:
1279: --select FND_GLOBAL.user_id into l_user from dual;
1280: l_user :=FND_GLOBAL.user_id ;
1281:
1282: FND_PROFILE.GET ( 'CS_INV_VALIDATION_ORG' , l_organization_id);
1283:
1284:

Line 3293: l_user := FND_GLOBAL.user_id;

3289:
3290: Begin
3291: p_error_id := 0; --Assume success
3292:
3293: l_user := FND_GLOBAL.user_id;
3294:
3295: /* getting present values of the debrief header */
3296: open c_dbf_rec(p_debrief_header_id, p_task_assignment_id);
3297: fetch c_dbf_rec into P_DEBRIEF_Rec;