DBA Data[Home] [Help]

APPS.GMS_AWARD_PVT dependencies on PA_PROJECT_PUB

Line 2171: L_Project_IN_REC PA_PROJECT_PUB.PROJECT_IN_REC_TYPE;

2167: PROCEDURE create_award_project ( X_return_status IN out NOCOPY varchar2,
2168: p_setup_award_project_id IN NUMBER) is
2169:
2170: L_Err_Code VARCHAR2(1) := NULL;
2171: L_Project_IN_REC PA_PROJECT_PUB.PROJECT_IN_REC_TYPE;
2172: L_Project_OUT_REC PA_PROJECT_PUB.PROJECT_OUT_REC_TYPE;
2173: L_Key_Members_IN_REC PA_PROJECT_PUB.PROJECT_ROLE_REC_TYPE;
2174: L_Tasks_IN_REC PA_PROJECT_PUB.TASK_IN_REC_TYPE;
2175:

Line 2172: L_Project_OUT_REC PA_PROJECT_PUB.PROJECT_OUT_REC_TYPE;

2168: p_setup_award_project_id IN NUMBER) is
2169:
2170: L_Err_Code VARCHAR2(1) := NULL;
2171: L_Project_IN_REC PA_PROJECT_PUB.PROJECT_IN_REC_TYPE;
2172: L_Project_OUT_REC PA_PROJECT_PUB.PROJECT_OUT_REC_TYPE;
2173: L_Key_Members_IN_REC PA_PROJECT_PUB.PROJECT_ROLE_REC_TYPE;
2174: L_Tasks_IN_REC PA_PROJECT_PUB.TASK_IN_REC_TYPE;
2175:
2176: L_Key_Members_IN_TBL PA_PROJECT_PUB.PROJECT_ROLE_TBL_TYPE;

Line 2173: L_Key_Members_IN_REC PA_PROJECT_PUB.PROJECT_ROLE_REC_TYPE;

2169:
2170: L_Err_Code VARCHAR2(1) := NULL;
2171: L_Project_IN_REC PA_PROJECT_PUB.PROJECT_IN_REC_TYPE;
2172: L_Project_OUT_REC PA_PROJECT_PUB.PROJECT_OUT_REC_TYPE;
2173: L_Key_Members_IN_REC PA_PROJECT_PUB.PROJECT_ROLE_REC_TYPE;
2174: L_Tasks_IN_REC PA_PROJECT_PUB.TASK_IN_REC_TYPE;
2175:
2176: L_Key_Members_IN_TBL PA_PROJECT_PUB.PROJECT_ROLE_TBL_TYPE;
2177: L_Class_Categories_IN_TBL PA_PROJECT_PUB.CLASS_CATEGORY_TBL_TYPE;

Line 2174: L_Tasks_IN_REC PA_PROJECT_PUB.TASK_IN_REC_TYPE;

2170: L_Err_Code VARCHAR2(1) := NULL;
2171: L_Project_IN_REC PA_PROJECT_PUB.PROJECT_IN_REC_TYPE;
2172: L_Project_OUT_REC PA_PROJECT_PUB.PROJECT_OUT_REC_TYPE;
2173: L_Key_Members_IN_REC PA_PROJECT_PUB.PROJECT_ROLE_REC_TYPE;
2174: L_Tasks_IN_REC PA_PROJECT_PUB.TASK_IN_REC_TYPE;
2175:
2176: L_Key_Members_IN_TBL PA_PROJECT_PUB.PROJECT_ROLE_TBL_TYPE;
2177: L_Class_Categories_IN_TBL PA_PROJECT_PUB.CLASS_CATEGORY_TBL_TYPE;
2178: L_Tasks_In_TBL PA_PROJECT_PUB.TASK_IN_TBL_TYPE;

Line 2176: L_Key_Members_IN_TBL PA_PROJECT_PUB.PROJECT_ROLE_TBL_TYPE;

2172: L_Project_OUT_REC PA_PROJECT_PUB.PROJECT_OUT_REC_TYPE;
2173: L_Key_Members_IN_REC PA_PROJECT_PUB.PROJECT_ROLE_REC_TYPE;
2174: L_Tasks_IN_REC PA_PROJECT_PUB.TASK_IN_REC_TYPE;
2175:
2176: L_Key_Members_IN_TBL PA_PROJECT_PUB.PROJECT_ROLE_TBL_TYPE;
2177: L_Class_Categories_IN_TBL PA_PROJECT_PUB.CLASS_CATEGORY_TBL_TYPE;
2178: L_Tasks_In_TBL PA_PROJECT_PUB.TASK_IN_TBL_TYPE;
2179: L_Tasks_Out_TBL PA_PROJECT_PUB.TASK_OUT_TBL_TYPE;
2180: L_default_org_id NUMBER ;

Line 2177: L_Class_Categories_IN_TBL PA_PROJECT_PUB.CLASS_CATEGORY_TBL_TYPE;

2173: L_Key_Members_IN_REC PA_PROJECT_PUB.PROJECT_ROLE_REC_TYPE;
2174: L_Tasks_IN_REC PA_PROJECT_PUB.TASK_IN_REC_TYPE;
2175:
2176: L_Key_Members_IN_TBL PA_PROJECT_PUB.PROJECT_ROLE_TBL_TYPE;
2177: L_Class_Categories_IN_TBL PA_PROJECT_PUB.CLASS_CATEGORY_TBL_TYPE;
2178: L_Tasks_In_TBL PA_PROJECT_PUB.TASK_IN_TBL_TYPE;
2179: L_Tasks_Out_TBL PA_PROJECT_PUB.TASK_OUT_TBL_TYPE;
2180: L_default_org_id NUMBER ;
2181:

Line 2178: L_Tasks_In_TBL PA_PROJECT_PUB.TASK_IN_TBL_TYPE;

2174: L_Tasks_IN_REC PA_PROJECT_PUB.TASK_IN_REC_TYPE;
2175:
2176: L_Key_Members_IN_TBL PA_PROJECT_PUB.PROJECT_ROLE_TBL_TYPE;
2177: L_Class_Categories_IN_TBL PA_PROJECT_PUB.CLASS_CATEGORY_TBL_TYPE;
2178: L_Tasks_In_TBL PA_PROJECT_PUB.TASK_IN_TBL_TYPE;
2179: L_Tasks_Out_TBL PA_PROJECT_PUB.TASK_OUT_TBL_TYPE;
2180: L_default_org_id NUMBER ;
2181:
2182: L_Workflow_Started varchar2(1) ;

Line 2179: L_Tasks_Out_TBL PA_PROJECT_PUB.TASK_OUT_TBL_TYPE;

2175:
2176: L_Key_Members_IN_TBL PA_PROJECT_PUB.PROJECT_ROLE_TBL_TYPE;
2177: L_Class_Categories_IN_TBL PA_PROJECT_PUB.CLASS_CATEGORY_TBL_TYPE;
2178: L_Tasks_In_TBL PA_PROJECT_PUB.TASK_IN_TBL_TYPE;
2179: L_Tasks_Out_TBL PA_PROJECT_PUB.TASK_OUT_TBL_TYPE;
2180: L_default_org_id NUMBER ;
2181:
2182: L_Workflow_Started varchar2(1) ;
2183:

Line 2185: L_Deliverable_IN_TBL PA_PROJECT_PUB.DELIVERABLE_IN_TBL_TYPE;

2181:
2182: L_Workflow_Started varchar2(1) ;
2183:
2184: /*** Bug 3576717 **/
2185: L_Deliverable_IN_TBL PA_PROJECT_PUB.DELIVERABLE_IN_TBL_TYPE;
2186: L_Deliverable_Action_IN_TBL PA_PROJECT_PUB.ACTION_IN_TBL_TYPE;
2187:
2188: -- BUG 3650374
2189: --L_Deliverable_OUT_TBL PA_PROJECT_PUB.DELIVERABLE_OUT_TBL_TYPE;

Line 2186: L_Deliverable_Action_IN_TBL PA_PROJECT_PUB.ACTION_IN_TBL_TYPE;

2182: L_Workflow_Started varchar2(1) ;
2183:
2184: /*** Bug 3576717 **/
2185: L_Deliverable_IN_TBL PA_PROJECT_PUB.DELIVERABLE_IN_TBL_TYPE;
2186: L_Deliverable_Action_IN_TBL PA_PROJECT_PUB.ACTION_IN_TBL_TYPE;
2187:
2188: -- BUG 3650374
2189: --L_Deliverable_OUT_TBL PA_PROJECT_PUB.DELIVERABLE_OUT_TBL_TYPE;
2190: --L_Deliverable_Action_OUT_TBL PA_PROJECT_PUB.ACTION_OUT_TBL_TYPE;

Line 2189: --L_Deliverable_OUT_TBL PA_PROJECT_PUB.DELIVERABLE_OUT_TBL_TYPE;

2185: L_Deliverable_IN_TBL PA_PROJECT_PUB.DELIVERABLE_IN_TBL_TYPE;
2186: L_Deliverable_Action_IN_TBL PA_PROJECT_PUB.ACTION_IN_TBL_TYPE;
2187:
2188: -- BUG 3650374
2189: --L_Deliverable_OUT_TBL PA_PROJECT_PUB.DELIVERABLE_OUT_TBL_TYPE;
2190: --L_Deliverable_Action_OUT_TBL PA_PROJECT_PUB.ACTION_OUT_TBL_TYPE;
2191:
2192: Begin
2193: -- Bug Fix for Bug 3076921

Line 2190: --L_Deliverable_Action_OUT_TBL PA_PROJECT_PUB.ACTION_OUT_TBL_TYPE;

2186: L_Deliverable_Action_IN_TBL PA_PROJECT_PUB.ACTION_IN_TBL_TYPE;
2187:
2188: -- BUG 3650374
2189: --L_Deliverable_OUT_TBL PA_PROJECT_PUB.DELIVERABLE_OUT_TBL_TYPE;
2190: --L_Deliverable_Action_OUT_TBL PA_PROJECT_PUB.ACTION_OUT_TBL_TYPE;
2191:
2192: Begin
2193: -- Bug Fix for Bug 3076921
2194: -- Need to verify and create a structure for the award project template.

Line 2258: PA_PROJECT_PUB.CREATE_PROJECT(p_api_version_number => 1.0,

2254:
2255: L_Tasks_In_TBL(1) := L_Tasks_IN_REC;
2256: L_Key_Members_IN_TBL(1) := L_Key_Members_IN_REC;
2257:
2258: PA_PROJECT_PUB.CREATE_PROJECT(p_api_version_number => 1.0,
2259: p_init_msg_list => 'F',
2260: p_msg_count => G_msg_count,
2261: p_msg_data => G_Msg_Data,
2262: p_return_status => X_Return_Status,