60: );
61:
62: PROCEDURE validate_cross_ou_tbl --
63: (
64: p_req_line_id_tbl IN PO_TBL_NUMBER
65: , p_requesting_org_id_tbl IN PO_TBL_NUMBER
66: , p_purchasing_org_id IN NUMBER
67: , p_document_type IN VARCHAR2
68: , p_item_id_tbl IN PO_TBL_NUMBER
61:
62: PROCEDURE validate_cross_ou_tbl --
63: (
64: p_req_line_id_tbl IN PO_TBL_NUMBER
65: , p_requesting_org_id_tbl IN PO_TBL_NUMBER
66: , p_purchasing_org_id IN NUMBER
67: , p_document_type IN VARCHAR2
68: , p_item_id_tbl IN PO_TBL_NUMBER
69: , p_source_doc_id_tbl IN PO_TBL_NUMBER
64: p_req_line_id_tbl IN PO_TBL_NUMBER
65: , p_requesting_org_id_tbl IN PO_TBL_NUMBER
66: , p_purchasing_org_id IN NUMBER
67: , p_document_type IN VARCHAR2
68: , p_item_id_tbl IN PO_TBL_NUMBER
69: , p_source_doc_id_tbl IN PO_TBL_NUMBER
70: , p_vmi_flag_tbl IN PO_TBL_VARCHAR1
71: , p_consigned_flag_tbl IN PO_TBL_VARCHAR1
72: , x_valid_flag_tbl OUT NOCOPY PO_TBL_VARCHAR1
65: , p_requesting_org_id_tbl IN PO_TBL_NUMBER
66: , p_purchasing_org_id IN NUMBER
67: , p_document_type IN VARCHAR2
68: , p_item_id_tbl IN PO_TBL_NUMBER
69: , p_source_doc_id_tbl IN PO_TBL_NUMBER
70: , p_vmi_flag_tbl IN PO_TBL_VARCHAR1
71: , p_consigned_flag_tbl IN PO_TBL_VARCHAR1
72: , x_valid_flag_tbl OUT NOCOPY PO_TBL_VARCHAR1
73: , x_error_msg_tbl OUT NOCOPY PO_TBL_VARCHAR30