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_SV dependencies on PO_LINE_TYPES

Line 1: PACKAGE BODY PO_LINE_TYPES_SV as

1: PACKAGE BODY PO_LINE_TYPES_SV as
2: /* $Header: POXSTLTB.pls 120.1.12010000.2 2008/09/24 10:55:24 cvardia ship $ */
3: /*========================== PO_LINE_TYPES_SV ===========================*/
4:
5: /*===========================================================================

Line 3: /========================== PO_LINE_TYPES_SV ===========================/

1: PACKAGE BODY PO_LINE_TYPES_SV as
2: /* $Header: POXSTLTB.pls 120.1.12010000.2 2008/09/24 10:55:24 cvardia ship $ */
3: /*========================== PO_LINE_TYPES_SV ===========================*/
4:
5: /*===========================================================================
6:
7: FUNCTION NAME: val_line_type()

Line 23: FROM po_line_types

19: /* Check if the given Line Type is active */
20:
21: SELECT line_type_id
22: INTO X_line_type_id_v
23: FROM po_line_types
24: WHERE sysdate < nvl(inactive_date, sysdate + 1)
25: AND line_type_id = X_line_type_id;
26:
27: return (TRUE);

Line 60: po_line_types_sv.get_line_type_def(X_Line_Type_Id,

56: BEGIN
57:
58: -- dbms_output.put_line('before call');
59: -- Bug: 1189629 Added receive close tolerance to the list of parameters
60: po_line_types_sv.get_line_type_def(X_Line_Type_Id,
61: X_Order_Type_Lookup_Code,
62: X_Category_Id,
63: X_Unit_Meas_Lookup_Code,
64: X_Unit_Price,

Line 141: FROM po_line_types_b lt --

137: lt.unit_price,
138: nvl(lt.outside_operation_flag,'N'),
139: lt.receiving_flag,
140: lt.receive_close_tolerance
141: FROM po_line_types_b lt --
142: WHERE lt.line_type_id = p_line_type_id; --
143:
144: BEGIN
145:

Line 232: l_matching_basis PO_LINE_TYPES_B.matching_basis%TYPE;

228: , x_receiving_flag OUT NOCOPY VARCHAR2
229: , x_receive_close_tolerance OUT NOCOPY NUMBER
230: )
231: IS
232: l_matching_basis PO_LINE_TYPES_B.matching_basis%TYPE;
233:
234: BEGIN
235:
236: PO_LINE_TYPES_SV.get_line_type_def

Line 236: PO_LINE_TYPES_SV.get_line_type_def

232: l_matching_basis PO_LINE_TYPES_B.matching_basis%TYPE;
233:
234: BEGIN
235:
236: PO_LINE_TYPES_SV.get_line_type_def
237: ( p_line_type_id => p_line_type_id
238: , x_order_type_lookup_code => x_order_type_lookup_code
239: , x_purchase_basis => x_purchase_basis
240: , x_matching_basis => l_matching_basis

Line 288: l_category_id PO_LINE_TYPES_B.category_id%TYPE;

284: , x_matching_basis OUT NOCOPY VARCHAR2
285: , x_outside_operation_flag OUT NOCOPY VARCHAR2
286: )
287: IS
288: l_category_id PO_LINE_TYPES_B.category_id%TYPE;
289: l_unit_meas_lookup_code PO_LINE_TYPES_B.unit_of_measure%TYPE;
290: l_unit_price PO_LINE_TYPES_B.unit_price%TYPE;
291: l_receiving_flag PO_LINE_TYPES_B.receiving_flag%TYPE;
292: l_receive_close_tolerance PO_LINE_TYPES_B.receive_close_tolerance%TYPE;

Line 289: l_unit_meas_lookup_code PO_LINE_TYPES_B.unit_of_measure%TYPE;

285: , x_outside_operation_flag OUT NOCOPY VARCHAR2
286: )
287: IS
288: l_category_id PO_LINE_TYPES_B.category_id%TYPE;
289: l_unit_meas_lookup_code PO_LINE_TYPES_B.unit_of_measure%TYPE;
290: l_unit_price PO_LINE_TYPES_B.unit_price%TYPE;
291: l_receiving_flag PO_LINE_TYPES_B.receiving_flag%TYPE;
292: l_receive_close_tolerance PO_LINE_TYPES_B.receive_close_tolerance%TYPE;
293:

Line 290: l_unit_price PO_LINE_TYPES_B.unit_price%TYPE;

286: )
287: IS
288: l_category_id PO_LINE_TYPES_B.category_id%TYPE;
289: l_unit_meas_lookup_code PO_LINE_TYPES_B.unit_of_measure%TYPE;
290: l_unit_price PO_LINE_TYPES_B.unit_price%TYPE;
291: l_receiving_flag PO_LINE_TYPES_B.receiving_flag%TYPE;
292: l_receive_close_tolerance PO_LINE_TYPES_B.receive_close_tolerance%TYPE;
293:
294: BEGIN

Line 291: l_receiving_flag PO_LINE_TYPES_B.receiving_flag%TYPE;

287: IS
288: l_category_id PO_LINE_TYPES_B.category_id%TYPE;
289: l_unit_meas_lookup_code PO_LINE_TYPES_B.unit_of_measure%TYPE;
290: l_unit_price PO_LINE_TYPES_B.unit_price%TYPE;
291: l_receiving_flag PO_LINE_TYPES_B.receiving_flag%TYPE;
292: l_receive_close_tolerance PO_LINE_TYPES_B.receive_close_tolerance%TYPE;
293:
294: BEGIN
295:

Line 292: l_receive_close_tolerance PO_LINE_TYPES_B.receive_close_tolerance%TYPE;

288: l_category_id PO_LINE_TYPES_B.category_id%TYPE;
289: l_unit_meas_lookup_code PO_LINE_TYPES_B.unit_of_measure%TYPE;
290: l_unit_price PO_LINE_TYPES_B.unit_price%TYPE;
291: l_receiving_flag PO_LINE_TYPES_B.receiving_flag%TYPE;
292: l_receive_close_tolerance PO_LINE_TYPES_B.receive_close_tolerance%TYPE;
293:
294: BEGIN
295:
296: PO_LINE_TYPES_SV.get_line_type_def

Line 296: PO_LINE_TYPES_SV.get_line_type_def

292: l_receive_close_tolerance PO_LINE_TYPES_B.receive_close_tolerance%TYPE;
293:
294: BEGIN
295:
296: PO_LINE_TYPES_SV.get_line_type_def
297: ( p_line_type_id => p_line_type_id
298: , x_order_type_lookup_code => x_order_type_lookup_code
299: , x_purchase_basis => x_purchase_basis
300: , x_matching_basis => x_matching_basis

Line 328: l_purchase_basis PO_LINE_TYPES_B.purchase_basis%TYPE; --

324: X_Outside_Operations_Flag IN OUT NOCOPY VARCHAR2,
325: X_Receiving_Flag IN OUT NOCOPY VARCHAR2,
326: X_Receive_close_tolerance IN OUT NOCOPY NUMBER)
327: IS
328: l_purchase_basis PO_LINE_TYPES_B.purchase_basis%TYPE; --
329:
330: BEGIN
331:
332: -- Call to overloaded 'get_line_type_def' procedure.

Line 334: PO_LINE_TYPES_SV.get_line_type_def

330: BEGIN
331:
332: -- Call to overloaded 'get_line_type_def' procedure.
333: --
334: PO_LINE_TYPES_SV.get_line_type_def
335: ( p_line_type_id => X_Line_Type_Id
336: , x_order_type_lookup_code => X_Order_Type_Lookup_Code
337: , x_purchase_basis => l_purchase_basis
338: , x_category_id => X_Category_Id

Line 366: FROM po_line_types polt

362: x_progress := 10;
363:
364: SELECT polt.line_type
365: INTO x_line_type
366: FROM po_line_types polt
367: WHERE polt.line_type_id = x_line_type_id
368: AND nvl(polt.inactive_date,sysdate + 1) > sysdate;
369:
370: return(x_line_type);

Line 493: FROM po_line_types

489: BEGIN
490:
491: SELECT outside_operation_flag
492: INTO x_outside_operation_flag
493: FROM po_line_types
494: WHERE line_type_id = p_line_type_id;
495:
496: IF ( x_outside_operation_flag = 'Y' )
497: THEN

Line 598: END po_line_types_sv;

594:
595: END transactions_exist;
596:
597:
598: END po_line_types_sv;