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 479: FND_PROFILE.GET('CSC_DASHBOARD_VIEW_FOR_CONTACT',g_dashboard_for_contact);

475: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 REBUILD NOLOGGING';
476: END IF;
477: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS2_T' ;
478: IF g_dashboard_for_contact IS NULL THEN
479: FND_PROFILE.GET('CSC_DASHBOARD_VIEW_FOR_CONTACT',g_dashboard_for_contact);
480: END IF;
481: /* R12 Employee HelpDesk Modifications */
482: /* If g_dashboard_for_employee ='Y' then honour only employee level checks.If
483: 'N',honour party_level checks with option for contact level fetched from profile option */

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

1285: l_us_total :=0;
1286: END IF;
1287: -- End fix by spamujul ER#8473903
1288: IF g_dashboard_for_contact IS NULL THEN
1289: FND_PROFILE.GET('CSC_DASHBOARD_VIEW_FOR_CONTACT',g_dashboard_for_contact);
1290: END IF;
1291:
1292: IF g_dashboard_for_contact = 'Y' THEN
1293: l_ip_total := 0;

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

3192: END IF;
3193: -- End fix by spamujul for ER#8473903
3194: --New changes
3195: IF g_dashboard_for_contact IS NULL THEN
3196: FND_PROFILE.GET('CSC_DASHBOARD_VIEW_FOR_CONTACT',g_dashboard_for_contact);
3197: END IF;
3198: IF g_dashboard_for_contact = 'Y' THEN
3199: l_ip_total :=0;
3200: l_up_total :=0;

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

3726: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 REBUILD NOLOGGING';
3727: END IF;
3728: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS2_T' ;
3729: IF g_dashboard_for_contact IS NULL THEN
3730: FND_PROFILE.GET('CSC_DASHBOARD_VIEW_FOR_CONTACT', g_dashboard_for_contact);
3731: END IF;
3732: /* R12 Employee HelpDesk Modifications */
3733: IF g_dashboard_for_employee ='Y' THEN
3734: OPEN checks_csr FOR

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

4509: l_us_total :=0;
4510: END IF;
4511: -- End fix by spamujul ER#8473903
4512: IF g_dashboard_for_contact IS NULL THEN
4513: FND_PROFILE.GET('CSC_DASHBOARD_VIEW_FOR_CONTACT',g_dashboard_for_contact);
4514: END IF;
4515: IF g_dashboard_for_contact = 'Y' THEN
4516: l_ip_total := 0;
4517: l_up_total := 0;

Line 9695: l_critical_flag := FND_PROFILE.value_specific ( name => 'CSC_DASHBOARD_AUTO_REFRESH',

9691: p_err_code => NULL,
9692: p_media_item_id => l_media_item_id );
9693: /* get the value of auto refresh PO if not passed from OTM */
9694: IF p_critical_flag IS NULL THEN
9695: l_critical_flag := FND_PROFILE.value_specific ( name => 'CSC_DASHBOARD_AUTO_REFRESH',
9696: responsibility_id => l_resp_id,
9697: application_id => l_resp_appl_id,
9698: user_id => -999
9699: );

Line 9704: l_view_by := FND_PROFILE.value_specific ( name => 'CSC_CC_DEFAULT_VIEW_BY',

9700: ELSE
9701: l_critical_flag := p_critical_flag;
9702: END IF;
9703: /* profile option for defaulting view by in CC */
9704: l_view_by := FND_PROFILE.value_specific ( name => 'CSC_CC_DEFAULT_VIEW_BY',
9705: responsibility_id => l_resp_id,
9706: application_id => l_resp_appl_id,
9707: user_id => -999
9708: );

Line 9718: l_hidden_party_id := FND_PROFILE.value_specific( name => 'CS_SR_DEFAULT_CUSTOMER_NAME',

9714: existing logic
9715: */
9716: IF l_emp_id IS NOT NULL AND l_which_ivr ='Employee' THEN
9717: IF l_view_by = 'CUSTOMER' THEN ---Refresh only for hidden customer
9718: l_hidden_party_id := FND_PROFILE.value_specific( name => 'CS_SR_DEFAULT_CUSTOMER_NAME',
9719: responsibility_id => l_resp_id,
9720: application_id => l_resp_appl_id,
9721: user_id => -999
9722: );

Line 9726: l_view_by_acct := FND_PROFILE.value_specific( name => 'CSC_DASHBOARD_TO_QUERY_BY_PARTY_OR_ACCOUNT',

9722: );
9723: /* Refresh for Customer only if Profile Option CS_SR_DEFAULT_CUSTOMER_NAME returns a value */
9724: IF l_hidden_party_id IS NOT NULL THEN
9725: /* profile option for view_by_account in dashboard tab */
9726: l_view_by_acct := FND_PROFILE.value_specific( name => 'CSC_DASHBOARD_TO_QUERY_BY_PARTY_OR_ACCOUNT',
9727: responsibility_id => l_resp_id,
9728: application_id => l_resp_appl_id,
9729: user_id => -999
9730: );

Line 9738: l_show_active_acct := FND_PROFILE.value_specific( name => 'CSC_CONTACT_CENTER_SHOW_ACTIVE_ACCOUNTS',

9734: If yes, use this account.
9735: Else get account_id based on profile option CSC_CC_DEFAULT_ACCT */
9736: IF l_view_by_acct = 'ACCOUNT' THEN
9737: IF l_acct_id IS NULL THEN
9738: l_show_active_acct := FND_PROFILE.value_specific( name => 'CSC_CONTACT_CENTER_SHOW_ACTIVE_ACCOUNTS',
9739: responsibility_id => l_resp_id,
9740: application_id => l_resp_appl_id,
9741: user_id => -999
9742: );

Line 9755: l_acct_new_old := FND_PROFILE.value_specific( name => 'CSC_CC_DEFAULT_ACCT',

9751: WHEN OTHERS THEN
9752: l_acct_id := NULL;
9753: END;
9754: IF l_acct_id IS NULL THEN
9755: l_acct_new_old := FND_PROFILE.value_specific( name => 'CSC_CC_DEFAULT_ACCT',
9756: responsibility_id => l_resp_id,
9757: application_id => l_resp_appl_id,
9758: user_id => -999
9759: );

Line 9855: l_contact_type := FND_PROFILE.value_specific

9851:
9852: END IF; /* l_view_by for HelpDesk Context */
9853:
9854: ELSIF l_emp_id IS NOT NULL AND l_which_ivr ='SR' THEN
9855: l_contact_type := FND_PROFILE.value_specific
9856: ( name => 'CSC_CC_DEFAULT_CONTACT_TYPE',
9857: responsibility_id => l_resp_id,
9858: application_id => l_resp_appl_id,
9859: user_id => -999

Line 9866: l_view_by_acct := FND_PROFILE.value_specific

9862: IF l_view_by = 'CUSTOMER' THEN
9863: --refresh dashboard for customer using l_party_id
9864: IF l_party_id IS NOT NULL THEN
9865: /* profile option for view_by_account in dashboard tab */
9866: l_view_by_acct := FND_PROFILE.value_specific
9867: ( name => 'CSC_DASHBOARD_TO_QUERY_BY_PARTY_OR_ACCOUNT',
9868: responsibility_id => l_resp_id,
9869: application_id => l_resp_appl_id,
9870: user_id => -999

Line 9880: l_show_active_acct := FND_PROFILE.value_specific

9876: Else get account_id based on profile option CSC_CC_DEFAULT_ACCT */
9877:
9878: IF l_view_by_acct = 'ACCOUNT' THEN
9879: IF l_acct_id IS NULL THEN
9880: l_show_active_acct := FND_PROFILE.value_specific
9881: ( name => 'CSC_CONTACT_CENTER_SHOW_ACTIVE_ACCOUNTS',
9882: responsibility_id => l_resp_id,
9883: application_id => l_resp_appl_id,
9884: user_id => -999

Line 9899: l_acct_new_old := FND_PROFILE.value_specific

9895: l_acct_id := NULL;
9896: END;
9897:
9898: IF l_acct_id IS NULL THEN
9899: l_acct_new_old := FND_PROFILE.value_specific
9900: ( name => 'CSC_CC_DEFAULT_ACCT',
9901: responsibility_id => l_resp_id,
9902: application_id => l_resp_appl_id,
9903: user_id => -999

Line 10065: l_view_by_acct := FND_PROFILE.value_specific

10061: CLOSE get_cust_from_cont;
10062: END IF;
10063:
10064: /* profile option for view_by_account in dashboard tab */
10065: l_view_by_acct := FND_PROFILE.value_specific
10066: ( name => 'CSC_DASHBOARD_TO_QUERY_BY_PARTY_OR_ACCOUNT',
10067: responsibility_id => l_resp_id,
10068: application_id => l_resp_appl_id,
10069: user_id => -999

Line 10079: l_show_active_acct := FND_PROFILE.value_specific

10075: Else get account_id based on profile option CSC_CC_DEFAULT_ACCT */
10076:
10077: IF l_view_by_acct = 'ACCOUNT' THEN
10078: IF l_acct_id IS NULL THEN
10079: l_show_active_acct := FND_PROFILE.value_specific
10080: ( name => 'CSC_CONTACT_CENTER_SHOW_ACTIVE_ACCOUNTS',
10081: responsibility_id => l_resp_id,
10082: application_id => l_resp_appl_id,
10083: user_id => -999

Line 10098: l_acct_new_old := FND_PROFILE.value_specific

10094: l_acct_id := NULL;
10095: END;
10096:
10097: IF l_acct_id IS NULL THEN
10098: l_acct_new_old := FND_PROFILE.value_specific
10099: ( name => 'CSC_CC_DEFAULT_ACCT',
10100: responsibility_id => l_resp_id,
10101: application_id => l_resp_appl_id,
10102: user_id => -999

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

10233: /*******************************************
10234: GET_PROFILE_VALUE_RESP
10235: added this procedure for JIT enhancement -- Bug 4535407
10236: Returns Profile Option value at the responsibility level.
10237: This function has been added as API fnd_profile.value_specific is
10238: not defined at form level FND_PROFILE package (pld)
10239: ********************************************/
10240:
10241: FUNCTION get_profile_value_resp ( p_profile_name VARCHAR2,

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

10234: GET_PROFILE_VALUE_RESP
10235: added this procedure for JIT enhancement -- Bug 4535407
10236: Returns Profile Option value at the responsibility level.
10237: This function has been added as API fnd_profile.value_specific is
10238: not defined at form level FND_PROFILE package (pld)
10239: ********************************************/
10240:
10241: FUNCTION get_profile_value_resp ( p_profile_name VARCHAR2,
10242: p_resp_id NUMBER,

Line 10249: l_prof_value := FND_PROFILE.value_specific

10245: ) RETURN VARCHAR2
10246: IS
10247: l_prof_value VARCHAR2(255);
10248: BEGIN
10249: l_prof_value := FND_PROFILE.value_specific
10250: ( name => p_profile_name,
10251: responsibility_id => p_resp_id,
10252: application_id => p_resp_appl_id,
10253: user_id => p_user_id