APPS.PA_PROJECT_CORE1 dependencies on PA_PROJECT_COPY_OPTIONS_TMP

Line 398: FROM PA_PROJECT_COPY_OPTIONS_TMP

394:
395: --Following code added for selective copy project options. Tracking bug No 3464332
396: CURSOR cur_get_flag( p_flag_name IN VARCHAR2 ) IS
397: SELECT FLAG
398: FROM PA_PROJECT_COPY_OPTIONS_TMP
399: WHERE CONTEXT = p_flag_name ;
400:
401: l_pr_team_members_flag VARCHAR2(1);
402: l_pr_attachments_flag VARCHAR2(1);

Line 5026: FROM PA_PROJECT_COPY_OPTIONS_TMP

5022: --Added for Selective Copy Project. Tracking Bug No. 3464332
5023: --This cursor determines if atleast one WP version has been selected by the user
5024: CURSOR min_one_wp_version_sel IS
5025: SELECT distinct 'Y'
5026: FROM PA_PROJECT_COPY_OPTIONS_TMP
5027: WHERE CONTEXT = 'WORKPLAN'
5028: AND VERSION_ID IS NOT NULL;
5029:
5030: l_workplan_enabled VARCHAR2(1) := 'N';

Line 5932: DELETE FROM PA_PROJECT_COPY_OPTIONS_TMP;

5928: WHERE project_id = x_new_project_id ;
5929:
5930: --Following code added for selective copy project changes. Tracking Bug no. 3464332
5931: --Delete all records from the global temporary table, used to store copy options in copy project
5932: DELETE FROM PA_PROJECT_COPY_OPTIONS_TMP;
5933:
5934: --********************************************************
5935: --DO NOT ADD ANY CODE AFTER THIS CALL. bug 3163280
5936: --********************************************************

Line 6064: -- temporary table PA_PROJECT_COPY_OPTIONS_TMP

6060:
6061: -------------------------------------------------------------
6062: -- PROCEDURE : populate_copy_options
6063: -- PURPOSE : This API should be called to populate values for copy options into the global
6064: -- temporary table PA_PROJECT_COPY_OPTIONS_TMP
6065: -- PARAMETERS Type Required Description and Purpose
6066: -- ---------------------- ----------------------------- -------- ---------------------------------------------------
6067: -- p_context_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE Y The context of the record
6068: -- p_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE Y Value would be 'Y' or 'N'

Line 6142: DELETE FROM PA_PROJECT_COPY_OPTIONS_TMP;

6138: END IF;
6139: END IF;
6140:
6141: --First truncate the global temporary table
6142: DELETE FROM PA_PROJECT_COPY_OPTIONS_TMP;
6143:
6144: --If the table passed is not NULL
6145: IF nvl(p_context_tbl.LAST,0) > 0 THEN
6146: --Populate the records in the global temporary table

Line 6148: INSERT INTO PA_PROJECT_COPY_OPTIONS_TMP(

6144: --If the table passed is not NULL
6145: IF nvl(p_context_tbl.LAST,0) > 0 THEN
6146: --Populate the records in the global temporary table
6147: FOR i IN p_context_tbl.FIRST..p_context_tbl.LAST LOOP
6148: INSERT INTO PA_PROJECT_COPY_OPTIONS_TMP(
6149: CONTEXT
6150: ,FLAG
6151: ,VERSION_ID
6152: )

Line 6196: -- temporary table PA_PROJECT_COPY_OPTIONS_TMP

6192:
6193:
6194: -- PROCEDURE : populate_default_copy_options
6195: -- PURPOSE : This API should be called to populate default values for copy options into the global
6196: -- temporary table PA_PROJECT_COPY_OPTIONS_TMP
6197: -- PARAMETERS Type Required Description and Purpose
6198: -- ---------------------- ------ -------- ---------------------------------------------------
6199: -- p_src_project_id NUMBER Y The source project id from which the default copy
6200: -- options would be populated

Line 6219: FROM PA_PROJECT_COPY_OPTIONS_TMP ppcot

6215: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
6216: ) IS
6217: CURSOR cur_wp_record_present IS
6218: SELECT version_id
6219: FROM PA_PROJECT_COPY_OPTIONS_TMP ppcot
6220: WHERE context = 'WORKPLAN';
6221:
6222: CURSOR cur_get_wp_attr IS
6223: SELECT ppwa.*

Line 6318: INSERT INTO PA_PROJECT_COPY_OPTIONS_TMP(

6314: RAISE Invalid_Arg_Exc;
6315: END IF;
6316:
6317: --First, insert default values for flags, in case they are not there
6318: INSERT INTO PA_PROJECT_COPY_OPTIONS_TMP(
6319: CONTEXT
6320: ,FLAG
6321: ,VERSION_ID
6322: )

Line 6331: FROM pa_project_copy_options_tmp

6327: FROM pa_lookups
6328: WHERE lookup_type = 'PA_COPY_OPTIONS'
6329: AND lookup_code NOT IN
6330: ( SELECT context
6331: FROM pa_project_copy_options_tmp
6332: WHERE context <> 'WORKPLAN'
6333: );
6334:
6335: IF l_debug_mode = 'Y' THEN

Line 6393: INSERT INTO PA_PROJECT_COPY_OPTIONS_TMP(

6389: END IF;
6390: END LOOP;
6391: END IF;
6392:
6393: INSERT INTO PA_PROJECT_COPY_OPTIONS_TMP(
6394: CONTEXT
6395: ,FLAG
6396: ,VERSION_ID )
6397: VALUES(

Line 6408: INSERT INTO PA_PROJECT_COPY_OPTIONS_TMP(

6404: IF 'Y' = p_src_template_flag OR 'N' = l_versioning_enabled THEN
6405: --In this case, there would be only a SINGLE WP version in the source project
6406: --So, the following loop will execute only ONCE
6407: FOR rec_wp_versions IN cur_get_wp_versions LOOP
6408: INSERT INTO PA_PROJECT_COPY_OPTIONS_TMP(
6409: CONTEXT
6410: ,FLAG
6411: ,VERSION_ID )
6412: VALUES(

Line 6438: INSERT INTO PA_PROJECT_COPY_OPTIONS_TMP(

6434: END IF;
6435: END LOOP;
6436: END IF;
6437:
6438: INSERT INTO PA_PROJECT_COPY_OPTIONS_TMP(
6439: CONTEXT
6440: ,FLAG
6441: ,VERSION_ID )
6442: VALUES(