APPS.ARP_CC_PKG dependencies on AR_NOTES

Line 129: | Insert values into ar_notes

125:
126:
127:
128: /*------------------------------------------------------------------
129: | Insert values into ar_notes
130: +------------------------------------------------------------------*/
131:
132: PROCEDURE insert_f_notes (
133: p_note_rec IN ar_notes%rowtype,

Line 133: p_note_rec IN ar_notes%rowtype,

129: | Insert values into ar_notes
130: +------------------------------------------------------------------*/
131:
132: PROCEDURE insert_f_notes (
133: p_note_rec IN ar_notes%rowtype,
134: p_note_id OUT NOCOPY ar_notes.note_id%type) IS
135:
136: l_created_by number;
137: l_creation_date date;

Line 134: p_note_id OUT NOCOPY ar_notes.note_id%type) IS

130: +------------------------------------------------------------------*/
131:
132: PROCEDURE insert_f_notes (
133: p_note_rec IN ar_notes%rowtype,
134: p_note_id OUT NOCOPY ar_notes.note_id%type) IS
135:
136: l_created_by number;
137: l_creation_date date;
138: l_last_updated_by number;

Line 154: select ar_notes_s.nextval

150:
151: /*------------------------------+
152: | get the unique id |
153: +------------------------------*/
154: select ar_notes_s.nextval
155: into p_note_id
156: from dual;
157:
158: /*------------------------------+

Line 161: insert into ar_notes (

157:
158: /*------------------------------+
159: | insert the record |
160: +------------------------------*/
161: insert into ar_notes (
162: note_id,
163: note_type,
164: text,
165: customer_call_id,