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.PQH_COMMITMENT_POSTING dependencies on PQH_BUDGET_PERIODS

Line 136: (p_budget_period_id IN pqh_budget_periods.budget_period_id%TYPE,

132: --
133: END;
134:
135: Procedure get_period_dates
136: (p_budget_period_id IN pqh_budget_periods.budget_period_id%TYPE,
137: p_period_start_date OUT NOCOPY date,
138: p_period_end_date OUT NOCOPY date) IS
139: --
140: Cursor csr_period is

Line 142: From pqh_budget_periods

138: p_period_end_date OUT NOCOPY date) IS
139: --
140: Cursor csr_period is
141: Select start_time_period_id,end_time_period_id
142: From pqh_budget_periods
143: Where budget_period_id = p_budget_period_id;
144: --
145: Cursor csr_period_date(p_time_period_id in number) is
146: Select start_date,end_date

Line 150: l_start_time_period_id pqh_budget_periods.start_time_period_id%TYPE;

146: Select start_date,end_date
147: From per_time_periods
148: Where time_period_id = p_time_period_id;
149: --
150: l_start_time_period_id pqh_budget_periods.start_time_period_id%TYPE;
151: l_end_time_period_id pqh_budget_periods.end_time_period_id%TYPE;
152: --
153: l_start_date date;
154: l_end_date date;

Line 151: l_end_time_period_id pqh_budget_periods.end_time_period_id%TYPE;

147: From per_time_periods
148: Where time_period_id = p_time_period_id;
149: --
150: l_start_time_period_id pqh_budget_periods.start_time_period_id%TYPE;
151: l_end_time_period_id pqh_budget_periods.end_time_period_id%TYPE;
152: --
153: l_start_date date;
154: l_end_date date;
155: --

Line 988: p_budget_period_id IN pqh_budget_periods.budget_period_id%TYPE,

984: --
985: ---------------------------------------------------------------------------------------------------
986: --
987: Procedure build_budget_set_ratio_table(
988: p_budget_period_id IN pqh_budget_periods.budget_period_id%TYPE,
989: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
990: p_budget_unit_seq IN number,
991: p_budget_ratio_table IN OUT NOCOPY t_ratio_table) IS
992: --

Line 1271: PROCEDURE build_period_commitment (p_budget_period_id IN pqh_budget_periods.budget_period_id%TYPE,

1267: End update_distribution_table;
1268: --
1269: --------------------------------------------------------------------------------------------------------------
1270: --
1271: PROCEDURE build_period_commitment (p_budget_period_id IN pqh_budget_periods.budget_period_id%TYPE,
1272: p_distribution_table IN t_distribution_table,
1273: p_budget_unit_seq IN number) IS
1274: --
1275: cnt NUMBER(10);

Line 1395: p_budget_period_id IN pqh_budget_periods.budget_period_id%type,

1391: p_position_id IN pqh_budget_details.position_id%type,
1392: p_organization_id IN pqh_budget_details.organization_id%type,
1393: p_job_id IN pqh_budget_details.job_id%type,
1394: p_grade_id IN pqh_budget_details.grade_id%type,
1395: p_budget_period_id IN pqh_budget_periods.budget_period_id%type,
1396: p_budget_unit_seq IN number,
1397: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%type,
1398: p_effective_date IN varchar2) IS
1399: --

Line 1503: p_budget_period_id IN pqh_budget_periods.budget_period_id%type,

1499: p_position_id IN pqh_budget_details.position_id%type,
1500: p_organization_id IN pqh_budget_details.organization_id%type,
1501: p_job_id IN pqh_budget_details.job_id%type,
1502: p_grade_id IN pqh_budget_details.grade_id%type,
1503: p_budget_period_id IN pqh_budget_periods.budget_period_id%type,
1504: p_budget_unit_seq IN number,
1505: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%type,
1506: p_effective_date IN varchar2) IS
1507: --

Line 1651: l_budget_period_id pqh_budget_periods.budget_period_id%TYPE;

1647: p_effective_date IN varchar2) IS
1648: --
1649: -- local variables
1650: --
1651: l_budget_period_id pqh_budget_periods.budget_period_id%TYPE;
1652: l_budget_set_id pqh_budget_sets.budget_set_id%TYPE;
1653: l_budget_element_id pqh_budget_elements.budget_element_id%TYPE;
1654: l_element_type_id pqh_budget_elements.element_type_id%TYPE;
1655: l_el_distribution_percentage pqh_budget_fund_srcs.distribution_percentage%TYPE;

Line 1690: pqh_budget_sets bst, pqh_budget_periods bpr

1686: bfs.award_id,
1687: bfs.expenditure_type,
1688: bfs.organization_id
1689: FROM pqh_budget_fund_srcs bfs, pqh_budget_elements bel,
1690: pqh_budget_sets bst, pqh_budget_periods bpr
1691: WHERE bpr.budget_detail_id = p_budget_detail_id
1692: AND bpr.budget_period_id = bst.budget_period_id
1693: AND bst.budget_set_id = bel.budget_set_id
1694: AND bel.budget_element_id = bfs.budget_element_id

Line 1700: From pqh_budget_periods bpr

1696: bfs.task_id,bfs.award_id,bfs.expenditure_type, bfs.organization_id;
1697: --
1698: Cursor csr_bdgt_periods is
1699: Select bpr.budget_period_id
1700: From pqh_budget_periods bpr
1701: Where bpr.budget_detail_id = p_budget_detail_id;
1702: --
1703: l_proc varchar2(72) := g_package||'populate_period_commitment_tab';
1704: --

Line 1932: p_budget_period_id IN pqh_budget_periods.budget_period_id%TYPE,

1928: -------------------------------------------------------------------------------------------
1929: --
1930: PROCEDURE get_gl_period
1931: (
1932: p_budget_period_id IN pqh_budget_periods.budget_period_id%TYPE,
1933: p_set_of_books_id IN pqh_budgets.gl_set_of_books_id%type,
1934: p_gl_period_statuses_rec OUT NOCOPY gl_period_statuses%ROWTYPE
1935: ) IS
1936: --

Line 1949: FROM pqh_budget_periods

1945: CURSOR csr_time_period IS
1946: SELECT start_date
1947: FROM per_time_periods
1948: WHERE time_period_id = ( SELECT start_time_period_id
1949: FROM pqh_budget_periods
1950: WHERE budget_period_id = p_budget_period_id );
1951: --
1952: CURSOR csr_period_name( p_start_date IN DATE ) IS
1953: SELECT *