APPS.PA_BUDGET_VERSIONS_PKG dependencies on PA_BUDGET_VERSIONS

Line 1: PACKAGE BODY PA_BUDGET_VERSIONS_PKG as

1: PACKAGE BODY PA_BUDGET_VERSIONS_PKG as
2: /* $Header: PAXBUBVB.pls 120.1.12020000.2 2012/07/19 10:02:34 admarath ship $ */
3:
4:
5: --Name: Insert_Row

Line 88: CURSOR C IS SELECT rowid FROM pa_budget_versions

84:
85: IS
86:
87:
88: CURSOR C IS SELECT rowid FROM pa_budget_versions
89: WHERE budget_version_id = X_Budget_Version_Id;
90:
91: CURSOR C2 IS SELECT pa_budget_versions_s.nextval FROM sys.dual;
92:

Line 91: CURSOR C2 IS SELECT pa_budget_versions_s.nextval FROM sys.dual;

87:
88: CURSOR C IS SELECT rowid FROM pa_budget_versions
89: WHERE budget_version_id = X_Budget_Version_Id;
90:
91: CURSOR C2 IS SELECT pa_budget_versions_s.nextval FROM sys.dual;
92:
93: nc_Rowid VARCHAR2(30);
94: nc_Budget_Version_Id NUMBER;
95:

Line 107: INSERT INTO pa_budget_versions(

103: FETCH C2 INTO X_Budget_Version_Id;
104: CLOSE C2;
105: end if;
106:
107: INSERT INTO pa_budget_versions(
108: budget_version_id,
109: project_id,
110: budget_type_code,
111: version_number,

Line 275: FROM pa_budget_versions

271: X_First_Budget_Period VARCHAR2
272: ) IS
273: CURSOR C IS
274: SELECT *
275: FROM pa_budget_versions
276: WHERE rowid = X_Rowid
277: FOR UPDATE of Budget_Version_Id NOWAIT;
278: Recinfo C%ROWTYPE;
279:

Line 474: UPDATE pa_budget_versions

470: x_plan_run_date DATE DEFAULT NULL,
471: x_plan_processing_code VARCHAR2 DEFAULT NULL
472: ) IS
473: BEGIN
474: UPDATE pa_budget_versions
475: SET
476: budget_version_id = X_Budget_Version_Id,
477: project_id = X_Project_Id,
478: budget_type_code = X_Budget_Type_Code,

Line 533: DELETE FROM pa_budget_versions

529: END Update_Row;
530:
531: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
532: BEGIN
533: DELETE FROM pa_budget_versions
534: WHERE rowid = X_Rowid;
535:
536: if (SQL%NOTFOUND) then
537: Raise NO_DATA_FOUND;

Line 542: END PA_BUDGET_VERSIONS_PKG;

538: end if;
539: END Delete_Row;
540:
541:
542: END PA_BUDGET_VERSIONS_PKG;