[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
| This procedure will provide the count of Items selected and the # of |
| exceptions that will be affected by the transaction, given and Item |
| Flex Range, Item Category Set, Item Category, Item Type, Exception |
| Location and Effective dates. |
| |
| PARAMETERS |
| p_Item Count OUT NOCOPY NUMBER -- Item Count |
| p_Exception_Count OUT NOCOPY NUMBER -- Exception Count |
| p_Trans_Type IN NUMBER -- Transaction Type,I(insert)/U(pdate)|
| p_Org Id IN NUMBER -- Organization Id |
| Item Flex Range, Item Category Set, Item Category, Item Type and |
| Exception Location and Effective dates. |
| |
| HISTORY |
| 19-Mar-96 Mahesh Sabapathy Created. |
*----------------------------------------------------------------------------*/
PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
| This procedure will provide the count of Items selected and the # of |
| exemptions that will be affected by the transaction, given and Item |
| Flex Range, Item Category Set, Item Category, Item Type, Exemption |
| Location and Effective dates. |
| |
| PARAMETERS |
| p_Item Count OUT NOCOPY NUMBER -- Item Count |
| p_Exemption_Count OUT NOCOPY NUMBER -- Exemption Count |
| p_Trans_Type IN NUMBER -- Transaction Type,I(insert)/U(pdate)|
| p_Org Id IN NUMBER -- Organization Id |
| Item Flex Range, Item Category Set, Item Category, Item Type , |
| Exemption Tax Code and Effective dates. |
| |
| HISTORY |
| 19-Mar-96 Mahesh Sabapathy Created. |
*----------------------------------------------------------------------------*/
PROCEDURE get_exemptions_count( p_Item_Count OUT NOCOPY NUMBER,
p_Exemption_Count OUT NOCOPY NUMBER,
p_Trans_Type VARCHAR2,
p_Org_ID NUMBER,
p_Item_Segment1_Low VARCHAR2,
p_Item_Segment1_High VARCHAR2,
p_Item_Segment2_Low VARCHAR2,
p_Item_Segment2_High VARCHAR2,
p_Item_Segment3_Low VARCHAR2,
p_Item_Segment3_High VARCHAR2,
p_Item_Segment4_Low VARCHAR2,
p_Item_Segment4_High VARCHAR2,
p_Item_Segment5_Low VARCHAR2,
p_Item_Segment5_High VARCHAR2,
p_Item_Segment6_Low VARCHAR2,
p_Item_Segment6_High VARCHAR2,
p_Item_Segment7_Low VARCHAR2,
p_Item_Segment7_High VARCHAR2,
p_Item_Segment8_Low VARCHAR2,
p_Item_Segment8_High VARCHAR2,
p_Item_Segment9_Low VARCHAR2,
p_Item_Segment9_High VARCHAR2,
p_Item_Segment10_Low VARCHAR2,
p_Item_Segment10_High VARCHAR2,
p_Category_Set_Id NUMBER,
p_Category_Id NUMBER,
p_Item_Type VARCHAR2,
p_Tax_Code VARCHAR2,
p_Start_Date DATE,
p_End_Date DATE
) IS
BEGIN
null;