eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_PURGE_PKG dependencies on FINANCIALS_PURGES

Line 30: Procedure Update_Financials_Purges ( p_check_rows IN NUMBER DEFAULT 0,

26:
27: -- Bug 8913560 : Added the following two procedures
28: PROCEDURE Submit_Multiple_Requests ( p_purge_name IN VARCHAR2,
29: p_success OUT NOCOPY BOOLEAN ) ; -- Bug 9268290
30: Procedure Update_Financials_Purges ( p_check_rows IN NUMBER DEFAULT 0,
31: p_invoice_payment_rows IN NUMBER DEFAULT 0,
32: p_invoice_rows IN NUMBER DEFAULT 0,
33: p_ae_line_rows IN NUMBER DEFAULT 0,
34: p_ae_header_rows IN NUMBER DEFAULT 0,

Line 96: Print('(Updating table financials_purges)'||debug_info);

92: 'Set_purge_status<-'||P_calling_sequence;
93: --
94: debug_info := 'Starting Set_purge_status';
95: IF (p_debug_switch in ('y','Y')) THEN
96: Print('(Updating table financials_purges)'||debug_info);
97: END IF;
98:
99: UPDATE financials_purges
100: SET status = P_Status

Line 99: UPDATE financials_purges

95: IF (p_debug_switch in ('y','Y')) THEN
96: Print('(Updating table financials_purges)'||debug_info);
97: END IF;
98:
99: UPDATE financials_purges
100: SET status = P_Status
101: WHERE purge_name = P_Purge_Name;
102: --
103: debug_info := 'End Set_purge_status';

Line 105: Print('(Done updating table financials_purges)'||debug_info);

101: WHERE purge_name = P_Purge_Name;
102: --
103: debug_info := 'End Set_purge_status';
104: IF (g_debug_switch in ('y','Y')) THEN
105: Print('(Done updating table financials_purges)'||debug_info);
106: END IF;
107: RETURN(TRUE);
108:
109: RETURN NULL;

Line 1582: FROM financials_purges

1578: SELECT NVL( approx_rows, 0 ),
1579: NVL(pay_alone,'A')
1580: INTO l_approx_rows,
1581: l_pay_alone
1582: FROM financials_purges
1583: WHERE purge_name = p_purge_name ;
1584:
1585: IF g_debug_switch in ('y','Y') THEN
1586: Print(' approx_rows: ' ||l_approx_rows|| ' pay_alone: ' || l_pay_alone );

Line 2072: from financials_purges

2068:
2069: --9481539
2070: select nvl(pay_alone,'A')
2071: into l_pay_alone
2072: from financials_purges
2073: where purge_name = P_Purge_Name ;
2074:
2075: -- Simple Invoices
2076: if (p_category = 'SIMPLE INVOICES') then

Line 4529: UPDATE financials_purges

4525: Print('(Record_Initial_Statistics)'||debug_info);
4526: END IF;
4527:
4528:
4529: UPDATE financials_purges
4530: SET
4531: ap_checks = fp_check_rows,
4532: ap_invoice_payments = fp_invoice_payment_rows,
4533: ap_invoices = fp_invoice_rows,

Line 5250: Update_Financials_Purges ( p_check_rows => l_check_rows ,

5246: AND C.check_number = overflow_check_number
5247: AND C.status_lookup_code = 'OVERFLOW';
5248:
5249: l_check_rows := SQL%ROWCOUNT ; -- Bug 8913560
5250: Update_Financials_Purges ( p_check_rows => l_check_rows ,
5251: p_purge_name => p_purge_name ) ;
5252:
5253: overflow_check_number := overflow_check_number - 1;
5254:

Line 5767: Update_Financials_Purges ( p_check_rows => l_check_rows ,

5763:
5764: l_invoice_rows := SQL%ROWCOUNT ; -- Bug 8913560
5765: P_rows_processed := l_invoice_rows ; -- 9481539
5766:
5767: Update_Financials_Purges ( p_check_rows => l_check_rows ,
5768: p_invoice_payment_rows => l_invoice_payment_rows,
5769: p_invoice_rows => l_invoice_rows ,
5770: p_invoice_lines_rows => l_invoice_lines_rows , --bug 11829621
5771: p_invoice_distributions_rows => l_invoice_distributions_rows, --bug 11829621

Line 6889: UPDATE financials_purges

6885: Print('count_ap_row failed.' );
6886: return(FALSE);
6887: end if;
6888:
6889: UPDATE financials_purges
6890: SET
6891: ap_checks = check_rows,
6892: ap_invoice_payments = invoice_payment_rows,
6893: ap_invoices = invoice_rows,

Line 6914: FROM financials_purges

6910: invoice_rows,
6911: ae_line_rows,
6912: ae_header_rows,
6913: accounting_event_rows
6914: FROM financials_purges
6915: WHERE purge_name = p_purge_name;
6916: END IF ;
6917:
6918: debug_info := 'Submitting Multiple Requests';

Line 7030: FROM financials_purges

7026: invoice_rows,
7027: ae_line_rows,
7028: ae_header_rows,
7029: accounting_event_rows
7030: FROM financials_purges
7031: WHERE purge_name = p_purge_name;
7032:
7033: debug_info := 'Submitting Multiple Requests';
7034: IF g_debug_switch in ('y','Y') THEN

Line 7192: UPDATE financials_purges

7188:
7189: IF ( l_purge_without_review <> 'Y' OR -- Bug 9268290
7190: p_category <> 'SIMPLE INVOICES' ) THEN
7191: -- record_final_statistics
7192: UPDATE financials_purges
7193: SET
7194: ap_checks = nvl(ap_checks, 0) - check_rows,
7195: ap_invoice_payments = nvl(ap_invoice_payments, 0) - invoice_payment_rows,
7196: ap_invoices = nvl(ap_invoices, 0) - invoice_rows,

Line 7968: Procedure : Update_Financials_Purges

7964: END Purge_acctg_and_ap_table;
7965:
7966: /*==========================================================================
7967: Bug 8913560
7968: Procedure : Update_Financials_Purges
7969: Purpose : Updates the financilas_purges table during the delete process of
7970: accounting and ap tables that is done using multiple child requests
7971: *==========================================================================*/
7972: Procedure Update_Financials_Purges ( p_check_rows IN NUMBER DEFAULT 0,

Line 7972: Procedure Update_Financials_Purges ( p_check_rows IN NUMBER DEFAULT 0,

7968: Procedure : Update_Financials_Purges
7969: Purpose : Updates the financilas_purges table during the delete process of
7970: accounting and ap tables that is done using multiple child requests
7971: *==========================================================================*/
7972: Procedure Update_Financials_Purges ( p_check_rows IN NUMBER DEFAULT 0,
7973: p_invoice_payment_rows IN NUMBER DEFAULT 0,
7974: p_invoice_rows IN NUMBER DEFAULT 0,
7975: p_ae_line_rows IN NUMBER DEFAULT 0,
7976: p_ae_header_rows IN NUMBER DEFAULT 0,

Line 7984: UPDATE financials_purges

7980: p_purge_name IN VARCHAR2 )
7981: IS
7982: PRAGMA AUTONOMOUS_TRANSACTION ;
7983: BEGIN
7984: UPDATE financials_purges
7985: SET ap_checks = NVL(ap_checks , 0 ) + p_check_rows,
7986: ap_invoice_payments = NVL(ap_invoice_payments , 0 ) + p_invoice_payment_rows,
7987: ap_invoices = NVL(ap_invoices , 0 ) + p_invoice_rows,
7988: ap_invoice_lines = NVL(ap_invoice_lines , 0 ) + p_invoice_lines_rows, --bug 11829621