1 PACKAGE pay_exa_bus AUTHID CURRENT_USER AS
2 /* $Header: pyexarhi.pkh 115.5 2002/12/10 18:44:35 dsaxby ship $ */
3 -- [start of change: 40.1, Dave Harris]
4 -- ----------------------------------------------------------------------------
5 -- |--------------------------< chk_territory_code >--------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 -- This procedure is used to validate the attribute territory_code.
11 -- If inserting then we must ensure that the territory_code is valid.
12 -- If updating then we must ensure that the territory_code has not changed
13 -- (we still require this check because the record upd interface could
14 -- still set the territory_code to a value).
15 --
16 -- Pre Conditions:
17 --
18 -- In Arguments:
19 --
20 -- Post Success:
21 -- The process will successfully exit.
22 --
23 -- Post Failure:
24 -- 1) If the territory_code is invalid then an application error will be
25 -- raised.
26 -- 2) If the territory_code is being updated then an application error will
27 -- be raise.
28 --
29 -- Developer Implementation Notes:
30 -- None.
31 --
32 -- Access Status:
33 -- Internal Development Use Only.
34 --
35 -- {End Of Comments}
36 -- ----------------------------------------------------------------------------
37 procedure chk_territory_code(
38 p_territory_code in varchar2
39 ,p_external_account_id in number
40 ,p_object_version_number in number
41 );
42 --
43 -- ----------------------------------------------------------------------------
44 -- |---------------------------< insert_validate >----------------------------|
45 -- ----------------------------------------------------------------------------
46 -- {Start Of Comments}
47 --
48 -- Description:
49 -- This procedure controls the execution of all insert business rule
50 -- validation.
51 --
52 -- Pre Conditions:
53 -- This private procedure is called from ins procedure.
54 --
55 -- In Arguments:
56 -- A Pl/Sql record structre.
57 --
58 -- Post Success:
59 -- Processing continues.
60 --
61 -- Post Failure:
62 -- If a business rules fails the error will not be handled by this procedure
63 -- unless explicity coded.
64 --
65 -- Developer Implementation Notes:
66 -- For insert, your business rules should be coded within this procedure and
67 -- should ideally (unless really necessary) just be straight procedure or
68 -- function calls. Try and avoid using conditional branching logic.
69 --
70 -- Access Status:
71 -- Internal Table Handler Use Only.
72 --
73 -- {End Of Comments}
74 -- ----------------------------------------------------------------------------
75 procedure insert_validate(
76 p_rec in pay_exa_shd.g_rec_type
77 ,p_business_group_id in number
78 );
79 --
80 -- ----------------------------------------------------------------------------
81 -- |---------------------------< update_validate >----------------------------|
82 -- ----------------------------------------------------------------------------
83 -- {Start Of Comments}
84 --
85 -- Description:
86 -- This procedure controls the execution of all update business rule
87 -- validation.
88 --
89 -- Pre Conditions:
90 -- This private procedure is called from upd procedure.
91 --
92 -- In Arguments:
93 -- A Pl/Sql record structre.
94 --
95 -- Post Success:
96 -- Processing continues.
97 --
98 -- Post Failure:
99 -- If a business rules fails the error will not be handled by this procedure
100 -- unless explicity coded.
101 --
102 -- Developer Implementation Notes:
103 -- For update, your business rules should be coded within this procedure and
104 -- should ideally (unless really necessary) just be straight procedure or
105 -- function calls. Try and avoid using conditional branching logic.
106 --
107 -- Access Status:
108 -- Internal Table Handler Use Only.
109 --
110 -- {End Of Comments}
111 -- ----------------------------------------------------------------------------
112 procedure update_validate(
113 p_rec in pay_exa_shd.g_rec_type
114 );
115 --
116 END pay_exa_bus;