[Home] [Help]
2299: begin
2300:
2301: DELETE
2302: from
2303: amw_fin_cert_ctrl_sum
2304: where
2305: fin_certification_id = x_fin_certification_id ;
2306:
2307:
2567:
2568: /* select
2569: fin_certification_id into var_fin_certification_id
2570: from
2571: amw_fin_cert_ctrl_sum
2572: where
2573: fin_certification_id = x_fin_certification_id and
2574: financial_statement_id = x_financial_statement_id and
2575: NVL(financial_item_id, -1) = NVL(x_financial_item_id, -1) and
2581: WHEN NO_DATA_FOUND THEN
2582: */
2583: --dbms_output.put_line('inserting data');
2584:
2585: insert into amw_fin_cert_ctrl_sum (
2586: fin_certification_id ,
2587: financial_statement_id ,
2588: financial_item_id ,
2589: account_group_id ,
3053: ctrl_attr_code_28,
3054: ctrl_attr_code_29,
3055: ctrl_attr_code_30
3056: from
3057: amw_fin_cert_ctrl_sum
3058: where
3059: fin_certification_id = P_CERTIFICATION_ID and
3060: ctrl_attribute_type = par_type and
3061: ROWNUM <2;
3364: ineff_ctrl_attr_28,
3365: ineff_ctrl_attr_29,
3366: ineff_ctrl_attr_30
3367: from
3368: amw_fin_cert_ctrl_sum
3369: where
3370: fin_certification_id = P_CERTIFICATION_ID and
3371: ctrl_attribute_type = par_type and
3372: ROWNUM <2
3728: ineff_ctrl_attr_28,
3729: ineff_ctrl_attr_29,
3730: ineff_ctrl_attr_30
3731: from
3732: amw_fin_cert_ctrl_sum
3733: where
3734: fin_certification_id = P_CERTIFICATION_ID and
3735: ctrl_attribute_type = par_type and
3736: ROWNUM <2;
4090: ineff_ctrl_attr_28,
4091: ineff_ctrl_attr_29,
4092: ineff_ctrl_attr_30
4093: from
4094: amw_fin_cert_ctrl_sum
4095: where
4096: fin_certification_id = P_CERTIFICATION_ID and
4097: ctrl_attribute_type = par_type and
4098: ROWNUM <2
4484: acc_assert_flag_29 ,
4485: acc_assert_flag_30
4486:
4487: from
4488: amw_fin_cert_ctrl_sum
4489: where
4490: fin_certification_id = P_CERTIFICATION_ID and
4491: ctrl_attribute_type = par_type and
4492: ROWNUM <2;
4971: acc_assert_flag_28 ,
4972: acc_assert_flag_29 ,
4973: acc_assert_flag_30
4974: from
4975: amw_fin_cert_ctrl_sum
4976: where
4977: fin_certification_id = P_CERTIFICATION_ID and
4978: ctrl_attribute_type = par_type and
4979: ROWNUM <2
5481: --******************************************************************************************************
5482: -- NOTE: The values in x_ineff_ctrl_attr_(1 .. 30) may be +1 or -1 depending on the change_flag b or f respectively
5483: --******************************************************************************************************
5484: UPDATE
5485: amw_fin_cert_ctrl_sum
5486: SET
5487: ineff_ctrl_attr_1= x_ineff_ctrl_attr_1
5488: ,ineff_ctrl_attr_2= x_ineff_ctrl_attr_2
5489: ,ineff_ctrl_attr_3= x_ineff_ctrl_attr_3
5714: --******************************************************************************************************
5715: -- NOTE: The values in x_ineff_ctrl_attr_(1 .. 30) may be +1 or -1 depending on the change_flag b or f respectively
5716: --******************************************************************************************************
5717: UPDATE
5718: amw_fin_cert_ctrl_sum
5719: SET
5720: ineff_ctrl_attr_1= x_ineff_ctrl_attr_1
5721: ,ineff_ctrl_attr_2 = x_ineff_ctrl_attr_2
5722: ,ineff_ctrl_attr_3= x_ineff_ctrl_attr_3
5948: --******************************************************************************************************
5949:
5950:
5951: UPDATE
5952: amw_fin_cert_ctrl_sum
5953: SET
5954: ineff_ctrl_attr_1= x_ineff_ctrl_attr_1
5955: ,ineff_ctrl_attr_2 = x_ineff_ctrl_attr_2
5956: ,ineff_ctrl_attr_3= x_ineff_ctrl_attr_3
6185:
6186:
6187:
6188: UPDATE
6189: amw_fin_cert_ctrl_sum
6190: SET
6191: ineff_ctrl_attr_1= x_ineff_ctrl_attr_1
6192: ,ineff_ctrl_attr_2 = x_ineff_ctrl_attr_2
6193: ,ineff_ctrl_attr_3= x_ineff_ctrl_attr_3
6466: total_ctrl_attr_29,
6467: total_ctrl_attr_30
6468: from
6469: amw_certification_vl cert,
6470: amw_fin_cert_ctrl_sum ctrlsum
6471: where
6472: cert.certification_id = ctrlsum.fin_certification_id and
6473: ctrl_attribute_type = 'CTRL_ASSERTIONS'
6474: and
6873: total_ctrl_attr_29,
6874: total_ctrl_attr_30
6875: from
6876: amw_certification_vl cert,
6877: amw_fin_cert_ctrl_sum ctrlsum,
6878: amw_fin_cert_scope scope
6879: where
6880: cert.certification_id = ctrlsum.fin_certification_id and
6881: ctrl_attribute_type = 'CTRL_ASSERTIONS'
7180: ) is
7181:
7182: begin
7183: UPDATE
7184: amw_fin_cert_ctrl_sum
7185: SET
7186: acc_assert_flag_1= x_acc_assert_flag1
7187: ,acc_assert_flag_2 = x_acc_assert_flag2
7188: ,acc_assert_flag_3= x_acc_assert_flag3
7278: ) is
7279:
7280: begin
7281: UPDATE
7282: amw_fin_cert_ctrl_sum
7283: SET
7284: acc_assert_flag_1= x_acc_assert_flag1
7285: ,acc_assert_flag_2 = x_acc_assert_flag2
7286: ,acc_assert_flag_3= x_acc_assert_flag3
7522: total_ctrl_attr_28,
7523: total_ctrl_attr_29,
7524: total_ctrl_attr_30
7525: from
7526: amw_fin_cert_ctrl_sum ctrlsum
7527: where
7528: FIN_CERTIFICATION_ID= P_CERTFICATION_ID
7529: and ctrl_attribute_type = 'CTRL_ASSERTIONS'
7530: AND OBJECT_TYPE='ACCOUNT' AND