APPS.ZX_PTP_MIGRATE_PKG dependencies on HZ_CODE_ASSIGNMENTS

Line 2671: HZ_CODE_ASSIGNMENTS

2667: /*
2668: ---Migrate the association of Supplier Type to a Supplier.
2669: ---In PTP Extract
2670: INSERT INTO
2671: HZ_CODE_ASSIGNMENTS
2672: (CODE_ASSIGNMENT_ID,
2673: OWNER_TABLE_NAME,
2674: OWNER_TABLE_ID,
2675: CLASS_CATEGORY,

Line 2702: HZ_CODE_ASSIGNMENTS_S.nextval,

2698: PROGRAM_APPLICATION_ID,
2699: PROGRAM_ID)
2700:
2701: Select
2702: HZ_CODE_ASSIGNMENTS_S.nextval,
2703: 'ZX_PARTY_TAX_PROFILE',
2704: PTP.PARTY_TAX_PROFILE_ID party_tax_profile_id,
2705: 'VENDOR TYPE',
2706: POV.VENDOR_TYPE_LOOKUP_CODE fiscal_classification_code,

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

2774: p_fiscal_class_type_code IN VARCHAR2,
2775: p_fiscal_classification_code IN VARCHAR2 ,
2776: p_dml_type IN VARCHAR2)
2777: IS
2778: l_table_owner HZ_CODE_ASSIGNMENTS.OWNER_TABLE_NAME%TYPE := 'HZ_PARTIES';
2779:
2780: BEGIN
2781:
2782:

Line 2795: HZ_CODE_ASSIGNMENTS

2791: IF p_dml_type= 'I' THEN
2792: BEGIN
2793:
2794: INSERT INTO
2795: HZ_CODE_ASSIGNMENTS
2796: (CODE_ASSIGNMENT_ID,
2797: OWNER_TABLE_NAME,
2798: OWNER_TABLE_ID,
2799: CLASS_CATEGORY,

Line 2823: (HZ_CODE_ASSIGNMENTS_S.nextval,

2819: OWNER_TABLE_KEY_3,
2820: OWNER_TABLE_KEY_4,
2821: OWNER_TABLE_KEY_5)
2822: values
2823: (HZ_CODE_ASSIGNMENTS_S.nextval,
2824: l_table_owner,
2825: p_party_tax_profile_id,
2826: p_fiscal_class_type_code,
2827: p_fiscal_classification_code,

Line 2854: HZ_CODE_ASSIGNMENTS for Party ID ' ||

2850:
2851: EXCEPTION
2852: WHEN OTHERS THEN
2853: arp_util_tax.debug('Error while Inserting data into
2854: HZ_CODE_ASSIGNMENTS for Party ID ' ||
2855: p_party_tax_profile_id );
2856: arp_util_tax.debug('Error Code: '||SQLCODE|| '. Error Message '|| SQLERRM);
2857:
2858: END ;

Line 2877: MERGE INTO HZ_CODE_ASSIGNMENTS pfa

2873: BEGIN
2874:
2875:
2876:
2877: MERGE INTO HZ_CODE_ASSIGNMENTS pfa
2878: USING (SELECT
2879: p_party_tax_profile_id party_Tax_profile_id ,
2880: p_fiscal_class_type_code fiscal_class_type_code,
2881: p_fiscal_classification_code fiscal_classification_code

Line 2934: HZ_CODE_ASSIGNMENTS_S.nextval,

2930: OWNER_TABLE_KEY_5
2931: )
2932: values
2933: (
2934: HZ_CODE_ASSIGNMENTS_S.nextval,
2935: l_table_owner,
2936: p_party_tax_profile_id,
2937: p_fiscal_class_type_code,
2938: p_fiscal_classification_code,

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

2961:
2962: EXCEPTION
2963: WHEN OTHERS THEN
2964: arp_util_tax.debug('Error while merging data into
2965: HZ_CODE_ASSIGNMENTS for Party ID ' || p_party_tax_profile_id );
2966: arp_util_tax.debug('Error Code: '||SQLCODE||'. Error Message '|| SQLERRM);
2967: END;
2968:
2969:

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

2969:
2970: ELSE
2971:
2972:
2973: arp_util_tax.debug('Updating the data in HZ_CODE_ASSIGNMENTS ');
2974:
2975:
2976: UPDATE HZ_CODE_ASSIGNMENTS
2977: SET

Line 2976: UPDATE HZ_CODE_ASSIGNMENTS

2972:
2973: arp_util_tax.debug('Updating the data in HZ_CODE_ASSIGNMENTS ');
2974:
2975:
2976: UPDATE HZ_CODE_ASSIGNMENTS
2977: SET
2978: OWNER_TABLE_NAME = l_table_owner,
2979: OWNER_TABLE_ID = P_PARTY_TAX_PROFILE_ID,
2980: CLASS_CATEGORY = P_fiscal_class_type_code,