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; ';