[Home] [Help]
PACKAGE BODY: APPS.ARP_MULTI_COMMON_COVER
Source
1 PACKAGE BODY ARP_MULTI_COMMON_COVER as
2 /* $Header: ARXEMCCB.pls 120.5 2006/05/10 00:08:17 sachandr ship $ */
3 /* Purpose: This package provides the support functions used to create */
4 /* Multiple tax rate exceptions/exemptions given a range of items. */
5 /* The package is used by the 10SC forms RAXSTDTE and RAXSUDTE. */
6
7 /*----------------------------------------------------------------------------*
8 | PROCEDURE |
9 | get_exceptions_count |
10 | |
11 | DESCRIPTION |
12 | This procedure will provide the count of Items selected and the # of |
13 | exceptions that will be affected by the transaction, given and Item |
14 | Flex Range, Item Category Set, Item Category, Item Type, Exception |
15 | Location and Effective dates. |
16 | |
17 | PARAMETERS |
18 | p_Item Count OUT NOCOPY NUMBER -- Item Count |
19 | p_Exception_Count OUT NOCOPY NUMBER -- Exception Count |
20 | p_Trans_Type IN NUMBER -- Transaction Type,I(insert)/U(pdate)|
21 | p_Org Id IN NUMBER -- Organization Id |
22 | Item Flex Range, Item Category Set, Item Category, Item Type and |
23 | Exception Location and Effective dates. |
24 | |
25 | HISTORY |
26 | 19-Mar-96 Mahesh Sabapathy Created. |
27 *----------------------------------------------------------------------------*/
28 PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
29
30 PROCEDURE get_exceptions_count( p_Item_Count OUT NOCOPY NUMBER,
31 p_Exception_Count OUT NOCOPY NUMBER,
32 p_Trans_Type VARCHAR2,
33 p_Org_ID NUMBER,
34 p_Item_Segment1_Low VARCHAR2,
35 p_Item_Segment1_High VARCHAR2,
36 p_Item_Segment2_Low VARCHAR2,
37 p_Item_Segment2_High VARCHAR2,
38 p_Item_Segment3_Low VARCHAR2,
39 p_Item_Segment3_High VARCHAR2,
40 p_Item_Segment4_Low VARCHAR2,
41 p_Item_Segment4_High VARCHAR2,
42 p_Item_Segment5_Low VARCHAR2,
43 p_Item_Segment5_High VARCHAR2,
44 p_Item_Segment6_Low VARCHAR2,
45 p_Item_Segment6_High VARCHAR2,
46 p_Item_Segment7_Low VARCHAR2,
47 p_Item_Segment7_High VARCHAR2,
48 p_Item_Segment8_Low VARCHAR2,
49 p_Item_Segment8_High VARCHAR2,
50 p_Item_Segment9_Low VARCHAR2,
51 p_Item_Segment9_High VARCHAR2,
52 p_Item_Segment10_Low VARCHAR2,
53 p_Item_Segment10_High VARCHAR2,
54 p_Category_Set_Id NUMBER,
55 p_Category_Id NUMBER,
56 p_Item_Type VARCHAR2,
57 p_Location_Id_Segment_1 NUMBER,
58 p_Location_Id_Segment_2 NUMBER,
59 p_Location_Id_Segment_3 NUMBER,
60 p_Location_Id_Segment_4 NUMBER,
61 p_Location_Id_Segment_5 NUMBER,
62 p_Location_Id_Segment_6 NUMBER,
63 p_Location_Id_Segment_7 NUMBER,
64 p_Location_Id_Segment_8 NUMBER,
65 p_Location_Id_Segment_9 NUMBER,
66 p_Location_Id_Segment_10 NUMBER,
67 p_Start_Date DATE,
68 p_End_Date DATE
69 ) IS
70 BEGIN
71
72 null;
73
74
75 EXCEPTION
76 WHEN OTHERS THEN
77 null;
78 END get_exceptions_count;
79
80 /*----------------------------------------------------------------------------*
81 | PROCEDURE |
82 | get_exemptions_count |
83 | |
84 | DESCRIPTION |
85 | This procedure will provide the count of Items selected and the # of |
86 | exemptions that will be affected by the transaction, given and Item |
87 | Flex Range, Item Category Set, Item Category, Item Type, Exemption |
88 | Location and Effective dates. |
89 | |
90 | PARAMETERS |
91 | p_Item Count OUT NOCOPY NUMBER -- Item Count |
92 | p_Exemption_Count OUT NOCOPY NUMBER -- Exemption Count |
93 | p_Trans_Type IN NUMBER -- Transaction Type,I(insert)/U(pdate)|
94 | p_Org Id IN NUMBER -- Organization Id |
95 | Item Flex Range, Item Category Set, Item Category, Item Type , |
96 | Exemption Tax Code and Effective dates. |
97 | |
98 | HISTORY |
99 | 19-Mar-96 Mahesh Sabapathy Created. |
100 *----------------------------------------------------------------------------*/
101 PROCEDURE get_exemptions_count( p_Item_Count OUT NOCOPY NUMBER,
102 p_Exemption_Count OUT NOCOPY NUMBER,
103 p_Trans_Type VARCHAR2,
104 p_Org_ID NUMBER,
105 p_Item_Segment1_Low VARCHAR2,
106 p_Item_Segment1_High VARCHAR2,
107 p_Item_Segment2_Low VARCHAR2,
108 p_Item_Segment2_High VARCHAR2,
109 p_Item_Segment3_Low VARCHAR2,
110 p_Item_Segment3_High VARCHAR2,
111 p_Item_Segment4_Low VARCHAR2,
112 p_Item_Segment4_High VARCHAR2,
113 p_Item_Segment5_Low VARCHAR2,
114 p_Item_Segment5_High VARCHAR2,
115 p_Item_Segment6_Low VARCHAR2,
116 p_Item_Segment6_High VARCHAR2,
117 p_Item_Segment7_Low VARCHAR2,
118 p_Item_Segment7_High VARCHAR2,
119 p_Item_Segment8_Low VARCHAR2,
120 p_Item_Segment8_High VARCHAR2,
121 p_Item_Segment9_Low VARCHAR2,
122 p_Item_Segment9_High VARCHAR2,
123 p_Item_Segment10_Low VARCHAR2,
124 p_Item_Segment10_High VARCHAR2,
125 p_Category_Set_Id NUMBER,
126 p_Category_Id NUMBER,
127 p_Item_Type VARCHAR2,
128 p_Tax_Code VARCHAR2,
129 p_Start_Date DATE,
130 p_End_Date DATE
131 ) IS
132 BEGIN
133 null;
134 EXCEPTION
135 WHEN OTHERS THEN
136 null;
137 END get_exemptions_count;
138
139 END ARP_MULTI_COMMON_COVER;