DBA Data[Home] [Help]

APPS.OKC_REP_CONTRACT_IMP_PVT dependencies on OKC_IMP_RECORD_TYPES

Line 53: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,

49: G_RETURN_CODE_SUCCESS CONSTANT NUMBER := 0;
50: G_RETURN_CODE_ERROR CONSTANT NUMBER := 2;
51:
52: Procedure create_contract(p_api_version IN NUMBER,
53: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
54: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,
55: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,
56: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,
57: p_create_contract IN VARCHAR2 := fnd_api.g_true,

Line 54: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,

50: G_RETURN_CODE_ERROR CONSTANT NUMBER := 2;
51:
52: Procedure create_contract(p_api_version IN NUMBER,
53: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
54: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,
55: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,
56: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,
57: p_create_contract IN VARCHAR2 := fnd_api.g_true,
58: p_commit IN VARCHAR2 := fnd_api.g_false,

Line 55: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,

51:
52: Procedure create_contract(p_api_version IN NUMBER,
53: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
54: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,
55: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,
56: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,
57: p_create_contract IN VARCHAR2 := fnd_api.g_true,
58: p_commit IN VARCHAR2 := fnd_api.g_false,
59: x_msg_data OUT NOCOPY VARCHAR2,

Line 56: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,

52: Procedure create_contract(p_api_version IN NUMBER,
53: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
54: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,
55: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,
56: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,
57: p_create_contract IN VARCHAR2 := fnd_api.g_true,
58: p_commit IN VARCHAR2 := fnd_api.g_false,
59: x_msg_data OUT NOCOPY VARCHAR2,
60: x_msg_count OUT NOCOPY NUMBER,

Line 65: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,

61: x_return_status OUT NOCOPY VARCHAR2
62: );
63:
64: Procedure populate_contract_hdr(p_api_version IN NUMBER,
65: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
66: p_run_id IN NUMBER ,
67: x_imp_contract_id OUT NOCOPY NUMBER,
68: x_msg_data OUT NOCOPY VARCHAR2,
69: x_msg_count OUT NOCOPY NUMBER,

Line 75: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,

71: );
72:
73: PROCEDURE populate_contract_parties (p_api_version IN NUMBER,
74: p_run_id IN NUMBER,
75: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,
76: p_imp_contract_id IN NUMBER,
77: x_msg_data OUT NOCOPY VARCHAR2,
78: x_msg_count OUT NOCOPY NUMBER,
79: x_return_status OUT NOCOPY VARCHAR2);

Line 83: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,

79: x_return_status OUT NOCOPY VARCHAR2);
80:
81: PROCEDURE populate_party_contacts(p_api_version IN NUMBER,
82: p_run_id IN NUMBER,
83: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,
84: p_imp_contract_id IN NUMBER,
85: x_msg_data OUT NOCOPY VARCHAR2,
86: x_msg_count OUT NOCOPY NUMBER,
87: x_return_status OUT NOCOPY VARCHAR2);

Line 91: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,

87: x_return_status OUT NOCOPY VARCHAR2);
88:
89: PROCEDURE populate_contract_risks(p_api_version IN NUMBER,
90: p_run_id IN NUMBER DEFAULT NULL,
91: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,
92: p_imp_contract_id IN NUMBER,
93: x_msg_data OUT NOCOPY VARCHAR2,
94: x_msg_count OUT NOCOPY NUMBER,
95: x_return_status OUT NOCOPY VARCHAR2);

Line 115: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,

111: p_validate_only IN VARCHAR2 );
112:
113: /* PROCEDURE delete_contract_risks(p_api_version IN NUMBER,
114: p_run_id IN NUMBER DEFAULT NULL,
115: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,
116: p_imp_contract_id IN NUMBER,
117: x_msg_data OUT NOCOPY VARCHAR2,
118: x_msg_count OUT NOCOPY NUMBER,
119: x_return_status OUT NOCOPY VARCHAR2);

Line 122: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,

118: x_msg_count OUT NOCOPY NUMBER,
119: x_return_status OUT NOCOPY VARCHAR2);
120: PROCEDURE delete_party_contacts(p_api_version IN NUMBER,
121: p_run_id IN NUMBER,
122: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,
123: p_imp_contract_id IN NUMBER,
124: x_msg_data OUT NOCOPY VARCHAR2,
125: x_msg_count OUT NOCOPY NUMBER,
126: x_return_status OUT NOCOPY VARCHAR2);

Line 129: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,

125: x_msg_count OUT NOCOPY NUMBER,
126: x_return_status OUT NOCOPY VARCHAR2);
127: PROCEDURE delete_parties(p_api_version IN NUMBER,
128: p_run_id IN NUMBER,
129: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,
130: p_imp_contract_id IN NUMBER,
131: x_msg_data OUT NOCOPY VARCHAR2,
132: x_msg_count OUT NOCOPY NUMBER,
133: x_return_status OUT NOCOPY VARCHAR2);

Line 142: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,

138: The relation of parent document which is obtained in p_document_rec is stored in the okc_rep_contract_usages table
139: */
140:
141: Procedure create_contract(p_api_version IN NUMBER,
142: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
143: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
144: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,
145: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,
146: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,

Line 143: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,

139: */
140:
141: Procedure create_contract(p_api_version IN NUMBER,
142: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
143: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
144: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,
145: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,
146: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,
147: p_commit IN VARCHAR2 := fnd_api.g_false,

Line 144: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,

140:
141: Procedure create_contract(p_api_version IN NUMBER,
142: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
143: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
144: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,
145: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,
146: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,
147: p_commit IN VARCHAR2 := fnd_api.g_false,
148: x_msg_data OUT NOCOPY VARCHAR2,

Line 145: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,

141: Procedure create_contract(p_api_version IN NUMBER,
142: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
143: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
144: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,
145: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,
146: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,
147: p_commit IN VARCHAR2 := fnd_api.g_false,
148: x_msg_data OUT NOCOPY VARCHAR2,
149: x_msg_count OUT NOCOPY NUMBER,

Line 146: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,

142: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
143: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
144: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,
145: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,
146: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,
147: p_commit IN VARCHAR2 := fnd_api.g_false,
148: x_msg_data OUT NOCOPY VARCHAR2,
149: x_msg_count OUT NOCOPY NUMBER,
150: x_return_status OUT NOCOPY VARCHAR2

Line 159: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,

155: */
156:
157: Procedure delete_contract(p_api_version IN NUMBER,
158: p_commit IN VARCHAR2 := fnd_api.g_false,
159: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
160: p_contract_type IN VARCHAR2 DEFAULT NULL,
161: p_contract_id IN NUMBER DEFAULT NULL,
162: x_msg_data OUT NOCOPY VARCHAR2,
163: x_msg_count OUT NOCOPY NUMBER,

Line 192: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,

188: The relation of parent document which is obtained in p_document_rec is stored in the okc_rep_contract_usages table
189: */
190:
191: Procedure create_new_contract_version(p_api_version IN NUMBER,
192: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
193: p_contract_type IN VARCHAR2 DEFAULT NULL,
194: p_contract_id IN NUMBER DEFAULT NULL,
195: p_run_id IN NUMBER,
196: p_commit IN VARCHAR2 := fnd_api.g_false,

Line 203: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,

199: x_return_status OUT NOCOPY VARCHAR2
200: );
201:
202: PROCEDURE check_contract_exists(p_api_version IN NUMBER,
203: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
204: x_contract_type IN OUT NOCOPY VARCHAR2 ,
205: x_contract_id IN OUT NOCOPY NUMBER ,
206: x_contract_version_num IN OUT NOCOPY NUMBER,
207: x_msg_data OUT NOCOPY VARCHAR2,

Line 213: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,

209: x_return_status OUT NOCOPY VARCHAR2
210: );
211:
212: PROCEDURE Activate_tasks_closeout(p_api_version IN NUMBER,
213: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
214: p_physical_completion_date IN DATE ,
215: p_init_msg_list IN VARCHAR2,
216: p_commit IN VARCHAR2,
217: x_msg_data OUT NOCOPY VARCHAR2,

Line 224: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,

220: );
221:
222:
223: PROCEDURE check_contract_exists(p_api_version IN NUMBER,
224: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
225: x_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
226: x_msg_data OUT NOCOPY VARCHAR2,
227: x_msg_count OUT NOCOPY NUMBER,
228: x_return_status OUT NOCOPY VARCHAR2

Line 225: x_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,

221:
222:
223: PROCEDURE check_contract_exists(p_api_version IN NUMBER,
224: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
225: x_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
226: x_msg_data OUT NOCOPY VARCHAR2,
227: x_msg_count OUT NOCOPY NUMBER,
228: x_return_status OUT NOCOPY VARCHAR2
229: );

Line 241: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,

237: );
238:
239: Procedure delete_cancel_contract(p_api_version IN NUMBER,
240: p_commit IN VARCHAR2 := fnd_api.g_false,
241: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
242: p_contract_type IN VARCHAR2 DEFAULT NULL,
243: p_contract_id IN NUMBER DEFAULT NULL,
244: x_msg_data OUT NOCOPY VARCHAR2,
245: x_msg_count OUT NOCOPY NUMBER,

Line 254: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,

250: Cancels the Contract for the given document type.
251: */
252:
253: Procedure cancel_contract(p_api_version IN NUMBER,
254: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
255: p_contract_type IN VARCHAR2 DEFAULT NULL,
256: p_contract_id IN NUMBER DEFAULT NULL,
257: p_commit IN VARCHAR2 := fnd_api.g_false,
258: x_msg_data OUT NOCOPY VARCHAR2,