APPS.FII_AP_INV_SUM_INC dependencies on FII_AP_INV_HOLDS_B

Line 685: g_state := 'Deleting records from the FII_AP_INV_HOLDS_B table';

681: FII_UTIL.put_line('');
682: end if;
683:
684:
685: g_state := 'Deleting records from the FII_AP_INV_HOLDS_B table';
686: if g_debug_flag = 'Y' then
687: FII_UTIL.put_line('');
688: FII_UTIL.put_line(g_state);
689: end if;

Line 691: DELETE FROM FII_AP_INV_HOLDS_B

687: FII_UTIL.put_line('');
688: FII_UTIL.put_line(g_state);
689: end if;
690:
691: DELETE FROM FII_AP_INV_HOLDS_B
692: WHERE Invoice_ID IN (SELECT Key_Value1_Num
693: FROM FII_AP_DBI_LOG_T
694: WHERE Table_Name = 'AP_INVOICES'
695: AND Operation_Flag = 'D');

Line 698: FII_UTIL.put_line('Deleted '|| SQL%ROWCOUNT ||' records from the FII_AP_INV_HOLDS_B');

694: WHERE Table_Name = 'AP_INVOICES'
695: AND Operation_Flag = 'D');
696:
697: if g_debug_flag = 'Y' then
698: FII_UTIL.put_line('Deleted '|| SQL%ROWCOUNT ||' records from the FII_AP_INV_HOLDS_B');
699: FII_UTIL.put_line('');
700: end if;
701:
702:

Line 748: g_state := 'Deleting holds from FII_AP_INV_HOLDS_B';

744: if g_debug_flag = 'Y' then
745: FII_UTIL.put_line('Inside the procedure POPULATE_HOLDS_SUM');
746: end if;
747:
748: g_state := 'Deleting holds from FII_AP_INV_HOLDS_B';
749: if g_debug_flag = 'Y' then
750: FII_UTIL.put_line('');
751: FII_UTIL.put_line(g_state);
752: FII_UTIL.start_timer;

Line 756: DELETE FROM FII_AP_INV_HOLDS_B

752: FII_UTIL.start_timer;
753: FII_UTIL.put_line('');
754: end if;
755:
756: DELETE FROM FII_AP_INV_HOLDS_B
757: WHERE Invoice_ID IN (SELECT /*+ cardinality(T,100) */ Key_Value1_Num
758: FROM FII_AP_DBI_LOG_T T
759: WHERE Table_Name = 'AP_HOLDS');
760:

Line 761: DELETE /*+ index(B) push_subq */ FROM FII_AP_INV_HOLDS_B B

757: WHERE Invoice_ID IN (SELECT /*+ cardinality(T,100) */ Key_Value1_Num
758: FROM FII_AP_DBI_LOG_T T
759: WHERE Table_Name = 'AP_HOLDS');
760:
761: DELETE /*+ index(B) push_subq */ FROM FII_AP_INV_HOLDS_B B
762: WHERE Invoice_ID IN (SELECT /*+ cardinality(Log,1) */ Key_Value1_Num
763: FROM FII_AP_DBI_LOG_T Log, FII_AP_Invoice_B AI
764: WHERE Log.Key_Value1_Num = AI.Invoice_ID
765: AND AI.Cancel_Date IS NOT NULL

Line 768: g_state := 'Populating FII_AP_INV_HOLDS_B FROM AP_HOLDS_ALL table';

764: WHERE Log.Key_Value1_Num = AI.Invoice_ID
765: AND AI.Cancel_Date IS NOT NULL
766: AND Log.Table_Name = 'AP_INVOICES');
767:
768: g_state := 'Populating FII_AP_INV_HOLDS_B FROM AP_HOLDS_ALL table';
769: if g_debug_flag = 'Y' then
770: FII_UTIL.put_line(g_state);
771: end if;
772:

Line 773: INSERT INTO FII_AP_INV_HOLDS_B

769: if g_debug_flag = 'Y' then
770: FII_UTIL.put_line(g_state);
771: end if;
772:
773: INSERT INTO FII_AP_INV_HOLDS_B
774: (Time_ID,
775: Period_Type_ID,
776: Org_ID,
777: Supplier_ID,

Line 839: FII_UTIL.put_line('Inserted ' || SQL%ROWCOUNT || ' records into FII_AP_INV_HOLDS_B');

835: AND AI.Invoice_Type NOT IN ('PREPAYMENT')
836: AND AH.Invoice_ID = T.Key_Value1_Num;
837:
838: if g_debug_flag = 'Y' then
839: FII_UTIL.put_line('Inserted ' || SQL%ROWCOUNT || ' records into FII_AP_INV_HOLDS_B');
840: FII_UTIL.put_line('');
841: FII_UTIL.stop_timer;
842: FII_UTIL.print_timer('Duration');
843: end if;

Line 845: UPDATE FII_AP_INV_HOLDS_B HSUM

841: FII_UTIL.stop_timer;
842: FII_UTIL.print_timer('Duration');
843: end if;
844:
845: UPDATE FII_AP_INV_HOLDS_B HSUM
846: SET Supplier_ID = (SELECT AI.Supplier_ID
847: FROM FII_AP_Invoice_B AI
848: WHERE AI.Invoice_ID = HSUM.Invoice_ID)
849: WHERE HSUM.Invoice_ID IN (SELECT Key_Value1_Num