13: begin
14: --
15: select 1
16: into x_dummy
17: from sys.dual
18: where not exists
19: (select 1
20: from pa_billing_extensions
21: where name = x_name
41: begin
42: --
43: select 1
44: into x_dummy
45: from sys.dual
46: where not exists
47: (select 1
48: from pa_billing_extensions
49: where processing_order = x_order
71: stage := 1;
72: --
73: select 1
74: into x_dummy
75: from sys.dual
76: where not exists
77: ( select 1
78: from pa_billing_assignments
79: where billing_extension_id = x_bill_extension_id );
101: --
102: stage := 1;
103: --
104: select 1 into x_dummy
105: from sys.dual
106: where not exists ( select 1
107: from pa_billing_assignments
108: where billing_extension_id = x_bill_extension_id
109: and billing_assignment_id in
128: --
129: begin
130: --
131: select pa_billing_extensions_s.nextval into x_nextval
132: from sys.dual;
133: --
134: x_return_status := 0;
135: --
136: EXCEPTION