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 479: ,p_standard_operation_id => FND_API.G_MISS_NUM

475: ,p_owning_department_id => p_parent_wo_line_rec.OWNING_DEPARTMENT_ID
476: ,p_user_defined_status_id => p_parent_wo_line_rec.STATUS_TYPE
477: ,p_op_seq_num => FND_API.G_MISS_NUM
478: ,p_op_description => FND_API.G_MISS_CHAR
479: ,p_standard_operation_id => FND_API.G_MISS_NUM
480: ,p_op_department_id => FND_API.G_MISS_NUM
481: ,p_op_long_description => FND_API.G_MISS_CHAR
482: ,p_res_seq_num => FND_API.G_MISS_NUM
483: ,p_res_id => FND_API.G_MISS_NUM

Line 560: ,p_standard_operation_id => FND_API.G_MISS_NUM

556: ,p_owning_department_id => p_parent_wo_line_rec.OWNING_DEPARTMENT_ID
557: ,p_user_defined_status_id => p_parent_wo_line_rec.STATUS_TYPE
558: ,p_op_seq_num => FND_API.G_MISS_NUM
559: ,p_op_description => FND_API.G_MISS_CHAR
560: ,p_standard_operation_id => FND_API.G_MISS_NUM
561: ,p_op_department_id => FND_API.G_MISS_NUM
562: ,p_op_long_description => FND_API.G_MISS_CHAR
563: ,p_res_seq_num => FND_API.G_MISS_NUM
564: ,p_res_id => FND_API.G_MISS_NUM

Line 804: BSOR.STANDARD_RATE_FLAG,

800: BSOR.ACTIVITY_ID,
801: BSOR.SCHEDULE_FLAG,
802: BSOR.ASSIGNED_UNITS,
803: DECODE(BSOR.AUTOCHARGE_TYPE,1,2,4,3,2,2,3,3,2) AUTOCHARGE_TYPE,
804: BSOR.STANDARD_RATE_FLAG,
805: 0 APPLIED_RESOURCE_UNITS,
806: 0 APPLIED_RESOURCE_VALUE,
807: SYSDATE START_DATE,
808: BSO.DEPARTMENT_ID,

Line 811: FROM BOM_STANDARD_OPERATIONS BSO,

807: SYSDATE START_DATE,
808: BSO.DEPARTMENT_ID,
809: DECODE(BSOR.SCHEDULE_FLAG,2,NULL,BSOR.RESOURCE_SEQ_NUM) ,
810: BSOR.SUBSTITUTE_GROUP_NUM
811: FROM BOM_STANDARD_OPERATIONS BSO,
812: BOM_STD_OP_RESOURCES BSOR,
813: BOM_RESOURCES BR
814: WHERE BSO.STANDARD_OPERATION_ID = BSOR.STANDARD_OPERATION_ID
815: AND BR.RESOURCE_ID = BSOR.RESOURCE_ID

Line 814: WHERE BSO.STANDARD_OPERATION_ID = BSOR.STANDARD_OPERATION_ID

810: BSOR.SUBSTITUTE_GROUP_NUM
811: FROM BOM_STANDARD_OPERATIONS BSO,
812: BOM_STD_OP_RESOURCES BSOR,
813: BOM_RESOURCES BR
814: WHERE BSO.STANDARD_OPERATION_ID = BSOR.STANDARD_OPERATION_ID
815: AND BR.RESOURCE_ID = BSOR.RESOURCE_ID
816: AND BSO.STANDARD_OPERATION_ID = p_std_op_id
817: AND BSO.ORGANIZATION_ID = p_org_id;
818:

Line 816: AND BSO.STANDARD_OPERATION_ID = p_std_op_id

812: BOM_STD_OP_RESOURCES BSOR,
813: BOM_RESOURCES BR
814: WHERE BSO.STANDARD_OPERATION_ID = BSOR.STANDARD_OPERATION_ID
815: AND BR.RESOURCE_ID = BSOR.RESOURCE_ID
816: AND BSO.STANDARD_OPERATION_ID = p_std_op_id
817: AND BSO.ORGANIZATION_ID = p_org_id;
818:
819: l_cost_type_id NUMBER := 0;
820: l_cost_group_id NUMBER := 0;

Line 921: ,p_standard_operation_id => p_std_op_id

917: ,p_owning_department_id => std_op_rec.DEPARTMENT_ID
918: ,p_user_defined_status_id => NULL
919: ,p_op_seq_num => std_op_rec.OPERATION_SEQ_NUM
920: ,p_op_description => std_op_rec.OPERATION_DESC
921: ,p_standard_operation_id => p_std_op_id
922: ,p_op_department_id => std_op_rec.DEPARTMENT_ID
923: ,p_op_long_description => NULL
924: ,p_res_seq_num => std_op_rec.RESOURCE_SEQ_NUM
925: ,p_res_id => std_op_rec.RESOURCE_ID

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

1157: ,p_owning_department_id => p_eam_ce_wo_lines_tbl(l_ce_tab_index).OWNING_DEPARTMENT_ID
1158: ,p_user_defined_status_id => p_eam_ce_wo_lines_tbl(l_ce_tab_index).USER_DEFINED_STATUS_ID
1159: ,p_op_seq_num => p_eam_ce_wo_lines_tbl(l_ce_tab_index).OP_SEQ_NUM
1160: ,p_op_description => p_eam_ce_wo_lines_tbl(l_ce_tab_index).OP_DESCRIPTION
1161: ,p_standard_operation_id => p_eam_ce_wo_lines_tbl(l_ce_tab_index).STANDARD_OPERATION_ID
1162: ,p_op_department_id => p_eam_ce_wo_lines_tbl(l_ce_tab_index).OP_DEPARTMENT_ID
1163: ,p_op_long_description => p_eam_ce_wo_lines_tbl(l_ce_tab_index).OP_LONG_DESCRIPTION
1164: ,p_res_seq_num => p_eam_ce_wo_lines_tbl(l_ce_tab_index).RES_SEQ_NUM
1165: ,p_res_id => p_eam_ce_wo_lines_tbl(l_ce_tab_index).RES_ID

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

1270: ,p_owning_department_id => p_eam_ce_wo_lines_tbl(l_ce_tab_index).OWNING_DEPARTMENT_ID
1271: ,p_user_defined_status_id => p_eam_ce_wo_lines_tbl(l_ce_tab_index).USER_DEFINED_STATUS_ID
1272: ,p_op_seq_num => p_eam_ce_wo_lines_tbl(l_ce_tab_index).OP_SEQ_NUM
1273: ,p_op_description => p_eam_ce_wo_lines_tbl(l_ce_tab_index).OP_DESCRIPTION
1274: ,p_standard_operation_id => p_eam_ce_wo_lines_tbl(l_ce_tab_index).STANDARD_OPERATION_ID
1275: ,p_op_department_id => p_eam_ce_wo_lines_tbl(l_ce_tab_index).OP_DEPARTMENT_ID
1276: ,p_op_long_description => p_eam_ce_wo_lines_tbl(l_ce_tab_index).OP_LONG_DESCRIPTION
1277: ,p_res_seq_num => p_eam_ce_wo_lines_tbl(l_ce_tab_index).RES_SEQ_NUM
1278: ,p_res_id => p_eam_ce_wo_lines_tbl(l_ce_tab_index).RES_ID

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

1658: l_eam_ce_wo_lines_tbl(l_wo_ind).ACCT_CLASS_CODE := p_ce_associatin_rec.ACCT_CLASS_CODE;
1659:
1660: l_eam_ce_wo_lines_tbl(l_wo_ind).OP_SEQ_NUM := p_eam_op_tbl(l_op_index).OPERATION_SEQ_NUM;
1661: l_eam_ce_wo_lines_tbl(l_wo_ind).OP_DESCRIPTION := p_eam_op_tbl(l_op_index).DESCRIPTION;
1662: l_eam_ce_wo_lines_tbl(l_wo_ind).STANDARD_OPERATION_ID := p_eam_op_tbl(l_op_index).STANDARD_OPERATION_ID;
1663: --l_eam_ce_wo_lines_tbl(l_wo_ind).STANDARD_OPERATION_ID := null;
1664: l_eam_ce_wo_lines_tbl(l_wo_ind).OP_DEPARTMENT_ID := p_eam_op_tbl(l_op_index).DEPARTMENT_ID;
1665: l_eam_ce_wo_lines_tbl(l_wo_ind).OP_LONG_DESCRIPTION := p_eam_op_tbl(l_op_index).LONG_DESCRIPTION;
1666:

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

1659:
1660: l_eam_ce_wo_lines_tbl(l_wo_ind).OP_SEQ_NUM := p_eam_op_tbl(l_op_index).OPERATION_SEQ_NUM;
1661: l_eam_ce_wo_lines_tbl(l_wo_ind).OP_DESCRIPTION := p_eam_op_tbl(l_op_index).DESCRIPTION;
1662: l_eam_ce_wo_lines_tbl(l_wo_ind).STANDARD_OPERATION_ID := p_eam_op_tbl(l_op_index).STANDARD_OPERATION_ID;
1663: --l_eam_ce_wo_lines_tbl(l_wo_ind).STANDARD_OPERATION_ID := null;
1664: l_eam_ce_wo_lines_tbl(l_wo_ind).OP_DEPARTMENT_ID := p_eam_op_tbl(l_op_index).DEPARTMENT_ID;
1665: l_eam_ce_wo_lines_tbl(l_wo_ind).OP_LONG_DESCRIPTION := p_eam_op_tbl(l_op_index).LONG_DESCRIPTION;
1666:
1667: -- Defaulting owning department id with operation department id

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

1749: l_eam_ce_wo_lines_tbl(l_wo_ind).ACCT_CLASS_CODE := p_ce_associatin_rec.ACCT_CLASS_CODE;
1750:
1751: l_eam_ce_wo_lines_tbl(l_wo_ind).OP_SEQ_NUM := p_eam_op_tbl(l_op_index).OPERATION_SEQ_NUM;
1752: l_eam_ce_wo_lines_tbl(l_wo_ind).OP_DESCRIPTION := p_eam_op_tbl(l_op_index).DESCRIPTION;
1753: l_eam_ce_wo_lines_tbl(l_wo_ind).STANDARD_OPERATION_ID := p_eam_op_tbl(l_op_index).STANDARD_OPERATION_ID;
1754: --l_eam_ce_wo_lines_tbl(l_wo_ind).STANDARD_OPERATION_ID := null;
1755: l_eam_ce_wo_lines_tbl(l_wo_ind).OP_DEPARTMENT_ID := p_eam_op_tbl(l_op_index).DEPARTMENT_ID;
1756: l_eam_ce_wo_lines_tbl(l_wo_ind).OP_LONG_DESCRIPTION := p_eam_op_tbl(l_op_index).LONG_DESCRIPTION;
1757:

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

1750:
1751: l_eam_ce_wo_lines_tbl(l_wo_ind).OP_SEQ_NUM := p_eam_op_tbl(l_op_index).OPERATION_SEQ_NUM;
1752: l_eam_ce_wo_lines_tbl(l_wo_ind).OP_DESCRIPTION := p_eam_op_tbl(l_op_index).DESCRIPTION;
1753: l_eam_ce_wo_lines_tbl(l_wo_ind).STANDARD_OPERATION_ID := p_eam_op_tbl(l_op_index).STANDARD_OPERATION_ID;
1754: --l_eam_ce_wo_lines_tbl(l_wo_ind).STANDARD_OPERATION_ID := null;
1755: l_eam_ce_wo_lines_tbl(l_wo_ind).OP_DEPARTMENT_ID := p_eam_op_tbl(l_op_index).DEPARTMENT_ID;
1756: l_eam_ce_wo_lines_tbl(l_wo_ind).OP_LONG_DESCRIPTION := p_eam_op_tbl(l_op_index).LONG_DESCRIPTION;
1757:
1758: -- Defaulting owning department id with operation department id

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

2909: l_ce_wo_ln_rec.OWNING_DEPARTMENT_ID := wo_line_rec.OWNING_DEPARTMENT_ID;
2910: l_ce_wo_ln_rec.USER_DEFINED_STATUS_ID := wo_line_rec.USER_DEFINED_STATUS_ID;
2911: l_ce_wo_ln_rec.OP_SEQ_NUM := wo_line_rec.OP_SEQ_NUM;
2912: l_ce_wo_ln_rec.OP_DESCRIPTION := wo_line_rec.OP_DESCRIPTION;
2913: l_ce_wo_ln_rec.STANDARD_OPERATION_ID := wo_line_rec.STANDARD_OPERATION_ID;
2914: l_ce_wo_ln_rec.OP_DEPARTMENT_ID := wo_line_rec.OP_DEPARTMENT_ID;
2915: l_ce_wo_ln_rec.OP_LONG_DESCRIPTION := wo_line_rec.OP_LONG_DESCRIPTION;
2916: l_ce_wo_ln_rec.RES_SEQ_NUM := wo_line_rec.RES_SEQ_NUM;
2917: l_ce_wo_ln_rec.RES_ID := wo_line_rec.RES_ID;

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

2992: l_ce_wo_ln_rec.OWNING_DEPARTMENT_ID := wo_line_rec.OWNING_DEPARTMENT_ID;
2993: l_ce_wo_ln_rec.USER_DEFINED_STATUS_ID := wo_line_rec.USER_DEFINED_STATUS_ID;
2994: l_ce_wo_ln_rec.OP_SEQ_NUM := wo_line_rec.OP_SEQ_NUM_DERIVED; --NVL(OP_SEQ_NUM, SRC_OP_SEQ_NUM)
2995: l_ce_wo_ln_rec.OP_DESCRIPTION := wo_line_rec.OP_DESCRIPTION;
2996: l_ce_wo_ln_rec.STANDARD_OPERATION_ID := wo_line_rec.STANDARD_OPERATION_ID;
2997: l_ce_wo_ln_rec.OP_DEPARTMENT_ID := wo_line_rec.OP_DEPARTMENT_ID;
2998: l_ce_wo_ln_rec.OP_LONG_DESCRIPTION := wo_line_rec.OP_LONG_DESCRIPTION;
2999: l_ce_wo_ln_rec.RES_SEQ_NUM := wo_line_rec.RES_SEQ_NUM;
3000: l_ce_wo_ln_rec.RES_ID := wo_line_rec.RES_ID;

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

3070: l_ce_wo_ln_rec.MAINTENANCE_OBJECT_SOURCE := wo_line_rec.MAINTENANCE_OBJECT_SOURCE;
3071: l_ce_wo_ln_rec.OWNING_DEPARTMENT_ID := wo_line_rec.OWNING_DEPARTMENT_ID;
3072: l_ce_wo_ln_rec.OP_SEQ_NUM := wo_line_rec.OP_SEQ_NUM_DERIVED; --NVL(OP_SEQ_NUM, SRC_OP_SEQ_NUM)
3073: l_ce_wo_ln_rec.OP_DESCRIPTION := wo_line_rec.OP_DESCRIPTION;
3074: l_ce_wo_ln_rec.STANDARD_OPERATION_ID := wo_line_rec.STANDARD_OPERATION_ID;
3075: l_ce_wo_ln_rec.OP_DEPARTMENT_ID := wo_line_rec.OP_DEPARTMENT_ID;
3076: l_ce_wo_ln_rec.OP_LONG_DESCRIPTION := wo_line_rec.OP_LONG_DESCRIPTION;
3077: l_ce_wo_ln_rec.RES_SEQ_NUM := wo_line_rec.RES_SEQ_NUM;
3078: l_ce_wo_ln_rec.RES_ID := wo_line_rec.RES_ID;

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

3557: p_owning_department_id => l_ce_wo_ln_tbl(i).OWNING_DEPARTMENT_ID,
3558: p_user_defined_status_id => l_ce_wo_ln_tbl(i).USER_DEFINED_STATUS_ID,
3559: p_op_seq_num => l_ce_wo_ln_tbl(i).OP_SEQ_NUM,
3560: p_op_description => l_ce_wo_ln_tbl(i).OP_DESCRIPTION,
3561: p_standard_operation_id => l_ce_wo_ln_tbl(i).STANDARD_OPERATION_ID,
3562: p_op_department_id => l_ce_wo_ln_tbl(i).OP_DEPARTMENT_ID,
3563: p_op_long_description => l_ce_wo_ln_tbl(i).OP_LONG_DESCRIPTION,
3564: p_res_seq_num => l_ce_wo_ln_tbl(i).RES_SEQ_NUM,
3565: p_res_id => l_ce_wo_ln_tbl(i).RES_ID,

Line 3780: -- standard start of API savepoint

3776:
3777: BEGIN
3778:
3779: -------------------------------------------------------------------------
3780: -- standard start of API savepoint
3781: -------------------------------------------------------------------------
3782: --dbms_output.put_line('1');
3783: SAVEPOINT CREATE_CU_WORKORDERS;
3784:

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

3782: --dbms_output.put_line('1');
3783: SAVEPOINT CREATE_CU_WORKORDERS;
3784:
3785: -------------------------------------------------------------------------
3786: -- standard call to check for call compatibility
3787: -------------------------------------------------------------------------
3788: IF NOT fnd_api.compatible_api_call (
3789: l_api_version,
3790: p_api_version,

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

4598:
4599: l_stmt_num := 80;
4600: x_eam_wo_rec := l_eam_wo_rec;
4601:
4602: -- Standard Call to get message count and if count = 1, get message info
4603: FND_MSG_PUB.Count_And_Get (
4604: p_count => x_msg_count,
4605: p_data => x_msg_data );
4606:

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

4668: l_eam_op_rec := x_eam_op_rec;
4669:
4670: l_eam_op_rec.organization_id := p_ce_line_rec.organization_id;
4671: l_eam_op_rec.operation_seq_num := p_ce_line_rec.op_seq_num;
4672: --l_eam_op_rec.standard_operation_id := p_ce_line_rec.standard_operation_id;
4673: l_eam_op_rec.standard_operation_id := null;
4674: l_eam_op_rec.department_id := p_ce_line_rec.op_department_id;
4675: l_eam_op_rec.description := p_ce_line_rec.op_description;
4676: l_eam_op_rec.start_date := nvl(p_ce_line_rec.scheduled_start_date, sysdate);

Line 4673: l_eam_op_rec.standard_operation_id := null;

4669:
4670: l_eam_op_rec.organization_id := p_ce_line_rec.organization_id;
4671: l_eam_op_rec.operation_seq_num := p_ce_line_rec.op_seq_num;
4672: --l_eam_op_rec.standard_operation_id := p_ce_line_rec.standard_operation_id;
4673: l_eam_op_rec.standard_operation_id := null;
4674: l_eam_op_rec.department_id := p_ce_line_rec.op_department_id;
4675: l_eam_op_rec.description := p_ce_line_rec.op_description;
4676: l_eam_op_rec.start_date := nvl(p_ce_line_rec.scheduled_start_date, sysdate);
4677: l_eam_op_rec.completion_date := nvl(p_ce_line_rec.scheduled_completion_date, sysdate);

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

4682:
4683: x_eam_op_rec := l_eam_op_rec;
4684:
4685:
4686: -- Standard Call to get message count and if count = 1, get message info
4687: FND_MSG_PUB.Count_And_Get (
4688: p_count => x_msg_count,
4689: p_data => x_msg_data );
4690:

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

4791: l_eam_res_rec.autocharge_type := l_autocharge;
4792:
4793: x_eam_res_rec := l_eam_res_rec;
4794:
4795: -- Standard Call to get message count and if count = 1, get message info
4796: FND_MSG_PUB.Count_And_Get (
4797: p_count => x_msg_count,
4798: p_data => x_msg_data );
4799:

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

4904:
4905: x_eam_mat_rec := l_eam_mat_rec;
4906: x_eam_direct_rec := l_eam_direct_rec;
4907:
4908: -- Standard Call to get message count and if count = 1, get message info
4909: FND_MSG_PUB.Count_And_Get (
4910: p_count => x_msg_count,
4911: p_data => x_msg_data );
4912:

Line 5144: ,p_standard_operation_id => l_est_workorder_line_rec.STANDARD_OPERATION_ID

5140: ,p_owning_department_id => l_est_workorder_line_rec.OWNING_DEPARTMENT_ID
5141: ,p_user_defined_status_id => NULL
5142: ,p_op_seq_num => l_est_workorder_line_rec.OP_SEQ_NUM
5143: ,p_op_description => l_est_workorder_line_rec.OP_DESCRIPTION
5144: ,p_standard_operation_id => l_est_workorder_line_rec.STANDARD_OPERATION_ID
5145: ,p_op_department_id => l_est_workorder_line_rec.OP_DEPARTMENT_ID
5146: ,p_op_long_description => l_est_workorder_line_rec.OP_LONG_DESCRIPTION
5147: ,p_res_seq_num => l_est_workorder_line_rec.RES_SEQ_NUM
5148: ,p_res_id => l_est_workorder_line_rec.RES_ID

Line 5252: ,p_standard_operation_id => l_est_workorder_line_rec.STANDARD_OPERATION_ID

5248: ,p_owning_department_id => l_est_workorder_line_rec.OWNING_DEPARTMENT_ID
5249: ,p_user_defined_status_id => l_est_workorder_line_rec.USER_DEFINED_STATUS_ID
5250: ,p_op_seq_num => l_est_workorder_line_rec.OP_SEQ_NUM
5251: ,p_op_description => l_est_workorder_line_rec.OP_DESCRIPTION
5252: ,p_standard_operation_id => l_est_workorder_line_rec.STANDARD_OPERATION_ID
5253: ,p_op_department_id => l_est_workorder_line_rec.OP_DEPARTMENT_ID
5254: ,p_op_long_description => l_est_workorder_line_rec.OP_LONG_DESCRIPTION
5255: ,p_res_seq_num => l_est_workorder_line_rec.RES_SEQ_NUM
5256: ,p_res_id => l_est_workorder_line_rec.RES_ID