594: Select rowid,
595: operation_sequence_id,
596: routing_sequence_id,
597: operation_seq_num,
598: standard_operation_id,
599: department_id,
600: operation_lead_time_percent,
601: minimum_transfer_quantity,
602: count_point_type,
777: l_operation_rec.new_operation_seq_num :=
778: l_interface_rec.new_operation_seq_num;
779: End if;
780:
781: If l_interface_rec.standard_operation_id = G_NullNum then
782: l_operation_rec.standard_operation_id := null;
783: Elsif l_interface_rec.transaction_type = G_Update then
784: l_operation_rec.standard_operation_id :=
785: nvl(l_interface_rec.standard_operation_id, Fnd_Api.G_Miss_Num);
778: l_interface_rec.new_operation_seq_num;
779: End if;
780:
781: If l_interface_rec.standard_operation_id = G_NullNum then
782: l_operation_rec.standard_operation_id := null;
783: Elsif l_interface_rec.transaction_type = G_Update then
784: l_operation_rec.standard_operation_id :=
785: nvl(l_interface_rec.standard_operation_id, Fnd_Api.G_Miss_Num);
786: Else
780:
781: If l_interface_rec.standard_operation_id = G_NullNum then
782: l_operation_rec.standard_operation_id := null;
783: Elsif l_interface_rec.transaction_type = G_Update then
784: l_operation_rec.standard_operation_id :=
785: nvl(l_interface_rec.standard_operation_id, Fnd_Api.G_Miss_Num);
786: Else
787: l_operation_rec.standard_operation_id :=
788: l_interface_rec.standard_operation_id;
781: If l_interface_rec.standard_operation_id = G_NullNum then
782: l_operation_rec.standard_operation_id := null;
783: Elsif l_interface_rec.transaction_type = G_Update then
784: l_operation_rec.standard_operation_id :=
785: nvl(l_interface_rec.standard_operation_id, Fnd_Api.G_Miss_Num);
786: Else
787: l_operation_rec.standard_operation_id :=
788: l_interface_rec.standard_operation_id;
789: End if;
783: Elsif l_interface_rec.transaction_type = G_Update then
784: l_operation_rec.standard_operation_id :=
785: nvl(l_interface_rec.standard_operation_id, Fnd_Api.G_Miss_Num);
786: Else
787: l_operation_rec.standard_operation_id :=
788: l_interface_rec.standard_operation_id;
789: End if;
790:
791: If l_interface_rec.operation_code = G_NullChar then
784: l_operation_rec.standard_operation_id :=
785: nvl(l_interface_rec.standard_operation_id, Fnd_Api.G_Miss_Num);
786: Else
787: l_operation_rec.standard_operation_id :=
788: l_interface_rec.standard_operation_id;
789: End if;
790:
791: If l_interface_rec.operation_code = G_NullChar then
792: l_operation_rec.operation_code := null;
1446: resource_id,
1447: resource_code,
1448: activity_id,
1449: activity,
1450: standard_rate_flag,
1451: assigned_units,
1452: usage_rate_or_amount,
1453: usage_rate_or_amount_inverse,
1454: basis_type,
1645: Else
1646: l_resource_rec.activity := l_interface_rec.activity;
1647: End if;
1648:
1649: If l_interface_rec.standard_rate_flag = G_NullNum then
1650: l_resource_rec.standard_rate_flag := null;
1651: Elsif l_interface_rec.transaction_type = G_Update then
1652: l_resource_rec.standard_rate_flag :=
1653: nvl(l_interface_rec.standard_rate_flag, Fnd_Api.G_Miss_Num);
1646: l_resource_rec.activity := l_interface_rec.activity;
1647: End if;
1648:
1649: If l_interface_rec.standard_rate_flag = G_NullNum then
1650: l_resource_rec.standard_rate_flag := null;
1651: Elsif l_interface_rec.transaction_type = G_Update then
1652: l_resource_rec.standard_rate_flag :=
1653: nvl(l_interface_rec.standard_rate_flag, Fnd_Api.G_Miss_Num);
1654: Else
1648:
1649: If l_interface_rec.standard_rate_flag = G_NullNum then
1650: l_resource_rec.standard_rate_flag := null;
1651: Elsif l_interface_rec.transaction_type = G_Update then
1652: l_resource_rec.standard_rate_flag :=
1653: nvl(l_interface_rec.standard_rate_flag, Fnd_Api.G_Miss_Num);
1654: Else
1655: l_resource_rec.standard_rate_flag :=
1656: l_interface_rec.standard_rate_flag;
1649: If l_interface_rec.standard_rate_flag = G_NullNum then
1650: l_resource_rec.standard_rate_flag := null;
1651: Elsif l_interface_rec.transaction_type = G_Update then
1652: l_resource_rec.standard_rate_flag :=
1653: nvl(l_interface_rec.standard_rate_flag, Fnd_Api.G_Miss_Num);
1654: Else
1655: l_resource_rec.standard_rate_flag :=
1656: l_interface_rec.standard_rate_flag;
1657: End if;
1651: Elsif l_interface_rec.transaction_type = G_Update then
1652: l_resource_rec.standard_rate_flag :=
1653: nvl(l_interface_rec.standard_rate_flag, Fnd_Api.G_Miss_Num);
1654: Else
1655: l_resource_rec.standard_rate_flag :=
1656: l_interface_rec.standard_rate_flag;
1657: End if;
1658:
1659: If l_interface_rec.assigned_units = G_NullNum then
1652: l_resource_rec.standard_rate_flag :=
1653: nvl(l_interface_rec.standard_rate_flag, Fnd_Api.G_Miss_Num);
1654: Else
1655: l_resource_rec.standard_rate_flag :=
1656: l_interface_rec.standard_rate_flag;
1657: End if;
1658:
1659: If l_interface_rec.assigned_units = G_NullNum then
1660: l_resource_rec.assigned_units := null;
2451: Select organization_code
2452: From mtl_parameters
2453: Where organization_id = p_organization_id;
2454: BEGIN
2455: -- Standard call to check for call compatibility.
2456: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
2457: G_PKG_NAME) THEN
2458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2459: END IF;
2503: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2504: End if;
2505:
2506: -- End of API body.
2507: -- Standard call to get message count and if count is 1, get message info.
2508: FND_MSG_PUB.Count_And_Get(
2509: p_count => x_msg_count,
2510: p_data => x_msg_data
2511: );