DBA Data[Home] [Help]

APPS.FTE_LTL_LOADER dependencies on QP_PROCESS_ID_S

Line 1144: SELECT qp_process_id_s.NEXTVAL

1140:
1141: FOR i IN 1..l_list_header_ids.COUNT
1142: LOOP
1143: -- Get a process id
1144: SELECT qp_process_id_s.NEXTVAL
1145: INTO l_process_id
1146: FROM DUAL;
1147:
1148: l_process_ids(l_process_ids.COUNT + 1) := l_process_id;

Line 1675: SELECT QP_PROCESS_ID_S.NEXTVAL

1671: x_status := -1;
1672: x_error_msg := 'COMPLETED';
1673:
1674: BEGIN
1675: SELECT QP_PROCESS_ID_S.NEXTVAL
1676: INTO x_process_ID
1677: FROM DUAL;
1678: EXCEPTION
1679: WHEN OTHERS THEN

Line 1681: x_error_msg := 'Unexpected error while performing select qp_process_id_s.nextval ' || sqlerrm;

1677: FROM DUAL;
1678: EXCEPTION
1679: WHEN OTHERS THEN
1680: x_status := 2;
1681: x_error_msg := 'Unexpected error while performing select qp_process_id_s.nextval ' || sqlerrm;
1682: FTE_UTIL_PKG.Write_LogFile(l_module_name, x_error_msg);
1683: FTE_UTIL_PKG.Exit_Debug(l_module_name);
1684: END;
1685: