[Home] [Help]
PACKAGE: APPS.OKS_QPATTRIB_PVT
Source
1 PACKAGE OKS_QPATTRIB_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKSRSQPS.pls 120.0 2005/05/25 17:40:50 appldev noship $ */
3
4 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
5 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
6 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
7 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
8 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
9 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
10 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
11 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
12
13
14 ------------------------------------------------------------------------------------
15
16 -- GLOBAL EXCEPTION
17
18 ---------------------------------------------------------------------------
19
20 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
21 G_REQUIRED_ATTR_FAILED EXCEPTION;
22 G_CALL_QPATTRIB_FAILED EXCEPTION;
23
24 -- Global constant holding the package name
25
26 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKS_QPATTRIB_PVT';
27 G_APP_NAME CONSTANT VARCHAR2(3) := 'OKS';
28
29 TYPE Contract_HdrRec_Type IS RECORD
30 ( CHR_ID NUMBER
31 , TOP_LINE_ID NUMBER
32 , COV_LINE_ID NUMBER
33 , INVENTORY_ITEM_ID NUMBER
34 , INVT_ORG_ID NUMBER
35 , AUTH_ORG_ID NUMBER
36 , PRICING_DATE DATE
37 , PARTY_ID NUMBER
38 , CUSTOMER_ID NUMBER
39 , BILL_TO NUMBER
40 , SHIP_TO NUMBER
41 , AGREEMENT_ID NUMBER
42 , PAYMENT_TERM_ID NUMBER
43 , BREAK_UOM VARCHAR2(200)
44 );
45
46 TYPE Contract_LinRec_Type IS RECORD
47 ( CHR_ID NUMBER
48 , TOP_LINE_ID NUMBER
49 , COV_LINE_ID NUMBER
50 , INVENTORY_ITEM_ID NUMBER
51 , INVT_ORG_ID NUMBER
52 , AUTH_ORG_ID NUMBER
53 , PRICING_DATE DATE
54 , PARTY_ID NUMBER
55 , CUSTOMER_ID NUMBER
56 , BILL_TO NUMBER
57 , SHIP_TO NUMBER
58 , AGREEMENT_ID NUMBER
59 , PAYMENT_TERM_ID NUMBER
60 , BREAK_UOM VARCHAR2(200)
61 );
62
63 G_CONTRACT_HDRREC CONTRACT_HDRREC_TYPE;
64 G_CONTRACT_LINREC CONTRACT_LINREC_TYPE;
65
66 --VARIABLES for request structures
67 -- OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC
68 -- OKS_QPATTRIB_PVT.G_CONTRACT_LINREC
69
70 -- FUNCTIONS/PROCEDURES
71
72 -- QUALIFIER FUNCTIONS
73
74 --OKS_QPATTRIB_PVT.GET_ACCOUNT_TYPE(OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.CHR_ID)
75 --OKS_QPATTRIB_PVT.GET_ACCOUNT_TYPE(OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.CHR_ID)
76 FUNCTION GET_ACCOUNT_TYPE(p_chr_id IN NUMBER) RETURN QP_ATTR_MAPPING_PUB.T_MULTIRECORD;
77
78 --OKS_QPATTRIB_PVT.GET_AGREEMENT_NAME(OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.CHR_ID)
79 --OKS_QPATTRIB_PVT.GET_AGREEMENT_NAME(OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.CHR_ID)
80 FUNCTION GET_AGREEMENT_NAME (p_chr_id IN NUMBER) RETURN VARCHAR2;
81
82
83
84 --OKS_QPATTRIB_PVT.get_party_id(OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.CHR_ID)
85 --OKS_QPATTRIB_PVT.get_party_id(OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.CHR_ID)
86 FUNCTION GET_PARTY_ID (p_chr_id IN NUMBER) RETURN NUMBER ;
87
88 --OKS_QPATTRIB_PVT.get_party_id(OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.CHR_ID)
89 --OKS_QPATTRIB_PVT.get_party_id(OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.CHR_ID)
90 FUNCTION get_gsa (p_chr_id IN NUMBER) RETURN VARCHAR2;
91
92
93
94 --OKS_QPATTRIB_PVT.get_break_uom(OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.LIN_ID)
95 --FUNCTION get_break_uom (p_cle_id IN NUMBER) RETURN VARCHAR2;
96
97
98
99 --OKS_QPATTRIB_PVT.get_bill_to(OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.CHR_ID)
100 --OKS_QPATTRIB_PVT.get_bill_to(OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.TOP_LINE_ID)
101 --FUNCTION GET_BILL_TO (p_hdr_id IN NUMBER, p_line_id IN NUMBER) RETURN NUMBER ;
102
103
104
105 END;