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.B_STD_SUB_OP_RES_PKG dependencies on STANDARD

Line 5: X_Standard_Operation_Id NUMBER,

1: PACKAGE BODY B_STD_SUB_OP_RES_PKG as
2: /* $Header: BOMPSSRB.pls 120.0.12010000.2 2008/10/15 11:06:18 tbhande ship $ */
3:
4: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
5: X_Standard_Operation_Id NUMBER,
6: X_Resource_Id NUMBER,
7: X_SUBSTITUTE_GROUP_NUM NUMBER,
8: X_REPLACEMENT_GROUP_NUM NUMBER,
9: X_Activity_Id NUMBER,

Line 10: X_Standard_Rate_Flag NUMBER,

6: X_Resource_Id NUMBER,
7: X_SUBSTITUTE_GROUP_NUM NUMBER,
8: X_REPLACEMENT_GROUP_NUM NUMBER,
9: X_Activity_Id NUMBER,
10: X_Standard_Rate_Flag NUMBER,
11: X_Assigned_Units NUMBER,
12: X_Usage_Rate_Or_Amount NUMBER,
13: X_Usage_Rate_Or_Amount_Inverse NUMBER,
14: X_Basis_Type NUMBER,

Line 41: WHERE standard_operation_id = X_Standard_Operation_Id

37: X_Attribute15 VARCHAR2,
38: X_Schedule_Seq_Num NUMBER -- Bug 7370692
39: ) IS
40: CURSOR C IS SELECT rowid FROM BOM_STD_SUB_OP_RESOURCES
41: WHERE standard_operation_id = X_Standard_Operation_Id
42: AND replacement_group_num = X_Replacement_Group_Num;
43:
44: BEGIN
45: INSERT INTO BOM_STD_SUB_OP_RESOURCES(

Line 46: standard_operation_id,

42: AND replacement_group_num = X_Replacement_Group_Num;
43:
44: BEGIN
45: INSERT INTO BOM_STD_SUB_OP_RESOURCES(
46: standard_operation_id,
47: resource_id,
48: SUBSTITUTE_GROUP_NUM,
49: REPLACEMENT_GROUP_NUM,
50: activity_id,

Line 51: standard_rate_flag,

47: resource_id,
48: SUBSTITUTE_GROUP_NUM,
49: REPLACEMENT_GROUP_NUM,
50: activity_id,
51: standard_rate_flag,
52: assigned_units,
53: usage_rate_or_amount,
54: usage_rate_or_amount_inverse,
55: basis_type,

Line 81: X_Standard_Operation_Id,

77: attribute14,
78: attribute15,
79: schedule_seq_num -- Bug 7370692
80: ) VALUES (
81: X_Standard_Operation_Id,
82: X_Resource_Id,
83: X_SUBSTITUTE_GROUP_NUM,
84: X_REPLACEMENT_GROUP_NUM,
85: X_Activity_Id,

Line 86: X_Standard_Rate_Flag,

82: X_Resource_Id,
83: X_SUBSTITUTE_GROUP_NUM,
84: X_REPLACEMENT_GROUP_NUM,
85: X_Activity_Id,
86: X_Standard_Rate_Flag,
87: X_Assigned_Units,
88: X_Usage_Rate_Or_Amount,
89: X_Usage_Rate_Or_Amount_Inverse,
90: X_Basis_Type,

Line 129: X_Standard_Operation_Id NUMBER,

125: END Insert_Row;
126:
127:
128: PROCEDURE Lock_Row(X_Rowid VARCHAR2,
129: X_Standard_Operation_Id NUMBER,
130: X_Resource_Id NUMBER,
131: X_SUBSTITUTE_GROUP_NUM NUMBER,
132: X_REPLACEMENT_GROUP_NUM NUMBER,
133: X_Activity_Id NUMBER DEFAULT NULL,

Line 138: X_Standard_Rate_Flag NUMBER,

134: X_Usage_Rate_Or_Amount NUMBER,
135: X_Usage_Rate_Or_Amount_Inverse NUMBER,
136: X_Basis_Type NUMBER,
137: X_Autocharge_Type NUMBER,
138: X_Standard_Rate_Flag NUMBER,
139: X_Assigned_Units NUMBER DEFAULT NULL,
140: X_Schedule_Flag NUMBER,
141: X_Attribute_Category VARCHAR2 DEFAULT NULL,
142: X_Attribute1 VARCHAR2 DEFAULT NULL,

Line 163: FOR UPDATE of Standard_Operation_Id, Replacement_Group_Num NOWAIT;

159: CURSOR C IS
160: SELECT *
161: FROM BOM_STD_SUB_OP_RESOURCES
162: WHERE rowid = X_Rowid
163: FOR UPDATE of Standard_Operation_Id, Replacement_Group_Num NOWAIT;
164: Recinfo C%ROWTYPE;
165: BEGIN
166: OPEN C;
167: FETCH C INTO Recinfo;

Line 176: ( (Recinfo.standard_operation_id = X_Standard_Operation_Id)

172: end if;
173: CLOSE C;
174:
175: if (
176: ( (Recinfo.standard_operation_id = X_Standard_Operation_Id)
177: OR ( (Recinfo.standard_operation_id IS NULL)
178: AND (X_Standard_Operation_Id IS NULL)))
179: AND ( (Recinfo.resource_id = X_Resource_Id)
180: OR ( (Recinfo.resource_id IS NULL)

Line 177: OR ( (Recinfo.standard_operation_id IS NULL)

173: CLOSE C;
174:
175: if (
176: ( (Recinfo.standard_operation_id = X_Standard_Operation_Id)
177: OR ( (Recinfo.standard_operation_id IS NULL)
178: AND (X_Standard_Operation_Id IS NULL)))
179: AND ( (Recinfo.resource_id = X_Resource_Id)
180: OR ( (Recinfo.resource_id IS NULL)
181: AND (X_Resource_Id IS NULL)))

Line 178: AND (X_Standard_Operation_Id IS NULL)))

174:
175: if (
176: ( (Recinfo.standard_operation_id = X_Standard_Operation_Id)
177: OR ( (Recinfo.standard_operation_id IS NULL)
178: AND (X_Standard_Operation_Id IS NULL)))
179: AND ( (Recinfo.resource_id = X_Resource_Id)
180: OR ( (Recinfo.resource_id IS NULL)
181: AND (X_Resource_Id IS NULL)))
182: AND ( (Recinfo.activity_id = X_Activity_Id)

Line 201: AND ( (Recinfo.standard_rate_flag = X_Standard_Rate_Flag)

197: AND (X_Basis_Type IS NULL)))
198: AND ( (Recinfo.autocharge_type = X_Autocharge_Type)
199: OR ( (Recinfo.autocharge_type IS NULL)
200: AND (X_Autocharge_Type IS NULL)))
201: AND ( (Recinfo.standard_rate_flag = X_Standard_Rate_Flag)
202: OR ( (Recinfo.standard_rate_flag IS NULL)
203: AND (X_Standard_Rate_Flag IS NULL)))
204: AND ( (Recinfo.assigned_units = X_Assigned_Units)
205: OR ( (Recinfo.assigned_units IS NULL)

Line 202: OR ( (Recinfo.standard_rate_flag IS NULL)

198: AND ( (Recinfo.autocharge_type = X_Autocharge_Type)
199: OR ( (Recinfo.autocharge_type IS NULL)
200: AND (X_Autocharge_Type IS NULL)))
201: AND ( (Recinfo.standard_rate_flag = X_Standard_Rate_Flag)
202: OR ( (Recinfo.standard_rate_flag IS NULL)
203: AND (X_Standard_Rate_Flag IS NULL)))
204: AND ( (Recinfo.assigned_units = X_Assigned_Units)
205: OR ( (Recinfo.assigned_units IS NULL)
206: AND (X_Assigned_Units IS NULL)))

Line 203: AND (X_Standard_Rate_Flag IS NULL)))

199: OR ( (Recinfo.autocharge_type IS NULL)
200: AND (X_Autocharge_Type IS NULL)))
201: AND ( (Recinfo.standard_rate_flag = X_Standard_Rate_Flag)
202: OR ( (Recinfo.standard_rate_flag IS NULL)
203: AND (X_Standard_Rate_Flag IS NULL)))
204: AND ( (Recinfo.assigned_units = X_Assigned_Units)
205: OR ( (Recinfo.assigned_units IS NULL)
206: AND (X_Assigned_Units IS NULL)))
207: AND ( (Recinfo.schedule_flag = X_Schedule_Flag)

Line 273: X_Standard_Operation_Id NUMBER,

269: END Lock_Row;
270:
271:
272: PROCEDURE Update_Row(X_Rowid VARCHAR2,
273: X_Standard_Operation_Id NUMBER,
274: X_Resource_Id NUMBER,
275: X_SUBSTITUTE_GROUP_NUM NUMBER,
276: X_REPLACEMENT_GROUP_NUM NUMBER,
277: X_Activity_Id NUMBER DEFAULT NULL,

Line 285: X_Standard_Rate_Flag NUMBER,

281: X_Usage_Rate_Or_Amount NUMBER,
282: X_Usage_Rate_Or_Amount_Inverse NUMBER,
283: X_Basis_Type NUMBER,
284: X_Autocharge_Type NUMBER,
285: X_Standard_Rate_Flag NUMBER,
286: X_Assigned_Units NUMBER DEFAULT NULL,
287: X_Schedule_Flag NUMBER,
288: X_Attribute_Category VARCHAR2 DEFAULT NULL,
289: X_Attribute1 VARCHAR2 DEFAULT NULL,

Line 309: standard_operation_id = X_Standard_Operation_Id,

305: ) IS
306: BEGIN
307: UPDATE BOM_STD_SUB_OP_RESOURCES
308: SET
309: standard_operation_id = X_Standard_Operation_Id,
310: resource_id = X_Resource_Id,
311: activity_id = X_Activity_Id,
312: SUBSTITUTE_GROUP_NUM = X_SUBSTITUTE_GROUP_NUM,
313: REPLACEMENT_GROUP_NUM = X_REPLACEMENT_GROUP_NUM,

Line 321: standard_rate_flag = X_Standard_Rate_Flag,

317: usage_rate_or_amount = X_Usage_Rate_Or_Amount,
318: usage_rate_or_amount_inverse = X_Usage_Rate_Or_Amount_Inverse,
319: basis_type = X_Basis_Type,
320: autocharge_type = X_Autocharge_Type,
321: standard_rate_flag = X_Standard_Rate_Flag,
322: assigned_units = X_Assigned_Units,
323: schedule_flag = X_Schedule_Flag,
324: attribute_category = X_Attribute_Category,
325: attribute1 = X_Attribute1,

Line 361: X_Standard_Operation_Id NUMBER,

357: end if;
358: END Delete_Row_Sub;
359:
360: PROCEDURE Check_Unique(X_Rowid VARCHAR2,
361: X_Standard_Operation_Id NUMBER,
362: X_Resource_Seq_Num NUMBER) IS
363: dummy NUMBER;
364: BEGIN
365: SELECT 1 INTO dummy FROM DUAL WHERE NOT EXISTS

Line 367: WHERE Standard_Operation_Id = X_Standard_Operation_Id

363: dummy NUMBER;
364: BEGIN
365: SELECT 1 INTO dummy FROM DUAL WHERE NOT EXISTS
366: (SELECT 1 FROM BOM_STD_OP_RESOURCES
367: WHERE Standard_Operation_Id = X_Standard_Operation_Id
368: AND Resource_Seq_Num = X_Resource_Seq_Num
369: AND ((X_Rowid IS NULL) OR (ROWID <> X_Rowid))
370: );
371: