1 PACKAGE IEC_VALIDATE_PVT AUTHID CURRENT_USER AS
2 /* $Header: IECVALS.pls 120.1 2005/06/06 08:55:22 appldev $ */
3
4 G_NUM_CONTACT_POINTS CONSTANT NUMBER := 6;
5 G_LISTHEADER_REC_INITIAL NUMBER :=0;
6 l_listheader_rec AMS_LISTHEADER_PVT.list_header_rec_type;
7
8
9 TYPE ContactPoint IS RECORD (
10 id NUMBER(15),
11 phone_country_code VARCHAR2(500),
12 phone_area_code VARCHAR2(500),
13 phone_number VARCHAR2(500),
14 raw_phone_number VARCHAR2(500),
15 time_zone VARCHAR2(500),
16 phone_line_type VARCHAR2(30),
17 purpose VARCHAR2(30),
18 territory_code VARCHAR2(500),
19 region_id NUMBER(15),
20 cc_tz_id NUMBER(15),
21 valid_flag VARCHAR2(1),
22 dnu_reason NUMBER
23 );
24
25 TYPE ContactPointList IS VARRAY(6) OF ContactPoint;
26
27 TYPE ListEntryCsrType IS REF CURSOR;
28
29 PROCEDURE Init_ContactPointRecord
30 ( x_contact_point IN OUT NOCOPY ContactPoint);
31
32 PROCEDURE Validate_List
33 ( p_list_id IN NUMBER
34 , x_return_code OUT NOCOPY VARCHAR2);
35
36 -- Moves a recycled entry to a new target group and dynamically
37 -- loads the entry into the AO system. Call history is moved with the entry.
38 -- The validation procedure is bypassed since a recycled entry
39 -- has already been validated.
40 PROCEDURE Move_RecycledEntry
41 ( p_returns_id IN NUMBER
42 , p_to_list_id IN NUMBER);
43
44 -- Moves recycled entries to a new target group and dynamically
45 -- loads the entries into the AO system. Call history is moved with the entries.
46 -- The validation procedure is bypassed since a recycled entry
47 -- has already been validated.
48 PROCEDURE Move_RecycledEntries
49 ( p_returns_id_col IN SYSTEM.number_tbl_type
50 , p_to_list_id IN NUMBER);
51
52 -- Moves all validated entries from one target group to another and
53 -- dynamically loads the entries into the AO system. Call history is moved
54 -- with the entries. The entries are marked as do not use in the original
55 -- list. Assumes that target group has been validated. Only validated
56 -- entries will be moved. Non-validated entries will remain untouched.
57 PROCEDURE Copy_TargetGroupEntries
58 ( p_from_list_id IN NUMBER
59 , p_to_list_id IN NUMBER);
60
61 -- Dynamically validates and loads a new list entry into the AO system.
62 PROCEDURE Load_NewEntry
63 ( p_list_entry_id IN NUMBER
64 , p_list_id IN NUMBER);
65
66 -- Dynamically validates and loads a collection of new list entries into the AO system.
67 PROCEDURE Load_NewEntries
68 ( p_list_entry_id_col IN SYSTEM.number_tbl_type
69 , p_list_id IN NUMBER);
70
71 -- Called by the time zone map loader utility to remove redundant
72 -- time zone mapping entries - performance enhancement for validation
73 PROCEDURE Update_Tz_Mappings;
74
75 -- Dynamically inserts a new record into a calling list
76 -- If record cannot be inserted or validated, the appropriate
77 -- failure code will be returned and the entire transaction
78 -- will be rolled back
79 PROCEDURE Add_Record_To_List_Interactive
80 ( p_list_id IN NUMBER
81 , p_column_name IN SYSTEM.varchar_tbl_type
82 , p_column_value IN SYSTEM.varchar_tbl_type
83 , p_callback_time IN DATE DEFAULT NULL
84 , x_failure_code OUT NOCOPY VARCHAR2
85 );
86
87 -- Dynamically inserts a new record into a calling list
88 -- If record cannot be inserted or validated, the appropriate
89 -- failure code will be returned. If the record is inserted
90 -- but fails validation, the record will remain in the calling
91 -- list as an invalid record
92 PROCEDURE Add_Record_To_List
93 ( p_list_id IN NUMBER
94 , p_column_name IN SYSTEM.varchar_tbl_type
95 , p_column_value IN SYSTEM.varchar_tbl_type
96 , p_callback_time IN DATE DEFAULT NULL
97 , x_failure_code OUT NOCOPY VARCHAR2
98 );
99
100 -- Updates a contact point in AMS_LIST_ENTRIES and optionally
101 -- updates the corresponding contact point in HZ_CONTACT_POINTS
102 PROCEDURE Update_ContactPoint
103 ( p_list_id IN NUMBER
104 , p_list_entry_id IN NUMBER
105 , p_party_id IN NUMBER
106 , p_contact_point_id IN NUMBER
107 , p_index IN NUMBER
108 , p_country_code IN VARCHAR2
109 , p_area_code IN VARCHAR2
110 , p_phone_number IN VARCHAR2
111 , p_time_zone IN NUMBER
112 , p_update_tca_flag IN VARCHAR2
113 );
114
115 -- Called by public api to copy schedule entries
116 PROCEDURE Copy_ScheduleEntries_Pub
117 ( p_src_schedule_id IN NUMBER
118 , p_dest_schedule_id IN NUMBER
119 , p_commit IN BOOLEAN
120 , x_return_status OUT NOCOPY VARCHAR2);
121
122 -- Called by public api to move schedule entries
123 PROCEDURE Move_ScheduleEntries_Pub
124 ( p_src_schedule_id IN NUMBER
125 , p_dest_schedule_id IN NUMBER
126 , p_commit IN BOOLEAN
127 , x_return_status OUT NOCOPY VARCHAR2);
128
129 -- Called by public api to move schedule entries
130 PROCEDURE Purge_ScheduleEntries_Pub
131 ( p_schedule_id IN NUMBER
132 , p_commit IN BOOLEAN
133 , x_return_status OUT NOCOPY VARCHAR2);
134
135
136 END IEC_VALIDATE_PVT;