DBA Data[Home] [Help]

APPS.ARP_CORRECT_CC_ERRORS dependencies on AR_NOTES

Line 1511: l_note_id ar_notes.note_id%type;

1507: |
1508: +===========================================================================*/
1509: PROCEDURE attach_notes(p_customer_trx_id IN NUMBER,
1510: p_text IN VARCHAR2) IS
1511: l_note_id ar_notes.note_id%type;
1512: BEGIN
1513: IF PG_DEBUG in ('Y', 'C') THEN
1514: arp_util.debug('ARP_CORRECT_CC_ERRORS.attach_notes()+');
1515: END IF;

Line 1517: INSERT INTO ar_notes

1513: IF PG_DEBUG in ('Y', 'C') THEN
1514: arp_util.debug('ARP_CORRECT_CC_ERRORS.attach_notes()+');
1515: END IF;
1516:
1517: INSERT INTO ar_notes
1518: (
1519: note_id,
1520: note_type,
1521: text,

Line 1534: ar_notes_s.nextval,

1530: creation_date
1531: )
1532: VALUES
1533: (
1534: ar_notes_s.nextval,
1535: 'MAINTAIN',
1536: p_text,
1537: p_customer_trx_id,
1538: NULL,