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_LINES_INT_ALL

Line 351: FROM ozf_resale_lines_int_all b

347: FND_MESSAGE.get_string('OZF','OZF_RESALE_SELL_PRICE_NULL'),
348: 'SELLING_PRICE',
349: NULL,
350: org_id
351: FROM ozf_resale_lines_int_all b
352: WHERE b.status_code = 'OPEN'
353: AND b.direct_customer_flag = 'T'
354: AND b.selling_price IS NULL
355: AND b.resale_batch_id = p_resale_batch_id

Line 370: UPDATE ozf_resale_lines_int_all

366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
367: END;
368:
369: BEGIN
370: UPDATE ozf_resale_lines_int_all
371: SET status_code = 'DISPUTED',
372: dispute_code = 'OZF_RESALE_SELL_PRICE_NULL'
373: WHERE status_code = 'OPEN'
374: AND direct_customer_flag = 'T'

Line 1633: FROM ozf_resale_lines_int_all

1629: CURSOR order_identifiers_csr (p_id IN NUMBER) IS
1630: SELECT order_number
1631: , bill_to_cust_account_id
1632: , date_ordered
1633: FROM ozf_resale_lines_int_all
1634: WHERE resale_line_int_id = p_id;
1635:
1636: CURSOR resale_info_csr (p_id IN NUMBER) IS
1637: SELECT resale_header_id

Line 1688: FROM ozf_resale_lines_int_all

1684: , p_cust_id IN NUMBER
1685: , p_date IN DATE
1686: ) IS
1687: SELECT 1
1688: FROM ozf_resale_lines_int_all
1689: WHERE resale_batch_id = p_id
1690: AND order_number = p_order_number
1691: AND bill_to_cust_account_id = p_cust_id
1692: AND date_ordered = p_date

Line 1710: , ozf_resale_lines_int_all b

1706: , p_date IN DATE
1707: ) IS
1708: SELECT a.resale_header_id
1709: FROM ozf_resale_headers_all a
1710: , ozf_resale_lines_int_all b
1711: , ozf_resale_lines_all c
1712: WHERE b.resale_batch_id = p_id
1713: AND b.order_number = p_order_number
1714: AND b.bill_to_cust_account_id = p_cust_id

Line 1801: UPDATE ozf_resale_lines_int_all

1797: -- IF there is an error for a line or lines, we need to UPDATE the whole order as error;
1798: -- nothing to UPDATE if it's FROM line.
1799: IF p_caller_type = 'IFACE' THEN
1800: BEGIN
1801: UPDATE ozf_resale_lines_int_all
1802: SET status_code = 'DISPUTED'
1803: WHERE status_code = 'OPEN'
1804: AND order_NUMBER = l_order_number
1805: AND bill_to_cust_account_id = l_cust_account_id

Line 1999: UPDATE ozf_resale_lines_int_all

1995: RAISE FND_API.g_exc_unexpected_error;
1996: END IF;
1997:
1998: -- Delink resale interface line from batch
1999: UPDATE ozf_resale_lines_int_all
2000: SET resale_batch_id = null,
2001: request_id = null,
2002: status_code = 'DISPUTED',
2003: dispute_code = 'OZF_LT_INVT'

Line 2167: UPDATE ozf_resale_lines_int_all

2163: -- drop this line from batch if it is from interface
2164: -- Fux for bug Bug 14584673 : Added exception block at the end of the loop to log all type of errors at one place.
2165: /* IF p_caller_type = 'IFACE' THEN
2166: BEGIN
2167: UPDATE ozf_resale_lines_int_all
2168: SET resale_batch_id = NULL,
2169: request_id = NULL,
2170: status_code = 'DISPUTED',
2171: dispute_code = 'OZF_PRIC_RESULT_ERR'

Line 2183: UPDATE ozf_resale_lines_int_all

2179: ELSE
2180: -- CLOSE THIS LINE If it is from interface
2181: IF p_caller_type = 'IFACE' THEN
2182: BEGIN
2183: UPDATE ozf_resale_lines_int_all
2184: SET status_code= 'CLOSED'
2185: WHERE resale_line_int_id = p_line_tbl(i).chargeback_int_id;
2186: EXCEPTION
2187: WHEN OTHERS THEN

Line 2219: UPDATE ozf_resale_lines_int_all

2215: RAISE FND_API.g_exc_unexpected_error;
2216: END IF;
2217: IF p_run_mode <> 'DRAFT' THEN
2218: -- Delink resale interface line from batch
2219: UPDATE ozf_resale_lines_int_all
2220: SET resale_batch_id = null,
2221: request_id = null,
2222: status_code = 'DISPUTED',
2223: dispute_code = l_dispute_code

Line 2226: UPDATE ozf_resale_lines_int_all

2222: status_code = 'DISPUTED',
2223: dispute_code = l_dispute_code
2224: WHERE resale_line_int_id = l_resale_int_rec.resale_line_int_id;
2225: ELSE
2226: UPDATE ozf_resale_lines_int_all
2227: SET status_code = 'DISPUTED',
2228: dispute_code = l_dispute_code
2229: WHERE resale_line_int_id = l_resale_int_rec.resale_line_int_id;
2230: END IF;

Line 3352: FROM ozf_resale_lines_int_all b

3348: DELETE FROM ozf_resale_logs_all a
3349: WHERE a.resale_id_type = 'IFACE'
3350: AND a.resale_id IN (
3351: SELECT resale_line_int_id
3352: FROM ozf_resale_lines_int_all b
3353: WHERE b.direct_customer_flag = 'F'
3354: AND b.status_code = 'OPEN'
3355: AND b.order_number = l_order_num_tbl(i).order_number
3356: AND b.bill_to_cust_account_id = l_order_num_tbl(i).bill_to_cust_account_id

Line 3496: FROM ozf_resale_lines_int_all

3492: CURSOR order_num_csr IS
3493: SELECT DISTINCT order_NUMBER,
3494: bill_to_cust_account_id,
3495: date_ordered
3496: FROM ozf_resale_lines_int_all
3497: WHERE status_code IN ('OPEN', 'DUPLICATED')
3498: AND duplicated_adjustment_id IS NULL
3499: AND resale_batch_id = p_resale_batch_id
3500: AND direct_customer_flag <> 'F' -- TPA in DRAFT mode ER : will pick up only the direct customer orders

Line 3513: FROM ozf_resale_lines_int_all

3509: p_id IN NUMBER,
3510: p_date IN DATE
3511: ) IS
3512: SELECT *
3513: FROM ozf_resale_lines_int_all
3514: WHERE order_number = p_order_number
3515: AND bill_to_cust_account_id= p_id
3516: AND date_ordered = p_date
3517: AND status_code IN ('OPEN', 'DUPLICATED')

Line 3551: FROM ozf_resale_lines_int_all

3547: p_id IN NUMBER,
3548: p_date IN DATE
3549: ) IS
3550: SELECT *
3551: FROM ozf_resale_lines_int_all
3552: WHERE order_number = p_order_number
3553: AND bill_to_cust_account_id = p_id
3554: AND date_ordered = p_date
3555: AND status_code = 'DUPLICATED'

Line 3565: FROM ozf_resale_lines_int_all

3561: p_id IN NUMBER,
3562: p_date IN DATE
3563: ) IS
3564: SELECT *
3565: FROM ozf_resale_lines_int_all
3566: WHERE order_number = p_order_number -- ?? need this
3567: AND bill_to_cust_account_id = p_id -- ?? need this
3568: AND date_ordered = p_date
3569: AND status_code IN ('OPEN', 'DUPLICATED')

Line 3576: FROM ozf_resale_lines_int_all

3572:
3573: -- [BEGIN OF BUG 4233341 FIXING]
3574: CURSOR csr_valid_line_count(cv_batch_id IN NUMBER) IS
3575: SELECT COUNT(1)
3576: FROM ozf_resale_lines_int_all
3577: WHERE status_code IN ('PROCESSED', 'CLOSED', 'DUPLICATED')
3578: AND resale_batch_id = cv_batch_id;
3579:
3580: CURSOR csr_get_batch_number(cv_batch_id IN NUMBER) IS

Line 3595: FROM ozf_resale_lines_int_all i

3591: , lk.meaning dispute_code
3592: , lg.error_message
3593: , lg.column_name
3594: , lg.column_value
3595: FROM ozf_resale_lines_int_all i
3596: , ozf_resale_logs_all lg
3597: , ozf_lookups lk
3598: WHERE i.dispute_code = lk.lookup_code(+)
3599: AND lk.lookup_type(+) = 'OZF_RESALE_DISPUTE_CODE'

Line 3610: FROM ozf_resale_lines_int_all i

3606: CURSOR csr_out_duplicate_pre_proc(cv_batch_id IN NUMBER) IS
3607: SELECT i.resale_line_int_id id
3608: , DECODE(lg.column_value,'-1', 'RESALE_LINE_INT_ID', '-2', 'RESALE_LINE_ID') column_name
3609: , i.duplicated_line_id column_value
3610: FROM ozf_resale_lines_int_all i
3611: , ozf_resale_logs_all lg
3612: WHERE i.status_code = 'DUPLICATED'
3613: AND i.resale_batch_id = cv_batch_id
3614: AND i.resale_line_int_id = lg.resale_id

Line 3873: UPDATE ozf_resale_lines_int_all

3869: l_order_num_tbl(i).bill_to_cust_account_id IS NOT NULL AND
3870: l_order_num_tbl(i).date_ordered IS NOT NULL THEN
3871:
3872: -- UPDATE tracing order lines to processed for this order to be processed
3873: UPDATE ozf_resale_lines_int_all
3874: SET status_code= 'PROCESSED'
3875: WHERE status_code = 'OPEN'
3876: AND order_number = l_order_num_tbl(i).order_number
3877: AND bill_to_cust_account_id = l_order_num_tbl(i).bill_to_cust_account_id

Line 4270: UPDATE ozf_resale_lines_int_all

4266: END;
4267: END LOOP;
4268:
4269: BEGIN
4270: UPDATE ozf_resale_lines_int_all
4271: SET status_code = 'DISPUTED'
4272: WHERE status_code = 'OPEN'
4273: AND order_number = l_order_num_tbl(i).order_number
4274: AND bill_to_cust_account_id = l_order_num_tbl(i).bill_to_cust_account_id

Line 4543: UPDATE ozf_resale_lines_int_all

4539: IF l_run_mode <> 'DRAFT' THEN
4540:
4541: -- [BEGIN OF BUG 4233341 FIXING]
4542: -- delink all the new/processed/disputed lines
4543: UPDATE ozf_resale_lines_int_all
4544: SET resale_batch_id = null
4545: , request_id = null
4546: WHERE resale_batch_id = p_resale_batch_id
4547: AND status_code IN ('NEW', 'OPEN', 'DISPUTED'); -- 'PROCESSED'

Line 4757: FROM ozf_resale_lines_int_all

4753: CURSOR start_end_date_csr( p_account_id NUMBER,
4754: p_org_id NUMBER,
4755: p_currency_code VARCHAR2) IS
4756: SELECT MIN(date_ordered), MAX(date_ordered)
4757: FROM ozf_resale_lines_int_all
4758: WHERE sold_from_cust_account_id = p_account_id
4759: AND request_id = FND_GLOBAL.CONC_REQUEST_ID
4760: AND org_id = p_org_id
4761: AND currency_code = p_currency_code;

Line 4773: SELECT resale_line_int_id FROM OZF_RESALE_LINES_INT_ALL_TEMP ;

4769:
4770: -- TPA iN Draft Mode - start
4771: -- Fix for Bug 14584673
4772: /*CURSOR csr_resale_lines_int_tmp_dtls IS
4773: SELECT resale_line_int_id FROM OZF_RESALE_LINES_INT_ALL_TEMP ;
4774: l_resale_line_int_id_tbl OZF_RESALE_COMMON_PVT.number_tbl_type; */
4775:
4776: l_status VARCHAR2(5);
4777: l_industry VARCHAR2(5);

Line 4811: SELECT COUNT(*) FROM ozf_resale_lines_int_all

4807: l_resale_logs_tbl l_resale_logs_tbl_type;
4808:
4809: -- nepanda : Fix for bug # 15900683 : cursor to find out number of lines being fetched for an org id
4810: CURSOR csr_processed_lines_count IS
4811: SELECT COUNT(*) FROM ozf_resale_lines_int_all
4812: WHERE REQUEST_ID = G_CONC_REQUEST_ID
4813: AND ORG_ID = l_org_id ;
4814:
4815: l_processed_lines_count NUMBER;

Line 4870: UPDATE ozf_resale_lines_int_all

4866: ozf_utility_PVT.debug_message('source code is '|| p_data_source_code||', id:' || FND_GLOBAL.CONC_REQUEST_ID );
4867: END IF;
4868: END IF;
4869:
4870: UPDATE ozf_resale_lines_int_all
4871: SET request_id = G_CONC_REQUEST_ID
4872: , dispute_code = null
4873: , program_application_id = FND_GLOBAL.PROG_APPL_ID
4874: , program_update_date = SYSDATE

Line 4885: UPDATE ozf_resale_lines_int_all

4881: IF OZF_DEBUG_LOW_ON THEN
4882: ozf_utility_PVT.debug_message('source code is '|| p_data_source_code||', id:' || FND_GLOBAL.CONC_REQUEST_ID );
4883: END IF;
4884:
4885: UPDATE ozf_resale_lines_int_all
4886: SET request_id = G_CONC_REQUEST_ID
4887: , dispute_code = null
4888: , program_application_id = FND_GLOBAL.PROG_APPL_ID
4889: , program_update_date = SYSDATE

Line 5057: UPDATE ozf_resale_lines_int_all orli

5053: l_batch_tbl(i) := l_resale_batch_id;
5054: l_sold_from_cust_name_tbl(i) := l_party_name;
5055: i := i +1;
5056:
5057: UPDATE ozf_resale_lines_int_all orli
5058: SET resale_batch_id = l_resale_batch_id
5059: WHERE orli.sold_from_cust_account_id = l_sold_from_cust_id_tbl(j)
5060: AND orli.org_id = l_org_id_tbl(j)
5061: AND orli.currency_code = l_currency_code_tbl(j)

Line 5090: -- Bug 14194884 - TPA In Draft Mode ER : start : Updating OZF_RESALE_LINES_INT_ALL table with the records populated in OZF_RESALE_LINES_INT_ALL_TEMP table except for STATUS_CODE

5086: END IF;
5087: END LOOP;
5088: END IF; -- END if l_batch_tbl.EXISTS
5089:
5090: -- Bug 14194884 - TPA In Draft Mode ER : start : Updating OZF_RESALE_LINES_INT_ALL table with the records populated in OZF_RESALE_LINES_INT_ALL_TEMP table except for STATUS_CODE
5091: IF l_run_mode = 'DRAFT' THEN
5092: -- Inserting data into OZF_RESALE_LINES_INT_DRAFT_ALL for the request_id
5093: INSERT INTO OZF_RESALE_LINES_INT_DRAFT_ALL
5094: ( RESALE_LINES_INT_DRAFT_ID,

Line 5560: FROM OZF_RESALE_LINES_INT_ALL

5556: INVOICE_LINE_NUMBER, -- INVOICE_LINE_NUMBER
5557: ORDER_LINE_NUMBER, -- ORDER_LINE_NUMBER
5558: SUPPLIER_ITEM_COST, -- SUPPLIER_ITEM_COST
5559: SUPPLIER_ITEM_UOM -- SUPPLIER_ITEM_UOM
5560: FROM OZF_RESALE_LINES_INT_ALL
5561: WHERE REQUEST_ID = G_CONC_REQUEST_ID
5562: AND ORG_ID = l_org_id -- nepanda : Fix for bug # 15900683
5563: );
5564:

Line 5581: UPDATE ozf_resale_lines_int_all

5577: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Please check OZF_FUNDS_UTILIZED_DRAFT_ALL, OZF_RESALE_DRAFT_LOGS_ALL and OZF_RESALE_LINES_INT_DRAFT_ALL tables for accrual details ');
5578: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
5579:
5580: -- Fix for Bug 14584673
5581: UPDATE ozf_resale_lines_int_all
5582: SET request_id = null, resale_batch_id = null
5583: WHERE REQUEST_ID = G_CONC_REQUEST_ID
5584: AND ORG_ID = l_org_id ; -- nepanda : Fix for bug # 15900683
5585: