59: on the search criteria given.
60: Notes :
61: --------------------------------------------------------------------------*/
62: PROCEDURE search_result (
63: p_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
64: p_pr_date_to IN DATE := FND_API.G_MISS_DATE,
65: p_pr_date_from IN DATE := FND_API.G_MISS_DATE,
66: p_calc_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
67: p_adj_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
60: Notes :
61: --------------------------------------------------------------------------*/
62: PROCEDURE search_result (
63: p_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
64: p_pr_date_to IN DATE := FND_API.G_MISS_DATE,
65: p_pr_date_from IN DATE := FND_API.G_MISS_DATE,
66: p_calc_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
67: p_adj_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
68: p_load_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
61: --------------------------------------------------------------------------*/
62: PROCEDURE search_result (
63: p_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
64: p_pr_date_to IN DATE := FND_API.G_MISS_DATE,
65: p_pr_date_from IN DATE := FND_API.G_MISS_DATE,
66: p_calc_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
67: p_adj_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
68: p_load_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
69: p_invoice_num IN VARCHAR2:= FND_API.G_MISS_CHAR,
62: PROCEDURE search_result (
63: p_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
64: p_pr_date_to IN DATE := FND_API.G_MISS_DATE,
65: p_pr_date_from IN DATE := FND_API.G_MISS_DATE,
66: p_calc_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
67: p_adj_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
68: p_load_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
69: p_invoice_num IN VARCHAR2:= FND_API.G_MISS_CHAR,
70: p_order_num IN NUMBER := FND_API.G_MISS_NUM,
63: p_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
64: p_pr_date_to IN DATE := FND_API.G_MISS_DATE,
65: p_pr_date_from IN DATE := FND_API.G_MISS_DATE,
66: p_calc_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
67: p_adj_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
68: p_load_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
69: p_invoice_num IN VARCHAR2:= FND_API.G_MISS_CHAR,
70: p_order_num IN NUMBER := FND_API.G_MISS_NUM,
71: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
64: p_pr_date_to IN DATE := FND_API.G_MISS_DATE,
65: p_pr_date_from IN DATE := FND_API.G_MISS_DATE,
66: p_calc_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
67: p_adj_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
68: p_load_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
69: p_invoice_num IN VARCHAR2:= FND_API.G_MISS_CHAR,
70: p_order_num IN NUMBER := FND_API.G_MISS_NUM,
71: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
72: p_srch_attr_rec IN cn_get_tx_data_pub.adj_rec_type,
65: p_pr_date_from IN DATE := FND_API.G_MISS_DATE,
66: p_calc_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
67: p_adj_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
68: p_load_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
69: p_invoice_num IN VARCHAR2:= FND_API.G_MISS_CHAR,
70: p_order_num IN NUMBER := FND_API.G_MISS_NUM,
71: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
72: p_srch_attr_rec IN cn_get_tx_data_pub.adj_rec_type,
73: x_return_status OUT NOCOPY VARCHAR2,
66: p_calc_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
67: p_adj_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
68: p_load_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
69: p_invoice_num IN VARCHAR2:= FND_API.G_MISS_CHAR,
70: p_order_num IN NUMBER := FND_API.G_MISS_NUM,
71: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
72: p_srch_attr_rec IN cn_get_tx_data_pub.adj_rec_type,
73: x_return_status OUT NOCOPY VARCHAR2,
74: x_adj_tbl OUT NOCOPY cn_get_tx_data_pub.adj_tbl_type,
67: p_adj_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
68: p_load_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
69: p_invoice_num IN VARCHAR2:= FND_API.G_MISS_CHAR,
70: p_order_num IN NUMBER := FND_API.G_MISS_NUM,
71: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
72: p_srch_attr_rec IN cn_get_tx_data_pub.adj_rec_type,
73: x_return_status OUT NOCOPY VARCHAR2,
74: x_adj_tbl OUT NOCOPY cn_get_tx_data_pub.adj_tbl_type,
75: x_source_counter OUT NOCOPY NUMBER);