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_CAP_INT_PVT dependencies on GL_PERIOD_STATUSES

Line 70: g_gl_app_id gl_period_statuses.application_id%TYPE := 101;

66: g_request_id NUMBER;
67:
68:
69: -- GL application ID
70: g_gl_app_id gl_period_statuses.application_id%TYPE := 101;
71:
72:
73: -- Alloc Rule ID for Capitalized Interest
74: g_cap_int_rule_id pa_alloc_rules_all.rule_id%TYPE := -1;

Line 78: g_gl_period gl_period_statuses.period_name%TYPE;

74: g_cap_int_rule_id pa_alloc_rules_all.rule_id%TYPE := -1;
75:
76:
77: -- Globally used variables
78: g_gl_period gl_period_statuses.period_name%TYPE;
79: g_project_id pa_projects_all.project_id%TYPE;
80: g_rate_name pa_ind_cost_codes.ind_cost_code%TYPE;
81: g_period_end_date gl_period_statuses.end_date%TYPE;
82: g_period_start_date gl_period_statuses.end_date%TYPE;

Line 81: g_period_end_date gl_period_statuses.end_date%TYPE;

77: -- Globally used variables
78: g_gl_period gl_period_statuses.period_name%TYPE;
79: g_project_id pa_projects_all.project_id%TYPE;
80: g_rate_name pa_ind_cost_codes.ind_cost_code%TYPE;
81: g_period_end_date gl_period_statuses.end_date%TYPE;
82: g_period_start_date gl_period_statuses.end_date%TYPE;
83: g_exp_item_date gl_period_statuses.end_date%TYPE;
84: g_bdgt_entry_level_code varchar2(2) := 'L'; -- Lowest level task
85:

Line 82: g_period_start_date gl_period_statuses.end_date%TYPE;

78: g_gl_period gl_period_statuses.period_name%TYPE;
79: g_project_id pa_projects_all.project_id%TYPE;
80: g_rate_name pa_ind_cost_codes.ind_cost_code%TYPE;
81: g_period_end_date gl_period_statuses.end_date%TYPE;
82: g_period_start_date gl_period_statuses.end_date%TYPE;
83: g_exp_item_date gl_period_statuses.end_date%TYPE;
84: g_bdgt_entry_level_code varchar2(2) := 'L'; -- Lowest level task
85:
86:

Line 83: g_exp_item_date gl_period_statuses.end_date%TYPE;

79: g_project_id pa_projects_all.project_id%TYPE;
80: g_rate_name pa_ind_cost_codes.ind_cost_code%TYPE;
81: g_period_end_date gl_period_statuses.end_date%TYPE;
82: g_period_start_date gl_period_statuses.end_date%TYPE;
83: g_exp_item_date gl_period_statuses.end_date%TYPE;
84: g_bdgt_entry_level_code varchar2(2) := 'L'; -- Lowest level task
85:
86:
87: ------------------------------------------------------------------

Line 431: FROM gl_period_statuses gps

427: ,x_end_date
428: ,x_fiscal_year
429: ,x_quarter_num
430: ,x_period_num
431: FROM gl_period_statuses gps
432: ,pa_implementations pi
433: WHERE gps.period_name = p_gl_period
434: AND gps.application_id = g_gl_app_id
435: AND gps.set_of_books_id = pi.set_of_books_id;

Line 469: FROM gl_period_statuses gps

465: SELECT gps.period_year
466: ,gps.period_num
467: INTO x_fiscal_year
468: ,x_period_num
469: FROM gl_period_statuses gps
470: ,pa_implementations pi
471: WHERE gps.application_id = g_gl_app_id
472: AND gps.set_of_books_id = pi.set_of_books_id
473: AND gps.adjustment_period_flag = 'N'

Line 476: FROM gl_period_statuses gps

472: AND gps.set_of_books_id = pi.set_of_books_id
473: AND gps.adjustment_period_flag = 'N'
474: AND gps.start_date =
475: (SELECT MIN(gps.start_date)
476: FROM gl_period_statuses gps
477: ,pa_implementations pi
478: WHERE gps.application_id = g_gl_app_id
479: AND gps.set_of_books_id = pi.set_of_books_id
480: AND gps.adjustment_period_flag = 'N'

Line 483: FROM gl_period_statuses gps

479: AND gps.set_of_books_id = pi.set_of_books_id
480: AND gps.adjustment_period_flag = 'N'
481: AND gps.start_date >
482: (SELECT gps.end_date
483: FROM gl_period_statuses gps
484: ,pa_implementations pi
485: WHERE gps.application_id = g_gl_app_id
486: AND gps.set_of_books_id = pi.set_of_books_id
487: AND gps.period_year = p_fiscal_year

Line 520: FROM gl_period_statuses gps

516: BEGIN
517: -- Test if the cdl row has already been placed in service
518: SELECT COUNT(*)
519: INTO ln_count
520: FROM gl_period_statuses gps
521: ,pa_implementations pi
522: WHERE gps.period_year = p_fiscal_year
523: AND gps.application_id = g_gl_app_id
524: AND gps.set_of_books_id = pi.set_of_books_id

Line 1298: ld_period_start_date gl_period_statuses.start_date%TYPE;

1294:
1295: ln_org_id pa_implementations_all.org_id%TYPE;
1296: lv_currency_code gl_sets_of_books.currency_code%TYPE;
1297:
1298: ld_period_start_date gl_period_statuses.start_date%TYPE;
1299:
1300: ln_fiscal_year gl_period_statuses.period_year%TYPE;
1301: ln_quarter_num gl_period_statuses.quarter_num%TYPE;
1302: ln_period_num gl_period_statuses.period_num%TYPE;

Line 1300: ln_fiscal_year gl_period_statuses.period_year%TYPE;

1296: lv_currency_code gl_sets_of_books.currency_code%TYPE;
1297:
1298: ld_period_start_date gl_period_statuses.start_date%TYPE;
1299:
1300: ln_fiscal_year gl_period_statuses.period_year%TYPE;
1301: ln_quarter_num gl_period_statuses.quarter_num%TYPE;
1302: ln_period_num gl_period_statuses.period_num%TYPE;
1303:
1304: ln_curr_period_mult NUMBER;

Line 1301: ln_quarter_num gl_period_statuses.quarter_num%TYPE;

1297:
1298: ld_period_start_date gl_period_statuses.start_date%TYPE;
1299:
1300: ln_fiscal_year gl_period_statuses.period_year%TYPE;
1301: ln_quarter_num gl_period_statuses.quarter_num%TYPE;
1302: ln_period_num gl_period_statuses.period_num%TYPE;
1303:
1304: ln_curr_period_mult NUMBER;
1305: ln_period_mult NUMBER;

Line 1302: ln_period_num gl_period_statuses.period_num%TYPE;

1298: ld_period_start_date gl_period_statuses.start_date%TYPE;
1299:
1300: ln_fiscal_year gl_period_statuses.period_year%TYPE;
1301: ln_quarter_num gl_period_statuses.quarter_num%TYPE;
1302: ln_period_num gl_period_statuses.period_num%TYPE;
1303:
1304: ln_curr_period_mult NUMBER;
1305: ln_period_mult NUMBER;
1306: ln_rate_mult pa_ind_cost_multipliers.multiplier%TYPE;

Line 2974: ld_period_start_date gl_period_statuses.start_date%TYPE;

2970:
2971:
2972: -- Working storage variables
2973:
2974: ld_period_start_date gl_period_statuses.start_date%TYPE;
2975: ld_period_end_date gl_period_statuses.end_date%TYPE;
2976: ln_period_num gl_period_statuses.period_num%TYPE;
2977: ln_fiscal_year gl_period_statuses.period_year%TYPE;
2978: ln_quarter_num gl_period_statuses.quarter_num%TYPE;

Line 2975: ld_period_end_date gl_period_statuses.end_date%TYPE;

2971:
2972: -- Working storage variables
2973:
2974: ld_period_start_date gl_period_statuses.start_date%TYPE;
2975: ld_period_end_date gl_period_statuses.end_date%TYPE;
2976: ln_period_num gl_period_statuses.period_num%TYPE;
2977: ln_fiscal_year gl_period_statuses.period_year%TYPE;
2978: ln_quarter_num gl_period_statuses.quarter_num%TYPE;
2979:

Line 2976: ln_period_num gl_period_statuses.period_num%TYPE;

2972: -- Working storage variables
2973:
2974: ld_period_start_date gl_period_statuses.start_date%TYPE;
2975: ld_period_end_date gl_period_statuses.end_date%TYPE;
2976: ln_period_num gl_period_statuses.period_num%TYPE;
2977: ln_fiscal_year gl_period_statuses.period_year%TYPE;
2978: ln_quarter_num gl_period_statuses.quarter_num%TYPE;
2979:
2980: ln_rows_deleted NUMBER;

Line 2977: ln_fiscal_year gl_period_statuses.period_year%TYPE;

2973:
2974: ld_period_start_date gl_period_statuses.start_date%TYPE;
2975: ld_period_end_date gl_period_statuses.end_date%TYPE;
2976: ln_period_num gl_period_statuses.period_num%TYPE;
2977: ln_fiscal_year gl_period_statuses.period_year%TYPE;
2978: ln_quarter_num gl_period_statuses.quarter_num%TYPE;
2979:
2980: ln_rows_deleted NUMBER;
2981: ln_tot_rows_deleted NUMBER;

Line 2978: ln_quarter_num gl_period_statuses.quarter_num%TYPE;

2974: ld_period_start_date gl_period_statuses.start_date%TYPE;
2975: ld_period_end_date gl_period_statuses.end_date%TYPE;
2976: ln_period_num gl_period_statuses.period_num%TYPE;
2977: ln_fiscal_year gl_period_statuses.period_year%TYPE;
2978: ln_quarter_num gl_period_statuses.quarter_num%TYPE;
2979:
2980: ln_rows_deleted NUMBER;
2981: ln_tot_rows_deleted NUMBER;
2982: