APPS.AMW_FIN_COSO_VIEWS_PVT dependencies on AMW_FIN_COSO_VIEWS_PVT

Line 1: PACKAGE BODY amw_fin_coso_views_pvt as

1: PACKAGE BODY amw_fin_coso_views_pvt as
2: /* $Header: amwcfcvb.pls 120.0.12000000.2 2007/04/02 16:45:02 dliao ship $ */
3:
4:
5: PROCEDURE create_fin_ctrl_components

Line 532: amw_fin_coso_views_pvt.INSERT_ROW(

528: -- ************************** CALL Proc to Insert Data into the Table **************************************** --
529:
530: m_object_version_number := 1;
531:
532: amw_fin_coso_views_pvt.INSERT_ROW(
533: x_fin_certification_id => P_CERTIFICATION_ID ,
534: x_financial_statement_id => P_FINANCIAL_STATEMENT_ID ,
535: x_financial_item_id => P_FINANCIAL_ITEM_ID ,
536: x_account_group_id => P_ACCOUNT_GROUP_ID ,

Line 1241: amw_fin_coso_views_pvt.INSERT_ROW(

1237: -- ************************** CALL Proc to Insert Data into the Table **************************************** --
1238:
1239: --dbms_output.put_line('Objective - before inserting data');
1240:
1241: amw_fin_coso_views_pvt.INSERT_ROW(
1242: x_fin_certification_id => P_CERTIFICATION_ID ,
1243: x_financial_statement_id => P_FINANCIAL_STATEMENT_ID ,
1244: x_financial_item_id => P_FINANCIAL_ITEM_ID ,
1245: x_account_group_id => P_ACCOUNT_GROUP_ID ,

Line 2098: amw_fin_coso_views_pvt.INSERT_ROW(

2094: -- ************************** CALL Proc to Insert Data into the Table **************************************** --
2095:
2096: --dbms_output.put_line('Objective - before inserting data');
2097:
2098: amw_fin_coso_views_pvt.INSERT_ROW(
2099: x_fin_certification_id => P_CERTIFICATION_ID ,
2100: x_financial_statement_id => P_FINANCIAL_STATEMENT_ID ,
2101: x_financial_item_id => P_FINANCIAL_ITEM_ID ,
2102: x_account_group_id => P_ACCOUNT_GROUP_ID ,

Line 3202: amw_fin_coso_views_pvt.UPDATE_FIN_ITEM_ROW(

3198:
3199:
3200:
3201:
3202: amw_fin_coso_views_pvt.UPDATE_FIN_ITEM_ROW(
3203: x_fin_certification_id => P_CERTIFICATION_ID ,
3204: x_financial_statement_id => P_FINANCIAL_STATEMENT_ID ,
3205: x_financial_item_id => P_FINANCIAL_ITEM_ID ,
3206: x_account_group_id => null ,

Line 3560: amw_fin_coso_views_pvt.UPDATE_FIN_ACC_ROW(

3556: end loop; --end of ctrl_coso_codes in comp_of_the_ctrl loop
3557:
3558:
3559:
3560: amw_fin_coso_views_pvt.UPDATE_FIN_ACC_ROW(
3561: x_fin_certification_id => P_CERTIFICATION_ID ,
3562: x_financial_statement_id => NULL ,
3563: x_financial_item_id => NULL ,
3564: x_account_group_id => P_ACCOUNT_GROUP_ID,

Line 3927: amw_fin_coso_views_pvt.UPDATE_FIN_ITEM_ROW(

3923:
3924:
3925:
3926:
3927: amw_fin_coso_views_pvt.UPDATE_FIN_ITEM_ROW(
3928: x_fin_certification_id => P_CERTIFICATION_ID ,
3929: x_financial_statement_id => P_FINANCIAL_STATEMENT_ID ,
3930: x_financial_item_id => P_FINANCIAL_ITEM_ID ,
3931: x_account_group_id => null ,

Line 4276: amw_fin_coso_views_pvt.UPDATE_FIN_ACC_ROW(

4272:
4273:
4274:
4275:
4276: amw_fin_coso_views_pvt.UPDATE_FIN_ACC_ROW(
4277: x_fin_certification_id => P_CERTIFICATION_ID ,
4278: x_financial_statement_id => NULL ,
4279: x_financial_item_id => NULL ,
4280: x_account_group_id => P_ACCOUNT_GROUP_ID,

Line 4747: amw_fin_coso_views_pvt.UPDATE_FINITEM_ASSERT_ROW(

4743:
4744:
4745:
4746:
4747: amw_fin_coso_views_pvt.UPDATE_FINITEM_ASSERT_ROW(
4748: x_fin_certification_id => P_CERTIFICATION_ID ,
4749: x_financial_statement_id => P_FINANCIAL_STATEMENT_ID ,
4750: x_financial_item_id => P_FINANCIAL_ITEM_ID ,
4751: x_account_group_id => null ,

Line 5244: amw_fin_coso_views_pvt.UPDATE_FIN_ACC_ASSERT_ROW(

5240: end loop;
5241: end loop; --end of acc_assertions in ACC_ASSERT_CODES
5242:
5243:
5244: amw_fin_coso_views_pvt.UPDATE_FIN_ACC_ASSERT_ROW(
5245: x_fin_certification_id => P_CERTIFICATION_ID ,
5246: x_financial_statement_id => NULL ,
5247: x_financial_item_id => NULL ,
5248: x_account_group_id => P_ACCOUNT_GROUP_ID,

Line 6666: amw_fin_coso_views_pvt.UPDATE_CTRLSUM_FLAG(

6662:
6663:
6664: ---------------------------------------------------------------------------------------------
6665:
6666: amw_fin_coso_views_pvt.UPDATE_CTRLSUM_FLAG(
6667: x_fin_certification_id => m_cert_id ,
6668: x_natural_account_id => P_ACCOUNT_ID ,
6669: x_ctrl_attribute_type => m_ctrl_attribute_type ,
6670: x_created_by => g_user_id ,

Line 6710: amw_fin_coso_views_pvt.update_parentacc_assert_flags

6706: x_display_flag => m_display_flag );
6707:
6708: -------------------------------------------------------------------------------------
6709:
6710: amw_fin_coso_views_pvt.update_parentacc_assert_flags
6711: (P_ACCOUNT_ID =>P_ACCOUNT_ID ,
6712: P_CERTFICATION_ID => m_cert_id ,
6713: P_ACCOUNT_GROUP_ID => M_ACCOUNT_GROUP_ID);
6714:

Line 6717: amw_fin_coso_views_pvt.update_item_assert_flags

6713: P_ACCOUNT_GROUP_ID => M_ACCOUNT_GROUP_ID);
6714:
6715: -------------------------------------------------------------------------------------
6716:
6717: amw_fin_coso_views_pvt.update_item_assert_flags
6718: ( P_NATRL_ACCOUNT_ID => P_ACCOUNT_ID );
6719:
6720: ---------------------------------------------------------------------------------------
6721: end loop; -- end of load_current_codes loop

Line 7080: amw_fin_coso_views_pvt.UPDATE_CTRLSUM_ITEM_FLAG(

7076: end if;
7077:
7078:
7079: ---------------------------------------------------------------------------------------------
7080: amw_fin_coso_views_pvt.UPDATE_CTRLSUM_ITEM_FLAG(
7081: x_fin_certification_id => m_cert_id ,
7082: x_financial_item_id => m_fin_item_id ,
7083: x_ctrl_attribute_type => m_ctrl_attribute_type ,
7084: x_created_by => g_user_id ,

Line 7356: amw_fin_coso_views_pvt.update_acc_assert_flags(l_acccount_id);

7352: --p_event.GetValueForParameter('SECURITY_GROUP_ID');
7353:
7354: -- fnd_global.apps_initialize (l_user_id, l_resp_id, l_resp_appl_id, l_security_group_id);
7355:
7356: amw_fin_coso_views_pvt.update_acc_assert_flags(l_acccount_id);
7357:
7358:
7359: RETURN 'SUCCESS';
7360: EXCEPTION

Line 7362: WF_CORE.CONTEXT('amw_fin_coso_views_pvt', 'update_acc_assert_flags', p_event.getEventName(), p_subscription_guid);

7358:
7359: RETURN 'SUCCESS';
7360: EXCEPTION
7361: WHEN OTHERS THEN
7362: WF_CORE.CONTEXT('amw_fin_coso_views_pvt', 'update_acc_assert_flags', p_event.getEventName(), p_subscription_guid);
7363: WF_EVENT.setErrorInfo(p_event, 'ERROR');
7364: RETURN 'ERROR';
7365:
7366: end take_new_acc_assertions;

Line 7715: amw_fin_coso_views_pvt.UPDATE_CTRLSUM_FLAG(

7711:
7712:
7713: ---------------------------------------------------------------------------------------------
7714:
7715: amw_fin_coso_views_pvt.UPDATE_CTRLSUM_FLAG(
7716: x_fin_certification_id => m_cert_id ,
7717: x_natural_account_id => M_PARENT_ACCOUNT_ID ,
7718: x_ctrl_attribute_type => m_ctrl_attribute_type ,
7719: x_created_by => g_user_id ,

Line 7782: END amw_fin_coso_views_pvt;

7778: -- ************************************************************************************************************* --
7779:
7780:
7781:
7782: END amw_fin_coso_views_pvt;