APPS.PER_QH_FIND_QUERY dependencies on PER_QUERY_CRITERIA

Line 2388: insert into per_query_criteria

2384: ,p_field varchar2
2385: ,p_value varchar2
2386: ) is
2387: begin
2388: insert into per_query_criteria
2389: (query_id
2390: ,field
2391: ,field_type
2392: ,varchar2_value

Line 2411: insert into per_query_criteria

2407: ,p_field varchar2
2408: ,p_value number
2409: ) is
2410: begin
2411: insert into per_query_criteria
2412: (query_id
2413: ,field
2414: ,field_type
2415: ,varchar2_value

Line 2434: insert into per_query_criteria

2430: ,p_field varchar2
2431: ,p_value date
2432: ) is
2433: begin
2434: insert into per_query_criteria
2435: (query_id
2436: ,field
2437: ,field_type
2438: ,varchar2_value

Line 2850: from per_query_criteria

2846: l_value varchar2(240);
2847: --
2848: cursor get_varchar2 is
2849: select varchar2_value
2850: from per_query_criteria
2851: where query_id=p_query_id
2852: and field=p_field;
2853: begin
2854: open get_varchar2;

Line 2867: from per_query_criteria

2863: l_value number;
2864: --
2865: cursor get_number is
2866: select number_value
2867: from per_query_criteria
2868: where query_id=p_query_id
2869: and field=p_field;
2870: begin
2871: open get_number;

Line 2884: from per_query_criteria

2880: l_value date;
2881: --
2882: cursor get_date is
2883: select date_value
2884: from per_query_criteria
2885: where query_id=p_query_id
2886: and field=p_field;
2887: begin
2888: open get_date;