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 DUAL

Line 36: select fnd_profile.value('AMW_FIN_IMPORT_FROM_FSG') into m_fsg_or_not from dual;

32: g_retcode := '0';
33: g_user_id := fnd_global.user_id;
34: g_login_id := fnd_global.conc_login_id;
35:
36: select fnd_profile.value('AMW_FIN_IMPORT_FROM_FSG') into m_fsg_or_not from dual;
37:
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

Line 77: select fnd_profile.value('AMW_FIN_IMPORT_FROM_FSG') into m_fsg_or_not from dual;

73: g_user_id := fnd_global.user_id;
74: g_login_id := fnd_global.conc_login_id;
75:
76:
77: select fnd_profile.value('AMW_FIN_IMPORT_FROM_FSG') into m_fsg_or_not from dual;
78: fnd_file.put_line(fnd_file.LOG,'AMW_FIN_IMPORT_FROM_FSG Profile Value' || m_fsg_or_not );
79:
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:

Line 266: select AMW_FIN_STMNT_S.nextval into M_STATEMENT_GROUP_ID from dual;

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
270: fetch Get_stmnt_from_external_apps into statements_b_record ;

Line 580: select AMW_FIN_STMNT_S.nextval into M_STATEMENT_GROUP_ID from dual;

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
584:

Line 937: select fnd_profile.value('AMW_NATRL_ACCT_VALUE_SET') into default_value_set_id from dual ;

933:
934:
935:
936: begin
937: select fnd_profile.value('AMW_NATRL_ACCT_VALUE_SET') into default_value_set_id from dual ;
938:
939: fnd_file.put_line(fnd_file.LOG, 'Profile value AMW_NATRL_ACCT_VALUE_SET =' || default_value_set_id );
940:
941: select fnd_profile.value('GL_SET_OF_BKS_ID') into M_DEFAULT_SETOFBOOKS_ID from dual ;

Line 941: select fnd_profile.value('GL_SET_OF_BKS_ID') into M_DEFAULT_SETOFBOOKS_ID from dual ;

937: select fnd_profile.value('AMW_NATRL_ACCT_VALUE_SET') into default_value_set_id from dual ;
938:
939: fnd_file.put_line(fnd_file.LOG, 'Profile value AMW_NATRL_ACCT_VALUE_SET =' || default_value_set_id );
940:
941: select fnd_profile.value('GL_SET_OF_BKS_ID') into M_DEFAULT_SETOFBOOKS_ID from dual ;
942: fnd_file.put_line(fnd_file.LOG, 'Profile value GL_SET_OF_BKS_ID (Default Set of Books)=' || M_DEFAULT_SETOFBOOKS_ID );
943:
944:
945:

Line 1338: -- select fnd_profile.value('AMW_NATRL_ACCT_VALUE_SET') into m_acc_value_set_id from dual;

1334:
1335: --fix bug 5926333
1336: m_acc_value_set_id := to_number(fnd_profile.value('AMW_NATRL_ACCT_VALUE_SET'));
1337:
1338: -- select fnd_profile.value('AMW_NATRL_ACCT_VALUE_SET') into m_acc_value_set_id from dual;
1339: select AMW_FIN_KEY_ACCOUNTS_S.nextval into M_ACCOUNT_GROUP_ID from dual;
1340:
1341: for accounts in Get_accounts_from_oraapps_gl(m_acc_value_set_id)
1342: loop

Line 1339: select AMW_FIN_KEY_ACCOUNTS_S.nextval into M_ACCOUNT_GROUP_ID from dual;

1335: --fix bug 5926333
1336: m_acc_value_set_id := to_number(fnd_profile.value('AMW_NATRL_ACCT_VALUE_SET'));
1337:
1338: -- select fnd_profile.value('AMW_NATRL_ACCT_VALUE_SET') into m_acc_value_set_id from dual;
1339: select AMW_FIN_KEY_ACCOUNTS_S.nextval into M_ACCOUNT_GROUP_ID from dual;
1340:
1341: for accounts in Get_accounts_from_oraapps_gl(m_acc_value_set_id)
1342: loop
1343:

Line 1648: DUAL;

1644:
1645: SELECT
1646: *
1647: from
1648: DUAL;
1649:
1650: */
1651:
1652: sql_for_acc_name varchar2(2000):=

Line 1676: select AMW_FIN_KEY_ACCOUNTS_S.nextval into M_ACCOUNT_GROUP_ID from dual;

1672:
1673: begin
1674:
1675: --update AMW_FIN_KEY_ACCOUNTS_B set end_date = sysdate;
1676: select AMW_FIN_KEY_ACCOUNTS_S.nextval into M_ACCOUNT_GROUP_ID from dual;
1677:
1678:
1679: open Get_acc_from_external_apps for sql_for_acc;
1680: loop

Line 2528: select fnd_profile.value('AMW_ACCOUNT_SOURCE_VIEW') into M_AMW_ACCOUNT_SOURCE_VIEW from dual;

2524: M_AMW_ACCOUNT_NAMES_VIEW varchar2(2000) := null;
2525: m_errMsg varchar2(2000);
2526:
2527: begin
2528: select fnd_profile.value('AMW_ACCOUNT_SOURCE_VIEW') into M_AMW_ACCOUNT_SOURCE_VIEW from dual;
2529: select fnd_profile.value('AMW_ACCOUNT_NAMES_VIEW' ) into M_AMW_ACCOUNT_NAMES_VIEW from dual;
2530: if (trim(M_AMW_ACCOUNT_SOURCE_VIEW) is null) then
2531:
2532: -- FND_MESSAGE.SET_NAME ('AMW', 'AMW_FINIMPORT_PROFILE_NO_VALUE');

Line 2529: select fnd_profile.value('AMW_ACCOUNT_NAMES_VIEW' ) into M_AMW_ACCOUNT_NAMES_VIEW from dual;

2525: m_errMsg varchar2(2000);
2526:
2527: begin
2528: select fnd_profile.value('AMW_ACCOUNT_SOURCE_VIEW') into M_AMW_ACCOUNT_SOURCE_VIEW from dual;
2529: select fnd_profile.value('AMW_ACCOUNT_NAMES_VIEW' ) into M_AMW_ACCOUNT_NAMES_VIEW from dual;
2530: if (trim(M_AMW_ACCOUNT_SOURCE_VIEW) is null) then
2531:
2532: -- FND_MESSAGE.SET_NAME ('AMW', 'AMW_FINIMPORT_PROFILE_NO_VALUE');
2533:

Line 2578: select fnd_profile.value('AMW_STMNT_SOURCE_VIEW') into M_AMW_STMNT_SOURCE_VIEW from dual;

2574: M_AMW_STMNT_SOURCE_TL_VIEW varchar2(2000) := null;
2575: M_AMW_FINITEM_SOURCE_TL_VIEW varchar2(2000) := null;
2576:
2577: begin
2578: select fnd_profile.value('AMW_STMNT_SOURCE_VIEW') into M_AMW_STMNT_SOURCE_VIEW from dual;
2579: select fnd_profile.value('AMW_FINITEM_SOURCE_VIEW' ) into M_AMW_FINITEM_SOURCE_VIEW from dual;
2580: select fnd_profile.value('AMW_FIN_ITEM_ACC_RELATIONS_VIEW' ) into M_AMW_FIN_ITEM_ACC_MAP_VIEW from dual;
2581: select fnd_profile.value('AMW_STMNT_SOURCE_TL_VIEW' ) into M_AMW_STMNT_SOURCE_TL_VIEW from dual;
2582: select fnd_profile.value('AMW_FINITEM_SOURCE_TL_VIEW' ) into M_AMW_FINITEM_SOURCE_TL_VIEW from dual;

Line 2579: select fnd_profile.value('AMW_FINITEM_SOURCE_VIEW' ) into M_AMW_FINITEM_SOURCE_VIEW from dual;

2575: M_AMW_FINITEM_SOURCE_TL_VIEW varchar2(2000) := null;
2576:
2577: begin
2578: select fnd_profile.value('AMW_STMNT_SOURCE_VIEW') into M_AMW_STMNT_SOURCE_VIEW from dual;
2579: select fnd_profile.value('AMW_FINITEM_SOURCE_VIEW' ) into M_AMW_FINITEM_SOURCE_VIEW from dual;
2580: select fnd_profile.value('AMW_FIN_ITEM_ACC_RELATIONS_VIEW' ) into M_AMW_FIN_ITEM_ACC_MAP_VIEW from dual;
2581: select fnd_profile.value('AMW_STMNT_SOURCE_TL_VIEW' ) into M_AMW_STMNT_SOURCE_TL_VIEW from dual;
2582: select fnd_profile.value('AMW_FINITEM_SOURCE_TL_VIEW' ) into M_AMW_FINITEM_SOURCE_TL_VIEW from dual;
2583:

Line 2580: select fnd_profile.value('AMW_FIN_ITEM_ACC_RELATIONS_VIEW' ) into M_AMW_FIN_ITEM_ACC_MAP_VIEW from dual;

2576:
2577: begin
2578: select fnd_profile.value('AMW_STMNT_SOURCE_VIEW') into M_AMW_STMNT_SOURCE_VIEW from dual;
2579: select fnd_profile.value('AMW_FINITEM_SOURCE_VIEW' ) into M_AMW_FINITEM_SOURCE_VIEW from dual;
2580: select fnd_profile.value('AMW_FIN_ITEM_ACC_RELATIONS_VIEW' ) into M_AMW_FIN_ITEM_ACC_MAP_VIEW from dual;
2581: select fnd_profile.value('AMW_STMNT_SOURCE_TL_VIEW' ) into M_AMW_STMNT_SOURCE_TL_VIEW from dual;
2582: select fnd_profile.value('AMW_FINITEM_SOURCE_TL_VIEW' ) into M_AMW_FINITEM_SOURCE_TL_VIEW from dual;
2583:
2584:

Line 2581: select fnd_profile.value('AMW_STMNT_SOURCE_TL_VIEW' ) into M_AMW_STMNT_SOURCE_TL_VIEW from dual;

2577: begin
2578: select fnd_profile.value('AMW_STMNT_SOURCE_VIEW') into M_AMW_STMNT_SOURCE_VIEW from dual;
2579: select fnd_profile.value('AMW_FINITEM_SOURCE_VIEW' ) into M_AMW_FINITEM_SOURCE_VIEW from dual;
2580: select fnd_profile.value('AMW_FIN_ITEM_ACC_RELATIONS_VIEW' ) into M_AMW_FIN_ITEM_ACC_MAP_VIEW from dual;
2581: select fnd_profile.value('AMW_STMNT_SOURCE_TL_VIEW' ) into M_AMW_STMNT_SOURCE_TL_VIEW from dual;
2582: select fnd_profile.value('AMW_FINITEM_SOURCE_TL_VIEW' ) into M_AMW_FINITEM_SOURCE_TL_VIEW from dual;
2583:
2584:
2585: if (trim(M_AMW_STMNT_SOURCE_VIEW) is null) then

Line 2582: select fnd_profile.value('AMW_FINITEM_SOURCE_TL_VIEW' ) into M_AMW_FINITEM_SOURCE_TL_VIEW from dual;

2578: select fnd_profile.value('AMW_STMNT_SOURCE_VIEW') into M_AMW_STMNT_SOURCE_VIEW from dual;
2579: select fnd_profile.value('AMW_FINITEM_SOURCE_VIEW' ) into M_AMW_FINITEM_SOURCE_VIEW from dual;
2580: select fnd_profile.value('AMW_FIN_ITEM_ACC_RELATIONS_VIEW' ) into M_AMW_FIN_ITEM_ACC_MAP_VIEW from dual;
2581: select fnd_profile.value('AMW_STMNT_SOURCE_TL_VIEW' ) into M_AMW_STMNT_SOURCE_TL_VIEW from dual;
2582: select fnd_profile.value('AMW_FINITEM_SOURCE_TL_VIEW' ) into M_AMW_FINITEM_SOURCE_TL_VIEW from dual;
2583:
2584:
2585: if (trim(M_AMW_STMNT_SOURCE_VIEW) is null) then
2586:

Line 2696: select fnd_profile.value('AMW_NATRL_ACCT_VALUE_SET') into acc_value_set_id from dual ;

2692: declare
2693:
2694: acc_value_set_id number := NULL;
2695: begin
2696: select fnd_profile.value('AMW_NATRL_ACCT_VALUE_SET') into acc_value_set_id from dual ;
2697:
2698: if acc_value_set_id IS NULL then
2699: FND_MESSAGE.SET_NAME ('AMW', 'AMW_ACCT_VALUE_SET_NOT_DEFINED');
2700: g_errbuf := FND_MESSAGE.GET_STRING('AMW', 'AMW_ACCT_VALUE_SET_NOT_DEFINED');