1 PACKAGE OKC_REP_CONTRACT_IMP_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKCPREPIMPS.pls 120.0.12020000.4 2013/02/22 12:27:14 kkolukul noship $ */
3
4 /*
5 Creates a contract with the data given in the parameters.
6 p_create_contract true :A contract will be created
7 false: only dumps data to interface tables. The CP Impor Repository Contract has to be run to create the contract.
8 */
9
10 Procedure create_contract(p_api_version IN NUMBER,
11 p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
12 p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,
13 p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,
14 p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,
15 p_create_contract IN VARCHAR2 := fnd_api.g_true,
16 p_commit IN VARCHAR2 := fnd_api.g_false,
17 x_msg_data OUT NOCOPY VARCHAR2,
18 x_msg_count OUT NOCOPY NUMBER,
19 x_return_status OUT NOCOPY VARCHAR2
20 );
21
22
23 /*
24 Deletes the Contract with the given contract id
25 */
26
27 Procedure delete_contract(p_api_version IN NUMBER,
28 p_contract_id IN NUMBER,
29 p_commit IN VARCHAR2 := fnd_api.g_false,
30 x_msg_data OUT NOCOPY VARCHAR2,
31 x_msg_count OUT NOCOPY NUMBER,
32 x_return_status OUT NOCOPY VARCHAR2
33 );
34
35 /*
36 Creates a contract with the data given in the parameters.
37 The relation of parent document which is obtained in p_document_rec is stored in the okc_rep_contract_usages table
38 */
39
40 Procedure create_contract(p_api_version IN NUMBER,
41 p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
42 p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
43 p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,
44 p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,
45 p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,
46 p_commit IN VARCHAR2 := fnd_api.g_false,
47 x_msg_data OUT NOCOPY VARCHAR2,
48 x_msg_count OUT NOCOPY NUMBER,
49 x_return_status OUT NOCOPY VARCHAR2
50 );
51
52 /*
53 Deletes the Contract for the given document type.
54 */
55
56 Procedure delete_contract(p_api_version IN NUMBER,
57 p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
58 p_contract_type IN VARCHAR2 DEFAULT NULL,
59 p_contract_id IN NUMBER DEFAULT NULL,
60 p_commit IN VARCHAR2 := fnd_api.g_false,
61 x_msg_data OUT NOCOPY VARCHAR2,
62 x_msg_count OUT NOCOPY NUMBER,
63 x_return_status OUT NOCOPY VARCHAR2
64 );
65
66 /*
67 Creates a new version of the contract contract in draft status.
68 Updates to the contract should be done from UI.
69 */
70
71 Procedure create_new_contract_version(p_api_version IN NUMBER,
72 p_contract_id IN NUMBER,
73 p_commit IN VARCHAR2 := fnd_api.g_false,
74 x_msg_data OUT NOCOPY VARCHAR2,
75 x_msg_count OUT NOCOPY NUMBER,
76 x_return_status OUT NOCOPY VARCHAR2
77 );
78
79
80 /*
81 Creates a new version of the contract contract in draft status.
82 Updates to the contract should be done from UI.
83
84 The relation of parent document which is obtained in p_document_rec is stored in the okc_rep_contract_usages table
85 */
86
87 Procedure create_new_contract_version(p_api_version IN NUMBER,
88 p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
89 p_contract_type IN VARCHAR2 DEFAULT NULL,
90 p_contract_id IN NUMBER DEFAULT NULL,
91 p_commit IN VARCHAR2 := fnd_api.g_false,
92 x_msg_data OUT NOCOPY VARCHAR2,
93 x_msg_count OUT NOCOPY NUMBER,
94 x_return_status OUT NOCOPY VARCHAR2
95 );
96
97 PROCEDURE check_contract_exists(p_api_version IN NUMBER,
98 p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
99 x_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
100 x_msg_data OUT NOCOPY VARCHAR2,
101 x_msg_count OUT NOCOPY NUMBER,
102 x_return_status OUT NOCOPY VARCHAR2
103 );
104
105 PROCEDURE Activate_tasks_closeout(p_api_version IN NUMBER,
106 p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
107 p_physical_completion_date IN DATE ,
108 p_init_msg_list IN VARCHAR2,
109 p_commit IN VARCHAR2,
110 x_msg_data OUT NOCOPY VARCHAR2,
111 x_msg_count OUT NOCOPY NUMBER,
112 x_return_status OUT NOCOPY VARCHAR2
113 );
114
115 /*
116 Cancels the Contract for the given document type.
117 */
118
119 Procedure cancel_contract(p_api_version IN NUMBER,
120 p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
121 p_contract_type IN VARCHAR2 DEFAULT NULL,
122 p_contract_id IN NUMBER DEFAULT NULL,
123 p_commit IN VARCHAR2 := fnd_api.g_false,
124 x_msg_data OUT NOCOPY VARCHAR2,
125 x_msg_count OUT NOCOPY NUMBER,
126 x_return_status OUT NOCOPY VARCHAR2
127 );
128
129 PROCEDURE cancel_contract(p_api_version IN NUMBER,
130 p_commit IN VARCHAR2 := fnd_api.g_false,
131 p_contract_id IN NUMBER,
132 x_msg_data OUT NOCOPY VARCHAR2,
133 x_msg_count OUT NOCOPY NUMBER,
134 x_return_status OUT NOCOPY VARCHAR2
135 );
136
137 Procedure delete_cancel_contract(p_api_version IN NUMBER,
138 p_commit IN VARCHAR2 := fnd_api.g_false,
139 p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
140 p_contract_type IN VARCHAR2 DEFAULT NULL,
141 p_contract_id IN NUMBER DEFAULT NULL,
142 x_msg_data OUT NOCOPY VARCHAR2,
143 x_msg_count OUT NOCOPY NUMBER,
144 x_return_status OUT NOCOPY VARCHAR2
145 );
146
147 END OKC_REP_CONTRACT_IMP_PUB;
148