DBA Data[Home] [Help]

APPS.ARP_CORRECT_CC_ERRORS dependencies on AR_NOTES

Line 1506: l_note_id ar_notes.note_id%type;

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

Line 1512: INSERT INTO ar_notes

1508: IF PG_DEBUG in ('Y', 'C') THEN
1509: arp_util.debug('ARP_CORRECT_CC_ERRORS.attach_notes()+');
1510: END IF;
1511:
1512: INSERT INTO ar_notes
1513: (
1514: note_id,
1515: note_type,
1516: text,

Line 1529: ar_notes_s.nextval,

1525: creation_date
1526: )
1527: VALUES
1528: (
1529: ar_notes_s.nextval,
1530: 'MAINTAIN',
1531: p_text,
1532: p_customer_trx_id,
1533: NULL,