APPS.HZ_DUP_SETS_PKG dependencies on FND_API

Line 21: IF ( px_DUP_SET_ID IS NULL) OR (px_DUP_SET_ID = FND_API.G_MISS_NUM) THEN

17: IS
18: CURSOR C2 IS SELECT HZ_MERGE_BATCH_S.nextval FROM sys.dual;
19: BEGIN
20:
21: IF ( px_DUP_SET_ID IS NULL) OR (px_DUP_SET_ID = FND_API.G_MISS_NUM) THEN
22: OPEN C2;
23: FETCH C2 INTO px_DUP_SET_ID;
24: CLOSE C2;
25: END IF;

Line 43: decode(p_DUP_BATCH_ID, FND_API.G_MISS_NUM, NULL,

39: LAST_UPDATED_BY
40: )
41: VALUES (
42: px_DUP_SET_ID,
43: decode(p_DUP_BATCH_ID, FND_API.G_MISS_NUM, NULL,
44: p_DUP_BATCH_ID),
45: decode(p_WINNER_PARTY_ID,FND_API.G_MISS_NUM, NULL,
46: p_WINNER_PARTY_ID),
47: decode(p_STATUS,FND_API.G_MISS_CHAR, NULL,

Line 45: decode(p_WINNER_PARTY_ID,FND_API.G_MISS_NUM, NULL,

41: VALUES (
42: px_DUP_SET_ID,
43: decode(p_DUP_BATCH_ID, FND_API.G_MISS_NUM, NULL,
44: p_DUP_BATCH_ID),
45: decode(p_WINNER_PARTY_ID,FND_API.G_MISS_NUM, NULL,
46: p_WINNER_PARTY_ID),
47: decode(p_STATUS,FND_API.G_MISS_CHAR, NULL,
48: p_STATUS),
49: decode(p_ASSIGNED_TO_USER_ID,FND_API.G_MISS_NUM, NULL,

Line 47: decode(p_STATUS,FND_API.G_MISS_CHAR, NULL,

43: decode(p_DUP_BATCH_ID, FND_API.G_MISS_NUM, NULL,
44: p_DUP_BATCH_ID),
45: decode(p_WINNER_PARTY_ID,FND_API.G_MISS_NUM, NULL,
46: p_WINNER_PARTY_ID),
47: decode(p_STATUS,FND_API.G_MISS_CHAR, NULL,
48: p_STATUS),
49: decode(p_ASSIGNED_TO_USER_ID,FND_API.G_MISS_NUM, NULL,
50: p_ASSIGNED_TO_USER_ID),
51: decode(p_MERGE_TYPE,FND_API.G_MISS_CHAR, NULL,

Line 49: decode(p_ASSIGNED_TO_USER_ID,FND_API.G_MISS_NUM, NULL,

45: decode(p_WINNER_PARTY_ID,FND_API.G_MISS_NUM, NULL,
46: p_WINNER_PARTY_ID),
47: decode(p_STATUS,FND_API.G_MISS_CHAR, NULL,
48: p_STATUS),
49: decode(p_ASSIGNED_TO_USER_ID,FND_API.G_MISS_NUM, NULL,
50: p_ASSIGNED_TO_USER_ID),
51: decode(p_MERGE_TYPE,FND_API.G_MISS_CHAR, NULL,
52: p_MERGE_TYPE),
53: decode(p_OBJECT_VERSION_NUMBER,FND_API.G_MISS_NUM, NULL,

Line 51: decode(p_MERGE_TYPE,FND_API.G_MISS_CHAR, NULL,

47: decode(p_STATUS,FND_API.G_MISS_CHAR, NULL,
48: p_STATUS),
49: decode(p_ASSIGNED_TO_USER_ID,FND_API.G_MISS_NUM, NULL,
50: p_ASSIGNED_TO_USER_ID),
51: decode(p_MERGE_TYPE,FND_API.G_MISS_CHAR, NULL,
52: p_MERGE_TYPE),
53: decode(p_OBJECT_VERSION_NUMBER,FND_API.G_MISS_NUM, NULL,
54: p_OBJECT_VERSION_NUMBER),
55: hz_utility_v2pub.created_by,

Line 53: decode(p_OBJECT_VERSION_NUMBER,FND_API.G_MISS_NUM, NULL,

49: decode(p_ASSIGNED_TO_USER_ID,FND_API.G_MISS_NUM, NULL,
50: p_ASSIGNED_TO_USER_ID),
51: decode(p_MERGE_TYPE,FND_API.G_MISS_CHAR, NULL,
52: p_MERGE_TYPE),
53: decode(p_OBJECT_VERSION_NUMBER,FND_API.G_MISS_NUM, NULL,
54: p_OBJECT_VERSION_NUMBER),
55: hz_utility_v2pub.created_by,
56: hz_utility_v2pub.creation_date,
57: hz_utility_v2pub.last_update_login,

Line 77: DUP_BATCH_ID= decode(p_DUP_BATCH_ID, FND_API.G_MISS_NUM, NULL,

73: IS
74: BEGIN
75: UPDATE HZ_DUP_SETS
76: SET
77: DUP_BATCH_ID= decode(p_DUP_BATCH_ID, FND_API.G_MISS_NUM, NULL,
78: p_DUP_BATCH_ID),
79: WINNER_PARTY_ID = decode(p_WINNER_PARTY_ID,FND_API.G_MISS_NUM, NULL,
80: p_WINNER_PARTY_ID),
81: created_by = created_by,

Line 79: WINNER_PARTY_ID = decode(p_WINNER_PARTY_ID,FND_API.G_MISS_NUM, NULL,

75: UPDATE HZ_DUP_SETS
76: SET
77: DUP_BATCH_ID= decode(p_DUP_BATCH_ID, FND_API.G_MISS_NUM, NULL,
78: p_DUP_BATCH_ID),
79: WINNER_PARTY_ID = decode(p_WINNER_PARTY_ID,FND_API.G_MISS_NUM, NULL,
80: p_WINNER_PARTY_ID),
81: created_by = created_by,
82: creation_date= creation_date,
83: last_update_login= hz_utility_v2pub.last_update_login,