APPS.IEM_EMAIL_PROC_PVT dependencies on IEM_PARSER_DTLS

Line 6026: from iem_parser_dtls

6022: -- rather than hard coding them;where we can define which processing group each column name belongs to
6023: Cursor c_customer_attributes (l_parser_id IN NUMBER)
6024: IS
6025: Select parser_id, start_tag, end_tag, column_name, rank
6026: from iem_parser_dtls
6027: where parser_id = l_parser_id
6028: and UPPER(column_name) IN ('ACCOUNT_NUMBER','CUSTOMER_NUMBER','CUSTOMER_NAME',
6029: 'CUSTOMER_PHONE','CUSTOMER_EMAIL','INSTANCE_NUMBER',
6030: 'INSTANCE_SERIAL_NUMBER','INCIDENT_SITE_NUMBER','CONTACT_NUMBER',

Line 6038: from iem_parser_dtls

6034: --Note: serial number is not being implemented
6035: Cursor c_other_attributes (l_parser_id IN NUMBER)
6036: IS
6037: Select parser_id, start_tag, end_tag, column_name, rank
6038: from iem_parser_dtls
6039: where parser_id = l_parser_id
6040: and UPPER(column_name) IN ('ADDRESSEE', 'EXTERNAL_REFERENCE', 'INCIDENT_ADDRESS1', 'INCIDENT_ADDRESS2',
6041: 'INCIDENT_ADDRESS3', 'INCIDENT_ADDRESS4', 'INCIDENT_CITY', 'INCIDENT_COUNTRY',
6042: 'INCIDENT_COUNTY', 'INCIDENT_POSTAL_CODE', 'INCIDENT_PROVINCE', 'INCIDENT_STATE',

Line 6149: from iem_parser_dtls

6145: --if account type is of type I and the contact information has been passed in the email
6146: --then we should pick up the contact information from the email content otherwise we should
6147: --use the default
6148: FOR contact_rec in (Select start_tag, end_tag, column_name, rank
6149: from iem_parser_dtls
6150: where parser_id = p_parser_id
6151: and UPPER(column_name) IN ('CONTACT_PHONE','CONTACT_EMAIL')
6152: order by rank asc)
6153: LOOP

Line 8334: from iem_parser_dtls

8330: iem_logger(l_logmessage);
8331: --dbms_output.put_line(l_logmessage);
8332:
8333: FOR contact_rec in (Select column_name, rank
8334: from iem_parser_dtls
8335: where parser_id = p_parser_id
8336: and UPPER(column_name) IN ('CONTACT_PHONE','CONTACT_EMAIL')
8337: order by rank asc)
8338: LOOP

Line 8565: from iem_parser_dtls

8561: --dbms_output.put_line(l_logmessage);
8562: IF g_contact_party_id IS NULL THEN
8563:
8564: FOR contact_rec in (Select column_name, rank
8565: from iem_parser_dtls
8566: where parser_id = p_parser_id
8567: and UPPER(column_name) IN ('CONTACT_PHONE','CONTACT_EMAIL')
8568: order by rank asc)
8569: LOOP