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.PO_LINE_TYPES_PKG dependencies on PO_LINE_TYPES_B

Line 24: X_PURCHASE_BASIS IN PO_LINE_TYPES_B.purchase_basis%TYPE, --

20: X_OUTSIDE_OPERATION_FLAG in VARCHAR2,
21: X_REQUEST_ID in NUMBER,
22: X_RECEIVE_CLOSE_TOLERANCE in NUMBER,
23: X_ORDER_TYPE_LOOKUP_CODE in VARCHAR2,
24: X_PURCHASE_BASIS IN PO_LINE_TYPES_B.purchase_basis%TYPE, --
25: X_MATCHING_BASIS IN PO_LINE_TYPES_B.matching_basis%TYPE, --
26: X_CATEGORY_ID in NUMBER,
27: X_UNIT_OF_MEASURE in VARCHAR2,
28: X_UNIT_PRICE in NUMBER,

Line 25: X_MATCHING_BASIS IN PO_LINE_TYPES_B.matching_basis%TYPE, --

21: X_REQUEST_ID in NUMBER,
22: X_RECEIVE_CLOSE_TOLERANCE in NUMBER,
23: X_ORDER_TYPE_LOOKUP_CODE in VARCHAR2,
24: X_PURCHASE_BASIS IN PO_LINE_TYPES_B.purchase_basis%TYPE, --
25: X_MATCHING_BASIS IN PO_LINE_TYPES_B.matching_basis%TYPE, --
26: X_CATEGORY_ID in NUMBER,
27: X_UNIT_OF_MEASURE in VARCHAR2,
28: X_UNIT_PRICE in NUMBER,
29: X_RECEIVING_FLAG in VARCHAR2,

Line 42: cursor C is select ROWID from PO_LINE_TYPES_B

38: X_LAST_UPDATE_DATE in DATE,
39: X_LAST_UPDATED_BY in NUMBER,
40: X_LAST_UPDATE_LOGIN in NUMBER
41: ) is
42: cursor C is select ROWID from PO_LINE_TYPES_B
43: where LINE_TYPE_ID = X_LINE_TYPE_ID ;
44:
45: CURSOR C2 IS SELECT po_line_types_s.nextval FROM sys.dual;
46:

Line 57: insert into PO_LINE_TYPES_B (

53: CLOSE C2;
54: end if;
55: end;
56: begin
57: insert into PO_LINE_TYPES_B (
58: ATTRIBUTE3,
59: ATTRIBUTE4,
60: ATTRIBUTE5,
61: ATTRIBUTE6,

Line 203: X_PURCHASE_BASIS IN PO_LINE_TYPES_B.purchase_basis%TYPE, --

199: X_OUTSIDE_OPERATION_FLAG in VARCHAR2,
200: X_REQUEST_ID in NUMBER,
201: X_RECEIVE_CLOSE_TOLERANCE in NUMBER,
202: X_ORDER_TYPE_LOOKUP_CODE in VARCHAR2,
203: X_PURCHASE_BASIS IN PO_LINE_TYPES_B.purchase_basis%TYPE, --
204: X_MATCHING_BASIS IN PO_LINE_TYPES_B.matching_basis%TYPE, --
205: X_CATEGORY_ID in NUMBER,
206: X_UNIT_OF_MEASURE in VARCHAR2,
207: X_UNIT_PRICE in NUMBER,

Line 204: X_MATCHING_BASIS IN PO_LINE_TYPES_B.matching_basis%TYPE, --

200: X_REQUEST_ID in NUMBER,
201: X_RECEIVE_CLOSE_TOLERANCE in NUMBER,
202: X_ORDER_TYPE_LOOKUP_CODE in VARCHAR2,
203: X_PURCHASE_BASIS IN PO_LINE_TYPES_B.purchase_basis%TYPE, --
204: X_MATCHING_BASIS IN PO_LINE_TYPES_B.matching_basis%TYPE, --
205: X_CATEGORY_ID in NUMBER,
206: X_UNIT_OF_MEASURE in VARCHAR2,
207: X_UNIT_PRICE in NUMBER,
208: X_RECEIVING_FLAG in VARCHAR2,

Line 244: from PO_LINE_TYPES_B

240: INACTIVE_DATE,
241: ATTRIBUTE_CATEGORY,
242: ATTRIBUTE1,
243: ATTRIBUTE2
244: from PO_LINE_TYPES_B
245: where LINE_TYPE_ID = X_LINE_TYPE_ID
246: for update of LINE_TYPE_ID nowait;
247: recinfo c%rowtype;
248:

Line 359: X_PURCHASE_BASIS IN PO_LINE_TYPES_B.purchase_basis%TYPE, --

355: X_OUTSIDE_OPERATION_FLAG in VARCHAR2,
356: X_REQUEST_ID in NUMBER,
357: X_RECEIVE_CLOSE_TOLERANCE in NUMBER,
358: X_ORDER_TYPE_LOOKUP_CODE in VARCHAR2,
359: X_PURCHASE_BASIS IN PO_LINE_TYPES_B.purchase_basis%TYPE, --
360: X_MATCHING_BASIS IN PO_LINE_TYPES_B.matching_basis%TYPE, --
361: X_CATEGORY_ID in NUMBER,
362: X_UNIT_OF_MEASURE in VARCHAR2,
363: X_UNIT_PRICE in NUMBER,

Line 360: X_MATCHING_BASIS IN PO_LINE_TYPES_B.matching_basis%TYPE, --

356: X_REQUEST_ID in NUMBER,
357: X_RECEIVE_CLOSE_TOLERANCE in NUMBER,
358: X_ORDER_TYPE_LOOKUP_CODE in VARCHAR2,
359: X_PURCHASE_BASIS IN PO_LINE_TYPES_B.purchase_basis%TYPE, --
360: X_MATCHING_BASIS IN PO_LINE_TYPES_B.matching_basis%TYPE, --
361: X_CATEGORY_ID in NUMBER,
362: X_UNIT_OF_MEASURE in VARCHAR2,
363: X_UNIT_PRICE in NUMBER,
364: X_RECEIVING_FLAG in VARCHAR2,

Line 376: update PO_LINE_TYPES_B set

372: X_LAST_UPDATED_BY in NUMBER,
373: X_LAST_UPDATE_LOGIN in NUMBER
374: ) is
375: begin
376: update PO_LINE_TYPES_B set
377: ATTRIBUTE3 = X_ATTRIBUTE3,
378: ATTRIBUTE4 = X_ATTRIBUTE4,
379: ATTRIBUTE5 = X_ATTRIBUTE5,
380: ATTRIBUTE6 = X_ATTRIBUTE6,

Line 439: delete from PO_LINE_TYPES_B

435: if (sql%notfound) then
436: raise no_data_found;
437: end if;
438:
439: delete from PO_LINE_TYPES_B
440: where LINE_TYPE_ID = X_LINE_TYPE_ID;
441:
442: if (sql%notfound) then
443: raise no_data_found;

Line 453: from PO_LINE_TYPES_B B

449: begin
450: delete from PO_LINE_TYPES_TL T
451: where not exists
452: (select NULL
453: from PO_LINE_TYPES_B B
454: where B.LINE_TYPE_ID = T.LINE_TYPE_ID
455: );
456:
457: update PO_LINE_TYPES_TL T set (

Line 579: X_PURCHASE_BASIS IN PO_LINE_TYPES_B.purchase_basis%TYPE, --

575: X_OUTSIDE_OPERATION_FLAG in VARCHAR2,
576: X_REQUEST_ID in NUMBER,
577: X_RECEIVE_CLOSE_TOLERANCE in NUMBER,
578: X_ORDER_TYPE_LOOKUP_CODE in VARCHAR2,
579: X_PURCHASE_BASIS IN PO_LINE_TYPES_B.purchase_basis%TYPE, --
580: X_MATCHING_BASIS IN PO_LINE_TYPES_B.matching_basis%TYPE, --
581: X_CATEGORY_CODE in VARCHAR2,
582: X_UNIT_OF_MEASURE in VARCHAR2,
583: X_UNIT_PRICE in NUMBER,

Line 580: X_MATCHING_BASIS IN PO_LINE_TYPES_B.matching_basis%TYPE, --

576: X_REQUEST_ID in NUMBER,
577: X_RECEIVE_CLOSE_TOLERANCE in NUMBER,
578: X_ORDER_TYPE_LOOKUP_CODE in VARCHAR2,
579: X_PURCHASE_BASIS IN PO_LINE_TYPES_B.purchase_basis%TYPE, --
580: X_MATCHING_BASIS IN PO_LINE_TYPES_B.matching_basis%TYPE, --
581: X_CATEGORY_CODE in VARCHAR2,
582: X_UNIT_OF_MEASURE in VARCHAR2,
583: X_UNIT_PRICE in NUMBER,
584: X_RECEIVING_FLAG in VARCHAR2,