APPS.HZ_DUP_EXCLUSIONS_PKG dependencies on FND_API

Line 18: IF ( px_DUP_EXCLUSION_ID IS NULL) OR (px_DUP_EXCLUSION_ID = FND_API.G_MISS_NUM) THEN

14: p_LAST_UPDATED_BY NUMBER)
15: IS
16: CURSOR C2 IS SELECT HZ_DUP_EXCLUSIONS_s.nextval FROM sys.dual;
17: BEGIN
18: IF ( px_DUP_EXCLUSION_ID IS NULL) OR (px_DUP_EXCLUSION_ID = FND_API.G_MISS_NUM) THEN
19: OPEN C2;
20: FETCH C2 INTO px_DUP_EXCLUSION_ID;
21: CLOSE C2;
22: END IF;

Line 38: decode(p_PARTY_ID, FND_API.G_MISS_NUM, NULL,

34: LAST_UPDATED_BY
35: )
36: VALUES (
37: px_DUP_EXCLUSION_ID,
38: decode(p_PARTY_ID, FND_API.G_MISS_NUM, NULL,
39: p_PARTY_ID),
40: decode(p_DUP_PARTY_ID, FND_API.G_MISS_NUM, NULL,
41: p_DUP_PARTY_ID),
42: decode(p_from_date, FND_API.G_MISS_DATE, NULL,

Line 40: decode(p_DUP_PARTY_ID, FND_API.G_MISS_NUM, NULL,

36: VALUES (
37: px_DUP_EXCLUSION_ID,
38: decode(p_PARTY_ID, FND_API.G_MISS_NUM, NULL,
39: p_PARTY_ID),
40: decode(p_DUP_PARTY_ID, FND_API.G_MISS_NUM, NULL,
41: p_DUP_PARTY_ID),
42: decode(p_from_date, FND_API.G_MISS_DATE, NULL,
43: p_from_date),
44: decode(p_to_date, FND_API.G_MISS_DATE, NULL,

Line 42: decode(p_from_date, FND_API.G_MISS_DATE, NULL,

38: decode(p_PARTY_ID, FND_API.G_MISS_NUM, NULL,
39: p_PARTY_ID),
40: decode(p_DUP_PARTY_ID, FND_API.G_MISS_NUM, NULL,
41: p_DUP_PARTY_ID),
42: decode(p_from_date, FND_API.G_MISS_DATE, NULL,
43: p_from_date),
44: decode(p_to_date, FND_API.G_MISS_DATE, NULL,
45: p_to_date),
46: hz_utility_v2pub.created_by,

Line 44: decode(p_to_date, FND_API.G_MISS_DATE, NULL,

40: decode(p_DUP_PARTY_ID, FND_API.G_MISS_NUM, NULL,
41: p_DUP_PARTY_ID),
42: decode(p_from_date, FND_API.G_MISS_DATE, NULL,
43: p_from_date),
44: decode(p_to_date, FND_API.G_MISS_DATE, NULL,
45: p_to_date),
46: hz_utility_v2pub.created_by,
47: hz_utility_v2pub.creation_date,
48: hz_utility_v2pub.last_update_login,

Line 70: PARTY_ID = decode(p_PARTY_ID, FND_API.G_MISS_NUM, NULL,

66: ) IS
67: BEGIN
68: UPDATE HZ_DUP_EXCLUSIONS
69: SET
70: PARTY_ID = decode(p_PARTY_ID, FND_API.G_MISS_NUM, NULL,
71: p_PARTY_ID),
72: DUP_PARTY_ID = decode(p_DUP_PARTY_ID, FND_API.G_MISS_NUM, NULL,
73: p_DUP_PARTY_ID),
74: FROM_DATE = decode(p_FROM_DATE,FND_API.G_MISS_DATE, NULL,

Line 72: DUP_PARTY_ID = decode(p_DUP_PARTY_ID, FND_API.G_MISS_NUM, NULL,

68: UPDATE HZ_DUP_EXCLUSIONS
69: SET
70: PARTY_ID = decode(p_PARTY_ID, FND_API.G_MISS_NUM, NULL,
71: p_PARTY_ID),
72: DUP_PARTY_ID = decode(p_DUP_PARTY_ID, FND_API.G_MISS_NUM, NULL,
73: p_DUP_PARTY_ID),
74: FROM_DATE = decode(p_FROM_DATE,FND_API.G_MISS_DATE, NULL,
75: p_FROM_DATE),
76: TO_DATE = decode(p_TO_DATE,FND_API.G_MISS_DATE, NULL,

Line 74: FROM_DATE = decode(p_FROM_DATE,FND_API.G_MISS_DATE, NULL,

70: PARTY_ID = decode(p_PARTY_ID, FND_API.G_MISS_NUM, NULL,
71: p_PARTY_ID),
72: DUP_PARTY_ID = decode(p_DUP_PARTY_ID, FND_API.G_MISS_NUM, NULL,
73: p_DUP_PARTY_ID),
74: FROM_DATE = decode(p_FROM_DATE,FND_API.G_MISS_DATE, NULL,
75: p_FROM_DATE),
76: TO_DATE = decode(p_TO_DATE,FND_API.G_MISS_DATE, NULL,
77: p_TO_DATE),
78: CREATED_BY = created_by,

Line 76: TO_DATE = decode(p_TO_DATE,FND_API.G_MISS_DATE, NULL,

72: DUP_PARTY_ID = decode(p_DUP_PARTY_ID, FND_API.G_MISS_NUM, NULL,
73: p_DUP_PARTY_ID),
74: FROM_DATE = decode(p_FROM_DATE,FND_API.G_MISS_DATE, NULL,
75: p_FROM_DATE),
76: TO_DATE = decode(p_TO_DATE,FND_API.G_MISS_DATE, NULL,
77: p_TO_DATE),
78: CREATED_BY = created_by,
79: CREATION_DATE = CREATION_DATE,
80: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,