[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
t_component_dim_dc.DELETE;
t_display_code.DELETE;
SELECT dimension_active_flag
INTO l_dim_active_flag
FROM Fem_Xdim_Dimensions_VL
WHERE dimension_varchar_label = p_dimension_varchar_label;
t_metadata.DELETE;
SELECT x.dimension_id
,x.member_col
,x.member_display_code_col
,x.member_b_table_name
,x.value_set_required_flag
FROM FEM_COLUMN_REQUIREMNT_B c
,FEM_XDIM_DIMENSIONS x
WHERE c.dimension_id = x.dimension_id
AND c.cost_obj_dim_component_flag = 'Y'
ORDER BY 1 )
LOOP
FOR i IN 1 .. t_metadata.COUNT LOOP
IF c_metadata_cost.member_display_code_col = t_component_dim_dc(i) THEN
t_metadata(i).dimension_id := c_metadata_cost.dimension_id;
' SELECT '||c_metadata_cost.member_col||
' FROM '||c_metadata_cost.member_b_table_name||
' WHERE enabled_flag = ''Y'''||
' AND '||c_metadata_cost.member_display_code_col||' = :b_dc_val';
g_select_statement :=
'SELECT b.rowid,'||
' GLOBAL_VS_COMBO_DISPLAY_CODE,'||
' financial_elem_display_code,'||
' ledger_display_code,'||
' product_display_code,'||
' CCTR_ORG_DISPLAY_CODE,'||
' customer_display_code,'||
' channel_display_code,'||
' project_display_code,'||
' user_dim1_display_code,'||
' user_dim2_display_code,'||
' user_dim3_display_code,'||
' user_dim4_display_code,'||
' user_dim5_display_code,'||
' user_dim6_display_code,'||
' user_dim7_display_code,'||
' user_dim8_display_code,'||
' user_dim9_display_code,'||
' user_dim10_display_code,'||
' status'||
' FROM FEM_COST_OBJECTS_T B'||
' WHERE {{data_slice}} ';
SELECT x.dimension_id
,x.member_col
,x.member_display_code_col
,x.member_b_table_name
,x.value_set_required_flag
FROM FEM_COLUMN_REQUIREMNT_B c
,FEM_XDIM_DIMENSIONS x
WHERE c.dimension_id = x.dimension_id
AND c.activity_dim_component_flag = 'Y'
ORDER BY 1 )
LOOP
FOR i IN 1 .. t_metadata.COUNT LOOP
IF c_metadata_activity.member_display_code_col
= t_component_dim_dc(i) THEN
t_metadata(i).dimension_id := c_metadata_activity.dimension_id;
' SELECT '||c_metadata_activity.member_col||
' FROM '||c_metadata_activity.member_b_table_name||
' WHERE enabled_flag = ''Y'''||
' AND '||c_metadata_activity.member_display_code_col||' = :b_dc_val';
g_select_statement :=
'SELECT b.rowid,'||
' GLOBAL_VS_COMBO_DISPLAY_CODE,'||
' TASK_DISPLAY_CODE,'||
' CCTR_ORG_DISPLAY_CODE,'||
' customer_display_code,'||
' channel_display_code,'||
' product_display_code,'||
' project_display_code,'||
' user_dim1_display_code,'||
' user_dim2_display_code,'||
' user_dim3_display_code,'||
' user_dim4_display_code,'||
' user_dim5_display_code,'||
' user_dim6_display_code,'||
' user_dim7_display_code,'||
' user_dim8_display_code,'||
' user_dim9_display_code,'||
' user_dim10_display_code,'||
' status'||
' FROM FEM_ACTIVITIES_T B'||
' WHERE {{data_slice}} ';
g_select_statement := g_select_statement||' AND status = ''LOAD''';
| dimension members and inserts only the valid records into the member table
| of Composite Dimensions.The invalid records will be processed in
| 'Error Reproceesing' Mode.
|
| SCOPE - PRIVATE
|
| EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
|
| ARGUMENTS :
|
| RETURNS : NONE
|
| NOTES
|
|
| MODIFICATION HISTORY
| Aturlapa 31-MAR-05 Created
| sshanmug 17-MAY-05 Incorporated comments from Nico
| sshanmug 09-Jun-05 Changed the signature of the Process_Rows as
| per 'Bind Variable Push MP Framework'
| navekuma 25-Apr-06 Bug#4736810 error counts not appearing in Concurrent Log.
+===========================================================================*/
PROCEDURE Process_Rows(p_eng_sql IN VARCHAR2
,p_slc_pred IN VARCHAR2
,p_proc_num IN VARCHAR2
,p_part_code IN VARCHAR2
,p_fetch_limit IN NUMBER
,p_dimension_varchar_label IN VARCHAR2
,p_execution_mode IN VARCHAR2
,p_structure_id IN NUMBER
,p_req_id IN NUMBER )
IS
c_proc_name CONSTANT VARCHAR2(20) := 'Process_Rows';
v_select_stmt LONG;
v_update_stmt VARCHAR2(4000);
v_delete_stmt VARCHAR2(4000);
v_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
v_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
v_insert_cost_stmt CONSTANT LONG :=
'INSERT INTO FEM_COST_OBJECTS ('||
' COST_OBJECT_ID, '||
' COST_OBJECT_DISPLAY_CODE, '||
' SUMMARY_FLAG, '||
' START_DATE_ACTIVE, '||
' END_DATE_ACTIVE, '||
' COST_OBJECT_STRUCTURE_ID, '||
' LOCAL_VS_COMBO_ID, '||
' UOM_CODE, '||
' FINANCIAL_ELEM_ID, '||
' LEDGER_ID, '||
' PRODUCT_ID, '||
' COMPANY_COST_CENTER_ORG_ID, '||
' CUSTOMER_ID, '||
' CHANNEL_ID, '||
' PROJECT_ID, '||
' USER_DIM1_ID, '||
' USER_DIM2_ID, '||
' USER_DIM3_ID, '||
' USER_DIM4_ID, '||
' USER_DIM5_ID, '||
' USER_DIM6_ID, '||
' USER_DIM7_ID, '||
' USER_DIM8_ID, '||
' USER_DIM9_ID, '||
' USER_DIM10_ID, '||
' SEGMENT1, '||
' SEGMENT2, '||
' SEGMENT3, '||
' SEGMENT4, '||
' SEGMENT5, '||
' SEGMENT6, '||
' SEGMENT7, '||
' SEGMENT8, '||
' SEGMENT9, '||
' SEGMENT10, '||
' SEGMENT11, '||
' SEGMENT12, '||
' SEGMENT13, '||
' SEGMENT14, '||
' SEGMENT15, '||
' SEGMENT16, '||
' SEGMENT17, '||
' SEGMENT18, '||
' SEGMENT19, '||
' SEGMENT20, '||
' SEGMENT21, '||
' SEGMENT22, '||
' SEGMENT23, '||
' SEGMENT24, '||
' SEGMENT25, '||
' SEGMENT26, '||
' SEGMENT27, '||
' SEGMENT28, '||
' SEGMENT29, '||
' SEGMENT30, '||
' CREATION_DATE, '||
' CREATED_BY, '||
' LAST_UPDATED_BY, '||
' LAST_UPDATE_DATE, '||
' LAST_UPDATE_LOGIN, '||
' OBJECT_VERSION_NUMBER, '||
' ENABLED_FLAG, '||
' PERSONAL_FLAG, '||
' READ_ONLY_FLAG )'||
' SELECT fem_cost_objects_s.nextval,'||
' :b_COST_OBJECT_DISPLAY_CODE, '||
' :b_SUMMARY_FLAG, '||
' :b_START_DATE_ACTIVE, '||
' :b_END_DATE_ACTIVE, '||
' :b_COST_OBJECT_STRUCTURE_ID, '||
' :b_LOCAL_VS_COMBO_ID, '||
' :b_UOM_CODE, '||
' :b_FINANCIAL_ELEM_ID, '||
' :b_LEDGER_ID, '||
' :b_PRODUCT_ID, '||
' :b_COMPANY_COST_CENTER_ORG_ID, '||
' :b_CUSTOMER_ID, '||
' :b_CHANNEL_ID, '||
' :b_PROJECT_ID, '||
' :b_USER_DIM1_ID, '||
' :b_USER_DIM2_ID, '||
' :b_USER_DIM3_ID, '||
' :b_USER_DIM4_ID, '||
' :b_USER_DIM5_ID, '||
' :b_USER_DIM6_ID, '||
' :b_USER_DIM7_ID, '||
' :b_USER_DIM8_ID, '||
' :b_USER_DIM9_ID, '||
' :b_USER_DIM10_ID, '||
' :b_SEGMENT1, '||
' :b_SEGMENT2, '||
' :b_SEGMENT3, '||
' :b_SEGMENT4, '||
' :b_SEGMENT5, '||
' :b_SEGMENT6, '||
' :b_SEGMENT7, '||
' :b_SEGMENT8, '||
' :b_SEGMENT9, '||
' :b_SEGMENT10, '||
' :b_SEGMENT11, '||
' :b_SEGMENT12, '||
' :b_SEGMENT13, '||
' :b_SEGMENT14, '||
' :b_SEGMENT15, '||
' :b_SEGMENT16, '||
' :b_SEGMENT17, '||
' :b_SEGMENT18, '||
' :b_SEGMENT19, '||
' :b_SEGMENT20, '||
' :b_SEGMENT21, '||
' :b_SEGMENT22, '||
' :b_SEGMENT23, '||
' :b_SEGMENT24, '||
' :b_SEGMENT25, '||
' :b_SEGMENT26, '||
' :b_SEGMENT27, '||
' :b_SEGMENT28, '||
' :b_SEGMENT29, '||
' :b_SEGMENT30, '||
' :b_CREATION_DATE, '||
' :b_CREATED_BY, '||
' :b_LAST_UPDATED_BY, '||
' :b_LAST_UPDATE_DATE, '||
' :b_LAST_UPDATE_LOGIN, '||
' :b_OBJECT_VERSION_NUMBER, '||
' :b_ENABLED_FLAG, '||
' :b_PERSONAL_FLAG, '||
' :b_read_only_flag '||
' FROM dual'||
' WHERE :b_status = ''LOAD''';
v_insert_activity_stmt CONSTANT LONG :=
'INSERT INTO FEM_ACTIVITIES ('||
' ACTIVITY_ID, '||
' ACTIVITY_DISPLAY_CODE, '||
' SUMMARY_FLAG, '||
' START_DATE_ACTIVE, '||
' END_DATE_ACTIVE, '||
' ACTIVITY_STRUCTURE_ID, '||
' LOCAL_VS_COMBO_ID, '||
' TASK_ID, '||
' COMPANY_COST_CENTER_ORG_ID, '||
' CUSTOMER_ID, '||
' CHANNEL_ID, '||
' PRODUCT_ID, '||
' PROJECT_ID, '||
' USER_DIM1_ID, '||
' USER_DIM2_ID, '||
' USER_DIM3_ID, '||
' USER_DIM4_ID, '||
' USER_DIM5_ID, '||
' USER_DIM6_ID, '||
' USER_DIM7_ID, '||
' USER_DIM8_ID, '||
' USER_DIM9_ID, '||
' USER_DIM10_ID, '||
' SEGMENT1, '||
' SEGMENT2, '||
' SEGMENT3, '||
' SEGMENT4, '||
' SEGMENT5, '||
' SEGMENT6, '||
' SEGMENT7, '||
' SEGMENT8, '||
' SEGMENT9, '||
' SEGMENT10, '||
' SEGMENT11, '||
' SEGMENT12, '||
' SEGMENT13, '||
' SEGMENT14, '||
' SEGMENT15, '||
' SEGMENT16, '||
' SEGMENT17, '||
' SEGMENT18, '||
' SEGMENT19, '||
' SEGMENT20, '||
' SEGMENT21, '||
' SEGMENT22, '||
' SEGMENT23, '||
' SEGMENT24, '||
' SEGMENT25, '||
' SEGMENT26, '||
' SEGMENT27, '||
' SEGMENT28, '||
' SEGMENT29, '||
' SEGMENT30, '||
' CREATION_DATE, '||
' CREATED_BY, '||
' LAST_UPDATED_BY, '||
' LAST_UPDATE_DATE, '||
' LAST_UPDATE_LOGIN, '||
' OBJECT_VERSION_NUMBER, '||
' ENABLED_FLAG, '||
' PERSONAL_FLAG, '||
' READ_ONLY_FLAG )'||
' SELECT fem_activities_s.nextval,'||
' :b_ACTIVITY_DISPLAY_CODE, '||
' :b_SUMMARY_FLAG, '||
' :b_START_DATE_ACTIVE, '||
' :b_END_DATE_ACTIVE, '||
' :b_ACTIVITY_STRUCTURE_ID, '||
' :b_LOCAL_VS_COMBO_ID, '||
' :b_TASK_ID, '||
' :b_COMPANY_COST_CENTER_ORG_ID, '||
' :b_CUSTOMER_ID, '||
' :b_CHANNEL_ID, '||
' :b_PRODUCT_ID, '||
' :b_PROJECT_ID, '||
' :b_USER_DIM1_ID, '||
' :b_USER_DIM2_ID, '||
' :b_USER_DIM3_ID, '||
' :b_USER_DIM4_ID, '||
' :b_USER_DIM5_ID, '||
' :b_USER_DIM6_ID, '||
' :b_USER_DIM7_ID, '||
' :b_USER_DIM8_ID, '||
' :b_USER_DIM9_ID, '||
' :b_USER_DIM10_ID, '||
' :b_SEGMENT1, '||
' :b_SEGMENT2, '||
' :b_SEGMENT3, '||
' :b_SEGMENT4, '||
' :b_SEGMENT5, '||
' :b_SEGMENT6, '||
' :b_SEGMENT7, '||
' :b_SEGMENT8, '||
' :b_SEGMENT9, '||
' :b_SEGMENT10, '||
' :b_SEGMENT11, '||
' :b_SEGMENT12, '||
' :b_SEGMENT13, '||
' :b_SEGMENT14, '||
' :b_SEGMENT15, '||
' :b_SEGMENT16, '||
' :b_SEGMENT17, '||
' :b_SEGMENT18, '||
' :b_SEGMENT19, '||
' :b_SEGMENT20, '||
' :b_SEGMENT21, '||
' :b_SEGMENT22, '||
' :b_SEGMENT23, '||
' :b_SEGMENT24, '||
' :b_SEGMENT25, '||
' :b_SEGMENT26, '||
' :b_SEGMENT27, '||
' :b_SEGMENT28, '||
' :b_SEGMENT29, '||
' :b_SEGMENT30, '||
' :b_CREATION_DATE, '||
' :b_CREATED_BY, '||
' :b_LAST_UPDATED_BY, '||
' :b_LAST_UPDATE_DATE, '||
' :b_LAST_UPDATE_LOGIN, '||
' :b_OBJECT_VERSION_NUMBER, '||
' :b_ENABLED_FLAG, '||
' :b_PERSONAL_FLAG, '||
' :b_read_only_flag '||
' FROM dual'||
' WHERE :b_status = ''LOAD''';
v_update_cost_stmt CONSTANT VARCHAR2(4000) :=
'UPDATE FEM_COST_OBJECTS_T '||
' SET status = :b_status'||
' WHERE rowid = :b_rowid';
v_update_activity_stmt CONSTANT VARCHAR2(4000) :=
'UPDATE FEM_ACTIVITIES_T '||
' SET status = :b_status'||
' WHERE rowid = :b_rowid';
v_delete_cost_stmt CONSTANT VARCHAR2(4000) :=
'DELETE FROM FEM_COST_OBJECTS_T '||
' WHERE rowid = :b_rowid'||
' AND :b_status = ''LOAD''';
v_delete_activity_stmt CONSTANT VARCHAR2(4000) :=
'DELETE FROM FEM_ACTIVITIES_T '||
' WHERE rowid = :b_rowid'||
' AND :b_status = ''LOAD''';
v_select_stmt := REPLACE(g_select_statement,'{{data_slice}}',v_data_slc);
v_update_stmt := v_update_cost_stmt;
v_delete_stmt := v_delete_cost_stmt;
v_update_stmt := v_update_activity_stmt;
v_delete_stmt := v_delete_activity_stmt;
,p_msg_text => 'v_update_stmt '||v_update_stmt||
'v_member_table_name '||v_member_table_name);
,p_msg_text => 'v_delete_stmt '||v_delete_stmt||
'v_member_table_name '||v_member_table_name);
v_select_stmt := REPLACE(v_select_stmt,'{{table_partition}}',v_part_name);
' UPDATE '||v_member_table_name||' b'||
' SET status = ''LOAD'''||
' WHERE status <> ''LOAD'''||
' AND '||v_data_slc
USING v_slc_val1,v_slc_val2,v_slc_val3,v_slc_val4;
' UPDATE '||v_member_table_name||' b'||
' SET status = ''LOAD'''||
' WHERE status <> ''LOAD'''||
' AND '||v_data_slc
USING v_slc_val1,v_slc_val2,v_slc_val3;
' UPDATE '||v_member_table_name||' b'||
' SET status = ''LOAD'''||
' WHERE status <> ''LOAD'''||
' AND '||v_data_slc
USING v_slc_val1,v_slc_val2;
' UPDATE '||v_member_table_name||' b'||
' SET status = ''LOAD'''||
' WHERE status <> ''LOAD'''||
' AND '||v_data_slc
USING v_slc_val1;
l_validation_sql:= ' SELECT B.rowid '||
' FROM '||v_member_table_name||' B'||
' WHERE not exists '||
' (SELECT 1 FROM fem_global_vs_combos_b g '||
' WHERE B.global_vs_combo_display_code= g.global_vs_combo_display_code)'||
' AND B.status = ''LOAD'''||
-- ' AND 1=1';
EXECUTE IMMEDIATE v_update_stmt USING lv_status,t_rowid(i);
t_rowid.DELETE;
SELECT a.attribute_id
,v.version_id
,a.attribute_varchar_label
,a.dimension_id
FROM fem_dim_attributes_vl a
,fem_dim_attr_versions_vl v
WHERE a.attribute_id = v.attribute_id
AND v.default_version_flag = 'Y'
AND (
(a.attribute_varchar_label IN ('COST_OBJECT_UNIT_FLAG','DATA_TYPE_CODE')
AND a.dimension_id = 12) -- Financial Element
OR
(a.attribute_varchar_label IN ('GLOBAL_VS_COMBO')
AND a.dimension_id = 7) -- Ledger
)
AND v.default_version_flag = 'Y' )
LOOP
IF c_attr.dimension_id = 12 THEN -- Financial Element
IF c_attr.attribute_varchar_label = 'COST_OBJECT_UNIT_FLAG' THEN
l_count :=0 ;
l_validation_sql:= ' SELECT b.rowid'||
' FROM fem_cost_objects_t b'||
' ,fem_fin_elems_attr a'||
' ,fem_fin_elems_vl m'||
' WHERE a.financial_elem_id = m.financial_elem_id'||
' AND m.financial_elem_display_code = b.financial_elem_display_code'||
' AND a.attribute_id = '||c_attr.attribute_id||
' AND a.version_id = '||c_attr.version_id||
' AND a.dim_attribute_varchar_member <> ''Y'''||
' AND b.status = ''LOAD'''||
' AND '||v_data_slc;
EXECUTE IMMEDIATE v_update_stmt USING lv_status,t_rowid(i);
' SELECT b.rowid'||
' FROM fem_cost_objects_t b'||
' ,fem_fin_elems_attr a'||
' ,fem_fin_elems_vl m'||
' WHERE a.financial_elem_id = m.financial_elem_id'||
' AND m.financial_elem_display_code = b.financial_elem_display_code'||
' AND a.attribute_id = '||c_attr.attribute_id||
' AND a.version_id = '||c_attr.version_id||
' AND a.dim_attribute_varchar_member <> ''RATE'''||
' AND b.status = ''LOAD'''||
' AND '||v_data_slc;
EXECUTE IMMEDIATE v_update_stmt USING lv_status,t_rowid(i);
l_validation_sql := ' SELECT b.rowid'||
' FROM fem_cost_objects_t b'||
' WHERE NOT EXISTS ('||
' SELECT 1'||
' FROM fem_ledgers_b l'||
' ,fem_ledgers_attr a'||
' ,fem_global_vs_combos_b g'||
' WHERE l.ledger_display_code = b.ledger_display_code'||
' AND a.ledger_id = l.ledger_id'||
' AND a.attribute_id = '||c_attr.attribute_id||
' AND a.version_id = '||c_attr.version_id||
' AND a.dim_attribute_numeric_member = g.global_vs_combo_id'||
' AND g.global_vs_combo_display_code = b.global_vs_combo_display_code'||
' )'||
' AND status = ''LOAD'''||
' AND '||v_data_slc;
EXECUTE IMMEDIATE v_update_stmt USING lv_status,t_rowid(i);
t_rowid.DELETE;
l_validation_sql:= ' SELECT b.rowid '||
' FROM '||v_member_table_name||' b'||
' WHERE '||t_metadata(i).member_display_code_col||' is null'||
' AND status = ''LOAD'''||
' AND '||v_data_slc;
l_validation_sql:= ' SELECT b.rowid '||
' FROM '||v_member_table_name||' b'||
' WHERE '||t_metadata(i).member_display_code_col||' is not null'||
' AND status = ''LOAD'''||
' AND '||v_data_slc;
EXECUTE IMMEDIATE v_update_stmt USING lv_status,t_rowid(i);
t_rowid.DELETE;
v_select_stmt
USING v_slc_val1,v_slc_val2,v_slc_val3,v_slc_val4;
v_select_stmt
USING v_slc_val1,v_slc_val2,v_slc_val3;
v_select_stmt
USING v_slc_val1,v_slc_val2;
v_select_stmt
USING v_slc_val1;
SELECT g.dimension_id
,g.value_set_id
,g.global_vs_combo_id
FROM FEM_GLOBAL_VS_COMBO_DEFS g,
FEM_GLOBAL_VS_COMBOS_b m
WHERE g.global_vs_combo_id = m.global_vs_combo_id
AND g.dimension_id = t_metadata(i).dimension_id
AND m.global_vs_combo_display_code = t_global_vs_combo_dc(j)
ORDER BY 1)
LOOP
t_global_vs_combo_id(j) := c_value_set.global_vs_combo_id;
SELECT ledger_id
INTO t_ledger_id(j)
FROM fem_ledgers_vl
WHERE ledger_display_code = t_ledger_dc(j);
SELECT prod.dim_attribute_varchar_member AS uom_code
INTO t_uom_code(j)
FROM fem_products_attr prod,
fem_dim_attributes_b attr,
fem_dim_attr_versions_vl ver
WHERE prod.product_id = t_product_id(j)
AND prod.attribute_id = attr.attribute_id
AND prod.version_id = ver.version_id
AND attr.attribute_varchar_label = 'PRODUCT_UOM'
AND ver.attribute_id = attr.attribute_id
AND ver.default_version_flag = 'Y';
SELECT default_member_display_code INTO t_uom_code(j)
FROM Fem_Xdim_Dimensions_VL
WHERE dimension_varchar_label = 'UOM';
SELECT default_member_display_code INTO t_uom_code(j)
FROM Fem_Xdim_Dimensions_VL
WHERE dimension_varchar_label = 'UOM';
EXECUTE IMMEDIATE v_insert_cost_stmt
USING t_display_code(i),
'N',
sysdate,
sysdate,
p_structure_id,
t_global_vs_combo_id(i),
t_uom_code(i),
t_fin_elem_id(i),
t_ledger_id(i),
t_product_id(i),
t_cctr_org_id(i),
t_customer_id(i),
t_channel_id(i),
t_project_id(i),
t_user_dim1_id(i),
t_user_dim2_id(i),
t_user_dim3_id(i),
t_user_dim4_id(i),
t_user_dim5_id(i),
t_user_dim6_id(i),
t_user_dim7_id(i),
t_user_dim8_id(i),
t_user_dim9_id(i),
t_user_dim10_id(i),
t_fin_elem_dc(i),
t_ledger_dc(i),
t_product_dc(i),
t_cctr_org_dc(i),
t_customer_dc(i),
t_channel_dc(i),
t_project_dc(i),
t_user_dim1_dc(i),
t_user_dim2_dc(i),
t_user_dim3_dc(i),
t_user_dim4_dc(i),
t_user_dim5_dc(i),
t_user_dim6_dc(i),
t_user_dim7_dc(i),
t_user_dim8_dc(i),
t_user_dim9_dc(i),
t_user_dim10_dc(i),
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
sysdate,
v_CREATED_BY,
v_LAST_UPDATED_BY,
sysdate,
v_LAST_UPDATE_LOGIN,
1,
'Y',
'N',
'N',
t_status(i);
EXECUTE IMMEDIATE v_insert_activity_stmt
USING t_display_code(i),
'N',
sysdate,
sysdate,
p_structure_id,
t_global_vs_combo_id(i),
t_task_id(i),
t_cctr_org_id(i),
t_customer_id(i),
t_channel_id(i),
t_product_id(i),
t_project_id(i),
t_user_dim1_id(i),
t_user_dim2_id(i),
t_user_dim3_id(i),
t_user_dim4_id(i),
t_user_dim5_id(i),
t_user_dim6_id(i),
t_user_dim7_id(i),
t_user_dim8_id(i),
t_user_dim9_id(i),
t_user_dim10_id(i),
t_task_dc(i),
t_cctr_org_dc(i),
t_customer_dc(i),
t_channel_dc(i),
t_product_dc(i),
t_project_dc(i),
t_user_dim1_dc(i),
t_user_dim2_dc(i),
t_user_dim3_dc(i),
t_user_dim4_dc(i),
t_user_dim5_dc(i),
t_user_dim6_dc(i),
t_user_dim7_dc(i),
t_user_dim8_dc(i),
t_user_dim9_dc(i),
t_user_dim10_dc(i),
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
sysdate,
v_CREATED_BY,
v_LAST_UPDATED_BY,
sysdate,
v_LAST_UPDATE_LOGIN,
1,
'Y',
'N',
'N',
t_status(i);
EXECUTE IMMEDIATE v_update_stmt USING t_status(i),t_rowid(i);
EXECUTE IMMEDIATE v_delete_stmt USING t_rowid(i),t_status(i);
t_fin_elem_id.DELETE;
t_ledger_id.DELETE;
t_rowid.DELETE;
t_global_vs_combo_id.DELETE;
t_task_id.DELETE;
t_cctr_org_id.DELETE;
t_channel_id.DELETE;
t_customer_id.DELETE;
t_product_id.DELETE;
t_project_id.DELETE;
t_user_dim1_id.DELETE;
t_user_dim2_id.DELETE;
t_user_dim3_id.DELETE;
t_user_dim4_id.DELETE;
t_user_dim5_id.DELETE;
t_user_dim6_id.DELETE;
t_user_dim7_id.DELETE;
t_user_dim8_id.DELETE;
t_user_dim9_id.DELETE;
t_user_dim10_id.DELETE;
t_global_vs_combo_dc.DELETE;
t_task_dc.DELETE;
t_cctr_org_dc.DELETE;
t_channel_dc.DELETE;
t_customer_dc.DELETE;
t_product_dc.DELETE;
t_project_dc.DELETE;
t_fin_elem_dc.DELETE;
t_ledger_dc.DELETE;
t_user_dim1_dc.DELETE;
t_user_dim2_dc.DELETE;
t_user_dim3_dc.DELETE;
t_user_dim4_dc.DELETE;
t_user_dim5_dc.DELETE;
t_user_dim6_dc.DELETE;
t_user_dim7_dc.DELETE;
t_user_dim8_dc.DELETE;
t_user_dim9_dc.DELETE;
t_user_dim10_dc.DELETE;
t_display_code.DELETE;
t_status.DELETE;