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 6: PROCEDURE set_to_dummy( p_notes_rec OUT NOCOPY ar_notes%rowtype);

2: /* $Header: ARTINOTS.pls 120.4 2005/10/30 04:27:25 appldev ship $ */
3:
4: FUNCTION get_number_dummy(p_null IN NUMBER DEFAULT null) RETURN number;
5:
6: PROCEDURE set_to_dummy( p_notes_rec OUT NOCOPY ar_notes%rowtype);
7:
8: PROCEDURE lock_f_ct_id( p_customer_trx_id IN ar_notes.customer_trx_id%type );
9:
10: PROCEDURE lock_fetch_p( p_notes_rec IN OUT NOCOPY ar_notes%rowtype,

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

4: FUNCTION get_number_dummy(p_null IN NUMBER DEFAULT null) RETURN number;
5:
6: PROCEDURE set_to_dummy( p_notes_rec OUT NOCOPY ar_notes%rowtype);
7:
8: PROCEDURE lock_f_ct_id( p_customer_trx_id IN ar_notes.customer_trx_id%type );
9:
10: PROCEDURE lock_fetch_p( p_notes_rec IN OUT NOCOPY ar_notes%rowtype,
11: p_note_id IN ar_notes.note_id%type);
12:

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

6: PROCEDURE set_to_dummy( p_notes_rec OUT NOCOPY ar_notes%rowtype);
7:
8: PROCEDURE lock_f_ct_id( p_customer_trx_id IN ar_notes.customer_trx_id%type );
9:
10: PROCEDURE lock_fetch_p( p_notes_rec IN OUT NOCOPY ar_notes%rowtype,
11: p_note_id IN ar_notes.note_id%type);
12:
13: PROCEDURE lock_compare_p( p_notes_rec IN ar_notes%rowtype,
14: p_note_id IN ar_notes.note_id%type);

Line 11: p_note_id IN ar_notes.note_id%type);

7:
8: PROCEDURE lock_f_ct_id( p_customer_trx_id IN ar_notes.customer_trx_id%type );
9:
10: PROCEDURE lock_fetch_p( p_notes_rec IN OUT NOCOPY ar_notes%rowtype,
11: p_note_id IN ar_notes.note_id%type);
12:
13: PROCEDURE lock_compare_p( p_notes_rec IN ar_notes%rowtype,
14: p_note_id IN ar_notes.note_id%type);
15:

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

9:
10: PROCEDURE lock_fetch_p( p_notes_rec IN OUT NOCOPY ar_notes%rowtype,
11: p_note_id IN ar_notes.note_id%type);
12:
13: PROCEDURE lock_compare_p( p_notes_rec IN ar_notes%rowtype,
14: p_note_id IN ar_notes.note_id%type);
15:
16: PROCEDURE fetch_p( p_notes_rec OUT NOCOPY ar_notes%rowtype,
17: p_note_id IN ar_notes.note_id%type);

Line 14: p_note_id IN ar_notes.note_id%type);

10: PROCEDURE lock_fetch_p( p_notes_rec IN OUT NOCOPY ar_notes%rowtype,
11: p_note_id IN ar_notes.note_id%type);
12:
13: PROCEDURE lock_compare_p( p_notes_rec IN ar_notes%rowtype,
14: p_note_id IN ar_notes.note_id%type);
15:
16: PROCEDURE fetch_p( p_notes_rec OUT NOCOPY ar_notes%rowtype,
17: p_note_id IN ar_notes.note_id%type);
18:

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

12:
13: PROCEDURE lock_compare_p( p_notes_rec IN ar_notes%rowtype,
14: p_note_id IN ar_notes.note_id%type);
15:
16: PROCEDURE fetch_p( p_notes_rec OUT NOCOPY ar_notes%rowtype,
17: p_note_id IN ar_notes.note_id%type);
18:
19: procedure delete_f_ct_id( p_customer_trx_id IN ar_notes.customer_trx_id%type);
20:

Line 17: p_note_id IN ar_notes.note_id%type);

13: PROCEDURE lock_compare_p( p_notes_rec IN ar_notes%rowtype,
14: p_note_id IN ar_notes.note_id%type);
15:
16: PROCEDURE fetch_p( p_notes_rec OUT NOCOPY ar_notes%rowtype,
17: p_note_id IN ar_notes.note_id%type);
18:
19: procedure delete_f_ct_id( p_customer_trx_id IN ar_notes.customer_trx_id%type);
20:
21: PROCEDURE update_p( p_notes_rec IN OUT NOCOPY ar_notes%rowtype,

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

15:
16: PROCEDURE fetch_p( p_notes_rec OUT NOCOPY ar_notes%rowtype,
17: p_note_id IN ar_notes.note_id%type);
18:
19: procedure delete_f_ct_id( p_customer_trx_id IN ar_notes.customer_trx_id%type);
20:
21: PROCEDURE update_p( p_notes_rec IN OUT NOCOPY ar_notes%rowtype,
22: p_note_id IN ar_notes.note_id%type);
23:

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

17: p_note_id IN ar_notes.note_id%type);
18:
19: procedure delete_f_ct_id( p_customer_trx_id IN ar_notes.customer_trx_id%type);
20:
21: PROCEDURE update_p( p_notes_rec IN OUT NOCOPY ar_notes%rowtype,
22: p_note_id IN ar_notes.note_id%type);
23:
24: PROCEDURE insert_p(
25: p_notes_rec IN OUT NOCOPY ar_notes%rowtype

Line 22: p_note_id IN ar_notes.note_id%type);

18:
19: procedure delete_f_ct_id( p_customer_trx_id IN ar_notes.customer_trx_id%type);
20:
21: PROCEDURE update_p( p_notes_rec IN OUT NOCOPY ar_notes%rowtype,
22: p_note_id IN ar_notes.note_id%type);
23:
24: PROCEDURE insert_p(
25: p_notes_rec IN OUT NOCOPY ar_notes%rowtype
26: );

Line 25: p_notes_rec IN OUT NOCOPY ar_notes%rowtype

21: PROCEDURE update_p( p_notes_rec IN OUT NOCOPY ar_notes%rowtype,
22: p_note_id IN ar_notes.note_id%type);
23:
24: PROCEDURE insert_p(
25: p_notes_rec IN OUT NOCOPY ar_notes%rowtype
26: );
27:
28: PROCEDURE display_note_p( p_note_id IN ar_notes.note_id%type );
29:

Line 28: PROCEDURE display_note_p( p_note_id IN ar_notes.note_id%type );

24: PROCEDURE insert_p(
25: p_notes_rec IN OUT NOCOPY ar_notes%rowtype
26: );
27:
28: PROCEDURE display_note_p( p_note_id IN ar_notes.note_id%type );
29:
30: PROCEDURE display_note_rec ( p_notes_rec IN ar_notes%rowtype );
31:
32: PROCEDURE lock_compare_cover(

Line 30: PROCEDURE display_note_rec ( p_notes_rec IN ar_notes%rowtype );

26: );
27:
28: PROCEDURE display_note_p( p_note_id IN ar_notes.note_id%type );
29:
30: PROCEDURE display_note_rec ( p_notes_rec IN ar_notes%rowtype );
31:
32: PROCEDURE lock_compare_cover(
33: p_note_id IN ar_notes.note_id%type,
34: p_last_updated_by IN ar_notes.last_updated_by%type,

Line 33: p_note_id IN ar_notes.note_id%type,

29:
30: PROCEDURE display_note_rec ( p_notes_rec IN ar_notes%rowtype );
31:
32: PROCEDURE lock_compare_cover(
33: p_note_id IN ar_notes.note_id%type,
34: p_last_updated_by IN ar_notes.last_updated_by%type,
35: p_last_update_date IN ar_notes.last_update_date%type,
36: p_last_update_login IN ar_notes.last_update_login%type,
37: p_created_by IN ar_notes.created_by%type,

Line 34: p_last_updated_by IN ar_notes.last_updated_by%type,

30: PROCEDURE display_note_rec ( p_notes_rec IN ar_notes%rowtype );
31:
32: PROCEDURE lock_compare_cover(
33: p_note_id IN ar_notes.note_id%type,
34: p_last_updated_by IN ar_notes.last_updated_by%type,
35: p_last_update_date IN ar_notes.last_update_date%type,
36: p_last_update_login IN ar_notes.last_update_login%type,
37: p_created_by IN ar_notes.created_by%type,
38: p_creation_date IN ar_notes.creation_date%type,

Line 35: p_last_update_date IN ar_notes.last_update_date%type,

31:
32: PROCEDURE lock_compare_cover(
33: p_note_id IN ar_notes.note_id%type,
34: p_last_updated_by IN ar_notes.last_updated_by%type,
35: p_last_update_date IN ar_notes.last_update_date%type,
36: p_last_update_login IN ar_notes.last_update_login%type,
37: p_created_by IN ar_notes.created_by%type,
38: p_creation_date IN ar_notes.creation_date%type,
39: p_note_type IN ar_notes.note_type%type,

Line 36: p_last_update_login IN ar_notes.last_update_login%type,

32: PROCEDURE lock_compare_cover(
33: p_note_id IN ar_notes.note_id%type,
34: p_last_updated_by IN ar_notes.last_updated_by%type,
35: p_last_update_date IN ar_notes.last_update_date%type,
36: p_last_update_login IN ar_notes.last_update_login%type,
37: p_created_by IN ar_notes.created_by%type,
38: p_creation_date IN ar_notes.creation_date%type,
39: p_note_type IN ar_notes.note_type%type,
40: p_text IN ar_notes.text%type,

Line 37: p_created_by IN ar_notes.created_by%type,

33: p_note_id IN ar_notes.note_id%type,
34: p_last_updated_by IN ar_notes.last_updated_by%type,
35: p_last_update_date IN ar_notes.last_update_date%type,
36: p_last_update_login IN ar_notes.last_update_login%type,
37: p_created_by IN ar_notes.created_by%type,
38: p_creation_date IN ar_notes.creation_date%type,
39: p_note_type IN ar_notes.note_type%type,
40: p_text IN ar_notes.text%type,
41: p_customer_call_id IN ar_notes.customer_call_id%type,

Line 38: p_creation_date IN ar_notes.creation_date%type,

34: p_last_updated_by IN ar_notes.last_updated_by%type,
35: p_last_update_date IN ar_notes.last_update_date%type,
36: p_last_update_login IN ar_notes.last_update_login%type,
37: p_created_by IN ar_notes.created_by%type,
38: p_creation_date IN ar_notes.creation_date%type,
39: p_note_type IN ar_notes.note_type%type,
40: p_text IN ar_notes.text%type,
41: p_customer_call_id IN ar_notes.customer_call_id%type,
42: p_customer_call_topic_id IN ar_notes.customer_call_topic_id%type,

Line 39: p_note_type IN ar_notes.note_type%type,

35: p_last_update_date IN ar_notes.last_update_date%type,
36: p_last_update_login IN ar_notes.last_update_login%type,
37: p_created_by IN ar_notes.created_by%type,
38: p_creation_date IN ar_notes.creation_date%type,
39: p_note_type IN ar_notes.note_type%type,
40: p_text IN ar_notes.text%type,
41: p_customer_call_id IN ar_notes.customer_call_id%type,
42: p_customer_call_topic_id IN ar_notes.customer_call_topic_id%type,
43: p_call_action_id IN ar_notes.call_action_id%type,

Line 40: p_text IN ar_notes.text%type,

36: p_last_update_login IN ar_notes.last_update_login%type,
37: p_created_by IN ar_notes.created_by%type,
38: p_creation_date IN ar_notes.creation_date%type,
39: p_note_type IN ar_notes.note_type%type,
40: p_text IN ar_notes.text%type,
41: p_customer_call_id IN ar_notes.customer_call_id%type,
42: p_customer_call_topic_id IN ar_notes.customer_call_topic_id%type,
43: p_call_action_id IN ar_notes.call_action_id%type,
44: p_customer_trx_id IN ar_notes.customer_trx_id%type );

Line 41: p_customer_call_id IN ar_notes.customer_call_id%type,

37: p_created_by IN ar_notes.created_by%type,
38: p_creation_date IN ar_notes.creation_date%type,
39: p_note_type IN ar_notes.note_type%type,
40: p_text IN ar_notes.text%type,
41: p_customer_call_id IN ar_notes.customer_call_id%type,
42: p_customer_call_topic_id IN ar_notes.customer_call_topic_id%type,
43: p_call_action_id IN ar_notes.call_action_id%type,
44: p_customer_trx_id IN ar_notes.customer_trx_id%type );
45:

Line 42: p_customer_call_topic_id IN ar_notes.customer_call_topic_id%type,

38: p_creation_date IN ar_notes.creation_date%type,
39: p_note_type IN ar_notes.note_type%type,
40: p_text IN ar_notes.text%type,
41: p_customer_call_id IN ar_notes.customer_call_id%type,
42: p_customer_call_topic_id IN ar_notes.customer_call_topic_id%type,
43: p_call_action_id IN ar_notes.call_action_id%type,
44: p_customer_trx_id IN ar_notes.customer_trx_id%type );
45:
46: PROCEDURE insert_cover(

Line 43: p_call_action_id IN ar_notes.call_action_id%type,

39: p_note_type IN ar_notes.note_type%type,
40: p_text IN ar_notes.text%type,
41: p_customer_call_id IN ar_notes.customer_call_id%type,
42: p_customer_call_topic_id IN ar_notes.customer_call_topic_id%type,
43: p_call_action_id IN ar_notes.call_action_id%type,
44: p_customer_trx_id IN ar_notes.customer_trx_id%type );
45:
46: PROCEDURE insert_cover(
47: p_note_type IN ar_notes.note_type%type,

Line 44: p_customer_trx_id IN ar_notes.customer_trx_id%type );

40: p_text IN ar_notes.text%type,
41: p_customer_call_id IN ar_notes.customer_call_id%type,
42: p_customer_call_topic_id IN ar_notes.customer_call_topic_id%type,
43: p_call_action_id IN ar_notes.call_action_id%type,
44: p_customer_trx_id IN ar_notes.customer_trx_id%type );
45:
46: PROCEDURE insert_cover(
47: p_note_type IN ar_notes.note_type%type,
48: p_text IN ar_notes.text%type,

Line 47: p_note_type IN ar_notes.note_type%type,

43: p_call_action_id IN ar_notes.call_action_id%type,
44: p_customer_trx_id IN ar_notes.customer_trx_id%type );
45:
46: PROCEDURE insert_cover(
47: p_note_type IN ar_notes.note_type%type,
48: p_text IN ar_notes.text%type,
49: p_customer_call_id IN ar_notes.customer_call_id%type,
50: p_customer_call_topic_id IN ar_notes.customer_call_topic_id%type,
51: p_call_action_id IN ar_notes.call_action_id%type,

Line 48: p_text IN ar_notes.text%type,

44: p_customer_trx_id IN ar_notes.customer_trx_id%type );
45:
46: PROCEDURE insert_cover(
47: p_note_type IN ar_notes.note_type%type,
48: p_text IN ar_notes.text%type,
49: p_customer_call_id IN ar_notes.customer_call_id%type,
50: p_customer_call_topic_id IN ar_notes.customer_call_topic_id%type,
51: p_call_action_id IN ar_notes.call_action_id%type,
52: p_customer_trx_id IN ar_notes.customer_trx_id%type,

Line 49: p_customer_call_id IN ar_notes.customer_call_id%type,

45:
46: PROCEDURE insert_cover(
47: p_note_type IN ar_notes.note_type%type,
48: p_text IN ar_notes.text%type,
49: p_customer_call_id IN ar_notes.customer_call_id%type,
50: p_customer_call_topic_id IN ar_notes.customer_call_topic_id%type,
51: p_call_action_id IN ar_notes.call_action_id%type,
52: p_customer_trx_id IN ar_notes.customer_trx_id%type,
53: p_note_id OUT NOCOPY ar_notes.note_id%type,

Line 50: p_customer_call_topic_id IN ar_notes.customer_call_topic_id%type,

46: PROCEDURE insert_cover(
47: p_note_type IN ar_notes.note_type%type,
48: p_text IN ar_notes.text%type,
49: p_customer_call_id IN ar_notes.customer_call_id%type,
50: p_customer_call_topic_id IN ar_notes.customer_call_topic_id%type,
51: p_call_action_id IN ar_notes.call_action_id%type,
52: p_customer_trx_id IN ar_notes.customer_trx_id%type,
53: p_note_id OUT NOCOPY ar_notes.note_id%type,
54: p_last_updated_by IN OUT NOCOPY ar_notes.last_updated_by%type,

Line 51: p_call_action_id IN ar_notes.call_action_id%type,

47: p_note_type IN ar_notes.note_type%type,
48: p_text IN ar_notes.text%type,
49: p_customer_call_id IN ar_notes.customer_call_id%type,
50: p_customer_call_topic_id IN ar_notes.customer_call_topic_id%type,
51: p_call_action_id IN ar_notes.call_action_id%type,
52: p_customer_trx_id IN ar_notes.customer_trx_id%type,
53: p_note_id OUT NOCOPY ar_notes.note_id%type,
54: p_last_updated_by IN OUT NOCOPY ar_notes.last_updated_by%type,
55: p_last_update_date IN OUT NOCOPY ar_notes.last_update_date%type,

Line 52: p_customer_trx_id IN ar_notes.customer_trx_id%type,

48: p_text IN ar_notes.text%type,
49: p_customer_call_id IN ar_notes.customer_call_id%type,
50: p_customer_call_topic_id IN ar_notes.customer_call_topic_id%type,
51: p_call_action_id IN ar_notes.call_action_id%type,
52: p_customer_trx_id IN ar_notes.customer_trx_id%type,
53: p_note_id OUT NOCOPY ar_notes.note_id%type,
54: p_last_updated_by IN OUT NOCOPY ar_notes.last_updated_by%type,
55: p_last_update_date IN OUT NOCOPY ar_notes.last_update_date%type,
56: p_last_update_login IN OUT NOCOPY ar_notes.last_update_login%type,

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

49: p_customer_call_id IN ar_notes.customer_call_id%type,
50: p_customer_call_topic_id IN ar_notes.customer_call_topic_id%type,
51: p_call_action_id IN ar_notes.call_action_id%type,
52: p_customer_trx_id IN ar_notes.customer_trx_id%type,
53: p_note_id OUT NOCOPY ar_notes.note_id%type,
54: p_last_updated_by IN OUT NOCOPY ar_notes.last_updated_by%type,
55: p_last_update_date IN OUT NOCOPY ar_notes.last_update_date%type,
56: p_last_update_login IN OUT NOCOPY ar_notes.last_update_login%type,
57: p_created_by IN OUT NOCOPY ar_notes.created_by%type,

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

50: p_customer_call_topic_id IN ar_notes.customer_call_topic_id%type,
51: p_call_action_id IN ar_notes.call_action_id%type,
52: p_customer_trx_id IN ar_notes.customer_trx_id%type,
53: p_note_id OUT NOCOPY ar_notes.note_id%type,
54: p_last_updated_by IN OUT NOCOPY ar_notes.last_updated_by%type,
55: p_last_update_date IN OUT NOCOPY ar_notes.last_update_date%type,
56: p_last_update_login IN OUT NOCOPY ar_notes.last_update_login%type,
57: p_created_by IN OUT NOCOPY ar_notes.created_by%type,
58: p_creation_date IN OUT NOCOPY ar_notes.creation_date%type );

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

51: p_call_action_id IN ar_notes.call_action_id%type,
52: p_customer_trx_id IN ar_notes.customer_trx_id%type,
53: p_note_id OUT NOCOPY ar_notes.note_id%type,
54: p_last_updated_by IN OUT NOCOPY ar_notes.last_updated_by%type,
55: p_last_update_date IN OUT NOCOPY ar_notes.last_update_date%type,
56: p_last_update_login IN OUT NOCOPY ar_notes.last_update_login%type,
57: p_created_by IN OUT NOCOPY ar_notes.created_by%type,
58: p_creation_date IN OUT NOCOPY ar_notes.creation_date%type );
59:

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

52: p_customer_trx_id IN ar_notes.customer_trx_id%type,
53: p_note_id OUT NOCOPY ar_notes.note_id%type,
54: p_last_updated_by IN OUT NOCOPY ar_notes.last_updated_by%type,
55: p_last_update_date IN OUT NOCOPY ar_notes.last_update_date%type,
56: p_last_update_login IN OUT NOCOPY ar_notes.last_update_login%type,
57: p_created_by IN OUT NOCOPY ar_notes.created_by%type,
58: p_creation_date IN OUT NOCOPY ar_notes.creation_date%type );
59:
60: PROCEDURE update_cover(

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

53: p_note_id OUT NOCOPY ar_notes.note_id%type,
54: p_last_updated_by IN OUT NOCOPY ar_notes.last_updated_by%type,
55: p_last_update_date IN OUT NOCOPY ar_notes.last_update_date%type,
56: p_last_update_login IN OUT NOCOPY ar_notes.last_update_login%type,
57: p_created_by IN OUT NOCOPY ar_notes.created_by%type,
58: p_creation_date IN OUT NOCOPY ar_notes.creation_date%type );
59:
60: PROCEDURE update_cover(
61: p_note_id IN ar_notes.note_id%type,

Line 58: p_creation_date IN OUT NOCOPY ar_notes.creation_date%type );

54: p_last_updated_by IN OUT NOCOPY ar_notes.last_updated_by%type,
55: p_last_update_date IN OUT NOCOPY ar_notes.last_update_date%type,
56: p_last_update_login IN OUT NOCOPY ar_notes.last_update_login%type,
57: p_created_by IN OUT NOCOPY ar_notes.created_by%type,
58: p_creation_date IN OUT NOCOPY ar_notes.creation_date%type );
59:
60: PROCEDURE update_cover(
61: p_note_id IN ar_notes.note_id%type,
62: p_created_by IN ar_notes.created_by%type,

Line 61: p_note_id IN ar_notes.note_id%type,

57: p_created_by IN OUT NOCOPY ar_notes.created_by%type,
58: p_creation_date IN OUT NOCOPY ar_notes.creation_date%type );
59:
60: PROCEDURE update_cover(
61: p_note_id IN ar_notes.note_id%type,
62: p_created_by IN ar_notes.created_by%type,
63: p_creation_date IN ar_notes.creation_date%type,
64: p_note_type IN ar_notes.note_type%type,
65: p_text IN ar_notes.text%type,

Line 62: p_created_by IN ar_notes.created_by%type,

58: p_creation_date IN OUT NOCOPY ar_notes.creation_date%type );
59:
60: PROCEDURE update_cover(
61: p_note_id IN ar_notes.note_id%type,
62: p_created_by IN ar_notes.created_by%type,
63: p_creation_date IN ar_notes.creation_date%type,
64: p_note_type IN ar_notes.note_type%type,
65: p_text IN ar_notes.text%type,
66: p_customer_call_id IN ar_notes.customer_call_id%type,

Line 63: p_creation_date IN ar_notes.creation_date%type,

59:
60: PROCEDURE update_cover(
61: p_note_id IN ar_notes.note_id%type,
62: p_created_by IN ar_notes.created_by%type,
63: p_creation_date IN ar_notes.creation_date%type,
64: p_note_type IN ar_notes.note_type%type,
65: p_text IN ar_notes.text%type,
66: p_customer_call_id IN ar_notes.customer_call_id%type,
67: p_customer_call_topic_id IN ar_notes.customer_call_topic_id%type,

Line 64: p_note_type IN ar_notes.note_type%type,

60: PROCEDURE update_cover(
61: p_note_id IN ar_notes.note_id%type,
62: p_created_by IN ar_notes.created_by%type,
63: p_creation_date IN ar_notes.creation_date%type,
64: p_note_type IN ar_notes.note_type%type,
65: p_text IN ar_notes.text%type,
66: p_customer_call_id IN ar_notes.customer_call_id%type,
67: p_customer_call_topic_id IN ar_notes.customer_call_topic_id%type,
68: p_call_action_id IN ar_notes.call_action_id%type,

Line 65: p_text IN ar_notes.text%type,

61: p_note_id IN ar_notes.note_id%type,
62: p_created_by IN ar_notes.created_by%type,
63: p_creation_date IN ar_notes.creation_date%type,
64: p_note_type IN ar_notes.note_type%type,
65: p_text IN ar_notes.text%type,
66: p_customer_call_id IN ar_notes.customer_call_id%type,
67: p_customer_call_topic_id IN ar_notes.customer_call_topic_id%type,
68: p_call_action_id IN ar_notes.call_action_id%type,
69: p_customer_trx_id IN ar_notes.customer_trx_id%type,

Line 66: p_customer_call_id IN ar_notes.customer_call_id%type,

62: p_created_by IN ar_notes.created_by%type,
63: p_creation_date IN ar_notes.creation_date%type,
64: p_note_type IN ar_notes.note_type%type,
65: p_text IN ar_notes.text%type,
66: p_customer_call_id IN ar_notes.customer_call_id%type,
67: p_customer_call_topic_id IN ar_notes.customer_call_topic_id%type,
68: p_call_action_id IN ar_notes.call_action_id%type,
69: p_customer_trx_id IN ar_notes.customer_trx_id%type,
70: p_last_updated_by IN OUT NOCOPY ar_notes.last_updated_by%type,

Line 67: p_customer_call_topic_id IN ar_notes.customer_call_topic_id%type,

63: p_creation_date IN ar_notes.creation_date%type,
64: p_note_type IN ar_notes.note_type%type,
65: p_text IN ar_notes.text%type,
66: p_customer_call_id IN ar_notes.customer_call_id%type,
67: p_customer_call_topic_id IN ar_notes.customer_call_topic_id%type,
68: p_call_action_id IN ar_notes.call_action_id%type,
69: p_customer_trx_id IN ar_notes.customer_trx_id%type,
70: p_last_updated_by IN OUT NOCOPY ar_notes.last_updated_by%type,
71: p_last_update_date IN OUT NOCOPY ar_notes.last_update_date%type,

Line 68: p_call_action_id IN ar_notes.call_action_id%type,

64: p_note_type IN ar_notes.note_type%type,
65: p_text IN ar_notes.text%type,
66: p_customer_call_id IN ar_notes.customer_call_id%type,
67: p_customer_call_topic_id IN ar_notes.customer_call_topic_id%type,
68: p_call_action_id IN ar_notes.call_action_id%type,
69: p_customer_trx_id IN ar_notes.customer_trx_id%type,
70: p_last_updated_by IN OUT NOCOPY ar_notes.last_updated_by%type,
71: p_last_update_date IN OUT NOCOPY ar_notes.last_update_date%type,
72: p_last_update_login IN OUT NOCOPY ar_notes.last_update_login%type );

Line 69: p_customer_trx_id IN ar_notes.customer_trx_id%type,

65: p_text IN ar_notes.text%type,
66: p_customer_call_id IN ar_notes.customer_call_id%type,
67: p_customer_call_topic_id IN ar_notes.customer_call_topic_id%type,
68: p_call_action_id IN ar_notes.call_action_id%type,
69: p_customer_trx_id IN ar_notes.customer_trx_id%type,
70: p_last_updated_by IN OUT NOCOPY ar_notes.last_updated_by%type,
71: p_last_update_date IN OUT NOCOPY ar_notes.last_update_date%type,
72: p_last_update_login IN OUT NOCOPY ar_notes.last_update_login%type );
73:

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

66: p_customer_call_id IN ar_notes.customer_call_id%type,
67: p_customer_call_topic_id IN ar_notes.customer_call_topic_id%type,
68: p_call_action_id IN ar_notes.call_action_id%type,
69: p_customer_trx_id IN ar_notes.customer_trx_id%type,
70: p_last_updated_by IN OUT NOCOPY ar_notes.last_updated_by%type,
71: p_last_update_date IN OUT NOCOPY ar_notes.last_update_date%type,
72: p_last_update_login IN OUT NOCOPY ar_notes.last_update_login%type );
73:
74:

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

67: p_customer_call_topic_id IN ar_notes.customer_call_topic_id%type,
68: p_call_action_id IN ar_notes.call_action_id%type,
69: p_customer_trx_id IN ar_notes.customer_trx_id%type,
70: p_last_updated_by IN OUT NOCOPY ar_notes.last_updated_by%type,
71: p_last_update_date IN OUT NOCOPY ar_notes.last_update_date%type,
72: p_last_update_login IN OUT NOCOPY ar_notes.last_update_login%type );
73:
74:
75: END ARP_NOTES_PKG;

Line 72: p_last_update_login IN OUT NOCOPY ar_notes.last_update_login%type );

68: p_call_action_id IN ar_notes.call_action_id%type,
69: p_customer_trx_id IN ar_notes.customer_trx_id%type,
70: p_last_updated_by IN OUT NOCOPY ar_notes.last_updated_by%type,
71: p_last_update_date IN OUT NOCOPY ar_notes.last_update_date%type,
72: p_last_update_login IN OUT NOCOPY ar_notes.last_update_login%type );
73:
74:
75: END ARP_NOTES_PKG;