eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BOM_OPRESOURCE_PVT dependencies on STANDARD

Line 79: br.standard_rate_flag

75: 3, 2,
76: 4, 2,
77: br.AUTOCHARGE_TYPE),
78: nvl(br.AUTOCHARGE_TYPE, 2)) default_autocharge,
79: br.standard_rate_flag
80: from bom_resources br,
81: bom_departments bd,
82: bom_operation_sequences bos
83: where br.resource_id = P_ResourceId

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

84: and bos.operation_sequence_id = P_OpSeqId
85: and bd.department_id = bos.department_id;
86:
87: BEGIN
88: -- Standard call to check for call compatibility.
89: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
90: G_PKG_NAME) THEN
91: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
92: END IF;

Line 274: If l_resource_rec.standard_rate_flag is null then

270: End if;
271: If l_resource_rec.autocharge_type is null then
272: l_resource_rec.autocharge_type := l_defaults_rec.default_autocharge;
273: End if;
274: If l_resource_rec.standard_rate_flag is null then
275: l_resource_rec.standard_rate_flag := l_defaults_rec.standard_rate_flag;
276: End if;
277: End loop; -- defaults
278:

Line 275: l_resource_rec.standard_rate_flag := l_defaults_rec.standard_rate_flag;

271: If l_resource_rec.autocharge_type is null then
272: l_resource_rec.autocharge_type := l_defaults_rec.default_autocharge;
273: End if;
274: If l_resource_rec.standard_rate_flag is null then
275: l_resource_rec.standard_rate_flag := l_defaults_rec.standard_rate_flag;
276: End if;
277: End loop; -- defaults
278:
279: x_resource_rec := l_resource_rec;

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

278:
279: x_resource_rec := l_resource_rec;
280: -- End of API body.
281:
282: -- Standard call to get message count and if count is 1, get message info.
283: FND_MSG_PUB.Count_And_Get(
284: p_count => x_msg_count,
285: p_data => x_msg_data
286: );

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

449: where bos.operation_sequence_id = P_OpSeqId
450: and bd.department_id = bos.department_id
451: and bd.location_id is not null);
452: BEGIN
453: -- Standard call to check for call compatibility.
454: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
455: G_PKG_NAME) THEN
456: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
457: END IF;

Line 624: -- check if basis type,standard rate flag, schedule flag

620: FND_MSG_PUB.Add;
621: Raise FND_API.G_EXC_ERROR;
622: End if;
623:
624: -- check if basis type,standard rate flag, schedule flag
625: -- and autocharge type are valid
626: If (l_resource_rec.basis_type not in (1,2)) or
627: (l_resource_rec.standard_rate_flag not in (1, 2)) or
628: (l_resource_rec.schedule_flag not in (1,2,3,4)) or

Line 627: (l_resource_rec.standard_rate_flag not in (1, 2)) or

623:
624: -- check if basis type,standard rate flag, schedule flag
625: -- and autocharge type are valid
626: If (l_resource_rec.basis_type not in (1,2)) or
627: (l_resource_rec.standard_rate_flag not in (1, 2)) or
628: (l_resource_rec.schedule_flag not in (1,2,3,4)) or
629: (l_resource_rec.autocharge_type not in (1,2,3,4)) then
630: Fnd_Message.Set_Name('BOM', 'BOM_OP_RES_LOOKUP_ERROR');
631: FND_MSG_PUB.Add;

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

722:
723: x_resource_rec := l_resource_rec;
724: -- End of API body.
725:
726: -- Standard call to get message count and if count is 1, get message info.
727: FND_MSG_PUB.Count_And_Get(
728: p_count => x_msg_count,
729: p_data => x_msg_data
730: );

Line 778: -- Standard Start of API savepoint

774: l_ProgramId number;
775: l_ApplicationId number;
776: l_ProgramUpdate date;
777: BEGIN
778: -- Standard Start of API savepoint
779: SAVEPOINT CreateResource_Pvt;
780: -- Standard call to check for call compatibility.
781: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
782: G_PKG_NAME) THEN

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

776: l_ProgramUpdate date;
777: BEGIN
778: -- Standard Start of API savepoint
779: SAVEPOINT CreateResource_Pvt;
780: -- Standard call to check for call compatibility.
781: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
782: G_PKG_NAME) THEN
783: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
784: END IF;

Line 814: If nvl(l_resource_rec.standard_rate_flag, Fnd_Api.G_Miss_Num) =

810: If l_resource_rec.activity_id = Fnd_Api.G_Miss_Num then
811: l_resource_rec.activity_id := null;
812: End if;
813:
814: If nvl(l_resource_rec.standard_rate_flag, Fnd_Api.G_Miss_Num) =
815: Fnd_Api.G_Miss_Num then
816: --bug 2117759 standard_rate_flag will be defaulted from res definition
817: l_resource_rec.standard_rate_flag := null;
818: End if;

Line 816: --bug 2117759 standard_rate_flag will be defaulted from res definition

812: End if;
813:
814: If nvl(l_resource_rec.standard_rate_flag, Fnd_Api.G_Miss_Num) =
815: Fnd_Api.G_Miss_Num then
816: --bug 2117759 standard_rate_flag will be defaulted from res definition
817: l_resource_rec.standard_rate_flag := null;
818: End if;
819:
820: If nvl(l_resource_rec.assigned_units, Fnd_Api.G_Miss_Num) =

Line 817: l_resource_rec.standard_rate_flag := null;

813:
814: If nvl(l_resource_rec.standard_rate_flag, Fnd_Api.G_Miss_Num) =
815: Fnd_Api.G_Miss_Num then
816: --bug 2117759 standard_rate_flag will be defaulted from res definition
817: l_resource_rec.standard_rate_flag := null;
818: End if;
819:
820: If nvl(l_resource_rec.assigned_units, Fnd_Api.G_Miss_Num) =
821: Fnd_Api.G_Miss_Num then

Line 998: standard_rate_flag,

994: operation_sequence_id,
995: resource_seq_num,
996: resource_id,
997: activity_id,
998: standard_rate_flag,
999: assigned_units,
1000: usage_rate_or_amount,
1001: usage_rate_or_amount_inverse,
1002: basis_type,

Line 1039: l_resource_rec.standard_rate_flag,

1035: l_resource_rec.operation_sequence_id,
1036: l_resource_rec.new_resource_seq_num,
1037: l_resource_rec.resource_id,
1038: l_resource_rec.activity_id,
1039: l_resource_rec.standard_rate_flag,
1040: l_resource_rec.assigned_units,
1041: round(l_resource_rec.usage_rate_or_amount,G_round_off_val), /* Bug 7322996 */
1042: round(l_resource_rec.usage_rate_or_amount_inverse,G_round_off_val), /* Bug 7322996 */
1043: l_resource_rec.basis_type,

Line 1079: -- Standard check of p_commit.

1075:
1076: x_resource_rec := l_resource_rec;
1077: -- End of API body.
1078:
1079: -- Standard check of p_commit.
1080: IF FND_API.To_Boolean(p_commit) THEN
1081: COMMIT WORK;
1082: END IF;
1083: -- Standard call to get message count and if count is 1, get message info.

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

1079: -- Standard check of p_commit.
1080: IF FND_API.To_Boolean(p_commit) THEN
1081: COMMIT WORK;
1082: END IF;
1083: -- Standard call to get message count and if count is 1, get message info.
1084: FND_MSG_PUB.Count_And_Get(
1085: p_count => x_msg_count,
1086: p_data => x_msg_data
1087: );

Line 1145: -- Standard Start of API savepoint

1141: Where bor.operation_sequence_id = P_OpSeqId
1142: And bor.resource_seq_num = P_SeqNum;
1143: l_ResourceFound BOOLEAN := false;
1144: BEGIN
1145: -- Standard Start of API savepoint
1146: SAVEPOINT UpdateResource_Pvt;
1147: -- Standard call to check for call compatibility.
1148: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
1149: G_PKG_NAME) THEN

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

1143: l_ResourceFound BOOLEAN := false;
1144: BEGIN
1145: -- Standard Start of API savepoint
1146: SAVEPOINT UpdateResource_Pvt;
1147: -- Standard call to check for call compatibility.
1148: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
1149: G_PKG_NAME) THEN
1150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1151: END IF;

Line 1198: If l_resource_rec.standard_rate_flag = Fnd_Api.G_Miss_Num then

1194: If l_resource_rec.activity_id = Fnd_Api.G_Miss_Num then
1195: l_resource_rec.activity_id := l_OldResource_rec.activity_id;
1196: End if;
1197:
1198: If l_resource_rec.standard_rate_flag = Fnd_Api.G_Miss_Num then
1199: l_resource_rec.standard_rate_flag :=
1200: l_OldResource_rec.standard_rate_flag;
1201: End if;
1202:

Line 1199: l_resource_rec.standard_rate_flag :=

1195: l_resource_rec.activity_id := l_OldResource_rec.activity_id;
1196: End if;
1197:
1198: If l_resource_rec.standard_rate_flag = Fnd_Api.G_Miss_Num then
1199: l_resource_rec.standard_rate_flag :=
1200: l_OldResource_rec.standard_rate_flag;
1201: End if;
1202:
1203: If l_resource_rec.assigned_units = Fnd_Api.G_Miss_Num then

Line 1200: l_OldResource_rec.standard_rate_flag;

1196: End if;
1197:
1198: If l_resource_rec.standard_rate_flag = Fnd_Api.G_Miss_Num then
1199: l_resource_rec.standard_rate_flag :=
1200: l_OldResource_rec.standard_rate_flag;
1201: End if;
1202:
1203: If l_resource_rec.assigned_units = Fnd_Api.G_Miss_Num then
1204: l_resource_rec.assigned_units := l_OldResource_rec.assigned_units;

Line 1351: standard_rate_flag = l_resource_rec.standard_rate_flag,

1347: update bom_operation_resources set
1348: resource_seq_num = l_resource_rec.new_resource_seq_num,
1349: resource_id = l_resource_rec.resource_id,
1350: activity_id = l_resource_rec.activity_id,
1351: standard_rate_flag = l_resource_rec.standard_rate_flag,
1352: assigned_units = l_resource_rec.assigned_units,
1353: usage_rate_or_amount = round(l_resource_rec.usage_rate_or_amount,G_round_off_val), /* Bug 7322996 */
1354: usage_rate_or_amount_inverse = round(l_resource_rec.usage_rate_or_amount_inverse,G_round_off_val), /* Bug 7322996 */
1355: basis_type = l_resource_rec.basis_type,

Line 1391: -- Standard check of p_commit.

1387:
1388: x_resource_rec := l_resource_rec;
1389: -- End of API body.
1390:
1391: -- Standard check of p_commit.
1392: IF FND_API.To_Boolean(p_commit) THEN
1393: COMMIT WORK;
1394: END IF;
1395: -- Standard call to get message count and if count is 1, get message info.

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

1391: -- Standard check of p_commit.
1392: IF FND_API.To_Boolean(p_commit) THEN
1393: COMMIT WORK;
1394: END IF;
1395: -- Standard call to get message count and if count is 1, get message info.
1396: FND_MSG_PUB.Count_And_Get(
1397: p_count => x_msg_count,
1398: p_data => x_msg_data
1399: );

Line 1444: -- Standard Start of API savepoint

1440: l_return_status VARCHAR2(1);
1441: l_msg_count NUMBER;
1442: l_msg_data VARCHAR2(2000);
1443: BEGIN
1444: -- Standard Start of API savepoint
1445: SAVEPOINT DeleteResource_Pvt;
1446: -- Standard call to check for call compatibility.
1447: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
1448: G_PKG_NAME) THEN

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

1442: l_msg_data VARCHAR2(2000);
1443: BEGIN
1444: -- Standard Start of API savepoint
1445: SAVEPOINT DeleteResource_Pvt;
1446: -- Standard call to check for call compatibility.
1447: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
1448: G_PKG_NAME) THEN
1449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1450: END IF;

Line 1494: -- Standard check of p_commit.

1490: End if; -- missing op resource
1491:
1492: -- End of API body.
1493:
1494: -- Standard check of p_commit.
1495: IF FND_API.To_Boolean(p_commit) THEN
1496: COMMIT WORK;
1497: END IF;
1498: -- Standard call to get message count and if count is 1, get message info.

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

1494: -- Standard check of p_commit.
1495: IF FND_API.To_Boolean(p_commit) THEN
1496: COMMIT WORK;
1497: END IF;
1498: -- Standard call to get message count and if count is 1, get message info.
1499: FND_MSG_PUB.Count_And_Get(
1500: p_count => x_msg_count,
1501: p_data => x_msg_data
1502: );