[Home] [Help]
46: -- FND_API.g_ret_sts_unexp_error - unexpected error occurred
47: --x_transaction_flow_header_id
48: -- The unique header ID of the transaction flow, if any valid inter-company
49: -- relationship exists. If not flow was found, then this is NULL.
50: -- (MTL_TRANSACTION_FLOW_HEADERS.header_id%TYPE)
51: --End of Comments
52: --------------------------------------------------------------------------------
53: PROCEDURE check_transaction_flow
54: (
62: x_transaction_flow_header_id OUT NOCOPY NUMBER
63: )
64: IS
65:
66: l_end_ou_id MTL_TRANSACTION_FLOW_HEADERS.end_org_id%TYPE := p_end_ou_id;
67:
68: l_qual_code_tbl INV_TRANSACTION_FLOW_PUB.number_tbl;
69: l_qual_val_tbl INV_TRANSACTION_FLOW_PUB.number_tbl;
70:
67:
68: l_qual_code_tbl INV_TRANSACTION_FLOW_PUB.number_tbl;
69: l_qual_val_tbl INV_TRANSACTION_FLOW_PUB.number_tbl;
70:
71: l_new_accounting_flag MTL_TRANSACTION_FLOW_HEADERS.new_accounting_flag%TYPE;
72: l_txn_flow_exists VARCHAR2(1);
73:
74: l_progress VARCHAR2(3);
75: l_return_status VARCHAR2(1);
551:
552: l_pa_project BOOLEAN := FALSE;
553: l_transaction_flow_status VARCHAR2(1);
554: l_dest_inv_org_ou_id PO_SYSTEM_PARAMETERS_ALL.org_id%TYPE;
555: l_transaction_flow_header_id MTL_TRANSACTION_FLOW_HEADERS.header_id%TYPE;
556: l_category_id PO_REQUISITION_LINES_ALL.category_id%TYPE;
557: l_api_name CONSTANT VARCHAR2 (30) := 'validate_cross_ou_purchasing';
558: l_api_version CONSTANT NUMBER := 1.0;
559: l_dest_inv_org_id PO_REQUISITION_LINES_ALL.destination_organization_id%TYPE;
1261: -- FALSE otherwise.
1262: --x_transaction_flow_header_id
1263: -- The unique header ID of the transaction flow, if any valid inter-company
1264: -- relationship exists. If no flow is found, then this is set to NULL.
1265: -- (MTL_TRANSACTION_FLOW_HEADERS.header_id%TYPE)
1266: --End of Comments
1267: --------------------------------------------------------------------------------
1268: PROCEDURE validate_ship_to_org
1269: (