APPS.GMS_MULTI_FUNDING dependencies on PA_PROJECTS

Line 18: pa_projects a

14: BEGIN
15: SELECT a.project_id --Award_Project_Id
16: INTO Award_Id_Check
17: FROM gms_awards b,
18: pa_projects a
19: WHERE b.award_id = X_Award_Id
20: AND a.project_id = b.award_project_id;
21:
22: X_Err_Code := 'E';

Line 64: FROM PA_PROJECTS

60: BEGIN
61: BEGIN
62: SELECT 1
63: INTO Project_Check
64: FROM PA_PROJECTS
65: WHERE NAME = X_Award_Project_Name;
66:
67: IF Project_Check = 1 THEN
68: X_Err_Code := 'E';

Line 99: FROM PA_PROJECTS

95: WHEN NO_DATA_FOUND THEN
96: BEGIN
97: SELECT 1
98: INTO Project_Check
99: FROM PA_PROJECTS
100: WHERE SEGMENT1 = X_Award_Project_Number;
101:
102: IF Project_Check = 1 THEN
103: X_Err_Code := 'E';

Line 168: UPDATE PA_PROJECTS_ALL

164: X_Err_Code OUT NOCOPY VARCHAR2,
165: X_Err_Stage OUT NOCOPY VARCHAR2) IS
166: BEGIN
167: --dbms_output.put_line('Inside UPDATE Project Info');
168: UPDATE PA_PROJECTS_ALL
169: SET cost_ind_rate_sch_id = X_IDC_Schedule_Id,
170: cost_ind_sch_fixed_date = X_IDC_Schedule_Fixed_Date,
171: labor_invoice_format_id = X_Labor_Invoice_Format_Id,
172: non_labor_invoice_format_Id = X_Non_Labor_Invoice_Format_Id,

Line 228: l_awd_proj_temp pa_projects_all%rowtype;

224: ,X_Err_Code OUT NOCOPY VARCHAR2
225: ,X_Err_Stage OUT NOCOPY VARCHAR2) IS
226:
227: l_struct_exists varchar2(1) := 'N';
228: l_awd_proj_temp pa_projects_all%rowtype;
229: l_msg_count NUMBER;
230: l_msg_data VARCHAR2(2000);
231: l_return_status VARCHAR2(1);
232:

Line 235: Select * FROM pa_projects_all

231: l_return_status VARCHAR2(1);
232:
233:
234: CURSOR c_awd_proj_temp is
235: Select * FROM pa_projects_all
236: WHERE project_id = x_award_project_id;
237:
238: CURSOR c_struc_exists is
239: Select 'Y' FROM pa_proj_elements

Line 558: G_Stage := '(510:Select from pa_projects)';

554: --dbms_output.put_line('B Offset '||St_Billing_Offset);
555: END;
556: */
557:
558: G_Stage := '(510:Select from pa_projects)';
559: St_Billing_Offset := nvl(X_billing_offset,0) ;
560: /* Get X_Created_From_Project_Id */
561:
562: BEGIN

Line 571: FROM PA_PROJECTS

567: ** the code is modified.
568: **/
569: SELECT project_id
570: INTO X_Created_From_Project_Id
571: FROM PA_PROJECTS
572: WHERE project_type = 'AWARD_PROJECT'
573: AND template_flag = 'Y'
574: AND (segment1 = 'AWD_PROJ_'||x_default_org_id
575: OR segment1 = 'AWD_PROJ_-999');

Line 840: PA_PROJECTS a,

836: Store_Project_End_Date,
837: Store_Award_Id,
838: Store_Agreement_Id
839: FROM
840: PA_PROJECTS a,
841: GMS_AWARDS b,
842: GMS_INSTALLMENTS c
843: WHERE
844: c.installment_id = X_Installment_Id and

Line 3122: G_Stage := '(310:select from pa_projects)';

3118: SELECT TO_CHAR(NVL(org_id,-999))
3119: INTO x_default_org_id
3120: FROM gms_implementations;
3121:
3122: G_Stage := '(310:select from pa_projects)';
3123:
3124: --Get X_Created_From_Project_Id
3125: --Bug Fix 2447491:
3126: --After upgrading to multi org FROM non multi org, the award project

Line 3134: FROM PA_PROJECTS

3130: BEGIN
3131:
3132: SELECT project_id
3133: INTO X_Created_From_Project_Id
3134: FROM PA_PROJECTS
3135: WHERE project_type = 'AWARD_PROJECT'
3136: AND template_flag = 'Y'
3137: AND (segment1 = 'AWD_PROJ_'||x_default_org_id
3138: OR

Line 3721: G_Stage := '(600:SELECT PA_PROJECTS)';

3717:
3718: --This variable will help debugging when exception occurs
3719:
3720: BEGIN
3721: G_Stage := '(600:SELECT PA_PROJECTS)';
3722: BEGIN
3723: SELECT
3724: segment1
3725: INTO

Line 3728: PA_PROJECTS

3724: segment1
3725: INTO
3726: X_Awd_Proj_Number
3727: FROM
3728: PA_PROJECTS
3729: WHERE
3730: PROJECT_ID = X_Award_Project_Id;
3731: END;
3732: X_Product_Code := 'GMS';