632: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
633: g1_debug_mode VARCHAR2(1) ;
634:
635: /*4275236 : Some Perf Enhancements*/
636: l_yes FND_LOOKUPS.MEANING%TYPE;
637: l_no FND_LOOKUPS.MEANING%TYPE;
638:
639: --Added the below variables for bug 5580992
640: l_rowid_tbl pa_plsql_datatypes.RowidTabTyp ;
633: g1_debug_mode VARCHAR2(1) ;
634:
635: /*4275236 : Some Perf Enhancements*/
636: l_yes FND_LOOKUPS.MEANING%TYPE;
637: l_no FND_LOOKUPS.MEANING%TYPE;
638:
639: --Added the below variables for bug 5580992
640: l_rowid_tbl pa_plsql_datatypes.RowidTabTyp ;
641: rec_count NUMBER;
5179: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
5180: g1_debug_mode VARCHAR2(1) ;
5181:
5182: /*4275236: Perf Enhancements*/
5183: l_yes FND_LOOKUPS.MEANING%TYPE;
5184: l_no FND_LOOKUPS.MEANING%TYPE;
5185:
5186: -- Bug Fix 5609629.
5187: -- Caching the wp_version_enable_flag in a local variable in order to avoid the function call
5180: g1_debug_mode VARCHAR2(1) ;
5181:
5182: /*4275236: Perf Enhancements*/
5183: l_yes FND_LOOKUPS.MEANING%TYPE;
5184: l_no FND_LOOKUPS.MEANING%TYPE;
5185:
5186: -- Bug Fix 5609629.
5187: -- Caching the wp_version_enable_flag in a local variable in order to avoid the function call
5188: -- during the insert statements. This will avoid the multiple executions of the same select.
12101: ,pa_projects_all ppa
12102: ,pa_proj_element_versions ppv2
12103: ,pa_proj_structure_types ppst
12104: ,pa_structure_types pst
12105: ,fnd_lookups fl1
12106: ,fnd_lookups fl2
12107: ,fnd_lookups fl4
12108: ,fnd_lookups fl5
12109: ,fnd_lookups fl6
12102: ,pa_proj_element_versions ppv2
12103: ,pa_proj_structure_types ppst
12104: ,pa_structure_types pst
12105: ,fnd_lookups fl1
12106: ,fnd_lookups fl2
12107: ,fnd_lookups fl4
12108: ,fnd_lookups fl5
12109: ,fnd_lookups fl6
12110: ,pa_lookups lu1
12103: ,pa_proj_structure_types ppst
12104: ,pa_structure_types pst
12105: ,fnd_lookups fl1
12106: ,fnd_lookups fl2
12107: ,fnd_lookups fl4
12108: ,fnd_lookups fl5
12109: ,fnd_lookups fl6
12110: ,pa_lookups lu1
12111: ,pa_work_types_tl pwt
12104: ,pa_structure_types pst
12105: ,fnd_lookups fl1
12106: ,fnd_lookups fl2
12107: ,fnd_lookups fl4
12108: ,fnd_lookups fl5
12109: ,fnd_lookups fl6
12110: ,pa_lookups lu1
12111: ,pa_work_types_tl pwt
12112: ,pa_progress_rollup ppru
12105: ,fnd_lookups fl1
12106: ,fnd_lookups fl2
12107: ,fnd_lookups fl4
12108: ,fnd_lookups fl5
12109: ,fnd_lookups fl6
12110: ,pa_lookups lu1
12111: ,pa_work_types_tl pwt
12112: ,pa_progress_rollup ppru
12113: ,pa_project_statuses pps
12929: ,pa_projects_all ppa
12930: ,pa_proj_element_versions ppv2
12931: ,pa_proj_structure_types ppst
12932: ,pa_structure_types pst
12933: ,fnd_lookups fl1
12934: ,fnd_lookups fl2
12935: ,fnd_lookups fl4
12936: ,fnd_lookups fl5
12937: ,fnd_lookups fl6
12930: ,pa_proj_element_versions ppv2
12931: ,pa_proj_structure_types ppst
12932: ,pa_structure_types pst
12933: ,fnd_lookups fl1
12934: ,fnd_lookups fl2
12935: ,fnd_lookups fl4
12936: ,fnd_lookups fl5
12937: ,fnd_lookups fl6
12938: ,pa_lookups lu1
12931: ,pa_proj_structure_types ppst
12932: ,pa_structure_types pst
12933: ,fnd_lookups fl1
12934: ,fnd_lookups fl2
12935: ,fnd_lookups fl4
12936: ,fnd_lookups fl5
12937: ,fnd_lookups fl6
12938: ,pa_lookups lu1
12939: ,pa_work_types_tl pwt
12932: ,pa_structure_types pst
12933: ,fnd_lookups fl1
12934: ,fnd_lookups fl2
12935: ,fnd_lookups fl4
12936: ,fnd_lookups fl5
12937: ,fnd_lookups fl6
12938: ,pa_lookups lu1
12939: ,pa_work_types_tl pwt
12940: ,pa_progress_rollup ppru
12933: ,fnd_lookups fl1
12934: ,fnd_lookups fl2
12935: ,fnd_lookups fl4
12936: ,fnd_lookups fl5
12937: ,fnd_lookups fl6
12938: ,pa_lookups lu1
12939: ,pa_work_types_tl pwt
12940: ,pa_progress_rollup ppru
12941: ,pa_project_statuses pps
13758: ,pa_projects_all ppa
13759: ,pa_proj_element_versions ppv2
13760: ,pa_proj_structure_types ppst
13761: ,pa_structure_types pst
13762: ,fnd_lookups fl1
13763: ,fnd_lookups fl2
13764: ,fnd_lookups fl4
13765: ,fnd_lookups fl5
13766: ,fnd_lookups fl6
13759: ,pa_proj_element_versions ppv2
13760: ,pa_proj_structure_types ppst
13761: ,pa_structure_types pst
13762: ,fnd_lookups fl1
13763: ,fnd_lookups fl2
13764: ,fnd_lookups fl4
13765: ,fnd_lookups fl5
13766: ,fnd_lookups fl6
13767: ,pa_lookups lu1
13760: ,pa_proj_structure_types ppst
13761: ,pa_structure_types pst
13762: ,fnd_lookups fl1
13763: ,fnd_lookups fl2
13764: ,fnd_lookups fl4
13765: ,fnd_lookups fl5
13766: ,fnd_lookups fl6
13767: ,pa_lookups lu1
13768: ,pa_work_types_tl pwt
13761: ,pa_structure_types pst
13762: ,fnd_lookups fl1
13763: ,fnd_lookups fl2
13764: ,fnd_lookups fl4
13765: ,fnd_lookups fl5
13766: ,fnd_lookups fl6
13767: ,pa_lookups lu1
13768: ,pa_work_types_tl pwt
13769: ,pa_progress_rollup ppru
13762: ,fnd_lookups fl1
13763: ,fnd_lookups fl2
13764: ,fnd_lookups fl4
13765: ,fnd_lookups fl5
13766: ,fnd_lookups fl6
13767: ,pa_lookups lu1
13768: ,pa_work_types_tl pwt
13769: ,pa_progress_rollup ppru
13770: ,pa_project_statuses pps
14683: ,pa_projects_all ppa
14684: ,pa_proj_element_versions ppv2
14685: ,pa_proj_structure_types ppst
14686: ,pa_structure_types pst
14687: ,fnd_lookups fl1
14688: ,fnd_lookups fl2
14689: ,fnd_lookups fl4
14690: ,fnd_lookups fl5
14691: ,fnd_lookups fl6
14684: ,pa_proj_element_versions ppv2
14685: ,pa_proj_structure_types ppst
14686: ,pa_structure_types pst
14687: ,fnd_lookups fl1
14688: ,fnd_lookups fl2
14689: ,fnd_lookups fl4
14690: ,fnd_lookups fl5
14691: ,fnd_lookups fl6
14692: ,pa_lookups lu1
14685: ,pa_proj_structure_types ppst
14686: ,pa_structure_types pst
14687: ,fnd_lookups fl1
14688: ,fnd_lookups fl2
14689: ,fnd_lookups fl4
14690: ,fnd_lookups fl5
14691: ,fnd_lookups fl6
14692: ,pa_lookups lu1
14693: ,pa_work_types_tl pwt
14686: ,pa_structure_types pst
14687: ,fnd_lookups fl1
14688: ,fnd_lookups fl2
14689: ,fnd_lookups fl4
14690: ,fnd_lookups fl5
14691: ,fnd_lookups fl6
14692: ,pa_lookups lu1
14693: ,pa_work_types_tl pwt
14694: ,pa_progress_rollup ppru
14687: ,fnd_lookups fl1
14688: ,fnd_lookups fl2
14689: ,fnd_lookups fl4
14690: ,fnd_lookups fl5
14691: ,fnd_lookups fl6
14692: ,pa_lookups lu1
14693: ,pa_work_types_tl pwt
14694: ,pa_progress_rollup ppru
14695: ,pa_project_statuses pps
15480: ,pa_projects_all ppa
15481: ,pa_proj_element_versions ppv2
15482: ,pa_proj_structure_types ppst
15483: ,pa_structure_types pst
15484: ,fnd_lookups fl1
15485: ,fnd_lookups fl2
15486: ,fnd_lookups fl4
15487: ,fnd_lookups fl5
15488: ,fnd_lookups fl6
15481: ,pa_proj_element_versions ppv2
15482: ,pa_proj_structure_types ppst
15483: ,pa_structure_types pst
15484: ,fnd_lookups fl1
15485: ,fnd_lookups fl2
15486: ,fnd_lookups fl4
15487: ,fnd_lookups fl5
15488: ,fnd_lookups fl6
15489: ,pa_lookups lu1
15482: ,pa_proj_structure_types ppst
15483: ,pa_structure_types pst
15484: ,fnd_lookups fl1
15485: ,fnd_lookups fl2
15486: ,fnd_lookups fl4
15487: ,fnd_lookups fl5
15488: ,fnd_lookups fl6
15489: ,pa_lookups lu1
15490: ,pa_work_types_tl pwt
15483: ,pa_structure_types pst
15484: ,fnd_lookups fl1
15485: ,fnd_lookups fl2
15486: ,fnd_lookups fl4
15487: ,fnd_lookups fl5
15488: ,fnd_lookups fl6
15489: ,pa_lookups lu1
15490: ,pa_work_types_tl pwt
15491: ,pa_progress_rollup ppru
15484: ,fnd_lookups fl1
15485: ,fnd_lookups fl2
15486: ,fnd_lookups fl4
15487: ,fnd_lookups fl5
15488: ,fnd_lookups fl6
15489: ,pa_lookups lu1
15490: ,pa_work_types_tl pwt
15491: ,pa_progress_rollup ppru
15492: ,pa_project_statuses pps
16278: ,pa_projects_all ppa
16279: ,pa_proj_element_versions ppv2
16280: ,pa_proj_structure_types ppst
16281: ,pa_structure_types pst
16282: ,fnd_lookups fl1
16283: ,fnd_lookups fl2
16284: ,fnd_lookups fl4
16285: ,fnd_lookups fl5
16286: ,fnd_lookups fl6
16279: ,pa_proj_element_versions ppv2
16280: ,pa_proj_structure_types ppst
16281: ,pa_structure_types pst
16282: ,fnd_lookups fl1
16283: ,fnd_lookups fl2
16284: ,fnd_lookups fl4
16285: ,fnd_lookups fl5
16286: ,fnd_lookups fl6
16287: ,pa_lookups lu1
16280: ,pa_proj_structure_types ppst
16281: ,pa_structure_types pst
16282: ,fnd_lookups fl1
16283: ,fnd_lookups fl2
16284: ,fnd_lookups fl4
16285: ,fnd_lookups fl5
16286: ,fnd_lookups fl6
16287: ,pa_lookups lu1
16288: ,pa_work_types_tl pwt
16281: ,pa_structure_types pst
16282: ,fnd_lookups fl1
16283: ,fnd_lookups fl2
16284: ,fnd_lookups fl4
16285: ,fnd_lookups fl5
16286: ,fnd_lookups fl6
16287: ,pa_lookups lu1
16288: ,pa_work_types_tl pwt
16289: ,pa_progress_rollup ppru
16282: ,fnd_lookups fl1
16283: ,fnd_lookups fl2
16284: ,fnd_lookups fl4
16285: ,fnd_lookups fl5
16286: ,fnd_lookups fl6
16287: ,pa_lookups lu1
16288: ,pa_work_types_tl pwt
16289: ,pa_progress_rollup ppru
16290: ,pa_project_statuses pps