[Home] [Help]
PACKAGE: APPS.OKE_NUMBER_SEQUENCES_PKG
Source
1 PACKAGE OKE_NUMBER_SEQUENCES_PKG AS
2 /* $Header: OKENMSQS.pls 120.1 2005/06/02 11:59:33 appldev $ */
3 --
4 -- Name : Number_Option
5 -- Pre-reqs : None
6 -- Function : This procedure returns the numbering option given
7 -- the contract type and intent.
8 --
9 --
10 -- Parameters :
11 -- IN : X_K_TYPE_CODE VARCHAR2
12 -- X_BUY_OR_SELL VARCHAR2
13 -- B - Buy
14 -- S - Sell
15 -- X_OBJECT_NAME VARCHAR2
16 -- HEADER - Document Header
17 -- CHGREQ - Change Request
18 -- OUT NOCOPY /* file.sql.39 change */ : X_Num_Mode VARCHAR2
19 -- MANUAL - Manual
20 -- AUTOMATIC - Automatic
21 -- X_Manual_Num_Type VARCHAR2
22 -- NUMERIC - Numeric
23 -- ALPHANUMERIC - Alphanumeric
24 --
25 -- Returns : None
26 --
27
28 PROCEDURE Number_Option
29 ( X_K_Type_Code IN VARCHAR2
30 , X_Buy_Or_Sell IN VARCHAR2
31 , X_Object_Name IN VARCHAR2
32 , X_Num_Mode OUT NOCOPY /* file.sql.39 change */ VARCHAR2
33 , X_Manual_Num_Type OUT NOCOPY /* file.sql.39 change */ VARCHAR2
34 );
35
36
37 --
38 -- Name : Value_Is_Numeric
39 -- Pre-reqs : None
40 -- Function : This function tests whether a give string is
41 -- numeric or not.
42 --
43 --
44 -- Parameters :
45 -- IN : X_VALUE VARCHAR2
46 -- OUT NOCOPY /* file.sql.39 change */ : None
47 --
48 -- Returns : VARCHAR2
49 --
50 FUNCTION Value_Is_Numeric
51 ( X_Value IN VARCHAR2
52 ) RETURN VARCHAR2;
53
54
55 --
56 -- Name : Next_Contract_Number
57 -- Pre-reqs : None
58 -- Function : This function returns the next number based on
59 -- numbering option
60 --
61 --
62 -- Parameters :
63 -- IN : X_K_TYPE_CODE VARCHAR2
64 -- X_BUY_OR_SELL VARCHAR2
65 -- B - Buy
66 -- S - Sell
67 -- OUT NOCOPY /* file.sql.39 change */ : None
68 --
69 -- Returns : VARCHAR2
70 --
71 FUNCTION Next_Contract_Number
72 ( X_K_Type_Code IN VARCHAR2
73 , X_Buy_Or_Sell IN VARCHAR2
74 ) RETURN VARCHAR2;
75
76
77 --
78 -- Name : Next_ChgReq_Number
79 -- Pre-reqs : None
80 -- Function : This function returns the next change request
81 -- number based on numbering option
82 --
83 --
84 -- Parameters :
85 -- IN : X_CHG_TYPE_CODE VARCHAR2
86 -- X_K_HEADER_ID NUMBER
87 -- OUT NOCOPY /* file.sql.39 change */ : None
88 --
89 -- Returns : VARCHAR2
90 --
91 FUNCTION Next_ChgReq_Number
92 ( X_Chg_Type_Code IN VARCHAR2
93 , X_K_Header_ID IN NUMBER
94 ) RETURN VARCHAR2;
95
96
97 --
98 -- Name : Next_Line_Number
99 -- Pre-reqs : None
100 -- Function : This function returns the next line
101 -- number based on numbering option
102 --
103 --
104 -- Parameters :
105 -- IN : X_K_HEADER_ID NUMBER
106 -- X_PARENT_LINE_ID NUMBER
107 -- OUT NOCOPY /* file.sql.39 change */ : None
108 --
109 -- Returns : VARCHAR2
110 --
111 FUNCTION Next_Line_Number
112 ( X_K_Header_ID IN NUMBER
113 , X_Parent_Line_ID IN NUMBER
114 ) RETURN VARCHAR2;
115
116 --
117 -- Name : Next_Deliverable_Number
118 -- Pre-reqs : None
119 -- Function : This function returns the next deliverable
120 -- number based on numbering option
121 --
122 --
123 -- Parameters :
124 -- IN : X_K_HEADER_ID NUMBER
125 -- X_K_LINE_ID NUMBER
126 -- OUT NOCOPY /* file.sql.39 change */ : None
127 --
128 -- Returns : VARCHAR2
129 --
130 FUNCTION Next_Deliverable_Number
131 ( X_K_Header_ID IN NUMBER
132 , X_K_Line_ID IN NUMBER
133 ) RETURN VARCHAR2;
134
135 END OKE_NUMBER_SEQUENCES_PKG;