eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_CTDS_PKG dependencies on FND_API

Line 77: DECODE( px_ctd_id, FND_API.g_miss_num, NULL, px_ctd_id),

73: created_by,
74: last_update_login,
75: security_group_id
76: ) VALUES (
77: DECODE( px_ctd_id, FND_API.g_miss_num, NULL, px_ctd_id),
78: DECODE( p_action_id, FND_API.g_miss_num, NULL, p_action_id),
79: DECODE( p_forward_url, FND_API.g_miss_char, NULL, p_forward_url),
80: DECODE( p_track_url, FND_API.g_miss_char, NULL, p_track_url),
81: DECODE( p_activity_product_id, FND_API.g_miss_num, NULL, p_activity_product_id),

Line 78: DECODE( p_action_id, FND_API.g_miss_num, NULL, p_action_id),

74: last_update_login,
75: security_group_id
76: ) VALUES (
77: DECODE( px_ctd_id, FND_API.g_miss_num, NULL, px_ctd_id),
78: DECODE( p_action_id, FND_API.g_miss_num, NULL, p_action_id),
79: DECODE( p_forward_url, FND_API.g_miss_char, NULL, p_forward_url),
80: DECODE( p_track_url, FND_API.g_miss_char, NULL, p_track_url),
81: DECODE( p_activity_product_id, FND_API.g_miss_num, NULL, p_activity_product_id),
82: DECODE( p_activity_offer_id, FND_API.g_miss_num, NULL, p_activity_offer_id),

Line 79: DECODE( p_forward_url, FND_API.g_miss_char, NULL, p_forward_url),

75: security_group_id
76: ) VALUES (
77: DECODE( px_ctd_id, FND_API.g_miss_num, NULL, px_ctd_id),
78: DECODE( p_action_id, FND_API.g_miss_num, NULL, p_action_id),
79: DECODE( p_forward_url, FND_API.g_miss_char, NULL, p_forward_url),
80: DECODE( p_track_url, FND_API.g_miss_char, NULL, p_track_url),
81: DECODE( p_activity_product_id, FND_API.g_miss_num, NULL, p_activity_product_id),
82: DECODE( p_activity_offer_id, FND_API.g_miss_num, NULL, p_activity_offer_id),
83: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),

Line 80: DECODE( p_track_url, FND_API.g_miss_char, NULL, p_track_url),

76: ) VALUES (
77: DECODE( px_ctd_id, FND_API.g_miss_num, NULL, px_ctd_id),
78: DECODE( p_action_id, FND_API.g_miss_num, NULL, p_action_id),
79: DECODE( p_forward_url, FND_API.g_miss_char, NULL, p_forward_url),
80: DECODE( p_track_url, FND_API.g_miss_char, NULL, p_track_url),
81: DECODE( p_activity_product_id, FND_API.g_miss_num, NULL, p_activity_product_id),
82: DECODE( p_activity_offer_id, FND_API.g_miss_num, NULL, p_activity_offer_id),
83: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
84: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),

Line 81: DECODE( p_activity_product_id, FND_API.g_miss_num, NULL, p_activity_product_id),

77: DECODE( px_ctd_id, FND_API.g_miss_num, NULL, px_ctd_id),
78: DECODE( p_action_id, FND_API.g_miss_num, NULL, p_action_id),
79: DECODE( p_forward_url, FND_API.g_miss_char, NULL, p_forward_url),
80: DECODE( p_track_url, FND_API.g_miss_char, NULL, p_track_url),
81: DECODE( p_activity_product_id, FND_API.g_miss_num, NULL, p_activity_product_id),
82: DECODE( p_activity_offer_id, FND_API.g_miss_num, NULL, p_activity_offer_id),
83: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
84: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
85: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),

Line 82: DECODE( p_activity_offer_id, FND_API.g_miss_num, NULL, p_activity_offer_id),

78: DECODE( p_action_id, FND_API.g_miss_num, NULL, p_action_id),
79: DECODE( p_forward_url, FND_API.g_miss_char, NULL, p_forward_url),
80: DECODE( p_track_url, FND_API.g_miss_char, NULL, p_track_url),
81: DECODE( p_activity_product_id, FND_API.g_miss_num, NULL, p_activity_product_id),
82: DECODE( p_activity_offer_id, FND_API.g_miss_num, NULL, p_activity_offer_id),
83: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
84: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
85: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
86: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),

Line 83: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),

79: DECODE( p_forward_url, FND_API.g_miss_char, NULL, p_forward_url),
80: DECODE( p_track_url, FND_API.g_miss_char, NULL, p_track_url),
81: DECODE( p_activity_product_id, FND_API.g_miss_num, NULL, p_activity_product_id),
82: DECODE( p_activity_offer_id, FND_API.g_miss_num, NULL, p_activity_offer_id),
83: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
84: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
85: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
86: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
87: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),

Line 84: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),

80: DECODE( p_track_url, FND_API.g_miss_char, NULL, p_track_url),
81: DECODE( p_activity_product_id, FND_API.g_miss_num, NULL, p_activity_product_id),
82: DECODE( p_activity_offer_id, FND_API.g_miss_num, NULL, p_activity_offer_id),
83: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
84: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
85: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
86: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
87: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
88: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

Line 85: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),

81: DECODE( p_activity_product_id, FND_API.g_miss_num, NULL, p_activity_product_id),
82: DECODE( p_activity_offer_id, FND_API.g_miss_num, NULL, p_activity_offer_id),
83: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
84: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
85: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
86: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
87: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
88: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
89: DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id));

Line 86: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),

82: DECODE( p_activity_offer_id, FND_API.g_miss_num, NULL, p_activity_offer_id),
83: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
84: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
85: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
86: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
87: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
88: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
89: DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id));
90: END Insert_Row;

Line 87: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),

83: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
84: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
85: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
86: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
87: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
88: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
89: DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id));
90: END Insert_Row;
91:

Line 88: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

84: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
85: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
86: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
87: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
88: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
89: DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id));
90: END Insert_Row;
91:
92:

Line 89: DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id));

85: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
86: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
87: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
88: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
89: DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id));
90: END Insert_Row;
91:
92:
93: ----------------------------------------------------------

Line 128: ctd_id = DECODE( p_ctd_id, FND_API.g_miss_num, ctd_id, p_ctd_id),

124: IS
125: BEGIN
126: Update AMS_CTDS
127: SET
128: ctd_id = DECODE( p_ctd_id, FND_API.g_miss_num, ctd_id, p_ctd_id),
129: action_id = DECODE( p_action_id, FND_API.g_miss_num, action_id, p_action_id),
130: forward_url = DECODE( p_forward_url, FND_API.g_miss_char, forward_url, p_forward_url),
131: track_url = DECODE( p_track_url, FND_API.g_miss_char, track_url, p_track_url),
132: activity_product_id = DECODE( p_activity_product_id, FND_API.g_miss_num, activity_product_id, p_activity_product_id),

Line 129: action_id = DECODE( p_action_id, FND_API.g_miss_num, action_id, p_action_id),

125: BEGIN
126: Update AMS_CTDS
127: SET
128: ctd_id = DECODE( p_ctd_id, FND_API.g_miss_num, ctd_id, p_ctd_id),
129: action_id = DECODE( p_action_id, FND_API.g_miss_num, action_id, p_action_id),
130: forward_url = DECODE( p_forward_url, FND_API.g_miss_char, forward_url, p_forward_url),
131: track_url = DECODE( p_track_url, FND_API.g_miss_char, track_url, p_track_url),
132: activity_product_id = DECODE( p_activity_product_id, FND_API.g_miss_num, activity_product_id, p_activity_product_id),
133: activity_offer_id = DECODE( p_activity_offer_id, FND_API.g_miss_num, activity_offer_id, p_activity_offer_id),

Line 130: forward_url = DECODE( p_forward_url, FND_API.g_miss_char, forward_url, p_forward_url),

126: Update AMS_CTDS
127: SET
128: ctd_id = DECODE( p_ctd_id, FND_API.g_miss_num, ctd_id, p_ctd_id),
129: action_id = DECODE( p_action_id, FND_API.g_miss_num, action_id, p_action_id),
130: forward_url = DECODE( p_forward_url, FND_API.g_miss_char, forward_url, p_forward_url),
131: track_url = DECODE( p_track_url, FND_API.g_miss_char, track_url, p_track_url),
132: activity_product_id = DECODE( p_activity_product_id, FND_API.g_miss_num, activity_product_id, p_activity_product_id),
133: activity_offer_id = DECODE( p_activity_offer_id, FND_API.g_miss_num, activity_offer_id, p_activity_offer_id),
134: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),

Line 131: track_url = DECODE( p_track_url, FND_API.g_miss_char, track_url, p_track_url),

127: SET
128: ctd_id = DECODE( p_ctd_id, FND_API.g_miss_num, ctd_id, p_ctd_id),
129: action_id = DECODE( p_action_id, FND_API.g_miss_num, action_id, p_action_id),
130: forward_url = DECODE( p_forward_url, FND_API.g_miss_char, forward_url, p_forward_url),
131: track_url = DECODE( p_track_url, FND_API.g_miss_char, track_url, p_track_url),
132: activity_product_id = DECODE( p_activity_product_id, FND_API.g_miss_num, activity_product_id, p_activity_product_id),
133: activity_offer_id = DECODE( p_activity_offer_id, FND_API.g_miss_num, activity_offer_id, p_activity_offer_id),
134: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
135: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),

Line 132: activity_product_id = DECODE( p_activity_product_id, FND_API.g_miss_num, activity_product_id, p_activity_product_id),

128: ctd_id = DECODE( p_ctd_id, FND_API.g_miss_num, ctd_id, p_ctd_id),
129: action_id = DECODE( p_action_id, FND_API.g_miss_num, action_id, p_action_id),
130: forward_url = DECODE( p_forward_url, FND_API.g_miss_char, forward_url, p_forward_url),
131: track_url = DECODE( p_track_url, FND_API.g_miss_char, track_url, p_track_url),
132: activity_product_id = DECODE( p_activity_product_id, FND_API.g_miss_num, activity_product_id, p_activity_product_id),
133: activity_offer_id = DECODE( p_activity_offer_id, FND_API.g_miss_num, activity_offer_id, p_activity_offer_id),
134: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
135: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
136: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

Line 133: activity_offer_id = DECODE( p_activity_offer_id, FND_API.g_miss_num, activity_offer_id, p_activity_offer_id),

129: action_id = DECODE( p_action_id, FND_API.g_miss_num, action_id, p_action_id),
130: forward_url = DECODE( p_forward_url, FND_API.g_miss_char, forward_url, p_forward_url),
131: track_url = DECODE( p_track_url, FND_API.g_miss_char, track_url, p_track_url),
132: activity_product_id = DECODE( p_activity_product_id, FND_API.g_miss_num, activity_product_id, p_activity_product_id),
133: activity_offer_id = DECODE( p_activity_offer_id, FND_API.g_miss_num, activity_offer_id, p_activity_offer_id),
134: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
135: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
136: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
137: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),

Line 134: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),

130: forward_url = DECODE( p_forward_url, FND_API.g_miss_char, forward_url, p_forward_url),
131: track_url = DECODE( p_track_url, FND_API.g_miss_char, track_url, p_track_url),
132: activity_product_id = DECODE( p_activity_product_id, FND_API.g_miss_num, activity_product_id, p_activity_product_id),
133: activity_offer_id = DECODE( p_activity_offer_id, FND_API.g_miss_num, activity_offer_id, p_activity_offer_id),
134: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
135: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
136: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
137: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
138: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),

Line 135: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),

131: track_url = DECODE( p_track_url, FND_API.g_miss_char, track_url, p_track_url),
132: activity_product_id = DECODE( p_activity_product_id, FND_API.g_miss_num, activity_product_id, p_activity_product_id),
133: activity_offer_id = DECODE( p_activity_offer_id, FND_API.g_miss_num, activity_offer_id, p_activity_offer_id),
134: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
135: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
136: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
137: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
138: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
139: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

Line 136: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

132: activity_product_id = DECODE( p_activity_product_id, FND_API.g_miss_num, activity_product_id, p_activity_product_id),
133: activity_offer_id = DECODE( p_activity_offer_id, FND_API.g_miss_num, activity_offer_id, p_activity_offer_id),
134: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
135: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
136: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
137: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
138: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
139: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
140: security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id)

Line 137: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),

133: activity_offer_id = DECODE( p_activity_offer_id, FND_API.g_miss_num, activity_offer_id, p_activity_offer_id),
134: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
135: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
136: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
137: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
138: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
139: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
140: security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id)
141: WHERE CTD_ID = p_CTD_ID

Line 138: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),

134: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
135: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
136: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
137: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
138: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
139: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
140: security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id)
141: WHERE CTD_ID = p_CTD_ID
142: AND object_version_number = p_object_version_number;

Line 139: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

135: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
136: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
137: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
138: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
139: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
140: security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id)
141: WHERE CTD_ID = p_CTD_ID
142: AND object_version_number = p_object_version_number;
143:

Line 140: security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id)

136: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
137: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
138: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
139: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
140: security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id)
141: WHERE CTD_ID = p_CTD_ID
142: AND object_version_number = p_object_version_number;
143:
144: IF (SQL%NOTFOUND) THEN

Line 145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

141: WHERE CTD_ID = p_CTD_ID
142: AND object_version_number = p_object_version_number;
143:
144: IF (SQL%NOTFOUND) THEN
145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
146: END IF;
147: END Update_Row;
148:
149:

Line 173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

169: BEGIN
170: DELETE FROM AMS_CTDS
171: WHERE CTD_ID = p_CTD_ID;
172: If (SQL%NOTFOUND) then
173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
174: End If;
175: END Delete_Row ;
176:
177: