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.

[Home] [Help]

APPS.PA_TASK_ASSIGNMENTS_PVT dependencies on GL_PERIODS

Line 68: l_period_name gl_periods.period_name%TYPE;

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

Line 1548: ,gl_periods glp

1544: ,pa_implementations_all pia
1545: ,pa_projects_all ppa
1546: ,pa_budget_versions pbv
1547: ,pa_proj_fp_options ppfo
1548: ,gl_periods glp
1549: WHERE ppa.project_id = pbv.project_id
1550: AND pbv.budget_version_id = ppfo.fin_plan_version_id
1551: AND nvl(ppa.org_id,-99) = nvl(pia.org_id,-99)
1552: AND gsb.set_of_books_id = pia.set_of_books_id

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

1552: AND gsb.set_of_books_id = pia.set_of_books_id
1553: AND pbv.budget_version_id = p_budget_version_id
1554: AND glp.period_set_name = gsb.period_set_name
1555: -- this condition is not required as
1556: -- period_set_name and period_name are the unique columns on gl_periods
1557: -- and glp.period_type = decode(pbv.version_type
1558: -- ,'COST', decode(ppfo.cost_time_phased_code,'G',gsb.accounted_period_type,'P',pia.pa_period_type)
1559: -- ,'REVENUE',decode(ppfo.revenue_time_phased_code,'G',gsb.accounted_period_type,'P',pia.pa_period_type)
1560: -- ,decode(ppfo.all_time_phased_code,'G',gsb.accounted_period_type,'P',pia.pa_period_type))

Line 2259: p_period_set_name IN gl_periods.period_set_name%TYPE,

2255:
2256:
2257: PROCEDURE Check_Period_Details(
2258: P_BUDGET_VERSION_ID IN pa_budget_versions.budget_version_id%TYPE,
2259: p_period_set_name IN gl_periods.period_set_name%TYPE,
2260: p_time_phase_code IN pa_proj_fp_options.cost_time_phased_code%TYPE,
2261: p_accounted_period_type IN gl_periods.period_type%TYPE,
2262: p_pa_period_type IN gl_periods.period_type%TYPE,
2263: p_task_name IN pa_proj_elements.name%TYPE,

Line 2261: p_accounted_period_type IN gl_periods.period_type%TYPE,

2257: PROCEDURE Check_Period_Details(
2258: P_BUDGET_VERSION_ID IN pa_budget_versions.budget_version_id%TYPE,
2259: p_period_set_name IN gl_periods.period_set_name%TYPE,
2260: p_time_phase_code IN pa_proj_fp_options.cost_time_phased_code%TYPE,
2261: p_accounted_period_type IN gl_periods.period_type%TYPE,
2262: p_pa_period_type IN gl_periods.period_type%TYPE,
2263: p_task_name IN pa_proj_elements.name%TYPE,
2264: p_rlm_alias IN pa_resource_list_members.alias%TYPE,
2265: P_PERIOD_NAME IN OUT NOCOPY VARCHAR2, -- 4537865

Line 2262: p_pa_period_type IN gl_periods.period_type%TYPE,

2258: P_BUDGET_VERSION_ID IN pa_budget_versions.budget_version_id%TYPE,
2259: p_period_set_name IN gl_periods.period_set_name%TYPE,
2260: p_time_phase_code IN pa_proj_fp_options.cost_time_phased_code%TYPE,
2261: p_accounted_period_type IN gl_periods.period_type%TYPE,
2262: p_pa_period_type IN gl_periods.period_type%TYPE,
2263: p_task_name IN pa_proj_elements.name%TYPE,
2264: p_rlm_alias IN pa_resource_list_members.alias%TYPE,
2265: P_PERIOD_NAME IN OUT NOCOPY VARCHAR2, -- 4537865
2266: P_PERIOD_START_DATE IN OUT NOCOPY DATE, -- 4537865

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

2267: P_PERIOD_END_DATE IN OUT NOCOPY DATE, -- 4537865
2268: x_return_status OUT NOCOPY VARCHAR2
2269: ) IS
2270:
2271: l_period_name gl_periods.period_name%type := NULL;
2272: l_period_start_date gl_periods.start_date%type := NULL;
2273: l_period_end_date gl_periods.end_date%type := NULL;
2274:
2275:

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

2268: x_return_status OUT NOCOPY VARCHAR2
2269: ) IS
2270:
2271: l_period_name gl_periods.period_name%type := NULL;
2272: l_period_start_date gl_periods.start_date%type := NULL;
2273: l_period_end_date gl_periods.end_date%type := NULL;
2274:
2275:
2276: CURSOR get_period_name_from_dates IS

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

2269: ) IS
2270:
2271: l_period_name gl_periods.period_name%type := NULL;
2272: l_period_start_date gl_periods.start_date%type := NULL;
2273: l_period_end_date gl_periods.end_date%type := NULL;
2274:
2275:
2276: CURSOR get_period_name_from_dates IS
2277: SELECT start_date,

Line 2280: FROM gl_periods

2276: CURSOR get_period_name_from_dates IS
2277: SELECT start_date,
2278: end_date,
2279: period_name
2280: FROM gl_periods
2281: WHERE period_set_name = p_period_set_name
2282: AND period_type =
2283: decode(p_time_phase_code,'G',p_accounted_period_type,
2284: 'P',p_pa_period_type)

Line 2294: FROM gl_periods

2290: CURSOR get_period_dates_from_name IS
2291: SELECT start_date,
2292: end_date,
2293: period_name
2294: FROM gl_periods
2295: WHERE period_set_name = p_period_set_name
2296: AND period_type =
2297: decode(p_time_phase_code,'G',p_accounted_period_type,
2298: 'P',p_pa_period_type)