APPS.HZ_PARTY_USG_ASSIGNMENTS_PKG dependencies on HZ_PARTY_USG_ASSIGNMENTS

Line 1: PACKAGE BODY HZ_PARTY_USG_ASSIGNMENTS_PKG AS

1: PACKAGE BODY HZ_PARTY_USG_ASSIGNMENTS_PKG AS
2: /*$Header: ARHPUATB.pls 120.2 2006/02/28 21:59:56 jhuang noship $ */
3:
4: D_FUTURE_DATE CONSTANT DATE := TO_DATE('4712/12/31','YYYY/MM/DD');
5:

Line 44: INSERT INTO HZ_PARTY_USG_ASSIGNMENTS (

40: ) IS
41:
42: BEGIN
43:
44: INSERT INTO HZ_PARTY_USG_ASSIGNMENTS (
45: party_usg_assignment_id,
46: party_id,
47: party_usage_code,
48: effective_start_date,

Line 89: hz_party_usg_assignments_s.nextval,

85: program_id,
86: program_login_id
87: )
88: VALUES (
89: hz_party_usg_assignments_s.nextval,
90: x_party_id,
91: x_party_usage_code,
92: DECODE(x_effective_start_date,
93: NULL, trunc(sysdate),

Line 233: UPDATE HZ_PARTY_USG_ASSIGNMENTS

229: ) IS
230:
231: BEGIN
232:
233: UPDATE HZ_PARTY_USG_ASSIGNMENTS
234: SET
235: party_id =
236: DECODE(x_party_id,
237: NULL, party_id,

Line 398: END HZ_PARTY_USG_ASSIGNMENTS_PKG;

394:
395: END update_row;
396:
397:
398: END HZ_PARTY_USG_ASSIGNMENTS_PKG;