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_GENERIC_PURGE dependencies on PQH_ATTRIBUTES

Line 19: pk_column_name pqh_attributes.column_name%TYPE;

15: /* -------------Variable Declarations --------------------------------------
16: l_master_tab_route_id pqh_table_route.table_route_id%TYPE;
17: l_master_table_alias pqh_table_route.table_alias%TYPE;
18: l_master_pk_value NUMBER(15);
19: pk_column_name pqh_attributes.column_name%TYPE;
20: g_error_flag BOOLEAN DEFAULT FALSE;
21: retcode NUMBER;
22: l_effective_date DATE;
23: */

Line 59: FROM pqh_attributes att

55:
56: CURSOR csr_col_name(p_table_route_id IN NUMBER,
57: p_col_type_cd IN VARCHAR2) IS
58: SELECT upper(att.column_name) column_name
59: FROM pqh_attributes att
60: , pqh_special_attributes sat
61: , pqh_txn_category_attributes tca
62: WHERE att.attribute_id = tca.attribute_id
63: AND att.master_table_route_id = p_table_route_id

Line 156: paramname1 IN pqh_attributes.column_name%TYPE ,

152: PROCEDURE pqh_gen_purge
153: (errbuf OUT NOCOPY VARCHAR2,
154: retcode OUT NOCOPY NUMBER,
155: p_alias IN pqh_table_route.table_alias%TYPE,
156: paramname1 IN pqh_attributes.column_name%TYPE ,
157: paramvalue1 IN VARCHAR2 ,
158: paramname2 IN pqh_attributes.column_name%TYPE,
159: paramvalue2 IN VARCHAR2 ,
160: paramname3 IN pqh_attributes.column_name%TYPE ,

Line 158: paramname2 IN pqh_attributes.column_name%TYPE,

154: retcode OUT NOCOPY NUMBER,
155: p_alias IN pqh_table_route.table_alias%TYPE,
156: paramname1 IN pqh_attributes.column_name%TYPE ,
157: paramvalue1 IN VARCHAR2 ,
158: paramname2 IN pqh_attributes.column_name%TYPE,
159: paramvalue2 IN VARCHAR2 ,
160: paramname3 IN pqh_attributes.column_name%TYPE ,
161: paramvalue3 IN VARCHAR2 ,
162: paramname4 IN pqh_attributes.column_name%TYPE ,

Line 160: paramname3 IN pqh_attributes.column_name%TYPE ,

156: paramname1 IN pqh_attributes.column_name%TYPE ,
157: paramvalue1 IN VARCHAR2 ,
158: paramname2 IN pqh_attributes.column_name%TYPE,
159: paramvalue2 IN VARCHAR2 ,
160: paramname3 IN pqh_attributes.column_name%TYPE ,
161: paramvalue3 IN VARCHAR2 ,
162: paramname4 IN pqh_attributes.column_name%TYPE ,
163: paramvalue4 IN VARCHAR2 ,
164: paramname5 IN pqh_attributes.column_name%TYPE ,

Line 162: paramname4 IN pqh_attributes.column_name%TYPE ,

158: paramname2 IN pqh_attributes.column_name%TYPE,
159: paramvalue2 IN VARCHAR2 ,
160: paramname3 IN pqh_attributes.column_name%TYPE ,
161: paramvalue3 IN VARCHAR2 ,
162: paramname4 IN pqh_attributes.column_name%TYPE ,
163: paramvalue4 IN VARCHAR2 ,
164: paramname5 IN pqh_attributes.column_name%TYPE ,
165: paramvalue5 IN VARCHAR2 ,
166: p_effective_date IN DATE )

Line 164: paramname5 IN pqh_attributes.column_name%TYPE ,

160: paramname3 IN pqh_attributes.column_name%TYPE ,
161: paramvalue3 IN VARCHAR2 ,
162: paramname4 IN pqh_attributes.column_name%TYPE ,
163: paramvalue4 IN VARCHAR2 ,
164: paramname5 IN pqh_attributes.column_name%TYPE ,
165: paramvalue5 IN VARCHAR2 ,
166: p_effective_date IN DATE )
167: IS
168: l_proc varchar2(72) := g_package||'gen_purge';

Line 171: pk_col_name pqh_attributes.column_name%TYPE;

167: IS
168: l_proc varchar2(72) := g_package||'gen_purge';
169: l_master_alias pqh_table_route.table_alias%TYPE;
170: l_master_tab_route_id pqh_table_route.table_route_id%TYPE;
171: pk_col_name pqh_attributes.column_name%TYPE;
172: l_select_stmt VARCHAR2(8000);
173: l_from_clause_txn pqh_table_route.from_clause%TYPE;
174: l_where_clause_in_txn pqh_table_route.where_clause%TYPE;
175: l_where_clause_out_txn pqh_table_route.where_clause%TYPE;

Line 275: FUNCTION get_col_type(p_column_name IN pqh_attributes.column_name%TYPE,

271: END pqh_gen_purge;
272: -----------------------------------------------------------------------------------------
273: -- FUNCTION GET_COL_TYPE
274: -----------------------------------------------------------------------------------------
275: FUNCTION get_col_type(p_column_name IN pqh_attributes.column_name%TYPE,
276: l_master_table_route_id in pqh_table_route.table_route_id%TYPE )
277: RETURN VARCHAR2
278: IS
279: CURSOR

Line 280: csr_get_tr_type (p_column_name IN pqh_attributes.column_name%TYPE,

276: l_master_table_route_id in pqh_table_route.table_route_id%TYPE )
277: RETURN VARCHAR2
278: IS
279: CURSOR
280: csr_get_tr_type (p_column_name IN pqh_attributes.column_name%TYPE,
281: l_master_table_route_id IN pqh_table_route.table_route_id%TYPE ) IS
282: SELECT column_type
283: FROM pqh_attributes
284: WHERE column_name = UPPER(p_column_name)

Line 283: FROM pqh_attributes

279: CURSOR
280: csr_get_tr_type (p_column_name IN pqh_attributes.column_name%TYPE,
281: l_master_table_route_id IN pqh_table_route.table_route_id%TYPE ) IS
282: SELECT column_type
283: FROM pqh_attributes
284: WHERE column_name = UPPER(p_column_name)
285: AND master_table_route_id = l_master_table_route_id;
286:
287: CURSOR csr_get_type (p_column_name IN pqh_attributes.column_name%TYPE) IS

Line 287: CURSOR csr_get_type (p_column_name IN pqh_attributes.column_name%TYPE) IS

283: FROM pqh_attributes
284: WHERE column_name = UPPER(p_column_name)
285: AND master_table_route_id = l_master_table_route_id;
286:
287: CURSOR csr_get_type (p_column_name IN pqh_attributes.column_name%TYPE) IS
288: SELECT column_type
289: FROM pqh_attributes
290: WHERE column_name = UPPER(p_column_name)
291: AND master_table_route_id is null ;

Line 289: FROM pqh_attributes

285: AND master_table_route_id = l_master_table_route_id;
286:
287: CURSOR csr_get_type (p_column_name IN pqh_attributes.column_name%TYPE) IS
288: SELECT column_type
289: FROM pqh_attributes
290: WHERE column_name = UPPER(p_column_name)
291: AND master_table_route_id is null ;
292: l_dummy varchar2(1);
293: BEGIN

Line 311: paramname1 IN pqh_attributes.column_name%TYPE,

307: -- POPULATE_PLTABLE
308: -------------------------------------------------------------------------------------------------
309: PROCEDURE populate_pltable
310: (l_master_tab_route_id IN PQH_TABLE_ROUTE.TABLE_ROUTE_ID%TYPE,
311: paramname1 IN pqh_attributes.column_name%TYPE,
312: paramvalue1 IN VARCHAR2,
313: paramname2 IN pqh_attributes.column_name%TYPE,
314: paramvalue2 IN VARCHAR2,
315: paramname3 IN pqh_attributes.column_name%TYPE,

Line 313: paramname2 IN pqh_attributes.column_name%TYPE,

309: PROCEDURE populate_pltable
310: (l_master_tab_route_id IN PQH_TABLE_ROUTE.TABLE_ROUTE_ID%TYPE,
311: paramname1 IN pqh_attributes.column_name%TYPE,
312: paramvalue1 IN VARCHAR2,
313: paramname2 IN pqh_attributes.column_name%TYPE,
314: paramvalue2 IN VARCHAR2,
315: paramname3 IN pqh_attributes.column_name%TYPE,
316: paramvalue3 IN VARCHAR2,
317: paramname4 IN pqh_attributes.column_name%TYPE,

Line 315: paramname3 IN pqh_attributes.column_name%TYPE,

311: paramname1 IN pqh_attributes.column_name%TYPE,
312: paramvalue1 IN VARCHAR2,
313: paramname2 IN pqh_attributes.column_name%TYPE,
314: paramvalue2 IN VARCHAR2,
315: paramname3 IN pqh_attributes.column_name%TYPE,
316: paramvalue3 IN VARCHAR2,
317: paramname4 IN pqh_attributes.column_name%TYPE,
318: paramvalue4 IN VARCHAR2,
319: paramname5 IN pqh_attributes.column_name%TYPE,

Line 317: paramname4 IN pqh_attributes.column_name%TYPE,

313: paramname2 IN pqh_attributes.column_name%TYPE,
314: paramvalue2 IN VARCHAR2,
315: paramname3 IN pqh_attributes.column_name%TYPE,
316: paramvalue3 IN VARCHAR2,
317: paramname4 IN pqh_attributes.column_name%TYPE,
318: paramvalue4 IN VARCHAR2,
319: paramname5 IN pqh_attributes.column_name%TYPE,
320: paramvalue5 IN VARCHAR2) IS
321: l_proc varchar2(72) := g_package||'populate_pltable';

Line 319: paramname5 IN pqh_attributes.column_name%TYPE,

315: paramname3 IN pqh_attributes.column_name%TYPE,
316: paramvalue3 IN VARCHAR2,
317: paramname4 IN pqh_attributes.column_name%TYPE,
318: paramvalue4 IN VARCHAR2,
319: paramname5 IN pqh_attributes.column_name%TYPE,
320: paramvalue5 IN VARCHAR2) IS
321: l_proc varchar2(72) := g_package||'populate_pltable';
322: i number := 1;
323: BEGIN

Line 393: c_pk_col_name pqh_attributes.column_name%TYPE;

389: p_parent_pk_value IN NUMBER) IS
390: l_proc varchar2(72) := g_package||'del_child_records';
391: l_alias_name pqh_table_route.table_alias%TYPE default null;
392: l_tab_route_id pqh_table_route.table_route_id%TYPE;
393: c_pk_col_name pqh_attributes.column_name%TYPE;
394: l_select_stmt varchar2(8000) DEFAULT null;
395: l_parent_pk_value number;
396: --
397: l_all_child_rows_array dbms_sql.varchar2_table;

Line 502: p_pk_col_name IN pqh_attributes.column_name%TYPE) IS

498: Procedure call_delete_api
499: (p_tab_route_id IN pqh_table_route.table_route_id%TYPE,
500: p_pk_value IN NUMBER,
501: p_from_clause_txn IN pqh_table_route.from_clause%TYPE,
502: p_pk_col_name IN pqh_attributes.column_name%TYPE) IS
503: -- p_errror_flag OUT BOOLEAN ) IS
504: --This Cursor will get the delete api to be called for the respective tables.
505: ---------------------Cursor and Variable Declarations-------------------------------------
506: CURSOR

Line 540: l_pk_col_name PQH_ATTRIBUTES.COLUMN_NAME%TYPE;

536: l_pk_value Number;
537: l_ovn NUMBER;
538: l_dummy_out1 varchar2(4000);
539: l_dummy_out2 varchar2(4000);
540: l_pk_col_name PQH_ATTRIBUTES.COLUMN_NAME%TYPE;
541: l_process_log_id NUMBER;
542: -----------------------------------------------------------------------------------------
543: BEGIN
544: hr_utility.set_location('entering: ' ||l_proc,1700);

Line 634: p_pk_col_name IN pqh_attributes.column_name%TYPE)

630: ----------------------------------------------------------------------------------------------
631: PROCEDURE enter_conc_log(p_pk_value IN NUMBER,
632: TAB_ROU_ID IN NUMBER,
633: p_from_clause_txn IN pqh_table_route.from_clause%TYPE,
634: p_pk_col_name IN pqh_attributes.column_name%TYPE)
635: -- p_error_flag IN boolean)
636: IS
637: ------------------------DECLARATIONS----------------------------------------------------------
638: --

Line 642: FROM pqh_attributes att

638: --
639: CURSOR
640: csr_err_col_name(p_table_route_id IN pqh_table_route.table_route_id%TYPE) IS
641: SELECT upper(att.column_name) column_name
642: FROM pqh_attributes att
643: , pqh_special_attributes sat
644: , pqh_txn_category_attributes tca
645: WHERE att.attribute_id = tca.attribute_id
646: and att.master_table_route_id = p_table_route_id