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_OP_RES_PKG dependencies on STANDARD

Line 6: X_Standard_Operation_Id NUMBER,

2: /* $Header: BOMPISRB.pls 115.7 2003/12/24 08:59:05 dpsingh ship $ */
3:
4:
5: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
6: X_Standard_Operation_Id NUMBER,
7: X_Resource_Id NUMBER,
8: X_Activity_Id NUMBER DEFAULT NULL,
9: X_Last_Update_Date DATE,
10: X_Last_Updated_By NUMBER,

Line 19: X_Standard_Rate_Flag NUMBER,

15: X_Usage_Rate_Or_Amount NUMBER,
16: X_Usage_Rate_Or_Amount_Inverse NUMBER,
17: X_Basis_Type NUMBER,
18: X_Autocharge_Type NUMBER,
19: X_Standard_Rate_Flag NUMBER,
20: X_Assigned_Units NUMBER DEFAULT NULL,
21: X_Schedule_Flag NUMBER,
22: X_Attribute_Category VARCHAR2 DEFAULT NULL,
23: X_Attribute1 VARCHAR2 DEFAULT NULL,

Line 42: X_Standard_Operation_Id => X_Standard_Operation_Id,

38: ) IS
39:
40: BEGIN
41: Insert_Row(X_Rowid => X_Rowid,
42: X_Standard_Operation_Id => X_Standard_Operation_Id,
43: X_Resource_Id => X_Resource_Id,
44: X_Substitute_Group_Num => NULL,
45: X_Activity_Id => X_Activity_Id,
46: X_Last_Update_Date => X_Last_Update_Date,

Line 56: X_Standard_Rate_Flag => X_Standard_Rate_Flag,

52: X_Usage_Rate_Or_Amount => X_Usage_Rate_Or_Amount,
53: X_Usage_Rate_Or_Amount_Inverse => X_Usage_Rate_Or_Amount_Inverse,
54: X_Basis_Type => X_Basis_Type,
55: X_Autocharge_Type => X_Autocharge_Type,
56: X_Standard_Rate_Flag => X_Standard_Rate_Flag,
57: X_Assigned_Units => X_Assigned_Units,
58: X_Schedule_Flag => X_Schedule_Flag,
59: X_Attribute_Category => X_Attribute_Category,
60: X_Attribute1 => X_Attribute1,

Line 81: X_Standard_Operation_Id NUMBER,

77:
78: END Insert_Row;
79:
80: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
81: X_Standard_Operation_Id NUMBER,
82: X_Resource_Id NUMBER,
83: X_Substitute_Group_Num NUMBER,
84: X_Activity_Id NUMBER DEFAULT NULL,
85: X_Last_Update_Date DATE,

Line 95: X_Standard_Rate_Flag NUMBER,

91: X_Usage_Rate_Or_Amount NUMBER,
92: X_Usage_Rate_Or_Amount_Inverse NUMBER,
93: X_Basis_Type NUMBER,
94: X_Autocharge_Type NUMBER,
95: X_Standard_Rate_Flag NUMBER,
96: X_Assigned_Units NUMBER DEFAULT NULL,
97: X_Schedule_Flag NUMBER,
98: X_Attribute_Category VARCHAR2 DEFAULT NULL,
99: X_Attribute1 VARCHAR2 DEFAULT NULL,

Line 116: WHERE standard_operation_id = X_Standard_Operation_Id

112: X_Attribute14 VARCHAR2 DEFAULT NULL,
113: X_Attribute15 VARCHAR2 DEFAULT NULL
114: ) IS
115: CURSOR C IS SELECT rowid FROM BOM_STD_OP_RESOURCES
116: WHERE standard_operation_id = X_Standard_Operation_Id
117: AND resource_seq_num = X_Resource_Seq_Num;
118:
119: BEGIN
120: INSERT INTO BOM_STD_OP_RESOURCES(

Line 121: standard_operation_id,

117: AND resource_seq_num = X_Resource_Seq_Num;
118:
119: BEGIN
120: INSERT INTO BOM_STD_OP_RESOURCES(
121: standard_operation_id,
122: resource_id,
123: substitute_group_num,
124: activity_id,
125: last_update_date,

Line 135: standard_rate_flag,

131: usage_rate_or_amount,
132: usage_rate_or_amount_inverse,
133: basis_type,
134: autocharge_type,
135: standard_rate_flag,
136: assigned_units,
137: schedule_flag,
138: attribute_category,
139: attribute1,

Line 155: X_Standard_Operation_Id,

151: attribute13,
152: attribute14,
153: attribute15
154: ) VALUES (
155: X_Standard_Operation_Id,
156: X_Resource_Id,
157: X_Substitute_Group_Num,
158: X_Activity_Id,
159: X_Last_Update_Date,

Line 169: X_Standard_Rate_Flag,

165: X_Usage_Rate_Or_Amount,
166: X_Usage_Rate_Or_Amount_Inverse,
167: X_Basis_Type,
168: X_Autocharge_Type,
169: X_Standard_Rate_Flag,
170: X_Assigned_Units,
171: X_Schedule_Flag,
172: X_Attribute_Category,
173: X_Attribute1,

Line 201: X_Standard_Operation_Id NUMBER,

197: CLOSE C;
198: END Insert_Row;
199:
200: PROCEDURE Lock_Row(X_Rowid VARCHAR2,
201: X_Standard_Operation_Id NUMBER,
202: X_Resource_Id NUMBER,
203: X_Activity_Id NUMBER DEFAULT NULL,
204: X_Resource_Seq_Num NUMBER,
205: X_Usage_Rate_Or_Amount NUMBER,

Line 209: X_Standard_Rate_Flag NUMBER,

205: X_Usage_Rate_Or_Amount NUMBER,
206: X_Usage_Rate_Or_Amount_Inverse NUMBER,
207: X_Basis_Type NUMBER,
208: X_Autocharge_Type NUMBER,
209: X_Standard_Rate_Flag NUMBER,
210: X_Assigned_Units NUMBER DEFAULT NULL,
211: X_Schedule_Flag NUMBER,
212: X_Attribute_Category VARCHAR2 DEFAULT NULL,
213: X_Attribute1 VARCHAR2 DEFAULT NULL,

Line 233: X_Standard_Operation_Id => X_Standard_Operation_Id,

229:
230: BEGIN
231:
232: Lock_Row(X_Rowid => X_Rowid,
233: X_Standard_Operation_Id => X_Standard_Operation_Id,
234: X_Resource_Id => X_Resource_Id,
235: X_Substitute_Group_Num => NULL,
236: X_Activity_Id => X_Activity_Id,
237: X_Resource_Seq_Num => X_Resource_Seq_Num,

Line 242: X_Standard_Rate_Flag => X_Standard_Rate_Flag,

238: X_Usage_Rate_Or_Amount => X_Usage_Rate_Or_Amount,
239: X_Usage_Rate_Or_Amount_Inverse => X_Usage_Rate_Or_Amount_Inverse,
240: X_Basis_Type => X_Basis_Type,
241: X_Autocharge_Type => X_Autocharge_Type,
242: X_Standard_Rate_Flag => X_Standard_Rate_Flag,
243: X_Assigned_Units => X_Assigned_Units,
244: X_Schedule_Flag => X_Schedule_Flag,
245: X_Attribute_Category => X_Attribute_Category,
246: X_Attribute1 => X_Attribute1,

Line 265: X_Standard_Operation_Id NUMBER,

261:
262: END Lock_Row;
263:
264: PROCEDURE Lock_Row(X_Rowid VARCHAR2,
265: X_Standard_Operation_Id NUMBER,
266: X_Resource_Id NUMBER,
267: X_Substitute_Group_Num NUMBER,
268: X_Activity_Id NUMBER DEFAULT NULL,
269: X_Resource_Seq_Num NUMBER,

Line 274: X_Standard_Rate_Flag NUMBER,

270: X_Usage_Rate_Or_Amount NUMBER,
271: X_Usage_Rate_Or_Amount_Inverse NUMBER,
272: X_Basis_Type NUMBER,
273: X_Autocharge_Type NUMBER,
274: X_Standard_Rate_Flag NUMBER,
275: X_Assigned_Units NUMBER DEFAULT NULL,
276: X_Schedule_Flag NUMBER,
277: X_Attribute_Category VARCHAR2 DEFAULT NULL,
278: X_Attribute1 VARCHAR2 DEFAULT NULL,

Line 298: FOR UPDATE of Standard_Operation_Id, Substitute_Group_Num NOWAIT;

294: CURSOR C IS
295: SELECT *
296: FROM BOM_STD_OP_RESOURCES
297: WHERE rowid = X_Rowid
298: FOR UPDATE of Standard_Operation_Id, Substitute_Group_Num NOWAIT;
299: Recinfo C%ROWTYPE;
300: BEGIN
301: OPEN C;
302: FETCH C INTO Recinfo;

Line 310: ( (Recinfo.standard_operation_id = X_Standard_Operation_Id)

306: APP_EXCEPTION.RAISE_EXCEPTION;
307: end if;
308: CLOSE C;
309: if (
310: ( (Recinfo.standard_operation_id = X_Standard_Operation_Id)
311: OR ( (Recinfo.standard_operation_id IS NULL)
312: AND (X_Standard_Operation_Id IS NULL)))
313: AND ( (Recinfo.resource_id = X_Resource_Id)
314: OR ( (Recinfo.resource_id IS NULL)

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

307: end if;
308: CLOSE C;
309: if (
310: ( (Recinfo.standard_operation_id = X_Standard_Operation_Id)
311: OR ( (Recinfo.standard_operation_id IS NULL)
312: AND (X_Standard_Operation_Id IS NULL)))
313: AND ( (Recinfo.resource_id = X_Resource_Id)
314: OR ( (Recinfo.resource_id IS NULL)
315: AND (X_Resource_Id IS NULL)))

Line 312: AND (X_Standard_Operation_Id IS NULL)))

308: CLOSE C;
309: if (
310: ( (Recinfo.standard_operation_id = X_Standard_Operation_Id)
311: OR ( (Recinfo.standard_operation_id IS NULL)
312: AND (X_Standard_Operation_Id IS NULL)))
313: AND ( (Recinfo.resource_id = X_Resource_Id)
314: OR ( (Recinfo.resource_id IS NULL)
315: AND (X_Resource_Id IS NULL)))
316: AND ( (Recinfo.substitute_group_num = X_Substitute_Group_Num)

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

333: AND (X_Basis_Type IS NULL)))
334: AND ( (Recinfo.autocharge_type = X_Autocharge_Type)
335: OR ( (Recinfo.autocharge_type IS NULL)
336: AND (X_Autocharge_Type IS NULL)))
337: AND ( (Recinfo.standard_rate_flag = X_Standard_Rate_Flag)
338: OR ( (Recinfo.standard_rate_flag IS NULL)
339: AND (X_Standard_Rate_Flag IS NULL)))
340: AND ( (Recinfo.assigned_units = X_Assigned_Units)
341: OR ( (Recinfo.assigned_units IS NULL)

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

334: AND ( (Recinfo.autocharge_type = X_Autocharge_Type)
335: OR ( (Recinfo.autocharge_type IS NULL)
336: AND (X_Autocharge_Type IS NULL)))
337: AND ( (Recinfo.standard_rate_flag = X_Standard_Rate_Flag)
338: OR ( (Recinfo.standard_rate_flag IS NULL)
339: AND (X_Standard_Rate_Flag IS NULL)))
340: AND ( (Recinfo.assigned_units = X_Assigned_Units)
341: OR ( (Recinfo.assigned_units IS NULL)
342: AND (X_Assigned_Units IS NULL)))

Line 339: AND (X_Standard_Rate_Flag IS NULL)))

335: OR ( (Recinfo.autocharge_type IS NULL)
336: AND (X_Autocharge_Type IS NULL)))
337: AND ( (Recinfo.standard_rate_flag = X_Standard_Rate_Flag)
338: OR ( (Recinfo.standard_rate_flag IS NULL)
339: AND (X_Standard_Rate_Flag IS NULL)))
340: AND ( (Recinfo.assigned_units = X_Assigned_Units)
341: OR ( (Recinfo.assigned_units IS NULL)
342: AND (X_Assigned_Units IS NULL)))
343: AND ( (Recinfo.schedule_flag = X_Schedule_Flag)

Line 403: X_Standard_Operation_Id NUMBER,

399: end if;
400: END Lock_Row;
401:
402: PROCEDURE Update_Row(X_Rowid VARCHAR2,
403: X_Standard_Operation_Id NUMBER,
404: X_Resource_Id NUMBER,
405: X_Activity_Id NUMBER DEFAULT NULL,
406: X_Last_Update_Date DATE,
407: X_Last_Updated_By NUMBER,

Line 414: X_Standard_Rate_Flag NUMBER,

410: X_Usage_Rate_Or_Amount NUMBER,
411: X_Usage_Rate_Or_Amount_Inverse NUMBER,
412: X_Basis_Type NUMBER,
413: X_Autocharge_Type NUMBER,
414: X_Standard_Rate_Flag NUMBER,
415: X_Assigned_Units NUMBER DEFAULT NULL,
416: X_Schedule_Flag NUMBER,
417: X_Attribute_Category VARCHAR2 DEFAULT NULL,
418: X_Attribute1 VARCHAR2 DEFAULT NULL,

Line 436: X_Standard_Operation_Id => X_Standard_Operation_Id,

432: X_Attribute15 VARCHAR2 DEFAULT NULL
433: ) IS
434: BEGIN
435: Update_Row(X_Rowid => X_Rowid,
436: X_Standard_Operation_Id => X_Standard_Operation_Id,
437: X_Resource_Id => X_Resource_Id,
438: X_Substitute_Group_Num => NULL,
439: X_Activity_Id => X_Activity_Id,
440: X_Last_Update_Date => X_Last_Update_Date,

Line 448: X_Standard_Rate_Flag => X_Standard_Rate_Flag,

444: X_Usage_Rate_Or_Amount => X_Usage_Rate_Or_Amount,
445: X_Usage_Rate_Or_Amount_Inverse => X_Usage_Rate_Or_Amount_Inverse,
446: X_Basis_Type => X_Basis_Type,
447: X_Autocharge_Type => X_Autocharge_Type,
448: X_Standard_Rate_Flag => X_Standard_Rate_Flag,
449: X_Assigned_Units => X_Assigned_Units,
450: X_Schedule_Flag => X_Schedule_Flag,
451: X_Attribute_Category => X_Attribute_Category,
452: X_Attribute1 => X_Attribute1,

Line 471: X_Standard_Operation_Id NUMBER,

467:
468: END Update_Row;
469:
470: PROCEDURE Update_Row(X_Rowid VARCHAR2,
471: X_Standard_Operation_Id NUMBER,
472: X_Resource_Id NUMBER,
473: X_Substitute_Group_Num NUMBER,
474: X_Activity_Id NUMBER DEFAULT NULL,
475: X_Last_Update_Date DATE,

Line 483: X_Standard_Rate_Flag NUMBER,

479: X_Usage_Rate_Or_Amount NUMBER,
480: X_Usage_Rate_Or_Amount_Inverse NUMBER,
481: X_Basis_Type NUMBER,
482: X_Autocharge_Type NUMBER,
483: X_Standard_Rate_Flag NUMBER,
484: X_Assigned_Units NUMBER DEFAULT NULL,
485: X_Schedule_Flag NUMBER,
486: X_Attribute_Category VARCHAR2 DEFAULT NULL,
487: X_Attribute1 VARCHAR2 DEFAULT NULL,

Line 506: standard_operation_id = X_Standard_Operation_Id,

502: ) IS
503: BEGIN
504: UPDATE BOM_STD_OP_RESOURCES
505: SET
506: standard_operation_id = X_Standard_Operation_Id,
507: resource_id = X_Resource_Id,
508: substitute_group_num = X_Substitute_Group_Num,
509: activity_id = X_Activity_Id,
510: last_update_date = X_Last_Update_Date,

Line 518: standard_rate_flag = X_Standard_Rate_Flag,

514: usage_rate_or_amount = X_Usage_Rate_Or_Amount,
515: usage_rate_or_amount_inverse = X_Usage_Rate_Or_Amount_Inverse,
516: basis_type = X_Basis_Type,
517: autocharge_type = X_Autocharge_Type,
518: standard_rate_flag = X_Standard_Rate_Flag,
519: assigned_units = X_Assigned_Units,
520: schedule_flag = X_Schedule_Flag,
521: attribute_category = X_Attribute_Category,
522: attribute1 = X_Attribute1,

Line 556: X_Standard_Operation_Id NUMBER,

552: end if;
553: END Delete_Row;
554:
555: PROCEDURE Check_Unique(X_Rowid VARCHAR2,
556: X_Standard_Operation_Id NUMBER,
557: X_Resource_Seq_Num NUMBER) IS
558: dummy NUMBER;
559: BEGIN
560: SELECT 1 INTO dummy FROM DUAL WHERE NOT EXISTS

Line 562: WHERE Standard_Operation_Id = X_Standard_Operation_Id

558: dummy NUMBER;
559: BEGIN
560: SELECT 1 INTO dummy FROM DUAL WHERE NOT EXISTS
561: (SELECT 1 FROM BOM_STD_OP_RESOURCES
562: WHERE Standard_Operation_Id = X_Standard_Operation_Id
563: AND Resource_Seq_Num = X_Resource_Seq_Num
564: AND ((X_Rowid IS NULL) OR (ROWID <> X_Rowid))
565: );
566: