3752: BEGIN
3753:
3754:
3755:
3756: l_user_id := nvl(FND_GLOBAL.user_id, -1);
3757:
3758: l_login_id := nvl(FND_GLOBAL.conc_login_id, -1);
3759:
3760:
3754:
3755:
3756: l_user_id := nvl(FND_GLOBAL.user_id, -1);
3757:
3758: l_login_id := nvl(FND_GLOBAL.conc_login_id, -1);
3759:
3760:
3761:
3762: IF p_status = 'MOVING' AND p_api_initiated THEN
4228: L_TEMP VARCHAR2(4000);
4229:
4230: BEGIN
4231:
4232: l_user_id := nvl(FND_GLOBAL.user_id, -1);
4233:
4234: l_login_id := nvl(FND_GLOBAL.conc_login_id, -1);
4235:
4236:
4230: BEGIN
4231:
4232: l_user_id := nvl(FND_GLOBAL.user_id, -1);
4233:
4234: l_login_id := nvl(FND_GLOBAL.conc_login_id, -1);
4235:
4236:
4237:
4238: BEGIN
5610: l_login_id NUMBER;
5611:
5612: BEGIN
5613:
5614: l_user_id := nvl(FND_GLOBAL.user_id, -1);
5615:
5616: l_login_id := nvl(FND_GLOBAL.conc_login_id, -1);
5617:
5618:
5612: BEGIN
5613:
5614: l_user_id := nvl(FND_GLOBAL.user_id, -1);
5615:
5616: l_login_id := nvl(FND_GLOBAL.conc_login_id, -1);
5617:
5618:
5619:
5620: BEGIN
10648: l_login_id NUMBER;
10649:
10650: BEGIN
10651:
10652: l_user_id := nvl(FND_GLOBAL.user_id, -1);
10653:
10654: l_login_id := nvl(FND_GLOBAL.conc_login_id, -1);
10655:
10656: INSERT INTO IEC_O_VALIDATION_HISTORY
10650: BEGIN
10651:
10652: l_user_id := nvl(FND_GLOBAL.user_id, -1);
10653:
10654: l_login_id := nvl(FND_GLOBAL.conc_login_id, -1);
10655:
10656: INSERT INTO IEC_O_VALIDATION_HISTORY
10657:
10658: ( VALIDATION_HISTORY_ID