DBA Data[Home] [Help]

APPS.BOM_DEFAULT_OP_RES dependencies on STANDARD

Line 239: , p_standard_rate_flag IN NUMBER

235: , p_resource_id IN NUMBER
236: , p_activity_id IN NUMBER
237: , p_autocharge_type IN NUMBER
238: , p_basis_type IN NUMBER
239: , p_standard_rate_flag IN NUMBER
240: , p_org_id IN NUMBER
241: , x_activity_id IN OUT NOCOPY NUMBER
242: , x_autocharge_type IN OUT NOCOPY NUMBER
243: , x_basis_type IN OUT NOCOPY NUMBER

Line 244: , x_standard_rate_flag IN OUT NOCOPY NUMBER

240: , p_org_id IN NUMBER
241: , x_activity_id IN OUT NOCOPY NUMBER
242: , x_autocharge_type IN OUT NOCOPY NUMBER
243: , x_basis_type IN OUT NOCOPY NUMBER
244: , x_standard_rate_flag IN OUT NOCOPY NUMBER
245: )
246: IS
247:
248: CURSOR l_res_attr_csr( p_op_seq_id NUMBER

Line 260: , NVL(br.standard_rate_flag, 1) standard_rate_flag

256: 3, 2,
257: br.AUTOCHARGE_TYPE),
258: NVL(br.AUTOCHARGE_TYPE, 2)
259: ) default_autocharge
260: , NVL(br.standard_rate_flag, 1) standard_rate_flag
261: FROM BOM_RESOURCES br
262: , BOM_DEPARTMENTS bd
263: , BOM_OPERATION_SEQUENCES bos
264: , CST_ACTIVITIES_VAL_V ca

Line 298: IF p_standard_rate_flag IS NULL OR p_standard_rate_flag = FND_API.G_MISS_NUM

294: ELSE
295: x_basis_type := p_basis_type ;
296: END IF ;
297:
298: IF p_standard_rate_flag IS NULL OR p_standard_rate_flag = FND_API.G_MISS_NUM
299: THEN
300:
301: x_standard_rate_flag := NVL(l_res_attr_rec.standard_rate_flag,1) ;
302:

Line 301: x_standard_rate_flag := NVL(l_res_attr_rec.standard_rate_flag,1) ;

297:
298: IF p_standard_rate_flag IS NULL OR p_standard_rate_flag = FND_API.G_MISS_NUM
299: THEN
300:
301: x_standard_rate_flag := NVL(l_res_attr_rec.standard_rate_flag,1) ;
302:
303: ELSE
304: x_standard_rate_flag := p_standard_rate_flag ;
305:

Line 304: x_standard_rate_flag := p_standard_rate_flag ;

300:
301: x_standard_rate_flag := NVL(l_res_attr_rec.standard_rate_flag,1) ;
302:
303: ELSE
304: x_standard_rate_flag := p_standard_rate_flag ;
305:
306: END IF ;
307: END LOOP ;
308:

Line 708: IF l_rev_op_resource_rec.Standard_Rate_Flag IS NULL

704: l_rev_op_resource_rec.Resource_Sequence_Number
705: := p_old_rev_op_resource_rec.Resource_Sequence_Number ;
706: END IF ;
707:
708: IF l_rev_op_resource_rec.Standard_Rate_Flag IS NULL
709: THEN
710: l_rev_op_resource_rec.Standard_Rate_Flag
711: := p_old_rev_op_resource_rec.Standard_Rate_Flag ;
712: END IF ;

Line 710: l_rev_op_resource_rec.Standard_Rate_Flag

706: END IF ;
707:
708: IF l_rev_op_resource_rec.Standard_Rate_Flag IS NULL
709: THEN
710: l_rev_op_resource_rec.Standard_Rate_Flag
711: := p_old_rev_op_resource_rec.Standard_Rate_Flag ;
712: END IF ;
713:
714:

Line 711: := p_old_rev_op_resource_rec.Standard_Rate_Flag ;

707:
708: IF l_rev_op_resource_rec.Standard_Rate_Flag IS NULL
709: THEN
710: l_rev_op_resource_rec.Standard_Rate_Flag
711: := p_old_rev_op_resource_rec.Standard_Rate_Flag ;
712: END IF ;
713:
714:
715: IF l_rev_op_resource_rec.Assigned_Units IS NULL

Line 1075: -- Standard_Rate_Flag

1071: --
1072: -- Default Activity_Id,
1073: -- Autocharge_Type,
1074: -- Basis_Type,
1075: -- Standard_Rate_Flag
1076: --
1077: ************************************************************/
1078: IF l_rev_op_resource_rec.transaction_type = BOM_Rtg_Globals.G_OPR_CREATE
1079: AND

Line 1086: l_rev_op_resource_rec.standard_rate_flag IS NULL OR

1082: l_rev_op_resource_rec.autocharge_type IS NULL OR
1083: l_rev_op_resource_rec.autocharge_type = FND_API.G_MISS_NUM OR
1084: l_rev_op_resource_rec.basis_type IS NULL OR
1085: l_rev_op_resource_rec.basis_type = FND_API.G_MISS_NUM OR
1086: l_rev_op_resource_rec.standard_rate_flag IS NULL OR
1087: l_rev_op_resource_rec.standard_rate_flag = FND_API.G_MISS_NUM
1088: )
1089: THEN
1090: Get_Res_Attributes

Line 1087: l_rev_op_resource_rec.standard_rate_flag = FND_API.G_MISS_NUM

1083: l_rev_op_resource_rec.autocharge_type = FND_API.G_MISS_NUM OR
1084: l_rev_op_resource_rec.basis_type IS NULL OR
1085: l_rev_op_resource_rec.basis_type = FND_API.G_MISS_NUM OR
1086: l_rev_op_resource_rec.standard_rate_flag IS NULL OR
1087: l_rev_op_resource_rec.standard_rate_flag = FND_API.G_MISS_NUM
1088: )
1089: THEN
1090: Get_Res_Attributes
1091: ( p_operation_sequence_id => l_rev_op_res_unexp_rec.operation_sequence_id

Line 1096: , p_standard_rate_flag => l_rev_op_resource_rec.standard_rate_flag

1092: , p_resource_id => l_rev_op_res_unexp_rec.resource_id
1093: , p_activity_id => l_rev_op_res_unexp_rec.activity_id
1094: , p_autocharge_type => l_rev_op_resource_rec.autocharge_type
1095: , p_basis_type => l_rev_op_resource_rec.basis_type
1096: , p_standard_rate_flag => l_rev_op_resource_rec.standard_rate_flag
1097: , p_org_id => l_rev_op_res_unexp_rec.organization_id
1098: , x_activity_id => l_rev_op_res_unexp_rec.activity_id
1099: , x_autocharge_type => l_rev_op_resource_rec.autocharge_type
1100: , x_basis_type => l_rev_op_resource_rec.basis_type

Line 1101: , x_standard_rate_flag => l_rev_op_resource_rec.standard_rate_flag ) ;

1097: , p_org_id => l_rev_op_res_unexp_rec.organization_id
1098: , x_activity_id => l_rev_op_res_unexp_rec.activity_id
1099: , x_autocharge_type => l_rev_op_resource_rec.autocharge_type
1100: , x_basis_type => l_rev_op_resource_rec.basis_type
1101: , x_standard_rate_flag => l_rev_op_resource_rec.standard_rate_flag ) ;
1102:
1103: END IF ;
1104:
1105: