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

Line 705: -- 15-Jun-2001 choang Changed OFFR to return ozf_offers and qp_list_header_id.

701: -- 06-Apr-2001 choang Added DIWB, MODL and SCOR in get_qual_table_name_and_pk
702: -- added error message if no valid sys_qual mapped.
703: -- 09-Apr-2001 choang added CELL
704: -- 13-Jun-2001 ptendulk Added EONE
705: -- 15-Jun-2001 choang Changed OFFR to return ozf_offers and qp_list_header_id.
706: ---------------------------------------------------------------------
707: PROCEDURE get_qual_table_name_and_pk(
708: p_sys_qual IN VARCHAR2,
709: x_return_status OUT NOCOPY VARCHAR2,

Line 750: x_table_name := 'OZF_OFFERS';

746: --=========================================================
747: -- Following line of code is added by ptendulk on 14Jun2000
748: --=========================================================
749: ELSIF (p_sys_qual ='OFFR') THEN --added tdonohoe 04/24/2000
750: x_table_name := 'OZF_OFFERS';
751: x_pk_name := 'QP_LIST_HEADER_ID';
752: ELSIF (p_sys_qual ='FCST') THEN --added tdonohoe 04/24/2000
753: x_table_name := 'OZF_ACT_FORECASTS_ALL';
754: x_pk_name := 'FORECAST_ID';

Line 2417: FROM ozf_offers

2413:
2414: -- Cursor to get the org_id for offer
2415: CURSOR c_offer_org_id (p_list_header_id IN NUMBER)IS
2416: SELECT org_id
2417: FROM ozf_offers
2418: WHERE qp_list_header_id = p_list_header_id;
2419:
2420: -- Cursor to get the org_id for pric
2421: CURSOR c_pric_org_id (p_list_header_id IN NUMBER)IS