82: l_wip_job_rec.maintenance_object_source := 2; -- for 'AHL'
83: l_wip_job_rec.maintenance_object_type := 3; -- for 'CII'
84: l_wip_job_rec.creation_date := SYSDATE;
85: l_wip_job_rec.last_update_date := SYSDATE;
86: l_wip_job_rec.created_by := fnd_global.user_id;
87: l_wip_job_rec.last_updated_by := fnd_global.user_id;
88: l_wip_job_rec.last_update_login := fnd_global.login_id;
89: --l_wip_job_rec.last_updated_login := fnd_global.conc_login_id;
90: l_wip_job_rec.request_id := fnd_global.conc_request_id;
83: l_wip_job_rec.maintenance_object_type := 3; -- for 'CII'
84: l_wip_job_rec.creation_date := SYSDATE;
85: l_wip_job_rec.last_update_date := SYSDATE;
86: l_wip_job_rec.created_by := fnd_global.user_id;
87: l_wip_job_rec.last_updated_by := fnd_global.user_id;
88: l_wip_job_rec.last_update_login := fnd_global.login_id;
89: --l_wip_job_rec.last_updated_login := fnd_global.conc_login_id;
90: l_wip_job_rec.request_id := fnd_global.conc_request_id;
91: l_wip_job_rec.program_id := fnd_global.conc_program_id;
84: l_wip_job_rec.creation_date := SYSDATE;
85: l_wip_job_rec.last_update_date := SYSDATE;
86: l_wip_job_rec.created_by := fnd_global.user_id;
87: l_wip_job_rec.last_updated_by := fnd_global.user_id;
88: l_wip_job_rec.last_update_login := fnd_global.login_id;
89: --l_wip_job_rec.last_updated_login := fnd_global.conc_login_id;
90: l_wip_job_rec.request_id := fnd_global.conc_request_id;
91: l_wip_job_rec.program_id := fnd_global.conc_program_id;
92: l_wip_job_rec.program_application_id := fnd_global.prog_appl_id;
85: l_wip_job_rec.last_update_date := SYSDATE;
86: l_wip_job_rec.created_by := fnd_global.user_id;
87: l_wip_job_rec.last_updated_by := fnd_global.user_id;
88: l_wip_job_rec.last_update_login := fnd_global.login_id;
89: --l_wip_job_rec.last_updated_login := fnd_global.conc_login_id;
90: l_wip_job_rec.request_id := fnd_global.conc_request_id;
91: l_wip_job_rec.program_id := fnd_global.conc_program_id;
92: l_wip_job_rec.program_application_id := fnd_global.prog_appl_id;
93:
86: l_wip_job_rec.created_by := fnd_global.user_id;
87: l_wip_job_rec.last_updated_by := fnd_global.user_id;
88: l_wip_job_rec.last_update_login := fnd_global.login_id;
89: --l_wip_job_rec.last_updated_login := fnd_global.conc_login_id;
90: l_wip_job_rec.request_id := fnd_global.conc_request_id;
91: l_wip_job_rec.program_id := fnd_global.conc_program_id;
92: l_wip_job_rec.program_application_id := fnd_global.prog_appl_id;
93:
94: IF p_ahl_wo_rec.dml_type = 'I' THEN
87: l_wip_job_rec.last_updated_by := fnd_global.user_id;
88: l_wip_job_rec.last_update_login := fnd_global.login_id;
89: --l_wip_job_rec.last_updated_login := fnd_global.conc_login_id;
90: l_wip_job_rec.request_id := fnd_global.conc_request_id;
91: l_wip_job_rec.program_id := fnd_global.conc_program_id;
92: l_wip_job_rec.program_application_id := fnd_global.prog_appl_id;
93:
94: IF p_ahl_wo_rec.dml_type = 'I' THEN
95: l_wip_job_rec.load_type := 7; --create job
88: l_wip_job_rec.last_update_login := fnd_global.login_id;
89: --l_wip_job_rec.last_updated_login := fnd_global.conc_login_id;
90: l_wip_job_rec.request_id := fnd_global.conc_request_id;
91: l_wip_job_rec.program_id := fnd_global.conc_program_id;
92: l_wip_job_rec.program_application_id := fnd_global.prog_appl_id;
93:
94: IF p_ahl_wo_rec.dml_type = 'I' THEN
95: l_wip_job_rec.load_type := 7; --create job
96: ELSIF p_ahl_wo_rec.dml_type = 'U' THEN
304: l_wip_job_op_rec.group_id := p_group_id;
305: l_wip_job_op_rec.parent_header_id := p_parent_header_id;
306: l_wip_job_op_rec.creation_date := SYSDATE;
307: l_wip_job_op_rec.last_update_date := SYSDATE;
308: l_wip_job_op_rec.created_by := fnd_global.user_id;
309: l_wip_job_op_rec.last_updated_by := fnd_global.user_id;
310: l_wip_job_op_rec.last_update_login := fnd_global.login_id;
311: --l_wip_job_op_rec.last_updated_login := fnd_global.conc_login_id;
312: l_wip_job_op_rec.request_id := fnd_global.conc_request_id;
305: l_wip_job_op_rec.parent_header_id := p_parent_header_id;
306: l_wip_job_op_rec.creation_date := SYSDATE;
307: l_wip_job_op_rec.last_update_date := SYSDATE;
308: l_wip_job_op_rec.created_by := fnd_global.user_id;
309: l_wip_job_op_rec.last_updated_by := fnd_global.user_id;
310: l_wip_job_op_rec.last_update_login := fnd_global.login_id;
311: --l_wip_job_op_rec.last_updated_login := fnd_global.conc_login_id;
312: l_wip_job_op_rec.request_id := fnd_global.conc_request_id;
313: l_wip_job_op_rec.program_id := fnd_global.conc_program_id;
306: l_wip_job_op_rec.creation_date := SYSDATE;
307: l_wip_job_op_rec.last_update_date := SYSDATE;
308: l_wip_job_op_rec.created_by := fnd_global.user_id;
309: l_wip_job_op_rec.last_updated_by := fnd_global.user_id;
310: l_wip_job_op_rec.last_update_login := fnd_global.login_id;
311: --l_wip_job_op_rec.last_updated_login := fnd_global.conc_login_id;
312: l_wip_job_op_rec.request_id := fnd_global.conc_request_id;
313: l_wip_job_op_rec.program_id := fnd_global.conc_program_id;
314: l_wip_job_op_rec.program_application_id := fnd_global.prog_appl_id;
307: l_wip_job_op_rec.last_update_date := SYSDATE;
308: l_wip_job_op_rec.created_by := fnd_global.user_id;
309: l_wip_job_op_rec.last_updated_by := fnd_global.user_id;
310: l_wip_job_op_rec.last_update_login := fnd_global.login_id;
311: --l_wip_job_op_rec.last_updated_login := fnd_global.conc_login_id;
312: l_wip_job_op_rec.request_id := fnd_global.conc_request_id;
313: l_wip_job_op_rec.program_id := fnd_global.conc_program_id;
314: l_wip_job_op_rec.program_application_id := fnd_global.prog_appl_id;
315:
308: l_wip_job_op_rec.created_by := fnd_global.user_id;
309: l_wip_job_op_rec.last_updated_by := fnd_global.user_id;
310: l_wip_job_op_rec.last_update_login := fnd_global.login_id;
311: --l_wip_job_op_rec.last_updated_login := fnd_global.conc_login_id;
312: l_wip_job_op_rec.request_id := fnd_global.conc_request_id;
313: l_wip_job_op_rec.program_id := fnd_global.conc_program_id;
314: l_wip_job_op_rec.program_application_id := fnd_global.prog_appl_id;
315:
316: IF p_ahl_wo_op_rec.dml_type = 'I' THEN
309: l_wip_job_op_rec.last_updated_by := fnd_global.user_id;
310: l_wip_job_op_rec.last_update_login := fnd_global.login_id;
311: --l_wip_job_op_rec.last_updated_login := fnd_global.conc_login_id;
312: l_wip_job_op_rec.request_id := fnd_global.conc_request_id;
313: l_wip_job_op_rec.program_id := fnd_global.conc_program_id;
314: l_wip_job_op_rec.program_application_id := fnd_global.prog_appl_id;
315:
316: IF p_ahl_wo_op_rec.dml_type = 'I' THEN
317: l_wip_job_op_rec.substitution_type := 2; --add operation
310: l_wip_job_op_rec.last_update_login := fnd_global.login_id;
311: --l_wip_job_op_rec.last_updated_login := fnd_global.conc_login_id;
312: l_wip_job_op_rec.request_id := fnd_global.conc_request_id;
313: l_wip_job_op_rec.program_id := fnd_global.conc_program_id;
314: l_wip_job_op_rec.program_application_id := fnd_global.prog_appl_id;
315:
316: IF p_ahl_wo_op_rec.dml_type = 'I' THEN
317: l_wip_job_op_rec.substitution_type := 2; --add operation
318: ELSIF p_ahl_wo_op_rec.dml_type = 'U' THEN
452: l_wip_job_res_rec.group_id := p_group_id;
453: l_wip_job_res_rec.parent_header_id := p_parent_header_id;
454: l_wip_job_res_rec.creation_date := SYSDATE;
455: l_wip_job_res_rec.last_update_date := SYSDATE;
456: l_wip_job_res_rec.created_by := fnd_global.user_id;
457: l_wip_job_res_rec.last_updated_by := fnd_global.user_id;
458: l_wip_job_res_rec.last_update_login := fnd_global.login_id;
459: --l_wip_job_res_rec.last_updated_login := fnd_global.conc_login_id;
460: l_wip_job_res_rec.request_id := fnd_global.conc_request_id;
453: l_wip_job_res_rec.parent_header_id := p_parent_header_id;
454: l_wip_job_res_rec.creation_date := SYSDATE;
455: l_wip_job_res_rec.last_update_date := SYSDATE;
456: l_wip_job_res_rec.created_by := fnd_global.user_id;
457: l_wip_job_res_rec.last_updated_by := fnd_global.user_id;
458: l_wip_job_res_rec.last_update_login := fnd_global.login_id;
459: --l_wip_job_res_rec.last_updated_login := fnd_global.conc_login_id;
460: l_wip_job_res_rec.request_id := fnd_global.conc_request_id;
461: l_wip_job_res_rec.program_id := fnd_global.conc_program_id;
454: l_wip_job_res_rec.creation_date := SYSDATE;
455: l_wip_job_res_rec.last_update_date := SYSDATE;
456: l_wip_job_res_rec.created_by := fnd_global.user_id;
457: l_wip_job_res_rec.last_updated_by := fnd_global.user_id;
458: l_wip_job_res_rec.last_update_login := fnd_global.login_id;
459: --l_wip_job_res_rec.last_updated_login := fnd_global.conc_login_id;
460: l_wip_job_res_rec.request_id := fnd_global.conc_request_id;
461: l_wip_job_res_rec.program_id := fnd_global.conc_program_id;
462: l_wip_job_res_rec.program_application_id := fnd_global.prog_appl_id;
455: l_wip_job_res_rec.last_update_date := SYSDATE;
456: l_wip_job_res_rec.created_by := fnd_global.user_id;
457: l_wip_job_res_rec.last_updated_by := fnd_global.user_id;
458: l_wip_job_res_rec.last_update_login := fnd_global.login_id;
459: --l_wip_job_res_rec.last_updated_login := fnd_global.conc_login_id;
460: l_wip_job_res_rec.request_id := fnd_global.conc_request_id;
461: l_wip_job_res_rec.program_id := fnd_global.conc_program_id;
462: l_wip_job_res_rec.program_application_id := fnd_global.prog_appl_id;
463:
456: l_wip_job_res_rec.created_by := fnd_global.user_id;
457: l_wip_job_res_rec.last_updated_by := fnd_global.user_id;
458: l_wip_job_res_rec.last_update_login := fnd_global.login_id;
459: --l_wip_job_res_rec.last_updated_login := fnd_global.conc_login_id;
460: l_wip_job_res_rec.request_id := fnd_global.conc_request_id;
461: l_wip_job_res_rec.program_id := fnd_global.conc_program_id;
462: l_wip_job_res_rec.program_application_id := fnd_global.prog_appl_id;
463:
464: IF p_ahl_wo_res_rec.dml_type = 'I' THEN
457: l_wip_job_res_rec.last_updated_by := fnd_global.user_id;
458: l_wip_job_res_rec.last_update_login := fnd_global.login_id;
459: --l_wip_job_res_rec.last_updated_login := fnd_global.conc_login_id;
460: l_wip_job_res_rec.request_id := fnd_global.conc_request_id;
461: l_wip_job_res_rec.program_id := fnd_global.conc_program_id;
462: l_wip_job_res_rec.program_application_id := fnd_global.prog_appl_id;
463:
464: IF p_ahl_wo_res_rec.dml_type = 'I' THEN
465: l_wip_job_res_rec.substitution_type := 2; --add resource
458: l_wip_job_res_rec.last_update_login := fnd_global.login_id;
459: --l_wip_job_res_rec.last_updated_login := fnd_global.conc_login_id;
460: l_wip_job_res_rec.request_id := fnd_global.conc_request_id;
461: l_wip_job_res_rec.program_id := fnd_global.conc_program_id;
462: l_wip_job_res_rec.program_application_id := fnd_global.prog_appl_id;
463:
464: IF p_ahl_wo_res_rec.dml_type = 'I' THEN
465: l_wip_job_res_rec.substitution_type := 2; --add resource
466: ELSIF p_ahl_wo_res_rec.dml_type = 'U' THEN
621: l_wip_job_mtl_rec.group_id := p_group_id;
622: l_wip_job_mtl_rec.parent_header_id := p_parent_header_id;
623: l_wip_job_mtl_rec.creation_date := SYSDATE;
624: l_wip_job_mtl_rec.last_update_date := SYSDATE;
625: l_wip_job_mtl_rec.created_by := fnd_global.user_id;
626: l_wip_job_mtl_rec.last_updated_by := fnd_global.user_id;
627: l_wip_job_mtl_rec.last_update_login := fnd_global.login_id;
628: --l_wip_job_mtl_rec.last_updated_login := fnd_global.conc_login_id;
629: l_wip_job_mtl_rec.request_id := fnd_global.conc_request_id;
622: l_wip_job_mtl_rec.parent_header_id := p_parent_header_id;
623: l_wip_job_mtl_rec.creation_date := SYSDATE;
624: l_wip_job_mtl_rec.last_update_date := SYSDATE;
625: l_wip_job_mtl_rec.created_by := fnd_global.user_id;
626: l_wip_job_mtl_rec.last_updated_by := fnd_global.user_id;
627: l_wip_job_mtl_rec.last_update_login := fnd_global.login_id;
628: --l_wip_job_mtl_rec.last_updated_login := fnd_global.conc_login_id;
629: l_wip_job_mtl_rec.request_id := fnd_global.conc_request_id;
630: l_wip_job_mtl_rec.program_id := fnd_global.conc_program_id;
623: l_wip_job_mtl_rec.creation_date := SYSDATE;
624: l_wip_job_mtl_rec.last_update_date := SYSDATE;
625: l_wip_job_mtl_rec.created_by := fnd_global.user_id;
626: l_wip_job_mtl_rec.last_updated_by := fnd_global.user_id;
627: l_wip_job_mtl_rec.last_update_login := fnd_global.login_id;
628: --l_wip_job_mtl_rec.last_updated_login := fnd_global.conc_login_id;
629: l_wip_job_mtl_rec.request_id := fnd_global.conc_request_id;
630: l_wip_job_mtl_rec.program_id := fnd_global.conc_program_id;
631: l_wip_job_mtl_rec.program_application_id := fnd_global.prog_appl_id;
624: l_wip_job_mtl_rec.last_update_date := SYSDATE;
625: l_wip_job_mtl_rec.created_by := fnd_global.user_id;
626: l_wip_job_mtl_rec.last_updated_by := fnd_global.user_id;
627: l_wip_job_mtl_rec.last_update_login := fnd_global.login_id;
628: --l_wip_job_mtl_rec.last_updated_login := fnd_global.conc_login_id;
629: l_wip_job_mtl_rec.request_id := fnd_global.conc_request_id;
630: l_wip_job_mtl_rec.program_id := fnd_global.conc_program_id;
631: l_wip_job_mtl_rec.program_application_id := fnd_global.prog_appl_id;
632:
625: l_wip_job_mtl_rec.created_by := fnd_global.user_id;
626: l_wip_job_mtl_rec.last_updated_by := fnd_global.user_id;
627: l_wip_job_mtl_rec.last_update_login := fnd_global.login_id;
628: --l_wip_job_mtl_rec.last_updated_login := fnd_global.conc_login_id;
629: l_wip_job_mtl_rec.request_id := fnd_global.conc_request_id;
630: l_wip_job_mtl_rec.program_id := fnd_global.conc_program_id;
631: l_wip_job_mtl_rec.program_application_id := fnd_global.prog_appl_id;
632:
633: IF p_ahl_wo_mtl_rec.dml_type = 'I' THEN
626: l_wip_job_mtl_rec.last_updated_by := fnd_global.user_id;
627: l_wip_job_mtl_rec.last_update_login := fnd_global.login_id;
628: --l_wip_job_mtl_rec.last_updated_login := fnd_global.conc_login_id;
629: l_wip_job_mtl_rec.request_id := fnd_global.conc_request_id;
630: l_wip_job_mtl_rec.program_id := fnd_global.conc_program_id;
631: l_wip_job_mtl_rec.program_application_id := fnd_global.prog_appl_id;
632:
633: IF p_ahl_wo_mtl_rec.dml_type = 'I' THEN
634: l_wip_job_mtl_rec.substitution_type := 2; --add materila
627: l_wip_job_mtl_rec.last_update_login := fnd_global.login_id;
628: --l_wip_job_mtl_rec.last_updated_login := fnd_global.conc_login_id;
629: l_wip_job_mtl_rec.request_id := fnd_global.conc_request_id;
630: l_wip_job_mtl_rec.program_id := fnd_global.conc_program_id;
631: l_wip_job_mtl_rec.program_application_id := fnd_global.prog_appl_id;
632:
633: IF p_ahl_wo_mtl_rec.dml_type = 'I' THEN
634: l_wip_job_mtl_rec.substitution_type := 2; --add materila
635: ELSIF p_ahl_wo_mtl_rec.dml_type = 'U' THEN
812: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
813: IF G_DEBUG='Y' THEN
814: AHL_DEBUG_PUB.debug('Submit request itself failed and the initialized parameters for the application are: ');
815: --dbms_output.put_line('Submit request itself failed and the initialized parameters for the application are: ');
816: AHL_DEBUG_PUB.debug('user_id='||to_char(fnd_global.user_id)||' resp_id='||to_char(fnd_global.resp_id)||' resp_appl_id='||to_char(fnd_global.resp_appl_id));
817: --dbms_output.put_line('user_id='||to_char(fnd_global.user_id)||' resp_id='||to_char(fnd_global.resp_id)||' resp_appl_id='||to_char(fnd_global.resp_appl_id));
818: AHL_DEBUG_PUB.debug('user_name='||fnd_global.user_name||' resp_name='||fnd_global.resp_name||' application_name='||fnd_global.application_name);
819: --dbms_output.put_line('user_name='||fnd_global.user_name||' resp_name='||fnd_global.resp_name||' application_name='||fnd_global.application_name);
820: END IF;
813: IF G_DEBUG='Y' THEN
814: AHL_DEBUG_PUB.debug('Submit request itself failed and the initialized parameters for the application are: ');
815: --dbms_output.put_line('Submit request itself failed and the initialized parameters for the application are: ');
816: AHL_DEBUG_PUB.debug('user_id='||to_char(fnd_global.user_id)||' resp_id='||to_char(fnd_global.resp_id)||' resp_appl_id='||to_char(fnd_global.resp_appl_id));
817: --dbms_output.put_line('user_id='||to_char(fnd_global.user_id)||' resp_id='||to_char(fnd_global.resp_id)||' resp_appl_id='||to_char(fnd_global.resp_appl_id));
818: AHL_DEBUG_PUB.debug('user_name='||fnd_global.user_name||' resp_name='||fnd_global.resp_name||' application_name='||fnd_global.application_name);
819: --dbms_output.put_line('user_name='||fnd_global.user_name||' resp_name='||fnd_global.resp_name||' application_name='||fnd_global.application_name);
820: END IF;
821: ELSE
814: AHL_DEBUG_PUB.debug('Submit request itself failed and the initialized parameters for the application are: ');
815: --dbms_output.put_line('Submit request itself failed and the initialized parameters for the application are: ');
816: AHL_DEBUG_PUB.debug('user_id='||to_char(fnd_global.user_id)||' resp_id='||to_char(fnd_global.resp_id)||' resp_appl_id='||to_char(fnd_global.resp_appl_id));
817: --dbms_output.put_line('user_id='||to_char(fnd_global.user_id)||' resp_id='||to_char(fnd_global.resp_id)||' resp_appl_id='||to_char(fnd_global.resp_appl_id));
818: AHL_DEBUG_PUB.debug('user_name='||fnd_global.user_name||' resp_name='||fnd_global.resp_name||' application_name='||fnd_global.application_name);
819: --dbms_output.put_line('user_name='||fnd_global.user_name||' resp_name='||fnd_global.resp_name||' application_name='||fnd_global.application_name);
820: END IF;
821: ELSE
822: COMMIT; --This commit is a must;
815: --dbms_output.put_line('Submit request itself failed and the initialized parameters for the application are: ');
816: AHL_DEBUG_PUB.debug('user_id='||to_char(fnd_global.user_id)||' resp_id='||to_char(fnd_global.resp_id)||' resp_appl_id='||to_char(fnd_global.resp_appl_id));
817: --dbms_output.put_line('user_id='||to_char(fnd_global.user_id)||' resp_id='||to_char(fnd_global.resp_id)||' resp_appl_id='||to_char(fnd_global.resp_appl_id));
818: AHL_DEBUG_PUB.debug('user_name='||fnd_global.user_name||' resp_name='||fnd_global.resp_name||' application_name='||fnd_global.application_name);
819: --dbms_output.put_line('user_name='||fnd_global.user_name||' resp_name='||fnd_global.resp_name||' application_name='||fnd_global.application_name);
820: END IF;
821: ELSE
822: COMMIT; --This commit is a must;
823: IF G_DEBUG='Y' THEN
1271: FND_MSG_PUB.add;
1272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1273: END IF;
1274:
1275: OPEN get_user_name(fnd_global.user_id);
1276: FETCH get_user_name INTO l_user_name;
1277: IF get_user_name%NOTFOUND THEN
1278: FND_MESSAGE.set_name('AHL','AHL_PRD_USER_ID_INVALID');
1279: FND_MSG_PUB.add;
1312: l_wip_cost_txn_rec.source_code := 'Service';
1313:
1314: l_wip_cost_txn_rec.creation_date := sysdate;
1315: l_wip_cost_txn_rec.last_update_date := sysdate;
1316: l_wip_cost_txn_rec.created_by := fnd_global.user_id;
1317: --created_by_name is mandatory, otherwise Cost Manager won't pick it up.
1318: l_wip_cost_txn_rec.created_by_name := l_user_name.user_name;
1319: l_wip_cost_txn_rec.last_updated_by := fnd_global.user_id;
1320: --last_updated_by_name is mandatory, otherwise Cost Manager won't pick it up.
1315: l_wip_cost_txn_rec.last_update_date := sysdate;
1316: l_wip_cost_txn_rec.created_by := fnd_global.user_id;
1317: --created_by_name is mandatory, otherwise Cost Manager won't pick it up.
1318: l_wip_cost_txn_rec.created_by_name := l_user_name.user_name;
1319: l_wip_cost_txn_rec.last_updated_by := fnd_global.user_id;
1320: --last_updated_by_name is mandatory, otherwise Cost Manager won't pick it up.
1321: l_wip_cost_txn_rec.last_updated_by_name := l_user_name.user_name;
1322: l_wip_cost_txn_rec.last_update_login := fnd_global.login_id;
1323: --l_wip_cost_txn_rec.last_updated_login := fnd_global.conc_login_id;
1318: l_wip_cost_txn_rec.created_by_name := l_user_name.user_name;
1319: l_wip_cost_txn_rec.last_updated_by := fnd_global.user_id;
1320: --last_updated_by_name is mandatory, otherwise Cost Manager won't pick it up.
1321: l_wip_cost_txn_rec.last_updated_by_name := l_user_name.user_name;
1322: l_wip_cost_txn_rec.last_update_login := fnd_global.login_id;
1323: --l_wip_cost_txn_rec.last_updated_login := fnd_global.conc_login_id;
1324: l_wip_cost_txn_rec.request_id := fnd_global.conc_request_id;
1325: l_wip_cost_txn_rec.program_id := fnd_global.conc_program_id;
1326: l_wip_cost_txn_rec.program_application_id := fnd_global.prog_appl_id;
1319: l_wip_cost_txn_rec.last_updated_by := fnd_global.user_id;
1320: --last_updated_by_name is mandatory, otherwise Cost Manager won't pick it up.
1321: l_wip_cost_txn_rec.last_updated_by_name := l_user_name.user_name;
1322: l_wip_cost_txn_rec.last_update_login := fnd_global.login_id;
1323: --l_wip_cost_txn_rec.last_updated_login := fnd_global.conc_login_id;
1324: l_wip_cost_txn_rec.request_id := fnd_global.conc_request_id;
1325: l_wip_cost_txn_rec.program_id := fnd_global.conc_program_id;
1326: l_wip_cost_txn_rec.program_application_id := fnd_global.prog_appl_id;
1327:
1320: --last_updated_by_name is mandatory, otherwise Cost Manager won't pick it up.
1321: l_wip_cost_txn_rec.last_updated_by_name := l_user_name.user_name;
1322: l_wip_cost_txn_rec.last_update_login := fnd_global.login_id;
1323: --l_wip_cost_txn_rec.last_updated_login := fnd_global.conc_login_id;
1324: l_wip_cost_txn_rec.request_id := fnd_global.conc_request_id;
1325: l_wip_cost_txn_rec.program_id := fnd_global.conc_program_id;
1326: l_wip_cost_txn_rec.program_application_id := fnd_global.prog_appl_id;
1327:
1328: l_wip_cost_txn_rec.wip_entity_id := p_ahl_res_txn_tbl(i).wip_entity_id;
1321: l_wip_cost_txn_rec.last_updated_by_name := l_user_name.user_name;
1322: l_wip_cost_txn_rec.last_update_login := fnd_global.login_id;
1323: --l_wip_cost_txn_rec.last_updated_login := fnd_global.conc_login_id;
1324: l_wip_cost_txn_rec.request_id := fnd_global.conc_request_id;
1325: l_wip_cost_txn_rec.program_id := fnd_global.conc_program_id;
1326: l_wip_cost_txn_rec.program_application_id := fnd_global.prog_appl_id;
1327:
1328: l_wip_cost_txn_rec.wip_entity_id := p_ahl_res_txn_tbl(i).wip_entity_id;
1329: --wip_entity_name and entity_type are mandatory, otherwise Cost Manager won't pick it up.
1322: l_wip_cost_txn_rec.last_update_login := fnd_global.login_id;
1323: --l_wip_cost_txn_rec.last_updated_login := fnd_global.conc_login_id;
1324: l_wip_cost_txn_rec.request_id := fnd_global.conc_request_id;
1325: l_wip_cost_txn_rec.program_id := fnd_global.conc_program_id;
1326: l_wip_cost_txn_rec.program_application_id := fnd_global.prog_appl_id;
1327:
1328: l_wip_cost_txn_rec.wip_entity_id := p_ahl_res_txn_tbl(i).wip_entity_id;
1329: --wip_entity_name and entity_type are mandatory, otherwise Cost Manager won't pick it up.
1330: l_wip_cost_txn_rec.wip_entity_name := l_job_attr.wip_entity_name;