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.

[Home] [Help]

APPS.HZ_IMP_LOAD_WRAPPER dependencies on HZ_IMP_CONTACTPTS_INT

Line 758: FROM HZ_IMP_CONTACTPTS_SG cpt_sg,HZ_IMP_CONTACTPTS_INT cpi,

754: ';
755:
756: l_cleanup_ssm_cpt_qry VARCHAR2(4000) :=
757: ' SELECT cposr.rowid,posr.owner_table_id
758: FROM HZ_IMP_CONTACTPTS_SG cpt_sg,HZ_IMP_CONTACTPTS_INT cpi,
759: HZ_ORIG_SYS_REFERENCES posr,
760: HZ_ORIG_SYS_REFERENCES cposr
761: WHERE cpt_sg.batch_id = :CP_BATCH_ID
762: AND cpt_sg.batch_mode_flag = :CP_BATCH_MODE_FLAG

Line 778: AND err.interface_table_name = ''HZ_IMP_CONTACTPTS_INT''

774: AND NOT EXISTS
775: (SELECT 1 FROM HZ_IMP_TMP_ERRORS err
776: WHERE err.batch_id = :CP_BATCH_ID
777: AND err.request_id = :REQ_ID
778: AND err.interface_table_name = ''HZ_IMP_CONTACTPTS_INT''
779: AND err.int_row_id = cpt_sg.int_row_id)
780: ';
781:
782:

Line 1142: UPDATE HZ_IMP_CONTACTPTS_INT

1138: AND sub_orig_system_reference = l_posr(i);
1139:
1140: -- Update contact point records
1141: FORALL i in l_posr.FIRST..l_posr.LAST
1142: UPDATE HZ_IMP_CONTACTPTS_INT
1143: SET interface_status = 'D'
1144: WHERE batch_id = p_batch_id AND Nvl(party_id,l_pid(i)) = l_pid(i)
1145: AND party_orig_system = l_pos(i)
1146: AND party_orig_system_reference = l_posr(i);

Line 1313: update HZ_IMP_CONTACTPTS_INT

1309: where BATCH_ID = P_BATCH_ID
1310: and PARTY_ORIG_SYSTEM = P_ORIG_SYSTEM
1311: and INTERFACE_STATUS = 'C';
1312:
1313: update HZ_IMP_CONTACTPTS_INT
1314: set error_id = null,
1315: interface_status = null
1316: where BATCH_ID = P_BATCH_ID
1317: and PARTY_ORIG_SYSTEM = P_ORIG_SYSTEM

Line 1410: update HZ_IMP_CONTACTPTS_INT

1406: and batch_id = P_BATCH_ID
1407: and stage = 3
1408: and status = 'C');
1409:
1410: update HZ_IMP_CONTACTPTS_INT
1411: set error_id = null, interface_status = null
1412: where batch_id = P_BATCH_ID
1413: and party_orig_system = P_ORIG_SYSTEM
1414: and interface_status = 'C'

Line 3036: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',

3032: into hz_imp_errors (
3033: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
3034: token1_name, token1_value, token2_name, token2_value)
3035: values (
3036: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',
3037: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'CONTACT_POINT_TYPE',
3038: 'LOOKUP_TYPE', 'CONTACT_POINT_TYPE')
3039: when (E2_FLAG is null) then
3040: into hz_imp_errors (

Line 3044: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',

3040: into hz_imp_errors (
3041: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
3042: token1_name, token1_value, token2_name, token2_value)
3043: values (
3044: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',
3045: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'CONTACT_POINT_PURPOSE',
3046: 'LOOKUP_TYPE', 'CONTACT_POINT_PURPOSE')
3047: when (E3_FLAG is null) then
3048: into hz_imp_errors (

Line 3052: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',

3048: into hz_imp_errors (
3049: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
3050: token1_name, token1_value)
3051: values (
3052: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',
3053: 'HZ_API_MISSING_COLUMN', 'COLUMN', 'EDI_ID_NUMBER')
3054: when (E4_FLAG is null) then
3055: into hz_imp_errors (
3056: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,

Line 3059: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',

3055: into hz_imp_errors (
3056: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
3057: token1_name, token1_value)
3058: values (
3059: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',
3060: 'HZ_API_MISSING_COLUMN', 'COLUMN', 'EMAIL_ADDRESS')
3061: when (E5_FLAG is null) then
3062: into hz_imp_errors (
3063: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,

Line 3066: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',

3062: into hz_imp_errors (
3063: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
3064: token1_name, token1_value, token2_name, token2_value)
3065: values (
3066: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',
3067: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'EMAIL_FORMAT', 'LOOKUP_TYPE',
3068: 'EMAIL_FORMAT')
3069: when (E6_FLAG is null) then
3070: into hz_imp_errors (

Line 3075: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',

3071: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
3072: token1_name, token1_value, token2_name, token2_value, token3_name,
3073: token3_value)
3074: values (
3075: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',
3076: 'HZ_API_INVALID_FK', 'FK', 'PHONE_COUNTRY_CODE', 'COLUMN',
3077: 'PHONE_COUNTRY_CODE', 'TABLE', 'HZ_PHONE_COUNTRY_CODES')
3078: when (E7_FLAG is null) then
3079: into hz_imp_errors (

Line 3083: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',

3079: into hz_imp_errors (
3080: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
3081: token1_value, token2_name, token2_value)
3082: values (
3083: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',
3084: 'HZ_API_INVALID_LOOKUP', 'PHONE_LINE_TYPE', 'LOOKUP_TYPE',
3085: 'PHONE_LINE_TYPE')
3086: when (E8_FLAG is null) then
3087: into hz_imp_errors (

Line 3090: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',

3086: when (E8_FLAG is null) then
3087: into hz_imp_errors (
3088: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
3089: values (
3090: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',
3091: 'HZ_INVALID_PHONE_PARAMETER')
3092: when (E9_FLAG is null) then
3093: into hz_imp_errors (
3094: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,

Line 3097: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',

3093: into hz_imp_errors (
3094: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
3095: token1_name, token1_value)
3096: values (
3097: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',
3098: 'HZ_API_MISSING_COLUMN', 'COLUMN', 'TELEX_NUMBER')
3099: when (E10_FLAG is null) then
3100: into hz_imp_errors (
3101: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,

Line 3105: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',

3101: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
3102: token1_name, token1_value, token2_name, token2_value, token3_name,
3103: token3_value)
3104: values (
3105: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',
3106: 'HZ_API_INVALID_FK', 'FK', 'TIMEZONE_CODE', 'COLUMN',
3107: 'TIMEZONE_CODE', 'TABLE', 'FND_TIMEZONES_B')
3108: when (E11_FLAG is null) then
3109: into hz_imp_errors (

Line 3113: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',

3109: into hz_imp_errors (
3110: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
3111: token1_name, token1_value)
3112: values (
3113: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',
3114: 'HZ_API_MISSING_COLUMN', 'COLUMN', 'URL')
3115: when (E12_FLAG is null) then
3116: into hz_imp_errors (
3117: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,

Line 3120: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',

3116: into hz_imp_errors (
3117: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
3118: token1_name, token1_value)
3119: values (
3120: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',
3121: 'HZ_API_MISSING_COLUMN', 'COLUMN', 'WEB_TYPE')
3122: when (E13_FLAG is null) then
3123: into hz_imp_errors (
3124: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,

Line 3127: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',

3123: into hz_imp_errors (
3124: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
3125: token1_name, token1_value)
3126: values (
3127: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',
3128: 'AR_RAPI_DESC_FLEX_INVALID', 'DFF_NAME', 'HZ_CONTACT_POINTS')
3129: when (E15_FLAG is null) then
3130: into hz_imp_errors (
3131: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,

Line 3134: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',

3130: into hz_imp_errors (
3131: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
3132: token1_name, token1_value)
3133: values (
3134: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',
3135: 'HZ_API_MISSING_COLUMN', 'COLUMN', 'CONTACT_POINT_TYPE')
3136: when (E16_FLAG is null) then
3137: into hz_imp_errors (
3138: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)

Line 3140: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',

3136: when (E16_FLAG is null) then
3137: into hz_imp_errors (
3138: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
3139: values (
3140: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',
3141: 'HZ_IMP_CPT_ADDR_OSR_MISMATCH')
3142: when (E17_FLAG is null) then
3143: into hz_imp_errors (
3144: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,

Line 3147: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',

3143: into hz_imp_errors (
3144: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
3145: token1_name, token1_value)
3146: values (
3147: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',
3148: 'HZ_API_NONUPDATEABLE_COLUMN', 'COLUMN', 'CONTACT_POINT_TYPE')
3149: when (E18_FLAG='P') then
3150: into hz_imp_errors (
3151: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,

Line 3154: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',

3150: into hz_imp_errors (
3151: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
3152: token1_name, token1_value)
3153: values (
3154: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',
3155: 'HZ_DSS_NO_UPDATE_PRIVILEGE', 'ENTITY_NAME', l_dss_cp_err)
3156: when (E18_FLAG='S') then
3157: into hz_imp_errors (
3158: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,

Line 3161: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',

3157: into hz_imp_errors (
3158: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
3159: token1_name, token1_value)
3160: values (
3161: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',
3162: 'HZ_DSS_NO_UPDATE_PRIVILEGE', 'ENTITY_NAME', l_dss_ps_err)
3163: when (E19_FLAG is null) then
3164: into hz_imp_errors (
3165: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,

Line 3168: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',

3164: into hz_imp_errors (
3165: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
3166: token1_name, token1_value, token2_name, token2_value)
3167: values (
3168: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',
3169: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'CONTACT_POINT_PURPOSE',
3170: 'LOOKUP_TYPE', 'CONTACT_POINT_PURPOSE_WEB')
3171: when (DUP_VAL_IDX_EXCEP_FLAG = 'A') then
3172: into hz_imp_errors (

Line 3176: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',

3172: into hz_imp_errors (
3173: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
3174: token1_name, token1_value, token2_name, token2_value)
3175: values (
3176: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',
3177: 'HZ_IMP_DUP_VAL', 'INDEX', 'HZ_CONTACT_POINTS_U1', 'ENTITY',
3178: 'HZ_CONTACT_POINTS')
3179: when (ACTION_MISMATCH_FLAG is null) then
3180: into hz_imp_errors (

Line 3183: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',

3179: when (ACTION_MISMATCH_FLAG is null) then
3180: into hz_imp_errors (
3181: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
3182: values (
3183: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',
3184: 'HZ_IMP_ACTION_MISMATCH')
3185: when (MISSING_PARENT_FLAG = 'P') then
3186: into hz_imp_errors (
3187: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)

Line 3189: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',

3185: when (MISSING_PARENT_FLAG = 'P') then
3186: into hz_imp_errors (
3187: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
3188: values (
3189: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',
3190: 'HZ_IMP_PARENT_PARTY_NOT_FOUND')
3191: when (MISSING_PARENT_FLAG = 'A') then
3192: into hz_imp_errors (
3193: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)

Line 3195: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',

3191: when (MISSING_PARENT_FLAG = 'A') then
3192: into hz_imp_errors (
3193: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
3194: values (
3195: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',
3196: 'HZ_IMP_PARENT_ADDR_NOT_FOUND')
3197: when (E20_FLAG IS NULL) then /* Bug 4079902 */
3198: into hz_imp_errors (
3199: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)

Line 3201: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',

3197: when (E20_FLAG IS NULL) then /* Bug 4079902 */
3198: into hz_imp_errors (
3199: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
3200: values (
3201: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',
3202: 'HZ_NOTALLOW_UPDATE_THIRD_PARTY')
3203: when (E21_FLAG is null) then
3204: into hz_imp_errors (
3205: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,

Line 3208: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',

3204: into hz_imp_errors (
3205: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
3206: token1_name, token1_value, token2_name, token2_value)
3207: values (
3208: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTPTS_INT',
3209: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'CREATED_BY_MODULE', 'LOOKUP_TYPE',
3210: 'HZ_CREATED_BY_MODULES')
3211: select creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, E1_FLAG, E2_FLAG,
3212: E3_FLAG, E4_FLAG, E5_FLAG, E6_FLAG, E7_FLAG, E8_FLAG, E9_FLAG,

Line 3220: and e.interface_table_name = 'HZ_IMP_CONTACTPTS_INT';

3216: ACTION_MISMATCH_FLAG, MISSING_PARENT_FLAG
3217: from hz_imp_tmp_errors e
3218: where e.batch_id = P_BATCH_ID
3219: and request_id = P_REQUEST_ID
3220: and e.interface_table_name = 'HZ_IMP_CONTACTPTS_INT';
3221:
3222: /* Update interface status of errored records to 'E' */
3223: OPEN c_err(P_BATCH_ID, P_REQUEST_ID);
3224: FETCH c_err BULK COLLECT INTO l_row_id, l_table_name, l_error_id;

Line 3242: update hz_imp_contactpts_int

3238: where rowid = l_row_id(i)
3239: and l_table_name(i) = 'HZ_IMP_ADDRESSES_INT';
3240:
3241: ForAll i in 1..l_row_id.count
3242: update hz_imp_contactpts_int
3243: set interface_status = 'E',
3244: error_id = l_error_id(i)
3245: where rowid = l_row_id(i)
3246: and l_table_name(i) = 'HZ_IMP_CONTACTPTS_INT';

Line 3246: and l_table_name(i) = 'HZ_IMP_CONTACTPTS_INT';

3242: update hz_imp_contactpts_int
3243: set interface_status = 'E',
3244: error_id = l_error_id(i)
3245: where rowid = l_row_id(i)
3246: and l_table_name(i) = 'HZ_IMP_CONTACTPTS_INT';
3247:
3248: ForAll i in 1..l_row_id.count
3249: update hz_imp_contacts_int
3250: set interface_status = 'E',

Line 3948: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTPTS_INT');

3944: fnd_stats.gather_table_stats('AR', 'HZ_IMP_PARTIES_INT');
3945: fnd_stats.gather_table_stats('AR', 'HZ_IMP_ADDRESSES_INT');
3946: fnd_stats.gather_table_stats('AR', 'HZ_IMP_ADDRESSUSES_INT');
3947: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CLASSIFICS_INT');
3948: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTPTS_INT');
3949: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTROLES_INT');
3950: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTS_INT');
3951: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CREDITRTNGS_INT');
3952: fnd_stats.gather_table_stats('AR', 'HZ_IMP_FINNUMBERS_INT');

Line 4445: select /+ index_ffs(a,hz_imp_contactpts_int_n1) parallel_index(a)/

4441: from hz_imp_addresses_int a
4442: where party_orig_system = :2
4443: and batch_id=:1
4444: union all -- Contact Points
4445: select /*+ index_ffs(a,hz_imp_contactpts_int_n1) parallel_index(a)*/
4446: party_orig_system_reference
4447: from hz_imp_contactpts_int a
4448: where party_orig_system = :2
4449: and batch_id=:1

Line 4447: from hz_imp_contactpts_int a

4443: and batch_id=:1
4444: union all -- Contact Points
4445: select /*+ index_ffs(a,hz_imp_contactpts_int_n1) parallel_index(a)*/
4446: party_orig_system_reference
4447: from hz_imp_contactpts_int a
4448: where party_orig_system = :2
4449: and batch_id=:1
4450: union all -- Credit Ratings
4451: select /*+ index_ffs(a,hz_imp_creditrtngs_int_n1) parallel_index(a)*/

Line 4542: select /+ index(a,hz_imp_contactpts_int_n1) /

4538: from hz_imp_addresses_int a
4539: where party_orig_system = :2
4540: and batch_id=:1
4541: union all -- Contact Points
4542: select /*+ index(a,hz_imp_contactpts_int_n1) */
4543: party_orig_system_reference
4544: from hz_imp_contactpts_int a
4545: where party_orig_system = :2
4546: and batch_id=:1

Line 4544: from hz_imp_contactpts_int a

4540: and batch_id=:1
4541: union all -- Contact Points
4542: select /*+ index(a,hz_imp_contactpts_int_n1) */
4543: party_orig_system_reference
4544: from hz_imp_contactpts_int a
4545: where party_orig_system = :2
4546: and batch_id=:1
4547: union all -- Credit Ratings
4548: select /*+ index(a,hz_imp_creditrtngs_int_n1) */