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.IMC_CSV_LOAD dependencies on HZ_IMP_CONTACTPTS_INT

Line 1006: /* Bug 5371056 : insert one row to hz_imp_contactpts_int for

1002:
1003: if(CONTACT_POINTS_FLAG ='Y') then
1004: /* Bug 3854824: If contact_point_type is not passed, based on the
1005: contact point passed, set the contact point type */
1006: /* Bug 5371056 : insert one row to hz_imp_contactpts_int for
1007: | each contact point */
1008: if (PHONE_NUMBER is not null OR RAW_PHONE_NUMBER is not null) then
1009: CONTACT_POINT_TYPE := 'PHONE';
1010: if (PHONE_LINE_TYPE is null) then

Line 1017: insert into HZ_IMP_CONTACTPTS_INT(

1013: open get_next_ref_id;
1014: fetch get_next_ref_id into CP_ORIG_SYSTEM_REFERENCE;
1015: close get_next_ref_id;
1016:
1017: insert into HZ_IMP_CONTACTPTS_INT(
1018: batch_id,CP_ORIG_SYSTEM,CP_ORIG_SYSTEM_REFERENCE,PARTY_ORIG_SYSTEM,PARTY_ORIG_SYSTEM_REFERENCE,CONTACT_POINT_TYPE,EMAIL_FORMAT,EMAIL_ADDRESS,PHONE_AREA_CODE,PHONE_COUNTRY_CODE,PHONE_NUMBER,PHONE_EXTENSION,
1019: PHONE_LINE_TYPE,TELEX_NUMBER,WEB_TYPE,URL,RAW_PHONE_NUMBER,CONTACT_POINT_PURPOSE,CREATION_DATE,CREATED_BY,
1020: LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN)
1021: values(batchId,'CSV',CP_ORIG_SYSTEM_REFERENCE,'CSV',PARTY_ORIG_SYSTEM_REFERENCE,CONTACT_POINT_TYPE,EMAIL_FORMAT,EMAIL_ADDRESS,

Line 1032: insert into HZ_IMP_CONTACTPTS_INT(

1028: open get_next_ref_id;
1029: fetch get_next_ref_id into CP_ORIG_SYSTEM_REFERENCE;
1030: close get_next_ref_id;
1031:
1032: insert into HZ_IMP_CONTACTPTS_INT(
1033: batch_id,CP_ORIG_SYSTEM,CP_ORIG_SYSTEM_REFERENCE,PARTY_ORIG_SYSTEM,PARTY_ORIG_SYSTEM_REFERENCE,CONTACT_POINT_TYPE,EMAIL_FORMAT,EMAIL_ADDRESS,PHONE_AREA_CODE,PHONE_COUNTRY_CODE,PHONE_NUMBER,PHONE_EXTENSION,
1034: PHONE_LINE_TYPE,TELEX_NUMBER,WEB_TYPE,URL,RAW_PHONE_NUMBER,CONTACT_POINT_PURPOSE,CREATION_DATE,CREATED_BY,
1035: LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN)
1036: values(batchId,'CSV',CP_ORIG_SYSTEM_REFERENCE,'CSV',PARTY_ORIG_SYSTEM_REFERENCE,CONTACT_POINT_TYPE,EMAIL_FORMAT,EMAIL_ADDRESS,

Line 1047: insert into HZ_IMP_CONTACTPTS_INT(

1043: open get_next_ref_id;
1044: fetch get_next_ref_id into CP_ORIG_SYSTEM_REFERENCE;
1045: close get_next_ref_id;
1046:
1047: insert into HZ_IMP_CONTACTPTS_INT(
1048: batch_id,CP_ORIG_SYSTEM,CP_ORIG_SYSTEM_REFERENCE,PARTY_ORIG_SYSTEM,PARTY_ORIG_SYSTEM_REFERENCE,CONTACT_POINT_TYPE,EMAIL_FORMAT,EMAIL_ADDRESS,PHONE_AREA_CODE,PHONE_COUNTRY_CODE,PHONE_NUMBER,PHONE_EXTENSION,
1049: PHONE_LINE_TYPE,TELEX_NUMBER,WEB_TYPE,URL,RAW_PHONE_NUMBER,CONTACT_POINT_PURPOSE,CREATION_DATE,CREATED_BY,
1050: LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN)
1051: values(batchId,'CSV',CP_ORIG_SYSTEM_REFERENCE,'CSV',PARTY_ORIG_SYSTEM_REFERENCE,CONTACT_POINT_TYPE,EMAIL_FORMAT,EMAIL_ADDRESS,

Line 1062: insert into HZ_IMP_CONTACTPTS_INT(

1058: open get_next_ref_id;
1059: fetch get_next_ref_id into CP_ORIG_SYSTEM_REFERENCE;
1060: close get_next_ref_id;
1061:
1062: insert into HZ_IMP_CONTACTPTS_INT(
1063: batch_id,CP_ORIG_SYSTEM,CP_ORIG_SYSTEM_REFERENCE,PARTY_ORIG_SYSTEM,PARTY_ORIG_SYSTEM_REFERENCE,CONTACT_POINT_TYPE,EMAIL_FORMAT,EMAIL_ADDRESS,PHONE_AREA_CODE,PHONE_COUNTRY_CODE,PHONE_NUMBER,PHONE_EXTENSION,
1064: PHONE_LINE_TYPE,TELEX_NUMBER,WEB_TYPE,URL,RAW_PHONE_NUMBER,CONTACT_POINT_PURPOSE,CREATION_DATE,CREATED_BY,
1065: LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN)
1066: values(batchId,'CSV',CP_ORIG_SYSTEM_REFERENCE,'CSV',PARTY_ORIG_SYSTEM_REFERENCE,CONTACT_POINT_TYPE,EMAIL_FORMAT,EMAIL_ADDRESS,