APPS.HZ_DUP_SET_PARTIES_PKG dependencies on FND_API

Line 53: decode(p_MERGE_FLAG, FND_API.G_MISS_CHAR, NULL,

49: )
50: VALUES (
51: p_DUP_PARTY_ID,
52: p_DUP_SET_ID,
53: decode(p_MERGE_FLAG, FND_API.G_MISS_CHAR, NULL,
54: p_MERGE_FLAG),
55: decode(p_NOT_DUP, FND_API.G_MISS_CHAR, NULL,
56: p_NOT_DUP),
57: decode(p_SCORE, FND_API.G_MISS_NUM, NULL,

Line 55: decode(p_NOT_DUP, FND_API.G_MISS_CHAR, NULL,

51: p_DUP_PARTY_ID,
52: p_DUP_SET_ID,
53: decode(p_MERGE_FLAG, FND_API.G_MISS_CHAR, NULL,
54: p_MERGE_FLAG),
55: decode(p_NOT_DUP, FND_API.G_MISS_CHAR, NULL,
56: p_NOT_DUP),
57: decode(p_SCORE, FND_API.G_MISS_NUM, NULL,
58: p_SCORE),
59: decode(p_MERGE_SEQ_ID, FND_API.G_MISS_NUM, NULL,

Line 57: decode(p_SCORE, FND_API.G_MISS_NUM, NULL,

53: decode(p_MERGE_FLAG, FND_API.G_MISS_CHAR, NULL,
54: p_MERGE_FLAG),
55: decode(p_NOT_DUP, FND_API.G_MISS_CHAR, NULL,
56: p_NOT_DUP),
57: decode(p_SCORE, FND_API.G_MISS_NUM, NULL,
58: p_SCORE),
59: decode(p_MERGE_SEQ_ID, FND_API.G_MISS_NUM, NULL,
60: p_MERGE_SEQ_ID),
61: decode(p_MERGE_BATCH_ID, FND_API.G_MISS_NUM, NULL,

Line 59: decode(p_MERGE_SEQ_ID, FND_API.G_MISS_NUM, NULL,

55: decode(p_NOT_DUP, FND_API.G_MISS_CHAR, NULL,
56: p_NOT_DUP),
57: decode(p_SCORE, FND_API.G_MISS_NUM, NULL,
58: p_SCORE),
59: decode(p_MERGE_SEQ_ID, FND_API.G_MISS_NUM, NULL,
60: p_MERGE_SEQ_ID),
61: decode(p_MERGE_BATCH_ID, FND_API.G_MISS_NUM, NULL,
62: p_MERGE_BATCH_ID),
63: decode(p_MERGE_BATCH_NAME, FND_API.G_MISS_CHAR, NULL,

Line 61: decode(p_MERGE_BATCH_ID, FND_API.G_MISS_NUM, NULL,

57: decode(p_SCORE, FND_API.G_MISS_NUM, NULL,
58: p_SCORE),
59: decode(p_MERGE_SEQ_ID, FND_API.G_MISS_NUM, NULL,
60: p_MERGE_SEQ_ID),
61: decode(p_MERGE_BATCH_ID, FND_API.G_MISS_NUM, NULL,
62: p_MERGE_BATCH_ID),
63: decode(p_MERGE_BATCH_NAME, FND_API.G_MISS_CHAR, NULL,
64: p_MERGE_BATCH_NAME),
65: hz_utility_v2pub.created_by,

Line 63: decode(p_MERGE_BATCH_NAME, FND_API.G_MISS_CHAR, NULL,

59: decode(p_MERGE_SEQ_ID, FND_API.G_MISS_NUM, NULL,
60: p_MERGE_SEQ_ID),
61: decode(p_MERGE_BATCH_ID, FND_API.G_MISS_NUM, NULL,
62: p_MERGE_BATCH_ID),
63: decode(p_MERGE_BATCH_NAME, FND_API.G_MISS_CHAR, NULL,
64: p_MERGE_BATCH_NAME),
65: hz_utility_v2pub.created_by,
66: hz_utility_v2pub.creation_date,
67: hz_utility_v2pub.last_update_login,

Line 93: MERGE_FLAG = decode(p_MERGE_FLAG, FND_API.G_MISS_CHAR, MERGE_FLAG,

89: IS
90: BEGIN
91: UPDATE HZ_DUP_SET_PARTIES
92: SET
93: MERGE_FLAG = decode(p_MERGE_FLAG, FND_API.G_MISS_CHAR, MERGE_FLAG,
94: p_MERGE_FLAG),
95: NOT_DUP = decode(p_NOT_DUP, FND_API.G_MISS_CHAR, NOT_DUP,
96: p_NOT_DUP),
97: SCORE = decode(p_SCORE, FND_API.G_MISS_NUM, SCORE,

Line 95: NOT_DUP = decode(p_NOT_DUP, FND_API.G_MISS_CHAR, NOT_DUP,

91: UPDATE HZ_DUP_SET_PARTIES
92: SET
93: MERGE_FLAG = decode(p_MERGE_FLAG, FND_API.G_MISS_CHAR, MERGE_FLAG,
94: p_MERGE_FLAG),
95: NOT_DUP = decode(p_NOT_DUP, FND_API.G_MISS_CHAR, NOT_DUP,
96: p_NOT_DUP),
97: SCORE = decode(p_SCORE, FND_API.G_MISS_NUM, SCORE,
98: p_SCORE),
99: MERGE_SEQ_ID = decode(p_MERGE_SEQ_ID , FND_API.G_MISS_NUM, MERGE_SEQ_ID,

Line 97: SCORE = decode(p_SCORE, FND_API.G_MISS_NUM, SCORE,

93: MERGE_FLAG = decode(p_MERGE_FLAG, FND_API.G_MISS_CHAR, MERGE_FLAG,
94: p_MERGE_FLAG),
95: NOT_DUP = decode(p_NOT_DUP, FND_API.G_MISS_CHAR, NOT_DUP,
96: p_NOT_DUP),
97: SCORE = decode(p_SCORE, FND_API.G_MISS_NUM, SCORE,
98: p_SCORE),
99: MERGE_SEQ_ID = decode(p_MERGE_SEQ_ID , FND_API.G_MISS_NUM, MERGE_SEQ_ID,
100: p_MERGE_SEQ_ID),
101: MERGE_BATCH_ID = decode(p_MERGE_BATCH_ID, FND_API.G_MISS_NUM, MERGE_BATCH_ID,

Line 99: MERGE_SEQ_ID = decode(p_MERGE_SEQ_ID , FND_API.G_MISS_NUM, MERGE_SEQ_ID,

95: NOT_DUP = decode(p_NOT_DUP, FND_API.G_MISS_CHAR, NOT_DUP,
96: p_NOT_DUP),
97: SCORE = decode(p_SCORE, FND_API.G_MISS_NUM, SCORE,
98: p_SCORE),
99: MERGE_SEQ_ID = decode(p_MERGE_SEQ_ID , FND_API.G_MISS_NUM, MERGE_SEQ_ID,
100: p_MERGE_SEQ_ID),
101: MERGE_BATCH_ID = decode(p_MERGE_BATCH_ID, FND_API.G_MISS_NUM, MERGE_BATCH_ID,
102: p_MERGE_BATCH_ID),
103: MERGE_BATCH_NAME = decode(p_MERGE_BATCH_NAME, FND_API.G_MISS_CHAR, MERGE_BATCH_NAME,

Line 101: MERGE_BATCH_ID = decode(p_MERGE_BATCH_ID, FND_API.G_MISS_NUM, MERGE_BATCH_ID,

97: SCORE = decode(p_SCORE, FND_API.G_MISS_NUM, SCORE,
98: p_SCORE),
99: MERGE_SEQ_ID = decode(p_MERGE_SEQ_ID , FND_API.G_MISS_NUM, MERGE_SEQ_ID,
100: p_MERGE_SEQ_ID),
101: MERGE_BATCH_ID = decode(p_MERGE_BATCH_ID, FND_API.G_MISS_NUM, MERGE_BATCH_ID,
102: p_MERGE_BATCH_ID),
103: MERGE_BATCH_NAME = decode(p_MERGE_BATCH_NAME, FND_API.G_MISS_CHAR, MERGE_BATCH_NAME,
104: p_MERGE_BATCH_NAME),
105: created_by = created_by,

Line 103: MERGE_BATCH_NAME = decode(p_MERGE_BATCH_NAME, FND_API.G_MISS_CHAR, MERGE_BATCH_NAME,

99: MERGE_SEQ_ID = decode(p_MERGE_SEQ_ID , FND_API.G_MISS_NUM, MERGE_SEQ_ID,
100: p_MERGE_SEQ_ID),
101: MERGE_BATCH_ID = decode(p_MERGE_BATCH_ID, FND_API.G_MISS_NUM, MERGE_BATCH_ID,
102: p_MERGE_BATCH_ID),
103: MERGE_BATCH_NAME = decode(p_MERGE_BATCH_NAME, FND_API.G_MISS_CHAR, MERGE_BATCH_NAME,
104: p_MERGE_BATCH_NAME),
105: created_by = created_by,
106: creation_date= creation_date,
107: last_update_login= hz_utility_v2pub.last_update_login,