eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_CAPITAL_EVENTS_PVT dependencies on PA_LOOKUPS

Line 79: pa_lookups pl,

75: 'P',project_number,
76: 'T',task_number,
77: 'AT',task_number) formatted_message
78: FROM pa_cap_event_creation_v pe,
79: pa_lookups pl,
80: pa_lookups pl2,
81: pa_projects p
82: WHERE pe.request_id = x_conc_request_id
83: AND pl.lookup_type = 'PERIODIC_EVENT_CREATION'

Line 80: pa_lookups pl2,

76: 'T',task_number,
77: 'AT',task_number) formatted_message
78: FROM pa_cap_event_creation_v pe,
79: pa_lookups pl,
80: pa_lookups pl2,
81: pa_projects p
82: WHERE pe.request_id = x_conc_request_id
83: AND pl.lookup_type = 'PERIODIC_EVENT_CREATION'
84: AND pl.lookup_code = pe.message_code

Line 129: v_report_title PA_LOOKUPS.meaning%TYPE;

125: curr_project_id NUMBER;
126: curr_capital_type PA_REPORTING_EXCEPTIONS.record_type%TYPE;
127: curr_context PA_REPORTING_EXCEPTIONS.context%TYPE;
128: v_cost_type PA_PROJECT_TYPES.capital_cost_type_code%TYPE;
129: v_report_title PA_LOOKUPS.meaning%TYPE;
130: v_proj_heading1 PA_LOOKUPS.meaning%TYPE;
131: v_proj_heading2 PA_LOOKUPS.meaning%TYPE;
132: v_event_information PA_LOOKUPS.meaning%TYPE;
133: v_assets_included PA_LOOKUPS.meaning%TYPE;

Line 130: v_proj_heading1 PA_LOOKUPS.meaning%TYPE;

126: curr_capital_type PA_REPORTING_EXCEPTIONS.record_type%TYPE;
127: curr_context PA_REPORTING_EXCEPTIONS.context%TYPE;
128: v_cost_type PA_PROJECT_TYPES.capital_cost_type_code%TYPE;
129: v_report_title PA_LOOKUPS.meaning%TYPE;
130: v_proj_heading1 PA_LOOKUPS.meaning%TYPE;
131: v_proj_heading2 PA_LOOKUPS.meaning%TYPE;
132: v_event_information PA_LOOKUPS.meaning%TYPE;
133: v_assets_included PA_LOOKUPS.meaning%TYPE;
134: v_cost_included PA_LOOKUPS.meaning%TYPE;

Line 131: v_proj_heading2 PA_LOOKUPS.meaning%TYPE;

127: curr_context PA_REPORTING_EXCEPTIONS.context%TYPE;
128: v_cost_type PA_PROJECT_TYPES.capital_cost_type_code%TYPE;
129: v_report_title PA_LOOKUPS.meaning%TYPE;
130: v_proj_heading1 PA_LOOKUPS.meaning%TYPE;
131: v_proj_heading2 PA_LOOKUPS.meaning%TYPE;
132: v_event_information PA_LOOKUPS.meaning%TYPE;
133: v_assets_included PA_LOOKUPS.meaning%TYPE;
134: v_cost_included PA_LOOKUPS.meaning%TYPE;
135: v_assets_added PA_LOOKUPS.meaning%TYPE;

Line 132: v_event_information PA_LOOKUPS.meaning%TYPE;

128: v_cost_type PA_PROJECT_TYPES.capital_cost_type_code%TYPE;
129: v_report_title PA_LOOKUPS.meaning%TYPE;
130: v_proj_heading1 PA_LOOKUPS.meaning%TYPE;
131: v_proj_heading2 PA_LOOKUPS.meaning%TYPE;
132: v_event_information PA_LOOKUPS.meaning%TYPE;
133: v_assets_included PA_LOOKUPS.meaning%TYPE;
134: v_cost_included PA_LOOKUPS.meaning%TYPE;
135: v_assets_added PA_LOOKUPS.meaning%TYPE;
136: v_cost_added PA_LOOKUPS.meaning%TYPE;

Line 133: v_assets_included PA_LOOKUPS.meaning%TYPE;

129: v_report_title PA_LOOKUPS.meaning%TYPE;
130: v_proj_heading1 PA_LOOKUPS.meaning%TYPE;
131: v_proj_heading2 PA_LOOKUPS.meaning%TYPE;
132: v_event_information PA_LOOKUPS.meaning%TYPE;
133: v_assets_included PA_LOOKUPS.meaning%TYPE;
134: v_cost_included PA_LOOKUPS.meaning%TYPE;
135: v_assets_added PA_LOOKUPS.meaning%TYPE;
136: v_cost_added PA_LOOKUPS.meaning%TYPE;
137: v_total_cost PA_LOOKUPS.meaning%TYPE;

Line 134: v_cost_included PA_LOOKUPS.meaning%TYPE;

130: v_proj_heading1 PA_LOOKUPS.meaning%TYPE;
131: v_proj_heading2 PA_LOOKUPS.meaning%TYPE;
132: v_event_information PA_LOOKUPS.meaning%TYPE;
133: v_assets_included PA_LOOKUPS.meaning%TYPE;
134: v_cost_included PA_LOOKUPS.meaning%TYPE;
135: v_assets_added PA_LOOKUPS.meaning%TYPE;
136: v_cost_added PA_LOOKUPS.meaning%TYPE;
137: v_total_cost PA_LOOKUPS.meaning%TYPE;
138:

Line 135: v_assets_added PA_LOOKUPS.meaning%TYPE;

131: v_proj_heading2 PA_LOOKUPS.meaning%TYPE;
132: v_event_information PA_LOOKUPS.meaning%TYPE;
133: v_assets_included PA_LOOKUPS.meaning%TYPE;
134: v_cost_included PA_LOOKUPS.meaning%TYPE;
135: v_assets_added PA_LOOKUPS.meaning%TYPE;
136: v_cost_added PA_LOOKUPS.meaning%TYPE;
137: v_total_cost PA_LOOKUPS.meaning%TYPE;
138:
139: BEGIN

Line 136: v_cost_added PA_LOOKUPS.meaning%TYPE;

132: v_event_information PA_LOOKUPS.meaning%TYPE;
133: v_assets_included PA_LOOKUPS.meaning%TYPE;
134: v_cost_included PA_LOOKUPS.meaning%TYPE;
135: v_assets_added PA_LOOKUPS.meaning%TYPE;
136: v_cost_added PA_LOOKUPS.meaning%TYPE;
137: v_total_cost PA_LOOKUPS.meaning%TYPE;
138:
139: BEGIN
140:

Line 137: v_total_cost PA_LOOKUPS.meaning%TYPE;

133: v_assets_included PA_LOOKUPS.meaning%TYPE;
134: v_cost_included PA_LOOKUPS.meaning%TYPE;
135: v_assets_added PA_LOOKUPS.meaning%TYPE;
136: v_cost_added PA_LOOKUPS.meaning%TYPE;
137: v_total_cost PA_LOOKUPS.meaning%TYPE;
138:
139: BEGIN
140:
141: --Get translated Report Title

Line 144: FROM pa_lookups

140:
141: --Get translated Report Title
142: SELECT meaning
143: INTO v_report_title
144: FROM pa_lookups
145: WHERE lookup_type = 'PERIODIC_EVENT_CREATION'
146: AND lookup_code = 'REPORT_TITLE';
147:
148: --Get translated Report Heading 1

Line 151: FROM pa_lookups

147:
148: --Get translated Report Heading 1
149: SELECT meaning
150: INTO v_proj_heading1
151: FROM pa_lookups
152: WHERE lookup_type = 'PERIODIC_EVENT_CREATION'
153: AND lookup_code = 'PROJ_HEADING_1';
154:
155: --Get translated Report Heading 2

Line 158: FROM pa_lookups

154:
155: --Get translated Report Heading 2
156: SELECT meaning
157: INTO v_proj_heading2
158: FROM pa_lookups
159: WHERE lookup_type = 'PERIODIC_EVENT_CREATION'
160: AND lookup_code = 'PROJ_HEADING_2';
161:
162:

Line 166: FROM pa_lookups

162:
163: --Get translated "Event Information" literal
164: SELECT meaning
165: INTO v_event_information
166: FROM pa_lookups
167: WHERE lookup_type = 'PERIODIC_EVENT_CREATION'
168: AND lookup_code = 'EVENT_INFO';
169:
170: --Get translated "Assets Included" heading

Line 173: FROM pa_lookups

169:
170: --Get translated "Assets Included" heading
171: SELECT meaning
172: INTO v_assets_included
173: FROM pa_lookups
174: WHERE lookup_type = 'PERIODIC_EVENT_CREATION'
175: AND lookup_code = 'ASSETS_INCLUDED';
176:
177: --Get translated "Cost Included" heading

Line 180: FROM pa_lookups

176:
177: --Get translated "Cost Included" heading
178: SELECT meaning
179: INTO v_cost_included
180: FROM pa_lookups
181: WHERE lookup_type = 'PERIODIC_EVENT_CREATION'
182: AND lookup_code = 'COST_INCLUDED';
183:
184: --Get translated "Assets Added" heading

Line 187: FROM pa_lookups

183:
184: --Get translated "Assets Added" heading
185: SELECT meaning
186: INTO v_assets_added
187: FROM pa_lookups
188: WHERE lookup_type = 'PERIODIC_EVENT_CREATION'
189: AND lookup_code = 'ASSETS_ADDED';
190:
191: --Get translated "Cost Added" heading

Line 194: FROM pa_lookups

190:
191: --Get translated "Cost Added" heading
192: SELECT meaning
193: INTO v_cost_added
194: FROM pa_lookups
195: WHERE lookup_type = 'PERIODIC_EVENT_CREATION'
196: AND lookup_code = 'COST_ADDED';
197:
198: --Get translated "Total Cost" heading

Line 201: FROM pa_lookups

197:
198: --Get translated "Total Cost" heading
199: SELECT meaning
200: INTO v_total_cost
201: FROM pa_lookups
202: WHERE lookup_type = 'PERIODIC_EVENT_CREATION'
203: AND lookup_code = 'TOTAL_COST';
204:
205:

Line 856: v_capital_type pa_lookups.meaning%TYPE;

852: v_top_task_id NUMBER := 0;
853: v_return_status VARCHAR2(1);
854: v_msg_count NUMBER := 0;
855: v_msg_data VARCHAR2(2000);
856: v_capital_type pa_lookups.meaning%TYPE;
857: v_wbs_branch_assets_exist VARCHAR2(1) := 'N';
858:
859:
860: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

Line 1015: FROM pa_lookups

1011:
1012: --Get the Capital Type meaning
1013: SELECT meaning
1014: INTO v_capital_type
1015: FROM pa_lookups
1016: WHERE lookup_type = 'CAPITAL_TYPE'
1017: AND lookup_code = p_event_type;
1018:
1019: --Add one to get the next event number

Line 1505: FROM pa_lookups

1501:
1502: --Get the Capital Type meaning
1503: SELECT meaning
1504: INTO v_capital_type
1505: FROM pa_lookups
1506: WHERE lookup_type = 'CAPITAL_TYPE'
1507: AND lookup_code = p_event_type;
1508:
1509: --Add one to get the next event number