1 PACKAGE PO_COMPLEX_WORK_PVT AUTHID CURRENT_USER AS
2 -- $Header: PO_COMPLEX_WORK_PVT.pls 120.2 2010/06/24 13:05:32 vinnaray ship $
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_complex_work_po(p_po_header_id IN NUMBER,
36 p_draft_id IN NUMBER) RETURN BOOLEAN;
37 FUNCTION is_financing_po(p_po_header_id IN NUMBER) RETURN BOOLEAN;
38 FUNCTION is_financing_po(p_po_header_id IN NUMBER,
39 p_draft_id IN NUMBER) RETURN BOOLEAN;
40
41
42 PROCEDURE get_default_payitem_info(
43 p_po_header_id IN NUMBER
44 , p_po_line_id IN NUMBER
45 , p_line_value_basis IN VARCHAR2
46 , p_line_matching_basis IN VARCHAR2
47 , p_line_qty IN NUMBER
48 , p_line_amt IN NUMBER
49 , p_line_price IN NUMBER
50 , x_payment_type OUT NOCOPY VARCHAR2
51 , x_payitem_qty OUT NOCOPY NUMBER
52 , x_payitem_amt OUT NOCOPY NUMBER
53 , x_payitem_price OUT NOCOPY NUMBER
54 );
55
56 PROCEDURE get_default_payitem_info(
57 p_po_header_id IN NUMBER
58 , p_draft_id IN NUMBER
59 , p_po_line_id IN NUMBER
60 , p_line_value_basis IN VARCHAR2
61 , p_line_matching_basis IN VARCHAR2
62 , p_line_qty IN NUMBER
63 , p_line_amt IN NUMBER
64 , p_line_price IN NUMBER
65 , x_payment_type OUT NOCOPY VARCHAR2
66 , x_payitem_qty OUT NOCOPY NUMBER
67 , x_payitem_amt OUT NOCOPY NUMBER
68 , x_payitem_price OUT NOCOPY NUMBER
69 );
70
71
72 FUNCTION get_advance_amount(
73 p_po_line_id IN NUMBER
74 , p_doc_revision_num IN NUMBER DEFAULT NULL
75 , p_which_tables IN VARCHAR2 DEFAULT 'MAIN'
76 ) RETURN NUMBER;
77
78 END PO_COMPLEX_WORK_PVT;