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_UTILS2 dependencies on PA_BUDGET_LINES

Line 962: * This api validates the currency conversion parameters and updates the pa_budget_lines table

958:
959: END GetPeriodMask;
960:
961: /* THIS API is called from EditBudgetLineDetails.java page
962: * This api validates the currency conversion parameters and updates the pa_budget_lines table
963: * if there is any changes in the currency conversion attributes, it calls calculate api ()
964: * THIS API SHOULD NOT BE CALLED FROM ANY OTHER SOURCE, IF SO ALL THE PARAMETER VALUES MUST BE PASSED
965: * This api will not default any parameter values. This is similar to a table handler
966: */

Line 1038: FROM pa_budget_lines

1034: ,projfunc_rev_rate_type
1035: ,projfunc_rev_rate_date
1036: ,projfunc_rev_rate_date_type
1037: ,projfunc_rev_exchange_rate
1038: FROM pa_budget_lines
1039: Where budget_line_id = p_budget_line_id;
1040:
1041: Cursor projDetails IS
1042: Select bv.project_id

Line 1367: UPDATE pa_budget_lines bl

1363: p_start_date is NOT NULL and
1364: p_end_date is NOT NULL ) Then
1365: l_stage := 'Updateing the budget lines with currency attributes';
1366: print_msg(g_debug_flag,l_proc_name,l_stage);
1367: UPDATE pa_budget_lines bl
1368: SET bl.description = nvl(p_description,bl.description)
1369: ,bl.change_reason_code = nvl(p_change_reason_code,bl.change_reason_code)
1370: ,bl.attribute_category = nvl(p_attribute_category,bl.attribute_category)
1371: ,bl.attribute1 = nvl(p_attribute1,bl.attribute1)

Line 1704: FROM pa_budget_lines bl

1700: SELECT 'Y'
1701: FROM DUAL
1702: WHERE EXISTS
1703: (SELECT null
1704: FROM pa_budget_lines bl
1705: WHERE bl.budget_version_id = l_budget_version_id
1706: AND (bl.cost_rejection_code is NOT NULL
1707: OR bl.burden_rejection_code is NOT NULL
1708: OR bl.revenue_rejection_code is NOT NULL

Line 1718: FROM pa_budget_lines bl

1714: SELECT 'Y'
1715: FROM DUAL
1716: WHERE EXISTS
1717: (SELECT null
1718: FROM pa_budget_lines bl
1719: ,pa_resource_assignments ra
1720: WHERE ra.budget_version_id = l_budget_version_id
1721: and ra.wbs_element_version_id = p_task_str_version_id
1722: and bl.resource_assignment_id = ra.resource_assignment_id

Line 1735: FROM pa_budget_lines bl

1731: SELECT 'Y'
1732: FROM DUAL
1733: WHERE EXISTS
1734: (SELECT null
1735: FROM pa_budget_lines bl
1736: ,pa_resource_assignments ra
1737: WHERE ra.budget_version_id = l_budget_version_id
1738: and ra.wbs_element_version_id = p_task_str_version_id
1739: and bl.resource_assignment_id = ra.resource_assignment_id

Line 1752: FROM pa_budget_lines bl

1748: SELECT 'Y'
1749: FROM DUAL
1750: WHERE EXISTS
1751: (SELECT null
1752: FROM pa_budget_lines bl
1753: ,pa_resource_assignments ra
1754: WHERE ra.budget_version_id = l_budget_version_id
1755: and ra.wbs_element_version_id = p_task_str_version_id
1756: and bl.resource_assignment_id = ra.resource_assignment_id

Line 1769: FROM pa_budget_lines bl

1765: SELECT 'Y'
1766: FROM DUAL
1767: WHERE EXISTS
1768: (SELECT null
1769: FROM pa_budget_lines bl
1770: ,pa_resource_assignments ra
1771: WHERE ra.budget_version_id = l_budget_version_id
1772: and ra.wbs_element_version_id = p_task_str_version_id
1773: and bl.resource_assignment_id = ra.resource_assignment_id

Line 1786: FROM pa_budget_lines bl

1782: SELECT 'Y'
1783: FROM DUAL
1784: WHERE EXISTS
1785: (SELECT null
1786: FROM pa_budget_lines bl
1787: ,pa_resource_assignments ra
1788: WHERE ra.budget_version_id = l_budget_version_id
1789: and ra.wbs_element_version_id = p_task_str_version_id
1790: and bl.resource_assignment_id = ra.resource_assignment_id

Line 1933: from pa_budget_lines bl

1929: select bv.etc_start_date
1930: from pa_budget_versions bv
1931: where bv.budget_version_id = p_budget_version_id
1932: and Exists ( select null
1933: from pa_budget_lines bl
1934: where bl.resource_assignment_id = p_resource_assignment_id
1935: and bl.budget_version_id = bv.budget_version_id
1936: ) ;
1937:

Line 1941: from pa_budget_lines bl

1937:
1938: cursor cur_se_date IS
1939: select MIN(bl.start_date)
1940: ,MAX(bl.end_date)
1941: from pa_budget_lines bl
1942: where bl.resource_assignment_id = p_resource_assignment_id
1943: and bl.budget_version_id = p_budget_version_id
1944: and (bl.init_quantity is NOT NULL
1945: or bl.txn_init_raw_cost is NOT NULL

Line 3617: (p_source_fin_plan_version_id IN PA_BUDGET_LINES.budget_version_id%TYPE

3613: /** MRC Elimination: Moved this procedure from pa_mrc_finplan pkg to utils as
3614: * package itself is dropped
3615: */
3616: PROCEDURE POPULATE_BL_MAP_TMP
3617: (p_source_fin_plan_version_id IN PA_BUDGET_LINES.budget_version_id%TYPE
3618: ,x_return_status OUT NOCOPY VARCHAR2
3619: ,x_msg_count OUT NOCOPY NUMBER
3620: ,x_msg_data OUT NOCOPY VARCHAR2
3621: ) IS

Line 3626: ,pa_budget_lines_s.nextval

3622:
3623: CURSOR C_TMP_BUDGET_LINE IS
3624: SELECT
3625: budget_line_id
3626: ,pa_budget_lines_s.nextval
3627:
3628: FROM
3629: pa_budget_lines
3630: WHERE

Line 3629: pa_budget_lines

3625: budget_line_id
3626: ,pa_budget_lines_s.nextval
3627:
3628: FROM
3629: pa_budget_lines
3630: WHERE
3631: budget_version_id = p_source_fin_plan_version_id ;
3632:
3633:

Line 3645: pa_budget_lines.BUDGET_LINE_ID%TYPE INDEX BY BINARY_INTEGER ;

3641: g_module_name VARCHAR2(30) := 'pa.plsql.PA_FIN_PLAN_UTILS2';
3642: g_plsql_max_array_size NUMBER := 200 ;
3643:
3644: TYPE l_budget_line_id_tbl_typ IS TABLE OF
3645: pa_budget_lines.BUDGET_LINE_ID%TYPE INDEX BY BINARY_INTEGER ;
3646:
3647: l_source_budget_line_id_tbl l_budget_line_id_tbl_typ ;
3648: l_target_budget_line_id_tbl l_budget_line_id_tbl_typ ;
3649: