348:
349: l_estimate_rec EAM_EST_DATASTRUCTURES_PUB.EAM_CONSTRUCTION_ESTIMATE_REC;
350: l_parent_ce_wo_line_rec EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_REC;
351: l_creation_date DATE := SYSDATE;
352: l_created_by NUMBER := FND_GLOBAL.USER_ID;
353: l_last_updated_date DATE := SYSDATE;
354: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
355: l_last_updated_login NUMBER;
356: l_wo_line_id_seq NUMBER;
350: l_parent_ce_wo_line_rec EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_REC;
351: l_creation_date DATE := SYSDATE;
352: l_created_by NUMBER := FND_GLOBAL.USER_ID;
353: l_last_updated_date DATE := SYSDATE;
354: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
355: l_last_updated_login NUMBER;
356: l_wo_line_id_seq NUMBER;
357: l_parent_wo_num NUMBER;
358:
506: ,p_di_auto_request_material => FND_API.G_MISS_CHAR
507: ,p_di_need_by_date => FND_API.G_MISS_DATE
508: ,p_work_order_line_cost => FND_API.G_MISS_NUM
509: ,p_creation_date => sysdate
510: ,p_created_by => FND_GLOBAL.LOGIN_ID
511: ,p_last_update_date => sysdate
512: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID
513: ,p_last_update_login => FND_GLOBAL.LOGIN_ID
514: ,p_work_order_type => FND_API.G_MISS_NUM
508: ,p_work_order_line_cost => FND_API.G_MISS_NUM
509: ,p_creation_date => sysdate
510: ,p_created_by => FND_GLOBAL.LOGIN_ID
511: ,p_last_update_date => sysdate
512: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID
513: ,p_last_update_login => FND_GLOBAL.LOGIN_ID
514: ,p_work_order_type => FND_API.G_MISS_NUM
515: ,p_activity_type => FND_API.G_MISS_NUM
516: ,p_activity_source => FND_API.G_MISS_NUM
509: ,p_creation_date => sysdate
510: ,p_created_by => FND_GLOBAL.LOGIN_ID
511: ,p_last_update_date => sysdate
512: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID
513: ,p_last_update_login => FND_GLOBAL.LOGIN_ID
514: ,p_work_order_type => FND_API.G_MISS_NUM
515: ,p_activity_type => FND_API.G_MISS_NUM
516: ,p_activity_source => FND_API.G_MISS_NUM
517: ,p_activity_cause => FND_API.G_MISS_NUM
587: ,p_di_auto_request_material => FND_API.G_MISS_CHAR
588: ,p_di_need_by_date => FND_API.G_MISS_DATE
589: ,p_work_order_line_cost => FND_API.G_MISS_NUM
590: ,p_creation_date => sysdate
591: ,p_created_by => FND_GLOBAL.LOGIN_ID
592: ,p_last_update_date => sysdate
593: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID
594: ,p_last_update_login => FND_GLOBAL.LOGIN_ID
595: ,p_work_order_type => FND_API.G_MISS_NUM
589: ,p_work_order_line_cost => FND_API.G_MISS_NUM
590: ,p_creation_date => sysdate
591: ,p_created_by => FND_GLOBAL.LOGIN_ID
592: ,p_last_update_date => sysdate
593: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID
594: ,p_last_update_login => FND_GLOBAL.LOGIN_ID
595: ,p_work_order_type => FND_API.G_MISS_NUM
596: ,p_activity_type => FND_API.G_MISS_NUM
597: ,p_activity_source => FND_API.G_MISS_NUM
590: ,p_creation_date => sysdate
591: ,p_created_by => FND_GLOBAL.LOGIN_ID
592: ,p_last_update_date => sysdate
593: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID
594: ,p_last_update_login => FND_GLOBAL.LOGIN_ID
595: ,p_work_order_type => FND_API.G_MISS_NUM
596: ,p_activity_type => FND_API.G_MISS_NUM
597: ,p_activity_source => FND_API.G_MISS_NUM
598: ,p_activity_cause => FND_API.G_MISS_NUM
948: ,p_di_auto_request_material => NULL
949: ,p_di_need_by_date => NULL
950: ,p_work_order_line_cost => l_unit_cost
951: ,p_creation_date => sysdate
952: ,p_created_by => FND_GLOBAL.LOGIN_ID
953: ,p_last_update_date => sysdate
954: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID
955: ,p_last_update_login => FND_GLOBAL.LOGIN_ID
956: ,p_work_order_type => NULL
950: ,p_work_order_line_cost => l_unit_cost
951: ,p_creation_date => sysdate
952: ,p_created_by => FND_GLOBAL.LOGIN_ID
953: ,p_last_update_date => sysdate
954: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID
955: ,p_last_update_login => FND_GLOBAL.LOGIN_ID
956: ,p_work_order_type => NULL
957: ,p_activity_type => NULL
958: ,p_activity_source => NULL
951: ,p_creation_date => sysdate
952: ,p_created_by => FND_GLOBAL.LOGIN_ID
953: ,p_last_update_date => sysdate
954: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID
955: ,p_last_update_login => FND_GLOBAL.LOGIN_ID
956: ,p_work_order_type => NULL
957: ,p_activity_type => NULL
958: ,p_activity_source => NULL
959: ,p_activity_cause => NULL
1188: ,p_di_auto_request_material => p_eam_ce_wo_lines_tbl(l_ce_tab_index).DI_AUTO_REQUEST_MATERIAL
1189: ,p_di_need_by_date => p_eam_ce_wo_lines_tbl(l_ce_tab_index).DI_NEED_BY_DATE
1190: ,p_work_order_line_cost => l_unit_cost
1191: ,p_creation_date => sysdate
1192: ,p_created_by => FND_GLOBAL.LOGIN_ID
1193: ,p_last_update_date => sysdate
1194: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID
1195: ,p_last_update_login => FND_GLOBAL.LOGIN_ID
1196: ,p_work_order_type => p_eam_ce_wo_lines_tbl(l_ce_tab_index).WORK_ORDER_TYPE
1190: ,p_work_order_line_cost => l_unit_cost
1191: ,p_creation_date => sysdate
1192: ,p_created_by => FND_GLOBAL.LOGIN_ID
1193: ,p_last_update_date => sysdate
1194: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID
1195: ,p_last_update_login => FND_GLOBAL.LOGIN_ID
1196: ,p_work_order_type => p_eam_ce_wo_lines_tbl(l_ce_tab_index).WORK_ORDER_TYPE
1197: ,p_activity_type => p_eam_ce_wo_lines_tbl(l_ce_tab_index).ACTIVITY_TYPE
1198: ,p_activity_source => p_eam_ce_wo_lines_tbl(l_ce_tab_index).ACTIVITY_SOURCE
1191: ,p_creation_date => sysdate
1192: ,p_created_by => FND_GLOBAL.LOGIN_ID
1193: ,p_last_update_date => sysdate
1194: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID
1195: ,p_last_update_login => FND_GLOBAL.LOGIN_ID
1196: ,p_work_order_type => p_eam_ce_wo_lines_tbl(l_ce_tab_index).WORK_ORDER_TYPE
1197: ,p_activity_type => p_eam_ce_wo_lines_tbl(l_ce_tab_index).ACTIVITY_TYPE
1198: ,p_activity_source => p_eam_ce_wo_lines_tbl(l_ce_tab_index).ACTIVITY_SOURCE
1199: ,p_activity_cause => p_eam_ce_wo_lines_tbl(l_ce_tab_index).ACTIVITY_CAUSE
1301: ,p_di_auto_request_material => p_eam_ce_wo_lines_tbl(l_ce_tab_index).DI_AUTO_REQUEST_MATERIAL
1302: ,p_di_need_by_date => p_eam_ce_wo_lines_tbl(l_ce_tab_index).DI_NEED_BY_DATE
1303: ,p_work_order_line_cost => l_unit_cost
1304: ,p_creation_date => sysdate
1305: ,p_created_by => FND_GLOBAL.LOGIN_ID
1306: ,p_last_update_date => sysdate
1307: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID
1308: ,p_last_update_login => FND_GLOBAL.LOGIN_ID
1309: ,p_work_order_type => p_eam_ce_wo_lines_tbl(l_ce_tab_index).WORK_ORDER_TYPE
1303: ,p_work_order_line_cost => l_unit_cost
1304: ,p_creation_date => sysdate
1305: ,p_created_by => FND_GLOBAL.LOGIN_ID
1306: ,p_last_update_date => sysdate
1307: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID
1308: ,p_last_update_login => FND_GLOBAL.LOGIN_ID
1309: ,p_work_order_type => p_eam_ce_wo_lines_tbl(l_ce_tab_index).WORK_ORDER_TYPE
1310: ,p_activity_type => p_eam_ce_wo_lines_tbl(l_ce_tab_index).ACTIVITY_TYPE
1311: ,p_activity_source => p_eam_ce_wo_lines_tbl(l_ce_tab_index).ACTIVITY_SOURCE
1304: ,p_creation_date => sysdate
1305: ,p_created_by => FND_GLOBAL.LOGIN_ID
1306: ,p_last_update_date => sysdate
1307: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID
1308: ,p_last_update_login => FND_GLOBAL.LOGIN_ID
1309: ,p_work_order_type => p_eam_ce_wo_lines_tbl(l_ce_tab_index).WORK_ORDER_TYPE
1310: ,p_activity_type => p_eam_ce_wo_lines_tbl(l_ce_tab_index).ACTIVITY_TYPE
1311: ,p_activity_source => p_eam_ce_wo_lines_tbl(l_ce_tab_index).ACTIVITY_SOURCE
1312: ,p_activity_cause => p_eam_ce_wo_lines_tbl(l_ce_tab_index).ACTIVITY_CAUSE
2205: l_api_version CONSTANT NUMBER := 1.0;
2206: l_debug_filename VARCHAR(50) := G_DEBUG_FILENAME;
2207: l_debug VARCHAR2(1) := 'N';
2208: l_creation_date DATE := SYSDATE;
2209: l_created_by NUMBER := FND_GLOBAL.USER_ID;
2210: l_last_updated_date DATE := SYSDATE;
2211: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
2212: l_last_updated_login NUMBER;
2213: l_estimate_exist VARCHAR2(1) := 'N';
2207: l_debug VARCHAR2(1) := 'N';
2208: l_creation_date DATE := SYSDATE;
2209: l_created_by NUMBER := FND_GLOBAL.USER_ID;
2210: l_last_updated_date DATE := SYSDATE;
2211: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
2212: l_last_updated_login NUMBER;
2213: l_estimate_exist VARCHAR2(1) := 'N';
2214:
2215:
2366: l_api_version CONSTANT NUMBER := 1.0;
2367: l_debug_filename VARCHAR(50) := G_DEBUG_FILENAME;
2368: l_debug VARCHAR2(1) := 'N';
2369: l_creation_date DATE := SYSDATE;
2370: l_created_by NUMBER := FND_GLOBAL.USER_ID;
2371: l_last_updated_date DATE := SYSDATE;
2372: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
2373: l_last_updated_login NUMBER;
2374: l_estimate_exist VARCHAR2(1) := 'N';
2368: l_debug VARCHAR2(1) := 'N';
2369: l_creation_date DATE := SYSDATE;
2370: l_created_by NUMBER := FND_GLOBAL.USER_ID;
2371: l_last_updated_date DATE := SYSDATE;
2372: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
2373: l_last_updated_login NUMBER;
2374: l_estimate_exist VARCHAR2(1) := 'N';
2375: l_parent_creation_flag VARCHAR(1) := FND_API.G_MISS_CHAR;
2376: l_parent_wo_id NUMBER := FND_API.G_MISS_NUM;
2599: l_activity_qty NUMBER;
2600: l_difficulty_id NUMBER;
2601: l_resource_multiplier NUMBER;
2602: l_creation_date DATE := SYSDATE;
2603: l_created_by NUMBER := FND_GLOBAL.USER_ID;
2604: l_last_updated_date DATE := SYSDATE;
2605: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
2606: l_last_updated_login NUMBER;
2607: BEGIN
2601: l_resource_multiplier NUMBER;
2602: l_creation_date DATE := SYSDATE;
2603: l_created_by NUMBER := FND_GLOBAL.USER_ID;
2604: l_last_updated_date DATE := SYSDATE;
2605: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
2606: l_last_updated_login NUMBER;
2607: BEGIN
2608: SAVEPOINT SET_ACTIVITIES_FOR_CE;
2609:
3590: p_work_order_line_cost => l_ce_wo_ln_tbl(i).WORK_ORDER_LINE_COST,
3591: p_creation_date => FND_API.G_MISS_DATE,
3592: p_created_by => FND_API.G_MISS_NUM,
3593: p_last_update_date => SYSDATE,
3594: p_last_updated_by => FND_GLOBAL.USER_ID,
3595: p_last_update_login => FND_GLOBAL.USER_ID
3596: ,p_work_order_type => l_ce_wo_ln_tbl(i).WORK_ORDER_TYPE
3597: ,p_activity_type => l_ce_wo_ln_tbl(i).ACTIVITY_TYPE
3598: ,p_activity_source => l_ce_wo_ln_tbl(i).ACTIVITY_SOURCE
3591: p_creation_date => FND_API.G_MISS_DATE,
3592: p_created_by => FND_API.G_MISS_NUM,
3593: p_last_update_date => SYSDATE,
3594: p_last_updated_by => FND_GLOBAL.USER_ID,
3595: p_last_update_login => FND_GLOBAL.USER_ID
3596: ,p_work_order_type => l_ce_wo_ln_tbl(i).WORK_ORDER_TYPE
3597: ,p_activity_type => l_ce_wo_ln_tbl(i).ACTIVITY_TYPE
3598: ,p_activity_source => l_ce_wo_ln_tbl(i).ACTIVITY_SOURCE
3599: ,p_activity_cause => l_ce_wo_ln_tbl(i).ACTIVITY_CAUSE
4541: --l_eam_wo_rec.parent_wip_entity_id := p_ce_line_rec.activity_soure;
4542: l_eam_wo_rec.scheduled_start_date := nvl(p_ce_line_rec.scheduled_start_date, sysdate);
4543: l_eam_wo_rec.scheduled_completion_date := nvl(p_ce_line_rec.scheduled_completion_date, sysdate);
4544: l_eam_wo_rec.user_defined_status_id := p_ce_line_rec.user_defined_status_id;
4545: l_eam_wo_rec.user_id := fnd_global.user_id;
4546:
4547: --l_eam_wo_rec.responsibility_id := 55240; --fnd_glabal.resp_id
4548: -- Bug 10082577 - Replacing responsibility
4549: l_eam_wo_rec.responsibility_id := fnd_global.resp_id;
4545: l_eam_wo_rec.user_id := fnd_global.user_id;
4546:
4547: --l_eam_wo_rec.responsibility_id := 55240; --fnd_glabal.resp_id
4548: -- Bug 10082577 - Replacing responsibility
4549: l_eam_wo_rec.responsibility_id := fnd_global.resp_id;
4550: l_eam_wo_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_CREATE;
4551:
4552: l_stmt_num := 70;
4553: --dbms_output.put_line('PWO: 2');
4968:
4969:
4970: l_est_workorder_line_rec EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_REC;
4971: l_creation_date DATE := SYSDATE;
4972: l_created_by NUMBER := FND_GLOBAL.USER_ID;
4973: l_last_updated_date DATE := SYSDATE;
4974: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
4975: l_last_updated_login NUMBER;
4976: l_parent_estimate_wo_line_id NUMBER := 0;
4970: l_est_workorder_line_rec EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_REC;
4971: l_creation_date DATE := SYSDATE;
4972: l_created_by NUMBER := FND_GLOBAL.USER_ID;
4973: l_last_updated_date DATE := SYSDATE;
4974: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
4975: l_last_updated_login NUMBER;
4976: l_parent_estimate_wo_line_id NUMBER := 0;
4977: l_wo_line_id_seq NUMBER :=0;
4978:
5171: ,p_di_auto_request_material => l_est_workorder_line_rec.DI_AUTO_REQUEST_MATERIAL
5172: ,p_di_need_by_date => l_est_workorder_line_rec.DI_NEED_BY_DATE
5173: ,p_work_order_line_cost => l_est_workorder_line_rec.WO_LINE_PER_UNIT_COST
5174: ,p_creation_date => sysdate
5175: ,p_created_by => FND_GLOBAL.LOGIN_ID
5176: ,p_last_update_date => sysdate
5177: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID
5178: ,p_last_update_login => FND_GLOBAL.LOGIN_ID
5179: ,p_work_order_type => l_est_workorder_line_rec.WORK_ORDER_TYPE
5173: ,p_work_order_line_cost => l_est_workorder_line_rec.WO_LINE_PER_UNIT_COST
5174: ,p_creation_date => sysdate
5175: ,p_created_by => FND_GLOBAL.LOGIN_ID
5176: ,p_last_update_date => sysdate
5177: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID
5178: ,p_last_update_login => FND_GLOBAL.LOGIN_ID
5179: ,p_work_order_type => l_est_workorder_line_rec.WORK_ORDER_TYPE
5180: ,p_activity_type => l_est_workorder_line_rec.ACTIVITY_TYPE
5181: ,p_activity_source => l_est_workorder_line_rec.ACTIVITY_SOURCE
5174: ,p_creation_date => sysdate
5175: ,p_created_by => FND_GLOBAL.LOGIN_ID
5176: ,p_last_update_date => sysdate
5177: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID
5178: ,p_last_update_login => FND_GLOBAL.LOGIN_ID
5179: ,p_work_order_type => l_est_workorder_line_rec.WORK_ORDER_TYPE
5180: ,p_activity_type => l_est_workorder_line_rec.ACTIVITY_TYPE
5181: ,p_activity_source => l_est_workorder_line_rec.ACTIVITY_SOURCE
5182: ,p_activity_cause => l_est_workorder_line_rec.ACTIVITY_CAUSE
5279: ,p_di_auto_request_material => l_est_workorder_line_rec.DI_AUTO_REQUEST_MATERIAL
5280: ,p_di_need_by_date => l_est_workorder_line_rec.DI_NEED_BY_DATE
5281: ,p_work_order_line_cost => l_est_workorder_line_rec.WO_LINE_PER_UNIT_COST
5282: ,p_creation_date => sysdate
5283: ,p_created_by => FND_GLOBAL.LOGIN_ID
5284: ,p_last_update_date => sysdate
5285: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID
5286: ,p_last_update_login => FND_GLOBAL.LOGIN_ID
5287: ,p_work_order_type => l_est_workorder_line_rec.WORK_ORDER_TYPE
5281: ,p_work_order_line_cost => l_est_workorder_line_rec.WO_LINE_PER_UNIT_COST
5282: ,p_creation_date => sysdate
5283: ,p_created_by => FND_GLOBAL.LOGIN_ID
5284: ,p_last_update_date => sysdate
5285: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID
5286: ,p_last_update_login => FND_GLOBAL.LOGIN_ID
5287: ,p_work_order_type => l_est_workorder_line_rec.WORK_ORDER_TYPE
5288: ,p_activity_type => l_est_workorder_line_rec.ACTIVITY_TYPE
5289: ,p_activity_source => l_est_workorder_line_rec.ACTIVITY_SOURCE
5282: ,p_creation_date => sysdate
5283: ,p_created_by => FND_GLOBAL.LOGIN_ID
5284: ,p_last_update_date => sysdate
5285: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID
5286: ,p_last_update_login => FND_GLOBAL.LOGIN_ID
5287: ,p_work_order_type => l_est_workorder_line_rec.WORK_ORDER_TYPE
5288: ,p_activity_type => l_est_workorder_line_rec.ACTIVITY_TYPE
5289: ,p_activity_source => l_est_workorder_line_rec.ACTIVITY_SOURCE
5290: ,p_activity_cause => l_est_workorder_line_rec.ACTIVITY_CAUSE