APPS.PAY_SDB_INS SQL Statements

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

Line: 50

Procedure insert_dml(p_rec in out nocopy pay_sdb_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'insert_dml';

Line: 61

  insert into pay_shadow_defined_balances
  (	defined_balance_id,
	balance_type_id,
	dimension_name,
        force_latest_balance_flag,
        grossup_allowed_flag,
	object_version_number
       ,exclusion_rule_id
  )
  Values
  (	p_rec.defined_balance_id,
	p_rec.balance_type_id,
	p_rec.dimension_name,
        p_rec.force_latest_balance_flag,
        p_rec.grossup_allowed_flag,
	p_rec.object_version_number
       ,p_rec.exclusion_rule_id
  );

Line: 97

End insert_dml;

Line: 136

Procedure pre_insert(p_rec  in out nocopy pay_sdb_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'pre_insert';

Line: 140

  Cursor C_Sel1 is select pay_shadow_defined_balances_s.nextval from sys.dual;

Line: 153

End pre_insert;

Line: 187

Procedure post_insert(p_rec in pay_sdb_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'post_insert';

Line: 195

End post_insert;

Line: 213

  pay_sdb_bus.insert_validate(p_effective_date, p_rec);

Line: 217

  pre_insert(p_rec);

Line: 221

  insert_dml(p_rec);

Line: 225

  post_insert(p_rec);