[Home] [Help]
PACKAGE: APPS.PO_COMPLEX_WORK_PVT
Source
1 PACKAGE PO_COMPLEX_WORK_PVT AS
2 -- $Header: PO_COMPLEX_WORK_PVT.pls 120.1 2005/09/18 22:48:09 spangulu noship $
3
4 -- Package global constants
5
6 -- payment types
7 g_payment_type_MILESTONE CONSTANT VARCHAR2(10) := 'MILESTONE';
8 g_payment_type_RATE CONSTANT VARCHAR2(10) := 'RATE';
9 g_payment_type_LUMPSUM CONSTANT VARCHAR2(10) := 'LUMPSUM';
10 g_payment_type_ADVANCE CONSTANT VARCHAR2(10) := 'ADVANCE';
11 g_payment_type_DELIVERY CONSTANT VARCHAR2(10) := 'DELIVERY';
12
13 -- shipment types
14 g_shipment_type_STANDARD CONSTANT VARCHAR2(10) := 'STANDARD';
15 g_shipment_type_PREPAYMENT CONSTANT VARCHAR2(10) := 'PREPAYMENT';
16
17 -- Methods
18
19 PROCEDURE get_payment_style_settings(
20 p_style_id IN NUMBER
21 , x_complex_work_flag OUT NOCOPY VARCHAR2
22 , x_financing_payments_flag OUT NOCOPY VARCHAR2
23 , x_retainage_allowed_flag OUT NOCOPY VARCHAR2
24 , x_advance_allowed_flag OUT NOCOPY VARCHAR2
25 , x_milestone_allowed_flag OUT NOCOPY VARCHAR2
26 , x_lumpsum_allowed_flag OUT NOCOPY VARCHAR2
27 , x_rate_allowed_flag OUT NOCOPY VARCHAR2
28 );
29
30
31 FUNCTION is_complex_work_style(p_style_id IN NUMBER) RETURN BOOLEAN;
32 FUNCTION is_financing_payment_style(p_style_id IN NUMBER) RETURN BOOLEAN;
33
34 FUNCTION is_complex_work_po(p_po_header_id IN NUMBER) RETURN BOOLEAN;
35 FUNCTION is_financing_po(p_po_header_id IN NUMBER) RETURN BOOLEAN;
36
37
38 PROCEDURE get_default_payitem_info(
39 p_po_header_id IN NUMBER
40 , p_po_line_id IN NUMBER
41 , p_line_value_basis IN VARCHAR2
42 , p_line_matching_basis IN VARCHAR2
43 , p_line_qty IN NUMBER
44 , p_line_amt IN NUMBER
45 , p_line_price IN NUMBER
46 , x_payment_type OUT NOCOPY VARCHAR2
47 , x_payitem_qty OUT NOCOPY NUMBER
48 , x_payitem_amt OUT NOCOPY NUMBER
49 , x_payitem_price OUT NOCOPY NUMBER
50 );
51
52
53 FUNCTION get_advance_amount(
54 p_po_line_id IN NUMBER
55 , p_doc_revision_num IN NUMBER DEFAULT NULL
56 , p_which_tables IN VARCHAR2 DEFAULT 'MAIN'
57 ) RETURN NUMBER;
58
59 END PO_COMPLEX_WORK_PVT;