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 121: lv_msc_tp_coll_window := NVL(TO_NUMBER(FND_PROFILE.VALUE('MSC_COLLECTION_WINDOW_FOR_TP_CHANGES')),0);

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

Line 129: SELECT decode(nvl(fnd_profile.value('MSC_PURGE_ST_CONTROL'),'N'),'Y',1,2)

125: END;
126:
127: --Bug#12863892 fp of bug 9645763
128: BEGIN
129: SELECT decode(nvl(fnd_profile.value('MSC_PURGE_ST_CONTROL'),'N'),'Y',1,2)
130: INTO lv_control_flag
131: FROM dual;
132: EXCEPTION
133: WHEN OTHERS THEN

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

1005: -- Initialize G_MSC_CONFIGURATION if it is not initialized already
1006: --=============================================================================
1007:
1008: IF G_MSC_CONFIGURATION = NULL THEN
1009: G_MSC_CONFIGURATION := nvl(fnd_profile.value('MSC_ATP_DEFAULT_INSTANCE'), G_CONF_APS);
1010: END IF;
1011:
1012: IF (G_MSC_CONFIGURATION = G_CONF_APS) THEN
1013: BEGIN

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

2187:
2188: FUNCTION build_passwd RETURN VARCHAR2
2189: IS
2190:
2191: passwd_len number := NVL(FND_PROFILE.VALUE('SIGNON_PASSWORD_LENGTH') , 5) ;
2192: msize number := passwd_len -8 ;
2193: p_password varchar2(30) := 'welcome1';
2194: Begin
2195: