APPS.HZ_DUP_BATCH_PKG dependencies on FND_API

Line 20: IF (px_DUP_BATCH_ID IS NULL) OR (px_DUP_BATCH_ID = 0) OR (px_DUP_BATCH_ID = FND_API.G_MISS_NUM) THEN

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

Line 41: decode(p_DUP_BATCH_NAME, FND_API.G_MISS_CHAR, NULL,

37: LAST_UPDATED_BY
38: )
39: VALUES (
40: px_DUP_BATCH_ID,
41: decode(p_DUP_BATCH_NAME, FND_API.G_MISS_CHAR, NULL,
42: p_DUP_BATCH_NAME||' - '||px_DUP_BATCH_ID),
43: decode(p_MATCH_RULE_ID, FND_API.G_MISS_NUM, NULL,
44: p_MATCH_RULE_ID),
45: decode(p_APPLICATION_ID, FND_API.G_MISS_NUM, NULL,

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

39: VALUES (
40: px_DUP_BATCH_ID,
41: decode(p_DUP_BATCH_NAME, FND_API.G_MISS_CHAR, NULL,
42: p_DUP_BATCH_NAME||' - '||px_DUP_BATCH_ID),
43: decode(p_MATCH_RULE_ID, FND_API.G_MISS_NUM, NULL,
44: p_MATCH_RULE_ID),
45: decode(p_APPLICATION_ID, FND_API.G_MISS_NUM, NULL,
46: p_APPLICATION_ID),
47: decode(p_REQUEST_TYPE, FND_API.G_MISS_CHAR, NULL,

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

41: decode(p_DUP_BATCH_NAME, FND_API.G_MISS_CHAR, NULL,
42: p_DUP_BATCH_NAME||' - '||px_DUP_BATCH_ID),
43: decode(p_MATCH_RULE_ID, FND_API.G_MISS_NUM, NULL,
44: p_MATCH_RULE_ID),
45: decode(p_APPLICATION_ID, FND_API.G_MISS_NUM, NULL,
46: p_APPLICATION_ID),
47: decode(p_REQUEST_TYPE, FND_API.G_MISS_CHAR, NULL,
48: p_REQUEST_TYPE),
49: HZ_UTILITY_V2PUB.CREATED_BY,

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

43: decode(p_MATCH_RULE_ID, FND_API.G_MISS_NUM, NULL,
44: p_MATCH_RULE_ID),
45: decode(p_APPLICATION_ID, FND_API.G_MISS_NUM, NULL,
46: p_APPLICATION_ID),
47: decode(p_REQUEST_TYPE, FND_API.G_MISS_CHAR, NULL,
48: p_REQUEST_TYPE),
49: HZ_UTILITY_V2PUB.CREATED_BY,
50: HZ_UTILITY_V2PUB.CREATION_DATE,
51: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

Line 70: DUP_BATCH_NAME = decode(p_DUP_BATCH_NAME, FND_API.G_MISS_CHAR, NULL,

66: ) IS
67: BEGIN
68: UPDATE HZ_DUP_BATCH
69: SET
70: DUP_BATCH_NAME = decode(p_DUP_BATCH_NAME, FND_API.G_MISS_CHAR, NULL,
71: p_DUP_BATCH_NAME),
72: CREATED_BY = CREATED_BY,
73: CREATION_DATE = CREATION_DATE,
74: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,