APPS.HXC_RPT_LOAD_TC_SNAPSHOT dependencies on HXC_RPT_LAYOUT_COMP_QUERIES

Line 1150: -- against the queries in HXC_RPT_LAYOUT_COMP_QUERIES

1146:
1147:
1148: -- TRANSLATE_ATTRIBUTES
1149: -- Translates the attributes already loaded into HXC_RPT_TC_DETAILS_ALL table
1150: -- against the queries in HXC_RPT_LAYOUT_COMP_QUERIES
1151:
1152:
1153: PROCEDURE translate_attributes(p_layout_id NUMBER)
1154: AS

Line 1158: FROM hxc_rpt_layout_comp_queries

1154: AS
1155:
1156: CURSOR get_layout_queries( p_layout NUMBER)
1157: IS SELECT attribute||' = '''||component_name||': ''||NVL(('||query||'hx.'||attribute||'),hx.'||attribute||')'
1158: FROM hxc_rpt_layout_comp_queries
1159: WHERE layout_id = p_layout;
1160:
1161: l_update VARCHAR2(4000);
1162: l_curr_layout NUMBER(15);

Line 1181: -- Get the queries associated with layout components from HXC_RPT_LAYOUT_COMP_QUERIES

1177:
1178: BEGIN
1179:
1180: -- Public Procedure translate_attributes
1181: -- Get the queries associated with layout components from HXC_RPT_LAYOUT_COMP_QUERIES
1182: -- one by one thru get_layout_queries
1183: -- Create the dynamic update sql string attaching this query for all the detail
1184: -- records belonging to timecards having this layout id.
1185: -- Execute the dynamic update; repeat all the above steps for each component in the

Line 1186: -- corresponding layout, which has a record in HXC_RPT_LAYOUT_COMP_QUERIES.

1182: -- one by one thru get_layout_queries
1183: -- Create the dynamic update sql string attaching this query for all the detail
1184: -- records belonging to timecards having this layout id.
1185: -- Execute the dynamic update; repeat all the above steps for each component in the
1186: -- corresponding layout, which has a record in HXC_RPT_LAYOUT_COMP_QUERIES.
1187:
1188:
1189: IF g_debug
1190: THEN

Line 2646: -- Used by hxcldvo.lct to load records into HXC_RPT_LAYOUT_COMP_QUERIES.

2642: END load_tc_snapshot;
2643:
2644:
2645: -- INSERT_QUERIES
2646: -- Used by hxcldvo.lct to load records into HXC_RPT_LAYOUT_COMP_QUERIES.
2647:
2648: PROCEDURE insert_queries(p_vo_name VARCHAR2,
2649: p_query VARCHAR2)
2650: AS

Line 2692: -- Used by hxcldvo.lct to load records into HXC_RPT_LAYOUT_COMP_QUERIES

2688:
2689:
2690: -- Public Procedure insert_queries
2691: -- Not used by Load Timecard Snapshot Request.
2692: -- Used by hxcldvo.lct to load records into HXC_RPT_LAYOUT_COMP_QUERIES
2693: -- Inserts the relevant layout information and column name of
2694: -- HXC_RPT_TC_DETAILS_ALL that carries a given component.
2695:
2696: OPEN get_comp_rank ( p_vo_name);

Line 2709: DELETE FROM hxc_rpt_layout_comp_queries

2705: IF layout_comp_tab.COUNT > 0
2706: THEN
2707:
2708: FORALL i IN layout_comp_tab.FIRST..layout_comp_tab.LAST
2709: DELETE FROM hxc_rpt_layout_comp_queries
2710: WHERE layout_component_id = layout_comp_tab(i);
2711:
2712: FORALL i IN layout_tab.FIRST..layout_tab.LAST
2713: DELETE FROM hxc_rpt_layout_comp_queries

Line 2713: DELETE FROM hxc_rpt_layout_comp_queries

2709: DELETE FROM hxc_rpt_layout_comp_queries
2710: WHERE layout_component_id = layout_comp_tab(i);
2711:
2712: FORALL i IN layout_tab.FIRST..layout_tab.LAST
2713: DELETE FROM hxc_rpt_layout_comp_queries
2714: WHERE layout_id = layout_tab(i)
2715: AND attribute = attribute_tab(i);
2716:
2717: FORALL i IN layout_comp_tab.FIRST..layout_comp_tab.LAST

Line 2718: INSERT INTO hxc_rpt_layout_comp_queries

2714: WHERE layout_id = layout_tab(i)
2715: AND attribute = attribute_tab(i);
2716:
2717: FORALL i IN layout_comp_tab.FIRST..layout_comp_tab.LAST
2718: INSERT INTO hxc_rpt_layout_comp_queries
2719: ( layout_id,
2720: layout_component_id,
2721: component_name,
2722: query,