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 9: paramname1 IN pqh_attributes.column_name%TYPE DEFAULT NULL,

5: PROCEDURE pqh_gen_purge
6: (errbuf OUT NOCOPY varchar2,
7: retcode OUT NOCOPY number,
8: p_alias IN pqh_table_route.table_alias%TYPE,
9: paramname1 IN pqh_attributes.column_name%TYPE DEFAULT NULL,
10: paramvalue1 IN VARCHAR2 DEFAULT NULL,
11: paramname2 IN pqh_attributes.column_name%TYPE DEFAULT NULL,
12: paramvalue2 IN VARCHAR2 DEFAULT NULL,
13: paramname3 IN pqh_attributes.column_name%TYPE DEFAULT NULL,

Line 11: paramname2 IN pqh_attributes.column_name%TYPE DEFAULT NULL,

7: retcode OUT NOCOPY number,
8: p_alias IN pqh_table_route.table_alias%TYPE,
9: paramname1 IN pqh_attributes.column_name%TYPE DEFAULT NULL,
10: paramvalue1 IN VARCHAR2 DEFAULT NULL,
11: paramname2 IN pqh_attributes.column_name%TYPE DEFAULT NULL,
12: paramvalue2 IN VARCHAR2 DEFAULT NULL,
13: paramname3 IN pqh_attributes.column_name%TYPE DEFAULT NULL,
14: paramvalue3 IN VARCHAR2 DEFAULT NULL,
15: paramname4 IN pqh_attributes.column_name%TYPE DEFAULT NULL,

Line 13: paramname3 IN pqh_attributes.column_name%TYPE DEFAULT NULL,

9: paramname1 IN pqh_attributes.column_name%TYPE DEFAULT NULL,
10: paramvalue1 IN VARCHAR2 DEFAULT NULL,
11: paramname2 IN pqh_attributes.column_name%TYPE DEFAULT NULL,
12: paramvalue2 IN VARCHAR2 DEFAULT NULL,
13: paramname3 IN pqh_attributes.column_name%TYPE DEFAULT NULL,
14: paramvalue3 IN VARCHAR2 DEFAULT NULL,
15: paramname4 IN pqh_attributes.column_name%TYPE DEFAULT NULL,
16: paramvalue4 IN VARCHAR2 DEFAULT NULL,
17: paramname5 IN pqh_attributes.column_name%TYPE DEFAULT NULL,

Line 15: paramname4 IN pqh_attributes.column_name%TYPE DEFAULT NULL,

11: paramname2 IN pqh_attributes.column_name%TYPE DEFAULT NULL,
12: paramvalue2 IN VARCHAR2 DEFAULT NULL,
13: paramname3 IN pqh_attributes.column_name%TYPE DEFAULT NULL,
14: paramvalue3 IN VARCHAR2 DEFAULT NULL,
15: paramname4 IN pqh_attributes.column_name%TYPE DEFAULT NULL,
16: paramvalue4 IN VARCHAR2 DEFAULT NULL,
17: paramname5 IN pqh_attributes.column_name%TYPE DEFAULT NULL,
18: paramvalue5 IN VARCHAR2 DEFAULT NULL,
19: p_effective_date IN DATE DEFAULT SYSDATE);

Line 17: paramname5 IN pqh_attributes.column_name%TYPE DEFAULT NULL,

13: paramname3 IN pqh_attributes.column_name%TYPE DEFAULT NULL,
14: paramvalue3 IN VARCHAR2 DEFAULT NULL,
15: paramname4 IN pqh_attributes.column_name%TYPE DEFAULT NULL,
16: paramvalue4 IN VARCHAR2 DEFAULT NULL,
17: paramname5 IN pqh_attributes.column_name%TYPE DEFAULT NULL,
18: paramvalue5 IN VARCHAR2 DEFAULT NULL,
19: p_effective_date IN DATE DEFAULT SYSDATE);
20:
21: --To Populate the Pl/SQL table to be used in procedure 'replace_where_params'

Line 25: paramname1 IN pqh_attributes.column_name%TYPE,

21: --To Populate the Pl/SQL table to be used in procedure 'replace_where_params'
22:
23: PROCEDURE populate_pltable
24: (l_master_tab_route_id IN pqh_table_route.table_ROUTE_ID%TYPE,
25: paramname1 IN pqh_attributes.column_name%TYPE,
26: paramvalue1 IN VARCHAR2,
27: paramname2 IN pqh_attributes.column_name%TYPE,
28: paramvalue2 IN VARCHAR2,
29: paramname3 IN pqh_attributes.column_name%TYPE,

Line 27: paramname2 IN pqh_attributes.column_name%TYPE,

23: PROCEDURE populate_pltable
24: (l_master_tab_route_id IN pqh_table_route.table_ROUTE_ID%TYPE,
25: paramname1 IN pqh_attributes.column_name%TYPE,
26: paramvalue1 IN VARCHAR2,
27: paramname2 IN pqh_attributes.column_name%TYPE,
28: paramvalue2 IN VARCHAR2,
29: paramname3 IN pqh_attributes.column_name%TYPE,
30: paramvalue3 IN VARCHAR2,
31: paramname4 IN pqh_attributes.column_name%TYPE,

Line 29: paramname3 IN pqh_attributes.column_name%TYPE,

25: paramname1 IN pqh_attributes.column_name%TYPE,
26: paramvalue1 IN VARCHAR2,
27: paramname2 IN pqh_attributes.column_name%TYPE,
28: paramvalue2 IN VARCHAR2,
29: paramname3 IN pqh_attributes.column_name%TYPE,
30: paramvalue3 IN VARCHAR2,
31: paramname4 IN pqh_attributes.column_name%TYPE,
32: paramvalue4 IN VARCHAR2,
33: paramname5 IN pqh_attributes.column_name%TYPE,

Line 31: paramname4 IN pqh_attributes.column_name%TYPE,

27: paramname2 IN pqh_attributes.column_name%TYPE,
28: paramvalue2 IN VARCHAR2,
29: paramname3 IN pqh_attributes.column_name%TYPE,
30: paramvalue3 IN VARCHAR2,
31: paramname4 IN pqh_attributes.column_name%TYPE,
32: paramvalue4 IN VARCHAR2,
33: paramname5 IN pqh_attributes.column_name%TYPE,
34: paramvalue5 IN VARCHAR2);
35:

Line 33: paramname5 IN pqh_attributes.column_name%TYPE,

29: paramname3 IN pqh_attributes.column_name%TYPE,
30: paramvalue3 IN VARCHAR2,
31: paramname4 IN pqh_attributes.column_name%TYPE,
32: paramvalue4 IN VARCHAR2,
33: paramname5 IN pqh_attributes.column_name%TYPE,
34: paramvalue5 IN VARCHAR2);
35:
36: -- To identify child table records for the parent txn
37:

Line 49: p_pk_col_name IN pqh_attributes.column_name%TYPE);

45: PROCEDURE call_delete_api
46: (p_tab_route_id IN pqh_table_route.table_route_id%TYPE,
47: p_pk_value IN NUMBER,
48: p_from_clause_txn IN pqh_table_route.from_clause%TYPE,
49: p_pk_col_name IN pqh_attributes.column_name%TYPE);
50: --
51: -- To enter data into conc log file
52:
53: PROCEDURE enter_conc_log(p_pk_value IN NUMBER,

Line 56: p_pk_col_name IN pqh_attributes.column_name%TYPE);

52:
53: PROCEDURE enter_conc_log(p_pk_value IN NUMBER,
54: tab_rou_id IN NUMBER,
55: p_from_clause_txn IN pqh_table_route.from_clause%TYPE,
56: p_pk_col_name IN pqh_attributes.column_name%TYPE);
57:
58: FUNCTION get_col_type
59: (p_column_name IN pqh_attributes.column_name%TYPE,
60: l_master_table_route_id IN pqh_table_route.table_route_id%TYPE)

Line 59: (p_column_name IN pqh_attributes.column_name%TYPE,

55: p_from_clause_txn IN pqh_table_route.from_clause%TYPE,
56: p_pk_col_name IN pqh_attributes.column_name%TYPE);
57:
58: FUNCTION get_col_type
59: (p_column_name IN pqh_attributes.column_name%TYPE,
60: l_master_table_route_id IN pqh_table_route.table_route_id%TYPE)
61: RETURN VARCHAR2;
62:
63: END pqh_generic_purge;