57:
58:
59: v_COMPONENT_CODE varchar2(30);
60:
61: g_user_id NUMBER := fnd_global.user_id;
62: g_login_id NUMBER := fnd_global.conc_login_id;
63: g_errbuf VARCHAR2(2000) := null;
64: g_retcode VARCHAR2(2) := '0';
65: m_object_version_number NUMBER;
58:
59: v_COMPONENT_CODE varchar2(30);
60:
61: g_user_id NUMBER := fnd_global.user_id;
62: g_login_id NUMBER := fnd_global.conc_login_id;
63: g_errbuf VARCHAR2(2000) := null;
64: g_retcode VARCHAR2(2) := '0';
65: m_object_version_number NUMBER;
66:
773: m_display_flag varchar2(1) := 'N';
774:
775: v_OBJECTIVE_CODE varchar2(30);
776:
777: g_user_id NUMBER := fnd_global.user_id;
778: g_login_id NUMBER := fnd_global.conc_login_id;
779: g_errbuf VARCHAR2(2000) := null;
780: g_retcode VARCHAR2(2) := '0';
781:
774:
775: v_OBJECTIVE_CODE varchar2(30);
776:
777: g_user_id NUMBER := fnd_global.user_id;
778: g_login_id NUMBER := fnd_global.conc_login_id;
779: g_errbuf VARCHAR2(2000) := null;
780: g_retcode VARCHAR2(2) := '0';
781:
782: -- *************** Currsor to get all Control for the Fianancial Item being Passed ********** --
1492:
1493:
1494: v_ASSERTION_CODE varchar2(30);
1495:
1496: g_user_id NUMBER := fnd_global.user_id;
1497: g_login_id NUMBER := fnd_global.conc_login_id;
1498: g_errbuf VARCHAR2(2000) := null;
1499: g_retcode VARCHAR2(2) := '0';
1500:
1493:
1494: v_ASSERTION_CODE varchar2(30);
1495:
1496: g_user_id NUMBER := fnd_global.user_id;
1497: g_login_id NUMBER := fnd_global.conc_login_id;
1498: g_errbuf VARCHAR2(2000) := null;
1499: g_retcode VARCHAR2(2) := '0';
1500:
1501: -- *************** Currsor to get all Control for the Fianancial Item being Passed ********** --
3078: ctrl.CONTROL_ID = P_CONTROL_ID ;
3079:
3080:
3081:
3082: g_user_id NUMBER := fnd_global.user_id;
3083: g_login_id NUMBER := fnd_global.conc_login_id;
3084: m_object_version_number NUMBER;
3085: ctr integer :=0;
3086: max_num_of_codes integer :=0;
3079:
3080:
3081:
3082: g_user_id NUMBER := fnd_global.user_id;
3083: g_login_id NUMBER := fnd_global.conc_login_id;
3084: m_object_version_number NUMBER;
3085: ctr integer :=0;
3086: max_num_of_codes integer :=0;
3087: m_ctrl_attribute_type VARCHAR2(30) :='CTRL_COMPONENT';
3393: comp.OBJECT_TYPE ='CONTROL' and
3394: ctrl.ORGANIZATION_ID = P_ORG_ID and
3395: ctrl.CONTROL_ID = P_CONTROL_ID ;
3396: ----------------------------------------------------
3397: g_user_id NUMBER := fnd_global.user_id;
3398: g_login_id NUMBER := fnd_global.conc_login_id;
3399: m_object_version_number NUMBER;
3400: ctr integer :=0;
3401: max_num_of_codes integer :=0;
3394: ctrl.ORGANIZATION_ID = P_ORG_ID and
3395: ctrl.CONTROL_ID = P_CONTROL_ID ;
3396: ----------------------------------------------------
3397: g_user_id NUMBER := fnd_global.user_id;
3398: g_login_id NUMBER := fnd_global.conc_login_id;
3399: m_object_version_number NUMBER;
3400: ctr integer :=0;
3401: max_num_of_codes integer :=0;
3402: m_ctrl_attribute_type VARCHAR2(30) :='CTRL_COMPONENT';
3755: ctrl.CONTROL_ID = P_CONTROL_ID ;
3756:
3757:
3758:
3759: g_user_id NUMBER := fnd_global.user_id;
3760: g_login_id NUMBER := fnd_global.conc_login_id;
3761: m_object_version_number NUMBER;
3762: ctr integer :=0;
3763: max_num_of_codes integer :=0;
3756:
3757:
3758:
3759: g_user_id NUMBER := fnd_global.user_id;
3760: g_login_id NUMBER := fnd_global.conc_login_id;
3761: m_object_version_number NUMBER;
3762: ctr integer :=0;
3763: max_num_of_codes integer :=0;
3764: m_ctrl_attribute_type VARCHAR2(30) :='CTRL_OBJECTIVES';
4123: and
4124: ctrl.CONTROL_ID = P_CONTROL_ID ;
4125:
4126: ----------------------------------------------------
4127: g_user_id NUMBER := fnd_global.user_id;
4128: g_login_id NUMBER := fnd_global.conc_login_id;
4129: m_object_version_number NUMBER;
4130: ctr integer :=0;
4131: max_num_of_codes integer :=0;
4124: ctrl.CONTROL_ID = P_CONTROL_ID ;
4125:
4126: ----------------------------------------------------
4127: g_user_id NUMBER := fnd_global.user_id;
4128: g_login_id NUMBER := fnd_global.conc_login_id;
4129: m_object_version_number NUMBER;
4130: ctr integer :=0;
4131: max_num_of_codes integer :=0;
4132: m_ctrl_attribute_type VARCHAR2(30) :='CTRL_OBJECTIVES';
4527: -- *****************************************************************************************************
4528:
4529:
4530:
4531: g_user_id NUMBER := fnd_global.user_id;
4532: g_login_id NUMBER := fnd_global.conc_login_id;
4533: m_object_version_number NUMBER;
4534: ctr integer :=0;
4535: max_num_of_codes integer :=0;
4528:
4529:
4530:
4531: g_user_id NUMBER := fnd_global.user_id;
4532: g_login_id NUMBER := fnd_global.conc_login_id;
4533: m_object_version_number NUMBER;
4534: ctr integer :=0;
4535: max_num_of_codes integer :=0;
4536: m_ctrl_attribute_type VARCHAR2(30) :='CTRL_ASSERTIONS';
5027: ((NATURAL_ACCOUNT_ID =P_ACCOUNT_ID) or (NATURAL_ACCOUNT_ID in (select CHILD_NATURAL_ACCOUNT_ID from amw_fin_key_acct_flat
5028: where PARENT_NATURAL_ACCOUNT_ID =P_ACCOUNT_ID and ACCOUNT_GROUP_ID=P_ACCOUNT_GROUP_ID)));
5029:
5030: ----------------------------------------------------
5031: g_user_id NUMBER := fnd_global.user_id;
5032: g_login_id NUMBER := fnd_global.conc_login_id;
5033: m_object_version_number NUMBER;
5034: ctr integer :=0;
5035: max_num_of_codes integer :=0; m_ctrl_attribute_type VARCHAR2(30) :='CTRL_ASSERTIONS';
5028: where PARENT_NATURAL_ACCOUNT_ID =P_ACCOUNT_ID and ACCOUNT_GROUP_ID=P_ACCOUNT_GROUP_ID)));
5029:
5030: ----------------------------------------------------
5031: g_user_id NUMBER := fnd_global.user_id;
5032: g_login_id NUMBER := fnd_global.conc_login_id;
5033: m_object_version_number NUMBER;
5034: ctr integer :=0;
5035: max_num_of_codes integer :=0; m_ctrl_attribute_type VARCHAR2(30) :='CTRL_ASSERTIONS';
5036: m_OBJECT_TYPE VARCHAR2(50) := 'ACCOUNT';
6326:
6327: v_ASSERTION_CODE varchar2(30);
6328: m_display_flag varchar2(1) := 'N';
6329:
6330: g_user_id NUMBER := fnd_global.user_id;
6331: g_login_id NUMBER := fnd_global.conc_login_id;
6332: g_errbuf VARCHAR2(2000) := null;
6333: g_retcode VARCHAR2(2) := '0';
6334:
6327: v_ASSERTION_CODE varchar2(30);
6328: m_display_flag varchar2(1) := 'N';
6329:
6330: g_user_id NUMBER := fnd_global.user_id;
6331: g_login_id NUMBER := fnd_global.conc_login_id;
6332: g_errbuf VARCHAR2(2000) := null;
6333: g_retcode VARCHAR2(2) := '0';
6334:
6335: -- *************** Currsor to get all Control for the account being Passed ********** --
6760: m_display_flag varchar2(1) := 'N';
6761:
6762: v_ASSERTION_CODE varchar2(30);
6763:
6764: g_user_id NUMBER := fnd_global.user_id;
6765: g_login_id NUMBER := fnd_global.conc_login_id;
6766: g_errbuf VARCHAR2(2000) := null;
6767: g_retcode VARCHAR2(2) := '0';
6768:
6761:
6762: v_ASSERTION_CODE varchar2(30);
6763:
6764: g_user_id NUMBER := fnd_global.user_id;
6765: g_login_id NUMBER := fnd_global.conc_login_id;
6766: g_errbuf VARCHAR2(2000) := null;
6767: g_retcode VARCHAR2(2) := '0';
6768:
6769:
7350: l_security_group_id := null;
7351:
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:
7391:
7392: v_ASSERTION_CODE varchar2(30);
7393: m_display_flag varchar2(1) := 'N';
7394:
7395: g_user_id NUMBER := fnd_global.user_id;
7396: g_login_id NUMBER := fnd_global.conc_login_id;
7397: g_errbuf VARCHAR2(2000) := null;
7398: g_retcode VARCHAR2(2) := '0';
7399:
7392: v_ASSERTION_CODE varchar2(30);
7393: m_display_flag varchar2(1) := 'N';
7394:
7395: g_user_id NUMBER := fnd_global.user_id;
7396: g_login_id NUMBER := fnd_global.conc_login_id;
7397: g_errbuf VARCHAR2(2000) := null;
7398: g_retcode VARCHAR2(2) := '0';
7399:
7400: -- *************** Currsor to get all Control for the account being Passed ********** --