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_SPECIAL_PRICING_PVT dependencies on OZF_RESALE_LINES

Line 85: From ozf_resale_lines_int

81: l_last_updated_by NUMBER(15);
82:
83: CURSOR OPEN_line_count_csr (p_id in NUMBER) IS
84: SELECT count(1)
85: From ozf_resale_lines_int
86: WHERE resale_batch_id = p_id
87: AND status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN;
88: l_count NUMBER;
89:

Line 103: FROM ozf_resale_lines_int

99: p_order_number in VARCHAR2,
100: p_cust_id in NUMBER,
101: p_date in date) IS
102: SELECT resale_line_int_id
103: FROM ozf_resale_lines_int
104: WHERE resale_batch_id = p_id
105: AND order_number = p_order_number
106: AND sold_from_cust_account_id = p_cust_id
107: AND date_ordered = p_date

Line 126: FROM ozf_resale_lines_int

122: CURSOR batch_order_num_csr(p_id in NUMBER) IS
123: SELECT distinct order_number,
124: sold_from_cust_account_id,
125: date_ordered
126: FROM ozf_resale_lines_int
127: WHERE resale_batch_id = p_id
128: AND status_code = 'PROCESSED'
129: --AND status_code in(OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DUPLICATED, OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_PROCESSED)
130: ORDER BY date_ordered;

Line 161: FROM ozf_resale_lines_int

157: l_sales_transaction_id NUMBER;
158:
159: CURSOR agreement_list_csr(p_resale_batch_id NUMBER) IS
160: SELECT distinct substr(agreement_name, 1, 30)
161: FROM ozf_resale_lines_int
162: where resale_batch_id = p_resale_batch_id;
163:
164: TYPE agreement_name_type IS RECORD (
165: agreement_name VARCHAR2(30)

Line 192: , ozf_resale_lines_int b

188: , p_cust_id IN NUMBER
189: , p_date IN DATE ) IS
190: SELECT a.resale_header_id
191: FROM ozf_resale_headers a
192: , ozf_resale_lines_int b
193: , ozf_resale_lines c
194: WHERE b.resale_batch_id = p_id
195: AND b.order_number = p_order_number
196: AND b.sold_from_cust_account_id = p_cust_id

Line 193: , ozf_resale_lines c

189: , p_date IN DATE ) IS
190: SELECT a.resale_header_id
191: FROM ozf_resale_headers a
192: , ozf_resale_lines_int b
193: , ozf_resale_lines c
194: WHERE b.resale_batch_id = p_id
195: AND b.order_number = p_order_number
196: AND b.sold_from_cust_account_id = p_cust_id
197: AND b.date_ordered = p_date

Line 367: UPDATE ozf_resale_lines_int_all

363:
364: -- There is something wrong with this order. dispute all the orders
365: -- and move to the next one.
366: -- JXWU move update to common pvt
367: UPDATE ozf_resale_lines_int_all
368: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
369: dispute_code = 'OZF_RESALE_MULTI_HEADER',
370: followup_action_code = 'C',
371: response_type = 'CA',

Line 444: UPDATE ozf_resale_lines_int

440: ozf_utility_PVT.debug_message('Did not pass inventory checking');
441: END IF;
442:
443: -- Here turn this line to disputed and create a disput code for it.
444: UPDATE ozf_resale_lines_int
445: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
446: dispute_code = 'OZF_LT_INVT',
447: followup_action_code = 'C',
448: response_type = 'CA',

Line 644: UPDATE ozf_resale_lines_int

640: IF l_amount_claimed <> 0 THEN
641:
642: -- IF anything is paid, UPDATE batch line status to CLOSEd for each OPEN and duplicated lines.
643: BEGIN
644: UPDATE ozf_resale_lines_int
645: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_CLOSED
646: WHERE resale_batch_id = p_resale_batch_id
647: AND status_code in(OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DUPLICATED, OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_PROCESSED) ;
648:

Line 782: FROM ozf_resale_lines_int_all b

778: FND_MESSAGE.get_string('OZF','OZF_RESALE_AGR_TYPE_WNG'),
779: 'AGREEMENT_TYPE',
780: NULL,
781: org_id
782: FROM ozf_resale_lines_int_all b
783: WHERE b.status_code = 'OPEN'
784: AND b.tracing_flag = 'F'
785: AND b.agreement_type <>'SPO'
786: AND b.resale_batch_id = p_resale_batch_id

Line 803: UPDATE ozf_resale_lines_int_all

799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
800: END;
801:
802: BEGIN
803: UPDATE ozf_resale_lines_int_all
804: SET status_code = 'DISPUTED',
805: dispute_code = 'OZF_RESALE_AGRM_TYPE_WNG',
806: followup_action_code = 'C',
807: response_type = 'CA',

Line 842: FROM ozf_resale_lines_int_all b

838: fnd_message.get_string('OZF','OZF_RESALE_PUR_PRICE_MISSING'),
839: 'PURCHASE_PRICE',
840: NULL,
841: org_id
842: FROM ozf_resale_lines_int_all b
843: WHERE b.status_code = 'OPEN'
844: AND b.tracing_flag = 'F'
845: AND b.purchase_price IS NULL
846: AND b.resale_batch_id = p_resale_batch_id

Line 863: UPDATE ozf_resale_lines_int_all

859: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
860: END;
861:
862: BEGIN
863: UPDATE ozf_resale_lines_int_all
864: SET status_code = 'DISPUTED',
865: dispute_code = 'OZF_RESALE_PUR_PRICE_MISSING',
866: followup_action_code = 'C',
867: response_type = 'CA',

Line 953: FROM ozf_resale_lines_int

949: CURSOR order_set_csr(p_order_number VARCHAR2,
950: p_id NUMBER, p_date date,
951: p_resale_id NUMBER) IS
952: SELECT *
953: FROM ozf_resale_lines_int
954: WHERE order_number = p_order_number
955: AND sold_from_cust_account_id= p_id
956: AND date_ordered = p_date
957: AND status_code = 'OPEN'

Line 971: FROM ozf_resale_lines_int

967: CURSOR all_order_set_csr(p_order_number VARCHAR2,
968: p_id NUMBER, p_date date,
969: p_resale_id NUMBER) IS
970: SELECT *
971: FROM ozf_resale_lines_int
972: WHERE order_number = p_order_number
973: AND sold_from_cust_account_id= p_id
974: AND date_ordered = p_date
975: AND status_code = 'OPEN'

Line 1170: UPDATE ozf_resale_lines_int_all

1166: END IF;
1167:
1168: -- SET Batch as DISPUTED
1169: -- SLKRISHN change to common procedure
1170: UPDATE ozf_resale_lines_int_all
1171: SET status_code = 'DISPUTED',
1172: dispute_code = 'OZF_LT_INVT',
1173: followup_action_code = 'C',
1174: response_type = 'CA',

Line 1178: UPDATE ozf_resale_lines_int_all

1174: response_type = 'CA',
1175: response_code = 'N'
1176: WHERE resale_line_int_id = l_resale_int_rec.resale_line_int_id;
1177: ELSE
1178: UPDATE ozf_resale_lines_int_all
1179: SET status_code= 'PROCESSED'
1180: WHERE resale_line_int_id = l_resale_int_rec.resale_line_int_id
1181: AND tracing_flag = 'T';
1182: END IF;

Line 1185: UPDATE ozf_resale_lines_int_all

1181: AND tracing_flag = 'T';
1182: END IF;
1183: ELSE
1184: -- 7570302 update stock sale line to PROCESSED if inventory validation disabled
1185: UPDATE ozf_resale_lines_int_all
1186: SET status_code= 'PROCESSED'
1187: WHERE resale_line_int_id = l_resale_int_rec.resale_line_int_id
1188: AND tracing_flag = 'T';
1189: END IF;

Line 1194: /* UPDATE ozf_resale_lines_int_all

1190: END LOOP;
1191: END IF;
1192: -- the following piece of code has been commented in order to validate the tracing lines.
1193: -- ???? UPDATE tracing order lines to processed for this order to be processed
1194: /* UPDATE ozf_resale_lines_int_all
1195: SET status_code = 'PROCESSED'
1196: WHERE status_code = 'OPEN'
1197: AND order_number = p_order_number
1198: AND sold_from_cust_account_id = p_sold_from_cust_account_id

Line 1275: UPDATE ozf_resale_lines_int_all

1271: END IF;
1272: --
1273: -- SET Batch as DISPUTED
1274: -- SLKRISHN change to common procedure
1275: UPDATE ozf_resale_lines_int_all
1276: SET status_code = 'DISPUTED',
1277: dispute_code = 'OZF_LT_INVT',
1278: followup_action_code = 'C',
1279: response_type = 'CA',

Line 1327: UPDATE ozf_resale_lines_int

1323: RAISE FND_API.g_exc_unexpected_error;
1324: END IF;
1325:
1326: BEGIN
1327: UPDATE ozf_resale_lines_int
1328: SET status_code=OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
1329: dispute_code = 'OZF_RESALE_AGRM_WNG',
1330: followup_action_code = 'C',
1331: response_type = 'CA',

Line 1366: UPDATE ozf_resale_lines_int

1362: RAISE FND_API.g_exc_unexpected_error;
1363: END IF;
1364:
1365: BEGIN
1366: UPDATE ozf_resale_lines_int
1367: SET status_code=OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
1368: dispute_code = 'OZF_RESALE_AGRM_RANG_WNG',
1369: followup_action_code = 'C',
1370: response_type = 'CA',

Line 1387: UPDATE ozf_resale_lines_int

1383: OZF_UTILITY_PVT.debug_message('line currency '||l_order_set_tbl(J).currency_code );
1384: END IF;
1385: IF l_order_set_tbl(J).currency_code <> l_header_currency_code THEN
1386: BEGIN
1387: UPDATE ozf_resale_lines_int
1388: SET status_code=OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
1389: dispute_code = 'OZF_RESALE_AGRM_CURRENCY_WNG',
1390: followup_action_code = 'C',
1391: response_type = 'CA',

Line 1426: UPDATE ozf_resale_lines_int

1422: -- Do nothing
1423: NULL;
1424: ELSE
1425: BEGIN
1426: UPDATE ozf_resale_lines_int
1427: SET status_code=OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
1428: dispute_code = 'OZF_RESALE_AGRM_END_CUST_WNG',
1429: followup_action_code = 'C',
1430: response_type = 'CA',

Line 1474: UPDATE ozf_resale_lines_int

1470: (l_order_set_tbl(J).END_cust_party_id is NULL) THEN
1471: NULL;
1472: ELSE
1473: BEGIN
1474: UPDATE ozf_resale_lines_int
1475: SET status_code=OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
1476: dispute_code = 'OZF_RESALE_AGRM_RESELL_WNG',
1477: followup_action_code = 'C',
1478: response_type = 'CA',

Line 1492: UPDATE ozf_resale_lines_int

1488: END IF;
1489: END IF;
1490: ELSE
1491: BEGIN
1492: UPDATE ozf_resale_lines_int
1493: SET status_code=OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
1494: dispute_code = 'OZF_RESALE_AGRM_RESELL_WNG',
1495: followup_action_code = 'C',
1496: response_type = 'CA',

Line 1517: UPDATE ozf_resale_lines_int

1513:
1514: NULL;
1515: ELSE
1516: BEGIN
1517: UPDATE ozf_resale_lines_int
1518: SET status_code=OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
1519: dispute_code = 'OZF_RESALE_AGRM_RESELL_WNG',
1520: followup_action_code = 'C',
1521: response_type = 'CA',

Line 1542: UPDATE ozf_resale_lines_int

1538: IF OZF_DEBUG_LOW_ON THEN
1539: OZF_UTILITY_PVT.debug_message('In Offer id null' );
1540: END IF;
1541: BEGIN
1542: UPDATE ozf_resale_lines_int
1543: SET status_code=OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
1544: dispute_code = 'OZF_RESALE_AGRM_OFF_NULL',
1545: followup_action_code = 'C',
1546: response_type = 'CA',

Line 1562: UPDATE ozf_resale_lines_int

1558: IF OZF_DEBUG_LOW_ON THEN
1559: OZF_UTILITY_PVT.debug_message('In Off invoice offer' );
1560: END IF;
1561: BEGIN
1562: UPDATE ozf_resale_lines_int
1563: SET status_code=OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
1564: dispute_code = 'OZF_RESALE_AGRM_OFF_OFF_INV',
1565: followup_action_code = 'C',
1566: response_type = 'CA',

Line 1616: UPDATE ozf_resale_lines_int

1612: RAISE FND_API.g_exc_unexpected_error;
1613: END IF;
1614:
1615: BEGIN
1616: UPDATE ozf_resale_lines_int
1617: SET status_code=OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
1618: dispute_code = 'OZF_RESALE_AGRM_LINE_WNG',
1619: followup_action_code = 'C',
1620: response_type = 'CA',

Line 1685: UPDATE ozf_resale_lines_int

1681: l_used_uom_code,
1682: NULL, NULL);
1683: IF l_request_line_apprv_max_qty = -99999 THEN
1684: BEGIN
1685: UPDATE ozf_resale_lines_int
1686: SET status_code=OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
1687: dispute_code = 'OZF_SPP_NO_UOM_CONV_MAX',
1688: followup_action_code = 'C',
1689: response_type = 'CA',

Line 1712: UPDATE ozf_resale_lines_int

1708: l_used_uom_code,
1709: NULL, NULL);
1710: IF l_request_line_apprv_min_qty = -99999 THEN
1711: BEGIN
1712: UPDATE ozf_resale_lines_int
1713: SET status_code=OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
1714: dispute_code = 'OZF_SPP_NO_UOM_CONV_MIN',
1715: followup_action_code = 'C',
1716: response_type = 'CA',

Line 1742: UPDATE ozf_resale_lines_int

1738: l_used_uom_code,
1739: NULL, NULL);
1740: IF l_current_quantity = -99999 THEN
1741: BEGIN
1742: UPDATE ozf_resale_lines_int
1743: SET status_code=OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
1744: dispute_code = 'OZF_SPP_NO_UOM_CONV_CURR',
1745: followup_action_code = 'C',
1746: response_type = 'CA',

Line 1766: UPDATE ozf_resale_lines_int

1762:
1763: IF l_request_line_apprv_max_qty is not NULL AND
1764: l_current_quantity + l_used_quantity > l_request_line_apprv_max_qty THEN
1765: BEGIN
1766: UPDATE ozf_resale_lines_int
1767: SET status_code=OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
1768: dispute_code = 'OZF_RESALE_AGRM_QUN_GT_MAX',
1769: followup_action_code = 'C',
1770: response_type = 'CA',

Line 1785: UPDATE ozf_resale_lines_int

1781:
1782: IF l_request_line_apprv_min_qty is not NULL AND
1783: l_current_quantity + l_used_quantity < l_request_line_apprv_min_qty THEN
1784: BEGIN
1785: UPDATE ozf_resale_lines_int
1786: SET status_code=OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
1787: dispute_code = 'OZF_RESALE_AGRM_QUN_LT_MIN',
1788: followup_action_code = 'C',
1789: response_type = 'CA',

Line 1903: FROM ozf_resale_lines_int

1899: CURSOR order_num_csr IS
1900: SELECT DISTINCT order_number,
1901: sold_from_cust_account_id,
1902: date_ordered
1903: FROM ozf_resale_lines_int
1904: WHERE status_code = 'OPEN'
1905: --status_code in(OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN, OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DUPLICATED)
1906: AND duplicated_adjustment_id IS NULL
1907: AND resale_batch_id = p_resale_batch_id

Line 2019: update ozf_resale_lines_int

2015: x_return_status => l_return_status);
2016:
2017: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2018: BEGIN
2019: update ozf_resale_lines_int
2020: set status_code =OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
2021: dispute_code = 'OZF_PROC_PRIC_RESLT_ERR',
2022: followup_action_code = 'C',
2023: response_type = 'CA',