DBA Data[Home] [Help]

APPS.OZF_SALES_TRANSACTIONS_PVT dependencies on OZF_RESALE_COMMON_PVT

Line 1117: ,p_line_int_rec IN OZF_RESALE_COMMON_PVT.g_interface_rec_csr%rowtype

1113: PROCEDURE Validate_Inventory_Level (
1114: p_api_version IN NUMBER
1115: ,p_init_msg_list IN VARCHAR2
1116: ,p_validation_level IN NUMBER
1117: ,p_line_int_rec IN OZF_RESALE_COMMON_PVT.g_interface_rec_csr%rowtype
1118: ,x_valid OUT NOCOPY BOOLEAN
1119: ,x_return_status OUT NOCOPY VARCHAR2
1120: ,x_msg_count OUT NOCOPY NUMBER
1121: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1427: l_transaction_id_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;

1423: l_return_status VARCHAR2(30);
1424: l_msg_data VARCHAR2(2000);
1425: l_msg_count NUMBER;
1426:
1427: l_transaction_id_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
1428: l_transaction_date_tbl OZF_RESALE_COMMON_PVT.date_tbl_type;
1429: l_unit_price_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
1430: l_currency_code_tbl OZF_RESALE_COMMON_PVT.varchar_tbl_type;
1431: l_available_quan_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;

Line 1428: l_transaction_date_tbl OZF_RESALE_COMMON_PVT.date_tbl_type;

1424: l_msg_data VARCHAR2(2000);
1425: l_msg_count NUMBER;
1426:
1427: l_transaction_id_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
1428: l_transaction_date_tbl OZF_RESALE_COMMON_PVT.date_tbl_type;
1429: l_unit_price_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
1430: l_currency_code_tbl OZF_RESALE_COMMON_PVT.varchar_tbl_type;
1431: l_available_quan_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
1432: l_primary_uom_tbl OZF_RESALE_COMMON_PVT.varchar_tbl_type;

Line 1429: l_unit_price_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;

1425: l_msg_count NUMBER;
1426:
1427: l_transaction_id_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
1428: l_transaction_date_tbl OZF_RESALE_COMMON_PVT.date_tbl_type;
1429: l_unit_price_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
1430: l_currency_code_tbl OZF_RESALE_COMMON_PVT.varchar_tbl_type;
1431: l_available_quan_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
1432: l_primary_uom_tbl OZF_RESALE_COMMON_PVT.varchar_tbl_type;
1433:

Line 1430: l_currency_code_tbl OZF_RESALE_COMMON_PVT.varchar_tbl_type;

1426:
1427: l_transaction_id_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
1428: l_transaction_date_tbl OZF_RESALE_COMMON_PVT.date_tbl_type;
1429: l_unit_price_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
1430: l_currency_code_tbl OZF_RESALE_COMMON_PVT.varchar_tbl_type;
1431: l_available_quan_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
1432: l_primary_uom_tbl OZF_RESALE_COMMON_PVT.varchar_tbl_type;
1433:
1434: l_asking_quantity NUMBER;

Line 1431: l_available_quan_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;

1427: l_transaction_id_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
1428: l_transaction_date_tbl OZF_RESALE_COMMON_PVT.date_tbl_type;
1429: l_unit_price_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
1430: l_currency_code_tbl OZF_RESALE_COMMON_PVT.varchar_tbl_type;
1431: l_available_quan_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
1432: l_primary_uom_tbl OZF_RESALE_COMMON_PVT.varchar_tbl_type;
1433:
1434: l_asking_quantity NUMBER;
1435:

Line 1432: l_primary_uom_tbl OZF_RESALE_COMMON_PVT.varchar_tbl_type;

1428: l_transaction_date_tbl OZF_RESALE_COMMON_PVT.date_tbl_type;
1429: l_unit_price_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
1430: l_currency_code_tbl OZF_RESALE_COMMON_PVT.varchar_tbl_type;
1431: l_available_quan_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
1432: l_primary_uom_tbl OZF_RESALE_COMMON_PVT.varchar_tbl_type;
1433:
1434: l_asking_quantity NUMBER;
1435:
1436: l_trans_id_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;

Line 1436: l_trans_id_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;

1432: l_primary_uom_tbl OZF_RESALE_COMMON_PVT.varchar_tbl_type;
1433:
1434: l_asking_quantity NUMBER;
1435:
1436: l_trans_id_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
1437: l_used_quantity_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
1438: l_used_unit_price_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
1439: l_rate NUMBER;
1440: l_default_exchange_type VARCHAR2(30);

Line 1437: l_used_quantity_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;

1433:
1434: l_asking_quantity NUMBER;
1435:
1436: l_trans_id_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
1437: l_used_quantity_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
1438: l_used_unit_price_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
1439: l_rate NUMBER;
1440: l_default_exchange_type VARCHAR2(30);
1441:

Line 1438: l_used_unit_price_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;

1434: l_asking_quantity NUMBER;
1435:
1436: l_trans_id_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
1437: l_used_quantity_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
1438: l_used_unit_price_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
1439: l_rate NUMBER;
1440: l_default_exchange_type VARCHAR2(30);
1441:
1442: l_numerator NUMBER := 0; -- [BUG 4212965 Fixing]

Line 1522: OPEN OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;

1518: null, null);
1519: END IF;
1520:
1521: -- Get default exchange type
1522: OPEN OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
1523: FETCH OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr INTO l_default_exchange_type;
1524: CLOSE OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
1525:
1526: FOR i in 1..l_transaction_id_tbl.LAST

Line 1523: FETCH OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr INTO l_default_exchange_type;

1519: END IF;
1520:
1521: -- Get default exchange type
1522: OPEN OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
1523: FETCH OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr INTO l_default_exchange_type;
1524: CLOSE OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
1525:
1526: FOR i in 1..l_transaction_id_tbl.LAST
1527: LOOP

Line 1524: CLOSE OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;

1520:
1521: -- Get default exchange type
1522: OPEN OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
1523: FETCH OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr INTO l_default_exchange_type;
1524: CLOSE OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
1525:
1526: FOR i in 1..l_transaction_id_tbl.LAST
1527: LOOP
1528: IF l_asking_quantity = 0 THEN