DBA Data[Home] [Help]

APPS.IGS_PE_CONTACT_DTLS_PKG dependencies on IGS_PE_CONTACT_DTLS_S

Line 512: SELECT igs_pe_contact_dtls_s.nextval INTO x_contact_point_id

508: igs_ge_msg_stack.add;
509: app_exception.raise_exception;
510: END IF;
511:
512: SELECT igs_pe_contact_dtls_s.nextval INTO x_contact_point_id
513: FROM dual;
514:
515: before_dml(
516: p_action => 'INSERT',

Line 1027: UPDATE igs_pe_contact_dtls SET

1023:
1024: IF (x_mode = 'S') THEN
1025: igs_sc_gen_001.set_ctx('R');
1026: END IF;
1027: UPDATE igs_pe_contact_dtls SET
1028: phone_line_type = new_references.phone_line_type,
1029: location_venue_addr_id = new_references.location_venue_addr_id,
1030: contact_point_type = new_references.contact_point_type,
1031: status = new_references.status,