APPS.PJI_FM_SUM_BKLG dependencies on PJI_UTILS

Line 301: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;

297: )) then
298: return;
299: end if;
300:
301: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
302:
303: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema ,
304: 'PJI_FM_AGGR_ACT3',
305: 'NORMAL',

Line 944: l_g1_currency_code := PJI_UTILS.GET_GLOBAL_PRIMARY_CURRENCY;

940: l_g2_currency_flag
941: from
942: PJI_SYSTEM_SETTINGS;
943:
944: l_g1_currency_code := PJI_UTILS.GET_GLOBAL_PRIMARY_CURRENCY;
945: l_g2_currency_code := PJI_UTILS.GET_GLOBAL_SECONDARY_CURRENCY;
946:
947: IF l_calendar_id IS NULL THEN
948: l_daily_calendar_type := 'C';

Line 945: l_g2_currency_code := PJI_UTILS.GET_GLOBAL_SECONDARY_CURRENCY;

941: from
942: PJI_SYSTEM_SETTINGS;
943:
944: l_g1_currency_code := PJI_UTILS.GET_GLOBAL_PRIMARY_CURRENCY;
945: l_g2_currency_code := PJI_UTILS.GET_GLOBAL_SECONDARY_CURRENCY;
946:
947: IF l_calendar_id IS NULL THEN
948: l_daily_calendar_type := 'C';
949: l_aggr_calendar_type := 'E';

Line 1185: last_extr_date DATE := to_date(PJI_UTILS.GET_PARAMETER('LAST_FM_EXTR_DATE'),'YYYY/MM/DD');

1181: l_pa_calendar_flag VARCHAR2(1) := 'N';
1182: l_dbklg_days NUMBER := 0;
1183: l_max_date DATE := PJI_RM_SUM_MAIN.g_max_date;
1184: --temptemp needs to be PJI_PJI_LAST_EXTR_DATE
1185: last_extr_date DATE := to_date(PJI_UTILS.GET_PARAMETER('LAST_FM_EXTR_DATE'),'YYYY/MM/DD');
1186: l_commit_counter NUMBER := 0;
1187: l_dual_limit NUMBER := 0;
1188: l_dual NUMBER := 0;
1189: l_min_nocal_date DATE;

Line 1213: l_dbklg_days := to_number(PJI_UTILS.GET_SETUP_PARAMETER('DORMANT_BACKLOG_DAYS'));

1209: -- Assigning Values to the variables
1210:
1211: l_worker_id := p_worker_id;
1212:
1213: l_dbklg_days := to_number(PJI_UTILS.GET_SETUP_PARAMETER('DORMANT_BACKLOG_DAYS'));
1214:
1215: l_pa_calendar_flag := PJI_UTILS.GET_SETUP_PARAMETER('PA_PERIOD_FLAG');
1216:
1217: -- Code below has been added so that each programming unit

Line 1215: l_pa_calendar_flag := PJI_UTILS.GET_SETUP_PARAMETER('PA_PERIOD_FLAG');

1211: l_worker_id := p_worker_id;
1212:
1213: l_dbklg_days := to_number(PJI_UTILS.GET_SETUP_PARAMETER('DORMANT_BACKLOG_DAYS'));
1214:
1215: l_pa_calendar_flag := PJI_UTILS.GET_SETUP_PARAMETER('PA_PERIOD_FLAG');
1216:
1217: -- Code below has been added so that each programming unit
1218: -- handles the exception of the previous run
1219:

Line 1468: g_pji_schema := pji_utils.get_pji_schema_name;

1464:
1465:
1466:
1467: begin
1468: g_pji_schema := pji_utils.get_pji_schema_name;
1469:
1470: end PJI_FM_SUM_BKLG;