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 3534: PROCEDURE auto_create_category(p_tax_category_name IN JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_NAME%TYPE

3530: /*Added by Wenqiong for DTC end*/
3531:
3532: --Added by Chong.Lei for DTC bug#13359892 on 20111205 begin
3533: ------------------------------------------------------------------------------------------------
3534: PROCEDURE auto_create_category(p_tax_category_name IN JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_NAME%TYPE
3535: ,p_tax_category_desc IN JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_DESC%TYPE
3536: ,p_item_class_cd IN JAI_CMN_TAX_CTGS_ALL.ITEM_CLASS_CD%TYPE
3537: ,p_org_id IN JAI_CMN_TAX_CTGS_ALL.ORG_ID%TYPE
3538: ,p_object_version_number IN JAI_CMN_TAX_CTGS_ALL.OBJECT_VERSION_NUMBER%TYPE

Line 3535: ,p_tax_category_desc IN JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_DESC%TYPE

3531:
3532: --Added by Chong.Lei for DTC bug#13359892 on 20111205 begin
3533: ------------------------------------------------------------------------------------------------
3534: PROCEDURE auto_create_category(p_tax_category_name IN JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_NAME%TYPE
3535: ,p_tax_category_desc IN JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_DESC%TYPE
3536: ,p_item_class_cd IN JAI_CMN_TAX_CTGS_ALL.ITEM_CLASS_CD%TYPE
3537: ,p_org_id IN JAI_CMN_TAX_CTGS_ALL.ORG_ID%TYPE
3538: ,p_object_version_number IN JAI_CMN_TAX_CTGS_ALL.OBJECT_VERSION_NUMBER%TYPE
3539: ,p_creation_date IN JAI_CMN_TAX_CTGS_ALL.CREATION_DATE%TYPE

Line 3536: ,p_item_class_cd IN JAI_CMN_TAX_CTGS_ALL.ITEM_CLASS_CD%TYPE

3532: --Added by Chong.Lei for DTC bug#13359892 on 20111205 begin
3533: ------------------------------------------------------------------------------------------------
3534: PROCEDURE auto_create_category(p_tax_category_name IN JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_NAME%TYPE
3535: ,p_tax_category_desc IN JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_DESC%TYPE
3536: ,p_item_class_cd IN JAI_CMN_TAX_CTGS_ALL.ITEM_CLASS_CD%TYPE
3537: ,p_org_id IN JAI_CMN_TAX_CTGS_ALL.ORG_ID%TYPE
3538: ,p_object_version_number IN JAI_CMN_TAX_CTGS_ALL.OBJECT_VERSION_NUMBER%TYPE
3539: ,p_creation_date IN JAI_CMN_TAX_CTGS_ALL.CREATION_DATE%TYPE
3540: ,p_created_by IN JAI_CMN_TAX_CTGS_ALL.CREATED_BY%TYPE

Line 3537: ,p_org_id IN JAI_CMN_TAX_CTGS_ALL.ORG_ID%TYPE

3533: ------------------------------------------------------------------------------------------------
3534: PROCEDURE auto_create_category(p_tax_category_name IN JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_NAME%TYPE
3535: ,p_tax_category_desc IN JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_DESC%TYPE
3536: ,p_item_class_cd IN JAI_CMN_TAX_CTGS_ALL.ITEM_CLASS_CD%TYPE
3537: ,p_org_id IN JAI_CMN_TAX_CTGS_ALL.ORG_ID%TYPE
3538: ,p_object_version_number IN JAI_CMN_TAX_CTGS_ALL.OBJECT_VERSION_NUMBER%TYPE
3539: ,p_creation_date IN JAI_CMN_TAX_CTGS_ALL.CREATION_DATE%TYPE
3540: ,p_created_by IN JAI_CMN_TAX_CTGS_ALL.CREATED_BY%TYPE
3541: ,p_last_update_date IN JAI_CMN_TAX_CTGS_ALL.LAST_UPDATE_DATE%TYPE

Line 3538: ,p_object_version_number IN JAI_CMN_TAX_CTGS_ALL.OBJECT_VERSION_NUMBER%TYPE

3534: PROCEDURE auto_create_category(p_tax_category_name IN JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_NAME%TYPE
3535: ,p_tax_category_desc IN JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_DESC%TYPE
3536: ,p_item_class_cd IN JAI_CMN_TAX_CTGS_ALL.ITEM_CLASS_CD%TYPE
3537: ,p_org_id IN JAI_CMN_TAX_CTGS_ALL.ORG_ID%TYPE
3538: ,p_object_version_number IN JAI_CMN_TAX_CTGS_ALL.OBJECT_VERSION_NUMBER%TYPE
3539: ,p_creation_date IN JAI_CMN_TAX_CTGS_ALL.CREATION_DATE%TYPE
3540: ,p_created_by IN JAI_CMN_TAX_CTGS_ALL.CREATED_BY%TYPE
3541: ,p_last_update_date IN JAI_CMN_TAX_CTGS_ALL.LAST_UPDATE_DATE%TYPE
3542: ,p_last_updated_by IN JAI_CMN_TAX_CTGS_ALL.LAST_UPDATED_BY%TYPE

Line 3539: ,p_creation_date IN JAI_CMN_TAX_CTGS_ALL.CREATION_DATE%TYPE

3535: ,p_tax_category_desc IN JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_DESC%TYPE
3536: ,p_item_class_cd IN JAI_CMN_TAX_CTGS_ALL.ITEM_CLASS_CD%TYPE
3537: ,p_org_id IN JAI_CMN_TAX_CTGS_ALL.ORG_ID%TYPE
3538: ,p_object_version_number IN JAI_CMN_TAX_CTGS_ALL.OBJECT_VERSION_NUMBER%TYPE
3539: ,p_creation_date IN JAI_CMN_TAX_CTGS_ALL.CREATION_DATE%TYPE
3540: ,p_created_by IN JAI_CMN_TAX_CTGS_ALL.CREATED_BY%TYPE
3541: ,p_last_update_date IN JAI_CMN_TAX_CTGS_ALL.LAST_UPDATE_DATE%TYPE
3542: ,p_last_updated_by IN JAI_CMN_TAX_CTGS_ALL.LAST_UPDATED_BY%TYPE
3543: ,p_last_update_login IN JAI_CMN_TAX_CTGS_ALL.LAST_UPDATE_LOGIN%TYPE

Line 3540: ,p_created_by IN JAI_CMN_TAX_CTGS_ALL.CREATED_BY%TYPE

3536: ,p_item_class_cd IN JAI_CMN_TAX_CTGS_ALL.ITEM_CLASS_CD%TYPE
3537: ,p_org_id IN JAI_CMN_TAX_CTGS_ALL.ORG_ID%TYPE
3538: ,p_object_version_number IN JAI_CMN_TAX_CTGS_ALL.OBJECT_VERSION_NUMBER%TYPE
3539: ,p_creation_date IN JAI_CMN_TAX_CTGS_ALL.CREATION_DATE%TYPE
3540: ,p_created_by IN JAI_CMN_TAX_CTGS_ALL.CREATED_BY%TYPE
3541: ,p_last_update_date IN JAI_CMN_TAX_CTGS_ALL.LAST_UPDATE_DATE%TYPE
3542: ,p_last_updated_by IN JAI_CMN_TAX_CTGS_ALL.LAST_UPDATED_BY%TYPE
3543: ,p_last_update_login IN JAI_CMN_TAX_CTGS_ALL.LAST_UPDATE_LOGIN%TYPE
3544: ,p_tax_id IN JAI_CMN_TAX_CTG_LINES.TAX_ID%TYPE

Line 3541: ,p_last_update_date IN JAI_CMN_TAX_CTGS_ALL.LAST_UPDATE_DATE%TYPE

3537: ,p_org_id IN JAI_CMN_TAX_CTGS_ALL.ORG_ID%TYPE
3538: ,p_object_version_number IN JAI_CMN_TAX_CTGS_ALL.OBJECT_VERSION_NUMBER%TYPE
3539: ,p_creation_date IN JAI_CMN_TAX_CTGS_ALL.CREATION_DATE%TYPE
3540: ,p_created_by IN JAI_CMN_TAX_CTGS_ALL.CREATED_BY%TYPE
3541: ,p_last_update_date IN JAI_CMN_TAX_CTGS_ALL.LAST_UPDATE_DATE%TYPE
3542: ,p_last_updated_by IN JAI_CMN_TAX_CTGS_ALL.LAST_UPDATED_BY%TYPE
3543: ,p_last_update_login IN JAI_CMN_TAX_CTGS_ALL.LAST_UPDATE_LOGIN%TYPE
3544: ,p_tax_id IN JAI_CMN_TAX_CTG_LINES.TAX_ID%TYPE
3545: )

Line 3542: ,p_last_updated_by IN JAI_CMN_TAX_CTGS_ALL.LAST_UPDATED_BY%TYPE

3538: ,p_object_version_number IN JAI_CMN_TAX_CTGS_ALL.OBJECT_VERSION_NUMBER%TYPE
3539: ,p_creation_date IN JAI_CMN_TAX_CTGS_ALL.CREATION_DATE%TYPE
3540: ,p_created_by IN JAI_CMN_TAX_CTGS_ALL.CREATED_BY%TYPE
3541: ,p_last_update_date IN JAI_CMN_TAX_CTGS_ALL.LAST_UPDATE_DATE%TYPE
3542: ,p_last_updated_by IN JAI_CMN_TAX_CTGS_ALL.LAST_UPDATED_BY%TYPE
3543: ,p_last_update_login IN JAI_CMN_TAX_CTGS_ALL.LAST_UPDATE_LOGIN%TYPE
3544: ,p_tax_id IN JAI_CMN_TAX_CTG_LINES.TAX_ID%TYPE
3545: )
3546: IS

Line 3543: ,p_last_update_login IN JAI_CMN_TAX_CTGS_ALL.LAST_UPDATE_LOGIN%TYPE

3539: ,p_creation_date IN JAI_CMN_TAX_CTGS_ALL.CREATION_DATE%TYPE
3540: ,p_created_by IN JAI_CMN_TAX_CTGS_ALL.CREATED_BY%TYPE
3541: ,p_last_update_date IN JAI_CMN_TAX_CTGS_ALL.LAST_UPDATE_DATE%TYPE
3542: ,p_last_updated_by IN JAI_CMN_TAX_CTGS_ALL.LAST_UPDATED_BY%TYPE
3543: ,p_last_update_login IN JAI_CMN_TAX_CTGS_ALL.LAST_UPDATE_LOGIN%TYPE
3544: ,p_tax_id IN JAI_CMN_TAX_CTG_LINES.TAX_ID%TYPE
3545: )
3546: IS
3547: CURSOR tax_cat_id IS

Line 3548: SELECT JAI_CMN_TAX_CTGS_ALL_S.nextval val_id

3544: ,p_tax_id IN JAI_CMN_TAX_CTG_LINES.TAX_ID%TYPE
3545: )
3546: IS
3547: CURSOR tax_cat_id IS
3548: SELECT JAI_CMN_TAX_CTGS_ALL_S.nextval val_id
3549: FROM dual;
3550:
3551: CURSOR tax_cat is SELECT 'X' X
3552: FROM JAI_CMN_TAX_CTGS_ALL

Line 3552: FROM JAI_CMN_TAX_CTGS_ALL

3548: SELECT JAI_CMN_TAX_CTGS_ALL_S.nextval val_id
3549: FROM dual;
3550:
3551: CURSOR tax_cat is SELECT 'X' X
3552: FROM JAI_CMN_TAX_CTGS_ALL
3553: WHERE tax_category_name = p_tax_category_name
3554: AND org_id = to_number(p_org_id);
3555:
3556: ln_val_id NUMBER;

Line 3574: INSERT INTO JAI_CMN_TAX_CTGS_ALL(

3570: ln_val_id := reco.val_id;
3571: END LOOP;
3572:
3573: --create tax category header line
3574: INSERT INTO JAI_CMN_TAX_CTGS_ALL(
3575: TAX_CATEGORY_ID
3576: ,TAX_CATEGORY_NAME
3577: ,TAX_CATEGORY_DESC
3578: ,ITEM_CLASS_CD

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

3665: --
3666: -- CHANGE HISTORY:
3667: -- 24-OCT-2012 Chong created
3668: --==========================================================================
3669: PROCEDURE auto_create_dtc_category(p_tax_category_name IN JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_NAME%TYPE
3670: ,p_tax_category_desc IN JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_DESC%TYPE
3671: ,p_item_class_cd IN JAI_CMN_TAX_CTGS_ALL.ITEM_CLASS_CD%TYPE
3672: ,p_org_id IN JAI_CMN_TAX_CTGS_ALL.ORG_ID%TYPE
3673: ,p_object_version_number IN JAI_CMN_TAX_CTGS_ALL.OBJECT_VERSION_NUMBER%TYPE

Line 3670: ,p_tax_category_desc IN JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_DESC%TYPE

3666: -- CHANGE HISTORY:
3667: -- 24-OCT-2012 Chong created
3668: --==========================================================================
3669: PROCEDURE auto_create_dtc_category(p_tax_category_name IN JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_NAME%TYPE
3670: ,p_tax_category_desc IN JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_DESC%TYPE
3671: ,p_item_class_cd IN JAI_CMN_TAX_CTGS_ALL.ITEM_CLASS_CD%TYPE
3672: ,p_org_id IN JAI_CMN_TAX_CTGS_ALL.ORG_ID%TYPE
3673: ,p_object_version_number IN JAI_CMN_TAX_CTGS_ALL.OBJECT_VERSION_NUMBER%TYPE
3674: ,p_tax_id IN JAI_CMN_TAX_CTG_LINES.TAX_ID%TYPE

Line 3671: ,p_item_class_cd IN JAI_CMN_TAX_CTGS_ALL.ITEM_CLASS_CD%TYPE

3667: -- 24-OCT-2012 Chong created
3668: --==========================================================================
3669: PROCEDURE auto_create_dtc_category(p_tax_category_name IN JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_NAME%TYPE
3670: ,p_tax_category_desc IN JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_DESC%TYPE
3671: ,p_item_class_cd IN JAI_CMN_TAX_CTGS_ALL.ITEM_CLASS_CD%TYPE
3672: ,p_org_id IN JAI_CMN_TAX_CTGS_ALL.ORG_ID%TYPE
3673: ,p_object_version_number IN JAI_CMN_TAX_CTGS_ALL.OBJECT_VERSION_NUMBER%TYPE
3674: ,p_tax_id IN JAI_CMN_TAX_CTG_LINES.TAX_ID%TYPE
3675: )

Line 3672: ,p_org_id IN JAI_CMN_TAX_CTGS_ALL.ORG_ID%TYPE

3668: --==========================================================================
3669: PROCEDURE auto_create_dtc_category(p_tax_category_name IN JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_NAME%TYPE
3670: ,p_tax_category_desc IN JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_DESC%TYPE
3671: ,p_item_class_cd IN JAI_CMN_TAX_CTGS_ALL.ITEM_CLASS_CD%TYPE
3672: ,p_org_id IN JAI_CMN_TAX_CTGS_ALL.ORG_ID%TYPE
3673: ,p_object_version_number IN JAI_CMN_TAX_CTGS_ALL.OBJECT_VERSION_NUMBER%TYPE
3674: ,p_tax_id IN JAI_CMN_TAX_CTG_LINES.TAX_ID%TYPE
3675: )
3676: IS

Line 3673: ,p_object_version_number IN JAI_CMN_TAX_CTGS_ALL.OBJECT_VERSION_NUMBER%TYPE

3669: PROCEDURE auto_create_dtc_category(p_tax_category_name IN JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_NAME%TYPE
3670: ,p_tax_category_desc IN JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_DESC%TYPE
3671: ,p_item_class_cd IN JAI_CMN_TAX_CTGS_ALL.ITEM_CLASS_CD%TYPE
3672: ,p_org_id IN JAI_CMN_TAX_CTGS_ALL.ORG_ID%TYPE
3673: ,p_object_version_number IN JAI_CMN_TAX_CTGS_ALL.OBJECT_VERSION_NUMBER%TYPE
3674: ,p_tax_id IN JAI_CMN_TAX_CTG_LINES.TAX_ID%TYPE
3675: )
3676: IS
3677:

Line 3680: FROM JAI_CMN_TAX_CTGS_ALL

3676: IS
3677:
3678: CURSOR tax_cat is
3679: SELECT 'X' X
3680: FROM JAI_CMN_TAX_CTGS_ALL
3681: WHERE tax_category_name = p_tax_category_name
3682: AND org_id = to_number(p_org_id);
3683:
3684: CURSOR get_tax_code_info is

Line 3734: SELECT JAI_CMN_TAX_CTGS_ALL_S.nextval

3730: END IF;
3731: END LOOP;
3732:
3733: --get category id from sequence
3734: SELECT JAI_CMN_TAX_CTGS_ALL_S.nextval
3735: INTO ln_val_id
3736: FROM dual;
3737:
3738: --create tax category header line

Line 3739: INSERT INTO JAI_CMN_TAX_CTGS_ALL(

3735: INTO ln_val_id
3736: FROM dual;
3737:
3738: --create tax category header line
3739: INSERT INTO JAI_CMN_TAX_CTGS_ALL(
3740: TAX_CATEGORY_ID
3741: ,TAX_CATEGORY_NAME
3742: ,TAX_CATEGORY_DESC
3743: ,ITEM_CLASS_CD