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 147: and a.user_id = FND_GLOBAL.USER_ID;

143: cursor find_resource is
144: select a.resource_id resource_id, b.resource_type resource_type
145: from CSP_RS_RESOURCES_V b, jtf_rs_resource_extns a
146: where a.resource_id =b.resource_id
147: and a.user_id = FND_GLOBAL.USER_ID;
148:
149: r_find_resource find_resource%ROWTYPE;
150:
151:

Line 170: l_user := FND_GLOBAL.user_id ;

166: l_order_header_id := 0;
167: p_error_id := 0; --Assume success
168: l_header_id := p_debrief_header_id;
169:
170: l_user := FND_GLOBAL.user_id ;
171:
172: open c_dbf_line_id;
173: fetch c_dbf_line_id into l_dbf_line_id;
174: close c_dbf_line_id;

Line 384: l_user := FND_GLOBAL.user_id ;

380: open c_dbf_lineId;
381: fetch c_dbf_lineId into l_dbf_line_id;
382: close c_dbf_lineId;
383:
384: l_user := FND_GLOBAL.user_id ;
385:
386: FND_PROFILE.GET ( 'CS_INV_VALIDATION_ORG' , l_organization_id);
387:
388: open c_uom_code (l_organization_id, p_inventory_item_id);

Line 519: l_user := FND_GLOBAL.user_id ;

515: open c_DEBRIEF_HEADER_ID(p_debrief_line_id);
516: fetch c_DEBRIEF_HEADER_ID into l_header_id;
517: close c_DEBRIEF_HEADER_ID;
518:
519: l_user := FND_GLOBAL.user_id ;
520:
521: FND_PROFILE.GET ( 'CS_INV_VALIDATION_ORG' , l_organization_id);
522:
523: open c_uom_code (l_organization_id, p_inventory_item_id);

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

656: cursor find_resource is
657: select a.resource_id resource_id, b.resource_type resource_type
658: from CSP_RS_RESOURCES_V b, jtf_rs_resource_extns a
659: where a.resource_id =b.resource_id
660: and a.user_id = FND_GLOBAL.USER_ID;
661:
662: r_find_resource find_resource%ROWTYPE;
663:
664: BEGIN

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

668: fetch c_DEBRIEF_HEADER_ID into l_header_id;
669: close c_DEBRIEF_HEADER_ID;
670:
671:
672: --select FND_GLOBAL.user_id into l_user from dual;
673: l_user :=FND_GLOBAL.user_id ;
674:
675: FND_PROFILE.GET ( 'CS_INV_VALIDATION_ORG' , l_organization_id);
676:

Line 673: l_user :=FND_GLOBAL.user_id ;

669: close c_DEBRIEF_HEADER_ID;
670:
671:
672: --select FND_GLOBAL.user_id into l_user from dual;
673: l_user :=FND_GLOBAL.user_id ;
674:
675: FND_PROFILE.GET ( 'CS_INV_VALIDATION_ORG' , l_organization_id);
676:
677:

Line 2444: l_user := FND_GLOBAL.user_id;

2440:
2441: Begin
2442: p_error_id := 0; --Assume success
2443:
2444: l_user := FND_GLOBAL.user_id;
2445:
2446: /* getting present values of the debrief header */
2447: open c_dbf_rec(p_debrief_header_id, p_task_assignment_id);
2448: fetch c_dbf_rec into P_DEBRIEF_Rec;