eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_TP_ACCRUAL_PVT dependencies on OZF_RESALE_COMMON_PVT

Line 444: -- p_resale_line_int_rec IN OZF_RESALE_COMMON_PVT.g_interface_rec_csr%rowtype,

440: -- This procedure process the pricing call result for third party accrual.
441: -- It creates resale lines and accruals based on the discount information.
442: --
443: -- PARAMETERS
444: -- p_resale_line_int_rec IN OZF_RESALE_COMMON_PVT.g_interface_rec_csr%rowtype,
445: -- p_resale_line_rec IN OZF_RESALE_LINES_ALL%rowtype,
446: -- p_line_result_rec IN OZF_ORDER_PRICE_PVT.LINE_REC_TYPE,
447: -- p_header_id IN NUMBER,
448: -- p_resale_batch_id IN NUMBER,

Line 460: p_resale_line_int_rec IN OZF_RESALE_COMMON_PVT.g_interface_rec_csr%rowtype,

456: -- and ldets.benefit_uom for calculation.
457: --
458: ---------------------------------------------------------------------
459: PROCEDURE Process_One_Line(
460: p_resale_line_int_rec IN OZF_RESALE_COMMON_PVT.g_interface_rec_csr%rowtype,
461: p_resale_line_rec IN OZF_RESALE_LINES%rowtype,
462: p_line_result_rec IN OZF_ORDER_PRICE_PVT.LINE_REC_TYPE,
463: p_header_id IN NUMBER,
464: p_resale_batch_id IN NUMBER,

Line 537: AND b.batch_type = OZF_RESALE_COMMON_PVT.G_CHARGEBACK

533: WHERE a.resale_line_id = p_line_id
534: AND a.resale_batch_id = p_batch_id
535: AND a.line_agreement_flag = 'T'
536: AND a.resale_batch_id = b.resale_batch_id
537: AND b.batch_type = OZF_RESALE_COMMON_PVT.G_CHARGEBACK
538: AND rownum = 1;
539: */
540: l_log_id NUMBER;
541:

Line 589: OZF_RESALE_COMMON_PVT.Insert_resale_line(

585: END IF;
586:
587: -- create a resale line record, if it's FROM iface
588: IF p_caller_type = 'IFACE' THEN
589: OZF_RESALE_COMMON_PVT.Insert_resale_line(
590: p_api_version => 1
591: ,p_init_msg_list => FND_API.G_FALSE
592: ,p_commit => FND_API.G_FALSE
593: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 606: OZF_RESALE_COMMON_PVT.Insert_Resale_Line_Mapping(

602: ozf_utility_pvt.error_message('OZF_INS_RESALE_LINE_WRG');
603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
604: END IF;
605:
606: OZF_RESALE_COMMON_PVT.Insert_Resale_Line_Mapping(
607: p_api_version => 1
608: ,p_init_msg_list => FND_API.G_FALSE
609: ,p_commit => FND_API.G_FALSE
610: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 623: OZF_RESALE_COMMON_PVT.Create_Sales_Transaction(

619: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
621: END IF;
622:
623: OZF_RESALE_COMMON_PVT.Create_Sales_Transaction(
624: p_api_version => 1
625: ,p_init_msg_list => FND_API.G_FALSE
626: ,p_commit => FND_API.G_FALSE
627: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 823: OPEN OZF_RESALE_COMMON_PVT.g_adjustment_id_csr;

819: END IF;
820: END IF;
821: -- R12 Volumn Offer Enhancement (-)
822:
823: OPEN OZF_RESALE_COMMON_PVT.g_adjustment_id_csr;
824: FETCH OZF_RESALE_COMMON_PVT.g_adjustment_id_csr INTO l_adjustment_rec.resale_adjustment_id;
825: CLOSE OZF_RESALE_COMMON_PVT.g_adjustment_id_csr;
826:
827: l_adjustment_rec.resale_batch_id := p_resale_batch_id;

Line 824: FETCH OZF_RESALE_COMMON_PVT.g_adjustment_id_csr INTO l_adjustment_rec.resale_adjustment_id;

820: END IF;
821: -- R12 Volumn Offer Enhancement (-)
822:
823: OPEN OZF_RESALE_COMMON_PVT.g_adjustment_id_csr;
824: FETCH OZF_RESALE_COMMON_PVT.g_adjustment_id_csr INTO l_adjustment_rec.resale_adjustment_id;
825: CLOSE OZF_RESALE_COMMON_PVT.g_adjustment_id_csr;
826:
827: l_adjustment_rec.resale_batch_id := p_resale_batch_id;
828: l_adjustment_rec.resale_line_id := l_line_id;

Line 825: CLOSE OZF_RESALE_COMMON_PVT.g_adjustment_id_csr;

821: -- R12 Volumn Offer Enhancement (-)
822:
823: OPEN OZF_RESALE_COMMON_PVT.g_adjustment_id_csr;
824: FETCH OZF_RESALE_COMMON_PVT.g_adjustment_id_csr INTO l_adjustment_rec.resale_adjustment_id;
825: CLOSE OZF_RESALE_COMMON_PVT.g_adjustment_id_csr;
826:
827: l_adjustment_rec.resale_batch_id := p_resale_batch_id;
828: l_adjustment_rec.resale_line_id := l_line_id;
829: l_adjustment_rec.list_header_id := l_ldets_tbl(k).list_header_id;

Line 1004: OPEN OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;

1000: l_act_budgets_rec.request_amount := l_adjustment_rec.total_accepted_amount;
1001:
1002: IF p_line_result_rec.currency_code <> l_act_budgets_rec.request_currency THEN
1003: -- get convert type
1004: OPEN OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
1005: FETCH OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr INTO l_exchange_type;
1006: CLOSE OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
1007:
1008: OZF_UTILITY_PVT.convert_currency(

Line 1005: FETCH OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr INTO l_exchange_type;

1001:
1002: IF p_line_result_rec.currency_code <> l_act_budgets_rec.request_currency THEN
1003: -- get convert type
1004: OPEN OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
1005: FETCH OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr INTO l_exchange_type;
1006: CLOSE OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
1007:
1008: OZF_UTILITY_PVT.convert_currency(
1009: p_from_currency => p_line_result_rec.currency_code

Line 1006: CLOSE OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;

1002: IF p_line_result_rec.currency_code <> l_act_budgets_rec.request_currency THEN
1003: -- get convert type
1004: OPEN OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
1005: FETCH OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr INTO l_exchange_type;
1006: CLOSE OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
1007:
1008: OZF_UTILITY_PVT.convert_currency(
1009: p_from_currency => p_line_result_rec.currency_code
1010: ,p_to_currency => l_act_budgets_rec.request_currency

Line 1036: OPEN OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;

1032: IF l_ldets_tbl(k).list_line_type_code = 'PLL' THEN
1033: l_act_budgets_rec.parent_src_apprvd_amt := l_act_budgets_rec.request_amount;
1034: IF p_line_result_rec.currency_code <> l_act_budgets_rec.parent_src_curr THEN
1035: -- get convert type
1036: OPEN OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
1037: FETCH OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr INTO l_exchange_type;
1038: CLOSE OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
1039:
1040: OZF_UTILITY_PVT.convert_currency(

Line 1037: FETCH OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr INTO l_exchange_type;

1033: l_act_budgets_rec.parent_src_apprvd_amt := l_act_budgets_rec.request_amount;
1034: IF p_line_result_rec.currency_code <> l_act_budgets_rec.parent_src_curr THEN
1035: -- get convert type
1036: OPEN OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
1037: FETCH OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr INTO l_exchange_type;
1038: CLOSE OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
1039:
1040: OZF_UTILITY_PVT.convert_currency(
1041: p_FROM_currency => p_line_result_rec.currency_code

Line 1038: CLOSE OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;

1034: IF p_line_result_rec.currency_code <> l_act_budgets_rec.parent_src_curr THEN
1035: -- get convert type
1036: OPEN OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
1037: FETCH OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr INTO l_exchange_type;
1038: CLOSE OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
1039:
1040: OZF_UTILITY_PVT.convert_currency(
1041: p_FROM_currency => p_line_result_rec.currency_code
1042: ,p_to_currency => l_act_budgets_rec.parent_src_curr

Line 1089: OZF_RESALE_COMMON_PVT.Create_Adj_and_Utilization(

1085: OR
1086: (l_ldets_tbl(k).list_line_type_code = 'DIS' AND
1087: l_adjustment_rec.calculated_amount IS NOT NULL);
1088: */
1089: OZF_RESALE_COMMON_PVT.Create_Adj_and_Utilization(
1090: p_api_version => 1
1091: ,p_init_msg_list => FND_API.G_FALSE
1092: ,p_commit => FND_API.G_FALSE
1093: ,p_validation_level=> FND_API.G_VALID_LEVEL_FULL

Line 1273: l_resale_int_rec OZF_RESALE_COMMON_PVT.g_interface_rec_csr%rowtype;

1269: SELECT *
1270: FROM ozf_resale_lines
1271: WHERE resale_line_id = p_id;
1272:
1273: l_resale_int_rec OZF_RESALE_COMMON_PVT.g_interface_rec_csr%rowtype;
1274: l_resale_rec OZF_RESALE_LINES%rowtype;
1275:
1276: l_header_id NUMBER;
1277: l_line_id NUMBER;

Line 1430: OPEN OZF_RESALE_COMMON_PVT.g_log_id_csr;

1426: END IF;
1427:
1428: FOR i in 1..p_line_tbl.LAST LOOP
1429: BEGIN
1430: OPEN OZF_RESALE_COMMON_PVT.g_log_id_csr;
1431: FETCH OZF_RESALE_COMMON_PVT.g_log_id_csr INTO l_log_id;
1432: CLOSE OZF_RESALE_COMMON_PVT.g_log_id_csr;
1433:
1434: -- julou bug 6317120. get org_id from table

Line 1431: FETCH OZF_RESALE_COMMON_PVT.g_log_id_csr INTO l_log_id;

1427:
1428: FOR i in 1..p_line_tbl.LAST LOOP
1429: BEGIN
1430: OPEN OZF_RESALE_COMMON_PVT.g_log_id_csr;
1431: FETCH OZF_RESALE_COMMON_PVT.g_log_id_csr INTO l_log_id;
1432: CLOSE OZF_RESALE_COMMON_PVT.g_log_id_csr;
1433:
1434: -- julou bug 6317120. get org_id from table
1435: IF l_id_type = 'LINE' THEN

Line 1432: CLOSE OZF_RESALE_COMMON_PVT.g_log_id_csr;

1428: FOR i in 1..p_line_tbl.LAST LOOP
1429: BEGIN
1430: OPEN OZF_RESALE_COMMON_PVT.g_log_id_csr;
1431: FETCH OZF_RESALE_COMMON_PVT.g_log_id_csr INTO l_log_id;
1432: CLOSE OZF_RESALE_COMMON_PVT.g_log_id_csr;
1433:
1434: -- julou bug 6317120. get org_id from table
1435: IF l_id_type = 'LINE' THEN
1436: OPEN OZF_RESALE_COMMON_PVT.gc_line_org_id(p_line_tbl(i).chargeback_int_id);

Line 1436: OPEN OZF_RESALE_COMMON_PVT.gc_line_org_id(p_line_tbl(i).chargeback_int_id);

1432: CLOSE OZF_RESALE_COMMON_PVT.g_log_id_csr;
1433:
1434: -- julou bug 6317120. get org_id from table
1435: IF l_id_type = 'LINE' THEN
1436: OPEN OZF_RESALE_COMMON_PVT.gc_line_org_id(p_line_tbl(i).chargeback_int_id);
1437: FETCH OZF_RESALE_COMMON_PVT.gc_line_org_id INTO l_org_id;
1438: CLOSE OZF_RESALE_COMMON_PVT.gc_line_org_id;
1439: ELSIF l_id_type = 'IFACE' THEN
1440: OPEN OZF_RESALE_COMMON_PVT.gc_iface_org_id(p_line_tbl(i).chargeback_int_id);

Line 1437: FETCH OZF_RESALE_COMMON_PVT.gc_line_org_id INTO l_org_id;

1433:
1434: -- julou bug 6317120. get org_id from table
1435: IF l_id_type = 'LINE' THEN
1436: OPEN OZF_RESALE_COMMON_PVT.gc_line_org_id(p_line_tbl(i).chargeback_int_id);
1437: FETCH OZF_RESALE_COMMON_PVT.gc_line_org_id INTO l_org_id;
1438: CLOSE OZF_RESALE_COMMON_PVT.gc_line_org_id;
1439: ELSIF l_id_type = 'IFACE' THEN
1440: OPEN OZF_RESALE_COMMON_PVT.gc_iface_org_id(p_line_tbl(i).chargeback_int_id);
1441: FETCH OZF_RESALE_COMMON_PVT.gc_iface_org_id INTO l_org_id;

Line 1438: CLOSE OZF_RESALE_COMMON_PVT.gc_line_org_id;

1434: -- julou bug 6317120. get org_id from table
1435: IF l_id_type = 'LINE' THEN
1436: OPEN OZF_RESALE_COMMON_PVT.gc_line_org_id(p_line_tbl(i).chargeback_int_id);
1437: FETCH OZF_RESALE_COMMON_PVT.gc_line_org_id INTO l_org_id;
1438: CLOSE OZF_RESALE_COMMON_PVT.gc_line_org_id;
1439: ELSIF l_id_type = 'IFACE' THEN
1440: OPEN OZF_RESALE_COMMON_PVT.gc_iface_org_id(p_line_tbl(i).chargeback_int_id);
1441: FETCH OZF_RESALE_COMMON_PVT.gc_iface_org_id INTO l_org_id;
1442: CLOSE OZF_RESALE_COMMON_PVT.gc_iface_org_id;

Line 1440: OPEN OZF_RESALE_COMMON_PVT.gc_iface_org_id(p_line_tbl(i).chargeback_int_id);

1436: OPEN OZF_RESALE_COMMON_PVT.gc_line_org_id(p_line_tbl(i).chargeback_int_id);
1437: FETCH OZF_RESALE_COMMON_PVT.gc_line_org_id INTO l_org_id;
1438: CLOSE OZF_RESALE_COMMON_PVT.gc_line_org_id;
1439: ELSIF l_id_type = 'IFACE' THEN
1440: OPEN OZF_RESALE_COMMON_PVT.gc_iface_org_id(p_line_tbl(i).chargeback_int_id);
1441: FETCH OZF_RESALE_COMMON_PVT.gc_iface_org_id INTO l_org_id;
1442: CLOSE OZF_RESALE_COMMON_PVT.gc_iface_org_id;
1443: END IF;
1444:

Line 1441: FETCH OZF_RESALE_COMMON_PVT.gc_iface_org_id INTO l_org_id;

1437: FETCH OZF_RESALE_COMMON_PVT.gc_line_org_id INTO l_org_id;
1438: CLOSE OZF_RESALE_COMMON_PVT.gc_line_org_id;
1439: ELSIF l_id_type = 'IFACE' THEN
1440: OPEN OZF_RESALE_COMMON_PVT.gc_iface_org_id(p_line_tbl(i).chargeback_int_id);
1441: FETCH OZF_RESALE_COMMON_PVT.gc_iface_org_id INTO l_org_id;
1442: CLOSE OZF_RESALE_COMMON_PVT.gc_iface_org_id;
1443: END IF;
1444:
1445: OZF_RESALE_LOGS_PKG.Insert_Row(

Line 1442: CLOSE OZF_RESALE_COMMON_PVT.gc_iface_org_id;

1438: CLOSE OZF_RESALE_COMMON_PVT.gc_line_org_id;
1439: ELSIF l_id_type = 'IFACE' THEN
1440: OPEN OZF_RESALE_COMMON_PVT.gc_iface_org_id(p_line_tbl(i).chargeback_int_id);
1441: FETCH OZF_RESALE_COMMON_PVT.gc_iface_org_id INTO l_org_id;
1442: CLOSE OZF_RESALE_COMMON_PVT.gc_iface_org_id;
1443: END IF;
1444:
1445: OZF_RESALE_LOGS_PKG.Insert_Row(
1446: px_resale_log_id => l_log_id,

Line 1452: --px_org_id => OZF_RESALE_COMMON_PVT.g_org_id

1448: p_resale_id_type => l_id_type,
1449: p_error_code => p_line_tbl(i).pricing_status_code,
1450: p_error_message => p_line_tbl(i).pricing_status_text, p_column_name => NULL,
1451: p_column_value => NULL,
1452: --px_org_id => OZF_RESALE_COMMON_PVT.g_org_id
1453: px_org_id => l_org_id
1454: );
1455: EXCEPTION
1456: WHEN OTHERS THEN

Line 1483: OPEN OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr;

1479:
1480: l_create_order_header := l_dup_line_count IS NULL;
1481:
1482: -- Check whether there is a need to do inventory_verification
1483: OPEN OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr;
1484: FETCH OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr INTO l_inventory_tracking;
1485: CLOSE OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr;
1486:
1487: IF l_inventory_tracking = 'T' THEN

Line 1484: FETCH OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr INTO l_inventory_tracking;

1480: l_create_order_header := l_dup_line_count IS NULL;
1481:
1482: -- Check whether there is a need to do inventory_verification
1483: OPEN OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr;
1484: FETCH OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr INTO l_inventory_tracking;
1485: CLOSE OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr;
1486:
1487: IF l_inventory_tracking = 'T' THEN
1488: OZF_SALES_TRANSACTIONS_PVT.Initiate_Inventory_tmp (

Line 1485: CLOSE OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr;

1481:
1482: -- Check whether there is a need to do inventory_verification
1483: OPEN OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr;
1484: FETCH OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr INTO l_inventory_tracking;
1485: CLOSE OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr;
1486:
1487: IF l_inventory_tracking = 'T' THEN
1488: OZF_SALES_TRANSACTIONS_PVT.Initiate_Inventory_tmp (
1489: p_api_version => 1.0

Line 1543: OPEN OZF_RESALE_COMMON_PVT.g_interface_rec_csr(p_line_tbl(i).chargeback_int_id);

1539:
1540: IF p_caller_type = 'IFACE' THEN
1541: -- Process interface data
1542:
1543: OPEN OZF_RESALE_COMMON_PVT.g_interface_rec_csr(p_line_tbl(i).chargeback_int_id);
1544: FETCH OZF_RESALE_COMMON_PVT.g_interface_rec_csr INTO l_resale_int_rec;
1545: CLOSE OZF_RESALE_COMMON_PVT.g_interface_rec_csr;
1546:
1547: -- Bug 4380203 (+)

Line 1544: FETCH OZF_RESALE_COMMON_PVT.g_interface_rec_csr INTO l_resale_int_rec;

1540: IF p_caller_type = 'IFACE' THEN
1541: -- Process interface data
1542:
1543: OPEN OZF_RESALE_COMMON_PVT.g_interface_rec_csr(p_line_tbl(i).chargeback_int_id);
1544: FETCH OZF_RESALE_COMMON_PVT.g_interface_rec_csr INTO l_resale_int_rec;
1545: CLOSE OZF_RESALE_COMMON_PVT.g_interface_rec_csr;
1546:
1547: -- Bug 4380203 (+)
1548:

Line 1545: CLOSE OZF_RESALE_COMMON_PVT.g_interface_rec_csr;

1541: -- Process interface data
1542:
1543: OPEN OZF_RESALE_COMMON_PVT.g_interface_rec_csr(p_line_tbl(i).chargeback_int_id);
1544: FETCH OZF_RESALE_COMMON_PVT.g_interface_rec_csr INTO l_resale_int_rec;
1545: CLOSE OZF_RESALE_COMMON_PVT.g_interface_rec_csr;
1546:
1547: -- Bug 4380203 (+)
1548:
1549: -- Check inventory level FOR thIS order.

Line 1574: OZF_RESALE_COMMON_PVT.Insert_Resale_Log (

1570: IF OZF_DEBUG_LOW_ON THEN
1571: OZF_UTILITY_PVT.debug_message(l_api_name||' >> Did not pass inventory checking');
1572: END IF;
1573: --
1574: OZF_RESALE_COMMON_PVT.Insert_Resale_Log (
1575: p_id_value => l_resale_int_rec.resale_line_int_id,
1576: p_id_type => 'IFACE',
1577: p_error_code => 'OZF_RESALE_INV_LEVEL_ERROR',
1578: p_column_name => NULL,

Line 1612: OZF_RESALE_COMMON_PVT.Insert_Resale_Header(

1608:
1609: IF i = 1 THEN
1610: -- I need to create a header
1611: IF l_create_order_header THEN
1612: OZF_RESALE_COMMON_PVT.Insert_Resale_Header(
1613: p_api_version => 1
1614: ,p_init_msg_list => FND_API.G_FALSE
1615: ,p_commit => FND_API.G_FALSE
1616: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 2027: AND resale_id_type = OZF_RESALE_COMMON_PVT.G_ID_TYPE_LINE;

2023: -- OK for now
2024: BEGIN
2025: DELETE FROM ozf_resale_logs
2026: WHERE resale_id = l_order_set_tbl(J).resale_line_id
2027: AND resale_id_type = OZF_RESALE_COMMON_PVT.G_ID_TYPE_LINE;
2028: EXCEPTION
2029: WHEN OTHERS THEN
2030: ozf_utility_pvt.error_message('OZF_DEL_RESALE_LOG_WRG');
2031: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2250: OPEN OZF_RESALE_COMMON_PVT.g_log_id_csr;

2246:
2247: FOR p in 1..l_order_set_tbl.LAST
2248: LOOP
2249: BEGIN
2250: OPEN OZF_RESALE_COMMON_PVT.g_log_id_csr;
2251: FETCH OZF_RESALE_COMMON_PVT.g_log_id_csr INTO l_log_id;
2252: CLOSE OZF_RESALE_COMMON_PVT.g_log_id_csr;
2253:
2254: -- julou bug 6317120. get org_id from table

Line 2251: FETCH OZF_RESALE_COMMON_PVT.g_log_id_csr INTO l_log_id;

2247: FOR p in 1..l_order_set_tbl.LAST
2248: LOOP
2249: BEGIN
2250: OPEN OZF_RESALE_COMMON_PVT.g_log_id_csr;
2251: FETCH OZF_RESALE_COMMON_PVT.g_log_id_csr INTO l_log_id;
2252: CLOSE OZF_RESALE_COMMON_PVT.g_log_id_csr;
2253:
2254: -- julou bug 6317120. get org_id from table
2255: OPEN OZF_RESALE_COMMON_PVT.gc_line_org_id(l_order_set_tbl(p).resale_line_id);

Line 2252: CLOSE OZF_RESALE_COMMON_PVT.g_log_id_csr;

2248: LOOP
2249: BEGIN
2250: OPEN OZF_RESALE_COMMON_PVT.g_log_id_csr;
2251: FETCH OZF_RESALE_COMMON_PVT.g_log_id_csr INTO l_log_id;
2252: CLOSE OZF_RESALE_COMMON_PVT.g_log_id_csr;
2253:
2254: -- julou bug 6317120. get org_id from table
2255: OPEN OZF_RESALE_COMMON_PVT.gc_line_org_id(l_order_set_tbl(p).resale_line_id);
2256: FETCH OZF_RESALE_COMMON_PVT.gc_line_org_id INTO l_org_id;

Line 2255: OPEN OZF_RESALE_COMMON_PVT.gc_line_org_id(l_order_set_tbl(p).resale_line_id);

2251: FETCH OZF_RESALE_COMMON_PVT.g_log_id_csr INTO l_log_id;
2252: CLOSE OZF_RESALE_COMMON_PVT.g_log_id_csr;
2253:
2254: -- julou bug 6317120. get org_id from table
2255: OPEN OZF_RESALE_COMMON_PVT.gc_line_org_id(l_order_set_tbl(p).resale_line_id);
2256: FETCH OZF_RESALE_COMMON_PVT.gc_line_org_id INTO l_org_id;
2257: CLOSE OZF_RESALE_COMMON_PVT.gc_line_org_id;
2258:
2259: OZF_RESALE_LOGS_PKG.Insert_Row(

Line 2256: FETCH OZF_RESALE_COMMON_PVT.gc_line_org_id INTO l_org_id;

2252: CLOSE OZF_RESALE_COMMON_PVT.g_log_id_csr;
2253:
2254: -- julou bug 6317120. get org_id from table
2255: OPEN OZF_RESALE_COMMON_PVT.gc_line_org_id(l_order_set_tbl(p).resale_line_id);
2256: FETCH OZF_RESALE_COMMON_PVT.gc_line_org_id INTO l_org_id;
2257: CLOSE OZF_RESALE_COMMON_PVT.gc_line_org_id;
2258:
2259: OZF_RESALE_LOGS_PKG.Insert_Row(
2260: px_resale_log_id => l_log_id,

Line 2257: CLOSE OZF_RESALE_COMMON_PVT.gc_line_org_id;

2253:
2254: -- julou bug 6317120. get org_id from table
2255: OPEN OZF_RESALE_COMMON_PVT.gc_line_org_id(l_order_set_tbl(p).resale_line_id);
2256: FETCH OZF_RESALE_COMMON_PVT.gc_line_org_id INTO l_org_id;
2257: CLOSE OZF_RESALE_COMMON_PVT.gc_line_org_id;
2258:
2259: OZF_RESALE_LOGS_PKG.Insert_Row(
2260: px_resale_log_id => l_log_id,
2261: p_resale_id => l_order_set_tbl(p).resale_line_id,

Line 2262: p_resale_id_type => OZF_RESALE_COMMON_PVT.G_ID_TYPE_LINE,

2258:
2259: OZF_RESALE_LOGS_PKG.Insert_Row(
2260: px_resale_log_id => l_log_id,
2261: p_resale_id => l_order_set_tbl(p).resale_line_id,
2262: p_resale_id_type => OZF_RESALE_COMMON_PVT.G_ID_TYPE_LINE,
2263: p_error_code => 'OZF_GET_ORDER_PRIC_ERR',
2264: p_error_message => fnd_message.get_string('OZF','OZF_GET_ORDER_PRIC_ERR'),
2265: p_column_name => NULL,
2266: p_column_value => NULL,

Line 2267: --px_org_id => OZF_RESALE_COMMON_PVT.g_org_id

2263: p_error_code => 'OZF_GET_ORDER_PRIC_ERR',
2264: p_error_message => fnd_message.get_string('OZF','OZF_GET_ORDER_PRIC_ERR'),
2265: p_column_name => NULL,
2266: p_column_value => NULL,
2267: --px_org_id => OZF_RESALE_COMMON_PVT.g_org_id
2268: px_org_id => l_org_id
2269: );
2270: EXCEPTION
2271: WHEN OTHERS THEN

Line 2314: OPEN OZF_RESALE_COMMON_PVT.g_log_id_csr;

2310: END IF;
2311: FOR i in 1..l_order_set_tbl.LAST
2312: LOOP
2313: BEGIN
2314: OPEN OZF_RESALE_COMMON_PVT.g_log_id_csr;
2315: FETCH OZF_RESALE_COMMON_PVT.g_log_id_csr INTO l_log_id;
2316: CLOSE OZF_RESALE_COMMON_PVT.g_log_id_csr;
2317:
2318: -- julou bug 6317120. get org_id from table

Line 2315: FETCH OZF_RESALE_COMMON_PVT.g_log_id_csr INTO l_log_id;

2311: FOR i in 1..l_order_set_tbl.LAST
2312: LOOP
2313: BEGIN
2314: OPEN OZF_RESALE_COMMON_PVT.g_log_id_csr;
2315: FETCH OZF_RESALE_COMMON_PVT.g_log_id_csr INTO l_log_id;
2316: CLOSE OZF_RESALE_COMMON_PVT.g_log_id_csr;
2317:
2318: -- julou bug 6317120. get org_id from table
2319: OPEN OZF_RESALE_COMMON_PVT.gc_line_org_id(l_order_set_tbl(i).resale_line_id);

Line 2316: CLOSE OZF_RESALE_COMMON_PVT.g_log_id_csr;

2312: LOOP
2313: BEGIN
2314: OPEN OZF_RESALE_COMMON_PVT.g_log_id_csr;
2315: FETCH OZF_RESALE_COMMON_PVT.g_log_id_csr INTO l_log_id;
2316: CLOSE OZF_RESALE_COMMON_PVT.g_log_id_csr;
2317:
2318: -- julou bug 6317120. get org_id from table
2319: OPEN OZF_RESALE_COMMON_PVT.gc_line_org_id(l_order_set_tbl(i).resale_line_id);
2320: FETCH OZF_RESALE_COMMON_PVT.gc_line_org_id INTO l_org_id;

Line 2319: OPEN OZF_RESALE_COMMON_PVT.gc_line_org_id(l_order_set_tbl(i).resale_line_id);

2315: FETCH OZF_RESALE_COMMON_PVT.g_log_id_csr INTO l_log_id;
2316: CLOSE OZF_RESALE_COMMON_PVT.g_log_id_csr;
2317:
2318: -- julou bug 6317120. get org_id from table
2319: OPEN OZF_RESALE_COMMON_PVT.gc_line_org_id(l_order_set_tbl(i).resale_line_id);
2320: FETCH OZF_RESALE_COMMON_PVT.gc_line_org_id INTO l_org_id;
2321: CLOSE OZF_RESALE_COMMON_PVT.gc_line_org_id;
2322:
2323: OZF_RESALE_LOGS_PKG.Insert_Row(

Line 2320: FETCH OZF_RESALE_COMMON_PVT.gc_line_org_id INTO l_org_id;

2316: CLOSE OZF_RESALE_COMMON_PVT.g_log_id_csr;
2317:
2318: -- julou bug 6317120. get org_id from table
2319: OPEN OZF_RESALE_COMMON_PVT.gc_line_org_id(l_order_set_tbl(i).resale_line_id);
2320: FETCH OZF_RESALE_COMMON_PVT.gc_line_org_id INTO l_org_id;
2321: CLOSE OZF_RESALE_COMMON_PVT.gc_line_org_id;
2322:
2323: OZF_RESALE_LOGS_PKG.Insert_Row(
2324: px_resale_log_id => l_log_id,

Line 2321: CLOSE OZF_RESALE_COMMON_PVT.gc_line_org_id;

2317:
2318: -- julou bug 6317120. get org_id from table
2319: OPEN OZF_RESALE_COMMON_PVT.gc_line_org_id(l_order_set_tbl(i).resale_line_id);
2320: FETCH OZF_RESALE_COMMON_PVT.gc_line_org_id INTO l_org_id;
2321: CLOSE OZF_RESALE_COMMON_PVT.gc_line_org_id;
2322:
2323: OZF_RESALE_LOGS_PKG.Insert_Row(
2324: px_resale_log_id => l_log_id,
2325: p_resale_id => l_order_set_tbl(i).resale_line_id,

Line 2326: p_resale_id_type => OZF_RESALE_COMMON_PVT.G_ID_TYPE_LINE,

2322:
2323: OZF_RESALE_LOGS_PKG.Insert_Row(
2324: px_resale_log_id => l_log_id,
2325: p_resale_id => l_order_set_tbl(i).resale_line_id,
2326: p_resale_id_type => OZF_RESALE_COMMON_PVT.G_ID_TYPE_LINE,
2327: p_error_code => 'OZF_PROC_PRIC_RESLT_ERR',
2328: p_error_message => fnd_message.get_string('OZF','OZF_PROC_PRIC_RESLT_ERR'),
2329: p_column_name => NULL,
2330: p_column_value => NULL,

Line 2331: --px_org_id => OZF_RESALE_COMMON_PVT.g_org_id

2327: p_error_code => 'OZF_PROC_PRIC_RESLT_ERR',
2328: p_error_message => fnd_message.get_string('OZF','OZF_PROC_PRIC_RESLT_ERR'),
2329: p_column_name => NULL,
2330: p_column_value => NULL,
2331: --px_org_id => OZF_RESALE_COMMON_PVT.g_org_id
2332: px_org_id => l_org_id
2333: );
2334: EXCEPTION
2335: WHEN OTHERS THEN

Line 2608: WHERE status_code=OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN

2604: SELECT distinct order_NUMBER,
2605: bill_to_cust_account_id,
2606: date_ordered
2607: FROM ozf_resale_lines_int
2608: WHERE status_code=OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN
2609: AND direct_customer_flag = 'F'
2610: AND resale_batch_id = p_resale_batch_id
2611: ORDER BY date_ordered;
2612:

Line 2626: AND status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN

2622: WHERE order_NUMBER = p_num
2623: AND bill_to_cust_account_id = p_name
2624: AND date_ordered = p_date
2625: AND direct_customer_flag ='F'
2626: AND status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN
2627: AND resale_batch_id = p_resale_batch_id;
2628:
2629: TYPE interface_tbl_type is TABLE OF OZF_RESALE_COMMON_PVT.g_interface_rec_csr%rowtype INDEX BY binary_integer;
2630:

Line 2629: TYPE interface_tbl_type is TABLE OF OZF_RESALE_COMMON_PVT.g_interface_rec_csr%rowtype INDEX BY binary_integer;

2625: AND direct_customer_flag ='F'
2626: AND status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN
2627: AND resale_batch_id = p_resale_batch_id;
2628:
2629: TYPE interface_tbl_type is TABLE OF OZF_RESALE_COMMON_PVT.g_interface_rec_csr%rowtype INDEX BY binary_integer;
2630:
2631: l_resale_int_tbl interface_tbl_type;
2632:
2633: l_header_id NUMBER;

Line 2735: OZF_RESALE_COMMON_PVT.Insert_resale_header(

2731: FOR k in 1..l_resale_int_tbl.LAST LOOP
2732:
2733: -- Create an order header for the order_NUMBER;
2734: IF k = 1 THEN
2735: OZF_RESALE_COMMON_PVT.Insert_resale_header(
2736: p_api_version => 1
2737: ,p_init_msg_list => FND_API.G_FALSE
2738: ,p_commit => FND_API.G_FALSE
2739: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 2751: OZF_RESALE_COMMON_PVT.Insert_resale_line(

2747: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2748: END IF;
2749: END IF;
2750:
2751: OZF_RESALE_COMMON_PVT.Insert_resale_line(
2752: p_api_version => 1
2753: ,p_init_msg_list => FND_API.G_FALSE
2754: ,p_commit => FND_API.G_FALSE
2755: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 2772: SET status_code= OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_CLOSED

2768: END LOOP;
2769:
2770: BEGIN
2771: UPDATE ozf_resale_lines_int
2772: SET status_code= OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_CLOSED
2773: WHERE direct_customer_flag ='F'
2774: AND status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN
2775: AND resale_batch_id = p_resale_batch_id;
2776: EXCEPTION

Line 2774: AND status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN

2770: BEGIN
2771: UPDATE ozf_resale_lines_int
2772: SET status_code= OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_CLOSED
2773: WHERE direct_customer_flag ='F'
2774: AND status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN
2775: AND resale_batch_id = p_resale_batch_id;
2776: EXCEPTION
2777: WHEN OTHERS THEN
2778: ozf_utility_pvt.error_message('OZF_UPD_RESALE_INT_WRG');

Line 3511: OPEN OZF_RESALE_COMMON_PVT.g_log_id_csr;

3507:
3508: FOR p in 1..l_order_set_tbl.LAST
3509: LOOP
3510: BEGIN
3511: OPEN OZF_RESALE_COMMON_PVT.g_log_id_csr;
3512: FETCH OZF_RESALE_COMMON_PVT.g_log_id_csr INTO l_log_id;
3513: CLOSE OZF_RESALE_COMMON_PVT.g_log_id_csr;
3514:
3515: -- julou bug 6317120. get org_id from table

Line 3512: FETCH OZF_RESALE_COMMON_PVT.g_log_id_csr INTO l_log_id;

3508: FOR p in 1..l_order_set_tbl.LAST
3509: LOOP
3510: BEGIN
3511: OPEN OZF_RESALE_COMMON_PVT.g_log_id_csr;
3512: FETCH OZF_RESALE_COMMON_PVT.g_log_id_csr INTO l_log_id;
3513: CLOSE OZF_RESALE_COMMON_PVT.g_log_id_csr;
3514:
3515: -- julou bug 6317120. get org_id from table
3516: OPEN OZF_RESALE_COMMON_PVT.gc_iface_org_id(l_order_set_tbl(p).resale_line_int_id);

Line 3513: CLOSE OZF_RESALE_COMMON_PVT.g_log_id_csr;

3509: LOOP
3510: BEGIN
3511: OPEN OZF_RESALE_COMMON_PVT.g_log_id_csr;
3512: FETCH OZF_RESALE_COMMON_PVT.g_log_id_csr INTO l_log_id;
3513: CLOSE OZF_RESALE_COMMON_PVT.g_log_id_csr;
3514:
3515: -- julou bug 6317120. get org_id from table
3516: OPEN OZF_RESALE_COMMON_PVT.gc_iface_org_id(l_order_set_tbl(p).resale_line_int_id);
3517: FETCH OZF_RESALE_COMMON_PVT.gc_iface_org_id INTO l_org_id;

Line 3516: OPEN OZF_RESALE_COMMON_PVT.gc_iface_org_id(l_order_set_tbl(p).resale_line_int_id);

3512: FETCH OZF_RESALE_COMMON_PVT.g_log_id_csr INTO l_log_id;
3513: CLOSE OZF_RESALE_COMMON_PVT.g_log_id_csr;
3514:
3515: -- julou bug 6317120. get org_id from table
3516: OPEN OZF_RESALE_COMMON_PVT.gc_iface_org_id(l_order_set_tbl(p).resale_line_int_id);
3517: FETCH OZF_RESALE_COMMON_PVT.gc_iface_org_id INTO l_org_id;
3518: CLOSE OZF_RESALE_COMMON_PVT.gc_iface_org_id;
3519:
3520: OZF_RESALE_LOGS_PKG.Insert_Row(

Line 3517: FETCH OZF_RESALE_COMMON_PVT.gc_iface_org_id INTO l_org_id;

3513: CLOSE OZF_RESALE_COMMON_PVT.g_log_id_csr;
3514:
3515: -- julou bug 6317120. get org_id from table
3516: OPEN OZF_RESALE_COMMON_PVT.gc_iface_org_id(l_order_set_tbl(p).resale_line_int_id);
3517: FETCH OZF_RESALE_COMMON_PVT.gc_iface_org_id INTO l_org_id;
3518: CLOSE OZF_RESALE_COMMON_PVT.gc_iface_org_id;
3519:
3520: OZF_RESALE_LOGS_PKG.Insert_Row(
3521: px_resale_log_id => l_log_id,

Line 3518: CLOSE OZF_RESALE_COMMON_PVT.gc_iface_org_id;

3514:
3515: -- julou bug 6317120. get org_id from table
3516: OPEN OZF_RESALE_COMMON_PVT.gc_iface_org_id(l_order_set_tbl(p).resale_line_int_id);
3517: FETCH OZF_RESALE_COMMON_PVT.gc_iface_org_id INTO l_org_id;
3518: CLOSE OZF_RESALE_COMMON_PVT.gc_iface_org_id;
3519:
3520: OZF_RESALE_LOGS_PKG.Insert_Row(
3521: px_resale_log_id => l_log_id,
3522: p_resale_id => l_order_set_tbl(p).resale_line_int_id,

Line 3528: --px_org_id => OZF_RESALE_COMMON_PVT.g_org_id

3524: p_error_code => 'OZF_GET_ORDER_PRIC_ERR',
3525: p_error_message => FND_MESSAGE.get_string('OZF','OZF_GET_ORDER_PRIC_ERR'),
3526: p_column_name => NULL,
3527: p_column_value => NULL,
3528: --px_org_id => OZF_RESALE_COMMON_PVT.g_org_id
3529: px_org_id => l_org_id
3530: );
3531: EXCEPTION
3532: WHEN OTHERS THEN

Line 3567: OPEN OZF_RESALE_COMMON_PVT.g_log_id_csr;

3563: );
3564:
3565: FOR p in 1..l_order_set_tbl.LAST LOOP
3566: BEGIN
3567: OPEN OZF_RESALE_COMMON_PVT.g_log_id_csr;
3568: FETCH OZF_RESALE_COMMON_PVT.g_log_id_csr INTO l_log_id;
3569: CLOSE OZF_RESALE_COMMON_PVT.g_log_id_csr;
3570:
3571: -- julou bug 6317120. get org_id from table

Line 3568: FETCH OZF_RESALE_COMMON_PVT.g_log_id_csr INTO l_log_id;

3564:
3565: FOR p in 1..l_order_set_tbl.LAST LOOP
3566: BEGIN
3567: OPEN OZF_RESALE_COMMON_PVT.g_log_id_csr;
3568: FETCH OZF_RESALE_COMMON_PVT.g_log_id_csr INTO l_log_id;
3569: CLOSE OZF_RESALE_COMMON_PVT.g_log_id_csr;
3570:
3571: -- julou bug 6317120. get org_id from table
3572: OPEN OZF_RESALE_COMMON_PVT.gc_iface_org_id(l_order_set_tbl(p).resale_line_int_id);

Line 3569: CLOSE OZF_RESALE_COMMON_PVT.g_log_id_csr;

3565: FOR p in 1..l_order_set_tbl.LAST LOOP
3566: BEGIN
3567: OPEN OZF_RESALE_COMMON_PVT.g_log_id_csr;
3568: FETCH OZF_RESALE_COMMON_PVT.g_log_id_csr INTO l_log_id;
3569: CLOSE OZF_RESALE_COMMON_PVT.g_log_id_csr;
3570:
3571: -- julou bug 6317120. get org_id from table
3572: OPEN OZF_RESALE_COMMON_PVT.gc_iface_org_id(l_order_set_tbl(p).resale_line_int_id);
3573: FETCH OZF_RESALE_COMMON_PVT.gc_iface_org_id INTO l_org_id;

Line 3572: OPEN OZF_RESALE_COMMON_PVT.gc_iface_org_id(l_order_set_tbl(p).resale_line_int_id);

3568: FETCH OZF_RESALE_COMMON_PVT.g_log_id_csr INTO l_log_id;
3569: CLOSE OZF_RESALE_COMMON_PVT.g_log_id_csr;
3570:
3571: -- julou bug 6317120. get org_id from table
3572: OPEN OZF_RESALE_COMMON_PVT.gc_iface_org_id(l_order_set_tbl(p).resale_line_int_id);
3573: FETCH OZF_RESALE_COMMON_PVT.gc_iface_org_id INTO l_org_id;
3574: CLOSE OZF_RESALE_COMMON_PVT.gc_iface_org_id;
3575:
3576: OZF_RESALE_LOGS_PKG.Insert_Row(

Line 3573: FETCH OZF_RESALE_COMMON_PVT.gc_iface_org_id INTO l_org_id;

3569: CLOSE OZF_RESALE_COMMON_PVT.g_log_id_csr;
3570:
3571: -- julou bug 6317120. get org_id from table
3572: OPEN OZF_RESALE_COMMON_PVT.gc_iface_org_id(l_order_set_tbl(p).resale_line_int_id);
3573: FETCH OZF_RESALE_COMMON_PVT.gc_iface_org_id INTO l_org_id;
3574: CLOSE OZF_RESALE_COMMON_PVT.gc_iface_org_id;
3575:
3576: OZF_RESALE_LOGS_PKG.Insert_Row(
3577: px_resale_log_id => l_log_id,

Line 3574: CLOSE OZF_RESALE_COMMON_PVT.gc_iface_org_id;

3570:
3571: -- julou bug 6317120. get org_id from table
3572: OPEN OZF_RESALE_COMMON_PVT.gc_iface_org_id(l_order_set_tbl(p).resale_line_int_id);
3573: FETCH OZF_RESALE_COMMON_PVT.gc_iface_org_id INTO l_org_id;
3574: CLOSE OZF_RESALE_COMMON_PVT.gc_iface_org_id;
3575:
3576: OZF_RESALE_LOGS_PKG.Insert_Row(
3577: px_resale_log_id => l_log_id,
3578: p_resale_id => l_order_set_tbl(p).resale_line_int_id,

Line 3584: --px_org_id => OZF_RESALE_COMMON_PVT.g_org_id

3580: p_error_code => 'OZF_PRIC_RESULT_ERR',
3581: p_error_message => FND_MESSAGE.get_string('OZF','OZF_PRIC_RESULT_ERR'),
3582: p_column_name => NULL,
3583: p_column_value => NULL,
3584: --px_org_id => OZF_RESALE_COMMON_PVT.g_org_id
3585: px_org_id => l_org_id
3586: );
3587: EXCEPTION
3588: WHEN OTHERS THEN

Line 3712: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED

3708:
3709: IF l_valid_line_count > 0 THEN
3710: -- close this batch
3711: UPDATE ozf_resale_batches_all
3712: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED
3713: , batch_count = l_valid_line_count
3714: WHERE resale_batch_id = p_resale_batch_id;
3715:
3716: OPEN csr_get_batch_number(p_resale_batch_id);

Line 3832: l_sold_from_cust_id_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;

3828: FROM ozf_resale_lines_int
3829: WHERE resale_batch_id IS NULL
3830: AND request_id = p_id;
3831:
3832: l_sold_from_cust_id_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
3833:
3834: -- bug # 7375849 fixed by ateotia (+)
3835: --l_sold_from_cust_name_tbl OZF_RESALE_COMMON_PVT.varchar_tbl_type;
3836: TYPE varchar_tbl_type IS TABLE OF VARCHAR2(360) INDEX BY BINARY_INTEGER;

Line 3835: --l_sold_from_cust_name_tbl OZF_RESALE_COMMON_PVT.varchar_tbl_type;

3831:
3832: l_sold_from_cust_id_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
3833:
3834: -- bug # 7375849 fixed by ateotia (+)
3835: --l_sold_from_cust_name_tbl OZF_RESALE_COMMON_PVT.varchar_tbl_type;
3836: TYPE varchar_tbl_type IS TABLE OF VARCHAR2(360) INDEX BY BINARY_INTEGER;
3837: l_sold_from_cust_name_tbl varchar_tbl_type;
3838: -- bug # 7375849 fixed by ateotia (-)
3839:

Line 3840: l_org_id_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;

3836: TYPE varchar_tbl_type IS TABLE OF VARCHAR2(360) INDEX BY BINARY_INTEGER;
3837: l_sold_from_cust_name_tbl varchar_tbl_type;
3838: -- bug # 7375849 fixed by ateotia (-)
3839:
3840: l_org_id_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
3841: l_currency_code_tbl OZF_RESALE_COMMON_PVT.varchar_tbl_type;
3842:
3843: CURSOR party_id_csr(p_id number)IS
3844: SELECT hca.party_id

Line 3841: l_currency_code_tbl OZF_RESALE_COMMON_PVT.varchar_tbl_type;

3837: l_sold_from_cust_name_tbl varchar_tbl_type;
3838: -- bug # 7375849 fixed by ateotia (-)
3839:
3840: l_org_id_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
3841: l_currency_code_tbl OZF_RESALE_COMMON_PVT.varchar_tbl_type;
3842:
3843: CURSOR party_id_csr(p_id number)IS
3844: SELECT hca.party_id
3845: -- bug # 7375849 fixed by ateotia (+)

Line 4058: p_batch_type => OZF_RESALE_COMMON_PVT.G_TP_ACCRUAL,

4054: p_program_update_date => SYSdate,
4055: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,
4056: p_created_from => l_created_from,
4057: p_batch_number => l_resale_batch_number,
4058: p_batch_type => OZF_RESALE_COMMON_PVT.G_TP_ACCRUAL,
4059: p_batch_count => NULL,
4060: p_year => NULL,
4061: p_month => NULL,
4062: p_report_date => trunc(sysdate),

Line 4065: p_status_code => OZF_RESALE_COMMON_PVT.G_BATCH_NEW,

4061: p_month => NULL,
4062: p_report_date => trunc(sysdate),
4063: p_report_start_date => trunc(l_start_date),
4064: p_report_end_date => trunc(l_end_date),
4065: p_status_code => OZF_RESALE_COMMON_PVT.G_BATCH_NEW,
4066: p_data_source_code => l_data_source_code,
4067: p_reference_type => NULL,
4068: p_reference_number => NULL,
4069: p_comments => NULL,