1 PACKAGE JTF_FM_OCM_REQUEST_GRP AS
2 /* $Header: jtfgfmos.pls 120.2 2005/10/26 11:29:33 gjoby ship $*/
3
4 -- ------------------------------------------------------------------
5 -- Fulfillment Electronic Record
6 --added emailFormat flag on September 24th.
7 --if null is passed/value not passed, it should be interpreted as html.
8 -- ------------------------------------------------------------------
9 type fulfill_electronic_rec_type is record
10 ( template_id NUMBER, -- used as p_template_id
11 version_id NUMBER, -- used as p_version_id
12 object_type VARCHAR2(240), -- used as object_type
13 object_id NUMBER, -- used as object_id
14 source_code VARCHAR2(30), -- used as source_code
15 source_code_id NUMBER, -- used as source_code_id
16 requestor_type VARCHAR2(30), -- ignore
17 requestor_id NUMBER, -- used as user_id
18 server_group NUMBER, -- used to pass server id
19 schedule_date DATE := SYSDATE, -- ignore
20 media_types VARCHAR2(30) := 'E', -- Default is 'E' for email. other F for Fax, P for Print.
21 archive VARCHAR2(2) := 'N', -- ignore
22 log_user_ih VARCHAR2(2) := 'N', -- used as p_per_user_history
23 request_type VARCHAR2(30), -- s/b 'P'hysical or 'E'lectronic used to branch
24 language_code VARCHAR2(4), -- ignore
25 profile_id NUMBER, -- ignore
26 order_id NUMBER, -- ignore
27 collateral_id NUMBER, -- ignore
28 subject VARCHAR2(4000), -- first 250 chars as email subject
29 party_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE, -- Used for Test Requests
30 email JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE, -- Used for Test Requests
31 fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE, -- Used for Test Requests
32 printer JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE, -- Used for Test Requests
33 bind_values JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE, -- Used to pass bind var name
34 bind_names JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE, -- Used to pass bind var value
35 email_text VARCHAR2(256), -- ignore
36 content_name VARCHAR2(50), -- ignore
37 content_type VARCHAR2(256), -- ignore
38 extended_header VARCHAR2(32767), -- extended headers
39 stop_list_bypass VARCHAR2(30), -- Used to by pass server level setting for
40 email_format VARCHAR2(30) := 'BOTH' --possible values null,TEXT,HTML,BOTH
41
42 );
43
44
45 -- -----------------------------------------------------------------
46 -- Procedure Spec
47 -- -----------------------------------------------------------------
48 PROCEDURE create_fulfillment
49 (
50 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
51 p_api_version IN NUMBER,
52 p_commit IN VARCHAR2 := FND_API.G_FALSE,
53 p_order_header_rec IN JTF_Fulfillment_PUB.ORDER_HEADER_REC_TYPE,
54 p_order_line_tbl IN JTF_Fulfillment_PUB.ORDER_LINE_TBL_TYPE,
55 p_fulfill_electronic_rec IN JTF_FM_OCM_REQUEST_GRP.FULFILL_ELECTRONIC_REC_TYPE,
56 p_request_type IN VARCHAR2,
57 x_return_status OUT NOCOPY VARCHAR2,
58 x_msg_count OUT NOCOPY NUMBER,
59 x_msg_data OUT NOCOPY VARCHAR2,
60 x_order_header_rec OUT NOCOPY ASO_ORDER_INT.order_header_rec_type,
61 x_request_history_id OUT NOCOPY NUMBER
62 );
63
64 END JTF_FM_OCM_REQUEST_GRP;