DBA Data[Home] [Help]

PACKAGE: APPS.IEC_IH_HLPR_PVT

Source


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;