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.SR_UWQ_INTEG dependencies on IEU_PUB

Line 386: l_sr_list IEU_PUB.EnumeratorDataRecordList;

382: p_source_lang in varchar2,
383: p_sel_enum_id in number) as
384:
385: l_node_label varchar2(100);
386: l_sr_list IEU_PUB.EnumeratorDataRecordList;
387: l_bind_list IEU_PUB.BindVariableRecordList;
388: l_node_counter number;
389:
390: l_team_id number;

Line 387: l_bind_list IEU_PUB.BindVariableRecordList;

383: p_sel_enum_id in number) as
384:
385: l_node_label varchar2(100);
386: l_sr_list IEU_PUB.EnumeratorDataRecordList;
387: l_bind_list IEU_PUB.BindVariableRecordList;
388: l_node_counter number;
389:
390: l_team_id number;
391: l_team_name varchar2(30);

Line 550: return_value := ieu_pub.set_bind_var_data(l_bind_list);

546: l_sr_list(l_node_counter).res_cat_enum_flag := l_res_cat_enum_flag;
547: l_sr_list(l_node_counter).node_type := 10;
548: l_sr_list(l_node_counter).hide_if_empty := '';
549: l_sr_list(l_node_counter).node_depth := l_level+1;
550: return_value := ieu_pub.set_bind_var_data(l_bind_list);
551: l_sr_list(l_node_counter).bind_vars := return_value;
552:
553: begin
554: -- For Each of the SINGLE defined nodes first check if there

Line 613: return_value := ieu_pub.set_bind_var_data(l_bind_list);

609:
610: l_sr_list(l_node_counter).hide_if_empty := '';
611: l_sr_list(l_node_counter).node_depth := l_level+3;
612:
613: return_value := ieu_pub.set_bind_var_data(l_bind_list);
614: l_sr_list(l_node_counter).bind_vars := return_value;
615:
616: end loop;
617:

Line 662: return_value := ieu_pub.set_bind_var_data(l_bind_list);

658: l_sr_list(l_node_counter).res_cat_enum_flag := 'N';
659: l_sr_list(l_node_counter).node_type := 10;
660: l_sr_list(l_node_counter).hide_if_empty := '';
661: l_sr_list(l_node_counter).node_depth := 2;
662: return_value := ieu_pub.set_bind_var_data(l_bind_list);
663: l_sr_list(l_node_counter).bind_vars := return_value;
664:
665: v_cursorid := dbms_sql.open_cursor;
666: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);

Line 695: return_value := ieu_pub.set_bind_var_data(l_bind_list);

691: l_sr_list(l_node_counter).node_type := 12;
692: l_sr_list(l_node_counter).hide_if_empty := '';
693: l_sr_list(l_node_counter).node_depth := 3;
694:
695: return_value := ieu_pub.set_bind_var_data(l_bind_list);
696: l_sr_list(l_node_counter).bind_vars := return_value;
697: end loop;
698:
699: dbms_sql.close_cursor(v_cursorid);

Line 740: return_value := ieu_pub.set_bind_var_data(l_bind_list);

736: if instr(lower(n_where_clause), ':owner_id') <> 0 then
737: l_bind_list(1).bind_var_name := ':owner_id';
738: l_bind_list(1).bind_var_value := p_resource_id;
739: l_bind_list(1).bind_var_data_type :='NUMBER';
740: return_value := ieu_pub.set_bind_var_data(l_bind_list);
741: l_sr_list(l_node_counter).bind_vars := return_value;
742: end if;
743:
744: begin

Line 803: return_value := ieu_pub.set_bind_var_data(l_bind_list);

799: l_sr_list(l_node_counter).node_type := 12;
800: l_sr_list(l_node_counter).hide_if_empty := '';
801: l_sr_list(l_node_counter).node_depth := l_level+3;
802:
803: return_value := ieu_pub.set_bind_var_data(l_bind_list);
804: l_sr_list(l_node_counter).bind_vars := return_value;
805: end loop;
806:
807: dbms_sql.close_cursor(v_cursorid);

Line 819: ieu_pub.add_uwq_node_data

815:
816: end loop;
817: close node_cursor;
818:
819: ieu_pub.add_uwq_node_data
820: (p_resource_id,
821: p_sel_enum_id,
822: l_sr_list );
823:

Line 845: l_node_detail_record IEU_PUB.NodeDetailRecord;

841: n_count number;
842: l_node_type number;
843: l_node_count_view varchar2(50);
844:
845: l_node_detail_record IEU_PUB.NodeDetailRecord;
846: s_sql_statement varchar2(4000);
847: s_unbound_stat varchar2(4000);
848:
849: begin

Line 883: IEU_PUB.GET_UWQ_NODE_DETAILS(p_resource_id, p_node_id, l_node_detail_record);

879: */
880:
881: sr_count := 0;
882:
883: IEU_PUB.GET_UWQ_NODE_DETAILS(p_resource_id, p_node_id, l_node_detail_record);
884:
885: if l_node_detail_record.node_type = 0 then
886:
887: s_sql_statement := ' begin select count(1) into :n_count from cs_sr_uwq_emp_count_v where resource_id = :owner_id; end; ';

Line 1904: l_sr_list IEU_PUB.EnumeratorDataRecordList;

1900: p_source_lang in varchar2,
1901: p_sel_enum_id in number) as
1902:
1903: l_node_label varchar2(100);
1904: l_sr_list IEU_PUB.EnumeratorDataRecordList;
1905: l_bind_list IEU_PUB.BindVariableRecordList;
1906: l_node_counter number;
1907:
1908: l_team_id number;

Line 1905: l_bind_list IEU_PUB.BindVariableRecordList;

1901: p_sel_enum_id in number) as
1902:
1903: l_node_label varchar2(100);
1904: l_sr_list IEU_PUB.EnumeratorDataRecordList;
1905: l_bind_list IEU_PUB.BindVariableRecordList;
1906: l_node_counter number;
1907:
1908: l_team_id number;
1909: l_team_name varchar2(30);

Line 2084: return_value := ieu_pub.set_bind_var_data(l_bind_list);

2080: l_sr_list(l_node_counter).res_cat_enum_flag := l_res_cat_enum_flag;
2081: l_sr_list(l_node_counter).node_type := 10;
2082: l_sr_list(l_node_counter).hide_if_empty := '';
2083: l_sr_list(l_node_counter).node_depth := l_level+1;
2084: return_value := ieu_pub.set_bind_var_data(l_bind_list);
2085: l_sr_list(l_node_counter).bind_vars := return_value;
2086:
2087: begin
2088: -- For Each of the SINGLE defined nodes first check if there

Line 2169: return_value := ieu_pub.set_bind_var_data(l_bind_list);

2165:
2166: l_sr_list(l_node_counter).hide_if_empty := '';
2167: l_sr_list(l_node_counter).node_depth := l_level+3;
2168:
2169: return_value := ieu_pub.set_bind_var_data(l_bind_list);
2170: l_sr_list(l_node_counter).bind_vars := return_value;
2171:
2172: end loop;
2173:

Line 2228: return_value := ieu_pub.set_bind_var_data(l_bind_list);

2224: l_sr_list(l_node_counter).res_cat_enum_flag := 'N';
2225: l_sr_list(l_node_counter).node_type := 10;
2226: l_sr_list(l_node_counter).hide_if_empty := '';
2227: l_sr_list(l_node_counter).node_depth := 2;
2228: return_value := ieu_pub.set_bind_var_data(l_bind_list);
2229: l_sr_list(l_node_counter).bind_vars := return_value;
2230:
2231: v_cursorid := dbms_sql.open_cursor;
2232: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);

Line 2261: return_value := ieu_pub.set_bind_var_data(l_bind_list);

2257: l_sr_list(l_node_counter).node_type := 12;
2258: l_sr_list(l_node_counter).hide_if_empty := '';
2259: l_sr_list(l_node_counter).node_depth := 3;
2260:
2261: return_value := ieu_pub.set_bind_var_data(l_bind_list);
2262: l_sr_list(l_node_counter).bind_vars := return_value;
2263: end loop;
2264:
2265: dbms_sql.close_cursor(v_cursorid);

Line 2316: return_value := ieu_pub.set_bind_var_data(l_bind_list);

2312: if instr(lower(n_where_clause), ':owner_id') <> 0 then
2313: l_bind_list(1).bind_var_name := ':owner_id';
2314: l_bind_list(1).bind_var_value := p_resource_id;
2315: l_bind_list(1).bind_var_data_type :='NUMBER';
2316: return_value := ieu_pub.set_bind_var_data(l_bind_list);
2317: l_sr_list(l_node_counter).bind_vars := return_value;
2318: end if;
2319:
2320: begin

Line 2390: return_value := ieu_pub.set_bind_var_data(l_bind_list);

2386: l_sr_list(l_node_counter).node_type := 12;
2387: l_sr_list(l_node_counter).hide_if_empty := '';
2388: l_sr_list(l_node_counter).node_depth := l_level+3;
2389:
2390: return_value := ieu_pub.set_bind_var_data(l_bind_list);
2391: l_sr_list(l_node_counter).bind_vars := return_value;
2392: end loop;
2393:
2394: dbms_sql.close_cursor(v_cursorid);

Line 2406: ieu_pub.add_uwq_node_data

2402:
2403: end loop;
2404: close node_cursor;
2405:
2406: ieu_pub.add_uwq_node_data
2407: (p_resource_id,
2408: p_sel_enum_id,
2409: l_sr_list );
2410:

Line 2429: l_sr_list IEU_PUB.EnumeratorDataRecordList;

2425: p_source_lang in varchar2,
2426: p_sel_enum_id in number) as
2427:
2428: l_node_label varchar2(100);
2429: l_sr_list IEU_PUB.EnumeratorDataRecordList;
2430: l_bind_list IEU_PUB.BindVariableRecordList;
2431: l_node_counter number;
2432:
2433: l_team_id number;

Line 2430: l_bind_list IEU_PUB.BindVariableRecordList;

2426: p_sel_enum_id in number) as
2427:
2428: l_node_label varchar2(100);
2429: l_sr_list IEU_PUB.EnumeratorDataRecordList;
2430: l_bind_list IEU_PUB.BindVariableRecordList;
2431: l_node_counter number;
2432:
2433: l_team_id number;
2434: l_team_name varchar2(30);

Line 2605: return_value := ieu_pub.set_bind_var_data(l_bind_list);

2601: l_sr_list(l_node_counter).res_cat_enum_flag := l_res_cat_enum_flag;
2602: l_sr_list(l_node_counter).node_type := 10;
2603: l_sr_list(l_node_counter).hide_if_empty := '';
2604: l_sr_list(l_node_counter).node_depth := l_level+1;
2605: return_value := ieu_pub.set_bind_var_data(l_bind_list);
2606: l_sr_list(l_node_counter).bind_vars := return_value;
2607:
2608: begin
2609: -- For Each of the SINGLE defined nodes first check if there

Line 2691: return_value := ieu_pub.set_bind_var_data(l_bind_list);

2687:
2688: l_sr_list(l_node_counter).hide_if_empty := '';
2689: l_sr_list(l_node_counter).node_depth := l_level+3;
2690:
2691: return_value := ieu_pub.set_bind_var_data(l_bind_list);
2692: l_sr_list(l_node_counter).bind_vars := return_value;
2693:
2694: end loop;
2695:

Line 2751: return_value := ieu_pub.set_bind_var_data(l_bind_list);

2747: l_sr_list(l_node_counter).res_cat_enum_flag := 'N';
2748: l_sr_list(l_node_counter).node_type := 10;
2749: l_sr_list(l_node_counter).hide_if_empty := '';
2750: l_sr_list(l_node_counter).node_depth := 2;
2751: return_value := ieu_pub.set_bind_var_data(l_bind_list);
2752: l_sr_list(l_node_counter).bind_vars := return_value;
2753:
2754: v_cursorid := dbms_sql.open_cursor;
2755: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);

Line 2784: return_value := ieu_pub.set_bind_var_data(l_bind_list);

2780: l_sr_list(l_node_counter).node_type := 12;
2781: l_sr_list(l_node_counter).hide_if_empty := '';
2782: l_sr_list(l_node_counter).node_depth := 3;
2783:
2784: return_value := ieu_pub.set_bind_var_data(l_bind_list);
2785: l_sr_list(l_node_counter).bind_vars := return_value;
2786: end loop;
2787:
2788: dbms_sql.close_cursor(v_cursorid);

Line 2840: return_value := ieu_pub.set_bind_var_data(l_bind_list);

2836: if instr(lower(n_where_clause), ':owner_id') <> 0 then
2837: l_bind_list(1).bind_var_name := ':owner_id';
2838: l_bind_list(1).bind_var_value := p_resource_id;
2839: l_bind_list(1).bind_var_data_type :='NUMBER';
2840: return_value := ieu_pub.set_bind_var_data(l_bind_list);
2841: l_sr_list(l_node_counter).bind_vars := return_value;
2842: end if;
2843:
2844: begin

Line 2915: return_value := ieu_pub.set_bind_var_data(l_bind_list);

2911: l_sr_list(l_node_counter).node_type := 12;
2912: l_sr_list(l_node_counter).hide_if_empty := '';
2913: l_sr_list(l_node_counter).node_depth := l_level+3;
2914:
2915: return_value := ieu_pub.set_bind_var_data(l_bind_list);
2916: l_sr_list(l_node_counter).bind_vars := return_value;
2917: end loop;
2918:
2919: dbms_sql.close_cursor(v_cursorid);

Line 2931: ieu_pub.add_uwq_node_data

2927:
2928: end loop;
2929: close node_cursor;
2930:
2931: ieu_pub.add_uwq_node_data
2932: (p_resource_id,
2933: p_sel_enum_id,
2934: l_sr_list );
2935:

Line 2954: l_sr_list IEU_PUB.EnumeratorDataRecordList;

2950: p_source_lang in varchar2,
2951: p_sel_enum_id in number) as
2952:
2953: l_node_label varchar2(100);
2954: l_sr_list IEU_PUB.EnumeratorDataRecordList;
2955: l_bind_list IEU_PUB.BindVariableRecordList;
2956: l_node_counter number;
2957:
2958: l_team_id number;

Line 2955: l_bind_list IEU_PUB.BindVariableRecordList;

2951: p_sel_enum_id in number) as
2952:
2953: l_node_label varchar2(100);
2954: l_sr_list IEU_PUB.EnumeratorDataRecordList;
2955: l_bind_list IEU_PUB.BindVariableRecordList;
2956: l_node_counter number;
2957:
2958: l_team_id number;
2959: l_team_name varchar2(30);

Line 3133: return_value := ieu_pub.set_bind_var_data(l_bind_list);

3129: l_sr_list(l_node_counter).res_cat_enum_flag := l_res_cat_enum_flag;
3130: l_sr_list(l_node_counter).node_type := 10;
3131: l_sr_list(l_node_counter).hide_if_empty := '';
3132: l_sr_list(l_node_counter).node_depth := l_level+1;
3133: return_value := ieu_pub.set_bind_var_data(l_bind_list);
3134: l_sr_list(l_node_counter).bind_vars := return_value;
3135:
3136: begin
3137: -- For Each of the SINGLE defined nodes first check if there

Line 3217: return_value := ieu_pub.set_bind_var_data(l_bind_list);

3213:
3214: l_sr_list(l_node_counter).hide_if_empty := '';
3215: l_sr_list(l_node_counter).node_depth := l_level+3;
3216:
3217: return_value := ieu_pub.set_bind_var_data(l_bind_list);
3218: l_sr_list(l_node_counter).bind_vars := return_value;
3219:
3220: end loop;
3221:

Line 3277: return_value := ieu_pub.set_bind_var_data(l_bind_list);

3273: l_sr_list(l_node_counter).res_cat_enum_flag := 'N';
3274: l_sr_list(l_node_counter).node_type := 10;
3275: l_sr_list(l_node_counter).hide_if_empty := '';
3276: l_sr_list(l_node_counter).node_depth := 2;
3277: return_value := ieu_pub.set_bind_var_data(l_bind_list);
3278: l_sr_list(l_node_counter).bind_vars := return_value;
3279:
3280: v_cursorid := dbms_sql.open_cursor;
3281: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);

Line 3310: return_value := ieu_pub.set_bind_var_data(l_bind_list);

3306: l_sr_list(l_node_counter).node_type := 12;
3307: l_sr_list(l_node_counter).hide_if_empty := '';
3308: l_sr_list(l_node_counter).node_depth := 3;
3309:
3310: return_value := ieu_pub.set_bind_var_data(l_bind_list);
3311: l_sr_list(l_node_counter).bind_vars := return_value;
3312: end loop;
3313:
3314: dbms_sql.close_cursor(v_cursorid);

Line 3365: return_value := ieu_pub.set_bind_var_data(l_bind_list);

3361: if instr(lower(n_where_clause), ':owner_id') <> 0 then
3362: l_bind_list(1).bind_var_name := ':owner_id';
3363: l_bind_list(1).bind_var_value := p_resource_id;
3364: l_bind_list(1).bind_var_data_type :='NUMBER';
3365: return_value := ieu_pub.set_bind_var_data(l_bind_list);
3366: l_sr_list(l_node_counter).bind_vars := return_value;
3367: end if;
3368:
3369: begin

Line 3439: return_value := ieu_pub.set_bind_var_data(l_bind_list);

3435: l_sr_list(l_node_counter).node_type := 12;
3436: l_sr_list(l_node_counter).hide_if_empty := '';
3437: l_sr_list(l_node_counter).node_depth := l_level+3;
3438:
3439: return_value := ieu_pub.set_bind_var_data(l_bind_list);
3440: l_sr_list(l_node_counter).bind_vars := return_value;
3441: end loop;
3442:
3443: dbms_sql.close_cursor(v_cursorid);

Line 3455: ieu_pub.add_uwq_node_data

3451:
3452: end loop;
3453: close node_cursor;
3454:
3455: ieu_pub.add_uwq_node_data
3456: (p_resource_id,
3457: p_sel_enum_id,
3458: l_sr_list );
3459: