APPS.AR_GTA_TXT_OPERATOR_PROC dependencies on AR_GTA_TRXIMP_TMP

Line 377: FROM AR_GTA_TRXIMP_TMP

373:
374: --get exact line number
375: SELECT MIN(import_seq)
376: INTO x_line_seq
377: FROM AR_GTA_TRXIMP_TMP
378: WHERE import_seq>=x_line_seq;
379:
380: --get a valid line and insert into out parameter.
381: LOOP

Line 438: FROM AR_GTA_TRXIMP_TMP

434: , x_values(22)
435: , x_values(23)
436: , x_values(24)
437: , x_values(25)
438: FROM AR_GTA_TRXIMP_TMP
439: WHERE import_seq=x_line_seq;
440:
441: --delete the line from temporary table
442: --DELETE AR_GTA_TRXIMP_TMP WHERE import_seq=x_line_seq;

Line 442: --DELETE AR_GTA_TRXIMP_TMP WHERE import_seq=x_line_seq;

438: FROM AR_GTA_TRXIMP_TMP
439: WHERE import_seq=x_line_seq;
440:
441: --delete the line from temporary table
442: --DELETE AR_GTA_TRXIMP_TMP WHERE import_seq=x_line_seq;
443:
444: --set the line number read next time
445: x_line_seq:=x_line_seq+1;
446:

Line 526: DELETE AR_GTA_TRXIMP_TMP;

522: IS
523: PRAGMA AUTONOMOUS_TRANSACTION;
524:
525: BEGIN
526: DELETE AR_GTA_TRXIMP_TMP;
527: COMMIT;
528:
529: END Clear_Imp_Temp_Table;
530:

Line 540: -- AR_GTA_TRXIMP_TMP and GTA_TRX_NUMBER is a unique column

536: -- DESCRIPTION:
537: --
538: -- This procedure import VAT invoices from flat file to GTA
539: -- Because SQL*Loader will import flat file to temporary table
540: -- AR_GTA_TRXIMP_TMP and GTA_TRX_NUMBER is a unique column
541: -- in GTA, so no parameter is needed here
542: --
543: -- PARAMETERS:
544: -- In: None