APPS.HZ_PARTY_USAGE_RULES_PKG dependencies on HZ_PARTY_USAGE_RULES

Line 1: PACKAGE BODY HZ_PARTY_USAGE_RULES_PKG AS

1: PACKAGE BODY HZ_PARTY_USAGE_RULES_PKG AS
2: /*$Header: ARHPURTB.pls 120.0 2005/05/12 23:15:37 jhuang noship $ */
3:
4: D_FUTURE_DATE CONSTANT DATE := TO_DATE('4712/12/31','YYYY/MM/DD');
5:

Line 23: INSERT INTO hz_party_usage_rules (

19: ) IS
20:
21: BEGIN
22:
23: INSERT INTO hz_party_usage_rules (
24: party_usage_rule_id,
25: party_usage_rule_type,
26: party_usage_code,
27: related_party_usage_code,

Line 39: NULL, hz_party_usage_rules_s.nextval,

35: last_updated_by
36: )
37: VALUES (
38: DECODE(x_party_usage_rule_id,
39: NULL, hz_party_usage_rules_s.nextval,
40: FND_API.G_MISS_CHAR, hz_party_usage_rules_s.nextval,
41: x_party_usage_rule_id),
42: x_party_usage_rule_type,
43: x_party_usage_code,

Line 40: FND_API.G_MISS_CHAR, hz_party_usage_rules_s.nextval,

36: )
37: VALUES (
38: DECODE(x_party_usage_rule_id,
39: NULL, hz_party_usage_rules_s.nextval,
40: FND_API.G_MISS_CHAR, hz_party_usage_rules_s.nextval,
41: x_party_usage_rule_id),
42: x_party_usage_rule_type,
43: x_party_usage_code,
44: DECODE(x_related_party_usage_code,

Line 81: UPDATE hz_party_usage_rules

77: ) IS
78:
79: BEGIN
80:
81: UPDATE hz_party_usage_rules
82: SET
83: party_usage_rule_type = x_party_usage_rule_type,
84: party_usage_code = x_party_usage_code,
85: related_party_usage_code =

Line 139: FROM hz_party_usage_rules

135: f_ludate DATE; -- entity update date in file
136:
137: CURSOR c_party_usage_rule IS
138: SELECT object_version_number
139: FROM hz_party_usage_rules
140: WHERE party_usage_rule_id = x_party_usage_rule_id;
141:
142: -- we don't need to check transition rules created by customer
143: -- because we don't allow customer create seeded->seeded

Line 149: FROM hz_party_usage_rules

145: CURSOR c_duplicate_rule (
146: p_seed NUMBER
147: ) IS
148: SELECT party_usage_rule_id, object_version_number
149: FROM hz_party_usage_rules
150: WHERE party_usage_rule_type = x_party_usage_rule_type
151: AND party_usage_code = x_party_usage_code
152: AND NVL(related_party_usage_code, '##') = NVL(x_related_party_usage_code, '##')
153: AND effective_end_date = D_FUTURE_DATE

Line 229: END HZ_PARTY_USAGE_RULES_PKG;

225:
226: END load_row;
227:
228:
229: END HZ_PARTY_USAGE_RULES_PKG;