APPS.OE_RESERVE_CONC dependencies on FND_GLOBAL

Line 367: last_update_login = FND_GLOBAL.CONC_LOGIN_ID,

363: UPDATE oe_reservation_sets
364: SET process_flag = 'Y',
365: reservation_request_id = l_request_id,
366: program_update_date = sysdate,
367: last_update_login = FND_GLOBAL.CONC_LOGIN_ID,
368: last_updated_by = FND_GLOBAL.USER_ID,
369: last_update_date = sysdate
370: WHERE reservation_set_id = p_reservation_set_id;
371: IF (SQL%NOTFOUND) THEN

Line 368: last_updated_by = FND_GLOBAL.USER_ID,

364: SET process_flag = 'Y',
365: reservation_request_id = l_request_id,
366: program_update_date = sysdate,
367: last_update_login = FND_GLOBAL.CONC_LOGIN_ID,
368: last_updated_by = FND_GLOBAL.USER_ID,
369: last_update_date = sysdate
370: WHERE reservation_set_id = p_reservation_set_id;
371: IF (SQL%NOTFOUND) THEN
372: x_return_status := FND_API.G_RET_STS_ERROR;

Line 414: g_program_application_id := Fnd_global.PROG_APPL_ID;

410: oe_debug_pub.add( 'ENTERING CREATE_RESERVATION_SET ' , 1 ) ;
411: END IF;
412:
413: IF g_set_id IS NULL THEN
414: g_program_application_id := Fnd_global.PROG_APPL_ID;
415: g_program_id := Fnd_Global.Conc_Program_Id;
416:
417: -- Deleting records from table for the given set name.
418: BEGIN

Line 415: g_program_id := Fnd_Global.Conc_Program_Id;

411: END IF;
412:
413: IF g_set_id IS NULL THEN
414: g_program_application_id := Fnd_global.PROG_APPL_ID;
415: g_program_id := Fnd_Global.Conc_Program_Id;
416:
417: -- Deleting records from table for the given set name.
418: BEGIN
419: SELECT reservation_set_id into l_set_id

Line 466: , FND_GLOBAL.USER_ID

462: , p_rsv_request_id
463: , l_process_flag
464: , p_simulation_request_id
465: , sysdate
466: , FND_GLOBAL.USER_ID
467: , sysdate
468: , g_program_application_id
469: , g_program_id
470: , FND_GLOBAL.CONC_LOGIN_ID

Line 470: , FND_GLOBAL.CONC_LOGIN_ID

466: , FND_GLOBAL.USER_ID
467: , sysdate
468: , g_program_application_id
469: , g_program_id
470: , FND_GLOBAL.CONC_LOGIN_ID
471: , FND_GLOBAL.USER_ID
472: , sysdate);
473:
474: END IF;

Line 471: , FND_GLOBAL.USER_ID

467: , sysdate
468: , g_program_application_id
469: , g_program_id
470: , FND_GLOBAL.CONC_LOGIN_ID
471: , FND_GLOBAL.USER_ID
472: , sysdate);
473:
474: END IF;
475: -- Insert Detail Information

Line 521: ,FND_GLOBAL.USER_ID

517: ,NVL(p_rsv_tbl(I).corrected_reserved_qty2,p_rsv_tbl(I).derived_reserved_qty2) -- INVCONV
518: ,p_rsv_tbl(I).ship_from_org_id
519: ,p_rsv_tbl(I).subinventory
520: ,sysdate
521: ,FND_GLOBAL.USER_ID
522: ,sysdate
523: ,FND_GLOBAL.USER_ID
524: ,FND_GLOBAL.CONC_LOGIN_ID
525: ,g_program_application_id

Line 523: ,FND_GLOBAL.USER_ID

519: ,p_rsv_tbl(I).subinventory
520: ,sysdate
521: ,FND_GLOBAL.USER_ID
522: ,sysdate
523: ,FND_GLOBAL.USER_ID
524: ,FND_GLOBAL.CONC_LOGIN_ID
525: ,g_program_application_id
526: ,g_program_id
527: ,sysdate);

Line 524: ,FND_GLOBAL.CONC_LOGIN_ID

520: ,sysdate
521: ,FND_GLOBAL.USER_ID
522: ,sysdate
523: ,FND_GLOBAL.USER_ID
524: ,FND_GLOBAL.CONC_LOGIN_ID
525: ,g_program_application_id
526: ,g_program_id
527: ,sysdate);
528: IF l_line_count = 500 THEN

Line 2154: --AND CREATED_BY = FND_GLOBAL.USER_ID ;

2150: IF p_reserve_set_name IS NOT NULL THEN
2151: SELECT created_by INTO l_created_by
2152: from OE_RESERVATION_SETS
2153: WHERE reservation_set_name = p_reserve_set_name;
2154: --AND CREATED_BY = FND_GLOBAL.USER_ID ;
2155: IF l_created_by <> FND_GLOBAL.USER_ID THEN
2156: Fnd_Message.set_name('ONT', 'ONT_RSV_SET_NOT_CREATED_BY_USR');
2157: Fnd_Message.Set_Token('SET_NAME', p_reserve_set_name );
2158: Oe_Msg_Pub.Add;

Line 2155: IF l_created_by <> FND_GLOBAL.USER_ID THEN

2151: SELECT created_by INTO l_created_by
2152: from OE_RESERVATION_SETS
2153: WHERE reservation_set_name = p_reserve_set_name;
2154: --AND CREATED_BY = FND_GLOBAL.USER_ID ;
2155: IF l_created_by <> FND_GLOBAL.USER_ID THEN
2156: Fnd_Message.set_name('ONT', 'ONT_RSV_SET_NOT_CREATED_BY_USR');
2157: Fnd_Message.Set_Token('SET_NAME', p_reserve_set_name );
2158: Oe_Msg_Pub.Add;
2159: OE_MSG_PUB.Save_Messages(p_request_id => l_request_id);