APPS.PA_PROJECTS_PKG dependencies on PA_PROJECTS

Line 1: PACKAGE BODY PA_PROJECTS_PKG as

1: PACKAGE BODY PA_PROJECTS_PKG as
2: /* $Header: PAXPROJB.pls 120.4.12010000.2 2008/10/27 16:56:19 atshukla ship $ */
3:
4: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2, -- 4537865
5: X_Project_Id IN OUT NOCOPY NUMBER, -- 4537865

Line 192: CURSOR C IS SELECT rowid FROM pa_projects

188: --sunkalya:federal Bug#5511353
189: ,x_ar_rec_notify_flag VARCHAR2 -- 7508661 : EnC
190: ,x_auto_release_pwp_inv VARCHAR2 -- 7508661 : EnC
191: ) IS
192: CURSOR C IS SELECT rowid FROM pa_projects
193: WHERE project_id = X_Project_Id;
194: CURSOR C2 IS SELECT pa_projects_s.nextval FROM sys.dual;
195:
196: l_return_status VARCHAR2(1);

Line 194: CURSOR C2 IS SELECT pa_projects_s.nextval FROM sys.dual;

190: ,x_auto_release_pwp_inv VARCHAR2 -- 7508661 : EnC
191: ) IS
192: CURSOR C IS SELECT rowid FROM pa_projects
193: WHERE project_id = X_Project_Id;
194: CURSOR C2 IS SELECT pa_projects_s.nextval FROM sys.dual;
195:
196: l_return_status VARCHAR2(1);
197: BEGIN
198: if (X_Project_Id is NULL) then

Line 204: INSERT INTO pa_projects(

200: FETCH C2 INTO X_Project_Id;
201: CLOSE C2;
202: end if;
203:
204: INSERT INTO pa_projects(
205: project_id,
206: org_id, --R12: Bug 4363092
207: name,
208: long_name,

Line 591: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_PKG'

587: EXCEPTION -- 4537865 Included Exception Block
588: WHEN OTHERS THEN
589: X_Rowid := NULL ;
590: X_Project_Id := NULL;
591: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_PKG'
592: ,p_procedure_name => 'Insert_Row'
593: ,p_error_text => SUBSTRB(SQLERRM,1,240));
594: RAISE;
595: END Insert_Row;

Line 777: FROM pa_projects

773: ,x_auto_release_pwp_inv VARCHAR2 -- 7508661 : EnC
774: ) IS
775: CURSOR C IS
776: SELECT *
777: FROM pa_projects
778: WHERE rowid = X_Rowid
779: FOR UPDATE of Project_Id NOWAIT;
780: Recinfo C%ROWTYPE;
781:

Line 1372: END PA_PROJECTS_PKG;

1368: end if;
1369: END Lock_Row;
1370:
1371:
1372: END PA_PROJECTS_PKG;