APPS.PA_PROJECT_CORE1 dependencies on PA_PROJECT_COPY_OPTIONS_TMP

Line 394: FROM PA_PROJECT_COPY_OPTIONS_TMP

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

Line 4978: FROM PA_PROJECT_COPY_OPTIONS_TMP

4974: --Added for Selective Copy Project. Tracking Bug No. 3464332
4975: --This cursor determines if atleast one WP version has been selected by the user
4976: CURSOR min_one_wp_version_sel IS
4977: SELECT distinct 'Y'
4978: FROM PA_PROJECT_COPY_OPTIONS_TMP
4979: WHERE CONTEXT = 'WORKPLAN'
4980: AND VERSION_ID IS NOT NULL;
4981:
4982: l_workplan_enabled VARCHAR2(1) := 'N';

Line 5864: DELETE FROM PA_PROJECT_COPY_OPTIONS_TMP;

5860: WHERE project_id = x_new_project_id ;
5861:
5862: --Following code added for selective copy project changes. Tracking Bug no. 3464332
5863: --Delete all records from the global temporary table, used to store copy options in copy project
5864: DELETE FROM PA_PROJECT_COPY_OPTIONS_TMP;
5865:
5866: --********************************************************
5867: --DO NOT ADD ANY CODE AFTER THIS CALL. bug 3163280
5868: --********************************************************

Line 5996: -- temporary table PA_PROJECT_COPY_OPTIONS_TMP

5992:
5993: -------------------------------------------------------------
5994: -- PROCEDURE : populate_copy_options
5995: -- PURPOSE : This API should be called to populate values for copy options into the global
5996: -- temporary table PA_PROJECT_COPY_OPTIONS_TMP
5997: -- PARAMETERS Type Required Description and Purpose
5998: -- ---------------------- ----------------------------- -------- ---------------------------------------------------
5999: -- p_context_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE Y The context of the record
6000: -- p_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE Y Value would be 'Y' or 'N'

Line 6074: DELETE FROM PA_PROJECT_COPY_OPTIONS_TMP;

6070: END IF;
6071: END IF;
6072:
6073: --First truncate the global temporary table
6074: DELETE FROM PA_PROJECT_COPY_OPTIONS_TMP;
6075:
6076: --If the table passed is not NULL
6077: IF nvl(p_context_tbl.LAST,0) > 0 THEN
6078: --Populate the records in the global temporary table

Line 6080: INSERT INTO PA_PROJECT_COPY_OPTIONS_TMP(

6076: --If the table passed is not NULL
6077: IF nvl(p_context_tbl.LAST,0) > 0 THEN
6078: --Populate the records in the global temporary table
6079: FOR i IN p_context_tbl.FIRST..p_context_tbl.LAST LOOP
6080: INSERT INTO PA_PROJECT_COPY_OPTIONS_TMP(
6081: CONTEXT
6082: ,FLAG
6083: ,VERSION_ID
6084: )

Line 6128: -- temporary table PA_PROJECT_COPY_OPTIONS_TMP

6124:
6125:
6126: -- PROCEDURE : populate_default_copy_options
6127: -- PURPOSE : This API should be called to populate default values for copy options into the global
6128: -- temporary table PA_PROJECT_COPY_OPTIONS_TMP
6129: -- PARAMETERS Type Required Description and Purpose
6130: -- ---------------------- ------ -------- ---------------------------------------------------
6131: -- p_src_project_id NUMBER Y The source project id from which the default copy
6132: -- options would be populated

Line 6151: FROM PA_PROJECT_COPY_OPTIONS_TMP ppcot

6147: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
6148: ) IS
6149: CURSOR cur_wp_record_present IS
6150: SELECT version_id
6151: FROM PA_PROJECT_COPY_OPTIONS_TMP ppcot
6152: WHERE context = 'WORKPLAN';
6153:
6154: CURSOR cur_get_wp_attr IS
6155: SELECT ppwa.*

Line 6250: INSERT INTO PA_PROJECT_COPY_OPTIONS_TMP(

6246: RAISE Invalid_Arg_Exc;
6247: END IF;
6248:
6249: --First, insert default values for flags, in case they are not there
6250: INSERT INTO PA_PROJECT_COPY_OPTIONS_TMP(
6251: CONTEXT
6252: ,FLAG
6253: ,VERSION_ID
6254: )

Line 6263: FROM pa_project_copy_options_tmp

6259: FROM pa_lookups
6260: WHERE lookup_type = 'PA_COPY_OPTIONS'
6261: AND lookup_code NOT IN
6262: ( SELECT context
6263: FROM pa_project_copy_options_tmp
6264: WHERE context <> 'WORKPLAN'
6265: );
6266:
6267: IF l_debug_mode = 'Y' THEN

Line 6325: INSERT INTO PA_PROJECT_COPY_OPTIONS_TMP(

6321: END IF;
6322: END LOOP;
6323: END IF;
6324:
6325: INSERT INTO PA_PROJECT_COPY_OPTIONS_TMP(
6326: CONTEXT
6327: ,FLAG
6328: ,VERSION_ID )
6329: VALUES(

Line 6340: INSERT INTO PA_PROJECT_COPY_OPTIONS_TMP(

6336: IF 'Y' = p_src_template_flag OR 'N' = l_versioning_enabled THEN
6337: --In this case, there would be only a SINGLE WP version in the source project
6338: --So, the following loop will execute only ONCE
6339: FOR rec_wp_versions IN cur_get_wp_versions LOOP
6340: INSERT INTO PA_PROJECT_COPY_OPTIONS_TMP(
6341: CONTEXT
6342: ,FLAG
6343: ,VERSION_ID )
6344: VALUES(

Line 6370: INSERT INTO PA_PROJECT_COPY_OPTIONS_TMP(

6366: END IF;
6367: END LOOP;
6368: END IF;
6369:
6370: INSERT INTO PA_PROJECT_COPY_OPTIONS_TMP(
6371: CONTEXT
6372: ,FLAG
6373: ,VERSION_ID )
6374: VALUES(