DBA Data[Home] [Help]

APPS.PA_PROJ_STRUCTURE_PUB dependencies on FND_LOOKUPS

Line 636: l_yes FND_LOOKUPS.MEANING%TYPE;

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 ;

Line 637: l_no FND_LOOKUPS.MEANING%TYPE;

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;

Line 5183: l_yes FND_LOOKUPS.MEANING%TYPE;

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

Line 5184: l_no FND_LOOKUPS.MEANING%TYPE;

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.

Line 12105: ,fnd_lookups fl1

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

Line 12106: ,fnd_lookups fl2

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

Line 12107: ,fnd_lookups fl4

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

Line 12108: ,fnd_lookups fl5

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

Line 12109: ,fnd_lookups fl6

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

Line 12933: ,fnd_lookups fl1

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

Line 12934: ,fnd_lookups fl2

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

Line 12935: ,fnd_lookups fl4

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

Line 12936: ,fnd_lookups fl5

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

Line 12937: ,fnd_lookups fl6

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

Line 13762: ,fnd_lookups fl1

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

Line 13763: ,fnd_lookups fl2

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

Line 13764: ,fnd_lookups fl4

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

Line 13765: ,fnd_lookups fl5

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

Line 13766: ,fnd_lookups fl6

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

Line 14687: ,fnd_lookups fl1

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

Line 14688: ,fnd_lookups fl2

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

Line 14689: ,fnd_lookups fl4

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

Line 14690: ,fnd_lookups fl5

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

Line 14691: ,fnd_lookups fl6

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

Line 15484: ,fnd_lookups fl1

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

Line 15485: ,fnd_lookups fl2

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

Line 15486: ,fnd_lookups fl4

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

Line 15487: ,fnd_lookups fl5

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

Line 15488: ,fnd_lookups fl6

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

Line 16282: ,fnd_lookups fl1

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

Line 16283: ,fnd_lookups fl2

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

Line 16284: ,fnd_lookups fl4

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

Line 16285: ,fnd_lookups fl5

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

Line 16286: ,fnd_lookups fl6

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