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 3372: l_yes FND_LOOKUPS.MEANING%TYPE;

3368: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
3369: g1_debug_mode VARCHAR2(1) ;
3370:
3371: /*4275236: Perf Enhancements*/
3372: l_yes FND_LOOKUPS.MEANING%TYPE;
3373: l_no FND_LOOKUPS.MEANING%TYPE;
3374:
3375: -- Bug Fix 5609629.
3376: -- Caching the wp_version_enable_flag in a local variable in order to avoid the function call

Line 3373: l_no FND_LOOKUPS.MEANING%TYPE;

3369: g1_debug_mode VARCHAR2(1) ;
3370:
3371: /*4275236: Perf Enhancements*/
3372: l_yes FND_LOOKUPS.MEANING%TYPE;
3373: l_no FND_LOOKUPS.MEANING%TYPE;
3374:
3375: -- Bug Fix 5609629.
3376: -- Caching the wp_version_enable_flag in a local variable in order to avoid the function call
3377: -- during the insert statements. This will avoid the multiple executions of the same select.

Line 9774: ,fnd_lookups fl1

9770: ,pa_projects_all ppa
9771: ,pa_proj_element_versions ppv2
9772: ,pa_proj_structure_types ppst
9773: ,pa_structure_types pst
9774: ,fnd_lookups fl1
9775: ,fnd_lookups fl2
9776: ,fnd_lookups fl4
9777: ,fnd_lookups fl5
9778: ,fnd_lookups fl6

Line 9775: ,fnd_lookups fl2

9771: ,pa_proj_element_versions ppv2
9772: ,pa_proj_structure_types ppst
9773: ,pa_structure_types pst
9774: ,fnd_lookups fl1
9775: ,fnd_lookups fl2
9776: ,fnd_lookups fl4
9777: ,fnd_lookups fl5
9778: ,fnd_lookups fl6
9779: ,pa_lookups lu1

Line 9776: ,fnd_lookups fl4

9772: ,pa_proj_structure_types ppst
9773: ,pa_structure_types pst
9774: ,fnd_lookups fl1
9775: ,fnd_lookups fl2
9776: ,fnd_lookups fl4
9777: ,fnd_lookups fl5
9778: ,fnd_lookups fl6
9779: ,pa_lookups lu1
9780: ,pa_work_types_tl pwt

Line 9777: ,fnd_lookups fl5

9773: ,pa_structure_types pst
9774: ,fnd_lookups fl1
9775: ,fnd_lookups fl2
9776: ,fnd_lookups fl4
9777: ,fnd_lookups fl5
9778: ,fnd_lookups fl6
9779: ,pa_lookups lu1
9780: ,pa_work_types_tl pwt
9781: ,pa_progress_rollup ppru

Line 9778: ,fnd_lookups fl6

9774: ,fnd_lookups fl1
9775: ,fnd_lookups fl2
9776: ,fnd_lookups fl4
9777: ,fnd_lookups fl5
9778: ,fnd_lookups fl6
9779: ,pa_lookups lu1
9780: ,pa_work_types_tl pwt
9781: ,pa_progress_rollup ppru
9782: ,pa_project_statuses pps

Line 10601: ,fnd_lookups fl1

10597: ,pa_projects_all ppa
10598: ,pa_proj_element_versions ppv2
10599: ,pa_proj_structure_types ppst
10600: ,pa_structure_types pst
10601: ,fnd_lookups fl1
10602: ,fnd_lookups fl2
10603: ,fnd_lookups fl4
10604: ,fnd_lookups fl5
10605: ,fnd_lookups fl6

Line 10602: ,fnd_lookups fl2

10598: ,pa_proj_element_versions ppv2
10599: ,pa_proj_structure_types ppst
10600: ,pa_structure_types pst
10601: ,fnd_lookups fl1
10602: ,fnd_lookups fl2
10603: ,fnd_lookups fl4
10604: ,fnd_lookups fl5
10605: ,fnd_lookups fl6
10606: ,pa_lookups lu1

Line 10603: ,fnd_lookups fl4

10599: ,pa_proj_structure_types ppst
10600: ,pa_structure_types pst
10601: ,fnd_lookups fl1
10602: ,fnd_lookups fl2
10603: ,fnd_lookups fl4
10604: ,fnd_lookups fl5
10605: ,fnd_lookups fl6
10606: ,pa_lookups lu1
10607: ,pa_work_types_tl pwt

Line 10604: ,fnd_lookups fl5

10600: ,pa_structure_types pst
10601: ,fnd_lookups fl1
10602: ,fnd_lookups fl2
10603: ,fnd_lookups fl4
10604: ,fnd_lookups fl5
10605: ,fnd_lookups fl6
10606: ,pa_lookups lu1
10607: ,pa_work_types_tl pwt
10608: ,pa_progress_rollup ppru

Line 10605: ,fnd_lookups fl6

10601: ,fnd_lookups fl1
10602: ,fnd_lookups fl2
10603: ,fnd_lookups fl4
10604: ,fnd_lookups fl5
10605: ,fnd_lookups fl6
10606: ,pa_lookups lu1
10607: ,pa_work_types_tl pwt
10608: ,pa_progress_rollup ppru
10609: ,pa_project_statuses pps

Line 11429: ,fnd_lookups fl1

11425: ,pa_projects_all ppa
11426: ,pa_proj_element_versions ppv2
11427: ,pa_proj_structure_types ppst
11428: ,pa_structure_types pst
11429: ,fnd_lookups fl1
11430: ,fnd_lookups fl2
11431: ,fnd_lookups fl4
11432: ,fnd_lookups fl5
11433: ,fnd_lookups fl6

Line 11430: ,fnd_lookups fl2

11426: ,pa_proj_element_versions ppv2
11427: ,pa_proj_structure_types ppst
11428: ,pa_structure_types pst
11429: ,fnd_lookups fl1
11430: ,fnd_lookups fl2
11431: ,fnd_lookups fl4
11432: ,fnd_lookups fl5
11433: ,fnd_lookups fl6
11434: ,pa_lookups lu1

Line 11431: ,fnd_lookups fl4

11427: ,pa_proj_structure_types ppst
11428: ,pa_structure_types pst
11429: ,fnd_lookups fl1
11430: ,fnd_lookups fl2
11431: ,fnd_lookups fl4
11432: ,fnd_lookups fl5
11433: ,fnd_lookups fl6
11434: ,pa_lookups lu1
11435: ,pa_work_types_tl pwt

Line 11432: ,fnd_lookups fl5

11428: ,pa_structure_types pst
11429: ,fnd_lookups fl1
11430: ,fnd_lookups fl2
11431: ,fnd_lookups fl4
11432: ,fnd_lookups fl5
11433: ,fnd_lookups fl6
11434: ,pa_lookups lu1
11435: ,pa_work_types_tl pwt
11436: ,pa_progress_rollup ppru

Line 11433: ,fnd_lookups fl6

11429: ,fnd_lookups fl1
11430: ,fnd_lookups fl2
11431: ,fnd_lookups fl4
11432: ,fnd_lookups fl5
11433: ,fnd_lookups fl6
11434: ,pa_lookups lu1
11435: ,pa_work_types_tl pwt
11436: ,pa_progress_rollup ppru
11437: ,pa_project_statuses pps

Line 12353: ,fnd_lookups fl1

12349: ,pa_projects_all ppa
12350: ,pa_proj_element_versions ppv2
12351: ,pa_proj_structure_types ppst
12352: ,pa_structure_types pst
12353: ,fnd_lookups fl1
12354: ,fnd_lookups fl2
12355: ,fnd_lookups fl4
12356: ,fnd_lookups fl5
12357: ,fnd_lookups fl6

Line 12354: ,fnd_lookups fl2

12350: ,pa_proj_element_versions ppv2
12351: ,pa_proj_structure_types ppst
12352: ,pa_structure_types pst
12353: ,fnd_lookups fl1
12354: ,fnd_lookups fl2
12355: ,fnd_lookups fl4
12356: ,fnd_lookups fl5
12357: ,fnd_lookups fl6
12358: ,pa_lookups lu1

Line 12355: ,fnd_lookups fl4

12351: ,pa_proj_structure_types ppst
12352: ,pa_structure_types pst
12353: ,fnd_lookups fl1
12354: ,fnd_lookups fl2
12355: ,fnd_lookups fl4
12356: ,fnd_lookups fl5
12357: ,fnd_lookups fl6
12358: ,pa_lookups lu1
12359: ,pa_work_types_tl pwt

Line 12356: ,fnd_lookups fl5

12352: ,pa_structure_types pst
12353: ,fnd_lookups fl1
12354: ,fnd_lookups fl2
12355: ,fnd_lookups fl4
12356: ,fnd_lookups fl5
12357: ,fnd_lookups fl6
12358: ,pa_lookups lu1
12359: ,pa_work_types_tl pwt
12360: ,pa_progress_rollup ppru

Line 12357: ,fnd_lookups fl6

12353: ,fnd_lookups fl1
12354: ,fnd_lookups fl2
12355: ,fnd_lookups fl4
12356: ,fnd_lookups fl5
12357: ,fnd_lookups fl6
12358: ,pa_lookups lu1
12359: ,pa_work_types_tl pwt
12360: ,pa_progress_rollup ppru
12361: ,pa_project_statuses pps

Line 13149: ,fnd_lookups fl1

13145: ,pa_projects_all ppa
13146: ,pa_proj_element_versions ppv2
13147: ,pa_proj_structure_types ppst
13148: ,pa_structure_types pst
13149: ,fnd_lookups fl1
13150: ,fnd_lookups fl2
13151: ,fnd_lookups fl4
13152: ,fnd_lookups fl5
13153: ,fnd_lookups fl6

Line 13150: ,fnd_lookups fl2

13146: ,pa_proj_element_versions ppv2
13147: ,pa_proj_structure_types ppst
13148: ,pa_structure_types pst
13149: ,fnd_lookups fl1
13150: ,fnd_lookups fl2
13151: ,fnd_lookups fl4
13152: ,fnd_lookups fl5
13153: ,fnd_lookups fl6
13154: ,pa_lookups lu1

Line 13151: ,fnd_lookups fl4

13147: ,pa_proj_structure_types ppst
13148: ,pa_structure_types pst
13149: ,fnd_lookups fl1
13150: ,fnd_lookups fl2
13151: ,fnd_lookups fl4
13152: ,fnd_lookups fl5
13153: ,fnd_lookups fl6
13154: ,pa_lookups lu1
13155: ,pa_work_types_tl pwt

Line 13152: ,fnd_lookups fl5

13148: ,pa_structure_types pst
13149: ,fnd_lookups fl1
13150: ,fnd_lookups fl2
13151: ,fnd_lookups fl4
13152: ,fnd_lookups fl5
13153: ,fnd_lookups fl6
13154: ,pa_lookups lu1
13155: ,pa_work_types_tl pwt
13156: ,pa_progress_rollup ppru

Line 13153: ,fnd_lookups fl6

13149: ,fnd_lookups fl1
13150: ,fnd_lookups fl2
13151: ,fnd_lookups fl4
13152: ,fnd_lookups fl5
13153: ,fnd_lookups fl6
13154: ,pa_lookups lu1
13155: ,pa_work_types_tl pwt
13156: ,pa_progress_rollup ppru
13157: ,pa_project_statuses pps

Line 13946: ,fnd_lookups fl1

13942: ,pa_projects_all ppa
13943: ,pa_proj_element_versions ppv2
13944: ,pa_proj_structure_types ppst
13945: ,pa_structure_types pst
13946: ,fnd_lookups fl1
13947: ,fnd_lookups fl2
13948: ,fnd_lookups fl4
13949: ,fnd_lookups fl5
13950: ,fnd_lookups fl6

Line 13947: ,fnd_lookups fl2

13943: ,pa_proj_element_versions ppv2
13944: ,pa_proj_structure_types ppst
13945: ,pa_structure_types pst
13946: ,fnd_lookups fl1
13947: ,fnd_lookups fl2
13948: ,fnd_lookups fl4
13949: ,fnd_lookups fl5
13950: ,fnd_lookups fl6
13951: ,pa_lookups lu1

Line 13948: ,fnd_lookups fl4

13944: ,pa_proj_structure_types ppst
13945: ,pa_structure_types pst
13946: ,fnd_lookups fl1
13947: ,fnd_lookups fl2
13948: ,fnd_lookups fl4
13949: ,fnd_lookups fl5
13950: ,fnd_lookups fl6
13951: ,pa_lookups lu1
13952: ,pa_work_types_tl pwt

Line 13949: ,fnd_lookups fl5

13945: ,pa_structure_types pst
13946: ,fnd_lookups fl1
13947: ,fnd_lookups fl2
13948: ,fnd_lookups fl4
13949: ,fnd_lookups fl5
13950: ,fnd_lookups fl6
13951: ,pa_lookups lu1
13952: ,pa_work_types_tl pwt
13953: ,pa_progress_rollup ppru

Line 13950: ,fnd_lookups fl6

13946: ,fnd_lookups fl1
13947: ,fnd_lookups fl2
13948: ,fnd_lookups fl4
13949: ,fnd_lookups fl5
13950: ,fnd_lookups fl6
13951: ,pa_lookups lu1
13952: ,pa_work_types_tl pwt
13953: ,pa_progress_rollup ppru
13954: ,pa_project_statuses pps