39: , p_reference_source IN NUMBER DEFAULT NULL
40: , p_reference_type IN NUMBER DEFAULT NULL
41: )
42: RETURN VARCHAR2 IS
43: l_x_trohdr_rec inv_move_order_pub.trohdr_rec_type;
44: l_x_trolin_tbl inv_move_order_pub.trolin_tbl_type;
45: l_trohdr_rec inv_move_order_pub.trohdr_rec_type;
46: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
47: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
40: , p_reference_type IN NUMBER DEFAULT NULL
41: )
42: RETURN VARCHAR2 IS
43: l_x_trohdr_rec inv_move_order_pub.trohdr_rec_type;
44: l_x_trolin_tbl inv_move_order_pub.trolin_tbl_type;
45: l_trohdr_rec inv_move_order_pub.trohdr_rec_type;
46: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
47: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
48: l_msg_count NUMBER;
41: )
42: RETURN VARCHAR2 IS
43: l_x_trohdr_rec inv_move_order_pub.trohdr_rec_type;
44: l_x_trolin_tbl inv_move_order_pub.trolin_tbl_type;
45: l_trohdr_rec inv_move_order_pub.trohdr_rec_type;
46: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
47: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
48: l_msg_count NUMBER;
49: l_msg_data VARCHAR2(240);
42: RETURN VARCHAR2 IS
43: l_x_trohdr_rec inv_move_order_pub.trohdr_rec_type;
44: l_x_trolin_tbl inv_move_order_pub.trolin_tbl_type;
45: l_trohdr_rec inv_move_order_pub.trohdr_rec_type;
46: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
47: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
48: l_msg_count NUMBER;
49: l_msg_data VARCHAR2(240);
50: msg VARCHAR2(2000);