APPS.HZ_MATCH_RULE_CONDITIONS_PKG dependencies on FND_API

Line 41: (DECODE(X_MATCH_RULE_SET_CONDITION_ID, FND_API.G_MISS_NUM, HZ_MATCH_RULE_CONDITIONS_S.NEXTVAL, NULL,

37: OBJECT_VERSION_NUMBER,
38: CREATED_BY_MODULE,
39: APPLICATION_ID )
40: VALUES
41: (DECODE(X_MATCH_RULE_SET_CONDITION_ID, FND_API.G_MISS_NUM, HZ_MATCH_RULE_CONDITIONS_S.NEXTVAL, NULL,
42: HZ_MATCH_RULE_CONDITIONS_S.NEXTVAL, X_MATCH_RULE_SET_CONDITION_ID ),
43: DECODE(X_MATCH_RULE_SET_ID, FND_API.G_MISS_NUM, NULL,X_MATCH_RULE_SET_ID),
44: DECODE(X_CONDITION_MATCH_RULE_ID,FND_API.G_MISS_NUM,NULL,X_CONDITION_MATCH_RULE_ID ),
45: DECODE(X_ATTRIBUTE_ID,FND_API.G_MISS_NUM,NULL,X_ATTRIBUTE_ID ),

Line 43: DECODE(X_MATCH_RULE_SET_ID, FND_API.G_MISS_NUM, NULL,X_MATCH_RULE_SET_ID),

39: APPLICATION_ID )
40: VALUES
41: (DECODE(X_MATCH_RULE_SET_CONDITION_ID, FND_API.G_MISS_NUM, HZ_MATCH_RULE_CONDITIONS_S.NEXTVAL, NULL,
42: HZ_MATCH_RULE_CONDITIONS_S.NEXTVAL, X_MATCH_RULE_SET_CONDITION_ID ),
43: DECODE(X_MATCH_RULE_SET_ID, FND_API.G_MISS_NUM, NULL,X_MATCH_RULE_SET_ID),
44: DECODE(X_CONDITION_MATCH_RULE_ID,FND_API.G_MISS_NUM,NULL,X_CONDITION_MATCH_RULE_ID ),
45: DECODE(X_ATTRIBUTE_ID,FND_API.G_MISS_NUM,NULL,X_ATTRIBUTE_ID ),
46: DECODE(X_OPERATION,FND_API.G_MISS_CHAR,NULL,X_OPERATION),
47: DECODE(X_VALUE,FND_API.G_MISS_CHAR,NULL,X_VALUE),

Line 44: DECODE(X_CONDITION_MATCH_RULE_ID,FND_API.G_MISS_NUM,NULL,X_CONDITION_MATCH_RULE_ID ),

40: VALUES
41: (DECODE(X_MATCH_RULE_SET_CONDITION_ID, FND_API.G_MISS_NUM, HZ_MATCH_RULE_CONDITIONS_S.NEXTVAL, NULL,
42: HZ_MATCH_RULE_CONDITIONS_S.NEXTVAL, X_MATCH_RULE_SET_CONDITION_ID ),
43: DECODE(X_MATCH_RULE_SET_ID, FND_API.G_MISS_NUM, NULL,X_MATCH_RULE_SET_ID),
44: DECODE(X_CONDITION_MATCH_RULE_ID,FND_API.G_MISS_NUM,NULL,X_CONDITION_MATCH_RULE_ID ),
45: DECODE(X_ATTRIBUTE_ID,FND_API.G_MISS_NUM,NULL,X_ATTRIBUTE_ID ),
46: DECODE(X_OPERATION,FND_API.G_MISS_CHAR,NULL,X_OPERATION),
47: DECODE(X_VALUE,FND_API.G_MISS_CHAR,NULL,X_VALUE),
48: DECODE(X_RANK,FND_API.G_MISS_NUM,NULL,X_RANK),

Line 45: DECODE(X_ATTRIBUTE_ID,FND_API.G_MISS_NUM,NULL,X_ATTRIBUTE_ID ),

41: (DECODE(X_MATCH_RULE_SET_CONDITION_ID, FND_API.G_MISS_NUM, HZ_MATCH_RULE_CONDITIONS_S.NEXTVAL, NULL,
42: HZ_MATCH_RULE_CONDITIONS_S.NEXTVAL, X_MATCH_RULE_SET_CONDITION_ID ),
43: DECODE(X_MATCH_RULE_SET_ID, FND_API.G_MISS_NUM, NULL,X_MATCH_RULE_SET_ID),
44: DECODE(X_CONDITION_MATCH_RULE_ID,FND_API.G_MISS_NUM,NULL,X_CONDITION_MATCH_RULE_ID ),
45: DECODE(X_ATTRIBUTE_ID,FND_API.G_MISS_NUM,NULL,X_ATTRIBUTE_ID ),
46: DECODE(X_OPERATION,FND_API.G_MISS_CHAR,NULL,X_OPERATION),
47: DECODE(X_VALUE,FND_API.G_MISS_CHAR,NULL,X_VALUE),
48: DECODE(X_RANK,FND_API.G_MISS_NUM,NULL,X_RANK),
49: DECODE(X_BETWEEN_CONDITION_BIN_OP,FND_API.G_MISS_NUM,NULL,X_BETWEEN_CONDITION_BIN_OP),

Line 46: DECODE(X_OPERATION,FND_API.G_MISS_CHAR,NULL,X_OPERATION),

42: HZ_MATCH_RULE_CONDITIONS_S.NEXTVAL, X_MATCH_RULE_SET_CONDITION_ID ),
43: DECODE(X_MATCH_RULE_SET_ID, FND_API.G_MISS_NUM, NULL,X_MATCH_RULE_SET_ID),
44: DECODE(X_CONDITION_MATCH_RULE_ID,FND_API.G_MISS_NUM,NULL,X_CONDITION_MATCH_RULE_ID ),
45: DECODE(X_ATTRIBUTE_ID,FND_API.G_MISS_NUM,NULL,X_ATTRIBUTE_ID ),
46: DECODE(X_OPERATION,FND_API.G_MISS_CHAR,NULL,X_OPERATION),
47: DECODE(X_VALUE,FND_API.G_MISS_CHAR,NULL,X_VALUE),
48: DECODE(X_RANK,FND_API.G_MISS_NUM,NULL,X_RANK),
49: DECODE(X_BETWEEN_CONDITION_BIN_OP,FND_API.G_MISS_NUM,NULL,X_BETWEEN_CONDITION_BIN_OP),
50: HZ_UTILITY_V2PUB.REQUEST_ID,

Line 47: DECODE(X_VALUE,FND_API.G_MISS_CHAR,NULL,X_VALUE),

43: DECODE(X_MATCH_RULE_SET_ID, FND_API.G_MISS_NUM, NULL,X_MATCH_RULE_SET_ID),
44: DECODE(X_CONDITION_MATCH_RULE_ID,FND_API.G_MISS_NUM,NULL,X_CONDITION_MATCH_RULE_ID ),
45: DECODE(X_ATTRIBUTE_ID,FND_API.G_MISS_NUM,NULL,X_ATTRIBUTE_ID ),
46: DECODE(X_OPERATION,FND_API.G_MISS_CHAR,NULL,X_OPERATION),
47: DECODE(X_VALUE,FND_API.G_MISS_CHAR,NULL,X_VALUE),
48: DECODE(X_RANK,FND_API.G_MISS_NUM,NULL,X_RANK),
49: DECODE(X_BETWEEN_CONDITION_BIN_OP,FND_API.G_MISS_NUM,NULL,X_BETWEEN_CONDITION_BIN_OP),
50: HZ_UTILITY_V2PUB.REQUEST_ID,
51: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,

Line 48: DECODE(X_RANK,FND_API.G_MISS_NUM,NULL,X_RANK),

44: DECODE(X_CONDITION_MATCH_RULE_ID,FND_API.G_MISS_NUM,NULL,X_CONDITION_MATCH_RULE_ID ),
45: DECODE(X_ATTRIBUTE_ID,FND_API.G_MISS_NUM,NULL,X_ATTRIBUTE_ID ),
46: DECODE(X_OPERATION,FND_API.G_MISS_CHAR,NULL,X_OPERATION),
47: DECODE(X_VALUE,FND_API.G_MISS_CHAR,NULL,X_VALUE),
48: DECODE(X_RANK,FND_API.G_MISS_NUM,NULL,X_RANK),
49: DECODE(X_BETWEEN_CONDITION_BIN_OP,FND_API.G_MISS_NUM,NULL,X_BETWEEN_CONDITION_BIN_OP),
50: HZ_UTILITY_V2PUB.REQUEST_ID,
51: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
52: HZ_UTILITY_V2PUB.PROGRAM_ID,

Line 49: DECODE(X_BETWEEN_CONDITION_BIN_OP,FND_API.G_MISS_NUM,NULL,X_BETWEEN_CONDITION_BIN_OP),

45: DECODE(X_ATTRIBUTE_ID,FND_API.G_MISS_NUM,NULL,X_ATTRIBUTE_ID ),
46: DECODE(X_OPERATION,FND_API.G_MISS_CHAR,NULL,X_OPERATION),
47: DECODE(X_VALUE,FND_API.G_MISS_CHAR,NULL,X_VALUE),
48: DECODE(X_RANK,FND_API.G_MISS_NUM,NULL,X_RANK),
49: DECODE(X_BETWEEN_CONDITION_BIN_OP,FND_API.G_MISS_NUM,NULL,X_BETWEEN_CONDITION_BIN_OP),
50: HZ_UTILITY_V2PUB.REQUEST_ID,
51: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
52: HZ_UTILITY_V2PUB.PROGRAM_ID,
53: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,

Line 59: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),

55: HZ_UTILITY_V2PUB.CREATION_DATE,
56: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
57: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
58: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
59: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
60: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
61: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
62: ) returning MATCH_RULE_SET_CONDITION_ID INTO X_MATCH_RULE_SET_CONDITION_ID;
63:

Line 60: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),

56: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
57: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
58: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
59: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
60: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
61: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
62: ) returning MATCH_RULE_SET_CONDITION_ID INTO X_MATCH_RULE_SET_CONDITION_ID;
63:
64: END Insert_Row;

Line 61: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )

57: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
58: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
59: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
60: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
61: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
62: ) returning MATCH_RULE_SET_CONDITION_ID INTO X_MATCH_RULE_SET_CONDITION_ID;
63:
64: END Insert_Row;
65:

Line 83: /*MATCH_RULE_SET_ID = DECODE( X_MATCH_RULE_SET_ID, NULL, MATCH_RULE_SET_ID,FND_API.G_MISS_NUM,

79: X_APPLICATION_ID IN NUMBER
80: ) IS
81: BEGIN
82: UPDATE HZ_MATCH_RULE_CONDITIONS SET
83: /*MATCH_RULE_SET_ID = DECODE( X_MATCH_RULE_SET_ID, NULL, MATCH_RULE_SET_ID,FND_API.G_MISS_NUM,
84: NULL,MATCH_RULE_SET_ID),
85: */
86: CONDITION_MATCH_RULE_ID = DECODE(X_CONDITION_MATCH_RULE_ID,NULL,CONDITION_MATCH_RULE_ID,
87: FND_API.G_MISS_NUM,NULL,X_CONDITION_MATCH_RULE_ID),

Line 87: FND_API.G_MISS_NUM,NULL,X_CONDITION_MATCH_RULE_ID),

83: /*MATCH_RULE_SET_ID = DECODE( X_MATCH_RULE_SET_ID, NULL, MATCH_RULE_SET_ID,FND_API.G_MISS_NUM,
84: NULL,MATCH_RULE_SET_ID),
85: */
86: CONDITION_MATCH_RULE_ID = DECODE(X_CONDITION_MATCH_RULE_ID,NULL,CONDITION_MATCH_RULE_ID,
87: FND_API.G_MISS_NUM,NULL,X_CONDITION_MATCH_RULE_ID),
88: ATTRIBUTE_ID = DECODE(X_ATTRIBUTE_ID,NULL,ATTRIBUTE_ID,FND_API.G_MISS_NUM,NULL,
89: X_ATTRIBUTE_ID),
90: OPERATION = DECODE(X_OPERATION,NULL,OPERATION,FND_API.G_MISS_CHAR,NULL,X_OPERATION),
91: VALUE = DECODE(X_VALUE,NULL,VALUE,FND_API.G_MISS_CHAR,NULL,X_VALUE),

Line 88: ATTRIBUTE_ID = DECODE(X_ATTRIBUTE_ID,NULL,ATTRIBUTE_ID,FND_API.G_MISS_NUM,NULL,

84: NULL,MATCH_RULE_SET_ID),
85: */
86: CONDITION_MATCH_RULE_ID = DECODE(X_CONDITION_MATCH_RULE_ID,NULL,CONDITION_MATCH_RULE_ID,
87: FND_API.G_MISS_NUM,NULL,X_CONDITION_MATCH_RULE_ID),
88: ATTRIBUTE_ID = DECODE(X_ATTRIBUTE_ID,NULL,ATTRIBUTE_ID,FND_API.G_MISS_NUM,NULL,
89: X_ATTRIBUTE_ID),
90: OPERATION = DECODE(X_OPERATION,NULL,OPERATION,FND_API.G_MISS_CHAR,NULL,X_OPERATION),
91: VALUE = DECODE(X_VALUE,NULL,VALUE,FND_API.G_MISS_CHAR,NULL,X_VALUE),
92: RANK = DECODE(X_RANK,NULL,RANK,FND_API.G_MISS_NUM,NULL,X_RANK),

Line 90: OPERATION = DECODE(X_OPERATION,NULL,OPERATION,FND_API.G_MISS_CHAR,NULL,X_OPERATION),

86: CONDITION_MATCH_RULE_ID = DECODE(X_CONDITION_MATCH_RULE_ID,NULL,CONDITION_MATCH_RULE_ID,
87: FND_API.G_MISS_NUM,NULL,X_CONDITION_MATCH_RULE_ID),
88: ATTRIBUTE_ID = DECODE(X_ATTRIBUTE_ID,NULL,ATTRIBUTE_ID,FND_API.G_MISS_NUM,NULL,
89: X_ATTRIBUTE_ID),
90: OPERATION = DECODE(X_OPERATION,NULL,OPERATION,FND_API.G_MISS_CHAR,NULL,X_OPERATION),
91: VALUE = DECODE(X_VALUE,NULL,VALUE,FND_API.G_MISS_CHAR,NULL,X_VALUE),
92: RANK = DECODE(X_RANK,NULL,RANK,FND_API.G_MISS_NUM,NULL,X_RANK),
93: BETWEEN_CONDITION_BIN_OP = DECODE(X_BETWEEN_CONDITION_BIN_OP,NULL,BETWEEN_CONDITION_BIN_OP,
94: FND_API.G_MISS_CHAR,NULL,X_BETWEEN_CONDITION_BIN_OP),

Line 91: VALUE = DECODE(X_VALUE,NULL,VALUE,FND_API.G_MISS_CHAR,NULL,X_VALUE),

87: FND_API.G_MISS_NUM,NULL,X_CONDITION_MATCH_RULE_ID),
88: ATTRIBUTE_ID = DECODE(X_ATTRIBUTE_ID,NULL,ATTRIBUTE_ID,FND_API.G_MISS_NUM,NULL,
89: X_ATTRIBUTE_ID),
90: OPERATION = DECODE(X_OPERATION,NULL,OPERATION,FND_API.G_MISS_CHAR,NULL,X_OPERATION),
91: VALUE = DECODE(X_VALUE,NULL,VALUE,FND_API.G_MISS_CHAR,NULL,X_VALUE),
92: RANK = DECODE(X_RANK,NULL,RANK,FND_API.G_MISS_NUM,NULL,X_RANK),
93: BETWEEN_CONDITION_BIN_OP = DECODE(X_BETWEEN_CONDITION_BIN_OP,NULL,BETWEEN_CONDITION_BIN_OP,
94: FND_API.G_MISS_CHAR,NULL,X_BETWEEN_CONDITION_BIN_OP),
95: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

Line 92: RANK = DECODE(X_RANK,NULL,RANK,FND_API.G_MISS_NUM,NULL,X_RANK),

88: ATTRIBUTE_ID = DECODE(X_ATTRIBUTE_ID,NULL,ATTRIBUTE_ID,FND_API.G_MISS_NUM,NULL,
89: X_ATTRIBUTE_ID),
90: OPERATION = DECODE(X_OPERATION,NULL,OPERATION,FND_API.G_MISS_CHAR,NULL,X_OPERATION),
91: VALUE = DECODE(X_VALUE,NULL,VALUE,FND_API.G_MISS_CHAR,NULL,X_VALUE),
92: RANK = DECODE(X_RANK,NULL,RANK,FND_API.G_MISS_NUM,NULL,X_RANK),
93: BETWEEN_CONDITION_BIN_OP = DECODE(X_BETWEEN_CONDITION_BIN_OP,NULL,BETWEEN_CONDITION_BIN_OP,
94: FND_API.G_MISS_CHAR,NULL,X_BETWEEN_CONDITION_BIN_OP),
95: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
96: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

Line 94: FND_API.G_MISS_CHAR,NULL,X_BETWEEN_CONDITION_BIN_OP),

90: OPERATION = DECODE(X_OPERATION,NULL,OPERATION,FND_API.G_MISS_CHAR,NULL,X_OPERATION),
91: VALUE = DECODE(X_VALUE,NULL,VALUE,FND_API.G_MISS_CHAR,NULL,X_VALUE),
92: RANK = DECODE(X_RANK,NULL,RANK,FND_API.G_MISS_NUM,NULL,X_RANK),
93: BETWEEN_CONDITION_BIN_OP = DECODE(X_BETWEEN_CONDITION_BIN_OP,NULL,BETWEEN_CONDITION_BIN_OP,
94: FND_API.G_MISS_CHAR,NULL,X_BETWEEN_CONDITION_BIN_OP),
95: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
96: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
97: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
98: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,

Line 102: OBJECT_VERSION_NUMBER = DECODE(X_OBJECT_VERSION_NUMBER,NULL,OBJECT_VERSION_NUMBER,FND_API.G_MISS_NUM,NULL,X_OBJECT_VERSION_NUMBER),

98: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
99: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
100: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
101: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
102: OBJECT_VERSION_NUMBER = DECODE(X_OBJECT_VERSION_NUMBER,NULL,OBJECT_VERSION_NUMBER,FND_API.G_MISS_NUM,NULL,X_OBJECT_VERSION_NUMBER),
103: CREATED_BY_MODULE = DECODE(X_CREATED_BY_MODULE,NULL,CREATED_BY_MODULE,FND_API.G_MISS_CHAR,
104: NULL,X_CREATED_BY_MODULE),
105: APPLICATION_ID = DECODE(X_APPLICATION_ID,NULL,APPLICATION_ID,FND_API.G_MISS_NUM,NULL,X_APPLICATION_ID)
106: WHERE MATCH_RULE_SET_CONDITION_ID=X_MATCH_RULE_SET_CONDITION_ID;

Line 103: CREATED_BY_MODULE = DECODE(X_CREATED_BY_MODULE,NULL,CREATED_BY_MODULE,FND_API.G_MISS_CHAR,

99: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
100: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
101: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
102: OBJECT_VERSION_NUMBER = DECODE(X_OBJECT_VERSION_NUMBER,NULL,OBJECT_VERSION_NUMBER,FND_API.G_MISS_NUM,NULL,X_OBJECT_VERSION_NUMBER),
103: CREATED_BY_MODULE = DECODE(X_CREATED_BY_MODULE,NULL,CREATED_BY_MODULE,FND_API.G_MISS_CHAR,
104: NULL,X_CREATED_BY_MODULE),
105: APPLICATION_ID = DECODE(X_APPLICATION_ID,NULL,APPLICATION_ID,FND_API.G_MISS_NUM,NULL,X_APPLICATION_ID)
106: WHERE MATCH_RULE_SET_CONDITION_ID=X_MATCH_RULE_SET_CONDITION_ID;
107:

Line 105: APPLICATION_ID = DECODE(X_APPLICATION_ID,NULL,APPLICATION_ID,FND_API.G_MISS_NUM,NULL,X_APPLICATION_ID)

101: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
102: OBJECT_VERSION_NUMBER = DECODE(X_OBJECT_VERSION_NUMBER,NULL,OBJECT_VERSION_NUMBER,FND_API.G_MISS_NUM,NULL,X_OBJECT_VERSION_NUMBER),
103: CREATED_BY_MODULE = DECODE(X_CREATED_BY_MODULE,NULL,CREATED_BY_MODULE,FND_API.G_MISS_CHAR,
104: NULL,X_CREATED_BY_MODULE),
105: APPLICATION_ID = DECODE(X_APPLICATION_ID,NULL,APPLICATION_ID,FND_API.G_MISS_NUM,NULL,X_APPLICATION_ID)
106: WHERE MATCH_RULE_SET_CONDITION_ID=X_MATCH_RULE_SET_CONDITION_ID;
107:
108: IF ( SQL%NOTFOUND ) THEN
109: RAISE NO_DATA_FOUND;