APPS.PER_QH_FIND_QUERY dependencies on PER_QUERY_CRITERIA

Line 2372: insert into per_query_criteria

2368: ,p_field varchar2
2369: ,p_value varchar2
2370: ) is
2371: begin
2372: insert into per_query_criteria
2373: (query_id
2374: ,field
2375: ,field_type
2376: ,varchar2_value

Line 2395: insert into per_query_criteria

2391: ,p_field varchar2
2392: ,p_value number
2393: ) is
2394: begin
2395: insert into per_query_criteria
2396: (query_id
2397: ,field
2398: ,field_type
2399: ,varchar2_value

Line 2418: insert into per_query_criteria

2414: ,p_field varchar2
2415: ,p_value date
2416: ) is
2417: begin
2418: insert into per_query_criteria
2419: (query_id
2420: ,field
2421: ,field_type
2422: ,varchar2_value

Line 2834: from per_query_criteria

2830: l_value varchar2(240);
2831: --
2832: cursor get_varchar2 is
2833: select varchar2_value
2834: from per_query_criteria
2835: where query_id=p_query_id
2836: and field=p_field;
2837: begin
2838: open get_varchar2;

Line 2851: from per_query_criteria

2847: l_value number;
2848: --
2849: cursor get_number is
2850: select number_value
2851: from per_query_criteria
2852: where query_id=p_query_id
2853: and field=p_field;
2854: begin
2855: open get_number;

Line 2868: from per_query_criteria

2864: l_value date;
2865: --
2866: cursor get_date is
2867: select date_value
2868: from per_query_criteria
2869: where query_id=p_query_id
2870: and field=p_field;
2871: begin
2872: open get_date;