APPS.HXC_RPT_LOAD_TC_SNAPSHOT dependencies on HXC_RPT_LAYOUT_COMP_QUERIES

Line 1148: -- against the queries in HXC_RPT_LAYOUT_COMP_QUERIES

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

Line 1156: FROM hxc_rpt_layout_comp_queries

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

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

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

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

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

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

2547: END load_tc_snapshot;
2548:
2549:
2550: -- INSERT_QUERIES
2551: -- Used by hxcldvo.lct to load records into HXC_RPT_LAYOUT_COMP_QUERIES.
2552:
2553: PROCEDURE insert_queries(p_vo_name VARCHAR2,
2554: p_query VARCHAR2)
2555: AS

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

2593:
2594:
2595: -- Public Procedure insert_queries
2596: -- Not used by Load Timecard Snapshot Request.
2597: -- Used by hxcldvo.lct to load records into HXC_RPT_LAYOUT_COMP_QUERIES
2598: -- Inserts the relevant layout information and column name of
2599: -- HXC_RPT_TC_DETAILS_ALL that carries a given component.
2600:
2601: OPEN get_comp_rank ( p_vo_name);

Line 2614: DELETE FROM hxc_rpt_layout_comp_queries

2610: IF layout_comp_tab.COUNT > 0
2611: THEN
2612:
2613: FORALL i IN layout_comp_tab.FIRST..layout_comp_tab.LAST
2614: DELETE FROM hxc_rpt_layout_comp_queries
2615: WHERE layout_component_id = layout_comp_tab(i);
2616:
2617: FORALL i IN layout_tab.FIRST..layout_tab.LAST
2618: DELETE FROM hxc_rpt_layout_comp_queries

Line 2618: DELETE FROM hxc_rpt_layout_comp_queries

2614: DELETE FROM hxc_rpt_layout_comp_queries
2615: WHERE layout_component_id = layout_comp_tab(i);
2616:
2617: FORALL i IN layout_tab.FIRST..layout_tab.LAST
2618: DELETE FROM hxc_rpt_layout_comp_queries
2619: WHERE layout_id = layout_tab(i)
2620: AND attribute = attribute_tab(i);
2621:
2622: FORALL i IN layout_comp_tab.FIRST..layout_comp_tab.LAST

Line 2623: INSERT INTO hxc_rpt_layout_comp_queries

2619: WHERE layout_id = layout_tab(i)
2620: AND attribute = attribute_tab(i);
2621:
2622: FORALL i IN layout_comp_tab.FIRST..layout_comp_tab.LAST
2623: INSERT INTO hxc_rpt_layout_comp_queries
2624: ( layout_id,
2625: layout_component_id,
2626: component_name,
2627: query,