APPS.OZF_SALES_TRANSACTIONS_PVT dependencies on OZF_RESALE_COMMON_PVT

Line 1099: ,p_line_int_rec IN OZF_RESALE_COMMON_PVT.g_interface_rec_csr%rowtype

1095: PROCEDURE Validate_Inventory_Level (
1096: p_api_version IN NUMBER
1097: ,p_init_msg_list IN VARCHAR2
1098: ,p_validation_level IN NUMBER
1099: ,p_line_int_rec IN OZF_RESALE_COMMON_PVT.g_interface_rec_csr%rowtype
1100: ,x_valid OUT NOCOPY BOOLEAN
1101: ,x_return_status OUT NOCOPY VARCHAR2
1102: ,x_msg_count OUT NOCOPY NUMBER
1103: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1403: l_transaction_id_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;

1399: l_return_status VARCHAR2(30);
1400: l_msg_data VARCHAR2(2000);
1401: l_msg_count NUMBER;
1402:
1403: l_transaction_id_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
1404: l_transaction_date_tbl OZF_RESALE_COMMON_PVT.date_tbl_type;
1405: l_unit_price_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
1406: l_currency_code_tbl OZF_RESALE_COMMON_PVT.varchar_tbl_type;
1407: l_available_quan_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;

Line 1404: l_transaction_date_tbl OZF_RESALE_COMMON_PVT.date_tbl_type;

1400: l_msg_data VARCHAR2(2000);
1401: l_msg_count NUMBER;
1402:
1403: l_transaction_id_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
1404: l_transaction_date_tbl OZF_RESALE_COMMON_PVT.date_tbl_type;
1405: l_unit_price_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
1406: l_currency_code_tbl OZF_RESALE_COMMON_PVT.varchar_tbl_type;
1407: l_available_quan_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
1408: l_primary_uom_tbl OZF_RESALE_COMMON_PVT.varchar_tbl_type;

Line 1405: l_unit_price_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;

1401: l_msg_count NUMBER;
1402:
1403: l_transaction_id_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
1404: l_transaction_date_tbl OZF_RESALE_COMMON_PVT.date_tbl_type;
1405: l_unit_price_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
1406: l_currency_code_tbl OZF_RESALE_COMMON_PVT.varchar_tbl_type;
1407: l_available_quan_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
1408: l_primary_uom_tbl OZF_RESALE_COMMON_PVT.varchar_tbl_type;
1409:

Line 1406: l_currency_code_tbl OZF_RESALE_COMMON_PVT.varchar_tbl_type;

1402:
1403: l_transaction_id_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
1404: l_transaction_date_tbl OZF_RESALE_COMMON_PVT.date_tbl_type;
1405: l_unit_price_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
1406: l_currency_code_tbl OZF_RESALE_COMMON_PVT.varchar_tbl_type;
1407: l_available_quan_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
1408: l_primary_uom_tbl OZF_RESALE_COMMON_PVT.varchar_tbl_type;
1409:
1410: l_asking_quantity NUMBER;

Line 1407: l_available_quan_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;

1403: l_transaction_id_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
1404: l_transaction_date_tbl OZF_RESALE_COMMON_PVT.date_tbl_type;
1405: l_unit_price_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
1406: l_currency_code_tbl OZF_RESALE_COMMON_PVT.varchar_tbl_type;
1407: l_available_quan_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
1408: l_primary_uom_tbl OZF_RESALE_COMMON_PVT.varchar_tbl_type;
1409:
1410: l_asking_quantity NUMBER;
1411:

Line 1408: l_primary_uom_tbl OZF_RESALE_COMMON_PVT.varchar_tbl_type;

1404: l_transaction_date_tbl OZF_RESALE_COMMON_PVT.date_tbl_type;
1405: l_unit_price_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
1406: l_currency_code_tbl OZF_RESALE_COMMON_PVT.varchar_tbl_type;
1407: l_available_quan_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
1408: l_primary_uom_tbl OZF_RESALE_COMMON_PVT.varchar_tbl_type;
1409:
1410: l_asking_quantity NUMBER;
1411:
1412: l_trans_id_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;

Line 1412: l_trans_id_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;

1408: l_primary_uom_tbl OZF_RESALE_COMMON_PVT.varchar_tbl_type;
1409:
1410: l_asking_quantity NUMBER;
1411:
1412: l_trans_id_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
1413: l_used_quantity_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
1414: l_used_unit_price_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
1415: l_rate NUMBER;
1416: l_default_exchange_type VARCHAR2(30);

Line 1413: l_used_quantity_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;

1409:
1410: l_asking_quantity NUMBER;
1411:
1412: l_trans_id_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
1413: l_used_quantity_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
1414: l_used_unit_price_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
1415: l_rate NUMBER;
1416: l_default_exchange_type VARCHAR2(30);
1417:

Line 1414: l_used_unit_price_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;

1410: l_asking_quantity NUMBER;
1411:
1412: l_trans_id_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
1413: l_used_quantity_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
1414: l_used_unit_price_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
1415: l_rate NUMBER;
1416: l_default_exchange_type VARCHAR2(30);
1417:
1418: l_numerator NUMBER := 0; -- [BUG 4212965 Fixing]

Line 1498: OPEN OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;

1494: null, null);
1495: END IF;
1496:
1497: -- Get default exchange type
1498: OPEN OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
1499: FETCH OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr INTO l_default_exchange_type;
1500: CLOSE OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
1501:
1502: FOR i in 1..l_transaction_id_tbl.LAST

Line 1499: FETCH OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr INTO l_default_exchange_type;

1495: END IF;
1496:
1497: -- Get default exchange type
1498: OPEN OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
1499: FETCH OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr INTO l_default_exchange_type;
1500: CLOSE OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
1501:
1502: FOR i in 1..l_transaction_id_tbl.LAST
1503: LOOP

Line 1500: CLOSE OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;

1496:
1497: -- Get default exchange type
1498: OPEN OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
1499: FETCH OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr INTO l_default_exchange_type;
1500: CLOSE OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
1501:
1502: FOR i in 1..l_transaction_id_tbl.LAST
1503: LOOP
1504: IF l_asking_quantity = 0 THEN