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_TABLE_ROUTE

Line 16: l_master_tab_route_id pqh_table_route.table_route_id%TYPE;

12: g_wf_txn_catg_id NUMBER;
13: g_master_alias varchar2(30);
14: --
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;

Line 17: l_master_table_alias pqh_table_route.table_alias%TYPE;

13: g_master_alias varchar2(30);
14: --
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;

Line 49: CURSOR csr_table_route(p_alias IN pqh_table_route.TABLE_alias%TYPE) is

45: p_table_route_id OUT NOCOPY NUMBER,
46: p_from_clause OUT NOCOPY VARCHAR2,
47: p_where_clause OUT NOCOPY VARCHAR2,
48: p_primary_key_col OUT NOCOPY VARCHAR2) IS
49: CURSOR csr_table_route(p_alias IN pqh_table_route.TABLE_alias%TYPE) is
50: SELECT table_route_id,
51: from_clause,
52: where_clause
53: FROM pqh_table_route

Line 53: FROM pqh_table_route

49: CURSOR csr_table_route(p_alias IN pqh_table_route.TABLE_alias%TYPE) is
50: SELECT table_route_id,
51: from_clause,
52: where_clause
53: FROM pqh_table_route
54: WHERE table_alias = p_alias;
55:
56: CURSOR csr_col_name(p_table_route_id IN NUMBER,
57: p_col_type_cd IN VARCHAR2) IS

Line 155: p_alias IN pqh_table_route.table_alias%TYPE,

151: -------------------------------------------------------------------------------------------------
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 ,

Line 169: l_master_alias pqh_table_route.table_alias%TYPE;

165: paramvalue5 IN VARCHAR2 ,
166: p_effective_date IN DATE )
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;

Line 170: l_master_tab_route_id pqh_table_route.table_route_id%TYPE;

166: p_effective_date IN DATE )
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;

Line 173: l_from_clause_txn pqh_table_route.from_clause%TYPE;

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;
176: l_all_txn_rows_array dbms_sql.varchar2_table;
177: l_tot_txn_rows NUMBER;

Line 174: l_where_clause_in_txn pqh_table_route.where_clause%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;
176: l_all_txn_rows_array dbms_sql.varchar2_table;
177: l_tot_txn_rows NUMBER;
178: l_parent_pk_value NUMBER;

Line 175: l_where_clause_out_txn pqh_table_route.where_clause%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;
176: l_all_txn_rows_array dbms_sql.varchar2_table;
177: l_tot_txn_rows NUMBER;
178: l_parent_pk_value NUMBER;
179: i NUMBER default 1 ;

Line 276: l_master_table_route_id in pqh_table_route.table_route_id%TYPE )

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
280: csr_get_tr_type (p_column_name IN pqh_attributes.column_name%TYPE,

Line 281: l_master_table_route_id IN pqh_table_route.table_route_id%TYPE ) IS

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)
285: AND master_table_route_id = l_master_table_route_id;

Line 310: (l_master_tab_route_id IN PQH_TABLE_ROUTE.TABLE_ROUTE_ID%TYPE,

306: -------------------------------------------------------------------------------------------------
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,

Line 388: (p_alias_name IN pqh_table_route.table_alias%TYPE,

384: ----------------------------------------------------------------------------------------------
385: -- DEL_CHILD_RECORDS
386: ----------------------------------------------------------------------------------------------
387: PROCEDURE del_child_records
388: (p_alias_name IN pqh_table_route.table_alias%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;

Line 391: l_alias_name pqh_table_route.table_alias%TYPE default null;

387: PROCEDURE del_child_records
388: (p_alias_name IN pqh_table_route.table_alias%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;

Line 392: l_tab_route_id pqh_table_route.table_route_id%TYPE;

388: (p_alias_name IN pqh_table_route.table_alias%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: --

Line 398: l_child_alias pqh_table_route.table_alias%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;
398: l_child_alias pqh_table_route.table_alias%TYPE;
399: l_from_clause_txn pqh_table_route.from_clause%type;
400: l_where_clause_in_txn pqh_table_route.where_clause%type;
401: l_where_clause_out_txn pqh_table_route.where_clause%type;
402: l_tot_txn_rows NUMBER;

Line 399: l_from_clause_txn pqh_table_route.from_clause%type;

395: l_parent_pk_value number;
396: --
397: l_all_child_rows_array dbms_sql.varchar2_table;
398: l_child_alias pqh_table_route.table_alias%TYPE;
399: l_from_clause_txn pqh_table_route.from_clause%type;
400: l_where_clause_in_txn pqh_table_route.where_clause%type;
401: l_where_clause_out_txn pqh_table_route.where_clause%type;
402: l_tot_txn_rows NUMBER;
403: l_error_flag BOOLEAN;

Line 400: l_where_clause_in_txn pqh_table_route.where_clause%type;

396: --
397: l_all_child_rows_array dbms_sql.varchar2_table;
398: l_child_alias pqh_table_route.table_alias%TYPE;
399: l_from_clause_txn pqh_table_route.from_clause%type;
400: l_where_clause_in_txn pqh_table_route.where_clause%type;
401: l_where_clause_out_txn pqh_table_route.where_clause%type;
402: l_tot_txn_rows NUMBER;
403: l_error_flag BOOLEAN;
404: i NUMBER :=1 ;

Line 401: l_where_clause_out_txn pqh_table_route.where_clause%type;

397: l_all_child_rows_array dbms_sql.varchar2_table;
398: l_child_alias pqh_table_route.table_alias%TYPE;
399: l_from_clause_txn pqh_table_route.from_clause%type;
400: l_where_clause_in_txn pqh_table_route.where_clause%type;
401: l_where_clause_out_txn pqh_table_route.where_clause%type;
402: l_tot_txn_rows NUMBER;
403: l_error_flag BOOLEAN;
404: i NUMBER :=1 ;
405: /* Re-writing the cursor for Purging all the child/grand-child tables

Line 407: get_child_alias(p_alias_name in pqh_table_route.table_alias%type) IS

403: l_error_flag BOOLEAN;
404: i NUMBER :=1 ;
405: /* Re-writing the cursor for Purging all the child/grand-child tables
406: CURSOR
407: get_child_alias(p_alias_name in pqh_table_route.table_alias%type) IS
408: SELECT
409: child_node_type
410: FROM
411: per_gen_hier_node_types

Line 415: CURSOR csr_child_alias(p_alias_name IN pqh_table_route.table_alias%TYPE) IS

411: per_gen_hier_node_types
412: WHERE
413: parent_node_type = UPPER(p_alias_name) AND hierarchy_type = 'GENERIC_PURGE';
414: */
415: CURSOR csr_child_alias(p_alias_name IN pqh_table_route.table_alias%TYPE) IS
416: SELECT child_node_type
417: FROM per_gen_hier_node_types
418: WHERE hierarchy_type = 'GENERIC_PURGE'
419: START WITH parent_node_type = UPPER(p_alias_name)

Line 499: (p_tab_route_id IN pqh_table_route.table_route_id%TYPE,

495: -----------------------------------------------------------------------------------------
496: -- CALL_DELETE_API
497: ------------------------------------------------------------------------------------------
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

Line 501: p_from_clause_txn IN pqh_table_route.from_clause%TYPE,

497: ------------------------------------------------------------------------------------------
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-------------------------------------

Line 507: csr_delete_api_name( p_table_route_id IN pqh_table_route.table_route_id%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
507: csr_delete_api_name( p_table_route_id IN pqh_table_route.table_route_id%TYPE) IS
508: SELECT copy_function_name
509: FROM pqh_copy_entity_functions
510: WHERE table_route_id = p_table_route_id;
511: /*

Line 532: l_from_clause_txn pqh_table_route.from_clause%type;

528: l_dummy_out varchar2(4000);
529: l_select_stmt varchar2(8000);
530: -- l_ovn_value dbms_sql.varchar2_table;
531: -- l_plog_value dbms_sql.varchar2_table;
532: l_from_clause_txn pqh_table_route.from_clause%type;
533: l_where_clause_in_txn pqh_table_route.where_clause%type;
534: l_where_clause_out_txn pqh_table_route.where_clause%type;
535: l_ovn_rows number;
536: l_pk_value Number;

Line 533: l_where_clause_in_txn pqh_table_route.where_clause%type;

529: l_select_stmt varchar2(8000);
530: -- l_ovn_value dbms_sql.varchar2_table;
531: -- l_plog_value dbms_sql.varchar2_table;
532: l_from_clause_txn pqh_table_route.from_clause%type;
533: l_where_clause_in_txn pqh_table_route.where_clause%type;
534: l_where_clause_out_txn pqh_table_route.where_clause%type;
535: l_ovn_rows number;
536: l_pk_value Number;
537: l_ovn NUMBER;

Line 534: l_where_clause_out_txn pqh_table_route.where_clause%type;

530: -- l_ovn_value dbms_sql.varchar2_table;
531: -- l_plog_value dbms_sql.varchar2_table;
532: l_from_clause_txn pqh_table_route.from_clause%type;
533: l_where_clause_in_txn pqh_table_route.where_clause%type;
534: l_where_clause_out_txn pqh_table_route.where_clause%type;
535: l_ovn_rows number;
536: l_pk_value Number;
537: l_ovn NUMBER;
538: l_dummy_out1 varchar2(4000);

Line 633: p_from_clause_txn IN pqh_table_route.from_clause%TYPE,

629: -- ENTER_CONC_LOG
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----------------------------------------------------------

Line 640: csr_err_col_name(p_table_route_id IN pqh_table_route.table_route_id%TYPE) IS

636: IS
637: ------------------------DECLARATIONS----------------------------------------------------------
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