APPS.HZ_IMP_LOAD_ORG_CONTACT_PKG dependencies on HZ_ORG_CONTACTS

Line 158: 'HZ_ORG_CONTACTS',

154: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE20', l_attribute20(i));
155:
156: IF (NOT FND_FLEX_DESCVAL.validate_desccols(
157: 'AR',
158: 'HZ_ORG_CONTACTS',
159: 'V',
160: p_validation_date)) THEN
161: l_flex_val_errors(i) := 1;
162: END IF;

Line 188: /* Validate desc flexfield HZ_ORG_CONTACTS. Used only when inserting

184: *
185: * 18-Sep-08 Idris Ali o Created
186:
187: ************************************************/
188: /* Validate desc flexfield HZ_ORG_CONTACTS. Used only when inserting
189: new Contacts because need to have a function to be called in MTI.
190: Returns Y if flexfield is valid. Returns null if invalid. */
191: FUNCTION validate_desc_flexfield_f(
192: p_attr_category IN VARCHAR2,

Line 242: 'HZ_ORG_CONTACTS',

238: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE20', p_attr20);
239:
240: IF (FND_FLEX_DESCVAL.validate_desccols(
241: 'AR',
242: 'HZ_ORG_CONTACTS',
243: 'V',
244: p_validation_date)) THEN
245: return 'Y';
246: ELSE

Line 816: into hz_org_contacts (

812: relationship_type,
813: 1, -- object_version_number,
814: created_by_module,
815: decode(direction_code, ''P'', ''C'', ''C'', ''P'', ''N''))
816: into hz_org_contacts (
817: application_id,
818: created_by,
819: creation_date,
820: last_updated_by,

Line 874: contact_id, --hz_org_contacts_s.nextval,

870: :program_application_id,
871: :program_id,
872: :l_sysdate,
873: :request_id,
874: contact_id, --hz_org_contacts_s.nextval,
875: hz_relationships_s.nextval,
876: nvl(contact_number, hz_contact_numbers_s.nextval),
877: department_code,
878: department,

Line 941: ''HZ_ORG_CONTACTS'',

937: :last_update_login,
938: hz_orig_system_ref_s.nextval,
939: contact_orig_system,
940: contact_orig_system_reference,
941: ''HZ_ORG_CONTACTS'',
942: contact_id, ''A'',
943: hz_parties_s.nextval,
944: :l_sysdate,
945: created_by_module,

Line 1561: HZ_ORG_CONTACTS oc,

1557: */
1558: FROM HZ_IMP_CONTACTS_INT ci,
1559: HZ_IMP_CONTACTS_SG cs,
1560: HZ_RELATIONSHIPS r,
1561: HZ_ORG_CONTACTS oc,
1562: AR_LOOKUPS dept_l,
1563: AR_LOOKUPS title_l,
1564: AR_LOOKUPS decision_l,
1565: AR_LOOKUPS job_title_code_l,

Line 1781: /* Update HZ_ORG_CONTACTS */

1777: report_errors(P_DML_RECORD, 'U', l_dml_exception);
1778:
1779:
1780: /*************************************************/
1781: /* Update HZ_ORG_CONTACTS */
1782: /*************************************************/
1783:
1784: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'update hz_org_contacts ');
1785:

Line 1784: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'update hz_org_contacts ');

1780: /*************************************************/
1781: /* Update HZ_ORG_CONTACTS */
1782: /*************************************************/
1783:
1784: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'update hz_org_contacts ');
1785:
1786: BEGIN
1787: ForAll j in 1..l_org_contact_id.count
1788: update hz_org_contacts set

Line 1788: update hz_org_contacts set

1784: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'update hz_org_contacts ');
1785:
1786: BEGIN
1787: ForAll j in 1..l_org_contact_id.count
1788: update hz_org_contacts set
1789: CONTACT_NUMBER =
1790: DECODE(l_contact_number(j),
1791: NULL, CONTACT_NUMBER,
1792: P_DML_RECORD.GMISS_CHAR, NULL,

Line 1966: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Other exceptions when updating hz_org_contacts');

1962: and l_num_row_processed(j) = 1;
1963:
1964: EXCEPTION
1965: WHEN OTHERS THEN
1966: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Other exceptions when updating hz_org_contacts');
1967: ROLLBACK to process_update_contacts_pvt;
1968:
1969: populate_error_table(P_DML_RECORD, 'N', SQLERRM);
1970: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;