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_BUDGET_WF dependencies on PA_BUDGET_VERSIONS

Line 233: -- p_pm_product_code - The PM vendor's product code stored in pa_budget_versions.

229: -- Budgets model.
230: --
231: -- For the new FP model, the p_budget_type_code will be NULL!
232: --
233: -- p_pm_product_code - The PM vendor's product code stored in pa_budget_versions.
234: --
235: -- OUT Parameters
236: -- p_result - 'T' or 'F' (True/False)
237: -- p_err_code - Standard error code: 0, Success; x < 0, Unexpected Error;

Line 348: FROM pa_budget_versions

344:
345: CURSOR l_lock_budget_csr (p_draft_version_id NUMBER)
346: IS
347: SELECT 'x'
348: FROM pa_budget_versions
349: WHERE budget_version_id = p_draft_version_id
350: FOR UPDATE NOWAIT;
351:
352: -- Local Variables

Line 439: UPDATE pa_budget_versions

435: CLOSE l_lock_budget_csr;
436:
437: -- UPDATE Draft Budget Version
438:
439: UPDATE pa_budget_versions
440: SET budget_status_code = 'W'
441: , WF_status_code = 'REJECTED'
442: WHERE budget_version_id = l_draft_version_id;
443:

Line 549: l_version_type pa_budget_versions.version_type%TYPE := NULL;

545: l_api_version_number NUMBER := G_api_version_number;
546:
547:
548: l_fin_plan_type_id NUMBER := NULL;
549: l_version_type pa_budget_versions.version_type%TYPE := NULL;
550: l_draft_version_id NUMBER := NULL;
551:
552: l_approver_role varchar2(50); -- Bug 6994708
553:

Line 796: l_mark_as_original pa_budget_versions.current_original_flag%TYPE;

792:
793: l_warnings_only_flag VARCHAR2(1);
794: l_warnings_only VARCHAR2(1) := 'Y';
795: l_err_msg_count NUMBER := 0;
796: l_mark_as_original pa_budget_versions.current_original_flag%TYPE;
797: l_resource_list_id NUMBER;
798: l_project_type_class_code pa_project_types.project_type_class_code%TYPE;
799:
800: l_msg_count NUMBER;

Line 814: l_version_type pa_budget_versions.version_type%TYPE := NULL;

810:
811: l_bgt_intg_flag VARCHAR2(1) := NULL;
812:
813: l_fin_plan_type_id NUMBER := NULL;
814: l_version_type pa_budget_versions.version_type%TYPE := NULL;
815: l_draft_version_id NUMBER := NULL;
816:
817:
818: --

Line 1149: FROM pa_budget_versions

1145: , p_budget_type_code VARCHAR2 )
1146:
1147: IS
1148: SELECT MAX(budget_version_id)
1149: FROM pa_budget_versions
1150: WHERE project_id = p_project_id
1151: AND budget_type_code = p_budget_type_code
1152: AND budget_status_code = 'B';
1153:

Line 1164: FROM pa_budget_versions

1160: , p_version_type VARCHAR2)
1161: IS
1162: SELECT budget_version_id
1163: , RECORD_VERSION_NUMBER
1164: FROM pa_budget_versions
1165: WHERE project_id = p_project_id
1166: AND current_flag = 'Y'
1167: and fin_plan_type_id = p_fin_plan_type_id
1168: and version_type = p_version_type;

Line 1174: FROM pa_budget_versions

1170:
1171: CURSOR l_fp_draft_csr ( p_draft_version_id NUMBER)
1172: IS
1173: SELECT RECORD_VERSION_NUMBER
1174: FROM pa_budget_versions
1175: WHERE budget_version_id = p_draft_version_id;
1176:
1177: CURSOR l_get_baseliner_userid_csr( p_item_key VARCHAR2)
1178: IS

Line 1223: l_mark_as_original pa_budget_versions.current_original_flag%TYPE;

1219:
1220: l_warnings_only_flag VARCHAR2(1);
1221: l_warnings_only VARCHAR2(1) := 'Y';
1222: l_err_msg_count NUMBER;
1223: l_mark_as_original pa_budget_versions.current_original_flag%TYPE;
1224: l_resource_list_id NUMBER;
1225: l_project_type_class_code pa_project_types.project_type_class_code%TYPE;
1226:
1227: l_err_code NUMBER := 0;

Line 1235: l_version_type pa_budget_versions.version_type%TYPE := NULL;

1231: l_bgt_intg_flag VARCHAR2(1) := NULL;
1232: l_fck_req_flag VARCHAR2(1) := NULL;
1233:
1234: l_fin_plan_type_id NUMBER := NULL;
1235: l_version_type pa_budget_versions.version_type%TYPE := NULL;
1236: l_draft_version_id NUMBER := NULL;
1237: l_baselined_record_number NUMBER := NULL;
1238: l_draft_record_number NUMBER := NULL;
1239: l_fc_version_created_flag VARCHAR2(1);

Line 1570: UPDATE pa_budget_versions

1566:
1567: /* 4995380: Added code to set the WF status to 'REJECTED'
1568: so that the changes can be done and the Baseline can be submitted
1569: once again, if Baseline fails. */
1570: UPDATE pa_budget_versions
1571: SET budget_status_code = 'W'
1572: , wf_status_code = 'REJECTED'
1573: WHERE budget_version_id = l_draft_version_id;
1574:

Line 1635: UPDATE pa_budget_versions SET

1631: -- Since baseline will fail more often with new R12 functionality, Need to
1632: -- properly populate draft version semaphores.
1633: --
1634: -- Update WF Status on Draft Budget Version
1635: UPDATE pa_budget_versions SET
1636: budget_status_code = 'W'
1637: ,WF_status_code = 'REJECTED'
1638: WHERE budget_version_id = l_draft_version_id;
1639: -- -------------------------------------------------------------

Line 1702: UPDATE pa_budget_versions SET

1698: -- After Successfully calling BASELINE, Set The Budget_Status_Code
1699: -- Back To 'W' (Working) and wf_status_code to NULL.
1700: --
1701:
1702: UPDATE pa_budget_versions SET
1703: budget_status_code = 'W'
1704: , wf_status_code = NULL
1705: WHERE budget_version_id = l_draft_version_id;
1706:

Line 1720: UPDATE pa_budget_versions

1716: ELSE
1717: /* 4995380: Added code to set the WF status to 'REJECTED'
1718: so that the changes can be done and the Baseline can be submitted
1719: once again, if there are any errors and l_warnings_only = 'N'. */
1720: UPDATE pa_budget_versions
1721: SET budget_status_code = 'W'
1722: , wf_status_code = 'REJECTED'
1723: WHERE budget_version_id = l_draft_version_id;
1724: resultout := wf_engine.eng_completed||':'||'F';

Line 1731: UPDATE pa_budget_versions SET

1727: EXCEPTION
1728:
1729: WHEN FND_API.G_EXC_ERROR
1730: THEN
1731: UPDATE pa_budget_versions SET
1732: budget_status_code = 'W'
1733: , wf_status_code = NULL
1734: WHERE budget_version_id = l_draft_version_id;
1735: WF_CORE.CONTEXT('PA_BUDGET_WF','BASELINE_BUDGET', itemtype, itemkey, to_char(actid), funcmode);

Line 1740: UPDATE pa_budget_versions SET

1736: RAISE;
1737:
1738: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1739: THEN
1740: UPDATE pa_budget_versions SET
1741: budget_status_code = 'W'
1742: , wf_status_code = NULL
1743: WHERE budget_version_id = l_draft_version_id;
1744: WF_CORE.CONTEXT('PA_BUDGET_WF','BASELINE_BUDGET', itemtype, itemkey, to_char(actid), funcmode);

Line 1748: UPDATE pa_budget_versions SET

1744: WF_CORE.CONTEXT('PA_BUDGET_WF','BASELINE_BUDGET', itemtype, itemkey, to_char(actid), funcmode);
1745: RAISE;
1746:
1747: WHEN OTHERS THEN
1748: UPDATE pa_budget_versions SET
1749: budget_status_code = 'W'
1750: , wf_status_code = NULL
1751: WHERE budget_version_id = l_draft_version_id;
1752: WF_CORE.CONTEXT('PA_BUDGET_WF','BASELINE_BUDGET', itemtype, itemkey, to_char(actid), funcmode);