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.EAM_CONSTRUCTION_EST_PVT dependencies on STANDARD

Line 434: ,p_standard_operation_id => FND_API.G_MISS_NUM

430: ,p_owning_department_id => p_parent_wo_line_rec.OWNING_DEPARTMENT_ID
431: ,p_user_defined_status_id => p_parent_wo_line_rec.STATUS_TYPE
432: ,p_op_seq_num => FND_API.G_MISS_NUM
433: ,p_op_description => FND_API.G_MISS_CHAR
434: ,p_standard_operation_id => FND_API.G_MISS_NUM
435: ,p_op_department_id => FND_API.G_MISS_NUM
436: ,p_op_long_description => FND_API.G_MISS_CHAR
437: ,p_res_seq_num => FND_API.G_MISS_NUM
438: ,p_res_id => FND_API.G_MISS_NUM

Line 513: ,p_standard_operation_id => FND_API.G_MISS_NUM

509: ,p_owning_department_id => p_parent_wo_line_rec.OWNING_DEPARTMENT_ID
510: ,p_user_defined_status_id => p_parent_wo_line_rec.STATUS_TYPE
511: ,p_op_seq_num => FND_API.G_MISS_NUM
512: ,p_op_description => FND_API.G_MISS_CHAR
513: ,p_standard_operation_id => FND_API.G_MISS_NUM
514: ,p_op_department_id => FND_API.G_MISS_NUM
515: ,p_op_long_description => FND_API.G_MISS_CHAR
516: ,p_res_seq_num => FND_API.G_MISS_NUM
517: ,p_res_id => FND_API.G_MISS_NUM

Line 747: BSOR.STANDARD_RATE_FLAG,

743: BSOR.ACTIVITY_ID,
744: BSOR.SCHEDULE_FLAG,
745: BSOR.ASSIGNED_UNITS,
746: DECODE(BSOR.AUTOCHARGE_TYPE,1,2,4,3,2,2,3,3,2) AUTOCHARGE_TYPE,
747: BSOR.STANDARD_RATE_FLAG,
748: 0 APPLIED_RESOURCE_UNITS,
749: 0 APPLIED_RESOURCE_VALUE,
750: SYSDATE START_DATE,
751: BSO.DEPARTMENT_ID,

Line 754: FROM BOM_STANDARD_OPERATIONS BSO,

750: SYSDATE START_DATE,
751: BSO.DEPARTMENT_ID,
752: DECODE(BSOR.SCHEDULE_FLAG,2,NULL,BSOR.RESOURCE_SEQ_NUM) ,
753: BSOR.SUBSTITUTE_GROUP_NUM
754: FROM BOM_STANDARD_OPERATIONS BSO,
755: BOM_STD_OP_RESOURCES BSOR,
756: BOM_RESOURCES BR
757: WHERE BSO.STANDARD_OPERATION_ID = BSOR.STANDARD_OPERATION_ID
758: AND BR.RESOURCE_ID = BSOR.RESOURCE_ID

Line 757: WHERE BSO.STANDARD_OPERATION_ID = BSOR.STANDARD_OPERATION_ID

753: BSOR.SUBSTITUTE_GROUP_NUM
754: FROM BOM_STANDARD_OPERATIONS BSO,
755: BOM_STD_OP_RESOURCES BSOR,
756: BOM_RESOURCES BR
757: WHERE BSO.STANDARD_OPERATION_ID = BSOR.STANDARD_OPERATION_ID
758: AND BR.RESOURCE_ID = BSOR.RESOURCE_ID
759: AND BSO.STANDARD_OPERATION_ID = p_std_op_id
760: AND BSO.ORGANIZATION_ID = p_org_id;
761:

Line 759: AND BSO.STANDARD_OPERATION_ID = p_std_op_id

755: BOM_STD_OP_RESOURCES BSOR,
756: BOM_RESOURCES BR
757: WHERE BSO.STANDARD_OPERATION_ID = BSOR.STANDARD_OPERATION_ID
758: AND BR.RESOURCE_ID = BSOR.RESOURCE_ID
759: AND BSO.STANDARD_OPERATION_ID = p_std_op_id
760: AND BSO.ORGANIZATION_ID = p_org_id;
761:
762: l_cost_type_id NUMBER := 0;
763: l_cost_group_id NUMBER := 0;

Line 853: ,p_standard_operation_id => p_std_op_id

849: ,p_owning_department_id => std_op_rec.DEPARTMENT_ID
850: ,p_user_defined_status_id => NULL
851: ,p_op_seq_num => std_op_rec.OPERATION_SEQ_NUM
852: ,p_op_description => std_op_rec.OPERATION_DESC
853: ,p_standard_operation_id => p_std_op_id
854: ,p_op_department_id => std_op_rec.DEPARTMENT_ID
855: ,p_op_long_description => NULL
856: ,p_res_seq_num => std_op_rec.RESOURCE_SEQ_NUM
857: ,p_res_id => std_op_rec.RESOURCE_ID

Line 1081: ,p_standard_operation_id => p_eam_ce_wo_lines_tbl(l_ce_tab_index).STANDARD_OPERATION_ID

1077: ,p_owning_department_id => p_eam_ce_wo_lines_tbl(l_ce_tab_index).OWNING_DEPARTMENT_ID
1078: ,p_user_defined_status_id => p_eam_ce_wo_lines_tbl(l_ce_tab_index).USER_DEFINED_STATUS_ID
1079: ,p_op_seq_num => p_eam_ce_wo_lines_tbl(l_ce_tab_index).OP_SEQ_NUM
1080: ,p_op_description => p_eam_ce_wo_lines_tbl(l_ce_tab_index).OP_DESCRIPTION
1081: ,p_standard_operation_id => p_eam_ce_wo_lines_tbl(l_ce_tab_index).STANDARD_OPERATION_ID
1082: ,p_op_department_id => p_eam_ce_wo_lines_tbl(l_ce_tab_index).OP_DEPARTMENT_ID
1083: ,p_op_long_description => p_eam_ce_wo_lines_tbl(l_ce_tab_index).OP_LONG_DESCRIPTION
1084: ,p_res_seq_num => p_eam_ce_wo_lines_tbl(l_ce_tab_index).RES_SEQ_NUM
1085: ,p_res_id => p_eam_ce_wo_lines_tbl(l_ce_tab_index).RES_ID

Line 1193: ,p_standard_operation_id => p_eam_ce_wo_lines_tbl(l_ce_tab_index).STANDARD_OPERATION_ID

1189: ,p_owning_department_id => p_eam_ce_wo_lines_tbl(l_ce_tab_index).OWNING_DEPARTMENT_ID
1190: ,p_user_defined_status_id => p_eam_ce_wo_lines_tbl(l_ce_tab_index).USER_DEFINED_STATUS_ID
1191: ,p_op_seq_num => p_eam_ce_wo_lines_tbl(l_ce_tab_index).OP_SEQ_NUM
1192: ,p_op_description => p_eam_ce_wo_lines_tbl(l_ce_tab_index).OP_DESCRIPTION
1193: ,p_standard_operation_id => p_eam_ce_wo_lines_tbl(l_ce_tab_index).STANDARD_OPERATION_ID
1194: ,p_op_department_id => p_eam_ce_wo_lines_tbl(l_ce_tab_index).OP_DEPARTMENT_ID
1195: ,p_op_long_description => p_eam_ce_wo_lines_tbl(l_ce_tab_index).OP_LONG_DESCRIPTION
1196: ,p_res_seq_num => p_eam_ce_wo_lines_tbl(l_ce_tab_index).RES_SEQ_NUM
1197: ,p_res_id => p_eam_ce_wo_lines_tbl(l_ce_tab_index).RES_ID

Line 1550: l_eam_ce_wo_lines_tbl(l_wo_ind).STANDARD_OPERATION_ID := p_eam_op_tbl(l_op_index).STANDARD_OPERATION_ID;

1546: l_eam_ce_wo_lines_tbl(l_wo_ind).ACCT_CLASS_CODE := p_ce_associatin_rec.ACCT_CLASS_CODE;
1547:
1548: l_eam_ce_wo_lines_tbl(l_wo_ind).OP_SEQ_NUM := p_eam_op_tbl(l_op_index).OPERATION_SEQ_NUM;
1549: l_eam_ce_wo_lines_tbl(l_wo_ind).OP_DESCRIPTION := p_eam_op_tbl(l_op_index).DESCRIPTION;
1550: l_eam_ce_wo_lines_tbl(l_wo_ind).STANDARD_OPERATION_ID := p_eam_op_tbl(l_op_index).STANDARD_OPERATION_ID;
1551: --l_eam_ce_wo_lines_tbl(l_wo_ind).STANDARD_OPERATION_ID := null;
1552: l_eam_ce_wo_lines_tbl(l_wo_ind).OP_DEPARTMENT_ID := p_eam_op_tbl(l_op_index).DEPARTMENT_ID;
1553: l_eam_ce_wo_lines_tbl(l_wo_ind).OP_LONG_DESCRIPTION := p_eam_op_tbl(l_op_index).LONG_DESCRIPTION;
1554:

Line 1551: --l_eam_ce_wo_lines_tbl(l_wo_ind).STANDARD_OPERATION_ID := null;

1547:
1548: l_eam_ce_wo_lines_tbl(l_wo_ind).OP_SEQ_NUM := p_eam_op_tbl(l_op_index).OPERATION_SEQ_NUM;
1549: l_eam_ce_wo_lines_tbl(l_wo_ind).OP_DESCRIPTION := p_eam_op_tbl(l_op_index).DESCRIPTION;
1550: l_eam_ce_wo_lines_tbl(l_wo_ind).STANDARD_OPERATION_ID := p_eam_op_tbl(l_op_index).STANDARD_OPERATION_ID;
1551: --l_eam_ce_wo_lines_tbl(l_wo_ind).STANDARD_OPERATION_ID := null;
1552: l_eam_ce_wo_lines_tbl(l_wo_ind).OP_DEPARTMENT_ID := p_eam_op_tbl(l_op_index).DEPARTMENT_ID;
1553: l_eam_ce_wo_lines_tbl(l_wo_ind).OP_LONG_DESCRIPTION := p_eam_op_tbl(l_op_index).LONG_DESCRIPTION;
1554:
1555: -- Defaulting owning department id with operation department id

Line 1631: l_eam_ce_wo_lines_tbl(l_wo_ind).STANDARD_OPERATION_ID := p_eam_op_tbl(l_op_index).STANDARD_OPERATION_ID;

1627: l_eam_ce_wo_lines_tbl(l_wo_ind).ACCT_CLASS_CODE := p_ce_associatin_rec.ACCT_CLASS_CODE;
1628:
1629: l_eam_ce_wo_lines_tbl(l_wo_ind).OP_SEQ_NUM := p_eam_op_tbl(l_op_index).OPERATION_SEQ_NUM;
1630: l_eam_ce_wo_lines_tbl(l_wo_ind).OP_DESCRIPTION := p_eam_op_tbl(l_op_index).DESCRIPTION;
1631: l_eam_ce_wo_lines_tbl(l_wo_ind).STANDARD_OPERATION_ID := p_eam_op_tbl(l_op_index).STANDARD_OPERATION_ID;
1632: --l_eam_ce_wo_lines_tbl(l_wo_ind).STANDARD_OPERATION_ID := null;
1633: l_eam_ce_wo_lines_tbl(l_wo_ind).OP_DEPARTMENT_ID := p_eam_op_tbl(l_op_index).DEPARTMENT_ID;
1634: l_eam_ce_wo_lines_tbl(l_wo_ind).OP_LONG_DESCRIPTION := p_eam_op_tbl(l_op_index).LONG_DESCRIPTION;
1635:

Line 1632: --l_eam_ce_wo_lines_tbl(l_wo_ind).STANDARD_OPERATION_ID := null;

1628:
1629: l_eam_ce_wo_lines_tbl(l_wo_ind).OP_SEQ_NUM := p_eam_op_tbl(l_op_index).OPERATION_SEQ_NUM;
1630: l_eam_ce_wo_lines_tbl(l_wo_ind).OP_DESCRIPTION := p_eam_op_tbl(l_op_index).DESCRIPTION;
1631: l_eam_ce_wo_lines_tbl(l_wo_ind).STANDARD_OPERATION_ID := p_eam_op_tbl(l_op_index).STANDARD_OPERATION_ID;
1632: --l_eam_ce_wo_lines_tbl(l_wo_ind).STANDARD_OPERATION_ID := null;
1633: l_eam_ce_wo_lines_tbl(l_wo_ind).OP_DEPARTMENT_ID := p_eam_op_tbl(l_op_index).DEPARTMENT_ID;
1634: l_eam_ce_wo_lines_tbl(l_wo_ind).OP_LONG_DESCRIPTION := p_eam_op_tbl(l_op_index).LONG_DESCRIPTION;
1635:
1636: -- Defaulting owning department id with operation department id

Line 2734: l_ce_wo_ln_rec.STANDARD_OPERATION_ID := wo_line_rec.STANDARD_OPERATION_ID;

2730: l_ce_wo_ln_rec.OWNING_DEPARTMENT_ID := wo_line_rec.OWNING_DEPARTMENT_ID;
2731: l_ce_wo_ln_rec.USER_DEFINED_STATUS_ID := wo_line_rec.USER_DEFINED_STATUS_ID;
2732: l_ce_wo_ln_rec.OP_SEQ_NUM := wo_line_rec.OP_SEQ_NUM;
2733: l_ce_wo_ln_rec.OP_DESCRIPTION := wo_line_rec.OP_DESCRIPTION;
2734: l_ce_wo_ln_rec.STANDARD_OPERATION_ID := wo_line_rec.STANDARD_OPERATION_ID;
2735: l_ce_wo_ln_rec.OP_DEPARTMENT_ID := wo_line_rec.OP_DEPARTMENT_ID;
2736: l_ce_wo_ln_rec.OP_LONG_DESCRIPTION := wo_line_rec.OP_LONG_DESCRIPTION;
2737: l_ce_wo_ln_rec.RES_SEQ_NUM := wo_line_rec.RES_SEQ_NUM;
2738: l_ce_wo_ln_rec.RES_ID := wo_line_rec.RES_ID;

Line 2817: l_ce_wo_ln_rec.STANDARD_OPERATION_ID := wo_line_rec.STANDARD_OPERATION_ID;

2813: l_ce_wo_ln_rec.OWNING_DEPARTMENT_ID := wo_line_rec.OWNING_DEPARTMENT_ID;
2814: l_ce_wo_ln_rec.USER_DEFINED_STATUS_ID := wo_line_rec.USER_DEFINED_STATUS_ID;
2815: l_ce_wo_ln_rec.OP_SEQ_NUM := wo_line_rec.OP_SEQ_NUM_DERIVED; --NVL(OP_SEQ_NUM, SRC_OP_SEQ_NUM)
2816: l_ce_wo_ln_rec.OP_DESCRIPTION := wo_line_rec.OP_DESCRIPTION;
2817: l_ce_wo_ln_rec.STANDARD_OPERATION_ID := wo_line_rec.STANDARD_OPERATION_ID;
2818: l_ce_wo_ln_rec.OP_DEPARTMENT_ID := wo_line_rec.OP_DEPARTMENT_ID;
2819: l_ce_wo_ln_rec.OP_LONG_DESCRIPTION := wo_line_rec.OP_LONG_DESCRIPTION;
2820: l_ce_wo_ln_rec.RES_SEQ_NUM := wo_line_rec.RES_SEQ_NUM;
2821: l_ce_wo_ln_rec.RES_ID := wo_line_rec.RES_ID;

Line 2895: l_ce_wo_ln_rec.STANDARD_OPERATION_ID := wo_line_rec.STANDARD_OPERATION_ID;

2891: l_ce_wo_ln_rec.MAINTENANCE_OBJECT_SOURCE := wo_line_rec.MAINTENANCE_OBJECT_SOURCE;
2892: l_ce_wo_ln_rec.OWNING_DEPARTMENT_ID := wo_line_rec.OWNING_DEPARTMENT_ID;
2893: l_ce_wo_ln_rec.OP_SEQ_NUM := wo_line_rec.OP_SEQ_NUM_DERIVED; --NVL(OP_SEQ_NUM, SRC_OP_SEQ_NUM)
2894: l_ce_wo_ln_rec.OP_DESCRIPTION := wo_line_rec.OP_DESCRIPTION;
2895: l_ce_wo_ln_rec.STANDARD_OPERATION_ID := wo_line_rec.STANDARD_OPERATION_ID;
2896: l_ce_wo_ln_rec.OP_DEPARTMENT_ID := wo_line_rec.OP_DEPARTMENT_ID;
2897: l_ce_wo_ln_rec.OP_LONG_DESCRIPTION := wo_line_rec.OP_LONG_DESCRIPTION;
2898: l_ce_wo_ln_rec.RES_SEQ_NUM := wo_line_rec.RES_SEQ_NUM;
2899: l_ce_wo_ln_rec.RES_ID := wo_line_rec.RES_ID;

Line 3382: p_standard_operation_id => l_ce_wo_ln_tbl(i).STANDARD_OPERATION_ID,

3378: p_owning_department_id => l_ce_wo_ln_tbl(i).OWNING_DEPARTMENT_ID,
3379: p_user_defined_status_id => l_ce_wo_ln_tbl(i).USER_DEFINED_STATUS_ID,
3380: p_op_seq_num => l_ce_wo_ln_tbl(i).OP_SEQ_NUM,
3381: p_op_description => l_ce_wo_ln_tbl(i).OP_DESCRIPTION,
3382: p_standard_operation_id => l_ce_wo_ln_tbl(i).STANDARD_OPERATION_ID,
3383: p_op_department_id => l_ce_wo_ln_tbl(i).OP_DEPARTMENT_ID,
3384: p_op_long_description => l_ce_wo_ln_tbl(i).OP_LONG_DESCRIPTION,
3385: p_res_seq_num => l_ce_wo_ln_tbl(i).RES_SEQ_NUM,
3386: p_res_id => l_ce_wo_ln_tbl(i).RES_ID,

Line 3601: -- standard start of API savepoint

3597:
3598: BEGIN
3599:
3600: -------------------------------------------------------------------------
3601: -- standard start of API savepoint
3602: -------------------------------------------------------------------------
3603: --dbms_output.put_line('1');
3604: SAVEPOINT CREATE_CU_WORKORDERS;
3605:

Line 3607: -- standard call to check for call compatibility

3603: --dbms_output.put_line('1');
3604: SAVEPOINT CREATE_CU_WORKORDERS;
3605:
3606: -------------------------------------------------------------------------
3607: -- standard call to check for call compatibility
3608: -------------------------------------------------------------------------
3609: IF NOT fnd_api.compatible_api_call (
3610: l_api_version,
3611: p_api_version,

Line 4415: -- Standard Call to get message count and if count = 1, get message info

4411:
4412: l_stmt_num := 80;
4413: x_eam_wo_rec := l_eam_wo_rec;
4414:
4415: -- Standard Call to get message count and if count = 1, get message info
4416: FND_MSG_PUB.Count_And_Get (
4417: p_count => x_msg_count,
4418: p_data => x_msg_data );
4419:

Line 4485: --l_eam_op_rec.standard_operation_id := p_ce_line_rec.standard_operation_id;

4481: l_eam_op_rec := x_eam_op_rec;
4482:
4483: l_eam_op_rec.organization_id := p_ce_line_rec.organization_id;
4484: l_eam_op_rec.operation_seq_num := p_ce_line_rec.op_seq_num;
4485: --l_eam_op_rec.standard_operation_id := p_ce_line_rec.standard_operation_id;
4486: l_eam_op_rec.standard_operation_id := null;
4487: l_eam_op_rec.department_id := p_ce_line_rec.op_department_id;
4488: l_eam_op_rec.description := p_ce_line_rec.op_description;
4489: l_eam_op_rec.start_date := nvl(p_ce_line_rec.scheduled_start_date, sysdate);

Line 4486: l_eam_op_rec.standard_operation_id := null;

4482:
4483: l_eam_op_rec.organization_id := p_ce_line_rec.organization_id;
4484: l_eam_op_rec.operation_seq_num := p_ce_line_rec.op_seq_num;
4485: --l_eam_op_rec.standard_operation_id := p_ce_line_rec.standard_operation_id;
4486: l_eam_op_rec.standard_operation_id := null;
4487: l_eam_op_rec.department_id := p_ce_line_rec.op_department_id;
4488: l_eam_op_rec.description := p_ce_line_rec.op_description;
4489: l_eam_op_rec.start_date := nvl(p_ce_line_rec.scheduled_start_date, sysdate);
4490: l_eam_op_rec.completion_date := nvl(p_ce_line_rec.scheduled_completion_date, sysdate);

Line 4499: -- Standard Call to get message count and if count = 1, get message info

4495:
4496: x_eam_op_rec := l_eam_op_rec;
4497:
4498:
4499: -- Standard Call to get message count and if count = 1, get message info
4500: FND_MSG_PUB.Count_And_Get (
4501: p_count => x_msg_count,
4502: p_data => x_msg_data );
4503:

Line 4608: -- Standard Call to get message count and if count = 1, get message info

4604: l_eam_res_rec.autocharge_type := l_autocharge;
4605:
4606: x_eam_res_rec := l_eam_res_rec;
4607:
4608: -- Standard Call to get message count and if count = 1, get message info
4609: FND_MSG_PUB.Count_And_Get (
4610: p_count => x_msg_count,
4611: p_data => x_msg_data );
4612:

Line 4719: -- Standard Call to get message count and if count = 1, get message info

4715:
4716: x_eam_mat_rec := l_eam_mat_rec;
4717: x_eam_direct_rec := l_eam_direct_rec;
4718:
4719: -- Standard Call to get message count and if count = 1, get message info
4720: FND_MSG_PUB.Count_And_Get (
4721: p_count => x_msg_count,
4722: p_data => x_msg_data );
4723:

Line 4954: ,p_standard_operation_id => l_est_workorder_line_rec.STANDARD_OPERATION_ID

4950: ,p_owning_department_id => l_est_workorder_line_rec.OWNING_DEPARTMENT_ID
4951: ,p_user_defined_status_id => NULL
4952: ,p_op_seq_num => l_est_workorder_line_rec.OP_SEQ_NUM
4953: ,p_op_description => l_est_workorder_line_rec.OP_DESCRIPTION
4954: ,p_standard_operation_id => l_est_workorder_line_rec.STANDARD_OPERATION_ID
4955: ,p_op_department_id => l_est_workorder_line_rec.OP_DEPARTMENT_ID
4956: ,p_op_long_description => l_est_workorder_line_rec.OP_LONG_DESCRIPTION
4957: ,p_res_seq_num => l_est_workorder_line_rec.RES_SEQ_NUM
4958: ,p_res_id => l_est_workorder_line_rec.RES_ID

Line 5062: ,p_standard_operation_id => l_est_workorder_line_rec.STANDARD_OPERATION_ID

5058: ,p_owning_department_id => l_est_workorder_line_rec.OWNING_DEPARTMENT_ID
5059: ,p_user_defined_status_id => l_est_workorder_line_rec.USER_DEFINED_STATUS_ID
5060: ,p_op_seq_num => l_est_workorder_line_rec.OP_SEQ_NUM
5061: ,p_op_description => l_est_workorder_line_rec.OP_DESCRIPTION
5062: ,p_standard_operation_id => l_est_workorder_line_rec.STANDARD_OPERATION_ID
5063: ,p_op_department_id => l_est_workorder_line_rec.OP_DEPARTMENT_ID
5064: ,p_op_long_description => l_est_workorder_line_rec.OP_LONG_DESCRIPTION
5065: ,p_res_seq_num => l_est_workorder_line_rec.RES_SEQ_NUM
5066: ,p_res_id => l_est_workorder_line_rec.RES_ID