DBA Data[Home] [Help]

APPS.AMW_FIN_COSO_VIEWS_PVT dependencies on FND_GLOBAL

Line 61: g_user_id NUMBER := fnd_global.user_id;

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;

Line 62: g_login_id NUMBER := fnd_global.conc_login_id;

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:

Line 777: g_user_id NUMBER := fnd_global.user_id;

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:

Line 778: g_login_id NUMBER := fnd_global.conc_login_id;

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 ********** --

Line 1496: g_user_id NUMBER := fnd_global.user_id;

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:

Line 1497: g_login_id NUMBER := fnd_global.conc_login_id;

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 ********** --

Line 3082: g_user_id NUMBER := fnd_global.user_id;

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;

Line 3083: g_login_id NUMBER := fnd_global.conc_login_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;
3087: m_ctrl_attribute_type VARCHAR2(30) :='CTRL_COMPONENT';

Line 3397: g_user_id NUMBER := fnd_global.user_id;

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;

Line 3398: g_login_id NUMBER := fnd_global.conc_login_id;

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';

Line 3759: g_user_id NUMBER := fnd_global.user_id;

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;

Line 3760: g_login_id NUMBER := fnd_global.conc_login_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;
3764: m_ctrl_attribute_type VARCHAR2(30) :='CTRL_OBJECTIVES';

Line 4127: g_user_id NUMBER := fnd_global.user_id;

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;

Line 4128: g_login_id NUMBER := fnd_global.conc_login_id;

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';

Line 4531: g_user_id NUMBER := fnd_global.user_id;

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;

Line 4532: g_login_id NUMBER := fnd_global.conc_login_id;

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';

Line 5031: g_user_id NUMBER := fnd_global.user_id;

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';

Line 5032: g_login_id NUMBER := fnd_global.conc_login_id;

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';

Line 6330: g_user_id NUMBER := fnd_global.user_id;

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:

Line 6331: g_login_id NUMBER := fnd_global.conc_login_id;

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 ********** --

Line 6764: g_user_id NUMBER := fnd_global.user_id;

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:

Line 6765: g_login_id NUMBER := fnd_global.conc_login_id;

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:

Line 7354: -- fnd_global.apps_initialize (l_user_id, l_resp_id, l_resp_appl_id, l_security_group_id);

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:

Line 7395: g_user_id NUMBER := fnd_global.user_id;

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:

Line 7396: g_login_id NUMBER := fnd_global.conc_login_id;

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 ********** --