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

Line 458: FND_PROFILE.GET('CSC_DASHBOARD_VIEW_FOR_CONTACT',g_dashboard_for_contact);

454: END IF;
455: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS2_T' ;
456:
457: IF g_dashboard_for_contact IS NULL THEN
458: FND_PROFILE.GET('CSC_DASHBOARD_VIEW_FOR_CONTACT',g_dashboard_for_contact);
459: END IF;
460:
461: /* R12 Employee HelpDesk Modifications */
462:

Line 991: FND_PROFILE.GET('CSC_DASHBOARD_VIEW_FOR_CONTACT',g_dashboard_for_contact);

987: l_ua_total :=0;
988: END IF;
989:
990: IF g_dashboard_for_contact IS NULL THEN
991: FND_PROFILE.GET('CSC_DASHBOARD_VIEW_FOR_CONTACT',g_dashboard_for_contact);
992: END IF;
993:
994: IF g_dashboard_for_contact = 'Y' THEN
995: l_ip_total := 0;

Line 2296: FND_PROFILE.GET('CSC_DASHBOARD_VIEW_FOR_CONTACT',g_dashboard_for_contact);

2292: END IF;
2293:
2294: --New changes
2295: IF g_dashboard_for_contact IS NULL THEN
2296: FND_PROFILE.GET('CSC_DASHBOARD_VIEW_FOR_CONTACT',g_dashboard_for_contact);
2297: END IF;
2298: IF g_dashboard_for_contact = 'Y' THEN
2299: l_ip_total :=0;
2300: l_up_total :=0;

Line 2639: FND_PROFILE.GET('CSC_DASHBOARD_VIEW_FOR_CONTACT', g_dashboard_for_contact);

2635: END IF;
2636: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS2_T' ;
2637:
2638: IF g_dashboard_for_contact IS NULL THEN
2639: FND_PROFILE.GET('CSC_DASHBOARD_VIEW_FOR_CONTACT', g_dashboard_for_contact);
2640: END IF;
2641:
2642: /* R12 Employee HelpDesk Modifications */
2643:

Line 3185: FND_PROFILE.GET('CSC_DASHBOARD_VIEW_FOR_CONTACT',g_dashboard_for_contact);

3181: l_ua_total :=0;
3182: END IF;
3183:
3184: IF g_dashboard_for_contact IS NULL THEN
3185: FND_PROFILE.GET('CSC_DASHBOARD_VIEW_FOR_CONTACT',g_dashboard_for_contact);
3186: END IF;
3187:
3188: IF g_dashboard_for_contact = 'Y' THEN
3189: l_ip_total := 0;

Line 6977: l_critical_flag := FND_PROFILE.value_specific

6973: p_media_item_id => l_media_item_id );
6974:
6975: /* get the value of auto refresh PO if not passed from OTM */
6976: IF p_critical_flag IS NULL THEN
6977: l_critical_flag := FND_PROFILE.value_specific
6978: ( name => 'CSC_DASHBOARD_AUTO_REFRESH',
6979: responsibility_id => l_resp_id,
6980: application_id => l_resp_appl_id,
6981: user_id => -999

Line 6988: l_view_by := FND_PROFILE.value_specific

6984: l_critical_flag := p_critical_flag;
6985: END IF;
6986:
6987: /* profile option for defaulting view by in CC */
6988: l_view_by := FND_PROFILE.value_specific
6989: ( name => 'CSC_CC_DEFAULT_VIEW_BY',
6990: responsibility_id => l_resp_id,
6991: application_id => l_resp_appl_id,
6992: user_id => -999

Line 7003: l_hidden_party_id := FND_PROFILE.value_specific

6999: existing logic
7000: */
7001: IF l_emp_id IS NOT NULL AND l_which_ivr ='Employee' THEN
7002: IF l_view_by = 'CUSTOMER' THEN ---Refresh only for hidden customer
7003: l_hidden_party_id := FND_PROFILE.value_specific
7004: ( name => 'CS_SR_DEFAULT_CUSTOMER_NAME',
7005: responsibility_id => l_resp_id,
7006: application_id => l_resp_appl_id,
7007: user_id => -999

Line 7012: l_view_by_acct := FND_PROFILE.value_specific

7008: );
7009: /* Refresh for Customer only if Profile Option CS_SR_DEFAULT_CUSTOMER_NAME returns a value */
7010: IF l_hidden_party_id IS NOT NULL THEN
7011: /* profile option for view_by_account in dashboard tab */
7012: l_view_by_acct := FND_PROFILE.value_specific
7013: ( name => 'CSC_DASHBOARD_TO_QUERY_BY_PARTY_OR_ACCOUNT',
7014: responsibility_id => l_resp_id,
7015: application_id => l_resp_appl_id,
7016: user_id => -999

Line 7026: l_show_active_acct := FND_PROFILE.value_specific

7022: Else get account_id based on profile option CSC_CC_DEFAULT_ACCT */
7023:
7024: IF l_view_by_acct = 'ACCOUNT' THEN
7025: IF l_acct_id IS NULL THEN
7026: l_show_active_acct := FND_PROFILE.value_specific
7027: ( name => 'CSC_CONTACT_CENTER_SHOW_ACTIVE_ACCOUNTS',
7028: responsibility_id => l_resp_id,
7029: application_id => l_resp_appl_id,
7030: user_id => -999

Line 7045: l_acct_new_old := FND_PROFILE.value_specific

7041: l_acct_id := NULL;
7042: END;
7043:
7044: IF l_acct_id IS NULL THEN
7045: l_acct_new_old := FND_PROFILE.value_specific
7046: ( name => 'CSC_CC_DEFAULT_ACCT',
7047: responsibility_id => l_resp_id,
7048: application_id => l_resp_appl_id,
7049: user_id => -999

Line 7147: l_contact_type := FND_PROFILE.value_specific

7143:
7144: END IF; /* l_view_by for HelpDesk Context */
7145:
7146: ELSIF l_emp_id IS NOT NULL AND l_which_ivr ='SR' THEN
7147: l_contact_type := FND_PROFILE.value_specific
7148: ( name => 'CSC_CC_DEFAULT_CONTACT_TYPE',
7149: responsibility_id => l_resp_id,
7150: application_id => l_resp_appl_id,
7151: user_id => -999

Line 7158: l_view_by_acct := FND_PROFILE.value_specific

7154: IF l_view_by = 'CUSTOMER' THEN
7155: --refresh dashboard for customer using l_party_id
7156: IF l_party_id IS NOT NULL THEN
7157: /* profile option for view_by_account in dashboard tab */
7158: l_view_by_acct := FND_PROFILE.value_specific
7159: ( name => 'CSC_DASHBOARD_TO_QUERY_BY_PARTY_OR_ACCOUNT',
7160: responsibility_id => l_resp_id,
7161: application_id => l_resp_appl_id,
7162: user_id => -999

Line 7172: l_show_active_acct := FND_PROFILE.value_specific

7168: Else get account_id based on profile option CSC_CC_DEFAULT_ACCT */
7169:
7170: IF l_view_by_acct = 'ACCOUNT' THEN
7171: IF l_acct_id IS NULL THEN
7172: l_show_active_acct := FND_PROFILE.value_specific
7173: ( name => 'CSC_CONTACT_CENTER_SHOW_ACTIVE_ACCOUNTS',
7174: responsibility_id => l_resp_id,
7175: application_id => l_resp_appl_id,
7176: user_id => -999

Line 7191: l_acct_new_old := FND_PROFILE.value_specific

7187: l_acct_id := NULL;
7188: END;
7189:
7190: IF l_acct_id IS NULL THEN
7191: l_acct_new_old := FND_PROFILE.value_specific
7192: ( name => 'CSC_CC_DEFAULT_ACCT',
7193: responsibility_id => l_resp_id,
7194: application_id => l_resp_appl_id,
7195: user_id => -999

Line 7354: l_view_by_acct := FND_PROFILE.value_specific

7350: CLOSE get_cust_from_cont;
7351: END IF;
7352:
7353: /* profile option for view_by_account in dashboard tab */
7354: l_view_by_acct := FND_PROFILE.value_specific
7355: ( name => 'CSC_DASHBOARD_TO_QUERY_BY_PARTY_OR_ACCOUNT',
7356: responsibility_id => l_resp_id,
7357: application_id => l_resp_appl_id,
7358: user_id => -999

Line 7368: l_show_active_acct := FND_PROFILE.value_specific

7364: Else get account_id based on profile option CSC_CC_DEFAULT_ACCT */
7365:
7366: IF l_view_by_acct = 'ACCOUNT' THEN
7367: IF l_acct_id IS NULL THEN
7368: l_show_active_acct := FND_PROFILE.value_specific
7369: ( name => 'CSC_CONTACT_CENTER_SHOW_ACTIVE_ACCOUNTS',
7370: responsibility_id => l_resp_id,
7371: application_id => l_resp_appl_id,
7372: user_id => -999

Line 7387: l_acct_new_old := FND_PROFILE.value_specific

7383: l_acct_id := NULL;
7384: END;
7385:
7386: IF l_acct_id IS NULL THEN
7387: l_acct_new_old := FND_PROFILE.value_specific
7388: ( name => 'CSC_CC_DEFAULT_ACCT',
7389: responsibility_id => l_resp_id,
7390: application_id => l_resp_appl_id,
7391: user_id => -999

Line 7524: This function has been added as API fnd_profile.value_specific is

7520: /*******************************************
7521: GET_PROFILE_VALUE_RESP
7522: Added this procedure for JIT enhancement -- Bug 4535407
7523: Returns Profile Option value at the responsibility level.
7524: This function has been added as API fnd_profile.value_specific is
7525: not defined at form level FND_PROFILE package (pld)
7526: ********************************************/
7527:
7528: FUNCTION get_profile_value_resp

Line 7525: not defined at form level FND_PROFILE package (pld)

7521: GET_PROFILE_VALUE_RESP
7522: Added this procedure for JIT enhancement -- Bug 4535407
7523: Returns Profile Option value at the responsibility level.
7524: This function has been added as API fnd_profile.value_specific is
7525: not defined at form level FND_PROFILE package (pld)
7526: ********************************************/
7527:
7528: FUNCTION get_profile_value_resp
7529: ( p_profile_name VARCHAR2,

Line 7538: l_prof_value := FND_PROFILE.value_specific

7534: RETURN VARCHAR2
7535: IS
7536: l_prof_value VARCHAR2(255);
7537: BEGIN
7538: l_prof_value := FND_PROFILE.value_specific
7539: ( name => p_profile_name,
7540: responsibility_id => p_resp_id,
7541: application_id => p_resp_appl_id,
7542: user_id => p_user_id