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

Line 59: DECODE( px_item_id, FND_API.g_miss_num, NULL, px_item_id),

55: last_update_login,
56: object_version_number,
57: rule_id
58: ) VALUES (
59: DECODE( px_item_id, FND_API.g_miss_num, NULL, px_item_id),
60: DECODE( p_list_source_type_id, FND_API.g_miss_num, NULL, p_list_source_type_id),
61: DECODE( p_list_source_field_id, FND_API.g_miss_num, NULL, p_list_source_field_id),
62: DECODE( p_source_type_code, FND_API.g_miss_char, NULL, p_source_type_code),
63: DECODE( p_source_column_name, FND_API.g_miss_char, NULL, p_source_column_name),

Line 60: DECODE( p_list_source_type_id, FND_API.g_miss_num, NULL, p_list_source_type_id),

56: object_version_number,
57: rule_id
58: ) VALUES (
59: DECODE( px_item_id, FND_API.g_miss_num, NULL, px_item_id),
60: DECODE( p_list_source_type_id, FND_API.g_miss_num, NULL, p_list_source_type_id),
61: DECODE( p_list_source_field_id, FND_API.g_miss_num, NULL, p_list_source_field_id),
62: DECODE( p_source_type_code, FND_API.g_miss_char, NULL, p_source_type_code),
63: DECODE( p_source_column_name, FND_API.g_miss_char, NULL, p_source_column_name),
64: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),

Line 61: DECODE( p_list_source_field_id, FND_API.g_miss_num, NULL, p_list_source_field_id),

57: rule_id
58: ) VALUES (
59: DECODE( px_item_id, FND_API.g_miss_num, NULL, px_item_id),
60: DECODE( p_list_source_type_id, FND_API.g_miss_num, NULL, p_list_source_type_id),
61: DECODE( p_list_source_field_id, FND_API.g_miss_num, NULL, p_list_source_field_id),
62: DECODE( p_source_type_code, FND_API.g_miss_char, NULL, p_source_type_code),
63: DECODE( p_source_column_name, FND_API.g_miss_char, NULL, p_source_column_name),
64: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
65: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),

Line 62: DECODE( p_source_type_code, FND_API.g_miss_char, NULL, p_source_type_code),

58: ) VALUES (
59: DECODE( px_item_id, FND_API.g_miss_num, NULL, px_item_id),
60: DECODE( p_list_source_type_id, FND_API.g_miss_num, NULL, p_list_source_type_id),
61: DECODE( p_list_source_field_id, FND_API.g_miss_num, NULL, p_list_source_field_id),
62: DECODE( p_source_type_code, FND_API.g_miss_char, NULL, p_source_type_code),
63: DECODE( p_source_column_name, FND_API.g_miss_char, NULL, p_source_column_name),
64: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
65: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
66: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),

Line 63: DECODE( p_source_column_name, FND_API.g_miss_char, NULL, p_source_column_name),

59: DECODE( px_item_id, FND_API.g_miss_num, NULL, px_item_id),
60: DECODE( p_list_source_type_id, FND_API.g_miss_num, NULL, p_list_source_type_id),
61: DECODE( p_list_source_field_id, FND_API.g_miss_num, NULL, p_list_source_field_id),
62: DECODE( p_source_type_code, FND_API.g_miss_char, NULL, p_source_type_code),
63: DECODE( p_source_column_name, FND_API.g_miss_char, NULL, p_source_column_name),
64: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
65: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
66: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
67: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),

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

60: DECODE( p_list_source_type_id, FND_API.g_miss_num, NULL, p_list_source_type_id),
61: DECODE( p_list_source_field_id, FND_API.g_miss_num, NULL, p_list_source_field_id),
62: DECODE( p_source_type_code, FND_API.g_miss_char, NULL, p_source_type_code),
63: DECODE( p_source_column_name, FND_API.g_miss_char, NULL, p_source_column_name),
64: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
65: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
66: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
67: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
68: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

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

61: DECODE( p_list_source_field_id, FND_API.g_miss_num, NULL, p_list_source_field_id),
62: DECODE( p_source_type_code, FND_API.g_miss_char, NULL, p_source_type_code),
63: DECODE( p_source_column_name, FND_API.g_miss_char, NULL, p_source_column_name),
64: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
65: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
66: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
67: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
68: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
69: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),

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

62: DECODE( p_source_type_code, FND_API.g_miss_char, NULL, p_source_type_code),
63: DECODE( p_source_column_name, FND_API.g_miss_char, NULL, p_source_column_name),
64: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
65: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
66: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
67: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
68: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
69: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
70: DECODE( p_rule_id, FND_API.g_miss_num, NULL, p_rule_id));

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

63: DECODE( p_source_column_name, FND_API.g_miss_char, NULL, p_source_column_name),
64: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
65: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
66: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
67: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
68: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
69: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
70: DECODE( p_rule_id, FND_API.g_miss_num, NULL, p_rule_id));
71: END Insert_Row;

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

64: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
65: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
66: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
67: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
68: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
69: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
70: DECODE( p_rule_id, FND_API.g_miss_num, NULL, p_rule_id));
71: END Insert_Row;
72:

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

65: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
66: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
67: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
68: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
69: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
70: DECODE( p_rule_id, FND_API.g_miss_num, NULL, p_rule_id));
71: END Insert_Row;
72:
73: -- ========================================================

Line 70: DECODE( p_rule_id, FND_API.g_miss_num, NULL, p_rule_id));

66: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
67: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
68: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
69: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
70: DECODE( p_rule_id, FND_API.g_miss_num, NULL, p_rule_id));
71: END Insert_Row;
72:
73: -- ========================================================
74: PROCEDURE Update_Row(

Line 90: item_id = DECODE( p_item_id, FND_API.g_miss_num, item_id, p_item_id),

86: IS
87: BEGIN
88: Update AMS_DLG_IDENTIFY_ITEMS
89: SET
90: item_id = DECODE( p_item_id, FND_API.g_miss_num, item_id, p_item_id),
91: list_source_type_id = DECODE( p_list_source_type_id, FND_API.g_miss_num, list_source_type_id, p_list_source_type_id),
92: list_source_field_id = DECODE( p_list_source_field_id, FND_API.g_miss_num, list_source_field_id, p_list_source_field_id),
93: source_type_code = DECODE( p_source_type_code, FND_API.g_miss_char, source_type_code, p_source_type_code),
94: source_column_name = DECODE( p_source_column_name, FND_API.g_miss_char, source_column_name, p_source_column_name),

Line 91: list_source_type_id = DECODE( p_list_source_type_id, FND_API.g_miss_num, list_source_type_id, p_list_source_type_id),

87: BEGIN
88: Update AMS_DLG_IDENTIFY_ITEMS
89: SET
90: item_id = DECODE( p_item_id, FND_API.g_miss_num, item_id, p_item_id),
91: list_source_type_id = DECODE( p_list_source_type_id, FND_API.g_miss_num, list_source_type_id, p_list_source_type_id),
92: list_source_field_id = DECODE( p_list_source_field_id, FND_API.g_miss_num, list_source_field_id, p_list_source_field_id),
93: source_type_code = DECODE( p_source_type_code, FND_API.g_miss_char, source_type_code, p_source_type_code),
94: source_column_name = DECODE( p_source_column_name, FND_API.g_miss_char, source_column_name, p_source_column_name),
95: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),

Line 92: list_source_field_id = DECODE( p_list_source_field_id, FND_API.g_miss_num, list_source_field_id, p_list_source_field_id),

88: Update AMS_DLG_IDENTIFY_ITEMS
89: SET
90: item_id = DECODE( p_item_id, FND_API.g_miss_num, item_id, p_item_id),
91: list_source_type_id = DECODE( p_list_source_type_id, FND_API.g_miss_num, list_source_type_id, p_list_source_type_id),
92: list_source_field_id = DECODE( p_list_source_field_id, FND_API.g_miss_num, list_source_field_id, p_list_source_field_id),
93: source_type_code = DECODE( p_source_type_code, FND_API.g_miss_char, source_type_code, p_source_type_code),
94: source_column_name = DECODE( p_source_column_name, FND_API.g_miss_char, source_column_name, p_source_column_name),
95: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
96: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

Line 93: source_type_code = DECODE( p_source_type_code, FND_API.g_miss_char, source_type_code, p_source_type_code),

89: SET
90: item_id = DECODE( p_item_id, FND_API.g_miss_num, item_id, p_item_id),
91: list_source_type_id = DECODE( p_list_source_type_id, FND_API.g_miss_num, list_source_type_id, p_list_source_type_id),
92: list_source_field_id = DECODE( p_list_source_field_id, FND_API.g_miss_num, list_source_field_id, p_list_source_field_id),
93: source_type_code = DECODE( p_source_type_code, FND_API.g_miss_char, source_type_code, p_source_type_code),
94: source_column_name = DECODE( p_source_column_name, FND_API.g_miss_char, source_column_name, p_source_column_name),
95: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
96: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
97: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

Line 94: source_column_name = DECODE( p_source_column_name, FND_API.g_miss_char, source_column_name, p_source_column_name),

90: item_id = DECODE( p_item_id, FND_API.g_miss_num, item_id, p_item_id),
91: list_source_type_id = DECODE( p_list_source_type_id, FND_API.g_miss_num, list_source_type_id, p_list_source_type_id),
92: list_source_field_id = DECODE( p_list_source_field_id, FND_API.g_miss_num, list_source_field_id, p_list_source_field_id),
93: source_type_code = DECODE( p_source_type_code, FND_API.g_miss_char, source_type_code, p_source_type_code),
94: source_column_name = DECODE( p_source_column_name, FND_API.g_miss_char, source_column_name, p_source_column_name),
95: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
96: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
97: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
98: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),

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

91: list_source_type_id = DECODE( p_list_source_type_id, FND_API.g_miss_num, list_source_type_id, p_list_source_type_id),
92: list_source_field_id = DECODE( p_list_source_field_id, FND_API.g_miss_num, list_source_field_id, p_list_source_field_id),
93: source_type_code = DECODE( p_source_type_code, FND_API.g_miss_char, source_type_code, p_source_type_code),
94: source_column_name = DECODE( p_source_column_name, FND_API.g_miss_char, source_column_name, p_source_column_name),
95: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
96: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
97: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
98: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
99: rule_id = DECODE( p_rule_id, FND_API.g_miss_num, rule_id, p_rule_id)

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

92: list_source_field_id = DECODE( p_list_source_field_id, FND_API.g_miss_num, list_source_field_id, p_list_source_field_id),
93: source_type_code = DECODE( p_source_type_code, FND_API.g_miss_char, source_type_code, p_source_type_code),
94: source_column_name = DECODE( p_source_column_name, FND_API.g_miss_char, source_column_name, p_source_column_name),
95: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
96: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
97: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
98: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
99: rule_id = DECODE( p_rule_id, FND_API.g_miss_num, rule_id, p_rule_id)
100: WHERE ITEM_ID = p_ITEM_ID

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

93: source_type_code = DECODE( p_source_type_code, FND_API.g_miss_char, source_type_code, p_source_type_code),
94: source_column_name = DECODE( p_source_column_name, FND_API.g_miss_char, source_column_name, p_source_column_name),
95: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
96: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
97: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
98: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
99: rule_id = DECODE( p_rule_id, FND_API.g_miss_num, rule_id, p_rule_id)
100: WHERE ITEM_ID = p_ITEM_ID
101: AND object_version_number = p_object_version_number;

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

94: source_column_name = DECODE( p_source_column_name, FND_API.g_miss_char, source_column_name, p_source_column_name),
95: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
96: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
97: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
98: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
99: rule_id = DECODE( p_rule_id, FND_API.g_miss_num, rule_id, p_rule_id)
100: WHERE ITEM_ID = p_ITEM_ID
101: AND object_version_number = p_object_version_number;
102:

Line 99: rule_id = DECODE( p_rule_id, FND_API.g_miss_num, rule_id, p_rule_id)

95: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
96: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
97: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
98: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
99: rule_id = DECODE( p_rule_id, FND_API.g_miss_num, rule_id, p_rule_id)
100: WHERE ITEM_ID = p_ITEM_ID
101: AND object_version_number = p_object_version_number;
102:
103: IF (SQL%NOTFOUND) THEN

Line 104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

100: WHERE ITEM_ID = p_ITEM_ID
101: AND object_version_number = p_object_version_number;
102:
103: IF (SQL%NOTFOUND) THEN
104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
105: END IF;
106: END Update_Row;
107:
108: -- ========================================================

Line 116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

112: BEGIN
113: DELETE FROM AMS_DLG_IDENTIFY_ITEMS
114: WHERE ITEM_ID = p_ITEM_ID;
115: If (SQL%NOTFOUND) then
116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
117: End If;
118: END Delete_Row ;
119: -- ========================================================
120: PROCEDURE load_row (