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_FUND_RECONCILE_PVT dependencies on OZF_OFFERS

Line 144: FROM ozf_offers off,qp_list_headers_b qp

140: p_end_date IN DATE) IS
141: SELECT qp_list_header_id object_id
142: ,nvl(transaction_currency_code,fund_request_curr_code) object_curr
143: --, qp.end_date_active object_date
144: FROM ozf_offers off,qp_list_headers_b qp
145: WHERE off.qp_list_header_id = qp.list_header_id
146: AND NVL (qp.end_date_active, p_grace_date) <= p_grace_date
147: AND status_code IN (p_status)
148: --AND offr.status_code IN ('CLOSED','COMPLETED','TERMINATED') -- inactive offers;

Line 262: FROM ozf_offers off,ozf_request_headers_all_b req

258: p_code IN VARCHAR2,
259: p_end_date IN DATE) IS
260: SELECT qp_list_header_id object_id
261: ,nvl(transaction_currency_code,fund_request_curr_code) object_curr
262: FROM ozf_offers off,ozf_request_headers_all_b req
263: WHERE off.qp_list_header_id = req.offer_id
264: AND req.request_class ='SOFT_FUND'
265: AND NVL (req.approved_date, p_grace_date) <= p_grace_date
266: AND req.status_code ='APPROVED'

Line 277: FROM ozf_offers off,ozf_request_headers_all_b req

273: p_code IN VARCHAR2,
274: p_end_date IN DATE) IS
275: SELECT qp_list_header_id object_id
276: ,nvl(transaction_currency_code,fund_request_curr_code) object_curr
277: FROM ozf_offers off,ozf_request_headers_all_b req
278: WHERE off.qp_list_header_id = req.offer_id
279: AND req.request_class ='SPECIAL_PRICE'
280: AND NVL (req.end_date, p_grace_date) <= p_grace_date
281: AND req.status_code ='APPROVED'

Line 554: UPDATE ozf_offers

550: SET accounts_closed_flag = 'Y'
551: WHERE campaign_id = l_object_tbl (k).object_id;
552: -- we do not need to check this for fund
553: ELSIF p_object_type = 'OFFR' THEN
554: UPDATE ozf_offers
555: SET account_closed_flag = 'Y'
556: WHERE qp_list_header_id = l_object_tbl (k).object_id;
557: ELSIF p_object_type = 'SOFT_FUND' THEN
558: UPDATE ozf_offers

Line 558: UPDATE ozf_offers

554: UPDATE ozf_offers
555: SET account_closed_flag = 'Y'
556: WHERE qp_list_header_id = l_object_tbl (k).object_id;
557: ELSIF p_object_type = 'SOFT_FUND' THEN
558: UPDATE ozf_offers
559: SET account_closed_flag = 'Y'
560: WHERE qp_list_header_id = l_object_tbl (k).object_id;
561: UPDATE ozf_request_headers_all_b
562: SET status_code = 'CLOSED'

Line 565: UPDATE ozf_offers

561: UPDATE ozf_request_headers_all_b
562: SET status_code = 'CLOSED'
563: WHERE offer_id = l_object_tbl (k).object_id;
564: ELSIF p_object_type = 'SPECIAL_PRICE' THEN
565: UPDATE ozf_offers
566: SET account_closed_flag = 'Y'
567: WHERE qp_list_header_id = l_object_tbl (k).object_id;
568: UPDATE ozf_request_headers_all_b
569: SET status_code = 'CLOSED'

Line 661: FROM ozf_offers offr,ams_campaigns_all_b camp

657:
658: -- used to get parent_id, parent currency, and source from parent flag.
659: CURSOR c_offer_data(p_offer_id IN NUMBER) IS
660: SELECT offr.budget_source_id,NVL(offr.source_from_parent,'N'),camp.transaction_currency_code
661: FROM ozf_offers offr,ams_campaigns_all_b camp
662: WHERE offr.qp_list_header_id = p_offer_id
663: AND camp.campaign_id = offr.budget_source_id;
664:
665: CURSOR c_schedule_data(p_schedule_id IN NUMBER) IS

Line 690: FROM ozf_offers off

686: AND object_type = p_budget_used_by_type;
687:
688: CURSOR c_offr_reusable IS
689: SELECT count(*)
690: FROM ozf_offers off
691: WHERE off.qp_list_header_id = p_budget_used_by_id
692: AND off.reusable = 'Y' ;
693:
694: CURSOR c_offr_source IS

Line 696: FROM ozf_offers off,ozf_act_offers act

692: AND off.reusable = 'Y' ;
693:
694: CURSOR c_offr_source IS
695: SELECT count(activity_offer_id)
696: FROM ozf_offers off,ozf_act_offers act
697: WHERE off.qp_list_header_id = p_budget_used_by_id
698: AND off.reusable = 'N'
699: AND off.qp_list_header_id = act.qp_list_header_id ;
700:

Line 1083: TYPE listHeaderIdTbl IS TABLE OF ozf_offers.qp_list_header_id%TYPE;

1079: l_commit BOOLEAN := TRUE;
1080: l_last_flag BOOLEAN := FALSE;
1081: l_remaining_amt NUMBER;
1082:
1083: TYPE listHeaderIdTbl IS TABLE OF ozf_offers.qp_list_header_id%TYPE;
1084: TYPE transCurrCodeTbl IS TABLE OF ozf_offers.transaction_currency_code%TYPE;
1085: TYPE lastRecalDateTbl IS TABLE OF ozf_offers.last_recal_date%TYPE;
1086: TYPE startDateTbl IS TABLE OF qp_list_headers_b.start_date_active%TYPE;
1087: TYPE endDateTbl IS TABLE OF qp_list_headers_b.end_date_active%TYPE;

Line 1084: TYPE transCurrCodeTbl IS TABLE OF ozf_offers.transaction_currency_code%TYPE;

1080: l_last_flag BOOLEAN := FALSE;
1081: l_remaining_amt NUMBER;
1082:
1083: TYPE listHeaderIdTbl IS TABLE OF ozf_offers.qp_list_header_id%TYPE;
1084: TYPE transCurrCodeTbl IS TABLE OF ozf_offers.transaction_currency_code%TYPE;
1085: TYPE lastRecalDateTbl IS TABLE OF ozf_offers.last_recal_date%TYPE;
1086: TYPE startDateTbl IS TABLE OF qp_list_headers_b.start_date_active%TYPE;
1087: TYPE endDateTbl IS TABLE OF qp_list_headers_b.end_date_active%TYPE;
1088: l_listHeaderIdTbl listHeaderIdTbl;

Line 1085: TYPE lastRecalDateTbl IS TABLE OF ozf_offers.last_recal_date%TYPE;

1081: l_remaining_amt NUMBER;
1082:
1083: TYPE listHeaderIdTbl IS TABLE OF ozf_offers.qp_list_header_id%TYPE;
1084: TYPE transCurrCodeTbl IS TABLE OF ozf_offers.transaction_currency_code%TYPE;
1085: TYPE lastRecalDateTbl IS TABLE OF ozf_offers.last_recal_date%TYPE;
1086: TYPE startDateTbl IS TABLE OF qp_list_headers_b.start_date_active%TYPE;
1087: TYPE endDateTbl IS TABLE OF qp_list_headers_b.end_date_active%TYPE;
1088: l_listHeaderIdTbl listHeaderIdTbl;
1089: l_transCurrCodeTbl transCurrCodeTbl;

Line 1101: FROM ozf_offers offs, qp_list_headers_b qpl

1097: ,qpl.start_date_active start_date_active
1098: ,qpl.end_date_active end_date_active
1099: ,NVL(offs.last_recal_date,qpl.start_date_active) last_recal_date -- changed to new column for last recal date
1100: --,qpl.description description
1101: FROM ozf_offers offs, qp_list_headers_b qpl
1102: WHERE offs.offer_type NOT IN ('LUMPSUM', 'TERMS','SCAN_DATA')
1103: AND offs.status_code = 'ACTIVE'
1104: AND NVL (offs.account_closed_flag, 'N') = 'N'
1105: AND offs.qp_list_header_id = qpl.list_header_id(+)

Line 1481: UPDATE ozf_offers

1477: l_count := 0;
1478:
1479: -- update ozf_offer's last recal column with l_period_start_date - 1 which is last period end day.
1480: IF l_act_budget_id is not null THEN
1481: UPDATE ozf_offers
1482: SET last_recal_date = l_period_start_date
1483: WHERE qp_list_header_id = l_listHeaderIdTbl(i);
1484: END IF;
1485:

Line 1568: FROM qp_list_headers_b qpoffr, ozf_offers offr

1564:
1565: CURSOR c_offer_rec IS
1566: SELECT offr.qp_list_header_id offer_id,offr.offer_type
1567: ,offr.transaction_currency_code offer_curr
1568: FROM qp_list_headers_b qpoffr, ozf_offers offr
1569: WHERE offr.qp_list_header_id = qpoffr.list_header_id
1570: AND offr.status_code IN ('ACTIVE')
1571: AND offr.offer_type IN ('LUMPSUM', 'SCAN_DATA')
1572: AND NVL (offr.account_closed_flag, 'N') = 'N'

Line 2224: FROM ozf_offers

2220: WHERE deliverable_id = p_object_id;
2221:
2222: CURSOR c_offer(p_object_id IN NUMBER) IS
2223: SELECT status_code
2224: FROM ozf_offers
2225: WHERE qp_list_header_id = p_object_id;
2226:
2227: l_old_fund_obj c_get_old_fund_obj%ROWTYPE;
2228: