APPS.HZ_ORG_CONTACT_ROLES_PKG dependencies on HZ_ORG_CONTACT_ROLES_S

Line 47: DECODE( X_ORG_CONTACT_ROLE_ID, FND_API.G_MISS_NUM, HZ_ORG_CONTACT_ROLES_S.NEXTVAL, NULL, HZ_ORG_CONTACT_ROLES_S.NEXTVAL, X_ORG_CONTACT_ROLE_ID ),

43: CREATED_BY_MODULE,
44: APPLICATION_ID
45: )
46: VALUES (
47: DECODE( X_ORG_CONTACT_ROLE_ID, FND_API.G_MISS_NUM, HZ_ORG_CONTACT_ROLES_S.NEXTVAL, NULL, HZ_ORG_CONTACT_ROLES_S.NEXTVAL, X_ORG_CONTACT_ROLE_ID ),
48: DECODE( X_ORG_CONTACT_ID, FND_API.G_MISS_NUM, NULL, X_ORG_CONTACT_ID ),
49: DECODE( X_ROLE_TYPE, FND_API.G_MISS_CHAR, NULL, X_ROLE_TYPE ),
50: HZ_UTILITY_V2PUB.CREATED_BY,
51: DECODE( X_ROLE_LEVEL, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_ROLE_LEVEL ),

Line 54: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_ORG_CONTACT_ROLE_ID,HZ_ORG_CONTACT_ROLES_S.CURRVAL)), NULL, TO_CHAR(NVL(X_ORG_CONTACT_ROLE_ID,HZ_ORG_CONTACT_ROLES_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),

50: HZ_UTILITY_V2PUB.CREATED_BY,
51: DECODE( X_ROLE_LEVEL, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_ROLE_LEVEL ),
52: DECODE( X_PRIMARY_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_PRIMARY_FLAG ),
53: HZ_UTILITY_V2PUB.CREATION_DATE,
54: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_ORG_CONTACT_ROLE_ID,HZ_ORG_CONTACT_ROLES_S.CURRVAL)), NULL, TO_CHAR(NVL(X_ORG_CONTACT_ROLE_ID,HZ_ORG_CONTACT_ROLES_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
55: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
56: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
57: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
58: HZ_UTILITY_V2PUB.REQUEST_ID,

Line 85: SELECT HZ_ORG_CONTACT_ROLES_S.NEXTVAL

81: l_dummy VARCHAR2(1);
82: BEGIN
83: l_count := 1;
84: WHILE l_count > 0 LOOP
85: SELECT HZ_ORG_CONTACT_ROLES_S.NEXTVAL
86: INTO X_ORG_CONTACT_ROLE_ID FROM dual;
87: BEGIN
88: SELECT 'Y' INTO l_dummy
89: FROM HZ_ORG_CONTACT_ROLES

Line 124: UPDATE HZ_ORG_CONTACT_ROLES SET

120: ) IS
121:
122: BEGIN
123:
124: UPDATE HZ_ORG_CONTACT_ROLES SET
125: ORG_CONTACT_ROLE_ID = DECODE( X_ORG_CONTACT_ROLE_ID, NULL, ORG_CONTACT_ROLE_ID, FND_API.G_MISS_NUM, NULL, X_ORG_CONTACT_ROLE_ID ),
126: ORG_CONTACT_ID = DECODE( X_ORG_CONTACT_ID, NULL, ORG_CONTACT_ID, FND_API.G_MISS_NUM, NULL, X_ORG_CONTACT_ID ),
127: ROLE_TYPE = DECODE( X_ROLE_TYPE, NULL, ROLE_TYPE, FND_API.G_MISS_CHAR, NULL, X_ROLE_TYPE ),
128: CREATED_BY = CREATED_BY,