PACKAGE: APPS.ICX_CAT_POPULATE_STATUS_PVT

Source

1 PACKAGE ICX_CAT_POPULATE_STATUS_PVT AS
2 /* $Header: ICXVPPSS.pls 120.6 2006/10/06 02:42:59 rwidjaja noship $*/
3 
4 TYPE g_BPA_line_status_rec_type IS RECORD
5 (
6   approved_date               DATE,
7   authorization_status        po_headers.authorization_status%TYPE,
8   frozen_flag                 po_headers.frozen_flag%TYPE,
9   hdr_cancel_flag             po_headers.cancel_flag%TYPE,
10   line_cancel_flag            po_lines.cancel_flag%TYPE,
11   hdr_closed_code             po_headers.closed_code%TYPE,
12   line_closed_code            po_lines.closed_code%TYPE,
13   end_date                    DATE,
14   expiration_date             DATE,
15   system_date                 DATE
16 );
17 
18 g_BPA_line_status_rec           g_BPA_line_status_rec_type;
19 
20 VALID_FOR_POPULATE              PLS_INTEGER := 0;
21 INVALID_FOR_POPULATE            PLS_INTEGER := -1;
22 
23 GLOBAL_BLANKET_DISABLED         PLS_INTEGER := 22;
24 
25 INACTIVE_TEMPLATE               PLS_INTEGER := 1;
26 TEMPLATE_INVALID_BLANKET_LINE   PLS_INTEGER := 4;
27 
28 INVALID_ITEM_CATG_ASIGNMNT      PLS_INTEGER := 11;
29 
30 NULL_NUMBER                     PLS_INTEGER := -2;
31 
32 FUNCTION getCategoryStatus
33 (       p_end_date_active               IN              DATE            ,
34         p_disable_date                  IN              DATE            ,
35         p_system_date                   IN              DATE
36 )
37   RETURN NUMBER ;
38 
39 FUNCTION getBPALineStatus
40 (       p_BPA_line_status_rec           IN              g_BPA_line_status_rec_type
41 )
42   RETURN NUMBER;
43 
44 FUNCTION getQuoteLineStatus
45 (       p_po_line_id                    IN              NUMBER
46 )
47   RETURN NUMBER ;
48 
49 FUNCTION getGlobalAgreementStatus
50 (       p_enabled_flag                  IN              VARCHAR2
51 )
52   RETURN NUMBER ;
53 
54 FUNCTION getTemplateLineStatus
55 (       p_inactive_date                 IN              DATE            ,
56         p_contract_line_id	        IN              NUMBER          ,
57         p_BPA_line_status_rec           IN              g_BPA_line_status_rec_type
58 )
59   RETURN NUMBER;
60 
61 PROCEDURE getMasterItemStatusAndType
62 (       p_internal_order_enabled_flag   IN              VARCHAR2        ,
63         p_outside_operation_flag        IN              VARCHAR2        ,
64         p_item_price                    IN              NUMBER          ,
65         p_item_status                   OUT NOCOPY      NUMBER          ,
66         p_item_type                     OUT NOCOPY      VARCHAR2
67 );
68 
69 END ICX_CAT_POPULATE_STATUS_PVT;