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 103: FROM ozf_resale_lines_int

99: WHERE resale_batch_id = p_id;
100:
101: CURSOR open_line_count_csr (p_id IN NUMBER) IS
102: SELECT count(1)
103: FROM ozf_resale_lines_int
104: WHERE resale_batch_id = p_id
105: AND status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN;
106:
107: CURSOR valid_line_id_csr(p_id IN NUMBER,

Line 112: FROM ozf_resale_lines_int

108: p_order_number IN VARCHAR2,
109: p_cust_id IN NUMBER,
110: p_date IN DATE) IS
111: SELECT resale_line_int_id
112: FROM ozf_resale_lines_int
113: WHERE resale_batch_id = p_id
114: AND order_number = p_order_number
115: AND sold_from_cust_account_id = p_cust_id
116: AND date_ordered = p_date

Line 127: , ozf_resale_lines_int b

123: , p_cust_id IN NUMBER
124: , p_date IN DATE ) IS
125: SELECT a.resale_header_id
126: FROM ozf_resale_headers a
127: , ozf_resale_lines_int b
128: , ozf_resale_lines c
129: WHERE b.resale_batch_id = p_id
130: AND b.order_number = p_order_number
131: AND b.sold_from_cust_account_id = p_cust_id

Line 128: , ozf_resale_lines c

124: , p_date IN DATE ) IS
125: SELECT a.resale_header_id
126: FROM ozf_resale_headers a
127: , ozf_resale_lines_int b
128: , ozf_resale_lines c
129: WHERE b.resale_batch_id = p_id
130: AND b.order_number = p_order_number
131: AND b.sold_from_cust_account_id = p_cust_id
132: AND b.date_ordered = p_date

Line 143: FROM ozf_resale_lines_int

139: CURSOR batch_order_num_csr(p_id IN NUMBER) IS
140: SELECT DISTINCT order_number,
141: sold_from_cust_account_id,
142: date_ordered
143: FROM ozf_resale_lines_int
144: WHERE resale_batch_id = p_id
145: AND status_code = 'PROCESSED'
146: -- AND status_code in(OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DUPLICATED, OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_PROCESSED)
147: -- AND duplicated_adjustment_id <> -1

Line 183: FROM ozf_resale_lines_int_all

179: , bill_to_city
180: , bill_to_state
181: , bill_to_postal_code
182: , bill_to_country
183: FROM ozf_resale_lines_int_all
184: WHERE resale_batch_id = cv_resale_batch_id
185: AND status_code = 'PROCESSED'
186: AND ( duplicated_line_id IS NULL
187: OR ( duplicated_line_id IS NOT NULL AND duplicated_adjustment_id = -1))

Line 204: FROM ozf_resale_lines_int_all

200: , end_cust_state
201: , end_cust_postal_code
202: , end_cust_country
203: , end_cust_site_use_code
204: FROM ozf_resale_lines_int_all
205: WHERE resale_batch_id = cv_resale_batch_id
206: AND status_code = 'PROCESSED'
207: AND ( duplicated_line_id IS NULL
208: OR ( duplicated_line_id IS NOT NULL AND duplicated_adjustment_id = -1))

Line 384: UPDATE ozf_resale_lines_int_all

380: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
382: END IF;
383:
384: UPDATE ozf_resale_lines_int_all
385: SET bill_to_party_id = l_new_party_rec.party_id
386: , bill_to_party_site_id = l_new_party_rec.party_site_id
387: WHERE resale_batch_id = p_resale_batch_id
388: AND bill_to_party_id IS NULL

Line 439: UPDATE ozf_resale_lines_int_all

435: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
437: END IF;
438:
439: UPDATE ozf_resale_lines_int_all
440: SET end_cust_party_id = l_new_party_rec.party_id
441: , end_cust_party_site_id = l_new_party_rec.party_site_id
442: WHERE resale_batch_id = p_resale_batch_id
443: AND end_cust_party_id IS NULL

Line 503: UPDATE ozf_resale_lines_int_all

499:
500: -- There is something wrong with this order. dispute all the orders
501: -- and move to the next one.
502: -- JXWU move update to common pvt
503: UPDATE ozf_resale_lines_int_all
504: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
505: dispute_code = 'OZF_RESALE_MULTI_HEADER',
506: followup_action_code = 'C',
507: response_type = 'CA',

Line 581: UPDATE ozf_resale_lines_int

577: IF OZF_DEBUG_LOW_ON THEN
578: OZF_UTILITY_PVT.debug_message('Did NOT pass inventory checking');
579: END IF;
580: -- Here turn thIS line to DISPUTED AND create a dISput code FOR it.
581: UPDATE ozf_resale_lines_int
582: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
583: dispute_code = 'OZF_LT_INVT',
584: followup_action_code = 'C',
585: response_type = 'CA',

Line 828: UPDATE ozf_resale_lines_int

824: CLOSE claimed_amount_csr;
825:
826: BEGIN
827: -- BUG 4395931 (+)
828: UPDATE ozf_resale_lines_int
829: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_CLOSED
830: WHERE resale_batch_id = p_resale_batch_id
831: AND status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_PROCESSED;
832:

Line 835: UPDATE ozf_resale_lines_int

831: AND status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_PROCESSED;
832:
833: /*
834: -- SLKRISHN change to common procedure
835: UPDATE ozf_resale_lines_int
836: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_CLOSED
837: WHERE resale_batch_id = p_resale_batch_id
838: AND status_code in(OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DUPLICATED, OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_PROCESSED);
839: --AND duplicated_adjustment_id <> -1;

Line 958: FROM ozf_resale_lines_int_all

954: SELECT resale_line_int_id,
955: 'OZF_RESALE_PUR_PRICE_MISSING',
956: 'PURCHASE_PRICE',
957: NULL
958: FROM ozf_resale_lines_int_all
959: WHERE resale_batch_id = p_batch_id
960: AND status_code IN (OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN, OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED)
961: AND tracing_flag = 'F'
962: AND purchase_price IS NULL;

Line 1141: FROM ozf_resale_lines_int

1137: CURSOR order_identifiers_csr (p_id IN NUMBER) IS
1138: SELECT order_number
1139: , sold_from_cust_account_id
1140: , date_ordered
1141: FROM ozf_resale_lines_int
1142: WHERE resale_line_int_id = p_id;
1143:
1144: CURSOR func_currency_cd_csr IS
1145: SELECT gs.currency_code

Line 1155: FROM ozf_resale_lines_int

1151: CURSOR open_lines_csr(p_order_number VARCHAR2,
1152: p_date_ordered DATE,
1153: p_cust_account_id NUMBER )IS
1154: SELECT resale_line_int_id, 'OZF_RESALE_PRICE_ERROR', NULL, NULL
1155: FROM ozf_resale_lines_int
1156: WHERE status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN
1157: AND order_number = l_order_number
1158: AND date_ordered = l_date_ordered
1159: AND sold_from_cust_account_id =l_cust_account_id

Line 1201: update ozf_resale_lines_int

1197: IF OZF_DEBUG_LOW_ON THEN
1198: OZF_UTILITY_PVT.debug_message('line '||p_line_tbl(i).chargeback_int_id || ' has pricing error' );
1199: END IF;
1200: BEGIN
1201: update ozf_resale_lines_int
1202: set status_code =OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
1203: dispute_code = 'OZF_RESALE_PRICE_ERROR',
1204: followup_action_code = 'C',
1205: response_type = 'CA',

Line 1283: UPDATE ozf_resale_lines_int_all

1279: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1280: END IF;
1281:
1282: BEGIN
1283: UPDATE ozf_resale_lines_int_all
1284: SET status_code =OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
1285: dispute_code = 'OZF_RESALE_PRICE_ERROR',
1286: followup_action_code = 'C',
1287: response_type = 'CA',

Line 1367: UPDATE ozf_resale_lines_int

1363: END IF;
1364: --
1365: -- SET Batch as DISPUTED
1366: -- SLKRISHN change to common procedure
1367: UPDATE ozf_resale_lines_int
1368: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
1369: dispute_code = 'OZF_LT_INVT',
1370: followup_action_code = 'C',
1371: response_type = 'CA',

Line 1608: FROM ozf_resale_lines_int

1604: p_id IN NUMBER,
1605: p_date IN DATE,
1606: p_batch_id IN NUMBER ) IS
1607: SELECT *
1608: FROM ozf_resale_lines_int
1609: WHERE order_number = p_order_number
1610: AND sold_from_cust_account_id= p_id
1611: AND date_ordered = p_date
1612: AND status_code = 'OPEN'

Line 1630: FROM ozf_resale_lines_int

1626: p_id IN NUMBER,
1627: p_date IN DATE,
1628: p_batch_id IN NUMBER ) IS
1629: SELECT *
1630: FROM ozf_resale_lines_int
1631: WHERE order_number = p_order_number
1632: AND sold_from_cust_account_id= p_id
1633: AND date_ordered = p_date
1634: AND status_code = 'OPEN'

Line 1712: UPDATE ozf_resale_lines_int

1708: RAISE FND_API.g_exc_unexpected_error;
1709: END IF;
1710:
1711: -- Set line to DISPUTED
1712: UPDATE ozf_resale_lines_int
1713: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
1714: dispute_code = 'OZF_LT_INVT',
1715: followup_action_code = 'C',
1716: response_type = 'CA',

Line 2099: FROM ozf_resale_lines_int

2095: CURSOR order_num_csr IS
2096: SELECT DISTINCT order_number,
2097: sold_from_cust_account_id,
2098: date_ordered
2099: FROM ozf_resale_lines_int
2100: WHERE status_code = 'OPEN' --(OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN, OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DUPLICATED)
2101: AND resale_batch_id = p_resale_batch_id
2102: --AND (duplicated_adjustment_id IS NULL OR
2103: -- duplicated_adjustment_id = -1 )

Line 2333: UPDATE ozf_resale_lines_int

2329: OZF_UTILITY_PVT.debug_message('/*--- After process_pricing_result Insert resale log done ---*/');
2330: END IF;
2331:
2332: BEGIN
2333: UPDATE ozf_resale_lines_int
2334: SET status_code =OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
2335: dispute_code = 'OZF_PROC_PRIC_RESLT_ERR',
2336: followup_action_code = 'C',
2337: response_type = 'CA',

Line 2358: UPDATE ozf_resale_lines_int_all

2354: GOTO END_LOOP;
2355: END IF;
2356:
2357: -- Bug 4387465 (+)
2358: UPDATE ozf_resale_lines_int_all
2359: SET status_code= 'PROCESSED'
2360: WHERE status_code = 'OPEN'
2361: AND order_number = l_order_num_tbl(i)
2362: AND sold_from_cust_account_id = l_cust_account_id_tbl(i)