APPS.CN_COLUMN_TRG_MAPS_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 9

  PROCEDURE insert_row (
	X_rowid		OUT	ROWID,
	X_column_trg_map_id	cn_column_trg_maps.column_trg_map_id%TYPE,
	X_trigger_id		cn_column_trg_maps.trigger_id%TYPE,
	X_column_id		cn_column_trg_maps.column_id%TYPE) IS

    X_primary_key               cn_column_trg_maps.column_trg_map_id%TYPE;

Line: 20

      SELECT cn_objects_s.NEXTVAL
        INTO X_primary_key
        FROM dual;

Line: 25

    INSERT INTO cn_column_trg_maps (
	column_trg_map_id,
	trigger_id,
	column_id)
      VALUES (
	X_column_trg_map_id,
	X_trigger_id,
	X_column_id);

Line: 34

    SELECT ROWID
      INTO X_rowid
      FROM cn_column_trg_maps
     WHERE column_trg_map_id = X_primary_key;

Line: 43

  END insert_row;

Line: 46

  PROCEDURE select_row (
	recinfo IN OUT cn_column_trg_maps%ROWTYPE) IS
  BEGIN
    -- select row based on column_trg_map_id (primary key)
    IF (recinfo.column_trg_map_id IS NOT NULL) THEN

      SELECT * INTO recinfo
        FROM cn_column_trg_maps cctm
        WHERE cctm.column_trg_map_id = recinfo.column_trg_map_id;

Line: 57

  END select_row;