APPS.PON_BIZRULE_PKG SQL Statements

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

Line: 7

   SELECT doctype_id FROM pon_auc_doctypes;

Line: 12

      INSERT INTO PON_AUC_DOCTYPE_RULES
	(BIZRULE_ID,
	 DOCTYPE_ID,
	 DISPLAY_FLAG,
	 REQUIRED_FLAG,
	 FIXED_VALUE,
	 DEFAULT_VALUE,
	 RESTRICTED_VALUES_FLAG,
	 VALIDITY_FLAG,
	 CREATED_BY,
	 CREATION_DATE,
	 LAST_UPDATED_BY,
	 LAST_UPDATE_DATE
	 )
	VALUES
	(p_rule_id,
         doc.doctype_id,
	 'N',
	 'N',
	 NULL,
	 NULL,
	 'N',
	 'N',
	 1,
	 Sysdate,
	 1,
	 Sysdate
	 );

Line: 43

PROCEDURE delete_rule(p_rule_id    NUMBER) IS

CURSOR documents IS
   SELECT doctype_id FROM pon_auc_doctypes;

Line: 49

   DELETE FROM pon_auc_doctype_rules  WHERE  bizrule_id = p_rule_id;

Line: 50

END delete_rule;

Line: 56

SELECT d.doctype_id FROM pon_auc_doctypes d
  WHERE NOT EXISTS (select 'FOUND' from pon_auc_doctype_rules
		    where bizrule_id = p_rule_id AND doctype_id = d.doctype_id);

Line: 63

      INSERT INTO PON_AUC_DOCTYPE_RULES
	(BIZRULE_ID,
	 DOCTYPE_ID,
	 DISPLAY_FLAG,
	 REQUIRED_FLAG,
	 FIXED_VALUE,
	 DEFAULT_VALUE,
	 RESTRICTED_VALUES_FLAG,
	 VALIDITY_FLAG,
	 CREATED_BY,
	 CREATION_DATE,
	 LAST_UPDATED_BY,
	 LAST_UPDATE_DATE
	 )
	VALUES
	(p_rule_id,
         doc.doctype_id,
	 'N',
	 'N',
	 NULL,
	 NULL,
	 'N',
	 'N',
	 1,
	 Sysdate,
	 1,
	 Sysdate
	 );