1 PACKAGE ARP_NOTES_PKG AS
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,
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
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 );
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,
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,
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,
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,
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,
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;