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.ARP_CORRECT_CC_ERRORS dependencies on AR_CC_ERROR_HISTORY

Line 26: PROCEDURE insert_p(p_cc_error_hist IN ar_cc_error_history%ROWTYPE);

22: x_first_record_flag OUT NOCOPY VARCHAR2,
23: x_cc_action_code OUT NOCOPY VARCHAR2,x_cc_action_type OUT NOCOPY VARCHAR2,
24: x_error_notes OUT NOCOPY VARCHAR2);
25:
26: PROCEDURE insert_p(p_cc_error_hist IN ar_cc_error_history%ROWTYPE);
27:
28: PROCEDURE clear_invoice_pay_info(p_customer_trx_id IN NUMBER,
29: p_cc_trx_category IN VARCHAR2,
30: p_source_receipt_id IN NUMBER DEFAULT NULL,

Line 347: FROM ar_cc_error_history

343: SELECT 1
344: INTO l_dummy_number
345: FROM dual
346: WHERE NOT EXISTS ( SELECT 1
347: FROM ar_cc_error_history
348: WHERE cc_trx_id = p_cc_trx_id
349: AND cc_trx_category = p_cc_trx_category
350: AND customer_bank_account_id = p_customer_bank_account_id
351: AND cc_error_code = p_cc_error_code

Line 371: FROM ar_cc_error_history

367: -- Check if this a first time error
368: BEGIN
369: SELECT cc_error_date
370: INTO l_first_cc_error_date
371: FROM ar_cc_error_history
372: WHERE cc_trx_id = p_cc_trx_id
373: AND cc_trx_category = p_cc_trx_category
374: AND customer_bank_account_id = p_customer_bank_account_id
375: AND cc_error_code = p_cc_error_code

Line 426: | Inserts the record into ar_cc_error_history

422: | PROCEDURE
423: | insert_p
424: |
425: | DESCRIPTION
426: | Inserts the record into ar_cc_error_history
427: |
428: |
429: | SCOPE - PRIVATE
430: |

Line 444: PROCEDURE insert_p(p_cc_error_hist IN ar_cc_error_history%ROWTYPE) IS

440: |
441: | MODIFICATION HISTORY - Created by Srinivasa Kini - 25-Aug-2004
442: |
443: +===========================================================================*/
444: PROCEDURE insert_p(p_cc_error_hist IN ar_cc_error_history%ROWTYPE) IS
445: BEGIN
446: IF PG_DEBUG in ('Y', 'C') THEN
447: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.insert_p()+' );
448: END IF;

Line 449: INSERT INTO ar_cc_error_history

445: BEGIN
446: IF PG_DEBUG in ('Y', 'C') THEN
447: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.insert_p()+' );
448: END IF;
449: INSERT INTO ar_cc_error_history
450: (
451: request_id,
452: cc_trx_category,
453: cc_trx_id,

Line 1728: l_cc_error_hist ar_cc_error_history%ROWTYPE;

1724: | MODIFICATION HISTORY - Created by Srinivasa Kini - 25-Aug-2004
1725: |
1726: +===========================================================================*/
1727: PROCEDURE correct_remittance_errors(p_request_id IN NUMBER) IS
1728: l_cc_error_hist ar_cc_error_history%ROWTYPE;
1729: l_cc_trx_category ar_cc_error_history.cc_trx_category%TYPE;
1730: l_error_notes VARCHAR2(240);
1731: l_cc_error_desc VARCHAR2(240);
1732: l_first_record_flag VARCHAR2(1);

Line 1729: l_cc_trx_category ar_cc_error_history.cc_trx_category%TYPE;

1725: |
1726: +===========================================================================*/
1727: PROCEDURE correct_remittance_errors(p_request_id IN NUMBER) IS
1728: l_cc_error_hist ar_cc_error_history%ROWTYPE;
1729: l_cc_trx_category ar_cc_error_history.cc_trx_category%TYPE;
1730: l_error_notes VARCHAR2(240);
1731: l_cc_error_desc VARCHAR2(240);
1732: l_first_record_flag VARCHAR2(1);
1733: l_cc_action_type VARCHAR2(1);

Line 1784: -- Insert records into ar_cc_error_history

1780: p_cc_trx_category => cr_rec.type,
1781: p_error_notes => l_error_notes);
1782: END If;
1783:
1784: -- Insert records into ar_cc_error_history
1785: IF l_cc_action_code in ('RET','REAUT REC','REV REC') THEN
1786: -- Update current_record_flag in ar_cc_error_history
1787: IF NVL(l_first_record_flag,'N') <> 'Y' THEN
1788: UPDATE ar_cc_error_history

Line 1786: -- Update current_record_flag in ar_cc_error_history

1782: END If;
1783:
1784: -- Insert records into ar_cc_error_history
1785: IF l_cc_action_code in ('RET','REAUT REC','REV REC') THEN
1786: -- Update current_record_flag in ar_cc_error_history
1787: IF NVL(l_first_record_flag,'N') <> 'Y' THEN
1788: UPDATE ar_cc_error_history
1789: SET current_record_flag = 'N',
1790: last_update_date = sysdate,

Line 1788: UPDATE ar_cc_error_history

1784: -- Insert records into ar_cc_error_history
1785: IF l_cc_action_code in ('RET','REAUT REC','REV REC') THEN
1786: -- Update current_record_flag in ar_cc_error_history
1787: IF NVL(l_first_record_flag,'N') <> 'Y' THEN
1788: UPDATE ar_cc_error_history
1789: SET current_record_flag = 'N',
1790: last_update_date = sysdate,
1791: last_updated_by = pg_user_id,
1792: last_update_login = NVL(pg_login_id,pg_conc_login_id)

Line 1848: l_cc_error_hist ar_cc_error_history%ROWTYPE;

1844: | MODIFICATION HISTORY - Created by Srinivasa Kini - 25-Aug-2004
1845: |
1846: +===========================================================================*/
1847: PROCEDURE correct_creation_errors(p_request_id IN NUMBER) IS
1848: l_cc_error_hist ar_cc_error_history%ROWTYPE;
1849: l_cc_trx_category ar_cc_error_history.cc_trx_category%TYPE;
1850: l_error_notes VARCHAR2(240);
1851: l_cc_error_desc VARCHAR2(240);
1852: l_first_record_flag VARCHAR2(1);

Line 1849: l_cc_trx_category ar_cc_error_history.cc_trx_category%TYPE;

1845: |
1846: +===========================================================================*/
1847: PROCEDURE correct_creation_errors(p_request_id IN NUMBER) IS
1848: l_cc_error_hist ar_cc_error_history%ROWTYPE;
1849: l_cc_trx_category ar_cc_error_history.cc_trx_category%TYPE;
1850: l_error_notes VARCHAR2(240);
1851: l_cc_error_desc VARCHAR2(240);
1852: l_first_record_flag VARCHAR2(1);
1853: l_cc_action_type VARCHAR2(1);

Line 1897: -- Insert records into ar_cc_error_history

1893: p_cc_trx_category => inv_rec.type,
1894: p_error_notes => l_error_notes);
1895: END IF;
1896:
1897: -- Insert records into ar_cc_error_history
1898: IF l_cc_action_code in ('RET','CLR PAY INFO') THEN
1899: -- Update current_record_flag in ar_cc_error_history
1900: IF NVL(l_first_record_flag,'N') <> 'Y' THEN
1901: UPDATE ar_cc_error_history

Line 1899: -- Update current_record_flag in ar_cc_error_history

1895: END IF;
1896:
1897: -- Insert records into ar_cc_error_history
1898: IF l_cc_action_code in ('RET','CLR PAY INFO') THEN
1899: -- Update current_record_flag in ar_cc_error_history
1900: IF NVL(l_first_record_flag,'N') <> 'Y' THEN
1901: UPDATE ar_cc_error_history
1902: SET current_record_flag = 'N',
1903: last_update_date = sysdate,

Line 1901: UPDATE ar_cc_error_history

1897: -- Insert records into ar_cc_error_history
1898: IF l_cc_action_code in ('RET','CLR PAY INFO') THEN
1899: -- Update current_record_flag in ar_cc_error_history
1900: IF NVL(l_first_record_flag,'N') <> 'Y' THEN
1901: UPDATE ar_cc_error_history
1902: SET current_record_flag = 'N',
1903: last_update_date = sysdate,
1904: last_updated_by = pg_user_id,
1905: last_update_login = NVL(pg_login_id,pg_conc_login_id)