45: if ((l_settings_proj_perf_flag is null and
46: l_settings_cost_flag is null and
47: l_settings_profit_flag is null and
48: l_settings_util_flag is null) or
49: FND_PROFILE.VALUE('BIS_GLOBAL_START_DATE') is null or
50: FND_PROFILE.VALUE('BIS_PRIMARY_CURRENCY_CODE') is null or
51: FND_PROFILE.VALUE('BIS_PRIMARY_RATE_TYPE') is null or
52: FND_PROFILE.VALUE('BIS_ENTERPRISE_CALENDAR') is null or
53: FND_PROFILE.VALUE('BIS_PERIOD_TYPE') is null) then
46: l_settings_cost_flag is null and
47: l_settings_profit_flag is null and
48: l_settings_util_flag is null) or
49: FND_PROFILE.VALUE('BIS_GLOBAL_START_DATE') is null or
50: FND_PROFILE.VALUE('BIS_PRIMARY_CURRENCY_CODE') is null or
51: FND_PROFILE.VALUE('BIS_PRIMARY_RATE_TYPE') is null or
52: FND_PROFILE.VALUE('BIS_ENTERPRISE_CALENDAR') is null or
53: FND_PROFILE.VALUE('BIS_PERIOD_TYPE') is null) then
54:
47: l_settings_profit_flag is null and
48: l_settings_util_flag is null) or
49: FND_PROFILE.VALUE('BIS_GLOBAL_START_DATE') is null or
50: FND_PROFILE.VALUE('BIS_PRIMARY_CURRENCY_CODE') is null or
51: FND_PROFILE.VALUE('BIS_PRIMARY_RATE_TYPE') is null or
52: FND_PROFILE.VALUE('BIS_ENTERPRISE_CALENDAR') is null or
53: FND_PROFILE.VALUE('BIS_PERIOD_TYPE') is null) then
54:
55: rollback;
48: l_settings_util_flag is null) or
49: FND_PROFILE.VALUE('BIS_GLOBAL_START_DATE') is null or
50: FND_PROFILE.VALUE('BIS_PRIMARY_CURRENCY_CODE') is null or
51: FND_PROFILE.VALUE('BIS_PRIMARY_RATE_TYPE') is null or
52: FND_PROFILE.VALUE('BIS_ENTERPRISE_CALENDAR') is null or
53: FND_PROFILE.VALUE('BIS_PERIOD_TYPE') is null) then
54:
55: rollback;
56: dbms_standard.raise_application_error(-20044, l_no_setup_error);
49: FND_PROFILE.VALUE('BIS_GLOBAL_START_DATE') is null or
50: FND_PROFILE.VALUE('BIS_PRIMARY_CURRENCY_CODE') is null or
51: FND_PROFILE.VALUE('BIS_PRIMARY_RATE_TYPE') is null or
52: FND_PROFILE.VALUE('BIS_ENTERPRISE_CALENDAR') is null or
53: FND_PROFILE.VALUE('BIS_PERIOD_TYPE') is null) then
54:
55: rollback;
56: dbms_standard.raise_application_error(-20044, l_no_setup_error);
57:
848: 'PROCESS_RUNNING',
849: 'Y');
850:
851: -- ensure that worker and helpers can run concurrently
852: FND_PROFILE.PUT('CONC_SINGLE_THREAD', 'N');
853: commit;
854:
855: l_parallel_processes :=
856: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, 'PARALLEL_PROCESSES');
1059: 'RECVR_PA1', p_g1_currency_code,
1060: 'RECVR_PA2', p_g2_currency_code) G_CURRENCY_CODE,
1061: decode(invert.INVERT_ID,
1062: 'RECVR_GL1', PJI_UTILS.GET_RATE_TYPE,
1063: 'RECVR_GL2', FND_PROFILE.VALUE('BIS_SECONDARY_RATE_TYPE'),
1064: 'RECVR_PA1', PJI_UTILS.GET_RATE_TYPE,
1065: 'RECVR_PA2', FND_PROFILE.VALUE('BIS_SECONDARY_RATE_TYPE'))
1066: RATE_TYPE
1067: from
1061: decode(invert.INVERT_ID,
1062: 'RECVR_GL1', PJI_UTILS.GET_RATE_TYPE,
1063: 'RECVR_GL2', FND_PROFILE.VALUE('BIS_SECONDARY_RATE_TYPE'),
1064: 'RECVR_PA1', PJI_UTILS.GET_RATE_TYPE,
1065: 'RECVR_PA2', FND_PROFILE.VALUE('BIS_SECONDARY_RATE_TYPE'))
1066: RATE_TYPE
1067: from
1068: PJI_FM_DNGL_FIN tmp2,
1069: (
1115: 'PA1', p_g1_currency_code,
1116: 'PA2', p_g2_currency_code) G_CURRENCY_CODE,
1117: decode(invert.INVERT_ID,
1118: 'GL1', PJI_UTILS.GET_RATE_TYPE,
1119: 'GL2', FND_PROFILE.VALUE('BIS_SECONDARY_RATE_TYPE'),
1120: 'PA1', PJI_UTILS.GET_RATE_TYPE,
1121: 'PA2', FND_PROFILE.VALUE('BIS_SECONDARY_RATE_TYPE'))
1122: RATE_TYPE
1123: from
1117: decode(invert.INVERT_ID,
1118: 'GL1', PJI_UTILS.GET_RATE_TYPE,
1119: 'GL2', FND_PROFILE.VALUE('BIS_SECONDARY_RATE_TYPE'),
1120: 'PA1', PJI_UTILS.GET_RATE_TYPE,
1121: 'PA2', FND_PROFILE.VALUE('BIS_SECONDARY_RATE_TYPE'))
1122: RATE_TYPE
1123: from
1124: PJI_FM_DNGL_ACT tmp2,
1125: (