120: Notes :
121: --------------------------------------------------------------------------*/
122: PROCEDURE update_invoice_changes(
123: p_api_version IN NUMBER,
124: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
125: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
126: p_existing_data IN invoice_tbl,
127: p_new_data IN invoice_tbl,
128: p_exist_data_check IN VARCHAR2 DEFAULT NULL,
121: --------------------------------------------------------------------------*/
122: PROCEDURE update_invoice_changes(
123: p_api_version IN NUMBER,
124: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
125: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
126: p_existing_data IN invoice_tbl,
127: p_new_data IN invoice_tbl,
128: p_exist_data_check IN VARCHAR2 DEFAULT NULL,
129: p_new_data_check IN VARCHAR2 DEFAULT NULL,
150: Notes :
151: --------------------------------------------------------------------------*/
152: PROCEDURE update_credit_memo(
153: p_api_version IN NUMBER,
154: p_init_msg_list IN VARCHAR2:= FND_API.G_TRUE,
155: p_validation_level IN VARCHAR2:= FND_API.G_VALID_LEVEL_FULL,
156: p_existing_data IN invoice_tbl,
157: p_new_data IN invoice_tbl,
158: p_to_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
151: --------------------------------------------------------------------------*/
152: PROCEDURE update_credit_memo(
153: p_api_version IN NUMBER,
154: p_init_msg_list IN VARCHAR2:= FND_API.G_TRUE,
155: p_validation_level IN VARCHAR2:= FND_API.G_VALID_LEVEL_FULL,
156: p_existing_data IN invoice_tbl,
157: p_new_data IN invoice_tbl,
158: p_to_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
159: p_to_salesrep_number IN VARCHAR2:= FND_API.G_MISS_CHAR,
154: p_init_msg_list IN VARCHAR2:= FND_API.G_TRUE,
155: p_validation_level IN VARCHAR2:= FND_API.G_VALID_LEVEL_FULL,
156: p_existing_data IN invoice_tbl,
157: p_new_data IN invoice_tbl,
158: p_to_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
159: p_to_salesrep_number IN VARCHAR2:= FND_API.G_MISS_CHAR,
160: p_called_from IN VARCHAR2,
161: p_adjust_status IN VARCHAR2,
162: x_return_status OUT NOCOPY VARCHAR2,
155: p_validation_level IN VARCHAR2:= FND_API.G_VALID_LEVEL_FULL,
156: p_existing_data IN invoice_tbl,
157: p_new_data IN invoice_tbl,
158: p_to_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
159: p_to_salesrep_number IN VARCHAR2:= FND_API.G_MISS_CHAR,
160: p_called_from IN VARCHAR2,
161: p_adjust_status IN VARCHAR2,
162: x_return_status OUT NOCOPY VARCHAR2,
163: x_msg_count OUT NOCOPY NUMBER,
183: Notes :
184: --------------------------------------------------------------------------*/
185: PROCEDURE update_mass_invoices (
186: p_api_version IN NUMBER,
187: p_init_msg_list IN VARCHAR2:= FND_API.G_TRUE,
188: p_validation_level IN VARCHAR2:= FND_API.G_VALID_LEVEL_FULL,
189: p_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
190: p_pr_date_to IN DATE := FND_API.G_MISS_DATE,
191: p_pr_date_from IN DATE := FND_API.G_MISS_DATE,
184: --------------------------------------------------------------------------*/
185: PROCEDURE update_mass_invoices (
186: p_api_version IN NUMBER,
187: p_init_msg_list IN VARCHAR2:= FND_API.G_TRUE,
188: p_validation_level IN VARCHAR2:= FND_API.G_VALID_LEVEL_FULL,
189: p_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
190: p_pr_date_to IN DATE := FND_API.G_MISS_DATE,
191: p_pr_date_from IN DATE := FND_API.G_MISS_DATE,
192: p_calc_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
185: PROCEDURE update_mass_invoices (
186: p_api_version IN NUMBER,
187: p_init_msg_list IN VARCHAR2:= FND_API.G_TRUE,
188: p_validation_level IN VARCHAR2:= FND_API.G_VALID_LEVEL_FULL,
189: p_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
190: p_pr_date_to IN DATE := FND_API.G_MISS_DATE,
191: p_pr_date_from IN DATE := FND_API.G_MISS_DATE,
192: p_calc_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
193: p_invoice_num IN VARCHAR2:= FND_API.G_MISS_CHAR,
186: p_api_version IN NUMBER,
187: p_init_msg_list IN VARCHAR2:= FND_API.G_TRUE,
188: p_validation_level IN VARCHAR2:= FND_API.G_VALID_LEVEL_FULL,
189: p_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
190: p_pr_date_to IN DATE := FND_API.G_MISS_DATE,
191: p_pr_date_from IN DATE := FND_API.G_MISS_DATE,
192: p_calc_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
193: p_invoice_num IN VARCHAR2:= FND_API.G_MISS_CHAR,
194: p_order_num IN NUMBER := FND_API.G_MISS_NUM,
187: p_init_msg_list IN VARCHAR2:= FND_API.G_TRUE,
188: p_validation_level IN VARCHAR2:= FND_API.G_VALID_LEVEL_FULL,
189: p_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
190: p_pr_date_to IN DATE := FND_API.G_MISS_DATE,
191: p_pr_date_from IN DATE := FND_API.G_MISS_DATE,
192: p_calc_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
193: p_invoice_num IN VARCHAR2:= FND_API.G_MISS_CHAR,
194: p_order_num IN NUMBER := FND_API.G_MISS_NUM,
195: p_srch_attr_rec IN cn_get_tx_data_pub.adj_rec_type,
188: p_validation_level IN VARCHAR2:= FND_API.G_VALID_LEVEL_FULL,
189: p_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
190: p_pr_date_to IN DATE := FND_API.G_MISS_DATE,
191: p_pr_date_from IN DATE := FND_API.G_MISS_DATE,
192: p_calc_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
193: p_invoice_num IN VARCHAR2:= FND_API.G_MISS_CHAR,
194: p_order_num IN NUMBER := FND_API.G_MISS_NUM,
195: p_srch_attr_rec IN cn_get_tx_data_pub.adj_rec_type,
196: p_to_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
189: p_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
190: p_pr_date_to IN DATE := FND_API.G_MISS_DATE,
191: p_pr_date_from IN DATE := FND_API.G_MISS_DATE,
192: p_calc_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
193: p_invoice_num IN VARCHAR2:= FND_API.G_MISS_CHAR,
194: p_order_num IN NUMBER := FND_API.G_MISS_NUM,
195: p_srch_attr_rec IN cn_get_tx_data_pub.adj_rec_type,
196: p_to_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
197: p_to_salesrep_number IN VARCHAR2:= FND_API.G_MISS_CHAR,
190: p_pr_date_to IN DATE := FND_API.G_MISS_DATE,
191: p_pr_date_from IN DATE := FND_API.G_MISS_DATE,
192: p_calc_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
193: p_invoice_num IN VARCHAR2:= FND_API.G_MISS_CHAR,
194: p_order_num IN NUMBER := FND_API.G_MISS_NUM,
195: p_srch_attr_rec IN cn_get_tx_data_pub.adj_rec_type,
196: p_to_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
197: p_to_salesrep_number IN VARCHAR2:= FND_API.G_MISS_CHAR,
198: x_return_status OUT NOCOPY VARCHAR2,
192: p_calc_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
193: p_invoice_num IN VARCHAR2:= FND_API.G_MISS_CHAR,
194: p_order_num IN NUMBER := FND_API.G_MISS_NUM,
195: p_srch_attr_rec IN cn_get_tx_data_pub.adj_rec_type,
196: p_to_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
197: p_to_salesrep_number IN VARCHAR2:= FND_API.G_MISS_CHAR,
198: x_return_status OUT NOCOPY VARCHAR2,
199: x_msg_count OUT NOCOPY NUMBER,
200: x_msg_data OUT NOCOPY VARCHAR2,
193: p_invoice_num IN VARCHAR2:= FND_API.G_MISS_CHAR,
194: p_order_num IN NUMBER := FND_API.G_MISS_NUM,
195: p_srch_attr_rec IN cn_get_tx_data_pub.adj_rec_type,
196: p_to_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
197: p_to_salesrep_number IN VARCHAR2:= FND_API.G_MISS_CHAR,
198: x_return_status OUT NOCOPY VARCHAR2,
199: x_msg_count OUT NOCOPY NUMBER,
200: x_msg_data OUT NOCOPY VARCHAR2,
201: x_loading_status OUT NOCOPY VARCHAR2,
218: Notes :
219: --------------------------------------------------------------------------*/
220: PROCEDURE capture_deal_invoice(
221: p_api_version IN NUMBER,
222: p_init_msg_list IN VARCHAR2:= FND_API.G_TRUE,
223: p_validation_level IN VARCHAR2:= FND_API.G_VALID_LEVEL_FULL,
224: p_trx_type IN VARCHAR2,
225: p_split_nonrevenue_line IN VARCHAR2, p_invoice_number IN VARCHAR2,
226: p_org_id IN NUMBER,
219: --------------------------------------------------------------------------*/
220: PROCEDURE capture_deal_invoice(
221: p_api_version IN NUMBER,
222: p_init_msg_list IN VARCHAR2:= FND_API.G_TRUE,
223: p_validation_level IN VARCHAR2:= FND_API.G_VALID_LEVEL_FULL,
224: p_trx_type IN VARCHAR2,
225: p_split_nonrevenue_line IN VARCHAR2, p_invoice_number IN VARCHAR2,
226: p_org_id IN NUMBER,
227: p_split_data_tbl IN cn_get_tx_data_pub.split_data_tbl,