[Home] [Help]
PACKAGE: APPS.OKL_AM_SEND_FULFILLMENT_PVT
Source
1 PACKAGE OKL_AM_SEND_FULFILLMENT_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRSFWS.pls 115.4 2002/08/13 17:58:42 rmunjulu noship $ */
3
4 ---------------------------------------------------------------------------
5 -- GLOBAL CONSTANTS
6 ---------------------------------------------------------------------------
7 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_AM_SEND_FULFILLMENT_PVT';
8 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
9 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
10 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
11 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
12 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
13 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
14 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
15
16 -- p_ptm_code : From OKL_PROCESS_TMPLTS_V
17 -- p_agent_id : Created by
18 -- p_transaction_id : Quote_Id, Rmk_Id etc
19 -- p_recipient_type : Party(P),
20 -- Party Contact (PC),
21 -- Party Site (PS),
22 -- Vendor(V),
23 -- Vendor Contact(VC),
24 -- Vendor Site (VS)
25 -- p_recipient_id :
26
27
28 TYPE full_rec_type IS RECORD (
29 p_ptm_code VARCHAR2(200) := OKL_API.G_MISS_CHAR,
30 p_agent_id NUMBER := OKL_API.G_MISS_NUM,
31 p_transaction_id NUMBER := OKL_API.G_MISS_NUM,
32 p_recipient_type VARCHAR2(200) := OKL_API.G_MISS_CHAR,
33 p_recipient_id VARCHAR2(200) := OKL_API.G_MISS_CHAR,
34 p_expand_roles VARCHAR2(200) := OKL_API.G_MISS_CHAR,
35 p_subject_line VARCHAR2(200) := OKL_API.G_MISS_CHAR,
36 p_sender_email VARCHAR2(200) := OKL_API.G_MISS_CHAR,
37 p_recipient_email VARCHAR2(200) := OKL_API.G_MISS_CHAR);
38
39 TYPE full_tbl_type IS TABLE OF full_rec_type INDEX BY BINARY_INTEGER;
40
41 SUBTYPE qtev_rec_type IS OKL_TRX_QUOTES_PUB.qtev_rec_type;
42 SUBTYPE q_party_uv_tbl_type IS OKL_AM_PARTIES_PVT.q_party_uv_tbl_type;
43
44
45 PROCEDURE send_fulfillment (
46 p_api_version IN NUMBER,
47 p_init_msg_list IN VARCHAR2,
48 x_return_status OUT NOCOPY VARCHAR2,
49 x_msg_count OUT NOCOPY NUMBER,
50 x_msg_data OUT NOCOPY VARCHAR2,
51 p_send_rec IN full_rec_type,
52 x_send_rec OUT NOCOPY full_rec_type);
53
54 PROCEDURE send_fulfillment (
55 p_api_version IN NUMBER,
56 p_init_msg_list IN VARCHAR2,
57 x_return_status OUT NOCOPY VARCHAR2,
58 x_msg_count OUT NOCOPY NUMBER,
59 x_msg_data OUT NOCOPY VARCHAR2,
60 p_send_tbl IN full_tbl_type,
61 x_send_tbl OUT NOCOPY full_tbl_type);
62
63 PROCEDURE send_terminate_quote (
64 p_api_version IN NUMBER,
65 p_init_msg_list IN VARCHAR2,
66 x_return_status OUT NOCOPY VARCHAR2,
67 x_msg_count OUT NOCOPY NUMBER,
68 x_msg_data OUT NOCOPY VARCHAR2,
69 p_party_tbl IN q_party_uv_tbl_type,
70 x_party_tbl OUT NOCOPY q_party_uv_tbl_type,
71 p_qtev_rec IN qtev_rec_type,
72 x_qtev_rec OUT NOCOPY qtev_rec_type);
73
74 PROCEDURE send_repurchase_quote (
75 p_api_version IN NUMBER,
76 p_init_msg_list IN VARCHAR2,
77 x_return_status OUT NOCOPY VARCHAR2,
78 x_msg_count OUT NOCOPY NUMBER,
79 x_msg_data OUT NOCOPY VARCHAR2,
80 p_send_tbl IN full_tbl_type,
81 x_send_tbl OUT NOCOPY full_tbl_type,
82 p_qtev_rec IN qtev_rec_type,
83 x_qtev_rec OUT NOCOPY qtev_rec_type);
84
85 PROCEDURE send_restructure_quote (
86 p_api_version IN NUMBER,
87 p_init_msg_list IN VARCHAR2,
88 x_return_status OUT NOCOPY VARCHAR2,
89 x_msg_count OUT NOCOPY NUMBER,
90 x_msg_data OUT NOCOPY VARCHAR2,
91 p_send_tbl IN full_tbl_type,
92 x_send_tbl OUT NOCOPY full_tbl_type,
93 p_qtev_rec IN qtev_rec_type,
94 x_qtev_rec OUT NOCOPY qtev_rec_type);
95
96 PROCEDURE send_consolidate_quote (
97 p_api_version IN NUMBER,
98 p_init_msg_list IN VARCHAR2,
99 x_return_status OUT NOCOPY VARCHAR2,
100 x_msg_count OUT NOCOPY NUMBER,
101 x_msg_data OUT NOCOPY VARCHAR2,
102 p_send_tbl IN full_tbl_type,
103 x_send_tbl OUT NOCOPY full_tbl_type,
104 p_qtev_rec IN qtev_rec_type,
105 x_qtev_rec OUT NOCOPY qtev_rec_type);
106
107 END OKL_AM_SEND_FULFILLMENT_PVT;