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 IMC_CSV_LOAD

Line 1: PACKAGE BODY IMC_CSV_LOAD AS

1: PACKAGE BODY IMC_CSV_LOAD AS
2: /* $Header: IMCLOADB.pls 120.13.12010000.2 2009/07/31 06:26:24 vsegu ship $ */
3: PROCEDURE LOAD_DETAILS(loadId NUMBER, batchId NUMBER) IS
4: p_init_msg_list VARCHAR2(25) := FND_API.G_FALSE;
5: x_return_status VARCHAR2(50);

Line 122: date_format imc_csv_load_details.DATE_FORMAT%TYPE;

118: LAST_UPDATE_DATE imc_csv_interface_fields.LAST_UPDATE_DATE%TYPE;
119: LAST_UPDATED_BY imc_csv_interface_fields.LAST_UPDATED_BY%TYPE;
120: LAST_UPDATE_LOGIN imc_csv_interface_fields.LAST_UPDATE_LOGIN%TYPE;
121:
122: date_format imc_csv_load_details.DATE_FORMAT%TYPE;
123: ADDRESS_FLAG imc_csv_load_details.ADDRESS_FLAG%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);

Line 123: ADDRESS_FLAG imc_csv_load_details.ADDRESS_FLAG%TYPE;

119: LAST_UPDATED_BY imc_csv_interface_fields.LAST_UPDATED_BY%TYPE;
120: LAST_UPDATE_LOGIN imc_csv_interface_fields.LAST_UPDATE_LOGIN%TYPE;
121:
122: date_format imc_csv_load_details.DATE_FORMAT%TYPE;
123: ADDRESS_FLAG imc_csv_load_details.ADDRESS_FLAG%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:

Line 124: CONTACT_POINTS_FLAG imc_csv_load_details.CONTACT_POINTS_FLAG%TYPE;

120: LAST_UPDATE_LOGIN imc_csv_interface_fields.LAST_UPDATE_LOGIN%TYPE;
121:
122: date_format imc_csv_load_details.DATE_FORMAT%TYPE;
123: ADDRESS_FLAG imc_csv_load_details.ADDRESS_FLAG%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;

Line 125: CLASSIFICATION_FLAG imc_csv_load_details.CLASSIFICATION_FLAG%TYPE;

121:
122: date_format imc_csv_load_details.DATE_FORMAT%TYPE;
123: ADDRESS_FLAG imc_csv_load_details.ADDRESS_FLAG%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;

Line 183: from imc_csv_load_details where load_id = loadId and batch_id=batchId;

179: and (rec_status='E' OR nvl(rec_status,'NULL')='NULL');
180:
181: cursor get_load_details(loadId number, batchId number) is
182: select date_format,ADDRESS_FLAG,CONTACT_POINTS_FLAG,CLASSIFICATION_FLAG
183: from imc_csv_load_details where load_id = loadId and batch_id=batchId;
184:
185: cursor get_next_ref_id is
186: select imc_csv_orig_ref_s.NEXTVAL from dual;
187:

Line 1125: END IMC_CSV_LOAD;

1121: RAISE FND_API.G_EXC_ERROR;
1122: execute immediate 'update hz_imp_batch_summary set csv_status=''ERROR'' where load_type=''CSV'' and batch_id = '||batchId;
1123:
1124: END;
1125: END IMC_CSV_LOAD;