9:
10: PROCEDURE copy_cdrl_for_exhibit
11: (
12: p_api_version IN NUMBER,
13: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
14: p_commit IN VARCHAR2:=FND_API.G_FALSE,
15:
16:
17: p_doc_type IN VARCHAR2,
10: PROCEDURE copy_cdrl_for_exhibit
11: (
12: p_api_version IN NUMBER,
13: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
14: p_commit IN VARCHAR2:=FND_API.G_FALSE,
15:
16:
17: p_doc_type IN VARCHAR2,
18: p_doc_id IN NUMBER,
33:
34: PROCEDURE delete_cdrl_for_exhibits
35: (
36: p_api_version IN NUMBER,
37: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
38: p_commit IN VARCHAR2:=FND_API.G_FALSE,
39:
40: p_doc_type IN VARCHAR2,
41: p_doc_id IN NUMBER,
34: PROCEDURE delete_cdrl_for_exhibits
35: (
36: p_api_version IN NUMBER,
37: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
38: p_commit IN VARCHAR2:=FND_API.G_FALSE,
39:
40: p_doc_type IN VARCHAR2,
41: p_doc_id IN NUMBER,
42: p_doc_version IN NUMBER DEFAULT NULL,
52:
53: PROCEDURE create_exhibit_for_cdrl
54: (
55: p_api_version IN NUMBER,
56: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
57: p_commit IN VARCHAR2:=FND_API.G_FALSE,
58:
59: p_doc_class IN VARCHAR2 DEFAULT NULL,
60: p_doc_type IN VARCHAR2,
53: PROCEDURE create_exhibit_for_cdrl
54: (
55: p_api_version IN NUMBER,
56: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
57: p_commit IN VARCHAR2:=FND_API.G_FALSE,
58:
59: p_doc_class IN VARCHAR2 DEFAULT NULL,
60: p_doc_type IN VARCHAR2,
61: p_doc_id IN NUMBER,
76: PROCEDURE
77: delete_exhibit_for_cdrl
78: (
79: p_api_version IN NUMBER,
80: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
81: p_commit IN VARCHAR2:=FND_API.G_FALSE,
82:
83: p_doc_class IN VARCHAR2 DEFAULT NULL,
84:
77: delete_exhibit_for_cdrl
78: (
79: p_api_version IN NUMBER,
80: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
81: p_commit IN VARCHAR2:=FND_API.G_FALSE,
82:
83: p_doc_class IN VARCHAR2 DEFAULT NULL,
84:
85: p_doc_type IN VARCHAR2,
99:
100: PROCEDURE ins_exb_and_get_dataItemNum (
101:
102: p_api_version IN NUMBER,
103: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
104: p_commit IN VARCHAR2:=FND_API.G_FALSE,
105:
106: p_doc_class IN VARCHAR2,
107:
100: PROCEDURE ins_exb_and_get_dataItemNum (
101:
102: p_api_version IN NUMBER,
103: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
104: p_commit IN VARCHAR2:=FND_API.G_FALSE,
105:
106: p_doc_class IN VARCHAR2,
107:
108: p_doc_type IN VARCHAR2,
138:
139: /*PROCEDURE copy_exhibits (
140:
141: p_api_version IN NUMBER,
142: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
143: p_commit IN VARCHAR2:=FND_API.G_FALSE,
144:
145: p_doc_class IN VARCHAR2,
146: p_doc_type IN VARCHAR2,
139: /*PROCEDURE copy_exhibits (
140:
141: p_api_version IN NUMBER,
142: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
143: p_commit IN VARCHAR2:=FND_API.G_FALSE,
144:
145: p_doc_class IN VARCHAR2,
146: p_doc_type IN VARCHAR2,
147: p_doc_id IN NUMBER,
165: PROCEDURE specify_exhibits_for_cdrls
166: (
167:
168: p_api_version IN NUMBER,
169: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
170: p_commit IN VARCHAR2:=FND_API.G_FALSE,
171:
172:
173: p_cdrl_tbl IN deliverable_tbl_type,
166: (
167:
168: p_api_version IN NUMBER,
169: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
170: p_commit IN VARCHAR2:=FND_API.G_FALSE,
171:
172:
173: p_cdrl_tbl IN deliverable_tbl_type,
174: p_exhibit_code IN VARCHAR2,
189:
190: PROCEDURE delete_doc_exhibits (
191:
192: p_api_version IN NUMBER,
193: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
194: p_commit IN VARCHAR2:=FND_API.G_FALSE,
195:
196: p_doc_class IN VARCHAR2 DEFAULT NULL,
197:
190: PROCEDURE delete_doc_exhibits (
191:
192: p_api_version IN NUMBER,
193: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
194: p_commit IN VARCHAR2:=FND_API.G_FALSE,
195:
196: p_doc_class IN VARCHAR2 DEFAULT NULL,
197:
198: p_doc_type IN VARCHAR2,
217: ) RETURN VARCHAR2;
218:
219: PROCEDURE RETAIN_CDRLS_FOR_EXHIBITS (
220: p_api_version IN NUMBER,
221: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
222: p_commit IN VARCHAR2:=FND_API.G_FALSE,
223:
224: p_doc_type IN VARCHAR2,
225: p_doc_id IN NUMBER,
218:
219: PROCEDURE RETAIN_CDRLS_FOR_EXHIBITS (
220: p_api_version IN NUMBER,
221: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
222: p_commit IN VARCHAR2:=FND_API.G_FALSE,
223:
224: p_doc_type IN VARCHAR2,
225: p_doc_id IN NUMBER,
226: p_doc_version IN NUMBER DEFAULT NULL,