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.PQH_TCT_BUS dependencies on PQH_TABLE_ROUTE

Line 111: from pqh_table_route a

107: l_dummy varchar2(1);
108: --
109: cursor c1 is
110: select null
111: from pqh_table_route a
112: where a.table_route_id = p_consolidated_table_route_id;
113: --
114: Begin
115: --

Line 127: -- check if consolidated_table_route_id value exists in pqh_table_route table

123: and nvl(p_consolidated_table_route_id,hr_api.g_number)
124: <> nvl(pqh_tct_shd.g_old_rec.consolidated_table_route_id,hr_api.g_number)
125: or not l_api_updating) then
126: --
127: -- check if consolidated_table_route_id value exists in pqh_table_route table
128: --
129: open c1;
130: --
131: fetch c1 into l_dummy;

Line 136: -- raise error as FK does not relate to PK in pqh_table_route

132: if c1%notfound then
133: --
134: close c1;
135: --
136: -- raise error as FK does not relate to PK in pqh_table_route
137: -- table.
138: --
139: pqh_tct_shd.constraint_error('PQH_TRANSACTION_CATEGORIES_FK1');
140: --

Line 187: from pqh_table_route a

183: l_dummy varchar2(1);
184: --
185: cursor c1 is
186: select null
187: from pqh_table_route a
188: where a.table_route_id = p_master_table_route_id;
189: --
190: Begin
191: --

Line 204: -- check if master_table_route_id value exists in pqh_table_route table

200: <> nvl(pqh_tct_shd.g_old_rec.master_table_route_id,hr_api.g_number)
201: or not l_api_updating)
202: and p_master_table_route_id IS NOT NULL then
203: --
204: -- check if master_table_route_id value exists in pqh_table_route table
205: --
206: open c1;
207: --
208: fetch c1 into l_dummy;

Line 213: -- raise error as FK does not relate to PK in pqh_table_route

209: if c1%notfound then
210: --
211: close c1;
212: --
213: -- raise error as FK does not relate to PK in pqh_table_route
214: -- table.
215: --
216: pqh_tct_shd.constraint_error('PQH_TRANSACTION_CATEGORIES_FK2');
217: --

Line 1451: l_from_clause pqh_table_route.from_clause%type;

1447: type cur_type IS REF CURSOR;
1448: c2 cur_type;
1449: sql_stmt varchar2(1000);
1450: --
1451: l_from_clause pqh_table_route.from_clause%type;
1452: l_where_clause pqh_table_route.where_clause%type;
1453: l_table_alias pqh_table_route.table_alias%type;
1454: --
1455: l_new_where pqh_table_route.where_clause%type;

Line 1452: l_where_clause pqh_table_route.where_clause%type;

1448: c2 cur_type;
1449: sql_stmt varchar2(1000);
1450: --
1451: l_from_clause pqh_table_route.from_clause%type;
1452: l_where_clause pqh_table_route.where_clause%type;
1453: l_table_alias pqh_table_route.table_alias%type;
1454: --
1455: l_new_where pqh_table_route.where_clause%type;
1456: --

Line 1453: l_table_alias pqh_table_route.table_alias%type;

1449: sql_stmt varchar2(1000);
1450: --
1451: l_from_clause pqh_table_route.from_clause%type;
1452: l_where_clause pqh_table_route.where_clause%type;
1453: l_table_alias pqh_table_route.table_alias%type;
1454: --
1455: l_new_where pqh_table_route.where_clause%type;
1456: --
1457: Cursor c1 is

Line 1455: l_new_where pqh_table_route.where_clause%type;

1451: l_from_clause pqh_table_route.from_clause%type;
1452: l_where_clause pqh_table_route.where_clause%type;
1453: l_table_alias pqh_table_route.table_alias%type;
1454: --
1455: l_new_where pqh_table_route.where_clause%type;
1456: --
1457: Cursor c1 is
1458: Select tr.from_clause,tr.table_alias,tr.where_clause
1459: From pqh_transaction_categories tct,pqh_table_route tr

Line 1459: From pqh_transaction_categories tct,pqh_table_route tr

1455: l_new_where pqh_table_route.where_clause%type;
1456: --
1457: Cursor c1 is
1458: Select tr.from_clause,tr.table_alias,tr.where_clause
1459: From pqh_transaction_categories tct,pqh_table_route tr
1460: Where tct.transaction_category_id = p_transaction_category_id
1461: AND tct.consolidated_table_route_id = tr.table_route_id;
1462: --
1463: l_check_flag varchar2(1) := 'N';