612: end;
613: END IF;
614: g_prev_batch_id := g_batch_id;
615: SELECT
616: FND_GLOBAL.USER_ID,
617: FND_GLOBAL.USER_NAME,
618: FND_GLOBAL.RESP_NAME,
619: FND_GLOBAL.APPLICATION_NAME
620: INTO v_user_id,
613: END IF;
614: g_prev_batch_id := g_batch_id;
615: SELECT
616: FND_GLOBAL.USER_ID,
617: FND_GLOBAL.USER_NAME,
618: FND_GLOBAL.RESP_NAME,
619: FND_GLOBAL.APPLICATION_NAME
620: INTO v_user_id,
621: l_user_name,
614: g_prev_batch_id := g_batch_id;
615: SELECT
616: FND_GLOBAL.USER_ID,
617: FND_GLOBAL.USER_NAME,
618: FND_GLOBAL.RESP_NAME,
619: FND_GLOBAL.APPLICATION_NAME
620: INTO v_user_id,
621: l_user_name,
622: l_resp_name,
615: SELECT
616: FND_GLOBAL.USER_ID,
617: FND_GLOBAL.USER_NAME,
618: FND_GLOBAL.RESP_NAME,
619: FND_GLOBAL.APPLICATION_NAME
620: INTO v_user_id,
621: l_user_name,
622: l_resp_name,
623: l_application_name
984: end;
985: END IF;
986: g_prev_batch_id := g_batch_id;
987: SELECT
988: FND_GLOBAL.USER_ID,
989: FND_GLOBAL.USER_NAME,
990: FND_GLOBAL.RESP_NAME,
991: FND_GLOBAL.APPLICATION_NAME
992: INTO v_user_id,
985: END IF;
986: g_prev_batch_id := g_batch_id;
987: SELECT
988: FND_GLOBAL.USER_ID,
989: FND_GLOBAL.USER_NAME,
990: FND_GLOBAL.RESP_NAME,
991: FND_GLOBAL.APPLICATION_NAME
992: INTO v_user_id,
993: l_user_name,
986: g_prev_batch_id := g_batch_id;
987: SELECT
988: FND_GLOBAL.USER_ID,
989: FND_GLOBAL.USER_NAME,
990: FND_GLOBAL.RESP_NAME,
991: FND_GLOBAL.APPLICATION_NAME
992: INTO v_user_id,
993: l_user_name,
994: l_resp_name,
987: SELECT
988: FND_GLOBAL.USER_ID,
989: FND_GLOBAL.USER_NAME,
990: FND_GLOBAL.RESP_NAME,
991: FND_GLOBAL.APPLICATION_NAME
992: INTO v_user_id,
993: l_user_name,
994: l_resp_name,
995: l_application_name
1389:
1390: arg_loaded_int_repair_orders:= l_new_iro_num;
1391:
1392:
1393: l_user_id := FND_GLOBAL.USER_ID;
1394: l_user_name := FND_GLOBAL.USER_NAME;
1395: l_resp_name := FND_GLOBAL.RESP_NAME;
1396: l_application_name := FND_GLOBAL.APPLICATION_NAME;
1397:
1390: arg_loaded_int_repair_orders:= l_new_iro_num;
1391:
1392:
1393: l_user_id := FND_GLOBAL.USER_ID;
1394: l_user_name := FND_GLOBAL.USER_NAME;
1395: l_resp_name := FND_GLOBAL.RESP_NAME;
1396: l_application_name := FND_GLOBAL.APPLICATION_NAME;
1397:
1398:
1391:
1392:
1393: l_user_id := FND_GLOBAL.USER_ID;
1394: l_user_name := FND_GLOBAL.USER_NAME;
1395: l_resp_name := FND_GLOBAL.RESP_NAME;
1396: l_application_name := FND_GLOBAL.APPLICATION_NAME;
1397:
1398:
1399: SELECT APPLICATION_ID
1392:
1393: l_user_id := FND_GLOBAL.USER_ID;
1394: l_user_name := FND_GLOBAL.USER_NAME;
1395: l_resp_name := FND_GLOBAL.RESP_NAME;
1396: l_application_name := FND_GLOBAL.APPLICATION_NAME;
1397:
1398:
1399: SELECT APPLICATION_ID
1400: INTO l_application_id
1482: END IF;
1483: END IF ;
1484: arg_loaded_ext_repair_orders:= l_new_ero_num ;
1485:
1486: l_user_id := FND_GLOBAL.USER_ID;
1487: l_user_name := FND_GLOBAL.USER_NAME;
1488: l_resp_name := FND_GLOBAL.RESP_NAME;
1489: l_application_name := FND_GLOBAL.APPLICATION_NAME;
1490:
1483: END IF ;
1484: arg_loaded_ext_repair_orders:= l_new_ero_num ;
1485:
1486: l_user_id := FND_GLOBAL.USER_ID;
1487: l_user_name := FND_GLOBAL.USER_NAME;
1488: l_resp_name := FND_GLOBAL.RESP_NAME;
1489: l_application_name := FND_GLOBAL.APPLICATION_NAME;
1490:
1491: select nvl(application_id,724)
1484: arg_loaded_ext_repair_orders:= l_new_ero_num ;
1485:
1486: l_user_id := FND_GLOBAL.USER_ID;
1487: l_user_name := FND_GLOBAL.USER_NAME;
1488: l_resp_name := FND_GLOBAL.RESP_NAME;
1489: l_application_name := FND_GLOBAL.APPLICATION_NAME;
1490:
1491: select nvl(application_id,724)
1492: into l_application_id
1485:
1486: l_user_id := FND_GLOBAL.USER_ID;
1487: l_user_name := FND_GLOBAL.USER_NAME;
1488: l_resp_name := FND_GLOBAL.RESP_NAME;
1489: l_application_name := FND_GLOBAL.APPLICATION_NAME;
1490:
1491: select nvl(application_id,724)
1492: into l_application_id
1493: from fnd_application_vl