FND Design Data [Home] [Help]

Concurrent Program: PARRGLBB_ACTUALS

Product: PA - Projects
User Name: Generate Utilization Actuals - Obsolete
Description: Run Summarization for Actuals Utilization Amounts - Obsolete
Enabled: No
Execution Method: PL/SQL Stored Procedure
Argument Method: Standard

Executable: PARRGLBB_ACTUALS

User Name: PARRGLBB_ACTUALS
Description: Summarize Actuals Utilization Amounts
Execution Filename: PA_REP_UTIL_GLOB.get_util_ac_parm
Subroutine Name:
Request Set Arguments
Name Descriptive Flex Display Insert Update Default Type Default Value Shared Name
ATTRIBUTE1 $SRS$.PARRGLBB_ACTUALS Y Y YS SELECT FND_DATE.DATE_TO_DISPLAYDATE(per1.start_date) FROM gl_periods per1 WHERE per1.period_num = 1 AND (per1.period_set_name, per1.period_type, per1.period_year) IN (SELECT per.period_set_name, per.period_type, per.period_year FROM gl_periods per, pa_implementations i, gl_sets_of_books sob WHERE sob.set_of_books_id = i.set_of_books_id AND per.period_set_name = sob.period_set_name AND per.period_type = sob.accounted_period_type AND per.adjustment_period_flag = 'N' AND TRUNC(sysdate) between per.start_date and per.end_date)p_ac_start_date
ATTRIBUTE2 $SRS$.PARRGLBB_ACTUALS Y Y Yp_ac_end_date
ATTRIBUTE3 $SRS$.PARRGLBB_ACTUALS Y Y YS SELECT FND_DATE.DATE_TO_DISPLAYDATE(per1.start_date) FROM gl_periods per1 WHERE per1.period_num = 1 AND (per1.period_set_name, per1.period_type, per1.period_year) IN (SELECT per.period_set_name, per.period_type, per.period_year FROM gl_periods per, pa_implementations i, gl_sets_of_books sob WHERE sob.set_of_books_id = i.set_of_books_id AND per.period_set_name = sob.period_set_name AND per.period_type = sob.accounted_period_type AND per.adjustment_period_flag = 'N' AND TRUNC(sysdate) between per.start_date and per.end_date)p_fc_start_date
ATTRIBUTE4 $SRS$.PARRGLBB_ACTUALS Y Y Yp_fc_end_date
ATTRIBUTE5 $SRS$.PARRGLBB_ACTUALS Y Y YS SELECT meaning FROM pa_lookups WHERE lookup_type = 'PA_REP_UTIL_ORG_ROLLUP_METHOD' AND lookup_code = 'I'p_org_rollup_method
ATTRIBUTE6 $SRS$.PARRGLBB_ACTUALS N N NPPA_DEBUG_MODEp_debug_mode