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 688: -- 15-Jun-2001 choang Changed OFFR to return ozf_offers and qp_list_header_id.

684: -- 06-Apr-2001 choang Added DIWB, MODL and SCOR in get_qual_table_name_and_pk
685: -- added error message if no valid sys_qual mapped.
686: -- 09-Apr-2001 choang added CELL
687: -- 13-Jun-2001 ptendulk Added EONE
688: -- 15-Jun-2001 choang Changed OFFR to return ozf_offers and qp_list_header_id.
689: ---------------------------------------------------------------------
690: PROCEDURE get_qual_table_name_and_pk(
691: p_sys_qual IN VARCHAR2,
692: x_return_status OUT NOCOPY VARCHAR2,

Line 733: x_table_name := 'OZF_OFFERS';

729: --=========================================================
730: -- Following line of code is added by ptendulk on 14Jun2000
731: --=========================================================
732: ELSIF (p_sys_qual ='OFFR') THEN --added tdonohoe 04/24/2000
733: x_table_name := 'OZF_OFFERS';
734: x_pk_name := 'QP_LIST_HEADER_ID';
735: ELSIF (p_sys_qual ='FCST') THEN --added tdonohoe 04/24/2000
736: x_table_name := 'OZF_ACT_FORECASTS_ALL';
737: x_pk_name := 'FORECAST_ID';

Line 2418: FROM ozf_offers

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