APPS.OE_RESERVE_CONC dependencies on FND_GLOBAL

Line 443: last_update_login = FND_GLOBAL.CONC_LOGIN_ID,

439: UPDATE oe_reservation_sets
440: SET process_flag = 'Y',
441: reservation_request_id = l_request_id,
442: program_update_date = sysdate,
443: last_update_login = FND_GLOBAL.CONC_LOGIN_ID,
444: last_updated_by = FND_GLOBAL.USER_ID,
445: last_update_date = sysdate
446: WHERE reservation_set_id = p_reservation_set_id;
447: IF (SQL%NOTFOUND) THEN

Line 444: last_updated_by = FND_GLOBAL.USER_ID,

440: SET process_flag = 'Y',
441: reservation_request_id = l_request_id,
442: program_update_date = sysdate,
443: last_update_login = FND_GLOBAL.CONC_LOGIN_ID,
444: last_updated_by = FND_GLOBAL.USER_ID,
445: last_update_date = sysdate
446: WHERE reservation_set_id = p_reservation_set_id;
447: IF (SQL%NOTFOUND) THEN
448: x_return_status := FND_API.G_RET_STS_ERROR;

Line 490: g_program_application_id := Fnd_global.PROG_APPL_ID;

486: oe_debug_pub.add( 'ENTERING CREATE_RESERVATION_SET ' , 1 ) ;
487: END IF;
488:
489: IF g_set_id IS NULL THEN
490: g_program_application_id := Fnd_global.PROG_APPL_ID;
491: g_program_id := Fnd_Global.Conc_Program_Id;
492:
493: -- Deleting records from table for the given set name.
494: BEGIN

Line 491: g_program_id := Fnd_Global.Conc_Program_Id;

487: END IF;
488:
489: IF g_set_id IS NULL THEN
490: g_program_application_id := Fnd_global.PROG_APPL_ID;
491: g_program_id := Fnd_Global.Conc_Program_Id;
492:
493: -- Deleting records from table for the given set name.
494: BEGIN
495: SELECT reservation_set_id into l_set_id

Line 542: , FND_GLOBAL.USER_ID

538: , p_rsv_request_id
539: , l_process_flag
540: , p_simulation_request_id
541: , sysdate
542: , FND_GLOBAL.USER_ID
543: , sysdate
544: , g_program_application_id
545: , g_program_id
546: , FND_GLOBAL.CONC_LOGIN_ID

Line 546: , FND_GLOBAL.CONC_LOGIN_ID

542: , FND_GLOBAL.USER_ID
543: , sysdate
544: , g_program_application_id
545: , g_program_id
546: , FND_GLOBAL.CONC_LOGIN_ID
547: , FND_GLOBAL.USER_ID
548: , sysdate);
549:
550: END IF;

Line 547: , FND_GLOBAL.USER_ID

543: , sysdate
544: , g_program_application_id
545: , g_program_id
546: , FND_GLOBAL.CONC_LOGIN_ID
547: , FND_GLOBAL.USER_ID
548: , sysdate);
549:
550: END IF;
551: -- Insert Detail Information

Line 597: ,FND_GLOBAL.USER_ID

593: ,NVL(p_rsv_tbl(I).corrected_reserved_qty2,p_rsv_tbl(I).derived_reserved_qty2) -- INVCONV
594: ,p_rsv_tbl(I).ship_from_org_id
595: ,p_rsv_tbl(I).subinventory
596: ,sysdate
597: ,FND_GLOBAL.USER_ID
598: ,sysdate
599: ,FND_GLOBAL.USER_ID
600: ,FND_GLOBAL.CONC_LOGIN_ID
601: ,g_program_application_id

Line 599: ,FND_GLOBAL.USER_ID

595: ,p_rsv_tbl(I).subinventory
596: ,sysdate
597: ,FND_GLOBAL.USER_ID
598: ,sysdate
599: ,FND_GLOBAL.USER_ID
600: ,FND_GLOBAL.CONC_LOGIN_ID
601: ,g_program_application_id
602: ,g_program_id
603: ,sysdate);

Line 600: ,FND_GLOBAL.CONC_LOGIN_ID

596: ,sysdate
597: ,FND_GLOBAL.USER_ID
598: ,sysdate
599: ,FND_GLOBAL.USER_ID
600: ,FND_GLOBAL.CONC_LOGIN_ID
601: ,g_program_application_id
602: ,g_program_id
603: ,sysdate);
604: IF l_line_count = 500 THEN

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

2203: IF p_reserve_set_name IS NOT NULL THEN
2204: SELECT created_by INTO l_created_by
2205: from OE_RESERVATION_SETS
2206: WHERE reservation_set_name = p_reserve_set_name;
2207: --AND CREATED_BY = FND_GLOBAL.USER_ID ;
2208: IF l_created_by <> FND_GLOBAL.USER_ID THEN
2209: Fnd_Message.set_name('ONT', 'ONT_RSV_SET_NOT_CREATED_BY_USR');
2210: Fnd_Message.Set_Token('SET_NAME', p_reserve_set_name );
2211: Oe_Msg_Pub.Add;

Line 2208: IF l_created_by <> FND_GLOBAL.USER_ID THEN

2204: SELECT created_by INTO l_created_by
2205: from OE_RESERVATION_SETS
2206: WHERE reservation_set_name = p_reserve_set_name;
2207: --AND CREATED_BY = FND_GLOBAL.USER_ID ;
2208: IF l_created_by <> FND_GLOBAL.USER_ID THEN
2209: Fnd_Message.set_name('ONT', 'ONT_RSV_SET_NOT_CREATED_BY_USR');
2210: Fnd_Message.Set_Token('SET_NAME', p_reserve_set_name );
2211: Oe_Msg_Pub.Add;
2212: OE_MSG_PUB.Save_Messages(p_request_id => l_request_id);