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 FND_PROFILE

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 153: from ' || fnd_profile.value('AMW_STMNT_SOURCE_VIEW')

149: --- Section of code containg declaration of dynamic cursor based on profile for importing statemnts from external applications
150: sql_for_stmnt varchar2(2000):=
151: 'SELECT
152: FINANCIAL_STATEMENT_ID
153: from ' || fnd_profile.value('AMW_STMNT_SOURCE_VIEW')
154: || ' where FINANCIAL_STATEMENT_ID in (select FINANCIAL_STATEMENT_ID from AMW_FIN_STMNT_SELECTION where run_id =' || to_char(P_RUN_ID) || ')';
155:
156: TYPE statements_b IS RECORD (
157: FINANCIAL_STATEMENT_ID NUMBER);

Line 171: from ' || fnd_profile.value('AMW_FINITEM_SOURCE_VIEW')

167: FINANCIAL_STATEMENT_ID,
168: FINANCIAL_ITEM_ID,
169: PARENT_FINANCIAL_ITEM_ID,
170: SEQUENCE_NUMBER
171: from ' || fnd_profile.value('AMW_FINITEM_SOURCE_VIEW')
172: || ' where FINANCIAL_STATEMENT_ID in (select FINANCIAL_STATEMENT_ID from AMW_FIN_STMNT_SELECTION where run_id ='|| to_char(P_RUN_ID) || ')';
173:
174:
175: TYPE statement_item_b IS RECORD (

Line 193: from ' || fnd_profile.value('AMW_FIN_ITEM_ACC_RELATIONS_VIEW');

189: 'SELECT
190: FINANCIAL_STATEMENT_ID,
191: FINANCIAL_ITEM_ID,
192: NATURAL_ACCOUNT_ID
193: from ' || fnd_profile.value('AMW_FIN_ITEM_ACC_RELATIONS_VIEW');
194:
195: TYPE account_item_map_b IS RECORD (
196: FINANCIAL_STATEMENT_ID NUMBER,
197: FINANCIAL_ITEM_ID NUMBER,

Line 212: from ' || fnd_profile.value('AMW_STMNT_SOURCE_TL_VIEW');

208: FINANCIAL_STATEMENT_ID,
209: NAME ,
210: LANGUAGE ,
211: SOURCE_LANGUAGE
212: from ' || fnd_profile.value('AMW_STMNT_SOURCE_TL_VIEW');
213:
214: TYPE statement_tl IS RECORD (
215: FINANCIAL_STATEMENT_ID NUMBER,
216: NAME VARCHAR2(80),

Line 234: from ' || fnd_profile.value('AMW_FINITEM_SOURCE_TL_VIEW');

230: FINANCIAL_ITEM_ID,
231: NAME ,
232: LANGUAGE ,
233: SOURCE_LANGUAGE
234: from ' || fnd_profile.value('AMW_FINITEM_SOURCE_TL_VIEW');
235:
236: TYPE finitem_tl IS RECORD (
237: FINANCIAL_STATEMENT_ID NUMBER,
238: FINANCIAL_ITEM_ID NUMBER,

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 1292: --WHERE flex_value_set_id= fnd_profile.value('AMW_NATRL_ACCT_VALUE_SET');

1288: FLEX_VALUE_ID, FLEX_VALUE, DESCRIPTION
1289: from
1290: fnd_flex_values_vl
1291: -- 4872820 18-Oct-2006 Start-1
1292: --WHERE flex_value_set_id= fnd_profile.value('AMW_NATRL_ACCT_VALUE_SET');
1293: WHERE FLEX_VALUE_SET_ID = m_acc_value_set_id AND ENABLED_FLAG = 'Y'
1294: -- 4872820 18-Oct-2006 End-1
1295: -- bug 5633695 modified by dliao on 12-18-2006
1296: AND (start_date_active IS NULL OR start_date_active <= SYSDATE)

Line 1323: -- and FLEX_VALUE_SET_ID = fnd_profile.value('AMW_NATRL_ACCT_VALUE_SET');

1319: from
1320: fnd_flex_values_vl where
1321: FLEX_VALUE = m_child_flex_value
1322: -- 4872820 18-Oct-2006 Start-2
1323: -- and FLEX_VALUE_SET_ID = fnd_profile.value('AMW_NATRL_ACCT_VALUE_SET');
1324: AND FLEX_VALUE_SET_ID = m_acc_value_set_id AND ENABLED_FLAG = 'Y'
1325: -- 4872820 18-Oct-2006 End-2
1326: -- bug 5633695 modified by dliao on 12-18-2006
1327: AND (start_date_active IS NULL OR start_date_active <= SYSDATE)

Line 1336: m_acc_value_set_id := to_number(fnd_profile.value('AMW_NATRL_ACCT_VALUE_SET'));

1332:
1333: --update AMW_FIN_KEY_ACCOUNTS_B set end_date = sysdate;
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:

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 1617: from ' || fnd_profile.value('AMW_ACCOUNT_SOURCE_VIEW');

1613: ATTRIBUTE14,
1614: ATTRIBUTE15,
1615: SECURITY_GROUP_ID,
1616: OBJECT_VERSION_NUMBER
1617: from ' || fnd_profile.value('AMW_ACCOUNT_SOURCE_VIEW');
1618: ------------------------------------------------------
1619: */
1620:
1621: sql_for_acc varchar2(2000):=

Line 1626: from ' || fnd_profile.value('AMW_ACCOUNT_SOURCE_VIEW') ;

1622: 'SELECT
1623: NATURAL_ACCOUNT_ID,
1624: NATURAL_ACCOUNT_VALUE,
1625: PARENT_NATURAL_ACCOUNT_ID
1626: from ' || fnd_profile.value('AMW_ACCOUNT_SOURCE_VIEW') ;
1627:
1628: TYPE accounts_b IS RECORD (
1629: NATURAL_ACCOUNT_ID NUMBER,
1630: NATURAL_ACCOUNT_VALUE VARCHAR2(150),

Line 1658: from ' || fnd_profile.value('AMW_ACCOUNT_NAMES_VIEW');

1654: NATURAL_ACCOUNT_ID,
1655: NAME ,
1656: LANGUAGE ,
1657: SOURCE_LANGUAGE
1658: from ' || fnd_profile.value('AMW_ACCOUNT_NAMES_VIEW');
1659:
1660: TYPE accounts_tl IS RECORD (
1661: NATURAL_ACCOUNT_ID NUMBER,
1662: NAME VARCHAR2(80),

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