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,
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:
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);
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:
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);
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:
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:
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,
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:
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
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: );
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:
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(
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,
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,
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,
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,
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,
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,
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,
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,
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 );
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:
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(
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,
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,
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,
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,
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,
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,
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,
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,
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,
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 );
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:
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(
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,
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,
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,
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,
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,
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,
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,
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,
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,
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 );
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:
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:
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;
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;