APPS.AP_XLA_UPGRADE_PKG dependencies on AP_TRIAL_BALANCE_LEDGERS

Line 1597: FROM AP_Trial_Balance_Ledgers

1593:
1594: AP_Debug_Pkg.Print('Y', 'Begin of Trial Balance');
1595: SELECT count(*)
1596: INTO l_rows_to_process
1597: FROM AP_Trial_Balance_Ledgers
1598: WHERE ((Status IS NULL)
1599: OR (Status = 'S' and Worker_No = p_worker_id));
1600:
1601: AP_Debug_Pkg.Print('Y', 'Number of ledgers to process '|| l_rows_to_process);

Line 1610: FROM AP_Trial_Balance_Ledgers

1606: WHILE (l_any_rows_to_process = TRUE) LOOP
1607:
1608: SELECT count(*)
1609: INTO l_restarted_ledgers
1610: FROM AP_Trial_Balance_Ledgers
1611: WHERE Status = 'S'
1612: AND Worker_No = p_worker_id;
1613:
1614: IF l_restarted_ledgers = 0 THEN

Line 1617: UPDATE AP_Trial_Balance_Ledgers

1613:
1614: IF l_restarted_ledgers = 0 THEN
1615:
1616: AP_Debug_Pkg.Print('Y', 'Update the ledger for processing');
1617: UPDATE AP_Trial_Balance_Ledgers
1618: SET Status = 'S',
1619: Worker_No = p_worker_id
1620: WHERE Status IS NULL
1621: AND Rownum < 2;

Line 1628: FROM AP_Trial_Balance_Ledgers

1624: COMMIT;
1625:
1626: SELECT Ledger_ID
1627: INTO l_ledger_id
1628: FROM AP_Trial_Balance_Ledgers
1629: WHERE Status = 'S'
1630: AND Worker_No = p_worker_id;
1631:
1632: IF l_ledger_id IS NOT NULL THEN

Line 1647: UPDATE AP_Trial_Balance_Ledgers

1643:
1644: AP_Debug_Pkg.Print('Y', 'End of Create_Trial_Balance');
1645: END IF;
1646:
1647: UPDATE AP_Trial_Balance_Ledgers
1648: SET Status = 'P'
1649: WHERE Status = 'S'
1650: AND Worker_No = p_worker_id;
1651:

Line 1656: FROM AP_Trial_Balance_Ledgers

1652: COMMIT;
1653:
1654: SELECT count(*)
1655: INTO l_rows_to_process
1656: FROM AP_Trial_Balance_Ledgers
1657: WHERE Status IS NULL;
1658:
1659: IF l_rows_to_process > 0 THEN
1660: l_any_rows_to_process := TRUE;

Line 1752: l_stmt := 'TRUNCATE TABLE ' || l_table_owner || '.AP_TRIAL_BALANCE_LEDGERS';

1748: IF (FND_INSTALLATION.GET_APP_INFO('SQLAP', l_status, l_industry, l_table_owner)) THEN
1749: NULL;
1750: END IF;
1751:
1752: l_stmt := 'TRUNCATE TABLE ' || l_table_owner || '.AP_TRIAL_BALANCE_LEDGERS';
1753: Execute Immediate l_stmt;
1754:
1755: AP_Debug_Pkg.Print('Y', 'Inserting into ap_trial_balance_ledgers');
1756:

Line 1755: AP_Debug_Pkg.Print('Y', 'Inserting into ap_trial_balance_ledgers');

1751:
1752: l_stmt := 'TRUNCATE TABLE ' || l_table_owner || '.AP_TRIAL_BALANCE_LEDGERS';
1753: Execute Immediate l_stmt;
1754:
1755: AP_Debug_Pkg.Print('Y', 'Inserting into ap_trial_balance_ledgers');
1756:
1757: INSERT INTO ap_trial_balance_ledgers
1758: (Ledger_ID,
1759: Worker_No,

Line 1757: INSERT INTO ap_trial_balance_ledgers

1753: Execute Immediate l_stmt;
1754:
1755: AP_Debug_Pkg.Print('Y', 'Inserting into ap_trial_balance_ledgers');
1756:
1757: INSERT INTO ap_trial_balance_ledgers
1758: (Ledger_ID,
1759: Worker_No,
1760: Status,
1761: Creation_Date,