APPS.MSC_CL_SCE_COLLECTION dependencies on FND_PROFILE

Line 26: G_MSC_CONFIGURATION VARCHAR2(20) := nvl(fnd_profile.value('MSC_X_CONFIGURATION'), G_CONF_APS);

22: -- If the profile option is null or not defined then assume it's value
23: -- as 'APS'.
24: --=====================================================================
25:
26: G_MSC_CONFIGURATION VARCHAR2(20) := nvl(fnd_profile.value('MSC_X_CONFIGURATION'), G_CONF_APS);
27:
28: PROCEDURE PROCESS_COMPANY_CHANGE(p_status OUT NOCOPY NUMBER) IS
29:
30: v_my_company_old_name msc_companies.company_name%TYPE;

Line 44: v_my_company_new_name := fnd_profile.value('MSC_X_COMPANY_NAME');

40:
41: END IF;
42:
43: -- ========== Get My company's new name ============
44: v_my_company_new_name := fnd_profile.value('MSC_X_COMPANY_NAME');
45: -- LOG_MESSAGE('The OEM''s Company new name is :'||v_my_company_new_name);
46: --LOG_MESSAGE('The OEM''s Company old name is :'||v_my_company_old_name);
47:
48: -- ========== Update msc_companies and msc_trading_partners with new name ===

Line 120: lv_msc_tp_coll_window := NVL(TO_NUMBER(FND_PROFILE.VALUE('MSC_COLLECTION_WINDOW_FOR_TP_CHANGES')),0);

116: -- Perform this step for Complete and partial collections only.
117: -- We need not to delete these tables for net change scenario
118: -- ======================================================================================
119: BEGIN
120: lv_msc_tp_coll_window := NVL(TO_NUMBER(FND_PROFILE.VALUE('MSC_COLLECTION_WINDOW_FOR_TP_CHANGES')),0);
121: EXCEPTION
122: WHEN OTHERS THEN
123: lv_msc_tp_coll_window := 0;
124: END;

Line 926: G_MSC_CONFIGURATION := nvl(fnd_profile.value('MSC_ATP_DEFAULT_INSTANCE'), G_CONF_APS);

922: -- Initialize G_MSC_CONFIGURATION if it is not initialized already
923: --=============================================================================
924:
925: IF G_MSC_CONFIGURATION = NULL THEN
926: G_MSC_CONFIGURATION := nvl(fnd_profile.value('MSC_ATP_DEFAULT_INSTANCE'), G_CONF_APS);
927: END IF;
928:
929: IF (G_MSC_CONFIGURATION = G_CONF_APS) THEN
930: BEGIN

Line 2106: passwd_len number := NVL(FND_PROFILE.VALUE('SIGNON_PASSWORD_LENGTH') , 5) ;

2102:
2103: FUNCTION build_passwd RETURN VARCHAR2
2104: IS
2105:
2106: passwd_len number := NVL(FND_PROFILE.VALUE('SIGNON_PASSWORD_LENGTH') , 5) ;
2107: msize number := passwd_len -8 ;
2108: p_password varchar2(30) := 'welcome1';
2109: Begin
2110: