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

Line 167: FROM ozf_resale_lines_int

163: WHERE resale_batch_id = p_id;
164:
165: CURSOR open_line_count_csr (p_id IN NUMBER) IS
166: SELECT count(1)
167: FROM ozf_resale_lines_int
168: WHERE resale_batch_id = p_id
169: AND status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN;
170:
171: CURSOR valid_line_id_csr(p_id IN NUMBER,

Line 176: FROM ozf_resale_lines_int

172: p_order_number IN VARCHAR2,
173: p_cust_id IN NUMBER,
174: p_date IN DATE) IS
175: SELECT resale_line_int_id
176: FROM ozf_resale_lines_int
177: WHERE resale_batch_id = p_id
178: AND order_number = p_order_number
179: AND sold_from_cust_account_id = p_cust_id
180: AND date_ordered = p_date

Line 191: , ozf_resale_lines_int b

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

Line 192: , ozf_resale_lines c

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

Line 207: FROM ozf_resale_lines_int

203: CURSOR batch_order_num_csr(p_id IN NUMBER) IS
204: SELECT DISTINCT order_number,
205: sold_from_cust_account_id,
206: date_ordered
207: FROM ozf_resale_lines_int
208: WHERE resale_batch_id = p_id
209: AND status_code = 'PROCESSED'
210: -- AND status_code in(OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DUPLICATED, OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_PROCESSED)
211: -- AND duplicated_adjustment_id <> -1

Line 249: FROM ozf_resale_lines_int_all

245: , bill_to_city
246: , bill_to_state
247: , bill_to_postal_code
248: , bill_to_country
249: FROM ozf_resale_lines_int_all
250: WHERE resale_batch_id = cv_resale_batch_id
251: AND status_code = 'PROCESSED'
252: AND ( duplicated_line_id IS NULL
253: OR ( duplicated_line_id IS NOT NULL AND duplicated_adjustment_id = -1))

Line 270: FROM ozf_resale_lines_int_all

266: , end_cust_state
267: , end_cust_postal_code
268: , end_cust_country
269: , end_cust_site_use_code
270: FROM ozf_resale_lines_int_all
271: WHERE resale_batch_id = cv_resale_batch_id
272: AND status_code = 'PROCESSED'
273: AND ( duplicated_line_id IS NULL
274: OR ( duplicated_line_id IS NOT NULL AND duplicated_adjustment_id = -1))

Line 550: UPDATE ozf_resale_lines_int_all

546: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
548: END IF;
549:
550: UPDATE ozf_resale_lines_int_all
551: SET bill_to_party_id = l_new_party_rec.party_id
552: , bill_to_party_site_id = l_new_party_rec.party_site_id
553: WHERE resale_batch_id = p_resale_batch_id
554: AND bill_to_party_id IS NULL

Line 605: UPDATE ozf_resale_lines_int_all

601: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
603: END IF;
604:
605: UPDATE ozf_resale_lines_int_all
606: SET end_cust_party_id = l_new_party_rec.party_id
607: , end_cust_party_site_id = l_new_party_rec.party_site_id
608: WHERE resale_batch_id = p_resale_batch_id
609: AND end_cust_party_id IS NULL

Line 680: UPDATE ozf_resale_lines_int_all

676:
677: -- There is something wrong with this order. dispute all the orders
678: -- and move to the next one.
679: -- JXWU move update to common pvt
680: UPDATE ozf_resale_lines_int_all
681: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
682: dispute_code = 'OZF_RESALE_MULTI_HEADER',
683: followup_action_code = 'C',
684: response_type = 'CA',

Line 758: UPDATE ozf_resale_lines_int

754: IF OZF_DEBUG_LOW_ON THEN
755: OZF_UTILITY_PVT.debug_message('Did NOT pass inventory checking');
756: END IF;
757: -- Here turn thIS line to DISPUTED AND create a dISput code FOR it.
758: UPDATE ozf_resale_lines_int
759: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
760: dispute_code = 'OZF_LT_INVT',
761: followup_action_code = NVL2(followup_action_code,followup_action_code,'C'),
762: response_type = 'CA',

Line 1065: UPDATE ozf_resale_lines_int

1061: CLOSE claimed_amount_csr;
1062:
1063: BEGIN
1064: -- BUG 4395931 (+)
1065: UPDATE ozf_resale_lines_int
1066: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_CLOSED
1067: WHERE resale_batch_id = p_resale_batch_id
1068: AND status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_PROCESSED;
1069:

Line 1072: UPDATE ozf_resale_lines_int

1068: AND status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_PROCESSED;
1069:
1070: /*
1071: -- SLKRISHN change to common procedure
1072: UPDATE ozf_resale_lines_int
1073: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_CLOSED
1074: WHERE resale_batch_id = p_resale_batch_id
1075: AND status_code in(OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DUPLICATED, OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_PROCESSED);
1076: --AND duplicated_adjustment_id <> -1;

Line 1212: FROM ozf_resale_lines_int_all

1208: SELECT resale_line_int_id,
1209: 'OZF_RESALE_PUR_PRICE_MISSING',
1210: 'PURCHASE_PRICE',
1211: NULL
1212: FROM ozf_resale_lines_int_all
1213: WHERE resale_batch_id = p_batch_id
1214: AND status_code IN (OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN, OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED)
1215: AND tracing_flag = 'F'
1216: AND purchase_price IS NULL;

Line 1397: FROM ozf_resale_lines_int

1393: CURSOR order_identifiers_csr (p_id IN NUMBER) IS
1394: SELECT order_number
1395: , sold_from_cust_account_id
1396: , date_ordered
1397: FROM ozf_resale_lines_int
1398: WHERE resale_line_int_id = p_id;
1399:
1400: CURSOR func_currency_cd_csr IS
1401: SELECT gs.currency_code

Line 1411: FROM ozf_resale_lines_int

1407: CURSOR open_lines_csr(p_order_number VARCHAR2,
1408: p_date_ordered DATE,
1409: p_cust_account_id NUMBER )IS
1410: SELECT resale_line_int_id, 'OZF_RESALE_PRICE_ERROR', NULL, NULL
1411: FROM ozf_resale_lines_int
1412: WHERE status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN
1413: AND order_number = l_order_number
1414: AND date_ordered = l_date_ordered
1415: AND sold_from_cust_account_id =l_cust_account_id

Line 1457: update ozf_resale_lines_int

1453: IF OZF_DEBUG_LOW_ON THEN
1454: OZF_UTILITY_PVT.debug_message('line '||p_line_tbl(i).chargeback_int_id || ' has pricing error' );
1455: END IF;
1456: BEGIN
1457: update ozf_resale_lines_int
1458: set status_code =OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
1459: dispute_code = 'OZF_RESALE_PRICE_ERROR',
1460: followup_action_code = NVL2(followup_action_code,followup_action_code,'C'),
1461: response_type = 'CA',

Line 1541: UPDATE ozf_resale_lines_int_all

1537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1538: END IF;
1539:
1540: BEGIN
1541: UPDATE ozf_resale_lines_int_all
1542: SET status_code =OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
1543: dispute_code = 'OZF_RESALE_PRICE_ERROR',
1544: followup_action_code = NVL2(followup_action_code,followup_action_code,'C'),
1545: response_type = 'CA',

Line 1632: UPDATE ozf_resale_lines_int

1628: END IF;
1629: --
1630: -- SET Batch as DISPUTED
1631: -- SLKRISHN change to common procedure
1632: UPDATE ozf_resale_lines_int
1633: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
1634: dispute_code = 'OZF_LT_INVT',
1635: followup_action_code = NVL2(followup_action_code,followup_action_code,'C'),
1636: response_type = 'CA',

Line 1873: FROM ozf_resale_lines_int

1869: p_id IN NUMBER,
1870: p_date IN DATE,
1871: p_batch_id IN NUMBER ) IS
1872: SELECT *
1873: FROM ozf_resale_lines_int
1874: WHERE order_number = p_order_number
1875: AND sold_from_cust_account_id= p_id
1876: AND date_ordered = p_date
1877: AND status_code = 'OPEN'

Line 1895: FROM ozf_resale_lines_int

1891: p_id IN NUMBER,
1892: p_date IN DATE,
1893: p_batch_id IN NUMBER ) IS
1894: SELECT *
1895: FROM ozf_resale_lines_int
1896: WHERE order_number = p_order_number
1897: AND sold_from_cust_account_id= p_id
1898: AND date_ordered = p_date
1899: AND status_code = 'OPEN'

Line 1977: UPDATE ozf_resale_lines_int

1973: RAISE FND_API.g_exc_unexpected_error;
1974: END IF;
1975:
1976: -- Set line to DISPUTED
1977: UPDATE ozf_resale_lines_int
1978: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
1979: dispute_code = 'OZF_LT_INVT',
1980: followup_action_code = NVL2(followup_action_code,followup_action_code,'C'),
1981: response_type = 'CA',

Line 2364: FROM ozf_resale_lines_int

2360: CURSOR order_num_csr IS
2361: SELECT DISTINCT order_number,
2362: sold_from_cust_account_id,
2363: date_ordered
2364: FROM ozf_resale_lines_int
2365: WHERE status_code = 'OPEN' --(OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN, OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DUPLICATED)
2366: AND resale_batch_id = p_resale_batch_id
2367: --AND (duplicated_adjustment_id IS NULL OR
2368: -- duplicated_adjustment_id = -1 )

Line 2598: UPDATE ozf_resale_lines_int

2594: OZF_UTILITY_PVT.debug_message('/*--- After process_pricing_result Insert resale log done ---*/');
2595: END IF;
2596:
2597: BEGIN
2598: UPDATE ozf_resale_lines_int
2599: SET status_code =OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
2600: dispute_code = 'OZF_PROC_PRIC_RESLT_ERR',
2601: followup_action_code = NVL2(followup_action_code,followup_action_code,'C'),
2602: response_type = 'CA',

Line 2623: UPDATE ozf_resale_lines_int_all

2619: GOTO END_LOOP;
2620: END IF;
2621:
2622: -- Bug 4387465 (+)
2623: UPDATE ozf_resale_lines_int_all
2624: SET status_code= 'PROCESSED'
2625: WHERE status_code = 'OPEN'
2626: AND order_number = l_order_num_tbl(i)
2627: AND sold_from_cust_account_id = l_cust_account_id_tbl(i)