[Home] [Help]
PACKAGE: APPS.ARP_MULTI_COMMON_COVER
Source
1 PACKAGE ARP_MULTI_COMMON_COVER AUTHID CURRENT_USER as
2 /* $Header: ARXEMCCS.pls 115.1 2002/11/15 04:15:30 anukumar 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, Exemption |
15 | Location and Effective dates. |
16 | |
17 | PARAMETERS |
18 | p_Item Count OUT NOCOPY NUMBER -- Item Count |
19 | p_Exemption_Count OUT NOCOPY NUMBER -- Exemption 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 | Exemption Location and Effective dates. |
24 | |
25 | HISTORY |
26 | 19-Mar-96 Mahesh Sabapathy Created. |
27 *----------------------------------------------------------------------------*/
28 PROCEDURE get_exceptions_count( p_Item_Count OUT NOCOPY NUMBER,
29 p_Exception_Count OUT NOCOPY NUMBER,
30 p_Trans_Type VARCHAR2,
31 p_Org_ID NUMBER,
32 p_Item_Segment1_Low VARCHAR2,
33 p_Item_Segment1_High VARCHAR2,
34 p_Item_Segment2_Low VARCHAR2,
35 p_Item_Segment2_High VARCHAR2,
36 p_Item_Segment3_Low VARCHAR2,
37 p_Item_Segment3_High VARCHAR2,
38 p_Item_Segment4_Low VARCHAR2,
39 p_Item_Segment4_High VARCHAR2,
40 p_Item_Segment5_Low VARCHAR2,
41 p_Item_Segment5_High VARCHAR2,
42 p_Item_Segment6_Low VARCHAR2,
43 p_Item_Segment6_High VARCHAR2,
44 p_Item_Segment7_Low VARCHAR2,
45 p_Item_Segment7_High VARCHAR2,
46 p_Item_Segment8_Low VARCHAR2,
47 p_Item_Segment8_High VARCHAR2,
48 p_Item_Segment9_Low VARCHAR2,
49 p_Item_Segment9_High VARCHAR2,
50 p_Item_Segment10_Low VARCHAR2,
51 p_Item_Segment10_High VARCHAR2,
52 p_Category_Set_Id NUMBER,
53 p_Category_Id NUMBER,
54 p_Item_Type VARCHAR2,
55 p_Location_Id_Segment_1 NUMBER,
56 p_Location_Id_Segment_2 NUMBER,
57 p_Location_Id_Segment_3 NUMBER,
58 p_Location_Id_Segment_4 NUMBER,
59 p_Location_Id_Segment_5 NUMBER,
60 p_Location_Id_Segment_6 NUMBER,
61 p_Location_Id_Segment_7 NUMBER,
62 p_Location_Id_Segment_8 NUMBER,
63 p_Location_Id_Segment_9 NUMBER,
64 p_Location_Id_Segment_10 NUMBER,
65 p_Start_Date DATE,
66 p_End_Date DATE
67 );
68
69 /*----------------------------------------------------------------------------*
70 | PROCEDURE |
71 | get_exemptions_count |
72 | |
73 | DESCRIPTION |
74 | This procedure will provide the count of Items selected and the # of |
75 | exemptions that will be affected by the transaction, given and Item |
76 | Flex Range, Item Category Set, Item Category, Item Type, Exemption |
77 | Location and Effective dates. |
78 | |
79 | PARAMETERS |
80 | p_Item Count OUT NOCOPY NUMBER -- Item Count |
81 | p_Exemption_Count OUT NOCOPY NUMBER -- Exemption Count |
82 | p_Trans_Type IN NUMBER -- Transaction Type,I(insert)/U(pdate)|
83 | p_Org Id IN NUMBER -- Organization Id |
84 | Item Flex Range, Item Category Set, Item Category, Item Type , |
85 | Exemption Tax Code and Effective dates. |
86 | |
87 | HISTORY |
88 | 19-Mar-96 Mahesh Sabapathy Created. |
89 *----------------------------------------------------------------------------*/
90 PROCEDURE get_exemptions_count( p_Item_Count OUT NOCOPY NUMBER,
91 p_Exemption_Count OUT NOCOPY NUMBER,
92 p_Trans_Type VARCHAR2,
93 p_Org_ID NUMBER,
94 p_Item_Segment1_Low VARCHAR2,
95 p_Item_Segment1_High VARCHAR2,
96 p_Item_Segment2_Low VARCHAR2,
97 p_Item_Segment2_High VARCHAR2,
98 p_Item_Segment3_Low VARCHAR2,
99 p_Item_Segment3_High VARCHAR2,
100 p_Item_Segment4_Low VARCHAR2,
101 p_Item_Segment4_High VARCHAR2,
102 p_Item_Segment5_Low VARCHAR2,
103 p_Item_Segment5_High VARCHAR2,
104 p_Item_Segment6_Low VARCHAR2,
105 p_Item_Segment6_High VARCHAR2,
106 p_Item_Segment7_Low VARCHAR2,
107 p_Item_Segment7_High VARCHAR2,
108 p_Item_Segment8_Low VARCHAR2,
109 p_Item_Segment8_High VARCHAR2,
110 p_Item_Segment9_Low VARCHAR2,
111 p_Item_Segment9_High VARCHAR2,
112 p_Item_Segment10_Low VARCHAR2,
113 p_Item_Segment10_High VARCHAR2,
114 p_Category_Set_Id NUMBER,
115 p_Category_Id NUMBER,
116 p_Item_Type VARCHAR2,
117 p_Tax_Code VARCHAR2,
118 p_Start_Date DATE,
119 p_End_Date DATE
120 );
121
122 END ARP_MULTI_COMMON_COVER;