APPS.PA_COST_PLUS_STRUCTURE_PKG SQL Statements

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

Line: 15

   SELECT 1 INTO dummy FROM sys.dual WHERE NOT EXISTS
      (SELECT 1 FROM pa_cost_plus_structures
       WHERE     cost_plus_structure = cp_structure);

Line: 39

   SELECT 1 INTO dummy FROM sys.dual WHERE NOT EXISTS
      (SELECT 1 FROM pa_cost_base_cost_codes cbicc,
      		     pa_cost_base_exp_types cbet
       WHERE    cbicc.cost_plus_structure = cp_structure
             OR cbet.cost_plus_structure = cp_structure);

Line: 66

   SELECT 1 INTO dummy FROM sys.dual WHERE NOT EXISTS
      (SELECT 1 FROM pa_ind_rate_sch_revisions irsr
       WHERE    irsr.cost_plus_structure = cp_structure);

Line: 89

   SELECT 1 INTO dummy FROM sys.dual WHERE NOT EXISTS
      (SELECT 1
       FROM   pa_ind_rate_schedules
       WHERE  cost_plus_structure = cp_structure);

Line: 113

   SELECT 1 INTO dummy FROM sys.dual WHERE NOT EXISTS
      (SELECT 1
       FROM   pa_cost_base_cost_codes
       WHERE  cost_plus_structure = cp_structure);

Line: 136

   SELECT 1 INTO dummy FROM sys.dual WHERE NOT EXISTS
      (SELECT 1
       FROM   pa_cost_plus_structures
       WHERE  default_for_override_sch_flag = 'Y');

Line: 175

   SELECT 1 INTO dummy FROM sys.dual WHERE NOT EXISTS
      (SELECT 1 FROM pa_cost_plus_structures cps
       WHERE    cps.default_for_override_sch_flag = 'Y'
       AND      (  -- case A
		    (    (TRUNC(cps.start_date_active)
				BETWEEN
				TRUNC(start_date) AND
			        TRUNC(NVL(end_date, cps.start_date_active)))
		     and (   end_date IS NULL
			  or (TRUNC(NVL(cps.end_date_active, end_date))
				BETWEEN
				TRUNC(start_date) AND
			        TRUNC(end_date)))
	            )
		   -- case C
		 or (    (TRUNC(cps.start_date_active)
				BETWEEN
				TRUNC(start_date) AND
			        TRUNC(NVL(end_date, cps.start_date_active)))
		     and (TRUNC(end_date)
				BETWEEN
				TRUNC(cps.start_date_active) AND
			        TRUNC(NVL(cps.end_date_active, end_date)))
	            )
		   -- case D
		 or (    (TRUNC(start_date)
				BETWEEN
				TRUNC(cps.start_date_active) AND
			        TRUNC(NVL(cps.end_date_active, end_date)))
		     and (TRUNC(end_date)
				BETWEEN
				TRUNC(cps.start_date_active) AND
			        TRUNC(NVL(cps.end_date_active, end_date)))
	            )
		   -- case E
		 or (    (TRUNC(start_date)
				BETWEEN
				TRUNC(cps.start_date_active) AND
			        TRUNC(NVL(cps.end_date_active, start_date)))
		     and (   cps.end_date_active IS NULL
			  or TRUNC(cps.end_date_active)
				BETWEEN
				TRUNC(start_date) AND
			        TRUNC(NVL(end_date, cps.end_date_active)))
	            )
		)
      );

Line: 240

   UPDATE pa_cost_plus_structures SET default_for_override_sch_flag = 'N'
      WHERE cost_plus_structure = cp_structure;

Line: 253

procedure update_precedence(cp_structure IN     varchar2,
                            status       IN OUT NOCOPY number) is

begin

   status := 0;

Line: 260

   UPDATE pa_cost_base_cost_codes
   SET precedence = 1
   WHERE cost_plus_structure = cp_structure;

Line: 272

end update_precedence;

Line: 274

procedure cascade_delete(cp_structure IN     varchar2)
is
begin

    DELETE pa_cost_base_cost_codes
    WHERE  cost_plus_structure = cp_structure;

Line: 281

    DELETE pa_cost_base_exp_types
    WHERE  cost_plus_structure = cp_structure;

Line: 286

end cascade_delete;

Line: 288

procedure cascade_update(old_cp_structure IN  varchar2,
			 new_cp_structure IN  varchar2)

is
begin

    UPDATE pa_cost_base_cost_codes
    SET	   cost_plus_structure = new_cp_structure
    WHERE  cost_plus_structure = old_cp_structure;

Line: 298

    UPDATE pa_cost_base_exp_types
    SET	   cost_plus_structure = new_cp_structure
    WHERE  cost_plus_structure = old_cp_structure;

Line: 304

end cascade_update;