DBA Data[Home] [Help]

APPS.BOM_ROUTINGINTERFACE_PUB dependencies on STANDARD

Line 598: standard_operation_id,

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,

Line 781: If l_interface_rec.standard_operation_id = G_NullNum then

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);

Line 782: l_operation_rec.standard_operation_id := null;

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

Line 784: l_operation_rec.standard_operation_id :=

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;

Line 785: nvl(l_interface_rec.standard_operation_id, Fnd_Api.G_Miss_Num);

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;

Line 787: l_operation_rec.standard_operation_id :=

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

Line 788: l_interface_rec.standard_operation_id;

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;

Line 1450: standard_rate_flag,

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,

Line 1649: If l_interface_rec.standard_rate_flag = G_NullNum then

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);

Line 1650: l_resource_rec.standard_rate_flag := null;

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

Line 1652: l_resource_rec.standard_rate_flag :=

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;

Line 1653: nvl(l_interface_rec.standard_rate_flag, Fnd_Api.G_Miss_Num);

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;

Line 1655: l_resource_rec.standard_rate_flag :=

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

Line 1656: l_interface_rec.standard_rate_flag;

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;

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

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;

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

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: );