eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_AP_UTILS_PKG dependencies on JAI_CMN_TAX_CTGS_ALL

Line 354: PROCEDURE auto_create_category(p_tax_category_name IN JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_NAME%TYPE DEFAULT NULL

350: ------------------------------------------------------------------------------------------------
351: --Added by Chong.Lei for DTC bug#13359892 on 20111205 end
352: --Added by Chong.Lei for DTC bug#13359892 on 20111205 begin
353: ------------------------------------------------------------------------------------------------
354: PROCEDURE auto_create_category(p_tax_category_name IN JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_NAME%TYPE DEFAULT NULL
355: ,p_tax_category_desc IN JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_DESC%TYPE DEFAULT NULL
356: ,p_item_class_cd IN JAI_CMN_TAX_CTGS_ALL.ITEM_CLASS_CD%TYPE DEFAULT NULL
357: ,p_org_id IN JAI_CMN_TAX_CTGS_ALL.ORG_ID%TYPE DEFAULT NULL
358: ,p_object_version_number IN JAI_CMN_TAX_CTGS_ALL.OBJECT_VERSION_NUMBER%TYPE DEFAULT NULL

Line 355: ,p_tax_category_desc IN JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_DESC%TYPE DEFAULT NULL

351: --Added by Chong.Lei for DTC bug#13359892 on 20111205 end
352: --Added by Chong.Lei for DTC bug#13359892 on 20111205 begin
353: ------------------------------------------------------------------------------------------------
354: PROCEDURE auto_create_category(p_tax_category_name IN JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_NAME%TYPE DEFAULT NULL
355: ,p_tax_category_desc IN JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_DESC%TYPE DEFAULT NULL
356: ,p_item_class_cd IN JAI_CMN_TAX_CTGS_ALL.ITEM_CLASS_CD%TYPE DEFAULT NULL
357: ,p_org_id IN JAI_CMN_TAX_CTGS_ALL.ORG_ID%TYPE DEFAULT NULL
358: ,p_object_version_number IN JAI_CMN_TAX_CTGS_ALL.OBJECT_VERSION_NUMBER%TYPE DEFAULT NULL
359: ,p_creation_date IN JAI_CMN_TAX_CTGS_ALL.CREATION_DATE%TYPE DEFAULT NULL

Line 356: ,p_item_class_cd IN JAI_CMN_TAX_CTGS_ALL.ITEM_CLASS_CD%TYPE DEFAULT NULL

352: --Added by Chong.Lei for DTC bug#13359892 on 20111205 begin
353: ------------------------------------------------------------------------------------------------
354: PROCEDURE auto_create_category(p_tax_category_name IN JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_NAME%TYPE DEFAULT NULL
355: ,p_tax_category_desc IN JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_DESC%TYPE DEFAULT NULL
356: ,p_item_class_cd IN JAI_CMN_TAX_CTGS_ALL.ITEM_CLASS_CD%TYPE DEFAULT NULL
357: ,p_org_id IN JAI_CMN_TAX_CTGS_ALL.ORG_ID%TYPE DEFAULT NULL
358: ,p_object_version_number IN JAI_CMN_TAX_CTGS_ALL.OBJECT_VERSION_NUMBER%TYPE DEFAULT NULL
359: ,p_creation_date IN JAI_CMN_TAX_CTGS_ALL.CREATION_DATE%TYPE DEFAULT NULL
360: ,p_created_by IN JAI_CMN_TAX_CTGS_ALL.CREATED_BY%TYPE DEFAULT NULL

Line 357: ,p_org_id IN JAI_CMN_TAX_CTGS_ALL.ORG_ID%TYPE DEFAULT NULL

353: ------------------------------------------------------------------------------------------------
354: PROCEDURE auto_create_category(p_tax_category_name IN JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_NAME%TYPE DEFAULT NULL
355: ,p_tax_category_desc IN JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_DESC%TYPE DEFAULT NULL
356: ,p_item_class_cd IN JAI_CMN_TAX_CTGS_ALL.ITEM_CLASS_CD%TYPE DEFAULT NULL
357: ,p_org_id IN JAI_CMN_TAX_CTGS_ALL.ORG_ID%TYPE DEFAULT NULL
358: ,p_object_version_number IN JAI_CMN_TAX_CTGS_ALL.OBJECT_VERSION_NUMBER%TYPE DEFAULT NULL
359: ,p_creation_date IN JAI_CMN_TAX_CTGS_ALL.CREATION_DATE%TYPE DEFAULT NULL
360: ,p_created_by IN JAI_CMN_TAX_CTGS_ALL.CREATED_BY%TYPE DEFAULT NULL
361: ,p_last_update_date IN JAI_CMN_TAX_CTGS_ALL.LAST_UPDATE_DATE%TYPE DEFAULT NULL

Line 358: ,p_object_version_number IN JAI_CMN_TAX_CTGS_ALL.OBJECT_VERSION_NUMBER%TYPE DEFAULT NULL

354: PROCEDURE auto_create_category(p_tax_category_name IN JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_NAME%TYPE DEFAULT NULL
355: ,p_tax_category_desc IN JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_DESC%TYPE DEFAULT NULL
356: ,p_item_class_cd IN JAI_CMN_TAX_CTGS_ALL.ITEM_CLASS_CD%TYPE DEFAULT NULL
357: ,p_org_id IN JAI_CMN_TAX_CTGS_ALL.ORG_ID%TYPE DEFAULT NULL
358: ,p_object_version_number IN JAI_CMN_TAX_CTGS_ALL.OBJECT_VERSION_NUMBER%TYPE DEFAULT NULL
359: ,p_creation_date IN JAI_CMN_TAX_CTGS_ALL.CREATION_DATE%TYPE DEFAULT NULL
360: ,p_created_by IN JAI_CMN_TAX_CTGS_ALL.CREATED_BY%TYPE DEFAULT NULL
361: ,p_last_update_date IN JAI_CMN_TAX_CTGS_ALL.LAST_UPDATE_DATE%TYPE DEFAULT NULL
362: ,p_last_updated_by IN JAI_CMN_TAX_CTGS_ALL.LAST_UPDATED_BY%TYPE DEFAULT NULL

Line 359: ,p_creation_date IN JAI_CMN_TAX_CTGS_ALL.CREATION_DATE%TYPE DEFAULT NULL

355: ,p_tax_category_desc IN JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_DESC%TYPE DEFAULT NULL
356: ,p_item_class_cd IN JAI_CMN_TAX_CTGS_ALL.ITEM_CLASS_CD%TYPE DEFAULT NULL
357: ,p_org_id IN JAI_CMN_TAX_CTGS_ALL.ORG_ID%TYPE DEFAULT NULL
358: ,p_object_version_number IN JAI_CMN_TAX_CTGS_ALL.OBJECT_VERSION_NUMBER%TYPE DEFAULT NULL
359: ,p_creation_date IN JAI_CMN_TAX_CTGS_ALL.CREATION_DATE%TYPE DEFAULT NULL
360: ,p_created_by IN JAI_CMN_TAX_CTGS_ALL.CREATED_BY%TYPE DEFAULT NULL
361: ,p_last_update_date IN JAI_CMN_TAX_CTGS_ALL.LAST_UPDATE_DATE%TYPE DEFAULT NULL
362: ,p_last_updated_by IN JAI_CMN_TAX_CTGS_ALL.LAST_UPDATED_BY%TYPE DEFAULT NULL
363: ,p_last_update_login IN JAI_CMN_TAX_CTGS_ALL.LAST_UPDATE_LOGIN%TYPE DEFAULT NULL

Line 360: ,p_created_by IN JAI_CMN_TAX_CTGS_ALL.CREATED_BY%TYPE DEFAULT NULL

356: ,p_item_class_cd IN JAI_CMN_TAX_CTGS_ALL.ITEM_CLASS_CD%TYPE DEFAULT NULL
357: ,p_org_id IN JAI_CMN_TAX_CTGS_ALL.ORG_ID%TYPE DEFAULT NULL
358: ,p_object_version_number IN JAI_CMN_TAX_CTGS_ALL.OBJECT_VERSION_NUMBER%TYPE DEFAULT NULL
359: ,p_creation_date IN JAI_CMN_TAX_CTGS_ALL.CREATION_DATE%TYPE DEFAULT NULL
360: ,p_created_by IN JAI_CMN_TAX_CTGS_ALL.CREATED_BY%TYPE DEFAULT NULL
361: ,p_last_update_date IN JAI_CMN_TAX_CTGS_ALL.LAST_UPDATE_DATE%TYPE DEFAULT NULL
362: ,p_last_updated_by IN JAI_CMN_TAX_CTGS_ALL.LAST_UPDATED_BY%TYPE DEFAULT NULL
363: ,p_last_update_login IN JAI_CMN_TAX_CTGS_ALL.LAST_UPDATE_LOGIN%TYPE DEFAULT NULL
364: ,p_tax_id IN JAI_CMN_TAX_CTG_LINES.TAX_ID%TYPE DEFAULT NULL

Line 361: ,p_last_update_date IN JAI_CMN_TAX_CTGS_ALL.LAST_UPDATE_DATE%TYPE DEFAULT NULL

357: ,p_org_id IN JAI_CMN_TAX_CTGS_ALL.ORG_ID%TYPE DEFAULT NULL
358: ,p_object_version_number IN JAI_CMN_TAX_CTGS_ALL.OBJECT_VERSION_NUMBER%TYPE DEFAULT NULL
359: ,p_creation_date IN JAI_CMN_TAX_CTGS_ALL.CREATION_DATE%TYPE DEFAULT NULL
360: ,p_created_by IN JAI_CMN_TAX_CTGS_ALL.CREATED_BY%TYPE DEFAULT NULL
361: ,p_last_update_date IN JAI_CMN_TAX_CTGS_ALL.LAST_UPDATE_DATE%TYPE DEFAULT NULL
362: ,p_last_updated_by IN JAI_CMN_TAX_CTGS_ALL.LAST_UPDATED_BY%TYPE DEFAULT NULL
363: ,p_last_update_login IN JAI_CMN_TAX_CTGS_ALL.LAST_UPDATE_LOGIN%TYPE DEFAULT NULL
364: ,p_tax_id IN JAI_CMN_TAX_CTG_LINES.TAX_ID%TYPE DEFAULT NULL
365: );

Line 362: ,p_last_updated_by IN JAI_CMN_TAX_CTGS_ALL.LAST_UPDATED_BY%TYPE DEFAULT NULL

358: ,p_object_version_number IN JAI_CMN_TAX_CTGS_ALL.OBJECT_VERSION_NUMBER%TYPE DEFAULT NULL
359: ,p_creation_date IN JAI_CMN_TAX_CTGS_ALL.CREATION_DATE%TYPE DEFAULT NULL
360: ,p_created_by IN JAI_CMN_TAX_CTGS_ALL.CREATED_BY%TYPE DEFAULT NULL
361: ,p_last_update_date IN JAI_CMN_TAX_CTGS_ALL.LAST_UPDATE_DATE%TYPE DEFAULT NULL
362: ,p_last_updated_by IN JAI_CMN_TAX_CTGS_ALL.LAST_UPDATED_BY%TYPE DEFAULT NULL
363: ,p_last_update_login IN JAI_CMN_TAX_CTGS_ALL.LAST_UPDATE_LOGIN%TYPE DEFAULT NULL
364: ,p_tax_id IN JAI_CMN_TAX_CTG_LINES.TAX_ID%TYPE DEFAULT NULL
365: );
366:

Line 363: ,p_last_update_login IN JAI_CMN_TAX_CTGS_ALL.LAST_UPDATE_LOGIN%TYPE DEFAULT NULL

359: ,p_creation_date IN JAI_CMN_TAX_CTGS_ALL.CREATION_DATE%TYPE DEFAULT NULL
360: ,p_created_by IN JAI_CMN_TAX_CTGS_ALL.CREATED_BY%TYPE DEFAULT NULL
361: ,p_last_update_date IN JAI_CMN_TAX_CTGS_ALL.LAST_UPDATE_DATE%TYPE DEFAULT NULL
362: ,p_last_updated_by IN JAI_CMN_TAX_CTGS_ALL.LAST_UPDATED_BY%TYPE DEFAULT NULL
363: ,p_last_update_login IN JAI_CMN_TAX_CTGS_ALL.LAST_UPDATE_LOGIN%TYPE DEFAULT NULL
364: ,p_tax_id IN JAI_CMN_TAX_CTG_LINES.TAX_ID%TYPE DEFAULT NULL
365: );
366:
367: PROCEDURE auto_create_dtc_category(p_tax_category_name IN JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_NAME%TYPE

Line 367: PROCEDURE auto_create_dtc_category(p_tax_category_name IN JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_NAME%TYPE

363: ,p_last_update_login IN JAI_CMN_TAX_CTGS_ALL.LAST_UPDATE_LOGIN%TYPE DEFAULT NULL
364: ,p_tax_id IN JAI_CMN_TAX_CTG_LINES.TAX_ID%TYPE DEFAULT NULL
365: );
366:
367: PROCEDURE auto_create_dtc_category(p_tax_category_name IN JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_NAME%TYPE
368: ,p_tax_category_desc IN JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_DESC%TYPE
369: ,p_item_class_cd IN JAI_CMN_TAX_CTGS_ALL.ITEM_CLASS_CD%TYPE
370: ,p_org_id IN JAI_CMN_TAX_CTGS_ALL.ORG_ID%TYPE
371: ,p_object_version_number IN JAI_CMN_TAX_CTGS_ALL.OBJECT_VERSION_NUMBER%TYPE

Line 368: ,p_tax_category_desc IN JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_DESC%TYPE

364: ,p_tax_id IN JAI_CMN_TAX_CTG_LINES.TAX_ID%TYPE DEFAULT NULL
365: );
366:
367: PROCEDURE auto_create_dtc_category(p_tax_category_name IN JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_NAME%TYPE
368: ,p_tax_category_desc IN JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_DESC%TYPE
369: ,p_item_class_cd IN JAI_CMN_TAX_CTGS_ALL.ITEM_CLASS_CD%TYPE
370: ,p_org_id IN JAI_CMN_TAX_CTGS_ALL.ORG_ID%TYPE
371: ,p_object_version_number IN JAI_CMN_TAX_CTGS_ALL.OBJECT_VERSION_NUMBER%TYPE
372: ,p_tax_id IN JAI_CMN_TAX_CTG_LINES.TAX_ID%TYPE

Line 369: ,p_item_class_cd IN JAI_CMN_TAX_CTGS_ALL.ITEM_CLASS_CD%TYPE

365: );
366:
367: PROCEDURE auto_create_dtc_category(p_tax_category_name IN JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_NAME%TYPE
368: ,p_tax_category_desc IN JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_DESC%TYPE
369: ,p_item_class_cd IN JAI_CMN_TAX_CTGS_ALL.ITEM_CLASS_CD%TYPE
370: ,p_org_id IN JAI_CMN_TAX_CTGS_ALL.ORG_ID%TYPE
371: ,p_object_version_number IN JAI_CMN_TAX_CTGS_ALL.OBJECT_VERSION_NUMBER%TYPE
372: ,p_tax_id IN JAI_CMN_TAX_CTG_LINES.TAX_ID%TYPE
373: );

Line 370: ,p_org_id IN JAI_CMN_TAX_CTGS_ALL.ORG_ID%TYPE

366:
367: PROCEDURE auto_create_dtc_category(p_tax_category_name IN JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_NAME%TYPE
368: ,p_tax_category_desc IN JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_DESC%TYPE
369: ,p_item_class_cd IN JAI_CMN_TAX_CTGS_ALL.ITEM_CLASS_CD%TYPE
370: ,p_org_id IN JAI_CMN_TAX_CTGS_ALL.ORG_ID%TYPE
371: ,p_object_version_number IN JAI_CMN_TAX_CTGS_ALL.OBJECT_VERSION_NUMBER%TYPE
372: ,p_tax_id IN JAI_CMN_TAX_CTG_LINES.TAX_ID%TYPE
373: );
374:

Line 371: ,p_object_version_number IN JAI_CMN_TAX_CTGS_ALL.OBJECT_VERSION_NUMBER%TYPE

367: PROCEDURE auto_create_dtc_category(p_tax_category_name IN JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_NAME%TYPE
368: ,p_tax_category_desc IN JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_DESC%TYPE
369: ,p_item_class_cd IN JAI_CMN_TAX_CTGS_ALL.ITEM_CLASS_CD%TYPE
370: ,p_org_id IN JAI_CMN_TAX_CTGS_ALL.ORG_ID%TYPE
371: ,p_object_version_number IN JAI_CMN_TAX_CTGS_ALL.OBJECT_VERSION_NUMBER%TYPE
372: ,p_tax_id IN JAI_CMN_TAX_CTG_LINES.TAX_ID%TYPE
373: );
374:
375: PROCEDURE insert_jai_cmn_taxes_all (