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_SCHEDULER_B_PKG dependencies on FND_API

Line 79: DECODE( px_scheduler_id, FND_API.g_miss_num, NULL, px_scheduler_id)

75: object_id,
76: frequency,
77: frequency_type
78: ) VALUES (
79: DECODE( px_scheduler_id, FND_API.g_miss_num, NULL, px_scheduler_id)
80: , DECODE( p_created_by, FND_API.g_miss_num, 1, p_created_by)
81: , DECODE( p_creation_date, FND_API.g_miss_date, sysdate, p_creation_date)
82: , DECODE( p_last_updated_by, FND_API.g_miss_num, 1, p_last_updated_by)
83: , DECODE( p_last_update_date, FND_API.g_miss_date, sysdate, l_last_update_date)

Line 80: , DECODE( p_created_by, FND_API.g_miss_num, 1, p_created_by)

76: frequency,
77: frequency_type
78: ) VALUES (
79: DECODE( px_scheduler_id, FND_API.g_miss_num, NULL, px_scheduler_id)
80: , DECODE( p_created_by, FND_API.g_miss_num, 1, p_created_by)
81: , DECODE( p_creation_date, FND_API.g_miss_date, sysdate, p_creation_date)
82: , DECODE( p_last_updated_by, FND_API.g_miss_num, 1, p_last_updated_by)
83: , DECODE( p_last_update_date, FND_API.g_miss_date, sysdate, l_last_update_date)
84: , DECODE( p_last_update_login, FND_API.g_miss_num, 1, p_last_update_login)

Line 81: , DECODE( p_creation_date, FND_API.g_miss_date, sysdate, p_creation_date)

77: frequency_type
78: ) VALUES (
79: DECODE( px_scheduler_id, FND_API.g_miss_num, NULL, px_scheduler_id)
80: , DECODE( p_created_by, FND_API.g_miss_num, 1, p_created_by)
81: , DECODE( p_creation_date, FND_API.g_miss_date, sysdate, p_creation_date)
82: , DECODE( p_last_updated_by, FND_API.g_miss_num, 1, p_last_updated_by)
83: , DECODE( p_last_update_date, FND_API.g_miss_date, sysdate, l_last_update_date)
84: , DECODE( p_last_update_login, FND_API.g_miss_num, 1, p_last_update_login)
85: , DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number)

Line 82: , DECODE( p_last_updated_by, FND_API.g_miss_num, 1, p_last_updated_by)

78: ) VALUES (
79: DECODE( px_scheduler_id, FND_API.g_miss_num, NULL, px_scheduler_id)
80: , DECODE( p_created_by, FND_API.g_miss_num, 1, p_created_by)
81: , DECODE( p_creation_date, FND_API.g_miss_date, sysdate, p_creation_date)
82: , DECODE( p_last_updated_by, FND_API.g_miss_num, 1, p_last_updated_by)
83: , DECODE( p_last_update_date, FND_API.g_miss_date, sysdate, l_last_update_date)
84: , DECODE( p_last_update_login, FND_API.g_miss_num, 1, p_last_update_login)
85: , DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number)
86: , DECODE( p_object_type, FND_API.g_miss_char, NULL, p_object_type)

Line 83: , DECODE( p_last_update_date, FND_API.g_miss_date, sysdate, l_last_update_date)

79: DECODE( px_scheduler_id, FND_API.g_miss_num, NULL, px_scheduler_id)
80: , DECODE( p_created_by, FND_API.g_miss_num, 1, p_created_by)
81: , DECODE( p_creation_date, FND_API.g_miss_date, sysdate, p_creation_date)
82: , DECODE( p_last_updated_by, FND_API.g_miss_num, 1, p_last_updated_by)
83: , DECODE( p_last_update_date, FND_API.g_miss_date, sysdate, l_last_update_date)
84: , DECODE( p_last_update_login, FND_API.g_miss_num, 1, p_last_update_login)
85: , DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number)
86: , DECODE( p_object_type, FND_API.g_miss_char, NULL, p_object_type)
87: , DECODE( p_object_id, FND_API.g_miss_num, NULL, p_object_id)

Line 84: , DECODE( p_last_update_login, FND_API.g_miss_num, 1, p_last_update_login)

80: , DECODE( p_created_by, FND_API.g_miss_num, 1, p_created_by)
81: , DECODE( p_creation_date, FND_API.g_miss_date, sysdate, p_creation_date)
82: , DECODE( p_last_updated_by, FND_API.g_miss_num, 1, p_last_updated_by)
83: , DECODE( p_last_update_date, FND_API.g_miss_date, sysdate, l_last_update_date)
84: , DECODE( p_last_update_login, FND_API.g_miss_num, 1, p_last_update_login)
85: , DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number)
86: , DECODE( p_object_type, FND_API.g_miss_char, NULL, p_object_type)
87: , DECODE( p_object_id, FND_API.g_miss_num, NULL, p_object_id)
88: , DECODE( p_frequency, FND_API.g_miss_num, NULL, p_frequency)

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

81: , DECODE( p_creation_date, FND_API.g_miss_date, sysdate, p_creation_date)
82: , DECODE( p_last_updated_by, FND_API.g_miss_num, 1, p_last_updated_by)
83: , DECODE( p_last_update_date, FND_API.g_miss_date, sysdate, l_last_update_date)
84: , DECODE( p_last_update_login, FND_API.g_miss_num, 1, p_last_update_login)
85: , DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number)
86: , DECODE( p_object_type, FND_API.g_miss_char, NULL, p_object_type)
87: , DECODE( p_object_id, FND_API.g_miss_num, NULL, p_object_id)
88: , DECODE( p_frequency, FND_API.g_miss_num, NULL, p_frequency)
89: , DECODE( p_frequency_type, FND_API.g_miss_char, NULL, p_frequency_type)

Line 86: , DECODE( p_object_type, FND_API.g_miss_char, NULL, p_object_type)

82: , DECODE( p_last_updated_by, FND_API.g_miss_num, 1, p_last_updated_by)
83: , DECODE( p_last_update_date, FND_API.g_miss_date, sysdate, l_last_update_date)
84: , DECODE( p_last_update_login, FND_API.g_miss_num, 1, p_last_update_login)
85: , DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number)
86: , DECODE( p_object_type, FND_API.g_miss_char, NULL, p_object_type)
87: , DECODE( p_object_id, FND_API.g_miss_num, NULL, p_object_id)
88: , DECODE( p_frequency, FND_API.g_miss_num, NULL, p_frequency)
89: , DECODE( p_frequency_type, FND_API.g_miss_char, NULL, p_frequency_type)
90: );

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

83: , DECODE( p_last_update_date, FND_API.g_miss_date, sysdate, l_last_update_date)
84: , DECODE( p_last_update_login, FND_API.g_miss_num, 1, p_last_update_login)
85: , DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number)
86: , DECODE( p_object_type, FND_API.g_miss_char, NULL, p_object_type)
87: , DECODE( p_object_id, FND_API.g_miss_num, NULL, p_object_id)
88: , DECODE( p_frequency, FND_API.g_miss_num, NULL, p_frequency)
89: , DECODE( p_frequency_type, FND_API.g_miss_char, NULL, p_frequency_type)
90: );
91:

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

84: , DECODE( p_last_update_login, FND_API.g_miss_num, 1, p_last_update_login)
85: , DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number)
86: , DECODE( p_object_type, FND_API.g_miss_char, NULL, p_object_type)
87: , DECODE( p_object_id, FND_API.g_miss_num, NULL, p_object_id)
88: , DECODE( p_frequency, FND_API.g_miss_num, NULL, p_frequency)
89: , DECODE( p_frequency_type, FND_API.g_miss_char, NULL, p_frequency_type)
90: );
91:
92:

Line 89: , DECODE( p_frequency_type, FND_API.g_miss_char, NULL, p_frequency_type)

85: , DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number)
86: , DECODE( p_object_type, FND_API.g_miss_char, NULL, p_object_type)
87: , DECODE( p_object_id, FND_API.g_miss_num, NULL, p_object_id)
88: , DECODE( p_frequency, FND_API.g_miss_num, NULL, p_frequency)
89: , DECODE( p_frequency_type, FND_API.g_miss_char, NULL, p_frequency_type)
90: );
91:
92:
93:

Line 123: scheduler_id = DECODE( p_scheduler_id, FND_API.g_miss_num, scheduler_id, p_scheduler_id),

119: IS
120: BEGIN
121: Update AMS_SCHEDULER
122: SET
123: scheduler_id = DECODE( p_scheduler_id, FND_API.g_miss_num, scheduler_id, p_scheduler_id),
124: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
125: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
126: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
127: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),

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

120: BEGIN
121: Update AMS_SCHEDULER
122: SET
123: scheduler_id = DECODE( p_scheduler_id, FND_API.g_miss_num, scheduler_id, p_scheduler_id),
124: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
125: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
126: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
127: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
128: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

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

121: Update AMS_SCHEDULER
122: SET
123: scheduler_id = DECODE( p_scheduler_id, FND_API.g_miss_num, scheduler_id, p_scheduler_id),
124: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
125: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
126: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
127: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
128: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
129: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),

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

122: SET
123: scheduler_id = DECODE( p_scheduler_id, FND_API.g_miss_num, scheduler_id, p_scheduler_id),
124: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
125: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
126: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
127: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
128: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
129: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
130: object_type = DECODE( p_object_type, FND_API.g_miss_char, object_type, p_object_type),

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

123: scheduler_id = DECODE( p_scheduler_id, FND_API.g_miss_num, scheduler_id, p_scheduler_id),
124: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
125: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
126: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
127: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
128: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
129: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
130: object_type = DECODE( p_object_type, FND_API.g_miss_char, object_type, p_object_type),
131: object_id = DECODE( p_object_id, FND_API.g_miss_num, object_id, p_object_id),

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

124: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
125: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
126: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
127: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
128: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
129: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
130: object_type = DECODE( p_object_type, FND_API.g_miss_char, object_type, p_object_type),
131: object_id = DECODE( p_object_id, FND_API.g_miss_num, object_id, p_object_id),
132: frequency = DECODE( p_frequency, FND_API.g_miss_num, frequency, p_frequency),

Line 129: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),

125: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
126: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
127: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
128: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
129: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
130: object_type = DECODE( p_object_type, FND_API.g_miss_char, object_type, p_object_type),
131: object_id = DECODE( p_object_id, FND_API.g_miss_num, object_id, p_object_id),
132: frequency = DECODE( p_frequency, FND_API.g_miss_num, frequency, p_frequency),
133: frequency_type = DECODE( p_frequency_type, FND_API.g_miss_char, frequency_type, p_frequency_type)

Line 130: object_type = DECODE( p_object_type, FND_API.g_miss_char, object_type, p_object_type),

126: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
127: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
128: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
129: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
130: object_type = DECODE( p_object_type, FND_API.g_miss_char, object_type, p_object_type),
131: object_id = DECODE( p_object_id, FND_API.g_miss_num, object_id, p_object_id),
132: frequency = DECODE( p_frequency, FND_API.g_miss_num, frequency, p_frequency),
133: frequency_type = DECODE( p_frequency_type, FND_API.g_miss_char, frequency_type, p_frequency_type)
134: WHERE scheduler_id = p_scheduler_id

Line 131: object_id = DECODE( p_object_id, FND_API.g_miss_num, object_id, p_object_id),

127: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
128: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
129: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
130: object_type = DECODE( p_object_type, FND_API.g_miss_char, object_type, p_object_type),
131: object_id = DECODE( p_object_id, FND_API.g_miss_num, object_id, p_object_id),
132: frequency = DECODE( p_frequency, FND_API.g_miss_num, frequency, p_frequency),
133: frequency_type = DECODE( p_frequency_type, FND_API.g_miss_char, frequency_type, p_frequency_type)
134: WHERE scheduler_id = p_scheduler_id
135: AND object_version_number = p_object_version_number;

Line 132: frequency = DECODE( p_frequency, FND_API.g_miss_num, frequency, p_frequency),

128: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
129: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
130: object_type = DECODE( p_object_type, FND_API.g_miss_char, object_type, p_object_type),
131: object_id = DECODE( p_object_id, FND_API.g_miss_num, object_id, p_object_id),
132: frequency = DECODE( p_frequency, FND_API.g_miss_num, frequency, p_frequency),
133: frequency_type = DECODE( p_frequency_type, FND_API.g_miss_char, frequency_type, p_frequency_type)
134: WHERE scheduler_id = p_scheduler_id
135: AND object_version_number = p_object_version_number;
136:

Line 133: frequency_type = DECODE( p_frequency_type, FND_API.g_miss_char, frequency_type, p_frequency_type)

129: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
130: object_type = DECODE( p_object_type, FND_API.g_miss_char, object_type, p_object_type),
131: object_id = DECODE( p_object_id, FND_API.g_miss_num, object_id, p_object_id),
132: frequency = DECODE( p_frequency, FND_API.g_miss_num, frequency, p_frequency),
133: frequency_type = DECODE( p_frequency_type, FND_API.g_miss_char, frequency_type, p_frequency_type)
134: WHERE scheduler_id = p_scheduler_id
135: AND object_version_number = p_object_version_number;
136:
137:

Line 160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

156: BEGIN
157: DELETE FROM AMS_SCHEDULER
158: WHERE SCHEDULER_ID = p_scheduler_id;
159: If (SQL%NOTFOUND) then
160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
161: END IF;
162:
163: END Delete_Row ;
164: