DBA Data[Home] [Help]

APPS.BOM_VALIDATE_OP_RES dependencies on STANDARD

Line 279: AND (p_rev_op_resource_rec.standard_rate_flag = p_old_rev_op_resource_rec.standard_rate_flag

275: AND (p_rev_op_res_unexp_rec.activity_id = p_old_rev_op_res_unexp_rec.activity_id
276: OR ( p_rev_op_res_unexp_rec.activity_id IS NULL
277: AND p_old_rev_op_res_unexp_rec.activity_id IS NULL )
278: )
279: AND (p_rev_op_resource_rec.standard_rate_flag = p_old_rev_op_resource_rec.standard_rate_flag
280: OR ( p_rev_op_resource_rec.standard_rate_flag IS NULL
281: AND p_old_rev_op_resource_rec.standard_rate_flag IS NULL )
282: )
283: AND (p_rev_op_resource_rec.assigned_units = p_old_rev_op_resource_rec.assigned_units

Line 280: OR ( p_rev_op_resource_rec.standard_rate_flag IS NULL

276: OR ( p_rev_op_res_unexp_rec.activity_id IS NULL
277: AND p_old_rev_op_res_unexp_rec.activity_id IS NULL )
278: )
279: AND (p_rev_op_resource_rec.standard_rate_flag = p_old_rev_op_resource_rec.standard_rate_flag
280: OR ( p_rev_op_resource_rec.standard_rate_flag IS NULL
281: AND p_old_rev_op_resource_rec.standard_rate_flag IS NULL )
282: )
283: AND (p_rev_op_resource_rec.assigned_units = p_old_rev_op_resource_rec.assigned_units
284: OR ( p_rev_op_resource_rec.assigned_units IS NULL

Line 281: AND p_old_rev_op_resource_rec.standard_rate_flag IS NULL )

277: AND p_old_rev_op_res_unexp_rec.activity_id IS NULL )
278: )
279: AND (p_rev_op_resource_rec.standard_rate_flag = p_old_rev_op_resource_rec.standard_rate_flag
280: OR ( p_rev_op_resource_rec.standard_rate_flag IS NULL
281: AND p_old_rev_op_resource_rec.standard_rate_flag IS NULL )
282: )
283: AND (p_rev_op_resource_rec.assigned_units = p_old_rev_op_resource_rec.assigned_units
284: OR ( p_rev_op_resource_rec.assigned_units IS NULL
285: AND p_old_rev_op_resource_rec.assigned_units IS NULL )

Line 1664: -- Standard Rate Flag

1660: l_return_status := FND_API.G_RET_STS_ERROR;
1661: END IF ;
1662:
1663:
1664: -- Standard Rate Flag
1665: IF p_rev_op_resource_rec.standard_rate_flag = FND_API.G_MISS_NUM
1666: THEN
1667: Error_Handler.Add_Error_Token
1668: ( p_Message_Name => 'BOM_RES_STD_RATE_MISSING'

Line 1665: IF p_rev_op_resource_rec.standard_rate_flag = FND_API.G_MISS_NUM

1661: END IF ;
1662:
1663:
1664: -- Standard Rate Flag
1665: IF p_rev_op_resource_rec.standard_rate_flag = FND_API.G_MISS_NUM
1666: THEN
1667: Error_Handler.Add_Error_Token
1668: ( p_Message_Name => 'BOM_RES_STD_RATE_MISSING'
1669: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 1780: -- Standard Rate Flag

1776: l_return_status := FND_API.G_RET_STS_ERROR;
1777: END IF;
1778:
1779:
1780: -- Standard Rate Flag
1781: IF p_rev_op_resource_rec.standard_rate_flag IS NOT NULL AND
1782: p_rev_op_resource_rec.standard_rate_flag NOT IN (1,2)
1783: AND p_rev_op_resource_rec.standard_rate_flag <> FND_API.G_MISS_NUM
1784: THEN

Line 1781: IF p_rev_op_resource_rec.standard_rate_flag IS NOT NULL AND

1777: END IF;
1778:
1779:
1780: -- Standard Rate Flag
1781: IF p_rev_op_resource_rec.standard_rate_flag IS NOT NULL AND
1782: p_rev_op_resource_rec.standard_rate_flag NOT IN (1,2)
1783: AND p_rev_op_resource_rec.standard_rate_flag <> FND_API.G_MISS_NUM
1784: THEN
1785: Error_Handler.Add_Error_Token

Line 1782: p_rev_op_resource_rec.standard_rate_flag NOT IN (1,2)

1778:
1779:
1780: -- Standard Rate Flag
1781: IF p_rev_op_resource_rec.standard_rate_flag IS NOT NULL AND
1782: p_rev_op_resource_rec.standard_rate_flag NOT IN (1,2)
1783: AND p_rev_op_resource_rec.standard_rate_flag <> FND_API.G_MISS_NUM
1784: THEN
1785: Error_Handler.Add_Error_Token
1786: ( p_Message_Name => 'BOM_RES_STD_RATE_INVALID'

Line 1783: AND p_rev_op_resource_rec.standard_rate_flag <> FND_API.G_MISS_NUM

1779:
1780: -- Standard Rate Flag
1781: IF p_rev_op_resource_rec.standard_rate_flag IS NOT NULL AND
1782: p_rev_op_resource_rec.standard_rate_flag NOT IN (1,2)
1783: AND p_rev_op_resource_rec.standard_rate_flag <> FND_API.G_MISS_NUM
1784: THEN
1785: Error_Handler.Add_Error_Token
1786: ( p_Message_Name => 'BOM_RES_STD_RATE_INVALID'
1787: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl