APPS.HZ_RELATIONSHIPS_PKG dependencies on HZ_RELATIONSHIPS

Line 1: PACKAGE BODY HZ_RELATIONSHIPS_PKG AS

1: PACKAGE BODY HZ_RELATIONSHIPS_PKG AS
2: /*$Header: ARHRELTB.pls 120.4 2005/10/30 03:54:47 appldev noship $ */
3:
4: G_MISS_CONTENT_SOURCE_TYPE CONSTANT VARCHAR2(30) := 'USER_ENTERED';
5:

Line 84: INSERT INTO HZ_RELATIONSHIPS (

80: ) IS
81:
82: BEGIN
83:
84: INSERT INTO HZ_RELATIONSHIPS (
85: RELATIONSHIP_ID,
86: SUBJECT_ID,
87: SUBJECT_TYPE,
88: SUBJECT_TABLE_NAME,

Line 339: UPDATE HZ_RELATIONSHIPS SET

335: ) IS
336:
337: BEGIN
338:
339: UPDATE HZ_RELATIONSHIPS SET
340: RELATIONSHIP_ID = DECODE( X_RELATIONSHIP_ID, NULL, RELATIONSHIP_ID, FND_API.G_MISS_NUM, NULL, X_RELATIONSHIP_ID ),
341: SUBJECT_ID = DECODE( X_SUBJECT_ID, NULL, SUBJECT_ID, FND_API.G_MISS_NUM, NULL, X_SUBJECT_ID ),
342: SUBJECT_TYPE = DECODE( X_SUBJECT_TYPE, NULL, SUBJECT_TYPE, FND_API.G_MISS_CHAR, NULL, X_SUBJECT_TYPE ),
343: SUBJECT_TABLE_NAME = DECODE( X_SUBJECT_TABLE_NAME, NULL, SUBJECT_TABLE_NAME, FND_API.G_MISS_CHAR, NULL, X_SUBJECT_TABLE_NAME ),

Line 521: SELECT * FROM HZ_RELATIONSHIPS

517: X_ACTUAL_CONTENT_SOURCE IN VARCHAR2
518: ) IS
519:
520: CURSOR C IS
521: SELECT * FROM HZ_RELATIONSHIPS
522: WHERE ROWID = x_Rowid
523: FOR UPDATE NOWAIT;
524: Recinfo C%ROWTYPE;
525:

Line 1016: FROM HZ_RELATIONSHIPS

1012: X_ADDITIONAL_INFORMATION30,
1013: X_DIRECTION_CODE,
1014: X_PERCENTAGE_OWNERSHIP,
1015: X_ACTUAL_CONTENT_SOURCE
1016: FROM HZ_RELATIONSHIPS
1017: WHERE RELATIONSHIP_ID = X_RELATIONSHIP_ID
1018: AND DIRECTIONAL_FLAG = X_DIRECTIONAL_FLAG;
1019:
1020: EXCEPTION

Line 1036: DELETE FROM HZ_RELATIONSHIPS

1032: ) IS
1033:
1034: BEGIN
1035:
1036: DELETE FROM HZ_RELATIONSHIPS
1037: WHERE RELATIONSHIP_ID = X_RELATIONSHIP_ID;
1038:
1039: IF ( SQL%NOTFOUND ) THEN
1040: RAISE NO_DATA_FOUND;

Line 1045: END HZ_RELATIONSHIPS_PKG;

1041: END IF;
1042:
1043: END Delete_Row;
1044:
1045: END HZ_RELATIONSHIPS_PKG;