DBA Data[Home] [Help]

APPS.EAM_CONSTRUCTION_EST_PVT dependencies on FND_GLOBAL

Line 333: l_created_by NUMBER := FND_GLOBAL.USER_ID;

329:
330: l_estimate_rec EAM_EST_DATASTRUCTURES_PUB.EAM_CONSTRUCTION_ESTIMATE_REC;
331: l_parent_ce_wo_line_rec EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_REC;
332: l_creation_date DATE := SYSDATE;
333: l_created_by NUMBER := FND_GLOBAL.USER_ID;
334: l_last_updated_date DATE := SYSDATE;
335: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
336: l_last_updated_login NUMBER;
337: l_wo_line_id_seq NUMBER;

Line 335: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

331: l_parent_ce_wo_line_rec EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_REC;
332: l_creation_date DATE := SYSDATE;
333: l_created_by NUMBER := FND_GLOBAL.USER_ID;
334: l_last_updated_date DATE := SYSDATE;
335: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
336: l_last_updated_login NUMBER;
337: l_wo_line_id_seq NUMBER;
338: l_parent_wo_num NUMBER;
339:

Line 465: ,p_created_by => FND_GLOBAL.LOGIN_ID

461: ,p_di_auto_request_material => FND_API.G_MISS_CHAR
462: ,p_di_need_by_date => FND_API.G_MISS_DATE
463: ,p_work_order_line_cost => FND_API.G_MISS_NUM
464: ,p_creation_date => sysdate
465: ,p_created_by => FND_GLOBAL.LOGIN_ID
466: ,p_last_update_date => sysdate
467: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID
468: ,p_last_update_login => FND_GLOBAL.LOGIN_ID
469: ,p_work_order_type => FND_API.G_MISS_NUM

Line 467: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID

463: ,p_work_order_line_cost => FND_API.G_MISS_NUM
464: ,p_creation_date => sysdate
465: ,p_created_by => FND_GLOBAL.LOGIN_ID
466: ,p_last_update_date => sysdate
467: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID
468: ,p_last_update_login => FND_GLOBAL.LOGIN_ID
469: ,p_work_order_type => FND_API.G_MISS_NUM
470: ,p_activity_type => FND_API.G_MISS_NUM
471: ,p_activity_source => FND_API.G_MISS_NUM

Line 468: ,p_last_update_login => FND_GLOBAL.LOGIN_ID

464: ,p_creation_date => sysdate
465: ,p_created_by => FND_GLOBAL.LOGIN_ID
466: ,p_last_update_date => sysdate
467: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID
468: ,p_last_update_login => FND_GLOBAL.LOGIN_ID
469: ,p_work_order_type => FND_API.G_MISS_NUM
470: ,p_activity_type => FND_API.G_MISS_NUM
471: ,p_activity_source => FND_API.G_MISS_NUM
472: ,p_activity_cause => FND_API.G_MISS_NUM

Line 544: ,p_created_by => FND_GLOBAL.LOGIN_ID

540: ,p_di_auto_request_material => FND_API.G_MISS_CHAR
541: ,p_di_need_by_date => FND_API.G_MISS_DATE
542: ,p_work_order_line_cost => FND_API.G_MISS_NUM
543: ,p_creation_date => sysdate
544: ,p_created_by => FND_GLOBAL.LOGIN_ID
545: ,p_last_update_date => sysdate
546: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID
547: ,p_last_update_login => FND_GLOBAL.LOGIN_ID
548: ,p_work_order_type => FND_API.G_MISS_NUM

Line 546: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID

542: ,p_work_order_line_cost => FND_API.G_MISS_NUM
543: ,p_creation_date => sysdate
544: ,p_created_by => FND_GLOBAL.LOGIN_ID
545: ,p_last_update_date => sysdate
546: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID
547: ,p_last_update_login => FND_GLOBAL.LOGIN_ID
548: ,p_work_order_type => FND_API.G_MISS_NUM
549: ,p_activity_type => FND_API.G_MISS_NUM
550: ,p_activity_source => FND_API.G_MISS_NUM

Line 547: ,p_last_update_login => FND_GLOBAL.LOGIN_ID

543: ,p_creation_date => sysdate
544: ,p_created_by => FND_GLOBAL.LOGIN_ID
545: ,p_last_update_date => sysdate
546: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID
547: ,p_last_update_login => FND_GLOBAL.LOGIN_ID
548: ,p_work_order_type => FND_API.G_MISS_NUM
549: ,p_activity_type => FND_API.G_MISS_NUM
550: ,p_activity_source => FND_API.G_MISS_NUM
551: ,p_activity_cause => FND_API.G_MISS_NUM

Line 884: ,p_created_by => FND_GLOBAL.LOGIN_ID

880: ,p_di_auto_request_material => NULL
881: ,p_di_need_by_date => NULL
882: ,p_work_order_line_cost => l_unit_cost
883: ,p_creation_date => sysdate
884: ,p_created_by => FND_GLOBAL.LOGIN_ID
885: ,p_last_update_date => sysdate
886: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID
887: ,p_last_update_login => FND_GLOBAL.LOGIN_ID
888: ,p_work_order_type => NULL

Line 886: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID

882: ,p_work_order_line_cost => l_unit_cost
883: ,p_creation_date => sysdate
884: ,p_created_by => FND_GLOBAL.LOGIN_ID
885: ,p_last_update_date => sysdate
886: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID
887: ,p_last_update_login => FND_GLOBAL.LOGIN_ID
888: ,p_work_order_type => NULL
889: ,p_activity_type => NULL
890: ,p_activity_source => NULL

Line 887: ,p_last_update_login => FND_GLOBAL.LOGIN_ID

883: ,p_creation_date => sysdate
884: ,p_created_by => FND_GLOBAL.LOGIN_ID
885: ,p_last_update_date => sysdate
886: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID
887: ,p_last_update_login => FND_GLOBAL.LOGIN_ID
888: ,p_work_order_type => NULL
889: ,p_activity_type => NULL
890: ,p_activity_source => NULL
891: ,p_activity_cause => NULL

Line 1112: ,p_created_by => FND_GLOBAL.LOGIN_ID

1108: ,p_di_auto_request_material => p_eam_ce_wo_lines_tbl(l_ce_tab_index).DI_AUTO_REQUEST_MATERIAL
1109: ,p_di_need_by_date => p_eam_ce_wo_lines_tbl(l_ce_tab_index).DI_NEED_BY_DATE
1110: ,p_work_order_line_cost => l_unit_cost
1111: ,p_creation_date => sysdate
1112: ,p_created_by => FND_GLOBAL.LOGIN_ID
1113: ,p_last_update_date => sysdate
1114: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID
1115: ,p_last_update_login => FND_GLOBAL.LOGIN_ID
1116: ,p_work_order_type => p_eam_ce_wo_lines_tbl(l_ce_tab_index).WORK_ORDER_TYPE

Line 1114: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID

1110: ,p_work_order_line_cost => l_unit_cost
1111: ,p_creation_date => sysdate
1112: ,p_created_by => FND_GLOBAL.LOGIN_ID
1113: ,p_last_update_date => sysdate
1114: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID
1115: ,p_last_update_login => FND_GLOBAL.LOGIN_ID
1116: ,p_work_order_type => p_eam_ce_wo_lines_tbl(l_ce_tab_index).WORK_ORDER_TYPE
1117: ,p_activity_type => p_eam_ce_wo_lines_tbl(l_ce_tab_index).ACTIVITY_TYPE
1118: ,p_activity_source => p_eam_ce_wo_lines_tbl(l_ce_tab_index).ACTIVITY_SOURCE

Line 1115: ,p_last_update_login => FND_GLOBAL.LOGIN_ID

1111: ,p_creation_date => sysdate
1112: ,p_created_by => FND_GLOBAL.LOGIN_ID
1113: ,p_last_update_date => sysdate
1114: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID
1115: ,p_last_update_login => FND_GLOBAL.LOGIN_ID
1116: ,p_work_order_type => p_eam_ce_wo_lines_tbl(l_ce_tab_index).WORK_ORDER_TYPE
1117: ,p_activity_type => p_eam_ce_wo_lines_tbl(l_ce_tab_index).ACTIVITY_TYPE
1118: ,p_activity_source => p_eam_ce_wo_lines_tbl(l_ce_tab_index).ACTIVITY_SOURCE
1119: ,p_activity_cause => p_eam_ce_wo_lines_tbl(l_ce_tab_index).ACTIVITY_CAUSE

Line 1224: ,p_created_by => FND_GLOBAL.LOGIN_ID

1220: ,p_di_auto_request_material => p_eam_ce_wo_lines_tbl(l_ce_tab_index).DI_AUTO_REQUEST_MATERIAL
1221: ,p_di_need_by_date => p_eam_ce_wo_lines_tbl(l_ce_tab_index).DI_NEED_BY_DATE
1222: ,p_work_order_line_cost => l_unit_cost
1223: ,p_creation_date => sysdate
1224: ,p_created_by => FND_GLOBAL.LOGIN_ID
1225: ,p_last_update_date => sysdate
1226: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID
1227: ,p_last_update_login => FND_GLOBAL.LOGIN_ID
1228: ,p_work_order_type => p_eam_ce_wo_lines_tbl(l_ce_tab_index).WORK_ORDER_TYPE

Line 1226: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID

1222: ,p_work_order_line_cost => l_unit_cost
1223: ,p_creation_date => sysdate
1224: ,p_created_by => FND_GLOBAL.LOGIN_ID
1225: ,p_last_update_date => sysdate
1226: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID
1227: ,p_last_update_login => FND_GLOBAL.LOGIN_ID
1228: ,p_work_order_type => p_eam_ce_wo_lines_tbl(l_ce_tab_index).WORK_ORDER_TYPE
1229: ,p_activity_type => p_eam_ce_wo_lines_tbl(l_ce_tab_index).ACTIVITY_TYPE
1230: ,p_activity_source => p_eam_ce_wo_lines_tbl(l_ce_tab_index).ACTIVITY_SOURCE

Line 1227: ,p_last_update_login => FND_GLOBAL.LOGIN_ID

1223: ,p_creation_date => sysdate
1224: ,p_created_by => FND_GLOBAL.LOGIN_ID
1225: ,p_last_update_date => sysdate
1226: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID
1227: ,p_last_update_login => FND_GLOBAL.LOGIN_ID
1228: ,p_work_order_type => p_eam_ce_wo_lines_tbl(l_ce_tab_index).WORK_ORDER_TYPE
1229: ,p_activity_type => p_eam_ce_wo_lines_tbl(l_ce_tab_index).ACTIVITY_TYPE
1230: ,p_activity_source => p_eam_ce_wo_lines_tbl(l_ce_tab_index).ACTIVITY_SOURCE
1231: ,p_activity_cause => p_eam_ce_wo_lines_tbl(l_ce_tab_index).ACTIVITY_CAUSE

Line 2074: l_created_by NUMBER := FND_GLOBAL.USER_ID;

2070: l_api_version CONSTANT NUMBER := 1.0;
2071: l_debug_filename VARCHAR(50) := G_DEBUG_FILENAME;
2072: l_debug VARCHAR2(1) := 'N';
2073: l_creation_date DATE := SYSDATE;
2074: l_created_by NUMBER := FND_GLOBAL.USER_ID;
2075: l_last_updated_date DATE := SYSDATE;
2076: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
2077: l_last_updated_login NUMBER;
2078: l_estimate_exist VARCHAR2(1) := 'N';

Line 2076: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

2072: l_debug VARCHAR2(1) := 'N';
2073: l_creation_date DATE := SYSDATE;
2074: l_created_by NUMBER := FND_GLOBAL.USER_ID;
2075: l_last_updated_date DATE := SYSDATE;
2076: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
2077: l_last_updated_login NUMBER;
2078: l_estimate_exist VARCHAR2(1) := 'N';
2079: BEGIN
2080: SAVEPOINT CREATE_ESTIMATE;

Line 2231: l_created_by NUMBER := FND_GLOBAL.USER_ID;

2227: l_api_version CONSTANT NUMBER := 1.0;
2228: l_debug_filename VARCHAR(50) := G_DEBUG_FILENAME;
2229: l_debug VARCHAR2(1) := 'N';
2230: l_creation_date DATE := SYSDATE;
2231: l_created_by NUMBER := FND_GLOBAL.USER_ID;
2232: l_last_updated_date DATE := SYSDATE;
2233: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
2234: l_last_updated_login NUMBER;
2235: l_estimate_exist VARCHAR2(1) := 'N';

Line 2233: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

2229: l_debug VARCHAR2(1) := 'N';
2230: l_creation_date DATE := SYSDATE;
2231: l_created_by NUMBER := FND_GLOBAL.USER_ID;
2232: l_last_updated_date DATE := SYSDATE;
2233: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
2234: l_last_updated_login NUMBER;
2235: l_estimate_exist VARCHAR2(1) := 'N';
2236: l_parent_creation_flag VARCHAR(1) := FND_API.G_MISS_CHAR;
2237: l_parent_wo_id NUMBER := FND_API.G_MISS_NUM;

Line 2424: l_created_by NUMBER := FND_GLOBAL.USER_ID;

2420: l_activity_qty NUMBER;
2421: l_difficulty_id NUMBER;
2422: l_resource_multiplier NUMBER;
2423: l_creation_date DATE := SYSDATE;
2424: l_created_by NUMBER := FND_GLOBAL.USER_ID;
2425: l_last_updated_date DATE := SYSDATE;
2426: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
2427: l_last_updated_login NUMBER;
2428: BEGIN

Line 2426: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

2422: l_resource_multiplier NUMBER;
2423: l_creation_date DATE := SYSDATE;
2424: l_created_by NUMBER := FND_GLOBAL.USER_ID;
2425: l_last_updated_date DATE := SYSDATE;
2426: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
2427: l_last_updated_login NUMBER;
2428: BEGIN
2429: SAVEPOINT SET_ACTIVITIES_FOR_CE;
2430:

Line 3415: p_last_updated_by => FND_GLOBAL.USER_ID,

3411: p_work_order_line_cost => l_ce_wo_ln_tbl(i).WORK_ORDER_LINE_COST,
3412: p_creation_date => FND_API.G_MISS_DATE,
3413: p_created_by => FND_API.G_MISS_NUM,
3414: p_last_update_date => SYSDATE,
3415: p_last_updated_by => FND_GLOBAL.USER_ID,
3416: p_last_update_login => FND_GLOBAL.USER_ID
3417: ,p_work_order_type => l_ce_wo_ln_tbl(i).WORK_ORDER_TYPE
3418: ,p_activity_type => l_ce_wo_ln_tbl(i).ACTIVITY_TYPE
3419: ,p_activity_source => l_ce_wo_ln_tbl(i).ACTIVITY_SOURCE

Line 3416: p_last_update_login => FND_GLOBAL.USER_ID

3412: p_creation_date => FND_API.G_MISS_DATE,
3413: p_created_by => FND_API.G_MISS_NUM,
3414: p_last_update_date => SYSDATE,
3415: p_last_updated_by => FND_GLOBAL.USER_ID,
3416: p_last_update_login => FND_GLOBAL.USER_ID
3417: ,p_work_order_type => l_ce_wo_ln_tbl(i).WORK_ORDER_TYPE
3418: ,p_activity_type => l_ce_wo_ln_tbl(i).ACTIVITY_TYPE
3419: ,p_activity_source => l_ce_wo_ln_tbl(i).ACTIVITY_SOURCE
3420: ,p_activity_cause => l_ce_wo_ln_tbl(i).ACTIVITY_CAUSE

Line 4360: l_eam_wo_rec.user_id := fnd_global.user_id;

4356: l_eam_wo_rec.scheduled_start_date := nvl(p_ce_line_rec.scheduled_start_date, sysdate);
4357: l_eam_wo_rec.scheduled_completion_date := nvl(p_ce_line_rec.scheduled_completion_date, sysdate);
4358: l_eam_wo_rec.user_defined_status_id := p_ce_line_rec.user_defined_status_id;
4359: --dbms_output.put_line('PWO: 1.5');
4360: l_eam_wo_rec.user_id := fnd_global.user_id;
4361: --dbms_output.put_line('PWO: 1.51');
4362: l_eam_wo_rec.responsibility_id := 55240; --fnd_glabal.resp_id
4363: l_eam_wo_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_CREATE;
4364:

Line 4783: l_created_by NUMBER := FND_GLOBAL.USER_ID;

4779:
4780:
4781: l_est_workorder_line_rec EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_REC;
4782: l_creation_date DATE := SYSDATE;
4783: l_created_by NUMBER := FND_GLOBAL.USER_ID;
4784: l_last_updated_date DATE := SYSDATE;
4785: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
4786: l_last_updated_login NUMBER;
4787: l_parent_estimate_wo_line_id NUMBER := 0;

Line 4785: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

4781: l_est_workorder_line_rec EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_REC;
4782: l_creation_date DATE := SYSDATE;
4783: l_created_by NUMBER := FND_GLOBAL.USER_ID;
4784: l_last_updated_date DATE := SYSDATE;
4785: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
4786: l_last_updated_login NUMBER;
4787: l_parent_estimate_wo_line_id NUMBER := 0;
4788: l_wo_line_id_seq NUMBER :=0;
4789:

Line 4985: ,p_created_by => FND_GLOBAL.LOGIN_ID

4981: ,p_di_auto_request_material => l_est_workorder_line_rec.DI_AUTO_REQUEST_MATERIAL
4982: ,p_di_need_by_date => l_est_workorder_line_rec.DI_NEED_BY_DATE
4983: ,p_work_order_line_cost => l_est_workorder_line_rec.WO_LINE_PER_UNIT_COST
4984: ,p_creation_date => sysdate
4985: ,p_created_by => FND_GLOBAL.LOGIN_ID
4986: ,p_last_update_date => sysdate
4987: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID
4988: ,p_last_update_login => FND_GLOBAL.LOGIN_ID
4989: ,p_work_order_type => l_est_workorder_line_rec.WORK_ORDER_TYPE

Line 4987: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID

4983: ,p_work_order_line_cost => l_est_workorder_line_rec.WO_LINE_PER_UNIT_COST
4984: ,p_creation_date => sysdate
4985: ,p_created_by => FND_GLOBAL.LOGIN_ID
4986: ,p_last_update_date => sysdate
4987: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID
4988: ,p_last_update_login => FND_GLOBAL.LOGIN_ID
4989: ,p_work_order_type => l_est_workorder_line_rec.WORK_ORDER_TYPE
4990: ,p_activity_type => l_est_workorder_line_rec.ACTIVITY_TYPE
4991: ,p_activity_source => l_est_workorder_line_rec.ACTIVITY_SOURCE

Line 4988: ,p_last_update_login => FND_GLOBAL.LOGIN_ID

4984: ,p_creation_date => sysdate
4985: ,p_created_by => FND_GLOBAL.LOGIN_ID
4986: ,p_last_update_date => sysdate
4987: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID
4988: ,p_last_update_login => FND_GLOBAL.LOGIN_ID
4989: ,p_work_order_type => l_est_workorder_line_rec.WORK_ORDER_TYPE
4990: ,p_activity_type => l_est_workorder_line_rec.ACTIVITY_TYPE
4991: ,p_activity_source => l_est_workorder_line_rec.ACTIVITY_SOURCE
4992: ,p_activity_cause => l_est_workorder_line_rec.ACTIVITY_CAUSE

Line 5093: ,p_created_by => FND_GLOBAL.LOGIN_ID

5089: ,p_di_auto_request_material => l_est_workorder_line_rec.DI_AUTO_REQUEST_MATERIAL
5090: ,p_di_need_by_date => l_est_workorder_line_rec.DI_NEED_BY_DATE
5091: ,p_work_order_line_cost => l_est_workorder_line_rec.WO_LINE_PER_UNIT_COST
5092: ,p_creation_date => sysdate
5093: ,p_created_by => FND_GLOBAL.LOGIN_ID
5094: ,p_last_update_date => sysdate
5095: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID
5096: ,p_last_update_login => FND_GLOBAL.LOGIN_ID
5097: ,p_work_order_type => l_est_workorder_line_rec.WORK_ORDER_TYPE

Line 5095: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID

5091: ,p_work_order_line_cost => l_est_workorder_line_rec.WO_LINE_PER_UNIT_COST
5092: ,p_creation_date => sysdate
5093: ,p_created_by => FND_GLOBAL.LOGIN_ID
5094: ,p_last_update_date => sysdate
5095: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID
5096: ,p_last_update_login => FND_GLOBAL.LOGIN_ID
5097: ,p_work_order_type => l_est_workorder_line_rec.WORK_ORDER_TYPE
5098: ,p_activity_type => l_est_workorder_line_rec.ACTIVITY_TYPE
5099: ,p_activity_source => l_est_workorder_line_rec.ACTIVITY_SOURCE

Line 5096: ,p_last_update_login => FND_GLOBAL.LOGIN_ID

5092: ,p_creation_date => sysdate
5093: ,p_created_by => FND_GLOBAL.LOGIN_ID
5094: ,p_last_update_date => sysdate
5095: ,p_last_updated_by => FND_GLOBAL.LOGIN_ID
5096: ,p_last_update_login => FND_GLOBAL.LOGIN_ID
5097: ,p_work_order_type => l_est_workorder_line_rec.WORK_ORDER_TYPE
5098: ,p_activity_type => l_est_workorder_line_rec.ACTIVITY_TYPE
5099: ,p_activity_source => l_est_workorder_line_rec.ACTIVITY_SOURCE
5100: ,p_activity_cause => l_est_workorder_line_rec.ACTIVITY_CAUSE