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 120.0.12020000.3 2012/09/04 11:35:22 rambkond 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 82: X_Standard_Operation_Id NUMBER,

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

Line 96: X_Standard_Rate_Flag NUMBER,

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

Line 119: WHERE standard_operation_id = X_Standard_Operation_Id

115: X_SCHEDULE_SEQ_NUM NUMBER DEFAULT NULL, -- Bug#14550670
116: X_PRINCIPLE_FLAG NUMBER DEFAULT NULL -- Bug#14550670
117: ) IS
118: CURSOR C IS SELECT rowid FROM BOM_STD_OP_RESOURCES
119: WHERE standard_operation_id = X_Standard_Operation_Id
120: AND resource_seq_num = X_Resource_Seq_Num;
121:
122: BEGIN
123: INSERT INTO BOM_STD_OP_RESOURCES(

Line 124: standard_operation_id,

120: AND resource_seq_num = X_Resource_Seq_Num;
121:
122: BEGIN
123: INSERT INTO BOM_STD_OP_RESOURCES(
124: standard_operation_id,
125: resource_id,
126: substitute_group_num,
127: activity_id,
128: last_update_date,

Line 138: standard_rate_flag,

134: usage_rate_or_amount,
135: usage_rate_or_amount_inverse,
136: basis_type,
137: autocharge_type,
138: standard_rate_flag,
139: assigned_units,
140: schedule_flag,
141: attribute_category,
142: attribute1,

Line 160: X_Standard_Operation_Id,

156: attribute15,
157: schedule_seq_num, -- Bug#14550670
158: principle_flag -- Bug#14550670
159: ) VALUES (
160: X_Standard_Operation_Id,
161: X_Resource_Id,
162: X_Substitute_Group_Num,
163: X_Activity_Id,
164: X_Last_Update_Date,

Line 174: X_Standard_Rate_Flag,

170: X_Usage_Rate_Or_Amount,
171: X_Usage_Rate_Or_Amount_Inverse,
172: X_Basis_Type,
173: X_Autocharge_Type,
174: X_Standard_Rate_Flag,
175: X_Assigned_Units,
176: X_Schedule_Flag,
177: X_Attribute_Category,
178: X_Attribute1,

Line 208: X_Standard_Operation_Id NUMBER,

204: CLOSE C;
205: END Insert_Row;
206:
207: PROCEDURE Lock_Row(X_Rowid VARCHAR2,
208: X_Standard_Operation_Id NUMBER,
209: X_Resource_Id NUMBER,
210: X_Activity_Id NUMBER DEFAULT NULL,
211: X_Resource_Seq_Num NUMBER,
212: X_Usage_Rate_Or_Amount NUMBER,

Line 216: X_Standard_Rate_Flag NUMBER,

212: X_Usage_Rate_Or_Amount NUMBER,
213: X_Usage_Rate_Or_Amount_Inverse NUMBER,
214: X_Basis_Type NUMBER,
215: X_Autocharge_Type NUMBER,
216: X_Standard_Rate_Flag NUMBER,
217: X_Assigned_Units NUMBER DEFAULT NULL,
218: X_Schedule_Flag NUMBER,
219: X_Attribute_Category VARCHAR2 DEFAULT NULL,
220: X_Attribute1 VARCHAR2 DEFAULT NULL,

Line 240: X_Standard_Operation_Id => X_Standard_Operation_Id,

236:
237: BEGIN
238:
239: Lock_Row(X_Rowid => X_Rowid,
240: X_Standard_Operation_Id => X_Standard_Operation_Id,
241: X_Resource_Id => X_Resource_Id,
242: X_Substitute_Group_Num => NULL,
243: X_Activity_Id => X_Activity_Id,
244: X_Resource_Seq_Num => X_Resource_Seq_Num,

Line 249: X_Standard_Rate_Flag => X_Standard_Rate_Flag,

245: X_Usage_Rate_Or_Amount => X_Usage_Rate_Or_Amount,
246: X_Usage_Rate_Or_Amount_Inverse => X_Usage_Rate_Or_Amount_Inverse,
247: X_Basis_Type => X_Basis_Type,
248: X_Autocharge_Type => X_Autocharge_Type,
249: X_Standard_Rate_Flag => X_Standard_Rate_Flag,
250: X_Assigned_Units => X_Assigned_Units,
251: X_Schedule_Flag => X_Schedule_Flag,
252: X_Attribute_Category => X_Attribute_Category,
253: X_Attribute1 => X_Attribute1,

Line 275: X_Standard_Operation_Id NUMBER,

271:
272: END Lock_Row;
273:
274: PROCEDURE Lock_Row(X_Rowid VARCHAR2,
275: X_Standard_Operation_Id NUMBER,
276: X_Resource_Id NUMBER,
277: X_Substitute_Group_Num NUMBER,
278: X_Activity_Id NUMBER DEFAULT NULL,
279: X_Resource_Seq_Num NUMBER,

Line 284: X_Standard_Rate_Flag NUMBER,

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

Line 310: FOR UPDATE of Standard_Operation_Id, Substitute_Group_Num NOWAIT;

306: CURSOR C IS
307: SELECT *
308: FROM BOM_STD_OP_RESOURCES
309: WHERE rowid = X_Rowid
310: FOR UPDATE of Standard_Operation_Id, Substitute_Group_Num NOWAIT;
311: Recinfo C%ROWTYPE;
312: BEGIN
313: OPEN C;
314: FETCH C INTO Recinfo;

Line 322: ( (Recinfo.standard_operation_id = X_Standard_Operation_Id)

318: APP_EXCEPTION.RAISE_EXCEPTION;
319: end if;
320: CLOSE C;
321: if (
322: ( (Recinfo.standard_operation_id = X_Standard_Operation_Id)
323: OR ( (Recinfo.standard_operation_id IS NULL)
324: AND (X_Standard_Operation_Id IS NULL)))
325: AND ( (Recinfo.resource_id = X_Resource_Id)
326: OR ( (Recinfo.resource_id IS NULL)

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

319: end if;
320: CLOSE C;
321: if (
322: ( (Recinfo.standard_operation_id = X_Standard_Operation_Id)
323: OR ( (Recinfo.standard_operation_id IS NULL)
324: AND (X_Standard_Operation_Id IS NULL)))
325: AND ( (Recinfo.resource_id = X_Resource_Id)
326: OR ( (Recinfo.resource_id IS NULL)
327: AND (X_Resource_Id IS NULL)))

Line 324: AND (X_Standard_Operation_Id IS NULL)))

320: CLOSE C;
321: if (
322: ( (Recinfo.standard_operation_id = X_Standard_Operation_Id)
323: OR ( (Recinfo.standard_operation_id IS NULL)
324: AND (X_Standard_Operation_Id IS NULL)))
325: AND ( (Recinfo.resource_id = X_Resource_Id)
326: OR ( (Recinfo.resource_id IS NULL)
327: AND (X_Resource_Id IS NULL)))
328: AND ( (Recinfo.substitute_group_num = X_Substitute_Group_Num)

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

345: AND (X_Basis_Type IS NULL)))
346: AND ( (Recinfo.autocharge_type = X_Autocharge_Type)
347: OR ( (Recinfo.autocharge_type IS NULL)
348: AND (X_Autocharge_Type IS NULL)))
349: AND ( (Recinfo.standard_rate_flag = X_Standard_Rate_Flag)
350: OR ( (Recinfo.standard_rate_flag IS NULL)
351: AND (X_Standard_Rate_Flag IS NULL)))
352: AND ( (Recinfo.assigned_units = X_Assigned_Units)
353: OR ( (Recinfo.assigned_units IS NULL)

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

346: AND ( (Recinfo.autocharge_type = X_Autocharge_Type)
347: OR ( (Recinfo.autocharge_type IS NULL)
348: AND (X_Autocharge_Type IS NULL)))
349: AND ( (Recinfo.standard_rate_flag = X_Standard_Rate_Flag)
350: OR ( (Recinfo.standard_rate_flag IS NULL)
351: AND (X_Standard_Rate_Flag IS NULL)))
352: AND ( (Recinfo.assigned_units = X_Assigned_Units)
353: OR ( (Recinfo.assigned_units IS NULL)
354: AND (X_Assigned_Units IS NULL)))

Line 351: AND (X_Standard_Rate_Flag IS NULL)))

347: OR ( (Recinfo.autocharge_type IS NULL)
348: AND (X_Autocharge_Type IS NULL)))
349: AND ( (Recinfo.standard_rate_flag = X_Standard_Rate_Flag)
350: OR ( (Recinfo.standard_rate_flag IS NULL)
351: AND (X_Standard_Rate_Flag IS NULL)))
352: AND ( (Recinfo.assigned_units = X_Assigned_Units)
353: OR ( (Recinfo.assigned_units IS NULL)
354: AND (X_Assigned_Units IS NULL)))
355: AND ( (Recinfo.schedule_flag = X_Schedule_Flag)

Line 423: X_Standard_Operation_Id NUMBER,

419: end if;
420: END Lock_Row;
421:
422: PROCEDURE Update_Row(X_Rowid VARCHAR2,
423: X_Standard_Operation_Id NUMBER,
424: X_Resource_Id NUMBER,
425: X_Activity_Id NUMBER DEFAULT NULL,
426: X_Last_Update_Date DATE,
427: X_Last_Updated_By NUMBER,

Line 434: X_Standard_Rate_Flag NUMBER,

430: X_Usage_Rate_Or_Amount NUMBER,
431: X_Usage_Rate_Or_Amount_Inverse NUMBER,
432: X_Basis_Type NUMBER,
433: X_Autocharge_Type NUMBER,
434: X_Standard_Rate_Flag NUMBER,
435: X_Assigned_Units NUMBER DEFAULT NULL,
436: X_Schedule_Flag NUMBER,
437: X_Attribute_Category VARCHAR2 DEFAULT NULL,
438: X_Attribute1 VARCHAR2 DEFAULT NULL,

Line 456: X_Standard_Operation_Id => X_Standard_Operation_Id,

452: X_Attribute15 VARCHAR2 DEFAULT NULL
453: ) IS
454: BEGIN
455: Update_Row(X_Rowid => X_Rowid,
456: X_Standard_Operation_Id => X_Standard_Operation_Id,
457: X_Resource_Id => X_Resource_Id,
458: X_Substitute_Group_Num => NULL,
459: X_Activity_Id => X_Activity_Id,
460: X_Last_Update_Date => X_Last_Update_Date,

Line 468: X_Standard_Rate_Flag => X_Standard_Rate_Flag,

464: X_Usage_Rate_Or_Amount => X_Usage_Rate_Or_Amount,
465: X_Usage_Rate_Or_Amount_Inverse => X_Usage_Rate_Or_Amount_Inverse,
466: X_Basis_Type => X_Basis_Type,
467: X_Autocharge_Type => X_Autocharge_Type,
468: X_Standard_Rate_Flag => X_Standard_Rate_Flag,
469: X_Assigned_Units => X_Assigned_Units,
470: X_Schedule_Flag => X_Schedule_Flag,
471: X_Attribute_Category => X_Attribute_Category,
472: X_Attribute1 => X_Attribute1,

Line 494: X_Standard_Operation_Id NUMBER,

490:
491: END Update_Row;
492:
493: PROCEDURE Update_Row(X_Rowid VARCHAR2,
494: X_Standard_Operation_Id NUMBER,
495: X_Resource_Id NUMBER,
496: X_Substitute_Group_Num NUMBER,
497: X_Activity_Id NUMBER DEFAULT NULL,
498: X_Last_Update_Date DATE,

Line 506: X_Standard_Rate_Flag NUMBER,

502: X_Usage_Rate_Or_Amount NUMBER,
503: X_Usage_Rate_Or_Amount_Inverse NUMBER,
504: X_Basis_Type NUMBER,
505: X_Autocharge_Type NUMBER,
506: X_Standard_Rate_Flag NUMBER,
507: X_Assigned_Units NUMBER DEFAULT NULL,
508: X_Schedule_Flag NUMBER,
509: X_Attribute_Category VARCHAR2 DEFAULT NULL,
510: X_Attribute1 VARCHAR2 DEFAULT NULL,

Line 531: standard_operation_id = X_Standard_Operation_Id,

527: ) IS
528: BEGIN
529: UPDATE BOM_STD_OP_RESOURCES
530: SET
531: standard_operation_id = X_Standard_Operation_Id,
532: resource_id = X_Resource_Id,
533: substitute_group_num = X_Substitute_Group_Num,
534: activity_id = X_Activity_Id,
535: last_update_date = X_Last_Update_Date,

Line 543: standard_rate_flag = X_Standard_Rate_Flag,

539: usage_rate_or_amount = X_Usage_Rate_Or_Amount,
540: usage_rate_or_amount_inverse = X_Usage_Rate_Or_Amount_Inverse,
541: basis_type = X_Basis_Type,
542: autocharge_type = X_Autocharge_Type,
543: standard_rate_flag = X_Standard_Rate_Flag,
544: assigned_units = X_Assigned_Units,
545: schedule_flag = X_Schedule_Flag,
546: attribute_category = X_Attribute_Category,
547: attribute1 = X_Attribute1,

Line 583: X_Standard_Operation_Id NUMBER,

579: end if;
580: END Delete_Row;
581:
582: PROCEDURE Check_Unique(X_Rowid VARCHAR2,
583: X_Standard_Operation_Id NUMBER,
584: X_Resource_Seq_Num NUMBER) IS
585: dummy NUMBER;
586: BEGIN
587: SELECT 1 INTO dummy FROM DUAL WHERE NOT EXISTS

Line 589: WHERE Standard_Operation_Id = X_Standard_Operation_Id

585: dummy NUMBER;
586: BEGIN
587: SELECT 1 INTO dummy FROM DUAL WHERE NOT EXISTS
588: (SELECT 1 FROM BOM_STD_OP_RESOURCES
589: WHERE Standard_Operation_Id = X_Standard_Operation_Id
590: AND Resource_Seq_Num = X_Resource_Seq_Num
591: AND ((X_Rowid IS NULL) OR (ROWID <> X_Rowid))
592: );
593: