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.

APPS.IMC_CSV_LOAD dependencies on HZ_IMP_PARTIES_INT

Line 12: PARTY_ORIG_SYSTEM HZ_IMP_PARTIES_INT.PARTY_ORIG_SYSTEM%TYPE;

8: load_id imc_csv_interface_fields.LOAD_ID%TYPE;
9: BATCH_ID imc_csv_interface_fields.BATCH_ID%TYPE;
10: PARTY_REC_ID imc_csv_interface_fields.PARTY_REC_ID%TYPE;
11: REC_STATUS imc_csv_interface_fields.REC_STATUS%TYPE;
12: PARTY_ORIG_SYSTEM HZ_IMP_PARTIES_INT.PARTY_ORIG_SYSTEM%TYPE;
13: PARTY_ORIG_SYSTEM_REFERENCE HZ_IMP_PARTIES_INT.PARTY_ORIG_SYSTEM_REFERENCE%TYPE;
14: PARTY_TYPE imc_csv_interface_fields.PARTY_TYPE%TYPE;
15: ORGANIZATION_NAME imc_csv_interface_fields.ORGANIZATION_NAME%TYPE;
16: CEO_NAME imc_csv_interface_fields.CEO_NAME%TYPE;

Line 13: PARTY_ORIG_SYSTEM_REFERENCE HZ_IMP_PARTIES_INT.PARTY_ORIG_SYSTEM_REFERENCE%TYPE;

9: BATCH_ID imc_csv_interface_fields.BATCH_ID%TYPE;
10: PARTY_REC_ID imc_csv_interface_fields.PARTY_REC_ID%TYPE;
11: REC_STATUS imc_csv_interface_fields.REC_STATUS%TYPE;
12: PARTY_ORIG_SYSTEM HZ_IMP_PARTIES_INT.PARTY_ORIG_SYSTEM%TYPE;
13: PARTY_ORIG_SYSTEM_REFERENCE HZ_IMP_PARTIES_INT.PARTY_ORIG_SYSTEM_REFERENCE%TYPE;
14: PARTY_TYPE imc_csv_interface_fields.PARTY_TYPE%TYPE;
15: ORGANIZATION_NAME imc_csv_interface_fields.ORGANIZATION_NAME%TYPE;
16: CEO_NAME imc_csv_interface_fields.CEO_NAME%TYPE;
17: CEO_TITLE imc_csv_interface_fields.CEO_TITLE%TYPE;

Line 128: birthdate HZ_IMP_PARTIES_INT.DATE_OF_BIRTH%TYPE;

124: CONTACT_POINTS_FLAG imc_csv_load_details.CONTACT_POINTS_FLAG%TYPE;
125: CLASSIFICATION_FLAG imc_csv_load_details.CLASSIFICATION_FLAG%TYPE;
126: CONTACT_FLAG VARCHAR2(10);
127:
128: birthdate HZ_IMP_PARTIES_INT.DATE_OF_BIRTH%TYPE;
129: deathdate HZ_IMP_PARTIES_INT.DATE_OF_DEATH%TYPE;
130: maritaldate HZ_IMP_PARTIES_INT.MARITAL_STATUS_EFFECTIVE_DATE%TYPE;
131: --Data Type validations for CONTROL_YR,EMPLOYEES_TOTAL,INCORP_YEAR,TOTAL_PAYMENTS,YEAR_ESTABLISHED
132: control_year HZ_IMP_PARTIES_INT.CONTROL_YR%TYPE;

Line 129: deathdate HZ_IMP_PARTIES_INT.DATE_OF_DEATH%TYPE;

125: CLASSIFICATION_FLAG imc_csv_load_details.CLASSIFICATION_FLAG%TYPE;
126: CONTACT_FLAG VARCHAR2(10);
127:
128: birthdate HZ_IMP_PARTIES_INT.DATE_OF_BIRTH%TYPE;
129: deathdate HZ_IMP_PARTIES_INT.DATE_OF_DEATH%TYPE;
130: maritaldate HZ_IMP_PARTIES_INT.MARITAL_STATUS_EFFECTIVE_DATE%TYPE;
131: --Data Type validations for CONTROL_YR,EMPLOYEES_TOTAL,INCORP_YEAR,TOTAL_PAYMENTS,YEAR_ESTABLISHED
132: control_year HZ_IMP_PARTIES_INT.CONTROL_YR%TYPE;
133: emp_total HZ_IMP_PARTIES_INT.EMPLOYEES_TOTAL%TYPE;

Line 130: maritaldate HZ_IMP_PARTIES_INT.MARITAL_STATUS_EFFECTIVE_DATE%TYPE;

126: CONTACT_FLAG VARCHAR2(10);
127:
128: birthdate HZ_IMP_PARTIES_INT.DATE_OF_BIRTH%TYPE;
129: deathdate HZ_IMP_PARTIES_INT.DATE_OF_DEATH%TYPE;
130: maritaldate HZ_IMP_PARTIES_INT.MARITAL_STATUS_EFFECTIVE_DATE%TYPE;
131: --Data Type validations for CONTROL_YR,EMPLOYEES_TOTAL,INCORP_YEAR,TOTAL_PAYMENTS,YEAR_ESTABLISHED
132: control_year HZ_IMP_PARTIES_INT.CONTROL_YR%TYPE;
133: emp_total HZ_IMP_PARTIES_INT.EMPLOYEES_TOTAL%TYPE;
134: incorporation_year HZ_IMP_PARTIES_INT.INCORP_YEAR%TYPE;

Line 132: control_year HZ_IMP_PARTIES_INT.CONTROL_YR%TYPE;

128: birthdate HZ_IMP_PARTIES_INT.DATE_OF_BIRTH%TYPE;
129: deathdate HZ_IMP_PARTIES_INT.DATE_OF_DEATH%TYPE;
130: maritaldate HZ_IMP_PARTIES_INT.MARITAL_STATUS_EFFECTIVE_DATE%TYPE;
131: --Data Type validations for CONTROL_YR,EMPLOYEES_TOTAL,INCORP_YEAR,TOTAL_PAYMENTS,YEAR_ESTABLISHED
132: control_year HZ_IMP_PARTIES_INT.CONTROL_YR%TYPE;
133: emp_total HZ_IMP_PARTIES_INT.EMPLOYEES_TOTAL%TYPE;
134: incorporation_year HZ_IMP_PARTIES_INT.INCORP_YEAR%TYPE;
135: total_pays HZ_IMP_PARTIES_INT.TOTAL_PAYMENTS%TYPE;
136: yr_established HZ_IMP_PARTIES_INT.YEAR_ESTABLISHED%TYPE;

Line 133: emp_total HZ_IMP_PARTIES_INT.EMPLOYEES_TOTAL%TYPE;

129: deathdate HZ_IMP_PARTIES_INT.DATE_OF_DEATH%TYPE;
130: maritaldate HZ_IMP_PARTIES_INT.MARITAL_STATUS_EFFECTIVE_DATE%TYPE;
131: --Data Type validations for CONTROL_YR,EMPLOYEES_TOTAL,INCORP_YEAR,TOTAL_PAYMENTS,YEAR_ESTABLISHED
132: control_year HZ_IMP_PARTIES_INT.CONTROL_YR%TYPE;
133: emp_total HZ_IMP_PARTIES_INT.EMPLOYEES_TOTAL%TYPE;
134: incorporation_year HZ_IMP_PARTIES_INT.INCORP_YEAR%TYPE;
135: total_pays HZ_IMP_PARTIES_INT.TOTAL_PAYMENTS%TYPE;
136: yr_established HZ_IMP_PARTIES_INT.YEAR_ESTABLISHED%TYPE;
137: per_income HZ_IMP_PARTIES_INT.PERSONAL_INCOME%TYPE;

Line 134: incorporation_year HZ_IMP_PARTIES_INT.INCORP_YEAR%TYPE;

130: maritaldate HZ_IMP_PARTIES_INT.MARITAL_STATUS_EFFECTIVE_DATE%TYPE;
131: --Data Type validations for CONTROL_YR,EMPLOYEES_TOTAL,INCORP_YEAR,TOTAL_PAYMENTS,YEAR_ESTABLISHED
132: control_year HZ_IMP_PARTIES_INT.CONTROL_YR%TYPE;
133: emp_total HZ_IMP_PARTIES_INT.EMPLOYEES_TOTAL%TYPE;
134: incorporation_year HZ_IMP_PARTIES_INT.INCORP_YEAR%TYPE;
135: total_pays HZ_IMP_PARTIES_INT.TOTAL_PAYMENTS%TYPE;
136: yr_established HZ_IMP_PARTIES_INT.YEAR_ESTABLISHED%TYPE;
137: per_income HZ_IMP_PARTIES_INT.PERSONAL_INCOME%TYPE;
138: house_income HZ_IMP_PARTIES_INT.HOUSEHOLD_INCOME%TYPE;

Line 135: total_pays HZ_IMP_PARTIES_INT.TOTAL_PAYMENTS%TYPE;

131: --Data Type validations for CONTROL_YR,EMPLOYEES_TOTAL,INCORP_YEAR,TOTAL_PAYMENTS,YEAR_ESTABLISHED
132: control_year HZ_IMP_PARTIES_INT.CONTROL_YR%TYPE;
133: emp_total HZ_IMP_PARTIES_INT.EMPLOYEES_TOTAL%TYPE;
134: incorporation_year HZ_IMP_PARTIES_INT.INCORP_YEAR%TYPE;
135: total_pays HZ_IMP_PARTIES_INT.TOTAL_PAYMENTS%TYPE;
136: yr_established HZ_IMP_PARTIES_INT.YEAR_ESTABLISHED%TYPE;
137: per_income HZ_IMP_PARTIES_INT.PERSONAL_INCOME%TYPE;
138: house_income HZ_IMP_PARTIES_INT.HOUSEHOLD_INCOME%TYPE;
139: house_size HZ_IMP_PARTIES_INT.HOUSEHOLD_SIZE%TYPE;

Line 136: yr_established HZ_IMP_PARTIES_INT.YEAR_ESTABLISHED%TYPE;

132: control_year HZ_IMP_PARTIES_INT.CONTROL_YR%TYPE;
133: emp_total HZ_IMP_PARTIES_INT.EMPLOYEES_TOTAL%TYPE;
134: incorporation_year HZ_IMP_PARTIES_INT.INCORP_YEAR%TYPE;
135: total_pays HZ_IMP_PARTIES_INT.TOTAL_PAYMENTS%TYPE;
136: yr_established HZ_IMP_PARTIES_INT.YEAR_ESTABLISHED%TYPE;
137: per_income HZ_IMP_PARTIES_INT.PERSONAL_INCOME%TYPE;
138: house_income HZ_IMP_PARTIES_INT.HOUSEHOLD_INCOME%TYPE;
139: house_size HZ_IMP_PARTIES_INT.HOUSEHOLD_SIZE%TYPE;
140:

Line 137: per_income HZ_IMP_PARTIES_INT.PERSONAL_INCOME%TYPE;

133: emp_total HZ_IMP_PARTIES_INT.EMPLOYEES_TOTAL%TYPE;
134: incorporation_year HZ_IMP_PARTIES_INT.INCORP_YEAR%TYPE;
135: total_pays HZ_IMP_PARTIES_INT.TOTAL_PAYMENTS%TYPE;
136: yr_established HZ_IMP_PARTIES_INT.YEAR_ESTABLISHED%TYPE;
137: per_income HZ_IMP_PARTIES_INT.PERSONAL_INCOME%TYPE;
138: house_income HZ_IMP_PARTIES_INT.HOUSEHOLD_INCOME%TYPE;
139: house_size HZ_IMP_PARTIES_INT.HOUSEHOLD_SIZE%TYPE;
140:
141: lookup_code_count VARCHAR2(50);

Line 138: house_income HZ_IMP_PARTIES_INT.HOUSEHOLD_INCOME%TYPE;

134: incorporation_year HZ_IMP_PARTIES_INT.INCORP_YEAR%TYPE;
135: total_pays HZ_IMP_PARTIES_INT.TOTAL_PAYMENTS%TYPE;
136: yr_established HZ_IMP_PARTIES_INT.YEAR_ESTABLISHED%TYPE;
137: per_income HZ_IMP_PARTIES_INT.PERSONAL_INCOME%TYPE;
138: house_income HZ_IMP_PARTIES_INT.HOUSEHOLD_INCOME%TYPE;
139: house_size HZ_IMP_PARTIES_INT.HOUSEHOLD_SIZE%TYPE;
140:
141: lookup_code_count VARCHAR2(50);
142: CNT_ORIG_SYSTEM_REFERENCE number;

Line 139: house_size HZ_IMP_PARTIES_INT.HOUSEHOLD_SIZE%TYPE;

135: total_pays HZ_IMP_PARTIES_INT.TOTAL_PAYMENTS%TYPE;
136: yr_established HZ_IMP_PARTIES_INT.YEAR_ESTABLISHED%TYPE;
137: per_income HZ_IMP_PARTIES_INT.PERSONAL_INCOME%TYPE;
138: house_income HZ_IMP_PARTIES_INT.HOUSEHOLD_INCOME%TYPE;
139: house_size HZ_IMP_PARTIES_INT.HOUSEHOLD_SIZE%TYPE;
140:
141: lookup_code_count VARCHAR2(50);
142: CNT_ORIG_SYSTEM_REFERENCE number;
143: CNTORG_ORIG_SYSTEM_REFERENCE number;

Line 881: insert into HZ_IMP_PARTIES_INT(batch_id,PARTY_ORIG_SYSTEM,PARTY_ORIG_SYSTEM_REFERENCE,PARTY_TYPE,ORGANIZATION_NAME,CEO_NAME,CEO_TITLE,PRINCIPAL_NAME,

877: --INSERT INTO INTERFACE TABLES
878: if (REC_STATUS is null) OR (REC_STATUS<>'E') then
879: if (PARTY_TYPE='ORGANIZATION') then
880: --dbms_output.put_line('inserting into HZ parties interface');
881: insert into HZ_IMP_PARTIES_INT(batch_id,PARTY_ORIG_SYSTEM,PARTY_ORIG_SYSTEM_REFERENCE,PARTY_TYPE,ORGANIZATION_NAME,CEO_NAME,CEO_TITLE,PRINCIPAL_NAME,
882: PRINCIPAL_TITLE,LEGAL_STATUS,CONTROL_YR,EMPLOYEES_TOTAL,HQ_BRANCH_IND,BRANCH_FLAG,OOB_IND,TAX_REFERENCE,
883: GSA_INDICATOR_FLAG,JGZZ_FISCAL_CODE,ANALYSIS_FY,FISCAL_YEAREND_MONTH,CURR_FY_POTENTIAL_REVENUE,
884: NEXT_FY_POTENTIAL_REVENUE,YEAR_ESTABLISHED,MISSION_STATEMENT,ORGANIZATION_TYPE,BUSINESS_SCOPE,KNOWN_AS,
885: LOCAL_BUS_IDEN_TYPE,LOCAL_BUS_IDENTIFIER,PREF_FUNCTIONAL_CURRENCY,REGISTRATION_TYPE,PARENT_SUB_IND,INCORP_YEAR,

Line 896: insert into HZ_IMP_PARTIES_INT(batch_id,PARTY_ORIG_SYSTEM,PARTY_ORIG_SYSTEM_REFERENCE,PARTY_TYPE,PERSON_PRE_NAME_ADJUNCT,PERSON_FIRST_NAME,

892: LOCAL_BUS_IDEN_TYPE,LOCAL_BUS_IDENTIFIER,PREF_FUNCTIONAL_CURRENCY,REGISTRATION_TYPE,PARENT_SUB_IND,
893: incorporation_year,PUBLIC_PRIVATE_OWNERSHIP_FLAG,total_pays,DUNS_NUMBER_C,SYSDATE,FND_GLOBAL.user_id,SYSDATE,
894: FND_GLOBAL.user_id,FND_GLOBAL.login_id);
895: elsif (PARTY_TYPE='PERSON') then
896: insert into HZ_IMP_PARTIES_INT(batch_id,PARTY_ORIG_SYSTEM,PARTY_ORIG_SYSTEM_REFERENCE,PARTY_TYPE,PERSON_PRE_NAME_ADJUNCT,PERSON_FIRST_NAME,
897: PERSON_MIDDLE_NAME,PERSON_LAST_NAME,PERSON_NAME_SUFFIX,PERSON_TITLE,PERSON_ACADEMIC_TITLE,
898: PERSON_PREVIOUS_LAST_NAME,PERSON_INITIALS,KNOWN_AS,PERSON_NAME_PHONETIC,PERSON_FIRST_NAME_PHONETIC,
899: person_MIDDLE_NAME_PHONETIC,PERSON_LAST_NAME_PHONETIC,TAX_REFERENCE,JGZZ_FISCAL_CODE,PERSON_IDEN_TYPE,
900: PERSON_IDENTIFIER,DATE_OF_BIRTH,PLACE_OF_BIRTH,DATE_OF_DEATH,GENDER,DECLARED_ETHNICITY,MARITAL_STATUS,

Line 930: insert into HZ_IMP_PARTIES_INT(batch_id,PARTY_ORIG_SYSTEM,PARTY_ORIG_SYSTEM_REFERENCE,PARTY_TYPE,ORGANIZATION_NAME,CEO_NAME,CEO_TITLE,PRINCIPAL_NAME,

926: open get_next_ref_id;
927: fetch get_next_ref_id into CNTORG_ORIG_SYSTEM_REFERENCE;
928: close get_next_ref_id;
929:
930: insert into HZ_IMP_PARTIES_INT(batch_id,PARTY_ORIG_SYSTEM,PARTY_ORIG_SYSTEM_REFERENCE,PARTY_TYPE,ORGANIZATION_NAME,CEO_NAME,CEO_TITLE,PRINCIPAL_NAME,
931: PRINCIPAL_TITLE,LEGAL_STATUS,CONTROL_YR,EMPLOYEES_TOTAL,HQ_BRANCH_IND,BRANCH_FLAG,OOB_IND,TAX_REFERENCE,
932: GSA_INDICATOR_FLAG,JGZZ_FISCAL_CODE,ANALYSIS_FY,FISCAL_YEAREND_MONTH,CURR_FY_POTENTIAL_REVENUE,
933: NEXT_FY_POTENTIAL_REVENUE,YEAR_ESTABLISHED,MISSION_STATEMENT,ORGANIZATION_TYPE,BUSINESS_SCOPE,KNOWN_AS,
934: LOCAL_BUS_IDEN_TYPE,LOCAL_BUS_IDENTIFIER,PREF_FUNCTIONAL_CURRENCY,REGISTRATION_TYPE,PARENT_SUB_IND,INCORP_YEAR,