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_NOTES_PKG dependencies on AR_NOTES

Line 102: PROCEDURE set_to_dummy( p_notes_rec OUT NOCOPY ar_notes%rowtype) IS

98: | 19-DEC-95 Shelley Eitzen Added Customer Call Id
99: | |
100: +===========================================================================*/
101:
102: PROCEDURE set_to_dummy( p_notes_rec OUT NOCOPY ar_notes%rowtype) IS
103:
104: BEGIN
105:
106: arp_util.debug('arp_notes_pkg.set_to_dummy()+');

Line 138: | This procedure locks the ar_notes rows identified by the |

134: | PROCEDURE |
135: | lock_f_ct_id |
136: | |
137: | DESCRIPTION |
138: | This procedure locks the ar_notes rows identified by the |
139: | p_customer_trx_id parameter. |
140: | |
141: | SCOPE - PUBLIC |
142: | |

Line 160: PROCEDURE lock_f_ct_id( p_customer_trx_id IN ar_notes.customer_trx_id%type )

156: | 16-DEC-95 Charlie Tomberg Created |
157: | |
158: +===========================================================================*/
159:
160: PROCEDURE lock_f_ct_id( p_customer_trx_id IN ar_notes.customer_trx_id%type )
161: IS
162:
163: l_customer_trx_id ar_notes.customer_trx_id%type;
164:

Line 163: l_customer_trx_id ar_notes.customer_trx_id%type;

159:
160: PROCEDURE lock_f_ct_id( p_customer_trx_id IN ar_notes.customer_trx_id%type )
161: IS
162:
163: l_customer_trx_id ar_notes.customer_trx_id%type;
164:
165: BEGIN
166: arp_util.debug('arp_notes_pkg.lock_p()+');
167:

Line 171: FROM ar_notes

167:
168:
169: SELECT customer_trx_id
170: INTO l_customer_trx_id
171: FROM ar_notes
172: WHERE customer_trx_id = p_customer_trx_id
173: FOR UPDATE OF customer_trx_id NOWAIT;
174:
175: arp_util.debug('arp_notes_pkg.lock_p()-');

Line 188: | This procedure locks the ar_notes row identified by the |

184: | PROCEDURE |
185: | lock_fetch_p |
186: | |
187: | DESCRIPTION |
188: | This procedure locks the ar_notes row identified by the |
189: | p_note_id parameter and populates the p_notes_rec parameter with |
190: | the row that was locked. |
191: | |
192: | SCOPE - PUBLIC |

Line 211: PROCEDURE lock_fetch_p( p_notes_rec IN OUT NOCOPY ar_notes%rowtype,

207: | 16-DEC-95 Charlie Tomberg Created |
208: | |
209: +===========================================================================*/
210:
211: PROCEDURE lock_fetch_p( p_notes_rec IN OUT NOCOPY ar_notes%rowtype,
212: p_note_id IN ar_notes.note_id%type) IS
213:
214: BEGIN
215: arp_util.debug('arp_notes_pkg.lock_fetch_p()+');

Line 212: p_note_id IN ar_notes.note_id%type) IS

208: | |
209: +===========================================================================*/
210:
211: PROCEDURE lock_fetch_p( p_notes_rec IN OUT NOCOPY ar_notes%rowtype,
212: p_note_id IN ar_notes.note_id%type) IS
213:
214: BEGIN
215: arp_util.debug('arp_notes_pkg.lock_fetch_p()+');
216:

Line 219: FROM ar_notes

215: arp_util.debug('arp_notes_pkg.lock_fetch_p()+');
216:
217: SELECT *
218: INTO p_notes_rec
219: FROM ar_notes
220: WHERE note_id = p_note_id
221: FOR UPDATE OF note_id NOWAIT;
222:
223: arp_util.debug('arp_notes_pkg.lock_fetch_p()-');

Line 236: | This procedure locks the ar_notes row identified by the |

232: | PROCEDURE |
233: | lock_compare_p |
234: | |
235: | DESCRIPTION |
236: | This procedure locks the ar_notes row identified by the |
237: | p_note_id parameter only if no columns in that row have |
238: | changed from when they were first selected in the form. |
239: | |
240: | SCOPE - PUBLIC |

Line 261: PROCEDURE lock_compare_p( p_notes_rec IN ar_notes%rowtype,

257: | 19-DEC-95 Shelley Eitzen Added Customer Call Id |
258: | |
259: +===========================================================================*/
260:
261: PROCEDURE lock_compare_p( p_notes_rec IN ar_notes%rowtype,
262: p_note_id IN ar_notes.note_id%type) IS
263:
264: l_new_note_rec ar_notes%rowtype;
265:

Line 262: p_note_id IN ar_notes.note_id%type) IS

258: | |
259: +===========================================================================*/
260:
261: PROCEDURE lock_compare_p( p_notes_rec IN ar_notes%rowtype,
262: p_note_id IN ar_notes.note_id%type) IS
263:
264: l_new_note_rec ar_notes%rowtype;
265:
266: BEGIN

Line 264: l_new_note_rec ar_notes%rowtype;

260:
261: PROCEDURE lock_compare_p( p_notes_rec IN ar_notes%rowtype,
262: p_note_id IN ar_notes.note_id%type) IS
263:
264: l_new_note_rec ar_notes%rowtype;
265:
266: BEGIN
267: arp_util.debug('arp_notes_pkg.lock_compare_p()+');
268:

Line 271: FROM ar_notes n

267: arp_util.debug('arp_notes_pkg.lock_compare_p()+');
268:
269: SELECT *
270: INTO l_new_note_rec
271: FROM ar_notes n
272: WHERE n.note_id = p_note_id
273: AND
274: (
275: NVL(n.note_id, AR_NUMBER_DUMMY) =

Line 397: | This procedure fetches a single row from ar_notes into a |

393: | PROCEDURE |
394: | fetch_p |
395: | |
396: | DESCRIPTION |
397: | This procedure fetches a single row from ar_notes into a |
398: | variable specified as a parameter based on the table's primary key, |
399: | p_note_id. |
400: | |
401: | SCOPE - PUBLIC |

Line 420: PROCEDURE fetch_p( p_notes_rec OUT NOCOPY ar_notes%rowtype,

416: | 16-DEC-95 Charlie Tomberg Created |
417: | |
418: +===========================================================================*/
419:
420: PROCEDURE fetch_p( p_notes_rec OUT NOCOPY ar_notes%rowtype,
421: p_note_id IN ar_notes.note_id%type) IS
422:
423: BEGIN
424: arp_util.debug('arp_notes_pkg.fetch_p()+');

Line 421: p_note_id IN ar_notes.note_id%type) IS

417: | |
418: +===========================================================================*/
419:
420: PROCEDURE fetch_p( p_notes_rec OUT NOCOPY ar_notes%rowtype,
421: p_note_id IN ar_notes.note_id%type) IS
422:
423: BEGIN
424: arp_util.debug('arp_notes_pkg.fetch_p()+');
425:

Line 428: FROM ar_notes

424: arp_util.debug('arp_notes_pkg.fetch_p()+');
425:
426: SELECT *
427: INTO p_notes_rec
428: FROM ar_notes
429: WHERE note_id = p_note_id;
430:
431: arp_util.debug('arp_notes_pkg.fetch_p()-');
432:

Line 444: | This procedure deletes the ar_notes row identified by the |

440: | PROCEDURE |
441: | delete_f_ct_id |
442: | |
443: | DESCRIPTION |
444: | This procedure deletes the ar_notes row identified by the |
445: | p_customer_trx_id parameter. |
446: | |
447: | SCOPE - PUBLIC |
448: | |

Line 466: procedure delete_f_ct_id( p_customer_trx_id IN ar_notes.customer_trx_id%type)

462: | 16-DEC-95 Charlie Tomberg Created |
463: | |
464: +===========================================================================*/
465:
466: procedure delete_f_ct_id( p_customer_trx_id IN ar_notes.customer_trx_id%type)
467: IS
468:
469:
470: BEGIN

Line 475: DELETE FROM ar_notes

471:
472:
473: arp_util.debug('arp_notes_pkg.delete_f_ct_id()+');
474:
475: DELETE FROM ar_notes
476: WHERE customer_trx_id = p_customer_trx_id;
477:
478: arp_util.debug('arp_notes_pkg.delete_f_ct_id()-');
479:

Line 493: | This procedure updates the ar_notes row identified by the |

489: | PROCEDURE |
490: | update_p |
491: | |
492: | DESCRIPTION |
493: | This procedure updates the ar_notes row identified by the |
494: | p_note_id parameter. |
495: | |
496: | SCOPE - PUBLIC |
497: | |

Line 520: PROCEDURE update_p( p_notes_rec IN OUT NOCOPY ar_notes%rowtype,

516: | 19-DEC-95 Shelley Eitzen Added Customer Call Id |
517: | |
518: +===========================================================================*/
519:
520: PROCEDURE update_p( p_notes_rec IN OUT NOCOPY ar_notes%rowtype,
521: p_note_id IN ar_notes.note_id%type) IS
522:
523:
524: BEGIN

Line 521: p_note_id IN ar_notes.note_id%type) IS

517: | |
518: +===========================================================================*/
519:
520: PROCEDURE update_p( p_notes_rec IN OUT NOCOPY ar_notes%rowtype,
521: p_note_id IN ar_notes.note_id%type) IS
522:
523:
524: BEGIN
525:

Line 545: UPDATE ar_notes

541: p_notes_rec.last_update_date,
542: p_notes_rec.last_update_login
543: FROM DUAL;
544:
545: UPDATE ar_notes
546: SET customer_trx_id =
547: DECODE(p_notes_rec.customer_trx_id,
548: AR_NUMBER_DUMMY, customer_trx_id,
549: p_notes_rec.customer_trx_id),

Line 602: | This procedure inserts a row into ar_notes that contains the |

598: | PROCEDURE |
599: | insert_p |
600: | |
601: | DESCRIPTION |
602: | This procedure inserts a row into ar_notes that contains the |
603: | column values specified in the p_notes_rec parameter. |
604: | |
605: | SCOPE - PUBLIC |
606: | |

Line 626: p_notes_rec IN OUT NOCOPY ar_notes%rowtype

622: | |
623: +===========================================================================*/
624:
625: PROCEDURE insert_p(
626: p_notes_rec IN OUT NOCOPY ar_notes%rowtype
627: ) IS
628:
629:
630: l_note_id ar_notes.note_id%type;

Line 630: l_note_id ar_notes.note_id%type;

626: p_notes_rec IN OUT NOCOPY ar_notes%rowtype
627: ) IS
628:
629:
630: l_note_id ar_notes.note_id%type;
631:
632: BEGIN
633:
634: arp_util.debug('arp_notes_pkg.insert_p()+');

Line 640: SELECT ar_notes_s.nextval

636: /*------------------------------+
637: | get the unique id |
638: +------------------------------*/
639:
640: SELECT ar_notes_s.nextval
641: INTO l_note_id
642: FROM dual;
643:
644: /*---------------------------------+

Line 675: INSERT INTO ar_notes

671:
672: /*------------------------------+
673: | insert the record |
674: +------------------------------*/
675: INSERT INTO ar_notes
676: (
677: note_id,
678: note_type,
679: text,

Line 741: PROCEDURE display_note_p( p_note_id IN ar_notes.note_id%type ) IS

737: | 16-DEC-95 Charlie Tomberg Created |
738: | |
739: +===========================================================================*/
740:
741: PROCEDURE display_note_p( p_note_id IN ar_notes.note_id%type ) IS
742:
743:
744: l_notes_rec ar_notes%rowtype;
745:

Line 744: l_notes_rec ar_notes%rowtype;

740:
741: PROCEDURE display_note_p( p_note_id IN ar_notes.note_id%type ) IS
742:
743:
744: l_notes_rec ar_notes%rowtype;
745:
746: BEGIN
747:
748: arp_util.debug('arp_notes_pkg.display_note_p()+');

Line 789: PROCEDURE display_note_rec ( p_notes_rec IN ar_notes%rowtype ) IS

785: | 16-DEC-95 Charlie Tomberg Created |
786: | |
787: +===========================================================================*/
788:
789: PROCEDURE display_note_rec ( p_notes_rec IN ar_notes%rowtype ) IS
790:
791: BEGIN
792:
793: arp_util.debug('arp_notes_pkg.display_note_rec()+');

Line 795: arp_util.debug(' Dump of ar_notes record ');

791: BEGIN
792:
793: arp_util.debug('arp_notes_pkg.display_note_rec()+');
794:
795: arp_util.debug('************ Dump of ar_notes record ************');
796: arp_util.debug('customer_trx_id: ' || p_notes_rec.customer_trx_id);
797:
798: arp_util.debug('note_id : ' || p_notes_rec.note_id);
799: arp_util.debug('creation_date : ' || p_notes_rec.creation_date);

Line 809: arp_util.debug('* End ar_notes record *');

805: p_notes_rec.customer_call_topic_id );
806: arp_util.debug('call_action_id : ' ||p_notes_rec.call_action_id );
807: arp_util.debug('customer_trx_id : ' ||p_notes_rec.customer_trx_id);
808:
809: arp_util.debug('************* End ar_notes record *************');
810:
811: arp_util.debug('arp_notes_pkg.display_note_rec()-');
812:
813: EXCEPTION

Line 826: | Converts column parameters to a ar_notes record and locks the notes |

822: | PROCEDURE |
823: | lock_compare_cover |
824: | |
825: | DESCRIPTION |
826: | Converts column parameters to a ar_notes record and locks the notes |
827: | record. |
828: | |
829: | SCOPE - PUBLIC |
830: | |

Line 865: p_note_id IN ar_notes.note_id%type,

861: | |
862: +===========================================================================*/
863:
864: PROCEDURE lock_compare_cover(
865: p_note_id IN ar_notes.note_id%type,
866: p_last_updated_by IN ar_notes.last_updated_by%type,
867: p_last_update_date IN ar_notes.last_update_date%type,
868: p_last_update_login IN ar_notes.last_update_login%type,
869: p_created_by IN ar_notes.created_by%type,

Line 866: p_last_updated_by IN ar_notes.last_updated_by%type,

862: +===========================================================================*/
863:
864: PROCEDURE lock_compare_cover(
865: p_note_id IN ar_notes.note_id%type,
866: p_last_updated_by IN ar_notes.last_updated_by%type,
867: p_last_update_date IN ar_notes.last_update_date%type,
868: p_last_update_login IN ar_notes.last_update_login%type,
869: p_created_by IN ar_notes.created_by%type,
870: p_creation_date IN ar_notes.creation_date%type,

Line 867: p_last_update_date IN ar_notes.last_update_date%type,

863:
864: PROCEDURE lock_compare_cover(
865: p_note_id IN ar_notes.note_id%type,
866: p_last_updated_by IN ar_notes.last_updated_by%type,
867: p_last_update_date IN ar_notes.last_update_date%type,
868: p_last_update_login IN ar_notes.last_update_login%type,
869: p_created_by IN ar_notes.created_by%type,
870: p_creation_date IN ar_notes.creation_date%type,
871: p_note_type IN ar_notes.note_type%type,

Line 868: p_last_update_login IN ar_notes.last_update_login%type,

864: PROCEDURE lock_compare_cover(
865: p_note_id IN ar_notes.note_id%type,
866: p_last_updated_by IN ar_notes.last_updated_by%type,
867: p_last_update_date IN ar_notes.last_update_date%type,
868: p_last_update_login IN ar_notes.last_update_login%type,
869: p_created_by IN ar_notes.created_by%type,
870: p_creation_date IN ar_notes.creation_date%type,
871: p_note_type IN ar_notes.note_type%type,
872: p_text IN ar_notes.text%type,

Line 869: p_created_by IN ar_notes.created_by%type,

865: p_note_id IN ar_notes.note_id%type,
866: p_last_updated_by IN ar_notes.last_updated_by%type,
867: p_last_update_date IN ar_notes.last_update_date%type,
868: p_last_update_login IN ar_notes.last_update_login%type,
869: p_created_by IN ar_notes.created_by%type,
870: p_creation_date IN ar_notes.creation_date%type,
871: p_note_type IN ar_notes.note_type%type,
872: p_text IN ar_notes.text%type,
873: p_customer_call_id IN ar_notes.customer_call_id%type,

Line 870: p_creation_date IN ar_notes.creation_date%type,

866: p_last_updated_by IN ar_notes.last_updated_by%type,
867: p_last_update_date IN ar_notes.last_update_date%type,
868: p_last_update_login IN ar_notes.last_update_login%type,
869: p_created_by IN ar_notes.created_by%type,
870: p_creation_date IN ar_notes.creation_date%type,
871: p_note_type IN ar_notes.note_type%type,
872: p_text IN ar_notes.text%type,
873: p_customer_call_id IN ar_notes.customer_call_id%type,
874: p_customer_call_topic_id IN ar_notes.customer_call_topic_id%type,

Line 871: p_note_type IN ar_notes.note_type%type,

867: p_last_update_date IN ar_notes.last_update_date%type,
868: p_last_update_login IN ar_notes.last_update_login%type,
869: p_created_by IN ar_notes.created_by%type,
870: p_creation_date IN ar_notes.creation_date%type,
871: p_note_type IN ar_notes.note_type%type,
872: p_text IN ar_notes.text%type,
873: p_customer_call_id IN ar_notes.customer_call_id%type,
874: p_customer_call_topic_id IN ar_notes.customer_call_topic_id%type,
875: p_call_action_id IN ar_notes.call_action_id%type,

Line 872: p_text IN ar_notes.text%type,

868: p_last_update_login IN ar_notes.last_update_login%type,
869: p_created_by IN ar_notes.created_by%type,
870: p_creation_date IN ar_notes.creation_date%type,
871: p_note_type IN ar_notes.note_type%type,
872: p_text IN ar_notes.text%type,
873: p_customer_call_id IN ar_notes.customer_call_id%type,
874: p_customer_call_topic_id IN ar_notes.customer_call_topic_id%type,
875: p_call_action_id IN ar_notes.call_action_id%type,
876: p_customer_trx_id IN ar_notes.customer_trx_id%type ) IS

Line 873: p_customer_call_id IN ar_notes.customer_call_id%type,

869: p_created_by IN ar_notes.created_by%type,
870: p_creation_date IN ar_notes.creation_date%type,
871: p_note_type IN ar_notes.note_type%type,
872: p_text IN ar_notes.text%type,
873: p_customer_call_id IN ar_notes.customer_call_id%type,
874: p_customer_call_topic_id IN ar_notes.customer_call_topic_id%type,
875: p_call_action_id IN ar_notes.call_action_id%type,
876: p_customer_trx_id IN ar_notes.customer_trx_id%type ) IS
877:

Line 874: p_customer_call_topic_id IN ar_notes.customer_call_topic_id%type,

870: p_creation_date IN ar_notes.creation_date%type,
871: p_note_type IN ar_notes.note_type%type,
872: p_text IN ar_notes.text%type,
873: p_customer_call_id IN ar_notes.customer_call_id%type,
874: p_customer_call_topic_id IN ar_notes.customer_call_topic_id%type,
875: p_call_action_id IN ar_notes.call_action_id%type,
876: p_customer_trx_id IN ar_notes.customer_trx_id%type ) IS
877:
878:

Line 875: p_call_action_id IN ar_notes.call_action_id%type,

871: p_note_type IN ar_notes.note_type%type,
872: p_text IN ar_notes.text%type,
873: p_customer_call_id IN ar_notes.customer_call_id%type,
874: p_customer_call_topic_id IN ar_notes.customer_call_topic_id%type,
875: p_call_action_id IN ar_notes.call_action_id%type,
876: p_customer_trx_id IN ar_notes.customer_trx_id%type ) IS
877:
878:
879: l_notes_rec ar_notes%rowtype;

Line 876: p_customer_trx_id IN ar_notes.customer_trx_id%type ) IS

872: p_text IN ar_notes.text%type,
873: p_customer_call_id IN ar_notes.customer_call_id%type,
874: p_customer_call_topic_id IN ar_notes.customer_call_topic_id%type,
875: p_call_action_id IN ar_notes.call_action_id%type,
876: p_customer_trx_id IN ar_notes.customer_trx_id%type ) IS
877:
878:
879: l_notes_rec ar_notes%rowtype;
880:

Line 879: l_notes_rec ar_notes%rowtype;

875: p_call_action_id IN ar_notes.call_action_id%type,
876: p_customer_trx_id IN ar_notes.customer_trx_id%type ) IS
877:
878:
879: l_notes_rec ar_notes%rowtype;
880:
881: BEGIN
882: arp_util.debug('arp_notes_pkg.lock_compare_cover()+');
883:

Line 943: | Converts column parameters to a ar_notes record and |

939: | PROCEDURE |
940: | insert_cover |
941: | |
942: | DESCRIPTION |
943: | Converts column parameters to a ar_notes record and |
944: | inserts the notes record. |
945: | |
946: | SCOPE - PUBLIC |
947: | |

Line 980: p_note_type IN ar_notes.note_type%type,

976: | |
977: +===========================================================================*/
978:
979: PROCEDURE insert_cover(
980: p_note_type IN ar_notes.note_type%type,
981: p_text IN ar_notes.text%type,
982: p_customer_call_id IN ar_notes.customer_call_id%type,
983: p_customer_call_topic_id IN ar_notes.customer_call_topic_id%type,
984: p_call_action_id IN ar_notes.call_action_id%type,

Line 981: p_text IN ar_notes.text%type,

977: +===========================================================================*/
978:
979: PROCEDURE insert_cover(
980: p_note_type IN ar_notes.note_type%type,
981: p_text IN ar_notes.text%type,
982: p_customer_call_id IN ar_notes.customer_call_id%type,
983: p_customer_call_topic_id IN ar_notes.customer_call_topic_id%type,
984: p_call_action_id IN ar_notes.call_action_id%type,
985: p_customer_trx_id IN ar_notes.customer_trx_id%type,

Line 982: p_customer_call_id IN ar_notes.customer_call_id%type,

978:
979: PROCEDURE insert_cover(
980: p_note_type IN ar_notes.note_type%type,
981: p_text IN ar_notes.text%type,
982: p_customer_call_id IN ar_notes.customer_call_id%type,
983: p_customer_call_topic_id IN ar_notes.customer_call_topic_id%type,
984: p_call_action_id IN ar_notes.call_action_id%type,
985: p_customer_trx_id IN ar_notes.customer_trx_id%type,
986: p_note_id OUT NOCOPY ar_notes.note_id%type,

Line 983: p_customer_call_topic_id IN ar_notes.customer_call_topic_id%type,

979: PROCEDURE insert_cover(
980: p_note_type IN ar_notes.note_type%type,
981: p_text IN ar_notes.text%type,
982: p_customer_call_id IN ar_notes.customer_call_id%type,
983: p_customer_call_topic_id IN ar_notes.customer_call_topic_id%type,
984: p_call_action_id IN ar_notes.call_action_id%type,
985: p_customer_trx_id IN ar_notes.customer_trx_id%type,
986: p_note_id OUT NOCOPY ar_notes.note_id%type,
987: p_last_updated_by IN OUT NOCOPY ar_notes.last_updated_by%type,

Line 984: p_call_action_id IN ar_notes.call_action_id%type,

980: p_note_type IN ar_notes.note_type%type,
981: p_text IN ar_notes.text%type,
982: p_customer_call_id IN ar_notes.customer_call_id%type,
983: p_customer_call_topic_id IN ar_notes.customer_call_topic_id%type,
984: p_call_action_id IN ar_notes.call_action_id%type,
985: p_customer_trx_id IN ar_notes.customer_trx_id%type,
986: p_note_id OUT NOCOPY ar_notes.note_id%type,
987: p_last_updated_by IN OUT NOCOPY ar_notes.last_updated_by%type,
988: p_last_update_date IN OUT NOCOPY ar_notes.last_update_date%type,

Line 985: p_customer_trx_id IN ar_notes.customer_trx_id%type,

981: p_text IN ar_notes.text%type,
982: p_customer_call_id IN ar_notes.customer_call_id%type,
983: p_customer_call_topic_id IN ar_notes.customer_call_topic_id%type,
984: p_call_action_id IN ar_notes.call_action_id%type,
985: p_customer_trx_id IN ar_notes.customer_trx_id%type,
986: p_note_id OUT NOCOPY ar_notes.note_id%type,
987: p_last_updated_by IN OUT NOCOPY ar_notes.last_updated_by%type,
988: p_last_update_date IN OUT NOCOPY ar_notes.last_update_date%type,
989: p_last_update_login IN OUT NOCOPY ar_notes.last_update_login%type,

Line 986: p_note_id OUT NOCOPY ar_notes.note_id%type,

982: p_customer_call_id IN ar_notes.customer_call_id%type,
983: p_customer_call_topic_id IN ar_notes.customer_call_topic_id%type,
984: p_call_action_id IN ar_notes.call_action_id%type,
985: p_customer_trx_id IN ar_notes.customer_trx_id%type,
986: p_note_id OUT NOCOPY ar_notes.note_id%type,
987: p_last_updated_by IN OUT NOCOPY ar_notes.last_updated_by%type,
988: p_last_update_date IN OUT NOCOPY ar_notes.last_update_date%type,
989: p_last_update_login IN OUT NOCOPY ar_notes.last_update_login%type,
990: p_created_by IN OUT NOCOPY ar_notes.created_by%type,

Line 987: p_last_updated_by IN OUT NOCOPY ar_notes.last_updated_by%type,

983: p_customer_call_topic_id IN ar_notes.customer_call_topic_id%type,
984: p_call_action_id IN ar_notes.call_action_id%type,
985: p_customer_trx_id IN ar_notes.customer_trx_id%type,
986: p_note_id OUT NOCOPY ar_notes.note_id%type,
987: p_last_updated_by IN OUT NOCOPY ar_notes.last_updated_by%type,
988: p_last_update_date IN OUT NOCOPY ar_notes.last_update_date%type,
989: p_last_update_login IN OUT NOCOPY ar_notes.last_update_login%type,
990: p_created_by IN OUT NOCOPY ar_notes.created_by%type,
991: p_creation_date IN OUT NOCOPY ar_notes.creation_date%type ) IS

Line 988: p_last_update_date IN OUT NOCOPY ar_notes.last_update_date%type,

984: p_call_action_id IN ar_notes.call_action_id%type,
985: p_customer_trx_id IN ar_notes.customer_trx_id%type,
986: p_note_id OUT NOCOPY ar_notes.note_id%type,
987: p_last_updated_by IN OUT NOCOPY ar_notes.last_updated_by%type,
988: p_last_update_date IN OUT NOCOPY ar_notes.last_update_date%type,
989: p_last_update_login IN OUT NOCOPY ar_notes.last_update_login%type,
990: p_created_by IN OUT NOCOPY ar_notes.created_by%type,
991: p_creation_date IN OUT NOCOPY ar_notes.creation_date%type ) IS
992:

Line 989: p_last_update_login IN OUT NOCOPY ar_notes.last_update_login%type,

985: p_customer_trx_id IN ar_notes.customer_trx_id%type,
986: p_note_id OUT NOCOPY ar_notes.note_id%type,
987: p_last_updated_by IN OUT NOCOPY ar_notes.last_updated_by%type,
988: p_last_update_date IN OUT NOCOPY ar_notes.last_update_date%type,
989: p_last_update_login IN OUT NOCOPY ar_notes.last_update_login%type,
990: p_created_by IN OUT NOCOPY ar_notes.created_by%type,
991: p_creation_date IN OUT NOCOPY ar_notes.creation_date%type ) IS
992:
993:

Line 990: p_created_by IN OUT NOCOPY ar_notes.created_by%type,

986: p_note_id OUT NOCOPY ar_notes.note_id%type,
987: p_last_updated_by IN OUT NOCOPY ar_notes.last_updated_by%type,
988: p_last_update_date IN OUT NOCOPY ar_notes.last_update_date%type,
989: p_last_update_login IN OUT NOCOPY ar_notes.last_update_login%type,
990: p_created_by IN OUT NOCOPY ar_notes.created_by%type,
991: p_creation_date IN OUT NOCOPY ar_notes.creation_date%type ) IS
992:
993:
994: l_notes_rec ar_notes%rowtype;

Line 991: p_creation_date IN OUT NOCOPY ar_notes.creation_date%type ) IS

987: p_last_updated_by IN OUT NOCOPY ar_notes.last_updated_by%type,
988: p_last_update_date IN OUT NOCOPY ar_notes.last_update_date%type,
989: p_last_update_login IN OUT NOCOPY ar_notes.last_update_login%type,
990: p_created_by IN OUT NOCOPY ar_notes.created_by%type,
991: p_creation_date IN OUT NOCOPY ar_notes.creation_date%type ) IS
992:
993:
994: l_notes_rec ar_notes%rowtype;
995:

Line 994: l_notes_rec ar_notes%rowtype;

990: p_created_by IN OUT NOCOPY ar_notes.created_by%type,
991: p_creation_date IN OUT NOCOPY ar_notes.creation_date%type ) IS
992:
993:
994: l_notes_rec ar_notes%rowtype;
995:
996: BEGIN
997: arp_util.debug('arp_notes_pkg.insert_cover()+');
998:

Line 1106: p_note_id IN ar_notes.note_id%type,

1102: +===========================================================================*/
1103:
1104:
1105: PROCEDURE update_cover(
1106: p_note_id IN ar_notes.note_id%type,
1107: p_created_by IN ar_notes.created_by%type,
1108: p_creation_date IN ar_notes.creation_date%type,
1109: p_note_type IN ar_notes.note_type%type,
1110: p_text IN ar_notes.text%type,

Line 1107: p_created_by IN ar_notes.created_by%type,

1103:
1104:
1105: PROCEDURE update_cover(
1106: p_note_id IN ar_notes.note_id%type,
1107: p_created_by IN ar_notes.created_by%type,
1108: p_creation_date IN ar_notes.creation_date%type,
1109: p_note_type IN ar_notes.note_type%type,
1110: p_text IN ar_notes.text%type,
1111: p_customer_call_id IN ar_notes.customer_call_id%type,

Line 1108: p_creation_date IN ar_notes.creation_date%type,

1104:
1105: PROCEDURE update_cover(
1106: p_note_id IN ar_notes.note_id%type,
1107: p_created_by IN ar_notes.created_by%type,
1108: p_creation_date IN ar_notes.creation_date%type,
1109: p_note_type IN ar_notes.note_type%type,
1110: p_text IN ar_notes.text%type,
1111: p_customer_call_id IN ar_notes.customer_call_id%type,
1112: p_customer_call_topic_id IN ar_notes.customer_call_topic_id%type,

Line 1109: p_note_type IN ar_notes.note_type%type,

1105: PROCEDURE update_cover(
1106: p_note_id IN ar_notes.note_id%type,
1107: p_created_by IN ar_notes.created_by%type,
1108: p_creation_date IN ar_notes.creation_date%type,
1109: p_note_type IN ar_notes.note_type%type,
1110: p_text IN ar_notes.text%type,
1111: p_customer_call_id IN ar_notes.customer_call_id%type,
1112: p_customer_call_topic_id IN ar_notes.customer_call_topic_id%type,
1113: p_call_action_id IN ar_notes.call_action_id%type,

Line 1110: p_text IN ar_notes.text%type,

1106: p_note_id IN ar_notes.note_id%type,
1107: p_created_by IN ar_notes.created_by%type,
1108: p_creation_date IN ar_notes.creation_date%type,
1109: p_note_type IN ar_notes.note_type%type,
1110: p_text IN ar_notes.text%type,
1111: p_customer_call_id IN ar_notes.customer_call_id%type,
1112: p_customer_call_topic_id IN ar_notes.customer_call_topic_id%type,
1113: p_call_action_id IN ar_notes.call_action_id%type,
1114: p_customer_trx_id IN ar_notes.customer_trx_id%type,

Line 1111: p_customer_call_id IN ar_notes.customer_call_id%type,

1107: p_created_by IN ar_notes.created_by%type,
1108: p_creation_date IN ar_notes.creation_date%type,
1109: p_note_type IN ar_notes.note_type%type,
1110: p_text IN ar_notes.text%type,
1111: p_customer_call_id IN ar_notes.customer_call_id%type,
1112: p_customer_call_topic_id IN ar_notes.customer_call_topic_id%type,
1113: p_call_action_id IN ar_notes.call_action_id%type,
1114: p_customer_trx_id IN ar_notes.customer_trx_id%type,
1115: p_last_updated_by IN OUT NOCOPY ar_notes.last_updated_by%type,

Line 1112: p_customer_call_topic_id IN ar_notes.customer_call_topic_id%type,

1108: p_creation_date IN ar_notes.creation_date%type,
1109: p_note_type IN ar_notes.note_type%type,
1110: p_text IN ar_notes.text%type,
1111: p_customer_call_id IN ar_notes.customer_call_id%type,
1112: p_customer_call_topic_id IN ar_notes.customer_call_topic_id%type,
1113: p_call_action_id IN ar_notes.call_action_id%type,
1114: p_customer_trx_id IN ar_notes.customer_trx_id%type,
1115: p_last_updated_by IN OUT NOCOPY ar_notes.last_updated_by%type,
1116: p_last_update_date IN OUT NOCOPY ar_notes.last_update_date%type,

Line 1113: p_call_action_id IN ar_notes.call_action_id%type,

1109: p_note_type IN ar_notes.note_type%type,
1110: p_text IN ar_notes.text%type,
1111: p_customer_call_id IN ar_notes.customer_call_id%type,
1112: p_customer_call_topic_id IN ar_notes.customer_call_topic_id%type,
1113: p_call_action_id IN ar_notes.call_action_id%type,
1114: p_customer_trx_id IN ar_notes.customer_trx_id%type,
1115: p_last_updated_by IN OUT NOCOPY ar_notes.last_updated_by%type,
1116: p_last_update_date IN OUT NOCOPY ar_notes.last_update_date%type,
1117: p_last_update_login IN OUT NOCOPY ar_notes.last_update_login%type ) IS

Line 1114: p_customer_trx_id IN ar_notes.customer_trx_id%type,

1110: p_text IN ar_notes.text%type,
1111: p_customer_call_id IN ar_notes.customer_call_id%type,
1112: p_customer_call_topic_id IN ar_notes.customer_call_topic_id%type,
1113: p_call_action_id IN ar_notes.call_action_id%type,
1114: p_customer_trx_id IN ar_notes.customer_trx_id%type,
1115: p_last_updated_by IN OUT NOCOPY ar_notes.last_updated_by%type,
1116: p_last_update_date IN OUT NOCOPY ar_notes.last_update_date%type,
1117: p_last_update_login IN OUT NOCOPY ar_notes.last_update_login%type ) IS
1118:

Line 1115: p_last_updated_by IN OUT NOCOPY ar_notes.last_updated_by%type,

1111: p_customer_call_id IN ar_notes.customer_call_id%type,
1112: p_customer_call_topic_id IN ar_notes.customer_call_topic_id%type,
1113: p_call_action_id IN ar_notes.call_action_id%type,
1114: p_customer_trx_id IN ar_notes.customer_trx_id%type,
1115: p_last_updated_by IN OUT NOCOPY ar_notes.last_updated_by%type,
1116: p_last_update_date IN OUT NOCOPY ar_notes.last_update_date%type,
1117: p_last_update_login IN OUT NOCOPY ar_notes.last_update_login%type ) IS
1118:
1119:

Line 1116: p_last_update_date IN OUT NOCOPY ar_notes.last_update_date%type,

1112: p_customer_call_topic_id IN ar_notes.customer_call_topic_id%type,
1113: p_call_action_id IN ar_notes.call_action_id%type,
1114: p_customer_trx_id IN ar_notes.customer_trx_id%type,
1115: p_last_updated_by IN OUT NOCOPY ar_notes.last_updated_by%type,
1116: p_last_update_date IN OUT NOCOPY ar_notes.last_update_date%type,
1117: p_last_update_login IN OUT NOCOPY ar_notes.last_update_login%type ) IS
1118:
1119:
1120: l_notes_rec ar_notes%rowtype;

Line 1117: p_last_update_login IN OUT NOCOPY ar_notes.last_update_login%type ) IS

1113: p_call_action_id IN ar_notes.call_action_id%type,
1114: p_customer_trx_id IN ar_notes.customer_trx_id%type,
1115: p_last_updated_by IN OUT NOCOPY ar_notes.last_updated_by%type,
1116: p_last_update_date IN OUT NOCOPY ar_notes.last_update_date%type,
1117: p_last_update_login IN OUT NOCOPY ar_notes.last_update_login%type ) IS
1118:
1119:
1120: l_notes_rec ar_notes%rowtype;
1121:

Line 1120: l_notes_rec ar_notes%rowtype;

1116: p_last_update_date IN OUT NOCOPY ar_notes.last_update_date%type,
1117: p_last_update_login IN OUT NOCOPY ar_notes.last_update_login%type ) IS
1118:
1119:
1120: l_notes_rec ar_notes%rowtype;
1121:
1122: BEGIN
1123: arp_util.debug('arp_notes_pkg.update_cover()+');
1124: