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.ASO_UTILITY_PVT dependencies on FND_PROFILE

Line 485: to_number(NVL(FND_PROFILE.Value('LANGUAGE'), '0')));

481: l_message_num := NULL;
482: IF l_id is not NULL
483: THEN
484: OPEN Get_Message_Num (l_message_name, l_id,
485: to_number(NVL(FND_PROFILE.Value('LANGUAGE'), '0')));
486: FETCH Get_Message_Num into l_message_num;
487: CLOSE Get_Message_Num;
488: END IF;
489:

Line 4276: select decode(nvl(fnd_profile.value('ASO_FILTER_SERVICE_RF_END_CUST'),'N'),'Y',nvl(END_CUSTOMER_CUST_ACCOUNT_ID,cust_account_id),cust_account_id) cust_account_id

4272: AND account_id = p_cust_account_id;
4273:
4274: /*** Start: BugNo 8647883: R12.1.2 Service reference SUN ER ***/
4275: CURSOR c_get_cust_acct_id IS
4276: select decode(nvl(fnd_profile.value('ASO_FILTER_SERVICE_RF_END_CUST'),'N'),'Y',nvl(END_CUSTOMER_CUST_ACCOUNT_ID,cust_account_id),cust_account_id) cust_account_id
4277: from ASO_QUOTE_HEADERS_ALL
4278: WHERE quote_header_id = p_qte_header_id;
4279:
4280: CURSOR c_get_cust_acct_id_ln(p_qte_line_id number) IS

Line 4281: select decode(nvl(fnd_profile.value('ASO_FILTER_SERVICE_RF_END_CUST'),'N'),'Y',END_CUSTOMER_CUST_ACCOUNT_ID)

4277: from ASO_QUOTE_HEADERS_ALL
4278: WHERE quote_header_id = p_qte_header_id;
4279:
4280: CURSOR c_get_cust_acct_id_ln(p_qte_line_id number) IS
4281: select decode(nvl(fnd_profile.value('ASO_FILTER_SERVICE_RF_END_CUST'),'N'),'Y',END_CUSTOMER_CUST_ACCOUNT_ID)
4282: from ASO_QUOTE_LINES_ALL
4283: WHERE quote_line_id = p_qte_line_id;
4284:
4285: cursor c_get_price_list(p_qte_hdr_id number) is

Line 4814: select decode(nvl(fnd_profile.value('ASO_FILTER_SERVICE_RF_END_CUST'),'N'),'Y',nvl(END_CUSTOMER_CUST_ACCOUNT_ID,cust_account_id),cust_account_id) cust_account_id

4810: /* Cursors used for the customer_products*/
4811:
4812: /*** Start: BugNo 8647883: R12.1.2 Service reference SUN ER ***/
4813: CURSOR c_get_cust_acct_id IS
4814: select decode(nvl(fnd_profile.value('ASO_FILTER_SERVICE_RF_END_CUST'),'N'),'Y',nvl(END_CUSTOMER_CUST_ACCOUNT_ID,cust_account_id),cust_account_id) cust_account_id
4815: from ASO_QUOTE_HEADERS_ALL
4816: WHERE quote_header_id = p_qte_header_id;
4817:
4818: CURSOR c_get_cust_acct_id_ln(p_qte_line_id number) IS

Line 4819: select decode(nvl(fnd_profile.value('ASO_FILTER_SERVICE_RF_END_CUST'),'N'),'Y',END_CUSTOMER_CUST_ACCOUNT_ID)

4815: from ASO_QUOTE_HEADERS_ALL
4816: WHERE quote_header_id = p_qte_header_id;
4817:
4818: CURSOR c_get_cust_acct_id_ln(p_qte_line_id number) IS
4819: select decode(nvl(fnd_profile.value('ASO_FILTER_SERVICE_RF_END_CUST'),'N'),'Y',END_CUSTOMER_CUST_ACCOUNT_ID)
4820: from ASO_QUOTE_LINES_ALL
4821: WHERE quote_line_id = p_qte_line_id;
4822:
4823: cursor c_get_price_list(p_qte_hdr_id number) is

Line 5935: from fnd_profile_options

5931: IS
5932:
5933: cursor c_end_date is
5934: select end_date_active
5935: from fnd_profile_options
5936: where profile_option_name = p_profile_name
5937: and application_id = p_application_id
5938: and trunc(start_date_active) <= trunc(sysdate)
5939: and trunc(nvl(end_date_active, sysdate)) >= trunc(sysdate);

Line 6607: fnd_profile.get('XLA_MO_SECURITY_PROFILE_LEVEL',l_security_profile_id);

6603: aso_debug_pub.add( '***** Printing the profile values *****',1, 'Y' );
6604: aso_debug_pub.add( '******************************************',1, 'Y' );
6605: aso_debug_pub.add( ' ',1, 'Y' );
6606:
6607: fnd_profile.get('XLA_MO_SECURITY_PROFILE_LEVEL',l_security_profile_id);
6608: fnd_profile.get('DEFAULT_ORG_ID',l_def_org_id);
6609: fnd_profile.get('ORG_ID',l_org_id);
6610: aso_debug_pub.add(rpad('SECURITY PROFILE ID',50,'------')||'------>'||l_security_profile_id , 1, 'Y');
6611: aso_debug_pub.add(rpad('DEFAULT ORG ID',50,'------')||'------>'||l_def_org_id , 1, 'Y');

Line 6608: fnd_profile.get('DEFAULT_ORG_ID',l_def_org_id);

6604: aso_debug_pub.add( '******************************************',1, 'Y' );
6605: aso_debug_pub.add( ' ',1, 'Y' );
6606:
6607: fnd_profile.get('XLA_MO_SECURITY_PROFILE_LEVEL',l_security_profile_id);
6608: fnd_profile.get('DEFAULT_ORG_ID',l_def_org_id);
6609: fnd_profile.get('ORG_ID',l_org_id);
6610: aso_debug_pub.add(rpad('SECURITY PROFILE ID',50,'------')||'------>'||l_security_profile_id , 1, 'Y');
6611: aso_debug_pub.add(rpad('DEFAULT ORG ID',50,'------')||'------>'||l_def_org_id , 1, 'Y');
6612: aso_debug_pub.add(rpad('ORG ID',50,'------')||'------>'||l_org_id , 1, 'Y');

Line 6609: fnd_profile.get('ORG_ID',l_org_id);

6605: aso_debug_pub.add( ' ',1, 'Y' );
6606:
6607: fnd_profile.get('XLA_MO_SECURITY_PROFILE_LEVEL',l_security_profile_id);
6608: fnd_profile.get('DEFAULT_ORG_ID',l_def_org_id);
6609: fnd_profile.get('ORG_ID',l_org_id);
6610: aso_debug_pub.add(rpad('SECURITY PROFILE ID',50,'------')||'------>'||l_security_profile_id , 1, 'Y');
6611: aso_debug_pub.add(rpad('DEFAULT ORG ID',50,'------')||'------>'||l_def_org_id , 1, 'Y');
6612: aso_debug_pub.add(rpad('ORG ID',50,'------')||'------>'||l_org_id , 1, 'Y');
6613: