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

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

73: last_update_date,
74: last_update_login,
75: object_version_number
76: ) VALUES (
77: DECODE( px_page_parameter_id, FND_API.g_miss_num, NULL, px_page_parameter_id),
78: DECODE( p_page_id, FND_API.g_miss_num, NULL, p_page_id),
79: DECODE( p_site_ref_code, FND_API.g_miss_char, NULL, p_site_ref_code),
80: DECODE( p_page_ref_code, FND_API.g_miss_char, NULL, p_page_ref_code),
81: DECODE( p_parameter_id, FND_API.g_miss_num, NULL, p_parameter_id),

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

74: last_update_login,
75: object_version_number
76: ) VALUES (
77: DECODE( px_page_parameter_id, FND_API.g_miss_num, NULL, px_page_parameter_id),
78: DECODE( p_page_id, FND_API.g_miss_num, NULL, p_page_id),
79: DECODE( p_site_ref_code, FND_API.g_miss_char, NULL, p_site_ref_code),
80: DECODE( p_page_ref_code, FND_API.g_miss_char, NULL, p_page_ref_code),
81: DECODE( p_parameter_id, FND_API.g_miss_num, NULL, p_parameter_id),
82: DECODE( p_parameter_ref_code, FND_API.g_miss_char, NULL, p_parameter_ref_code),

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

75: object_version_number
76: ) VALUES (
77: DECODE( px_page_parameter_id, FND_API.g_miss_num, NULL, px_page_parameter_id),
78: DECODE( p_page_id, FND_API.g_miss_num, NULL, p_page_id),
79: DECODE( p_site_ref_code, FND_API.g_miss_char, NULL, p_site_ref_code),
80: DECODE( p_page_ref_code, FND_API.g_miss_char, NULL, p_page_ref_code),
81: DECODE( p_parameter_id, FND_API.g_miss_num, NULL, p_parameter_id),
82: DECODE( p_parameter_ref_code, FND_API.g_miss_char, NULL, p_parameter_ref_code),
83: DECODE( p_execution_order, FND_API.g_miss_num, NULL, p_execution_order),

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

76: ) VALUES (
77: DECODE( px_page_parameter_id, FND_API.g_miss_num, NULL, px_page_parameter_id),
78: DECODE( p_page_id, FND_API.g_miss_num, NULL, p_page_id),
79: DECODE( p_site_ref_code, FND_API.g_miss_char, NULL, p_site_ref_code),
80: DECODE( p_page_ref_code, FND_API.g_miss_char, NULL, p_page_ref_code),
81: DECODE( p_parameter_id, FND_API.g_miss_num, NULL, p_parameter_id),
82: DECODE( p_parameter_ref_code, FND_API.g_miss_char, NULL, p_parameter_ref_code),
83: DECODE( p_execution_order, FND_API.g_miss_num, NULL, p_execution_order),
84: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),

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

77: DECODE( px_page_parameter_id, FND_API.g_miss_num, NULL, px_page_parameter_id),
78: DECODE( p_page_id, FND_API.g_miss_num, NULL, p_page_id),
79: DECODE( p_site_ref_code, FND_API.g_miss_char, NULL, p_site_ref_code),
80: DECODE( p_page_ref_code, FND_API.g_miss_char, NULL, p_page_ref_code),
81: DECODE( p_parameter_id, FND_API.g_miss_num, NULL, p_parameter_id),
82: DECODE( p_parameter_ref_code, FND_API.g_miss_char, NULL, p_parameter_ref_code),
83: DECODE( p_execution_order, FND_API.g_miss_num, NULL, p_execution_order),
84: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
85: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),

Line 82: DECODE( p_parameter_ref_code, FND_API.g_miss_char, NULL, p_parameter_ref_code),

78: DECODE( p_page_id, FND_API.g_miss_num, NULL, p_page_id),
79: DECODE( p_site_ref_code, FND_API.g_miss_char, NULL, p_site_ref_code),
80: DECODE( p_page_ref_code, FND_API.g_miss_char, NULL, p_page_ref_code),
81: DECODE( p_parameter_id, FND_API.g_miss_num, NULL, p_parameter_id),
82: DECODE( p_parameter_ref_code, FND_API.g_miss_char, NULL, p_parameter_ref_code),
83: DECODE( p_execution_order, FND_API.g_miss_num, NULL, p_execution_order),
84: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
85: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
86: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),

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

79: DECODE( p_site_ref_code, FND_API.g_miss_char, NULL, p_site_ref_code),
80: DECODE( p_page_ref_code, FND_API.g_miss_char, NULL, p_page_ref_code),
81: DECODE( p_parameter_id, FND_API.g_miss_num, NULL, p_parameter_id),
82: DECODE( p_parameter_ref_code, FND_API.g_miss_char, NULL, p_parameter_ref_code),
83: DECODE( p_execution_order, FND_API.g_miss_num, NULL, p_execution_order),
84: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
85: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
86: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
87: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),

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

80: DECODE( p_page_ref_code, FND_API.g_miss_char, NULL, p_page_ref_code),
81: DECODE( p_parameter_id, FND_API.g_miss_num, NULL, p_parameter_id),
82: DECODE( p_parameter_ref_code, FND_API.g_miss_char, NULL, p_parameter_ref_code),
83: DECODE( p_execution_order, FND_API.g_miss_num, NULL, p_execution_order),
84: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
85: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
86: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
87: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
88: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

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

81: DECODE( p_parameter_id, FND_API.g_miss_num, NULL, p_parameter_id),
82: DECODE( p_parameter_ref_code, FND_API.g_miss_char, NULL, p_parameter_ref_code),
83: DECODE( p_execution_order, FND_API.g_miss_num, NULL, p_execution_order),
84: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
85: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
86: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
87: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
88: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
89: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));

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

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

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

83: DECODE( p_execution_order, FND_API.g_miss_num, NULL, p_execution_order),
84: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
85: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
86: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
87: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
88: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
89: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));
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_created_by, FND_API.g_miss_num, NULL, p_created_by),
85: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
86: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
87: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
88: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
89: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));
90: END Insert_Row;
91:
92:

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

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

Line 128: page_id = DECODE( p_page_id, FND_API.g_miss_num, page_id, p_page_id),

124: IS
125: BEGIN
126: Update AMS_IBA_PL_PG_PARAMS
127: SET
128: page_id = DECODE( p_page_id, FND_API.g_miss_num, page_id, p_page_id),
129: site_ref_code = DECODE( p_site_ref_code, FND_API.g_miss_char, site_ref_code, p_site_ref_code),
130: page_ref_code = DECODE( p_page_ref_code, FND_API.g_miss_char, page_ref_code, p_page_ref_code),
131: parameter_id = DECODE( p_parameter_id, FND_API.g_miss_num, parameter_id, p_parameter_id),
132: parameter_ref_code = DECODE( p_parameter_ref_code, FND_API.g_miss_char, parameter_ref_code, p_parameter_ref_code),

Line 129: site_ref_code = DECODE( p_site_ref_code, FND_API.g_miss_char, site_ref_code, p_site_ref_code),

125: BEGIN
126: Update AMS_IBA_PL_PG_PARAMS
127: SET
128: page_id = DECODE( p_page_id, FND_API.g_miss_num, page_id, p_page_id),
129: site_ref_code = DECODE( p_site_ref_code, FND_API.g_miss_char, site_ref_code, p_site_ref_code),
130: page_ref_code = DECODE( p_page_ref_code, FND_API.g_miss_char, page_ref_code, p_page_ref_code),
131: parameter_id = DECODE( p_parameter_id, FND_API.g_miss_num, parameter_id, p_parameter_id),
132: parameter_ref_code = DECODE( p_parameter_ref_code, FND_API.g_miss_char, parameter_ref_code, p_parameter_ref_code),
133: execution_order = DECODE( p_execution_order, FND_API.g_miss_num, execution_order, p_execution_order),

Line 130: page_ref_code = DECODE( p_page_ref_code, FND_API.g_miss_char, page_ref_code, p_page_ref_code),

126: Update AMS_IBA_PL_PG_PARAMS
127: SET
128: page_id = DECODE( p_page_id, FND_API.g_miss_num, page_id, p_page_id),
129: site_ref_code = DECODE( p_site_ref_code, FND_API.g_miss_char, site_ref_code, p_site_ref_code),
130: page_ref_code = DECODE( p_page_ref_code, FND_API.g_miss_char, page_ref_code, p_page_ref_code),
131: parameter_id = DECODE( p_parameter_id, FND_API.g_miss_num, parameter_id, p_parameter_id),
132: parameter_ref_code = DECODE( p_parameter_ref_code, FND_API.g_miss_char, parameter_ref_code, p_parameter_ref_code),
133: execution_order = DECODE( p_execution_order, FND_API.g_miss_num, execution_order, p_execution_order),
134: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

Line 131: parameter_id = DECODE( p_parameter_id, FND_API.g_miss_num, parameter_id, p_parameter_id),

127: SET
128: page_id = DECODE( p_page_id, FND_API.g_miss_num, page_id, p_page_id),
129: site_ref_code = DECODE( p_site_ref_code, FND_API.g_miss_char, site_ref_code, p_site_ref_code),
130: page_ref_code = DECODE( p_page_ref_code, FND_API.g_miss_char, page_ref_code, p_page_ref_code),
131: parameter_id = DECODE( p_parameter_id, FND_API.g_miss_num, parameter_id, p_parameter_id),
132: parameter_ref_code = DECODE( p_parameter_ref_code, FND_API.g_miss_char, parameter_ref_code, p_parameter_ref_code),
133: execution_order = DECODE( p_execution_order, FND_API.g_miss_num, execution_order, p_execution_order),
134: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
135: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),

Line 132: parameter_ref_code = DECODE( p_parameter_ref_code, FND_API.g_miss_char, parameter_ref_code, p_parameter_ref_code),

128: page_id = DECODE( p_page_id, FND_API.g_miss_num, page_id, p_page_id),
129: site_ref_code = DECODE( p_site_ref_code, FND_API.g_miss_char, site_ref_code, p_site_ref_code),
130: page_ref_code = DECODE( p_page_ref_code, FND_API.g_miss_char, page_ref_code, p_page_ref_code),
131: parameter_id = DECODE( p_parameter_id, FND_API.g_miss_num, parameter_id, p_parameter_id),
132: parameter_ref_code = DECODE( p_parameter_ref_code, FND_API.g_miss_char, parameter_ref_code, p_parameter_ref_code),
133: execution_order = DECODE( p_execution_order, FND_API.g_miss_num, execution_order, p_execution_order),
134: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
135: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
136: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

Line 133: execution_order = DECODE( p_execution_order, FND_API.g_miss_num, execution_order, p_execution_order),

129: site_ref_code = DECODE( p_site_ref_code, FND_API.g_miss_char, site_ref_code, p_site_ref_code),
130: page_ref_code = DECODE( p_page_ref_code, FND_API.g_miss_char, page_ref_code, p_page_ref_code),
131: parameter_id = DECODE( p_parameter_id, FND_API.g_miss_num, parameter_id, p_parameter_id),
132: parameter_ref_code = DECODE( p_parameter_ref_code, FND_API.g_miss_char, parameter_ref_code, p_parameter_ref_code),
133: execution_order = DECODE( p_execution_order, FND_API.g_miss_num, execution_order, p_execution_order),
134: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
135: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
136: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
137: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number)

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

130: page_ref_code = DECODE( p_page_ref_code, FND_API.g_miss_char, page_ref_code, p_page_ref_code),
131: parameter_id = DECODE( p_parameter_id, FND_API.g_miss_num, parameter_id, p_parameter_id),
132: parameter_ref_code = DECODE( p_parameter_ref_code, FND_API.g_miss_char, parameter_ref_code, p_parameter_ref_code),
133: execution_order = DECODE( p_execution_order, FND_API.g_miss_num, execution_order, p_execution_order),
134: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
135: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
136: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
137: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number)
138: WHERE PAGE_PARAMETER_ID = p_PAGE_PARAMETER_ID

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

131: parameter_id = DECODE( p_parameter_id, FND_API.g_miss_num, parameter_id, p_parameter_id),
132: parameter_ref_code = DECODE( p_parameter_ref_code, FND_API.g_miss_char, parameter_ref_code, p_parameter_ref_code),
133: execution_order = DECODE( p_execution_order, FND_API.g_miss_num, execution_order, p_execution_order),
134: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
135: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
136: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
137: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number)
138: WHERE PAGE_PARAMETER_ID = p_PAGE_PARAMETER_ID
139: AND object_version_number = p_object_version_number;

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

132: parameter_ref_code = DECODE( p_parameter_ref_code, FND_API.g_miss_char, parameter_ref_code, p_parameter_ref_code),
133: execution_order = DECODE( p_execution_order, FND_API.g_miss_num, execution_order, p_execution_order),
134: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
135: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
136: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
137: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number)
138: WHERE PAGE_PARAMETER_ID = p_PAGE_PARAMETER_ID
139: AND object_version_number = p_object_version_number;
140:

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

133: execution_order = DECODE( p_execution_order, FND_API.g_miss_num, execution_order, p_execution_order),
134: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
135: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
136: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
137: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number)
138: WHERE PAGE_PARAMETER_ID = p_PAGE_PARAMETER_ID
139: AND object_version_number = p_object_version_number;
140:
141: IF (SQL%NOTFOUND) THEN

Line 142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

138: WHERE PAGE_PARAMETER_ID = p_PAGE_PARAMETER_ID
139: AND object_version_number = p_object_version_number;
140:
141: IF (SQL%NOTFOUND) THEN
142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
143: END IF;
144: END Update_Row;
145:
146:

Line 170: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

166: BEGIN
167: DELETE FROM AMS_IBA_PL_PG_PARAMS
168: WHERE PAGE_PARAMETER_ID = p_PAGE_PARAMETER_ID;
169: If (SQL%NOTFOUND) then
170: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
171: End If;
172: END Delete_Row ;
173:
174: