APPS.ZX_RULES_PKG dependencies on ZX_RULES_B

Line 43: cursor C is select ROWID from ZX_RULES_B

39: X_TAX_LAW_REF_DESC IN VARCHAR2,
40: X_LAST_UPDATE_MODE_FLAG IN VARCHAR2,
41: X_NEVER_BEEN_ENABLED_FLAG IN VARCHAR2
42: ) is
43: cursor C is select ROWID from ZX_RULES_B
44: where TAX_RULE_ID = X_TAX_RULE_ID;
45:
46: l_tax_id NUMBER;
47:

Line 471: insert into ZX_RULES_B (

467: END IF;
468:
469: END IF;
470:
471: insert into ZX_RULES_B (
472: TAX_RULE_ID,
473: TAX_RULE_CODE,
474: TAX,
475: TAX_REGIME_CODE,

Line 650: from ZX_RULES_B

646: TAX_LAW_REF_CODE ,
647: LAST_UPDATE_MODE_FLAG ,
648: NEVER_BEEN_ENABLED_FLAG
649:
650: from ZX_RULES_B
651: where TAX_RULE_ID = X_TAX_RULE_ID
652: for update of TAX_RULE_ID nowait;
653:
654: recinfo c%rowtype;

Line 793: update ZX_RULES_B set

789: X_NEVER_BEEN_ENABLED_FLAG IN VARCHAR2
790: ) is
791:
792: begin
793: update ZX_RULES_B set
794: TAX_RULE_CODE = X_TAX_RULE_CODE,
795: TAX = X_TAX,
796: TAX_REGIME_CODE = X_TAX_REGIME_CODE,
797: SERVICE_TYPE_CODE = X_SERVICE_TYPE_CODE,

Line 861: delete from ZX_RULES_B

857: if (sql%notfound) then
858: raise no_data_found;
859: end if;
860:
861: delete from ZX_RULES_B
862: where TAX_RULE_ID = X_TAX_RULE_ID;
863:
864: if (sql%notfound) then
865: raise no_data_found;

Line 879: from ZX_RULES_B B

875: begin
876: delete from ZX_RULES_TL T
877: where not exists
878: (select NULL
879: from ZX_RULES_B B
880: where B.TAX_RULE_ID = T.TAX_RULE_ID);
881: update ZX_RULES_TL T set (
882: TAX_RULE_NAME,
883: TAX_RULE_DESC) = (select B.TAX_RULE_NAME,

Line 957: INSERT INTO ZX_RULES_B (TAX_RULE_ID,

953:
954: begin
955: If x_tax_rule_id.count <> 0 then
956: forall i in x_tax_rule_id.first..x_tax_rule_id.last
957: INSERT INTO ZX_RULES_B (TAX_RULE_ID,
958: TAX_RULE_CODE,
959: TAX,
960: TAX_REGIME_CODE,
961: SERVICE_TYPE_CODE,