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 141: FROM ozf_offers off,qp_list_headers_b qp

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

Line 259: FROM ozf_offers off,ozf_request_headers_all_b req

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

Line 274: FROM ozf_offers off,ozf_request_headers_all_b req

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

Line 551: UPDATE ozf_offers

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

Line 555: UPDATE ozf_offers

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

Line 562: UPDATE ozf_offers

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

Line 658: FROM ozf_offers offr,ams_campaigns_all_b camp

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

Line 687: FROM ozf_offers off

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

Line 693: FROM ozf_offers off,ozf_act_offers act

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

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

1066: l_commit BOOLEAN := TRUE;
1067: l_last_flag BOOLEAN := FALSE;
1068: l_remaining_amt NUMBER;
1069:
1070: TYPE listHeaderIdTbl IS TABLE OF ozf_offers.qp_list_header_id%TYPE;
1071: TYPE transCurrCodeTbl IS TABLE OF ozf_offers.transaction_currency_code%TYPE;
1072: TYPE lastRecalDateTbl IS TABLE OF ozf_offers.last_recal_date%TYPE;
1073: TYPE startDateTbl IS TABLE OF qp_list_headers_b.start_date_active%TYPE;
1074: TYPE endDateTbl IS TABLE OF qp_list_headers_b.end_date_active%TYPE;

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

1067: l_last_flag BOOLEAN := FALSE;
1068: l_remaining_amt NUMBER;
1069:
1070: TYPE listHeaderIdTbl IS TABLE OF ozf_offers.qp_list_header_id%TYPE;
1071: TYPE transCurrCodeTbl IS TABLE OF ozf_offers.transaction_currency_code%TYPE;
1072: TYPE lastRecalDateTbl IS TABLE OF ozf_offers.last_recal_date%TYPE;
1073: TYPE startDateTbl IS TABLE OF qp_list_headers_b.start_date_active%TYPE;
1074: TYPE endDateTbl IS TABLE OF qp_list_headers_b.end_date_active%TYPE;
1075: l_listHeaderIdTbl listHeaderIdTbl;

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

1068: l_remaining_amt NUMBER;
1069:
1070: TYPE listHeaderIdTbl IS TABLE OF ozf_offers.qp_list_header_id%TYPE;
1071: TYPE transCurrCodeTbl IS TABLE OF ozf_offers.transaction_currency_code%TYPE;
1072: TYPE lastRecalDateTbl IS TABLE OF ozf_offers.last_recal_date%TYPE;
1073: TYPE startDateTbl IS TABLE OF qp_list_headers_b.start_date_active%TYPE;
1074: TYPE endDateTbl IS TABLE OF qp_list_headers_b.end_date_active%TYPE;
1075: l_listHeaderIdTbl listHeaderIdTbl;
1076: l_transCurrCodeTbl transCurrCodeTbl;

Line 1088: FROM ozf_offers offs, qp_list_headers_b qpl

1084: ,qpl.start_date_active start_date_active
1085: ,qpl.end_date_active end_date_active
1086: ,NVL(offs.last_recal_date,qpl.start_date_active) last_recal_date -- changed to new column for last recal date
1087: --,qpl.description description
1088: FROM ozf_offers offs, qp_list_headers_b qpl
1089: WHERE offs.offer_type NOT IN ('LUMPSUM', 'TERMS','SCAN_DATA')
1090: AND offs.status_code = 'ACTIVE'
1091: AND NVL (offs.account_closed_flag, 'N') = 'N'
1092: AND offs.qp_list_header_id = qpl.list_header_id(+)

Line 1468: UPDATE ozf_offers

1464: l_count := 0;
1465:
1466: -- update ozf_offer's last recal column with l_period_start_date - 1 which is last period end day.
1467: IF l_act_budget_id is not null THEN
1468: UPDATE ozf_offers
1469: SET last_recal_date = l_period_start_date
1470: WHERE qp_list_header_id = l_listHeaderIdTbl(i);
1471: END IF;
1472:

Line 1555: FROM qp_list_headers_b qpoffr, ozf_offers offr

1551:
1552: CURSOR c_offer_rec IS
1553: SELECT offr.qp_list_header_id offer_id,offr.offer_type
1554: ,offr.transaction_currency_code offer_curr
1555: FROM qp_list_headers_b qpoffr, ozf_offers offr
1556: WHERE offr.qp_list_header_id = qpoffr.list_header_id
1557: AND offr.status_code IN ('ACTIVE')
1558: AND offr.offer_type IN ('LUMPSUM', 'SCAN_DATA')
1559: AND NVL (offr.account_closed_flag, 'N') = 'N'

Line 2176: FROM ozf_offers

2172: WHERE deliverable_id = p_object_id;
2173:
2174: CURSOR c_offer(p_object_id IN NUMBER) IS
2175: SELECT status_code
2176: FROM ozf_offers
2177: WHERE qp_list_header_id = p_object_id;
2178:
2179: l_old_fund_obj c_get_old_fund_obj%ROWTYPE;
2180: