APPS.JMF_GTA_TXT_OPERATOR_PROC dependencies on JMF_GTA_TRXIMP_TMP

Line 343: FROM JMF_GTA_TRXIMP_TMP

339:
340: --get exact line number
341: SELECT MIN(import_seq)
342: INTO x_line_seq
343: FROM JMF_GTA_TRXIMP_TMP
344: WHERE import_seq>=x_line_seq;
345:
346: --get a valid line and insert into out parameter.
347: LOOP

Line 404: FROM JMF_GTA_TRXIMP_TMP

400: , x_values(22)
401: , x_values(23)
402: , x_values(24)
403: , x_values(25)
404: FROM JMF_GTA_TRXIMP_TMP
405: WHERE import_seq=x_line_seq;
406:
407: --delete the line from temporary table
408: --DELETE JMF_GTA_TRXIMP_TMP WHERE import_seq=x_line_seq;

Line 408: --DELETE JMF_GTA_TRXIMP_TMP WHERE import_seq=x_line_seq;

404: FROM JMF_GTA_TRXIMP_TMP
405: WHERE import_seq=x_line_seq;
406:
407: --delete the line from temporary table
408: --DELETE JMF_GTA_TRXIMP_TMP WHERE import_seq=x_line_seq;
409:
410: --set the line number read next time
411: x_line_seq:=x_line_seq+1;
412:

Line 492: DELETE JMF_GTA_TRXIMP_TMP;

488: IS
489: PRAGMA AUTONOMOUS_TRANSACTION;
490:
491: BEGIN
492: DELETE JMF_GTA_TRXIMP_TMP;
493: COMMIT;
494:
495: END Clear_Imp_Temp_Table;
496:

Line 506: -- JMF_GTA_TRXIMP_TMP and GTA_TRX_NUMBER is a unique column

502: -- DESCRIPTION:
503: --
504: -- This procedure import VAT invoices from flat file to GTA
505: -- Because SQL*Loader will import flat file to temporary table
506: -- JMF_GTA_TRXIMP_TMP and GTA_TRX_NUMBER is a unique column
507: -- in GTA, so no parameter is needed here
508: --
509: -- PARAMETERS:
510: -- In: None