eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_TASK_ASSIGNMENTS_PVT dependencies on GL_PERIODS

Line 67: l_period_name gl_periods.period_name%TYPE;

63: l_period_set_name gl_sets_of_books.period_set_name%TYPE;
64: l_accounted_period_type gl_sets_of_books.accounted_period_type%TYPE;
65: l_pa_period_type pa_implementations_all.pa_period_type%TYPE;
66: l_time_phased_code pa_proj_fp_options.all_time_phased_code%TYPE;
67: l_period_name gl_periods.period_name%TYPE;
68: l_period_start_date DATE;
69: l_period_end_date DATE;
70: -- 10/22/04: To handle only lines after the progress as of date
71: l_finplan_line_count NUMBER := 1;

Line 1335: ,gl_periods glp

1331: ,pa_implementations_all pia
1332: ,pa_projects_all ppa
1333: ,pa_budget_versions pbv
1334: ,pa_proj_fp_options ppfo
1335: ,gl_periods glp
1336: WHERE ppa.project_id = pbv.project_id
1337: AND pbv.budget_version_id = ppfo.fin_plan_version_id
1338: AND nvl(ppa.org_id,-99) = nvl(pia.org_id,-99)
1339: AND gsb.set_of_books_id = pia.set_of_books_id

Line 1343: -- period_set_name and period_name are the unique columns on gl_periods

1339: AND gsb.set_of_books_id = pia.set_of_books_id
1340: AND pbv.budget_version_id = p_budget_version_id
1341: AND glp.period_set_name = gsb.period_set_name
1342: -- this condition is not required as
1343: -- period_set_name and period_name are the unique columns on gl_periods
1344: -- and glp.period_type = decode(pbv.version_type
1345: -- ,'COST', decode(ppfo.cost_time_phased_code,'G',gsb.accounted_period_type,'P',pia.pa_period_type)
1346: -- ,'REVENUE',decode(ppfo.revenue_time_phased_code,'G',gsb.accounted_period_type,'P',pia.pa_period_type)
1347: -- ,decode(ppfo.all_time_phased_code,'G',gsb.accounted_period_type,'P',pia.pa_period_type))

Line 2019: p_period_set_name IN gl_periods.period_set_name%TYPE,

2015:
2016:
2017: PROCEDURE Check_Period_Details(
2018: P_BUDGET_VERSION_ID IN pa_budget_versions.budget_version_id%TYPE,
2019: p_period_set_name IN gl_periods.period_set_name%TYPE,
2020: p_time_phase_code IN pa_proj_fp_options.cost_time_phased_code%TYPE,
2021: p_accounted_period_type IN gl_periods.period_type%TYPE,
2022: p_pa_period_type IN gl_periods.period_type%TYPE,
2023: p_task_name IN pa_proj_elements.name%TYPE,

Line 2021: p_accounted_period_type IN gl_periods.period_type%TYPE,

2017: PROCEDURE Check_Period_Details(
2018: P_BUDGET_VERSION_ID IN pa_budget_versions.budget_version_id%TYPE,
2019: p_period_set_name IN gl_periods.period_set_name%TYPE,
2020: p_time_phase_code IN pa_proj_fp_options.cost_time_phased_code%TYPE,
2021: p_accounted_period_type IN gl_periods.period_type%TYPE,
2022: p_pa_period_type IN gl_periods.period_type%TYPE,
2023: p_task_name IN pa_proj_elements.name%TYPE,
2024: p_rlm_alias IN pa_resource_list_members.alias%TYPE,
2025: P_PERIOD_NAME IN OUT NOCOPY VARCHAR2, -- 4537865

Line 2022: p_pa_period_type IN gl_periods.period_type%TYPE,

2018: P_BUDGET_VERSION_ID IN pa_budget_versions.budget_version_id%TYPE,
2019: p_period_set_name IN gl_periods.period_set_name%TYPE,
2020: p_time_phase_code IN pa_proj_fp_options.cost_time_phased_code%TYPE,
2021: p_accounted_period_type IN gl_periods.period_type%TYPE,
2022: p_pa_period_type IN gl_periods.period_type%TYPE,
2023: p_task_name IN pa_proj_elements.name%TYPE,
2024: p_rlm_alias IN pa_resource_list_members.alias%TYPE,
2025: P_PERIOD_NAME IN OUT NOCOPY VARCHAR2, -- 4537865
2026: P_PERIOD_START_DATE IN OUT NOCOPY DATE, -- 4537865

Line 2031: l_period_name gl_periods.period_name%type := NULL;

2027: P_PERIOD_END_DATE IN OUT NOCOPY DATE, -- 4537865
2028: x_return_status OUT NOCOPY VARCHAR2
2029: ) IS
2030:
2031: l_period_name gl_periods.period_name%type := NULL;
2032: l_period_start_date gl_periods.start_date%type := NULL;
2033: l_period_end_date gl_periods.end_date%type := NULL;
2034:
2035:

Line 2032: l_period_start_date gl_periods.start_date%type := NULL;

2028: x_return_status OUT NOCOPY VARCHAR2
2029: ) IS
2030:
2031: l_period_name gl_periods.period_name%type := NULL;
2032: l_period_start_date gl_periods.start_date%type := NULL;
2033: l_period_end_date gl_periods.end_date%type := NULL;
2034:
2035:
2036: CURSOR get_period_name_from_dates IS

Line 2033: l_period_end_date gl_periods.end_date%type := NULL;

2029: ) IS
2030:
2031: l_period_name gl_periods.period_name%type := NULL;
2032: l_period_start_date gl_periods.start_date%type := NULL;
2033: l_period_end_date gl_periods.end_date%type := NULL;
2034:
2035:
2036: CURSOR get_period_name_from_dates IS
2037: SELECT start_date,

Line 2040: FROM gl_periods

2036: CURSOR get_period_name_from_dates IS
2037: SELECT start_date,
2038: end_date,
2039: period_name
2040: FROM gl_periods
2041: WHERE period_set_name = p_period_set_name
2042: AND period_type =
2043: decode(p_time_phase_code,'G',p_accounted_period_type,
2044: 'P',p_pa_period_type)

Line 2054: FROM gl_periods

2050: CURSOR get_period_dates_from_name IS
2051: SELECT start_date,
2052: end_date,
2053: period_name
2054: FROM gl_periods
2055: WHERE period_set_name = p_period_set_name
2056: AND period_type =
2057: decode(p_time_phase_code,'G',p_accounted_period_type,
2058: 'P',p_pa_period_type)