APPS.HZ_PERSON_INTEREST_PKG dependencies on HZ_PERSON_INTEREST_S

Line 55: DECODE( x_PERSON_INTEREST_ID, FND_API.G_MISS_NUM, HZ_PERSON_INTEREST_S.NEXTVAL, NULL, HZ_PERSON_INTEREST_S.NEXTVAL, X_PERSON_INTEREST_ID ),

51: CREATED_BY_MODULE,
52: APPLICATION_ID
53:
54: ) VALUES (
55: DECODE( x_PERSON_INTEREST_ID, FND_API.G_MISS_NUM, HZ_PERSON_INTEREST_S.NEXTVAL, NULL, HZ_PERSON_INTEREST_S.NEXTVAL, X_PERSON_INTEREST_ID ),
56: decode( x_LEVEL_OF_INTEREST, FND_API.G_MISS_CHAR, NULL,x_LEVEL_OF_INTEREST),
57: decode( x_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_PARTY_ID),
58: decode( x_LEVEL_OF_PARTICIPATION, FND_API.G_MISS_CHAR, NULL,x_LEVEL_OF_PARTICIPATION),
59: decode( x_INTEREST_TYPE_CODE, FND_API.G_MISS_CHAR, NULL,x_INTEREST_TYPE_CODE),

Line 98: SELECT HZ_PERSON_INTEREST_S.NEXTVAL

94: l_dummy VARCHAR2(1);
95: BEGIN
96: l_count := 1;
97: WHILE l_count > 0 LOOP
98: SELECT HZ_PERSON_INTEREST_S.NEXTVAL
99: INTO X_PERSON_INTEREST_ID FROM dual;
100: BEGIN
101: SELECT 'Y' INTO l_dummy
102: FROM HZ_PERSON_INTEREST