[Home] [Help]
19: RETURN '';
20:
21: END;
22:
23: PROCEDURE list_to_csv_varchar(x_array IN pos_tbl_number,
24: x_result1 OUT NOCOPY VARCHAR2,
25: x_result2 OUT NOCOPY VARCHAR2,
26: x_result3 OUT NOCOPY VARCHAR2) IS
27:
80:
81: END list_to_csv_varchar;
82:
83: PROCEDURE parse_list(x_result IN VARCHAR2,
84: x_array IN OUT NOCOPY pos_tbl_number) IS
85:
86: -- For longcomments enhancement, Bug 2234299
87: -- changed 'value' type from qa_results.character1%TYPE to varchar2(2000)
88: -- rponnusa Thu Mar 14 21:27:04 PST 2002
150: */
151:
152: PROCEDURE create_supp_publish_event(p_api_version IN INTEGER,
153: p_init_msg_list IN VARCHAR2,
154: p_party_id IN pos_tbl_number,
155: p_published_by IN INTEGER,
156: p_publish_detail IN VARCHAR,
157: x_publication_event_id OUT NOCOPY NUMBER,
158: x_actions_request_id OUT NOCOPY NUMBER,
214:
215: -- This routine is used to re raise the already published events
216: PROCEDURE create_supp_publish_event_hist (p_api_version IN INTEGER,
217: p_init_msg_list IN VARCHAR2,
218: p_publication_event_id IN pos_tbl_number,
219: x_return_status OUT NOCOPY VARCHAR2,
220: x_msg_count OUT NOCOPY NUMBER,
221: x_msg_data OUT NOCOPY VARCHAR2) IS
222: l_event_key NUMBER := NULL;
427: x_msg_data VARCHAR2(100);
428: x_msg_count NUMBER;
429: l_publication_event_id NUMBER := NULL;
430: p_publication_event_id_out NUMBER := NULL;
431: p_party_id pos_tbl_number := pos_tbl_number();
432: l_event_key NUMBER := NULL;
433: BEGIN
434: SAVEPOINT populate_bo_and_save;
435:
499: WHEN OTHERS THEN
500: RETURN - 1;
501: END;
502:
503: PROCEDURE get_bo_and_insert(p_party_id IN pos_tbl_number,
504: p_publication_event_id IN NUMBER,
505: p_published_by IN NUMBER,
506: p_publish_detail IN VARCHAR)
507: