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_FIN_PLAN_PUB dependencies on PA_IMPLEMENTATIONS

Line 3618: l_org_structure_version_id pa_implementations_all.org_structure_version_id%TYPE;

3614: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
3615: l_org_fcst_period_type pa_forecasting_options_all.org_fcst_period_type%TYPE;
3616: l_org_time_phased_code pa_proj_fp_options.all_time_phased_code%TYPE;
3617: l_org_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
3618: l_org_structure_version_id pa_implementations_all.org_structure_version_id%TYPE;
3619: l_period_set_name pa_implementations_all.period_set_name%TYPE;
3620: l_act_period_type gl_periods.period_type%TYPE;
3621: l_org_projfunc_currency_code gl_sets_of_books.currency_code%TYPE;
3622: l_number_of_periods pa_forecasting_options_all.number_of_periods%TYPE;

Line 3619: l_period_set_name pa_implementations_all.period_set_name%TYPE;

3615: l_org_fcst_period_type pa_forecasting_options_all.org_fcst_period_type%TYPE;
3616: l_org_time_phased_code pa_proj_fp_options.all_time_phased_code%TYPE;
3617: l_org_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
3618: l_org_structure_version_id pa_implementations_all.org_structure_version_id%TYPE;
3619: l_period_set_name pa_implementations_all.period_set_name%TYPE;
3620: l_act_period_type gl_periods.period_type%TYPE;
3621: l_org_projfunc_currency_code gl_sets_of_books.currency_code%TYPE;
3622: l_number_of_periods pa_forecasting_options_all.number_of_periods%TYPE;
3623: l_request_id pa_budget_versions.request_id%TYPE;

Line 3632: l_pa_period_type pa_implementations_all.pa_period_type%TYPE;

3628: l_org_id pa_forecasting_options_all.org_id%TYPE;
3629: l_period_profile_id pa_proj_period_profiles.period_profile_id%TYPE;
3630: l_ppp_start_date DATE;
3631: l_ppp_end_date DATE;
3632: l_pa_period_type pa_implementations_all.pa_period_type%TYPE;
3633:
3634: cursor amount_set_csr is
3635: select
3636: fin_plan_amount_set_id

Line 6806: ,PA_IMPLEMENTATIONS i

6802: --Fetch the start date of the period in to which p_profile_start_date falls
6803: SELECT start_date
6804: INTO x_start_period_start_date
6805: FROM GL_PERIOD_STATUSES g
6806: ,PA_IMPLEMENTATIONS i
6807: WHERE adjustment_period_flag = 'N'
6808: AND g.application_id = pa_period_process_pkg.application_id
6809: AND g.set_of_books_id = i.set_of_books_id
6810: AND p_profile_start_date BETWEEN g.start_date AND g.end_date;

Line 6816: ,PA_IMPLEMENTATIONS i

6812: WHEN NO_DATA_FOUND THEN
6813: SELECT MIN(start_date)
6814: INTO x_start_period_start_date
6815: FROM GL_PERIOD_STATUSES g
6816: ,PA_IMPLEMENTATIONS i
6817: WHERE adjustment_period_flag = 'N'
6818: AND g.application_id = pa_period_process_pkg.application_id
6819: AND g.set_of_books_id = i.set_of_books_id;
6820: END;

Line 6827: ,PA_IMPLEMENTATIONS i

6823: --Fetch the end date of the period in to which p_profile_end_date falls
6824: SELECT end_date
6825: INTO x_end_period_end_date
6826: FROM GL_PERIOD_STATUSES g
6827: ,PA_IMPLEMENTATIONS i
6828: WHERE adjustment_period_flag = 'N'
6829: AND g.application_id = pa_period_process_pkg.application_id
6830: AND g.set_of_books_id = i.set_of_books_id
6831: AND p_profile_end_date BETWEEN g.start_date AND g.end_date;

Line 6837: ,PA_IMPLEMENTATIONS i

6833: WHEN NO_DATA_FOUND THEN
6834: SELECT MAX(end_date)
6835: INTO x_end_period_end_date--Selected the max(end_date) into x_end_period_end_date. Bug 3329002.
6836: FROM GL_PERIOD_STATUSES g
6837: ,PA_IMPLEMENTATIONS i
6838: WHERE adjustment_period_flag = 'N'
6839: AND g.application_id = pa_period_process_pkg.application_id
6840: AND g.set_of_books_id = i.set_of_books_id;
6841: END;

Line 6908: ,PA_IMPLEMENTATIONS i

6904:
6905: SELECT start_date
6906: INTO l_profile_start_date
6907: FROM GL_PERIOD_STATUSES a
6908: ,PA_IMPLEMENTATIONS i
6909: WHERE a.application_id = pa_period_process_pkg.application_id
6910: AND a.set_of_books_id = i.set_of_books_id
6911: AND a.adjustment_period_flag = 'N'
6912: AND 51= (SELECT COUNT(*) FROM GL_PERIOD_STATUSES b

Line 6913: ,PA_IMPLEMENTATIONS i2

6909: WHERE a.application_id = pa_period_process_pkg.application_id
6910: AND a.set_of_books_id = i.set_of_books_id
6911: AND a.adjustment_period_flag = 'N'
6912: AND 51= (SELECT COUNT(*) FROM GL_PERIOD_STATUSES b
6913: ,PA_IMPLEMENTATIONS i2
6914: WHERE b.adjustment_period_flag = 'N'
6915: AND b.application_id = pa_period_process_pkg.application_id
6916: AND b.set_of_books_id = i2.set_of_books_id
6917: AND a.start_date < b.start_date

Line 6931: ,PA_IMPLEMENTATIONS i

6927: */
6928: SELECT MIN(start_date)
6929: INTO l_profile_start_date
6930: FROM GL_PERIOD_STATUSES a
6931: ,PA_IMPLEMENTATIONS i
6932: WHERE a.application_id = pa_period_process_pkg.application_id
6933: AND a.set_of_books_id = i.set_of_books_id
6934: AND a.adjustment_period_flag = 'N';
6935: END;

Line 6997: ,PA_IMPLEMENTATIONS i

6993:
6994: SELECT end_date
6995: INTO l_profile_end_date
6996: FROM GL_PERIOD_STATUSES a
6997: ,PA_IMPLEMENTATIONS i
6998: WHERE a.application_id = pa_period_process_pkg.application_id
6999: AND a.set_of_books_id = i.set_of_books_id
7000: AND a.adjustment_period_flag = 'N'
7001: AND 51= (SELECT COUNT(*) FROM GL_PERIOD_STATUSES b

Line 7002: ,PA_IMPLEMENTATIONS i2

6998: WHERE a.application_id = pa_period_process_pkg.application_id
6999: AND a.set_of_books_id = i.set_of_books_id
7000: AND a.adjustment_period_flag = 'N'
7001: AND 51= (SELECT COUNT(*) FROM GL_PERIOD_STATUSES b
7002: ,PA_IMPLEMENTATIONS i2
7003: WHERE b.adjustment_period_flag = 'N'
7004: AND b.application_id = pa_period_process_pkg.application_id
7005: AND b.set_of_books_id = i2.set_of_books_id
7006: AND a.start_date > b.start_date

Line 7020: ,PA_IMPLEMENTATIONS i

7016: */
7017: SELECT MAX(end_date)
7018: INTO l_profile_end_date
7019: FROM GL_PERIOD_STATUSES a
7020: ,PA_IMPLEMENTATIONS i
7021: WHERE a.application_id = pa_period_process_pkg.application_id
7022: AND a.set_of_books_id = i.set_of_books_id
7023: AND a.adjustment_period_flag = 'N';
7024: END;

Line 7119: l_pa_period_type pa_implementations.pa_period_type%TYPE;

7115:
7116: l_number_of_periods NUMBER;
7117: l_period_set_name gl_sets_of_books.period_set_name%TYPE;
7118: l_accounted_period_type gl_sets_of_books.accounted_period_type%TYPE;
7119: l_pa_period_type pa_implementations.pa_period_type%TYPE;
7120:
7121: l_plan_start_date gl_periods.start_date%TYPE;
7122: l_plan_end_date gl_periods.end_date%TYPE;
7123:

Line 7246: FROM pa_implementations a

7242: PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_GL ,NULL) --pa_period_type
7243: INTO l_period_set_name
7244: ,l_accounted_period_type
7245: ,l_pa_period_type
7246: FROM pa_implementations a
7247: ,gl_sets_of_books b
7248: WHERE a.set_of_books_id = b.set_of_books_id;
7249:
7250: IF TRUNC(SYSDATE) BETWEEN l_start_date AND l_end_date THEN /*2690087*/

Line 7271: ,PA_IMPLEMENTATIONS i

7267:
7268: SELECT count(*)
7269: INTO l_number_of_periods
7270: FROM GL_PERIOD_STATUSES a
7271: ,PA_IMPLEMENTATIONS i
7272: WHERE a.application_id = pa_period_process_pkg.application_id
7273: AND a.set_of_books_id = i.set_of_books_id
7274: AND a.adjustment_period_flag = 'N'
7275: AND start_date BETWEEN TRUNC(SYSDATE) AND l_end_date; -- Bug :- 2623941, last condition has been put for 2623941

Line 7322: ,PA_IMPLEMENTATIONS i

7318:
7319: SELECT start_date
7320: INTO l_profile_start_date
7321: FROM GL_PERIOD_STATUSES g
7322: ,PA_IMPLEMENTATIONS i
7323: WHERE adjustment_period_flag = 'N'
7324: AND g.application_id = pa_period_process_pkg.application_id
7325: AND g.set_of_books_id = i.set_of_books_id
7326: AND TRUNC(SYSDATE) BETWEEN g.start_date AND g.end_date; /* Bug:- 2690087 */