APPS.SR_UWQ_INTEG dependencies on CS_SR_UWQ_NODES_TL

Line 430: from cs_sr_uwq_nodes_b uwq_b, cs_sr_uwq_nodes_tl uwq_tl

426: l_res_cat_enum_flag varchar2(1);
427:
428: cursor all_cursor is select node_label,node_view,cursor_key_col,cursor_sql,
429: data_source
430: from cs_sr_uwq_nodes_b uwq_b, cs_sr_uwq_nodes_tl uwq_tl
431: where uwq_b.node_id = uwq_tl.node_id
432: and uwq_tl.language = userenv('LANG')
433: and parent_id = l_node_id
434: and node_query='CURSOR' and enabled_flag='Y';

Line 509: select node_label into l_node_label from cs_sr_uwq_nodes_tl

505:
506: l_node_counter := l_node_counter + 1;
507:
508: begin
509: select node_label into l_node_label from cs_sr_uwq_nodes_tl
510: where node_id=l_node_id and language=userenv('LANG');
511: exception
512: when NO_DATA_FOUND then
513: l_node_label:='Error: No Label ';

Line 562: from cs_sr_uwq_nodes_b uwq_b, cs_sr_uwq_nodes_tl uwq_tl

558: select node_label,node_view,cursor_key_col,data_source,
559: node_query,cursor_sql,uwq_b.node_id,res_cat_enum_flag
560: into l_node_label,l_view_name,l_cursor_key_col,l_data_source,
561: l_node_query,l_cursor_sql,l_node_id,l_res_cat_enum_flag
562: from cs_sr_uwq_nodes_b uwq_b, cs_sr_uwq_nodes_tl uwq_tl
563: where uwq_b.node_id = uwq_tl.node_id
564: and uwq_tl.language = userenv('LANG')
565: and parent_id = l_node_id and enabled_flag='Y'
566: and node_query = 'CURSOR' ;

Line 719: select node_label into l_node_label from cs_sr_uwq_nodes_tl

715:
716: l_node_counter := l_node_counter + 1;
717:
718: begin
719: select node_label into l_node_label from cs_sr_uwq_nodes_tl
720: where node_id=l_node_id and language=userenv('LANG');
721: exception
722: when NO_DATA_FOUND then
723: l_node_label:='Error: No Label ';

Line 754: from cs_sr_uwq_nodes_b uwq_b, cs_sr_uwq_nodes_tl uwq_tl

750: , res_cat_enum_flag
751: into l_node_label,l_view_name,l_cursor_key_col,l_data_source,
752: l_node_query,l_cursor_sql,l_node_id
753: , l_res_cat_enum_flag
754: from cs_sr_uwq_nodes_b uwq_b, cs_sr_uwq_nodes_tl uwq_tl
755: where uwq_b.node_id = uwq_tl.node_id
756: and uwq_tl.language = userenv('LANG')
757: and parent_id = l_node_id and enabled_flag='Y'
758: and node_query = 'CURSOR' ;

Line 1032: insert into cs_sr_uwq_nodes_tl

1028: p_last_updated_by,
1029: p_last_update_login,
1030: 1);
1031:
1032: insert into cs_sr_uwq_nodes_tl
1033: (node_id,
1034: node_label,
1035: creation_date,
1036: created_by,

Line 1116: update cs_sr_uwq_nodes_tl set

1112: last_update_login = p_last_update_login,
1113: object_version_number = p_object_version_number + 1
1114: where node_id = p_node_id;
1115:
1116: update cs_sr_uwq_nodes_tl set
1117: node_label = p_node_label,
1118: creation_date = p_creation_date,
1119: created_by = p_created_by,
1120: last_update_date = p_last_update_date,