DBA Data[Home] [Help]

APPS.EAM_ACTIVITY_PUB dependencies on STANDARD

Line 241: IF l_wip_operation_row.standard_operation_id is not NULL THEN

237: p_work_order_rec.wip_entity_id)
238: LOOP
239:
240: -- added for bug#13519051
241: IF l_wip_operation_row.standard_operation_id is not NULL THEN
242: select operation_code into l_code
243: from bom_standard_operations
244: where standard_operation_id = l_wip_operation_row.standard_operation_id;
245: ELSE

Line 243: from bom_standard_operations

239:
240: -- added for bug#13519051
241: IF l_wip_operation_row.standard_operation_id is not NULL THEN
242: select operation_code into l_code
243: from bom_standard_operations
244: where standard_operation_id = l_wip_operation_row.standard_operation_id;
245: ELSE
246: l_code := NULL;
247: END IF;

Line 244: where standard_operation_id = l_wip_operation_row.standard_operation_id;

240: -- added for bug#13519051
241: IF l_wip_operation_row.standard_operation_id is not NULL THEN
242: select operation_code into l_code
243: from bom_standard_operations
244: where standard_operation_id = l_wip_operation_row.standard_operation_id;
245: ELSE
246: l_code := NULL;
247: END IF;
248:

Line 256: l_operation_tbl(l_operation_tbl_index).standard_operation_code := l_code; -- 13519051

252: l_operation_tbl(l_operation_tbl_index).Transaction_Type := l_create_txn_type;
253: l_operation_tbl(l_operation_tbl_index).Organization_Code := l_rtg_header_rec.Organization_Code;
254: l_operation_tbl(l_operation_tbl_index).Assembly_Item_Name := l_rtg_header_rec.Assembly_Item_Name;
255: l_operation_tbl(l_operation_tbl_index).Operation_Sequence_Number := l_wip_operation_row.Operation_Seq_Num;
256: l_operation_tbl(l_operation_tbl_index).standard_operation_code := l_code; -- 13519051
257: l_operation_tbl(l_operation_tbl_index).Start_Effective_Date := l_effectivity_date;
258: l_operation_tbl(l_operation_tbl_index).Department_Code :=
259: EAM_ActivityUtilities_PVT.Get_Department_Code(l_wip_operation_row.Organization_Id,
260: l_wip_operation_row.department_id);

Line 361: select wo.standard_operation_id into l_st_op_id

357: p_work_order_rec.wip_entity_id)
358: LOOP
359:
360: -- added for bug#13519051
361: select wo.standard_operation_id into l_st_op_id
362: from wip_operations wo
363: where wo.wip_entity_id= l_wip_resource_row.wip_entity_id
364: and wo.operation_seq_num=l_wip_resource_row.operation_seq_num
365: and wo.organization_id=l_wip_resource_row.organization_id;

Line 401: l_op_resource_tbl(l_op_resource_tbl_index).Standard_Rate_Flag := l_wip_resource_row.Standard_Rate_Flag;

397: EAM_ActivityUtilities_PVT.Get_Cost_Activity(l_wip_resource_row.Activity_Id);
398: l_op_resource_tbl(l_op_resource_tbl_index).Schedule_Flag := l_wip_resource_row.Scheduled_Flag;
399: l_op_resource_tbl(l_op_resource_tbl_index).Assigned_Units := l_wip_resource_row.Assigned_Units;
400: l_op_resource_tbl(l_op_resource_tbl_index).Autocharge_Type := l_wip_resource_row.Autocharge_Type;
401: l_op_resource_tbl(l_op_resource_tbl_index).Standard_Rate_Flag := l_wip_resource_row.Standard_Rate_Flag;
402: l_op_resource_tbl(l_op_resource_tbl_index).Principle_Flag := l_wip_resource_row.Principle_Flag;
403:
404: l_op_resource_tbl(l_op_resource_tbl_index).Attribute_Category := l_wip_resource_row.Attribute_Category;
405: l_op_resource_tbl(l_op_resource_tbl_index).Attribute1 := l_wip_resource_row.Attribute1;

Line 993: -- Standard Start of API savepoint

989:
990:
991: -- ======================================================================
992: BEGIN
993: -- Standard Start of API savepoint
994: SAVEPOINT Create_Activity_PUB;
995: -- Standard call to check for call compatibility.
996: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
997: p_api_version ,

Line 995: -- Standard call to check for call compatibility.

991: -- ======================================================================
992: BEGIN
993: -- Standard Start of API savepoint
994: SAVEPOINT Create_Activity_PUB;
995: -- Standard call to check for call compatibility.
996: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
997: p_api_version ,
998: l_api_name ,
999: G_PKG_NAME )

Line 1272: -- Standard check of p_commit.

1268:
1269: -- ======================================================================
1270:
1271: -- End of API body.
1272: -- Standard check of p_commit.
1273: IF FND_API.To_Boolean( p_commit ) THEN
1274: COMMIT WORK;
1275: END IF;
1276: -- Standard call to get message count and if count is 1, get message info.

Line 1276: -- Standard call to get message count and if count is 1, get message info.

1272: -- Standard check of p_commit.
1273: IF FND_API.To_Boolean( p_commit ) THEN
1274: COMMIT WORK;
1275: END IF;
1276: -- Standard call to get message count and if count is 1, get message info.
1277: FND_MSG_PUB.Count_And_Get
1278: ( p_count => x_msg_count ,
1279: p_data => x_msg_data
1280: );

Line 1435: -- Standard Start of API savepoint

1431: l_x_act_num_association_tbl EAM_Activity_PUB.Activity_Association_Tbl_Type;
1432: l_x_activity_association_tbl EAM_Activity_PUB.Activity_Association_Tbl_Type;
1433:
1434: BEGIN
1435: -- Standard Start of API savepoint
1436: SAVEPOINT Copy_Activity_PUB;
1437: -- Standard call to check for call compatibility.
1438: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1439: p_api_version ,

Line 1437: -- Standard call to check for call compatibility.

1433:
1434: BEGIN
1435: -- Standard Start of API savepoint
1436: SAVEPOINT Copy_Activity_PUB;
1437: -- Standard call to check for call compatibility.
1438: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1439: p_api_version ,
1440: l_api_name ,
1441: G_PKG_NAME )

Line 1838: -- Standard check of p_commit.

1834: -- ======================================================================
1835:
1836:
1837: -- End of API body.
1838: -- Standard check of p_commit.
1839: IF FND_API.To_Boolean( p_commit ) THEN
1840: COMMIT WORK;
1841: END IF;
1842: -- Standard call to get message count and if count is 1, get message info.

Line 1842: -- Standard call to get message count and if count is 1, get message info.

1838: -- Standard check of p_commit.
1839: IF FND_API.To_Boolean( p_commit ) THEN
1840: COMMIT WORK;
1841: END IF;
1842: -- Standard call to get message count and if count is 1, get message info.
1843: FND_MSG_PUB.Count_And_Get
1844: ( p_count => x_msg_count ,
1845: p_data => x_msg_data
1846: );

Line 2180: -- Standard Start of API savepoint

2176: l_x_master_item_return_status VARCHAR2(1);
2177: l_x_master_item_error_tbl INV_Item_GRP.Error_tbl_type;
2178:
2179: BEGIN
2180: -- Standard Start of API savepoint
2181: SAVEPOINT Create_Act_With_Templ_PUB;
2182: -- Standard call to check for call compatibility.
2183: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2184: p_api_version ,

Line 2182: -- Standard call to check for call compatibility.

2178:
2179: BEGIN
2180: -- Standard Start of API savepoint
2181: SAVEPOINT Create_Act_With_Templ_PUB;
2182: -- Standard call to check for call compatibility.
2183: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2184: p_api_version ,
2185: l_api_name ,
2186: G_PKG_NAME )

Line 2323: -- Standard check of p_commit.

2319:
2320: -- =============================================================
2321:
2322: -- End of API body.
2323: -- Standard check of p_commit.
2324: IF FND_API.To_Boolean( p_commit ) THEN
2325: COMMIT WORK;
2326: END IF;
2327: -- Standard call to get message count and if count is 1, get message info.

Line 2327: -- Standard call to get message count and if count is 1, get message info.

2323: -- Standard check of p_commit.
2324: IF FND_API.To_Boolean( p_commit ) THEN
2325: COMMIT WORK;
2326: END IF;
2327: -- Standard call to get message count and if count is 1, get message info.
2328: FND_MSG_PUB.Count_And_Get
2329: ( p_count => x_msg_count ,
2330: p_data => x_msg_data
2331: );

Line 2983: -- Standard call to check for call compatibility.

2979:
2980:
2981: BEGIN
2982: SAVEPOINT EAM_Activity_PUB;
2983: -- Standard call to check for call compatibility.
2984: --EAM_ActivityUtilities_PVT.Open_Debug_Session;
2985: IF NOT fnd_api.compatible_api_call(
2986: l_api_version
2987: ,p_api_version

Line 3160: -- Standard call to get message count and if count is 1, get message info.

3156: RAISE FND_API.G_EXC_ERROR;
3157: END IF;
3158:
3159:
3160: -- Standard call to get message count and if count is 1, get message info.
3161: --fnd_msg_pub.count_and_get(p_count => x_msg_count
3162: -- ,p_data => x_msg_data);
3163: -- commented for BUG# 5484686
3164: