1 PACKAGE PO_LINES_SV5 as
2 /* $Header: POXPOL5S.pls 120.0.12000000.2 2007/10/05 23:21:53 jburugul ship $ */
3
4 /*===========================================================================
5 PROCEDURE NAME: po_lines_post_query()
6
7 DESCRIPTION: This procedure is a wrapper that does post_query
8 processing for rows in PO_LINES block.
9
10 PARAMETERS:
11
12 DESIGN REFERENCES:
13
14 ALGORITHM:
15
16 NOTES:
17
18 OPEN ISSUES:
19
20 CLOSED ISSUES:
21
22 CHANGE HISTORY: Created 08/08/95 SIYER
23 ===========================================================================*/
24 procedure po_lines_post_query ( X_po_Line_id IN number,
25 X_from_header_id IN number,
26 X_from_line_id IN number,
27 X_line_type_id IN number,
28 X_item_id IN number,
29 X_inventory_org_id IN number,
30 X_expense_accrual_code IN varchar2,
31 X_po_header_id IN number,
32 X_type_lookup_code IN varchar2,
33 X_receipt_required_flag IN OUT NOCOPY varchar2,
34 X_quantity_received IN OUT NOCOPY number,
35 X_quantity_billed IN OUT NOCOPY number,
36 X_encumbered_flag IN OUT NOCOPY varchar2,
37 X_prevent_price_update_flag IN OUT NOCOPY varchar2,
38 X_online_req_flag IN OUT NOCOPY varchar2,
39 X_quantity_released IN OUT NOCOPY number,
40 X_amount_released IN OUT NOCOPY number,
41 X_quotation_number IN OUT NOCOPY varchar2,
42 X_quotation_line IN OUT NOCOPY number,
43 X_quotation_type IN OUT NOCOPY varchar2,
44 X_vendor_quotation_number IN OUT NOCOPY varchar2,
45 X_num_of_ship IN OUT NOCOPY number,
46 --< NBD TZ/Timestamp FPJ Start >
47 --X_promised_date IN OUT NOCOPY varchar2,
48 --X_need_by IN OUT NOCOPY varchar2,
49 X_promised_date IN OUT NOCOPY DATE,
50 X_need_by IN OUT NOCOPY DATE,
51 --< NBD TZ/Timestamp FPJ End >
52 X_num_of_dist IN OUT NOCOPY number,
53 X_code_combination_id IN OUT NOCOPY number,
54 X_line_total IN OUT NOCOPY number,
55 X_ship_total IN OUT NOCOPY number,
56 X_ship_total_rtot_db IN OUT NOCOPY number,
57 --togeorge 10/03/2000
58 --added oke variables
59 X_oke_contract_header_id IN number,
60 X_oke_contract_num IN OUT NOCOPY varchar2
61 ) ;
62
63 /*===========================================================================
64 * PROCEDURE NAME: price_update_allowed
65 * DESCRIPTION: This function checks whether price update
66 * on a PO line is allowed or not and returns true
67 * or false.
68 * PARAMETERS: p_po_line_id : line id of the PO LINE.
69 *
70 * DESIGN REFERENCES:
71 * ALGORITHM: 1. get the total quantity_received, quantity_billed
72 * for a particular po line.
73 *
74 * 2. if the destination at distribution is Inventory
75 * or Shopfloor and quantity_billed or
76 * received is > 0 disallow price update,
77 * 3. else for expense destination if any shipment
78 * has accrual option - at receipt, then
79 * if quantity billed or received is > 0 disallow the
80 * price update.
81 *
82 * NOTES:
83 * OPEN ISSUES:
84 * CLOSED ISSUES:
85 * CHANGE HISTORY: Created 22/02/05 Ambansal
86 * ===========================================================================*/
87
88 FUNCTION price_update_allowed(p_po_line_id IN NUMBER) RETURN BOOLEAN;
89
90 END PO_LINES_SV5;