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.

[Home] [Help]

APPS.OZF_ADJUSTMENT_EXT_PVT dependencies on OZF_OFFER_ADJUSTMENTS_B

Line 1728: FROM ozf_offer_adjustments_b

1724: SELECT offer_adjustment_id,
1725: list_header_id,
1726: effective_date,
1727: approved_date
1728: FROM ozf_offer_adjustments_b
1729: WHERE status_code = 'ACTIVE'
1730: AND NVL(budget_adjusted_flag,'N') = 'N'
1731: AND effective_date < approved_date; --query only backdated adjustments
1732:

Line 1760: TYPE offerAdjustmentIdTbl IS TABLE OF ozf_offer_adjustments_b.offer_adjustment_id%TYPE;

1756: l_adjusted_line_cur c_adjusted_line_cur%ROWTYPE;
1757: l_end_date DATE;
1758: l_type VARCHAR2(7) := NULL;
1759:
1760: TYPE offerAdjustmentIdTbl IS TABLE OF ozf_offer_adjustments_b.offer_adjustment_id%TYPE;
1761: TYPE listHeaderIdTbl IS TABLE OF ozf_offer_adjustments_b.list_header_id%TYPE;
1762: TYPE effectiveDateTbl IS TABLE OF ozf_offer_adjustments_b.effective_date%TYPE;
1763: TYPE approvedDateTbl IS TABLE OF ozf_offer_adjustments_b.approved_date%TYPE;
1764:

Line 1761: TYPE listHeaderIdTbl IS TABLE OF ozf_offer_adjustments_b.list_header_id%TYPE;

1757: l_end_date DATE;
1758: l_type VARCHAR2(7) := NULL;
1759:
1760: TYPE offerAdjustmentIdTbl IS TABLE OF ozf_offer_adjustments_b.offer_adjustment_id%TYPE;
1761: TYPE listHeaderIdTbl IS TABLE OF ozf_offer_adjustments_b.list_header_id%TYPE;
1762: TYPE effectiveDateTbl IS TABLE OF ozf_offer_adjustments_b.effective_date%TYPE;
1763: TYPE approvedDateTbl IS TABLE OF ozf_offer_adjustments_b.approved_date%TYPE;
1764:
1765: l_offerAdjustmentIdTbl offerAdjustmentIdTbl;

Line 1762: TYPE effectiveDateTbl IS TABLE OF ozf_offer_adjustments_b.effective_date%TYPE;

1758: l_type VARCHAR2(7) := NULL;
1759:
1760: TYPE offerAdjustmentIdTbl IS TABLE OF ozf_offer_adjustments_b.offer_adjustment_id%TYPE;
1761: TYPE listHeaderIdTbl IS TABLE OF ozf_offer_adjustments_b.list_header_id%TYPE;
1762: TYPE effectiveDateTbl IS TABLE OF ozf_offer_adjustments_b.effective_date%TYPE;
1763: TYPE approvedDateTbl IS TABLE OF ozf_offer_adjustments_b.approved_date%TYPE;
1764:
1765: l_offerAdjustmentIdTbl offerAdjustmentIdTbl;
1766: l_listHeaderIdTbl listHeaderIdTbl;

Line 1763: TYPE approvedDateTbl IS TABLE OF ozf_offer_adjustments_b.approved_date%TYPE;

1759:
1760: TYPE offerAdjustmentIdTbl IS TABLE OF ozf_offer_adjustments_b.offer_adjustment_id%TYPE;
1761: TYPE listHeaderIdTbl IS TABLE OF ozf_offer_adjustments_b.list_header_id%TYPE;
1762: TYPE effectiveDateTbl IS TABLE OF ozf_offer_adjustments_b.effective_date%TYPE;
1763: TYPE approvedDateTbl IS TABLE OF ozf_offer_adjustments_b.approved_date%TYPE;
1764:
1765: l_offerAdjustmentIdTbl offerAdjustmentIdTbl;
1766: l_listHeaderIdTbl listHeaderIdTbl;
1767: l_effectiveDateTbl effectiveDateTbl;

Line 2008: UPDATE ozf_offer_adjustments_b

2004: ozf_utility_pvt.write_conc_log ('after calling volume_offer_adjustment: ' || l_return_status);
2005:
2006: END IF; -- l_offer_info.offer_type = 'VOLUME_OFFER' THEN
2007:
2008: UPDATE ozf_offer_adjustments_b
2009: SET budget_adjusted_flag = 'Y',
2010: object_version_number = object_version_number + 1,
2011: status_code = 'CLOSED'
2012: WHERE offer_adjustment_id = l_offerAdjustmentIdTbl(i);