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 984: /* Bug 5371056 : insert one row to hz_imp_contactpts_int for

980:
981: if(CONTACT_POINTS_FLAG ='Y') then
982: /* Bug 3854824: If contact_point_type is not passed, based on the
983: contact point passed, set the contact point type */
984: /* Bug 5371056 : insert one row to hz_imp_contactpts_int for
985: | each contact point */
986: if (PHONE_NUMBER is not null OR RAW_PHONE_NUMBER is not null) then
987: CONTACT_POINT_TYPE := 'PHONE';
988: if (PHONE_LINE_TYPE is null) then

Line 995: insert into HZ_IMP_CONTACTPTS_INT(

991: open get_next_ref_id;
992: fetch get_next_ref_id into CP_ORIG_SYSTEM_REFERENCE;
993: close get_next_ref_id;
994:
995: insert into HZ_IMP_CONTACTPTS_INT(
996: 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,
997: PHONE_LINE_TYPE,TELEX_NUMBER,WEB_TYPE,URL,RAW_PHONE_NUMBER,CONTACT_POINT_PURPOSE,CREATION_DATE,CREATED_BY,
998: LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN)
999: values(batchId,'CSV',CP_ORIG_SYSTEM_REFERENCE,'CSV',PARTY_ORIG_SYSTEM_REFERENCE,CONTACT_POINT_TYPE,EMAIL_FORMAT,EMAIL_ADDRESS,

Line 1010: insert into HZ_IMP_CONTACTPTS_INT(

1006: open get_next_ref_id;
1007: fetch get_next_ref_id into CP_ORIG_SYSTEM_REFERENCE;
1008: close get_next_ref_id;
1009:
1010: insert into HZ_IMP_CONTACTPTS_INT(
1011: 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,
1012: PHONE_LINE_TYPE,TELEX_NUMBER,WEB_TYPE,URL,RAW_PHONE_NUMBER,CONTACT_POINT_PURPOSE,CREATION_DATE,CREATED_BY,
1013: LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN)
1014: values(batchId,'CSV',CP_ORIG_SYSTEM_REFERENCE,'CSV',PARTY_ORIG_SYSTEM_REFERENCE,CONTACT_POINT_TYPE,EMAIL_FORMAT,EMAIL_ADDRESS,

Line 1025: insert into HZ_IMP_CONTACTPTS_INT(

1021: open get_next_ref_id;
1022: fetch get_next_ref_id into CP_ORIG_SYSTEM_REFERENCE;
1023: close get_next_ref_id;
1024:
1025: insert into HZ_IMP_CONTACTPTS_INT(
1026: 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,
1027: PHONE_LINE_TYPE,TELEX_NUMBER,WEB_TYPE,URL,RAW_PHONE_NUMBER,CONTACT_POINT_PURPOSE,CREATION_DATE,CREATED_BY,
1028: LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN)
1029: values(batchId,'CSV',CP_ORIG_SYSTEM_REFERENCE,'CSV',PARTY_ORIG_SYSTEM_REFERENCE,CONTACT_POINT_TYPE,EMAIL_FORMAT,EMAIL_ADDRESS,

Line 1040: insert into HZ_IMP_CONTACTPTS_INT(

1036: open get_next_ref_id;
1037: fetch get_next_ref_id into CP_ORIG_SYSTEM_REFERENCE;
1038: close get_next_ref_id;
1039:
1040: insert into HZ_IMP_CONTACTPTS_INT(
1041: 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,
1042: PHONE_LINE_TYPE,TELEX_NUMBER,WEB_TYPE,URL,RAW_PHONE_NUMBER,CONTACT_POINT_PURPOSE,CREATION_DATE,CREATED_BY,
1043: LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN)
1044: values(batchId,'CSV',CP_ORIG_SYSTEM_REFERENCE,'CSV',PARTY_ORIG_SYSTEM_REFERENCE,CONTACT_POINT_TYPE,EMAIL_FORMAT,EMAIL_ADDRESS,