eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMW_IMPORT_STMNTS_ACCS_PKG dependencies on AMW_IMPORT_STMNTS_ACCS_PKG

Line 1: PACKAGE BODY AMW_IMPORT_STMNTS_ACCS_PKG AS

1: PACKAGE BODY AMW_IMPORT_STMNTS_ACCS_PKG AS
2: /* $Header: amwacimb.pls 120.0.12000000.3 2007/03/29 23:15:59 rjohnson ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- AMW_IMPORT_STMNTS_ACCS_PKG

2: /* $Header: amwacimb.pls 120.0.12000000.3 2007/03/29 23:15:59 rjohnson ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- AMW_IMPORT_STMNTS_ACCS_PKG
7: -- Purpose
8: --
9: -- History
10: --

Line 15: --G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMW_IMPORT_STMNTS_ACCS_PKG';

11: -- NOTE
12: --
13: -- End of Comments
14: -- ===============================================================
15: --G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMW_IMPORT_STMNTS_ACCS_PKG';
16: --G_FILE_NAME CONSTANT VARCHAR2(12) := amwacimb.pls';
17: g_user_id NUMBER ;
18: g_login_id NUMBER ;
19: g_errbuf VARCHAR2(2000);

Line 42: AMW_IMPORT_STMNTS_ACCS_PKG.get_acc_from_oracle_apps;

38: fnd_file.put_line(fnd_file.LOG,'AMW_FIN_IMPORT_FROM_FSG Profile Value' || m_fsg_or_not );
39:
40: if (m_fsg_or_not is null or upper(trim(m_fsg_or_not)) = 'Y' or upper(trim(m_fsg_or_not)) = 'YES') then
41: IF check_account_value_set THEN
42: AMW_IMPORT_STMNTS_ACCS_PKG.get_acc_from_oracle_apps;
43: END IF;
44: ELSE
45: if AMW_IMPORT_STMNTS_ACCS_PKG.check_acc_profiles_has_value then
46: AMW_IMPORT_STMNTS_ACCS_PKG.get_acc_from_external_apps;

Line 45: if AMW_IMPORT_STMNTS_ACCS_PKG.check_acc_profiles_has_value then

41: IF check_account_value_set THEN
42: AMW_IMPORT_STMNTS_ACCS_PKG.get_acc_from_oracle_apps;
43: END IF;
44: ELSE
45: if AMW_IMPORT_STMNTS_ACCS_PKG.check_acc_profiles_has_value then
46: AMW_IMPORT_STMNTS_ACCS_PKG.get_acc_from_external_apps;
47:
48: end if;
49: END IF;

Line 46: AMW_IMPORT_STMNTS_ACCS_PKG.get_acc_from_external_apps;

42: AMW_IMPORT_STMNTS_ACCS_PKG.get_acc_from_oracle_apps;
43: END IF;
44: ELSE
45: if AMW_IMPORT_STMNTS_ACCS_PKG.check_acc_profiles_has_value then
46: AMW_IMPORT_STMNTS_ACCS_PKG.get_acc_from_external_apps;
47:
48: end if;
49: END IF;
50: end;

Line 84: AMW_IMPORT_STMNTS_ACCS_PKG.get_stmnts_from_oracle_apps(P_RUN_ID => m_run_id) ;

80: if (m_fsg_or_not is null or upper(trim(m_fsg_or_not)) = 'Y' or upper(trim(m_fsg_or_not)) = 'YES') then
81:
82: if check_key_accounts_exists then
83: IF check_account_value_set THEN
84: AMW_IMPORT_STMNTS_ACCS_PKG.get_stmnts_from_oracle_apps(P_RUN_ID => m_run_id) ;
85: end if;
86: end if;
87:
88: ELSE

Line 91: AMW_IMPORT_STMNTS_ACCS_PKG.get_stmnts_from_external_apps(P_RUN_ID => m_run_id) ;

87:
88: ELSE
89: if check_key_accounts_exists then
90: if check_stmnt_profiles_has_value then
91: AMW_IMPORT_STMNTS_ACCS_PKG.get_stmnts_from_external_apps(P_RUN_ID => m_run_id) ;
92: end if;
93:
94: end if;
95: END IF;

Line 265: -- AMW_IMPORT_STMNTS_ACCS_PKG.end_date_stmnts_before_import(P_RUNID => m_run_id) ;

261: (select max(keyacc2.ACCOUNT_GROUP_ID) from AMW_FIN_KEY_ACCOUNTS_B keyacc2 where keyacc2.End_Date is null) ;
262:
263:
264: begin
265: -- AMW_IMPORT_STMNTS_ACCS_PKG.end_date_stmnts_before_import(P_RUNID => m_run_id) ;
266: select AMW_FIN_STMNT_S.nextval into M_STATEMENT_GROUP_ID from dual;
267:
268: open Get_stmnt_from_external_apps for sql_for_stmnt ;
269: loop

Line 279: AMW_IMPORT_STMNTS_ACCS_PKG.INSERT_STMNT_ROW (

275:
276: fnd_file.put_line(fnd_file.LOG, 'Processing STATEMENT_GROUP_ID =' || M_STATEMENT_GROUP_ID);
277: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_STATEMENT_ID =' || M_FINANCIAL_STATEMENT_ID );
278:
279: AMW_IMPORT_STMNTS_ACCS_PKG.INSERT_STMNT_ROW (
280: X_STATEMENT_GROUP_ID => M_STATEMENT_GROUP_ID,
281: X_FINANCIAL_STATEMENT_ID => M_FINANCIAL_STATEMENT_ID ,
282: X_END_DATE => NULL,
283: X_LAST_UPDATE_DATE => SYSDATE,

Line 324: AMW_IMPORT_STMNTS_ACCS_PKG.INSERT_STMNT_ROW_TL(

320: fnd_file.put_line(fnd_file.LOG, 'Processing TL Definition for FINANCIAL_STATEMENT_NAME =' || M_NAME );
321: fnd_file.put_line(fnd_file.LOG, 'Processing TL Definition for LANGUAGE =' || M_LANGUAGE );
322:
323:
324: AMW_IMPORT_STMNTS_ACCS_PKG.INSERT_STMNT_ROW_TL(
325: X_STATEMENT_GROUP_ID => M_STATEMENT_GROUP_ID,
326: X_FINANCIAL_STATEMENT_ID => M_FINANCIAL_STATEMENT_ID ,
327: X_NAME => M_NAME,
328: X_LANGUAGE => M_LANGUAGE,

Line 358: AMW_IMPORT_STMNTS_ACCS_PKG.INSERT_FINITEM_ROW(

354: fnd_file.put_line(fnd_file.LOG, 'Processing PARENT_FINANCIAL_ITEM_ID =' || M_PARENT_FINANCIAL_ITEM_ID );
355:
356:
357:
358: AMW_IMPORT_STMNTS_ACCS_PKG.INSERT_FINITEM_ROW(
359: X_STATEMENT_GROUP_ID => M_STATEMENT_GROUP_ID,
360: X_FINANCIAL_STATEMENT_ID => M_FINANCIAL_STATEMENT_ID ,
361: X_FINANCIAL_ITEM_ID => M_FINANCIAL_ITEM_ID ,
362: X_PARENT_FINANCIAL_ITEM_ID => M_PARENT_FINANCIAL_ITEM_ID ,

Line 408: AMW_IMPORT_STMNTS_ACCS_PKG.INSERT_FINITEM_ROW_TL(

404: fnd_file.put_line(fnd_file.LOG, 'Processing TL Definition for FINANCIAL_ITEM_NAME =' || M_NAME );
405: fnd_file.put_line(fnd_file.LOG, 'Processing TL Definition for LANGUAGE =' || M_LANGUAGE );
406:
407:
408: AMW_IMPORT_STMNTS_ACCS_PKG.INSERT_FINITEM_ROW_TL(
409: X_STATEMENT_GROUP_ID => M_STATEMENT_GROUP_ID,
410: X_FINANCIAL_STATEMENT_ID => M_FINANCIAL_STATEMENT_ID ,
411: X_FINANCIAL_ITEM_ID => M_FINANCIAL_ITEM_ID ,
412: X_NAME => M_NAME,

Line 451: AMW_IMPORT_STMNTS_ACCS_PKG.INSERT_FINITEM_ACC_MAP(

447: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR NATURAL_ACCOUNT_ID=' || M_NATURAL_ACCOUNT_ID);
448:
449:
450: if (M_ACCOUNT_GROUP_ID is not null) then
451: AMW_IMPORT_STMNTS_ACCS_PKG.INSERT_FINITEM_ACC_MAP(
452: X_STATEMENT_GROUP_ID => M_STATEMENT_GROUP_ID,
453: X_ACCOUNT_GROUP_ID => M_ACCOUNT_GROUP_ID ,
454: X_FINANCIAL_STATEMENT_ID => M_FINANCIAL_STATEMENT_ID ,
455: X_FINANCIAL_ITEM_ID => M_FINANCIAL_ITEM_ID ,

Line 484: AMW_IMPORT_STMNTS_ACCS_PKG.end_date_stmnts_after_import(P_RUNID => m_run_id,

480: end if;
481:
482:
483: end loop;
484: AMW_IMPORT_STMNTS_ACCS_PKG.end_date_stmnts_after_import(P_RUNID => m_run_id,
485: P_STATEMENT_GROUP_ID => M_STATEMENT_GROUP_ID) ;
486:
487: -- Sanket.
488: amw_import_stmnts_accs_pkg.flatten_items ( x_group_id => m_statement_group_id );

Line 488: amw_import_stmnts_accs_pkg.flatten_items ( x_group_id => m_statement_group_id );

484: AMW_IMPORT_STMNTS_ACCS_PKG.end_date_stmnts_after_import(P_RUNID => m_run_id,
485: P_STATEMENT_GROUP_ID => M_STATEMENT_GROUP_ID) ;
486:
487: -- Sanket.
488: amw_import_stmnts_accs_pkg.flatten_items ( x_group_id => m_statement_group_id );
489:
490: commit;
491: end;
492: EXCEPTION WHEN OTHERS THEN

Line 579: -- AMW_IMPORT_STMNTS_ACCS_PKG.end_date_stmnts_before_import(P_RUNID => m_run_id) ;

575: FND_LANGUAGES
576: where INSTALLED_FLAG in ('I', 'B');
577:
578: begin
579: -- AMW_IMPORT_STMNTS_ACCS_PKG.end_date_stmnts_before_import(P_RUNID => m_run_id) ;
580: select AMW_FIN_STMNT_S.nextval into M_STATEMENT_GROUP_ID from dual;
581:
582: for statements in Get_statements_from_ora_gl
583: loop

Line 592: AMW_IMPORT_STMNTS_ACCS_PKG.INSERT_STMNT_ROW (

588: fnd_file.put_line(fnd_file.LOG, 'Processing STATEMENT_GROUP_ID = ' || M_STATEMENT_GROUP_ID);
589: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_STATEMENT_ID = ' || M_FINANCIAL_STATEMENT_ID);
590:
591:
592: AMW_IMPORT_STMNTS_ACCS_PKG.INSERT_STMNT_ROW (
593: X_STATEMENT_GROUP_ID => M_STATEMENT_GROUP_ID,
594: X_FINANCIAL_STATEMENT_ID => M_FINANCIAL_STATEMENT_ID ,
595: X_END_DATE => NULL,
596: X_LAST_UPDATE_DATE => SYSDATE,

Line 633: AMW_IMPORT_STMNTS_ACCS_PKG.INSERT_STMNT_ROW_TL(

629: exit when Get_lang%notfound;
630: M_LANGUAGE := lang.LANGUAGE_CODE;
631: fnd_file.put_line(fnd_file.LOG, 'Processing TL Definition for LANGUAGE = ' || M_LANGUAGE);
632:
633: AMW_IMPORT_STMNTS_ACCS_PKG.INSERT_STMNT_ROW_TL(
634: X_STATEMENT_GROUP_ID => M_STATEMENT_GROUP_ID,
635: X_FINANCIAL_STATEMENT_ID => M_FINANCIAL_STATEMENT_ID,
636: X_NAME => M_NAME,
637: X_LANGUAGE => M_LANGUAGE,

Line 666: AMW_IMPORT_STMNTS_ACCS_PKG.INSERT_FINITEM_ROW(

662: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_STATEMENT_ID = ' || M_FINANCIAL_STATEMENT_ID);
663: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_ITEM_ID = ' || M_FINANCIAL_ITEM_ID);
664: fnd_file.put_line(fnd_file.LOG, 'Processing PARENT_FINANCIAL_ITEM_ID = ' || M_PARENT_FINANCIAL_ITEM_ID);
665:
666: AMW_IMPORT_STMNTS_ACCS_PKG.INSERT_FINITEM_ROW(
667: X_STATEMENT_GROUP_ID => M_STATEMENT_GROUP_ID,
668: X_FINANCIAL_STATEMENT_ID => M_FINANCIAL_STATEMENT_ID ,
669: X_FINANCIAL_ITEM_ID => M_FINANCIAL_ITEM_ID ,
670: X_PARENT_FINANCIAL_ITEM_ID => M_PARENT_FINANCIAL_ITEM_ID,

Line 710: AMW_IMPORT_STMNTS_ACCS_PKG.INSERT_FINITEM_ROW_TL(

706: exit when Get_lang%notfound;
707: M_LANGUAGE := lang.LANGUAGE_CODE;
708: fnd_file.put_line(fnd_file.LOG, 'Processing TL Definition for LANGUAGE = ' || M_LANGUAGE);
709:
710: AMW_IMPORT_STMNTS_ACCS_PKG.INSERT_FINITEM_ROW_TL(
711: X_STATEMENT_GROUP_ID => M_STATEMENT_GROUP_ID,
712: X_FINANCIAL_STATEMENT_ID => M_FINANCIAL_STATEMENT_ID,
713: X_FINANCIAL_ITEM_ID => M_FINANCIAL_ITEM_ID,
714: X_NAME => M_NAME,

Line 729: AMW_IMPORT_STMNTS_ACCS_PKG.get_stmnts_accs_oracle_apps(P_RUN_ID =>m_run_id ,

725:
726: end loop;
727: end loop;
728:
729: AMW_IMPORT_STMNTS_ACCS_PKG.get_stmnts_accs_oracle_apps(P_RUN_ID =>m_run_id ,
730: P_STATEMENT_GROUP_ID => M_STATEMENT_GROUP_ID);
731:
732: AMW_IMPORT_STMNTS_ACCS_PKG.end_date_stmnts_after_import(P_RUNID => m_run_id,
733: P_STATEMENT_GROUP_ID => M_STATEMENT_GROUP_ID) ;

Line 732: AMW_IMPORT_STMNTS_ACCS_PKG.end_date_stmnts_after_import(P_RUNID => m_run_id,

728:
729: AMW_IMPORT_STMNTS_ACCS_PKG.get_stmnts_accs_oracle_apps(P_RUN_ID =>m_run_id ,
730: P_STATEMENT_GROUP_ID => M_STATEMENT_GROUP_ID);
731:
732: AMW_IMPORT_STMNTS_ACCS_PKG.end_date_stmnts_after_import(P_RUNID => m_run_id,
733: P_STATEMENT_GROUP_ID => M_STATEMENT_GROUP_ID) ;
734:
735: -- Sanket.
736: amw_import_stmnts_accs_pkg.flatten_items ( x_group_id => m_statement_group_id );

Line 736: amw_import_stmnts_accs_pkg.flatten_items ( x_group_id => m_statement_group_id );

732: AMW_IMPORT_STMNTS_ACCS_PKG.end_date_stmnts_after_import(P_RUNID => m_run_id,
733: P_STATEMENT_GROUP_ID => M_STATEMENT_GROUP_ID) ;
734:
735: -- Sanket.
736: amw_import_stmnts_accs_pkg.flatten_items ( x_group_id => m_statement_group_id );
737:
738: commit;
739: end;
740:

Line 1123: AMW_IMPORT_STMNTS_ACCS_PKG.INSERT_FINITEM_ACC_MAP(

1119: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR ACCOUNT_GROUP_ID=' || M_ACCOUNT_GROUP_ID);
1120: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR NATURAL_ACCOUNT_ID=' || M_NATURAL_ACCOUNT_ID);
1121:
1122:
1123: AMW_IMPORT_STMNTS_ACCS_PKG.INSERT_FINITEM_ACC_MAP(
1124: X_STATEMENT_GROUP_ID => M_STATEMENT_GROUP_ID,
1125: X_ACCOUNT_GROUP_ID => M_ACCOUNT_GROUP_ID ,
1126: X_FINANCIAL_STATEMENT_ID => M_FINANCIAL_STATEMENT_ID ,
1127: X_FINANCIAL_ITEM_ID => M_FINANCIAL_ITEM_ID ,

Line 1356: AMW_IMPORT_STMNTS_ACCS_PKG.INSERT_ROW(

1352: fnd_file.put_line(fnd_file.LOG, 'Processing NATURAL_ACCOUNT_ID=' || M_NATURAL_ACCOUNT_ID);
1353:
1354:
1355:
1356: AMW_IMPORT_STMNTS_ACCS_PKG.INSERT_ROW(
1357: X_ACCOUNT_GROUP_ID => M_ACCOUNT_GROUP_ID,
1358: X_NATURAL_ACCOUNT_ID => M_NATURAL_ACCOUNT_ID,
1359: X_NATURAL_ACCOUNT_VALUE => M_NATURAL_ACCOUNT_VALUE,
1360: X_END_DATE => NULL,

Line 1384: AMW_IMPORT_STMNTS_ACCS_PKG.get_acc_name_from_oracle_apps( p_group_id => M_ACCOUNT_GROUP_ID

1380: X_ATTRIBUTE14 => NULL,
1381: X_ATTRIBUTE15 => NULL,
1382: X_PARENT_NATURAL_ACCOUNT_ID => NULL );
1383:
1384: AMW_IMPORT_STMNTS_ACCS_PKG.get_acc_name_from_oracle_apps( p_group_id => M_ACCOUNT_GROUP_ID
1385: ,p_flex_value_id => M_NATURAL_ACCOUNT_ID);
1386:
1387: M_PARENT_NATURAL_ACCOUNT_ID := M_NATURAL_ACCOUNT_ID;
1388: for sub_accounts in Get_sub_acc_from_oraapps_gl(M_NATURAL_ACCOUNT_VALUE, m_acc_value_set_id)

Line 1409: AMW_IMPORT_STMNTS_ACCS_PKG.INSERT_ROW(

1405: fnd_file.put_line(fnd_file.LOG, 'Processing PARENT_NATURAL_ACCOUNT_ID=' || M_PARENT_NATURAL_ACCOUNT_ID);
1406:
1407:
1408:
1409: AMW_IMPORT_STMNTS_ACCS_PKG.INSERT_ROW(
1410: X_ACCOUNT_GROUP_ID => M_ACCOUNT_GROUP_ID,
1411: X_NATURAL_ACCOUNT_ID => C_NATURAL_ACCOUNT_ID,
1412: X_NATURAL_ACCOUNT_VALUE => C_NATURAL_ACCOUNT_VALUE ,
1413: X_END_DATE => NULL,

Line 1437: -- AMW_IMPORT_STMNTS_ACCS_PKG.get_acc_name_from_oracle_apps( p_group_id => M_ACCOUNT_GROUP_ID ,p_flex_value_id => C_NATURAL_ACCOUNT_ID);

1433: X_ATTRIBUTE14 => NULL,
1434: X_ATTRIBUTE15 => NULL,
1435: X_PARENT_NATURAL_ACCOUNT_ID => M_PARENT_NATURAL_ACCOUNT_ID);
1436:
1437: -- AMW_IMPORT_STMNTS_ACCS_PKG.get_acc_name_from_oracle_apps( p_group_id => M_ACCOUNT_GROUP_ID ,p_flex_value_id => C_NATURAL_ACCOUNT_ID);
1438:
1439: end loop;
1440:
1441: end loop;

Line 1446: amw_import_stmnts_accs_pkg.flatten_accounts ( x_group_id => m_account_group_id );

1442: update AMW_FIN_KEY_ACCOUNTS_B set end_date = sysdate
1443: where ACCOUNT_GROUP_ID<>M_ACCOUNT_GROUP_ID;
1444:
1445: -- Sanket.
1446: amw_import_stmnts_accs_pkg.flatten_accounts ( x_group_id => m_account_group_id );
1447:
1448: commit;
1449: END;
1450: EXCEPTION WHEN OTHERS THEN

Line 1514: AMW_IMPORT_STMNTS_ACCS_PKG.INSERT_ROW_TL(

1510: fnd_file.put_line(fnd_file.LOG, 'Processing LANGUAGE=' || M_LANGUAGE);
1511: fnd_file.put_line(fnd_file.LOG, 'Processing NAME=' || M_NAME);
1512:
1513:
1514: AMW_IMPORT_STMNTS_ACCS_PKG.INSERT_ROW_TL(
1515: X_ACCOUNT_GROUP_ID => P_ACCOUNT_GROUP_ID,
1516: X_NATURAL_ACCOUNT_ID => P_NATURAL_ACCOUNT_ID,
1517: X_NAME => M_NAME,
1518: X_LANGUAGE => M_LANGUAGE,

Line 1694: AMW_IMPORT_STMNTS_ACCS_PKG.INSERT_ROW(

1690: fnd_file.put_line(fnd_file.LOG, 'Processing NATURAL_ACCOUNT_ID=' || M_NATURAL_ACCOUNT_ID);
1691: fnd_file.put_line(fnd_file.LOG, 'Processing PARENT_NATURAL_ACCOUNT_ID=' || M_PARENT_NATURAL_ACCOUNT_ID);
1692:
1693:
1694: AMW_IMPORT_STMNTS_ACCS_PKG.INSERT_ROW(
1695: X_ACCOUNT_GROUP_ID => M_ACCOUNT_GROUP_ID,
1696: X_NATURAL_ACCOUNT_ID => M_NATURAL_ACCOUNT_ID,
1697: X_NATURAL_ACCOUNT_VALUE => M_NATURAL_ACCOUNT_VALUE,
1698: X_END_DATE => NULL,

Line 1742: AMW_IMPORT_STMNTS_ACCS_PKG.INSERT_ROW_TL(

1738: fnd_file.put_line(fnd_file.LOG, 'Processing NAME=' || M_NAME);
1739:
1740:
1741:
1742: AMW_IMPORT_STMNTS_ACCS_PKG.INSERT_ROW_TL(
1743: X_ACCOUNT_GROUP_ID => M_ACCOUNT_GROUP_ID,
1744: X_NATURAL_ACCOUNT_ID => M_NATURAL_ACCOUNT_ID ,
1745: X_NAME => M_NAME,
1746: X_LANGUAGE => M_LANGUAGE,

Line 1764: amw_import_stmnts_accs_pkg.flatten_accounts ( x_group_id => m_account_group_id );

1760: where ACCOUNT_GROUP_ID<>M_ACCOUNT_GROUP_ID;
1761:
1762:
1763: -- Sanket.
1764: amw_import_stmnts_accs_pkg.flatten_accounts ( x_group_id => m_account_group_id );
1765:
1766: commit;
1767: END;
1768:

Line 2845: END AMW_IMPORT_STMNTS_ACCS_PKG;

2841: end flatten_items;
2842: -------------------------------------------------------------------------------------------------------------------
2843:
2844:
2845: END AMW_IMPORT_STMNTS_ACCS_PKG;