APPS.ZX_PTP_MIGRATE_PKG dependencies on HZ_CODE_ASSIGNMENTS

Line 2791: HZ_CODE_ASSIGNMENTS

2787: /*
2788: ---Migrate the association of Supplier Type to a Supplier.
2789: ---In PTP Extract
2790: INSERT INTO
2791: HZ_CODE_ASSIGNMENTS
2792: (CODE_ASSIGNMENT_ID,
2793: OWNER_TABLE_NAME,
2794: OWNER_TABLE_ID,
2795: CLASS_CATEGORY,

Line 2822: HZ_CODE_ASSIGNMENTS_S.nextval,

2818: PROGRAM_APPLICATION_ID,
2819: PROGRAM_ID)
2820:
2821: Select
2822: HZ_CODE_ASSIGNMENTS_S.nextval,
2823: 'ZX_PARTY_TAX_PROFILE',
2824: PTP.PARTY_TAX_PROFILE_ID party_tax_profile_id,
2825: 'VENDOR TYPE',
2826: POV.VENDOR_TYPE_LOOKUP_CODE fiscal_classification_code,

Line 2898: l_table_owner HZ_CODE_ASSIGNMENTS.OWNER_TABLE_NAME%TYPE := 'HZ_PARTIES';

2894: p_fiscal_class_type_code IN VARCHAR2,
2895: p_fiscal_classification_code IN VARCHAR2 ,
2896: p_dml_type IN VARCHAR2)
2897: IS
2898: l_table_owner HZ_CODE_ASSIGNMENTS.OWNER_TABLE_NAME%TYPE := 'HZ_PARTIES';
2899:
2900: BEGIN
2901:
2902:

Line 2915: HZ_CODE_ASSIGNMENTS

2911: IF p_dml_type= 'I' THEN
2912: BEGIN
2913:
2914: INSERT INTO
2915: HZ_CODE_ASSIGNMENTS
2916: (CODE_ASSIGNMENT_ID,
2917: OWNER_TABLE_NAME,
2918: OWNER_TABLE_ID,
2919: CLASS_CATEGORY,

Line 2943: (HZ_CODE_ASSIGNMENTS_S.nextval,

2939: OWNER_TABLE_KEY_3,
2940: OWNER_TABLE_KEY_4,
2941: OWNER_TABLE_KEY_5)
2942: values
2943: (HZ_CODE_ASSIGNMENTS_S.nextval,
2944: l_table_owner,
2945: p_party_tax_profile_id,
2946: p_fiscal_class_type_code,
2947: p_fiscal_classification_code,

Line 2974: HZ_CODE_ASSIGNMENTS for Party ID ' ||

2970:
2971: EXCEPTION
2972: WHEN OTHERS THEN
2973: arp_util_tax.debug('Error while Inserting data into
2974: HZ_CODE_ASSIGNMENTS for Party ID ' ||
2975: p_party_tax_profile_id );
2976: arp_util_tax.debug('Error Code: '||SQLCODE|| '. Error Message '|| SQLERRM);
2977:
2978: END ;

Line 2997: MERGE INTO HZ_CODE_ASSIGNMENTS pfa

2993: BEGIN
2994:
2995:
2996:
2997: MERGE INTO HZ_CODE_ASSIGNMENTS pfa
2998: USING (SELECT
2999: p_party_tax_profile_id party_Tax_profile_id ,
3000: p_fiscal_class_type_code fiscal_class_type_code,
3001: p_fiscal_classification_code fiscal_classification_code

Line 3054: HZ_CODE_ASSIGNMENTS_S.nextval,

3050: OWNER_TABLE_KEY_5
3051: )
3052: values
3053: (
3054: HZ_CODE_ASSIGNMENTS_S.nextval,
3055: l_table_owner,
3056: p_party_tax_profile_id,
3057: p_fiscal_class_type_code,
3058: p_fiscal_classification_code,

Line 3085: HZ_CODE_ASSIGNMENTS for Party ID ' || p_party_tax_profile_id );

3081:
3082: EXCEPTION
3083: WHEN OTHERS THEN
3084: arp_util_tax.debug('Error while merging data into
3085: HZ_CODE_ASSIGNMENTS for Party ID ' || p_party_tax_profile_id );
3086: arp_util_tax.debug('Error Code: '||SQLCODE||'. Error Message '|| SQLERRM);
3087: END;
3088:
3089:

Line 3093: arp_util_tax.debug('Updating the data in HZ_CODE_ASSIGNMENTS ');

3089:
3090: ELSE
3091:
3092:
3093: arp_util_tax.debug('Updating the data in HZ_CODE_ASSIGNMENTS ');
3094:
3095:
3096: UPDATE HZ_CODE_ASSIGNMENTS
3097: SET

Line 3096: UPDATE HZ_CODE_ASSIGNMENTS

3092:
3093: arp_util_tax.debug('Updating the data in HZ_CODE_ASSIGNMENTS ');
3094:
3095:
3096: UPDATE HZ_CODE_ASSIGNMENTS
3097: SET
3098: OWNER_TABLE_NAME = l_table_owner,
3099: OWNER_TABLE_ID = P_PARTY_TAX_PROFILE_ID,
3100: CLASS_CATEGORY = P_fiscal_class_type_code,