APPS.FPA_PROJECT_PVT dependencies on FPA_AW_PC_INFO_V

Line 101: FPA_AW_PC_INFO_V PC, PA_CLASS_CATEGORIES PCC,

97: SELECT
98: PC.PLANNING_CYCLE,
99: CC.CLASS_CODE_ID
100: FROM
101: FPA_AW_PC_INFO_V PC, PA_CLASS_CATEGORIES PCC,
102: PA_PROJECT_CLASSES PAC, PA_CLASS_CODES CC
103: WHERE
104: PC.PC_STATUS IN ('COLLECTING', 'ANALYSIS')
105: AND PC.PC_CATEGORY = PCC.CLASS_CATEGORY_ID

Line 117: l_current_pc_id FPA_AW_PC_INFO_V.PLANNING_CYCLE%TYPE := null;

113: l_portfolio_id FPA_AW_PORTF_HEADERS_V.PORTFOLIO%TYPE := null;
114: l_portfolio_org_id FPA_AW_PORTF_HEADERS_V.PORTFOLIO_ORGANIZATION%TYPE := null;
115: l_class_code PA_CLASS_CODES.CLASS_CODE%TYPE := null;
116: l_class_code_id PA_CLASS_CODES.CLASS_CODE_ID%TYPE := null;
117: l_current_pc_id FPA_AW_PC_INFO_V.PLANNING_CYCLE%TYPE := null;
118: l_project_org_id HR_ALL_ORGANIZATION_UNITS.ORGANIZATION_ID%TYPE := null;
119: l_pjp_org_version_id PER_ORG_STRUCTURE_VERSIONS.ORG_STRUCTURE_VERSION_ID%TYPE := null;
120: l_flag VARCHAR2(1) := null;
121:

Line 278: l_current_pc_id FPA_AW_PC_INFO_V.PLANNING_CYCLE%TYPE := null;

274: l_msg_count NUMBER;
275: l_msg_data VARCHAR2(4000);
276:
277: l_portfolio_id FPA_AW_PORTF_HEADERS_V.PORTFOLIO%TYPE := null;
278: l_current_pc_id FPA_AW_PC_INFO_V.PLANNING_CYCLE%TYPE := null;
279: l_class_code_id NUMBER;
280: l_valid_project VARCHAR2(1) := FND_API.G_FALSE;
281:
282: BEGIN

Line 529: l_current_pc_id FPA_AW_PC_INFO_V.PLANNING_CYCLE%TYPE := null;

525: l_msg_log VARCHAR2(2000) := null;
526: ----------------------------------------------------------------------------
527:
528: l_portfolio_id FPA_AW_PORTF_HEADERS_V.PORTFOLIO%TYPE := null;
529: l_current_pc_id FPA_AW_PC_INFO_V.PLANNING_CYCLE%TYPE := null;
530: l_class_code_id NUMBER;
531: l_valid_project VARCHAR2(1) := FND_API.G_FALSE;
532:
533: PROCEDURE save_project