1 PACKAGE IEC_IH_HLPR_PVT AUTHID CURRENT_USER AS
2 /* $Header: IECVIHS.pls 115.14 2004/05/24 20:39:50 minwang noship $ */
3
4 -- Generic initial parameter, record and table defs used by CALL_IH
5 L_INTERACTION_INITIAL NUMBER :=0;
6 L_MEDIA_LC_INITIAL NUMBER := 0;
7
8 L_INTERACTION_REC JTF_IH_PUB.interaction_rec_type;
9 L_ACTIVITIES_TBL JTF_IH_PUB.activity_tbl_type;
10 L_MEDIA_LC_REC JTF_IH_PUB.media_lc_rec_type;
11
12 TYPE MEDIA_ID_CURSOR is REF CURSOR;
13
14 TYPE MEDIA_ID_TAB is TABLE of JTF_IH_MEDIA_ITEMS.MEDIA_ID%TYPE index by binary_integer;
15
16 -- Create interaction
17 PROCEDURE CREATE_INTERACTION
18 (
19 P_MEDIA_ID IN NUMBER,
20 P_PARTY_ID IN NUMBER,
21 P_START_TIME IN DATE,
22 P_END_TIME IN DATE,
23 P_OUTCOME_ID IN NUMBER,
24 P_REASON_ID IN NUMBER,
25 P_RESULT_ID IN NUMBER
26 );
27
28 -- update and close AO media item
29 PROCEDURE UPDATE_CLOSE_MEDIA_ITEM
30 (
31 P_MEDIA_ID IN NUMBER,
32 P_SUBSET_ID IN NUMBER,
33 P_SVR_GROUP_ID IN NUMBER,
34 P_START_TIME IN DATE,
35 P_END_TIME IN DATE,
36 P_ADDRESS IN VARCHAR2,
37 P_ABANDON_FLAG IN VARCHAR2,
38 P_HARD_CLOSE IN VARCHAR2
39 );
40
41 -- create media item life cycle segment
42 PROCEDURE CREATE_MILCS
43 (
44 P_MEDIA_ID IN NUMBER,
45 P_MILCS_TYPE IN NUMBER,
46 P_START_TIME IN DATE,
47 P_END_TIME IN DATE
48 );
49
50 END IEC_IH_HLPR_PVT;