51: and also removed all the JL_BR package references */
52:
53: PROCEDURE get_trx_reason_code
54: ( p_fsp_inv_org_id IN NUMBER
55: , p_inventory_org_id_tbl IN po_tbl_number
56: , p_item_id_tbl IN po_tbl_number
57: , p_org_id IN NUMBER
58: , x_return_status OUT NOCOPY VARCHAR2
59: , x_trx_reason_code_tbl OUT NOCOPY po_tbl_varchar100
52:
53: PROCEDURE get_trx_reason_code
54: ( p_fsp_inv_org_id IN NUMBER
55: , p_inventory_org_id_tbl IN po_tbl_number
56: , p_item_id_tbl IN po_tbl_number
57: , p_org_id IN NUMBER
58: , x_return_status OUT NOCOPY VARCHAR2
59: , x_trx_reason_code_tbl OUT NOCOPY po_tbl_varchar100
60: , x_error_code_tbl OUT NOCOPY po_tbl_number
56: , p_item_id_tbl IN po_tbl_number
57: , p_org_id IN NUMBER
58: , x_return_status OUT NOCOPY VARCHAR2
59: , x_trx_reason_code_tbl OUT NOCOPY po_tbl_varchar100
60: , x_error_code_tbl OUT NOCOPY po_tbl_number
61: )
62: IS
63:
64: l_api_name CONSTANT VARCHAR2(30) := 'get_trx_reason_code';
135:
136: /*Bug#4430300 Replaced the references to JLBR data types with the po standard data types */
137:
138: l_trx_reason_code_tbl po_tbl_varchar100 ;
139: l_error_code_tbl po_tbl_number;
140:
141: BEGIN
142: l_progress := '000';
143: