[Home] [Help]
20: RETURN '';
21: END;
22: -------------------------------------------------------------
23:
24: PROCEDURE list_to_csv_varchar(x_array IN pos_tbl_number,
25: x_result1 OUT NOCOPY VARCHAR2,
26: x_result2 OUT NOCOPY VARCHAR2,
27: x_result3 OUT NOCOPY VARCHAR2) IS
28: -- For longcomments enhancement, Bug 2234299
62: END list_to_csv_varchar;
63: ---------------------------------------------
64:
65: PROCEDURE parse_list(x_result IN VARCHAR2,
66: x_array IN OUT NOCOPY pos_tbl_number) IS
67: -- For longcomments enhancement, Bug 2234299
68: -- changed 'value' type from qa_results.character1%TYPE to varchar2(2000)
69: -- rponnusa Thu Mar 14 21:27:04 PST 2002
70: l_value VARCHAR2(2000);
108: ----------------------------------------
109: -- Main Procedure which is being called from the Generate Report AM Method
110: PROCEDURE generate_report_event( p_api_version IN INTEGER,
111: p_init_msg_list IN VARCHAR2,
112: p_party_id IN pos_tbl_number,
113: x_report_id OUT NOCOPY NUMBER,
114: x_actions_request_id OUT NOCOPY NUMBER,
115: x_return_status OUT NOCOPY VARCHAR2,
116: x_msg_count OUT NOCOPY NUMBER,
147: x_return_status VARCHAR2(100);
148: x_msg_data VARCHAR2(100);
149: x_msg_count NUMBER;
150: l_report_id NUMBER := NULL;
151: p_party_id pos_tbl_number := pos_tbl_number();
152:
153: BEGIN
154:
155: p_party_id.extend(1);
194: RETURN - 1;
195: END;
196: ------------------------------------------------
197: -- Procedure to get the XML content for each party Id and insert in the table
198: PROCEDURE get_bo_and_insert(p_party_id IN pos_tbl_number,
199: p_report_id IN NUMBER ) IS
200: l_user_id NUMBER := fnd_global.user_id;
201: l_last_update_login NUMBER := fnd_global.login_id;
202: l_pos_supplier_bo pos_supplier_bo;