1 PACKAGE IEX_SEND_FFM_PVT AUTHID CURRENT_USER as
2 /* $Header: iexvffms.pls 120.1 2004/10/28 20:30:17 clchang ship $ */
3 -- Start of Comments
4 -- Package name : IEX_SEND_FFM_PVT
5 -- Purpose : Calling Fullfillment
6 -- NOTE :
7 -- History :
8 -- 03/20/2001 CLCHANG Created.
9 -- End of Comments
10
11 TYPE content_rec_type is RECORD
12 ( Content_ID NUMBER ,
13 Media_Type VARCHAR2(30) ,
14 Request_Type VARCHAR2(30) ,
15 User_Note VARCHAR2(1000),
16 Document_Type VARCHAR2(30) ,
17 Email VARCHAR2(1000) ,
18 Printer VARCHAR2(1000) ,
19 File_Path VARCHAR2(1000) ,
20 Fax VARCHAR2(1000)
21 );
22
23 TYPE content_tbl_type is table of content_rec_type
24 index by binary_integer;
25
26 G_MISS_CONTENT_REC content_rec_type;
27 G_MISS_CONTENT_TBL content_tbl_type;
28
29 -- a PLSQL Table may not contain a table or a record with composite fields.
30 -- So we use bind_cnt_tbl to count the num of bind vars for each content.
31 -- EX: bind_cnt_tbl(1) := 2 => content1 has 2 bind_vars
32 -- => bind_var(1)&(2) are for content1 (content_tbl_type(1))
33 -- bind_cnt_tbl(2) := 1 => bind_var(3) is for content2 (content_tbl_type(2))
34 TYPE bind_cnt_tbl is table of NUMBER index by binary_integer;
35
36
37 G_MISS_VARCHAR_TBL JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
38
39
40 -- *************************
41 -- Validation Procedures
42 -- *************************
43 PROCEDURE Validate_Media_Type
44 (
45 P_Init_Msg_List IN VARCHAR2 ,
46 P_Content_Tbl IN IEX_SEND_FFM_PVT.CONTENT_TBL_TYPE,
47 X_Return_Status OUT NOCOPY VARCHAR2,
48 X_Msg_Count OUT NOCOPY NUMBER,
49 X_Msg_Data OUT NOCOPY VARCHAR2
50 );
51
52 -- **************************
53 -- Calling FFM APIs
54 -- **************************
55
56 -- API Name: Send_FFM
57
58 PROCEDURE Send_FFM(
59 P_Api_Version_Number IN NUMBER,
60 P_Init_Msg_List IN VARCHAR2 ,
61 P_Commit IN VARCHAR2 ,
62 p_Content_NM IN VARCHAR2,
63 P_User_id IN NUMBER,
64 P_Server_id IN NUMBER,
65 P_Party_id IN NUMBER,
66 p_Subject IN VARCHAR2 ,
67 --
68 P_Content_tbl IN IEX_SEND_FFM_PVT.CONTENT_TBL_TYPE,
69 p_bind_var IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE,
70 p_bind_var_type IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE,
71 p_bind_val IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE,
72 /*
73 P_Content_ID IN NUMBER,
74 P_Media_Type IN VARCHAR2,
75 P_Request_Type IN VARCHAR2,
76 P_User_Note IN VARCHAR2,
77 P_Document_Type IN VARCHAR2,
78 P_Subject IN VARCHAR2,
79 P_Email IN VARCHAR2,
80 P_Printer IN VARCHAR2,
81 P_File_Path IN VARCHAR2,
82 P_Fax IN VARCHAR2,
83 */
84 X_Request_ID OUT NOCOPY NUMBER,
85 X_Return_Status OUT NOCOPY VARCHAR2,
86 X_Msg_Count OUT NOCOPY NUMBER,
87 X_Msg_Data OUT NOCOPY VARCHAR2
88 );
89
90
91 End IEX_SEND_FFM_PVT;