[Home] [Help]
74: 'CE',capital_event_number||' '||event_name,
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
370: FROM pa_projects_all
371: WHERE project_id = p_project_id;
372:
373:
374: INSERT INTO pa_cap_event_creation_v
375: (request_id,
376: module,
377: context,
378: sub_context,
414: v_org_id --org_id
415: );
416:
417: ELSE
418: INSERT INTO pa_cap_event_creation_v
419: (request_id,
420: module,
421: context,
422: sub_context,
1094:
1095: ELSIF (v_asset_count = 0) AND (v_ei_count = 0) THEN
1096:
1097: --Print warning message
1098: INSERT INTO pa_cap_event_creation_v
1099: (request_id,
1100: module,
1101: context,
1102: sub_context,
1145:
1146: ELSIF (v_asset_count > 0) AND (v_ei_count = 0) THEN
1147:
1148: --Print warning message
1149: INSERT INTO pa_cap_event_creation_v
1150: (request_id,
1151: module,
1152: context,
1153: sub_context,
1195:
1196: ELSIF (v_asset_count = 0) AND (v_ei_count > 0) THEN
1197:
1198: --Print warning message
1199: INSERT INTO pa_cap_event_creation_v
1200: (request_id,
1201: module,
1202: context,
1203: sub_context,
1792: FROM pa_tasks
1793: WHERE task_id = remaining_costs_rec.task_id;
1794:
1795: --Print warning message
1796: INSERT INTO pa_cap_event_creation_v
1797: (request_id,
1798: module,
1799: context,
1800: sub_context,
1849:
1850: IF remaining_assets_rec.task_id IS NULL THEN
1851:
1852: --Print warning message
1853: INSERT INTO pa_cap_event_creation_v
1854: (request_id,
1855: module,
1856: context,
1857: sub_context,
1900:
1901: ELSIF remaining_assets_rec.task_id = 0 THEN
1902:
1903: --Print warning message
1904: INSERT INTO pa_cap_event_creation_v
1905: (request_id,
1906: module,
1907: context,
1908: sub_context,
1957: FROM pa_tasks
1958: WHERE task_id = remaining_assets_rec.task_id;
1959:
1960: --Print warning message
1961: INSERT INTO pa_cap_event_creation_v
1962: (request_id,
1963: module,
1964: context,
1965: sub_context,
2023: FETCH print_events_cur INTO print_events_rec;
2024: IF (print_events_cur%NOTFOUND) THEN
2025:
2026: --No new events were created
2027: INSERT INTO pa_cap_event_creation_v
2028: (request_id,
2029: module,
2030: context,
2031: sub_context,
2074: --Print successful event cost totals and asset listings
2075: FOR print_events_rec IN print_events_cur(v_request_id, p_project_id, p_event_type) LOOP
2076:
2077: --Print Event info
2078: INSERT INTO pa_cap_event_creation_v
2079: (request_id,
2080: module,
2081: context,
2082: sub_context,
2129: FETCH existing_events_cur INTO existing_events_rec;
2130: IF (existing_events_cur%NOTFOUND) THEN
2131:
2132: --No existing events could have had costs or assets added
2133: INSERT INTO pa_cap_event_creation_v
2134: (request_id,
2135: module,
2136: context,
2137: sub_context,
2189:
2190: v_addtl_costs_or_assets := 'Y';
2191:
2192: --Print Assets added to Event info
2193: INSERT INTO pa_cap_event_creation_v
2194: (request_id,
2195: module,
2196: context,
2197: sub_context,
2246:
2247: v_addtl_costs_or_assets := 'Y';
2248:
2249: --Print Costs added to Event info
2250: INSERT INTO pa_cap_event_creation_v
2251: (request_id,
2252: module,
2253: context,
2254: sub_context,
2299:
2300: IF v_addtl_costs_or_assets = 'N' THEN
2301:
2302: --No existing events have had costs or assets added
2303: INSERT INTO pa_cap_event_creation_v
2304: (request_id,
2305: module,
2306: context,
2307: sub_context,