DBA Data[Home] [Help]

APPS.GMS_AWARD_PVT dependencies on PA_PROJECT_PUB

Line 2172: L_Project_IN_REC PA_PROJECT_PUB.PROJECT_IN_REC_TYPE;

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

Line 2173: L_Project_OUT_REC PA_PROJECT_PUB.PROJECT_OUT_REC_TYPE;

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

Line 2174: L_Key_Members_IN_REC PA_PROJECT_PUB.PROJECT_ROLE_REC_TYPE;

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

Line 2175: L_Tasks_IN_REC PA_PROJECT_PUB.TASK_IN_REC_TYPE;

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

Line 2177: L_Key_Members_IN_TBL PA_PROJECT_PUB.PROJECT_ROLE_TBL_TYPE;

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

Line 2178: L_Class_Categories_IN_TBL PA_PROJECT_PUB.CLASS_CATEGORY_TBL_TYPE;

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

Line 2179: L_Tasks_In_TBL PA_PROJECT_PUB.TASK_IN_TBL_TYPE;

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

Line 2180: L_Tasks_Out_TBL PA_PROJECT_PUB.TASK_OUT_TBL_TYPE;

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

Line 2186: L_Deliverable_IN_TBL PA_PROJECT_PUB.DELIVERABLE_IN_TBL_TYPE;

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

Line 2187: L_Deliverable_Action_IN_TBL PA_PROJECT_PUB.ACTION_IN_TBL_TYPE;

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

Line 2190: --L_Deliverable_OUT_TBL PA_PROJECT_PUB.DELIVERABLE_OUT_TBL_TYPE;

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

Line 2191: --L_Deliverable_Action_OUT_TBL PA_PROJECT_PUB.ACTION_OUT_TBL_TYPE;

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

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

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