PACKAGE: APPS.ASO_FFM_INT

Source

1 PACKAGE ASO_FFM_INT AUTHID CURRENT_USER as
2 /* $Header: asoiffms.pls 120.1 2005/06/29 12:33:26 appldev ship $ */
3 -- Start of Comments
4 -- Package name     : ASO_FFM_INT
5 -- Purpose          :
6 -- History          :
7 -- NOTE             :
8 -- End of Comments
9 
10 --   Record Type:
11 --	FFM_REQUEST_REC_TYPE
12 --	FFM_CONTENT_REC_TYPE
13 
14 -- Priority Levels of the fulfillment requests.
15 -- Lower number represents higher priority
16 G_PRIORITY_HIGHEST 		  	CONSTANT    NUMBER := 1;
17 G_PRIORITY_SPECIALITY_FLAG 	CONSTANT    NUMBER := 6;
18 G_PRIORITY_REGULAR 			CONSTANT    NUMBER := 7;
19 G_PRIORITY_BATCH_REQUEST 	CONSTANT    NUMBER := 8;
20 
21 TYPE FFM_REQUEST_REC_TYPE IS RECORD
22 (
23 	template_id		NUMBER := NULL,
24 	subject			VARCHAR2(250) := FND_API.G_MISS_CHAR,
25 	party_id		NUMBER,
26 	user_id			NUMBER,
27 	priority		NUMBER := G_PRIORITY_REGULAR,
28 	source_code_id		NUMBER := FND_API.G_MISS_NUM,
29 	source_code		VARCHAR2(250) := FND_API.G_MISS_CHAR,
30 	object_type		VARCHAR2(250) := FND_API.G_MISS_CHAR,
31 	object_id		NUMBER := FND_API.G_MISS_NUM,
32 	order_id		NUMBER := FND_API.G_MISS_NUM,
33 	server_id		NUMBER,
34 	queue_response		VARCHAR2(250) := FND_API.G_FALSE
35 );
36 
37 
38 TYPE FFM_CONTENT_REC_TYPE IS RECORD
39 (
40 	content_id		NUMBER,
41 	content_name		VARCHAR2(250),
42 	document_type		VARCHAR2(250),
43 	quantity		NUMBER := 1,
44 	media_type		VARCHAR2(250),
45 	printer			VARCHAR2(250) := NULL,
46 	email			VARCHAR2(250) := NULL,
47 	fax			VARCHAR2(250) := NULL,
48 	file_path		VARCHAR2(250) := NULL,
49 	user_note		VARCHAR2(250) := FND_API.G_MISS_CHAR,
50 	content_type		VARCHAR2(250)
51 );
52 
53 TYPE  FFM_Content_Tbl_Type      IS TABLE OF FFM_Content_Rec_Type
54                                     INDEX BY BINARY_INTEGER;
55 
56 TYPE FFM_BIND_REC_TYPE IS RECORD
57 (
58 	content_index		NUMBER,
59 	bind_var		VARCHAR2(1000),
60 	bind_val		VARCHAR2(1000),
61 	bind_var_type		VARCHAR2(1000)
62 );
63 
64 TYPE FFM_Bind_Tbl_Type IS TABLE OF FFM_BIND_REC_TYPE
65 				     INDEX BY BINARY_INTEGER;
66 
67 
68 PROCEDURE Submit_FFM_Request(
69     P_Api_Version_Number	IN	NUMBER,
70     p_Init_Msg_List		IN	VARCHAR2 := FND_API.G_FALSE,
71     p_Commit			IN	VARCHAR2 := FND_API.G_FALSE,
72     p_validation_Level		IN	NUMBER := FND_API.G_VALID_LEVEL_FULL,
73     p_ffm_request_rec		IN	FFM_REQUEST_REC_TYPE,
74     p_ffm_content_tbl		IN	FFM_CONTENT_TBL_TYPE,
75     p_bind_tbl			IN	FFM_Bind_Tbl_Type,
76     X_Request_ID	 OUT NOCOPY /* file.sql.39 change */  	NUMBER,
77     X_Return_Status             OUT NOCOPY /* file.sql.39 change */  	VARCHAR2,
78     X_Msg_Count                 OUT NOCOPY /* file.sql.39 change */  	NUMBER,
79     X_Msg_Data                  OUT NOCOPY /* file.sql.39 change */  	VARCHAR2);
80 
81 End ASO_FFM_INT;