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.PV_ENTY_ATTR_VALIDATIONS_PKG dependencies on FND_API

Line 70: DECODE( px_enty_attr_validation_id, Fnd_Api.g_miss_num, NULL, px_enty_attr_validation_id)

66: VALIDATED_BY_RESOURCE_ID,
67: VALIDATION_DOCUMENT_ID,
68: VALIDATION_NOTE
69: ) VALUES (
70: DECODE( px_enty_attr_validation_id, Fnd_Api.g_miss_num, NULL, px_enty_attr_validation_id)
71: ,DECODE( p_last_update_date, Fnd_Api.g_miss_date, NULL, p_last_update_date)
72: ,DECODE( p_last_updated_by, Fnd_Api.g_miss_num, NULL, p_last_updated_by)
73: ,DECODE( p_creation_date, Fnd_Api.g_miss_date, NULL, p_creation_date)
74: ,DECODE( p_created_by, Fnd_Api.g_miss_num, NULL, p_created_by)

Line 71: ,DECODE( p_last_update_date, Fnd_Api.g_miss_date, NULL, p_last_update_date)

67: VALIDATION_DOCUMENT_ID,
68: VALIDATION_NOTE
69: ) VALUES (
70: DECODE( px_enty_attr_validation_id, Fnd_Api.g_miss_num, NULL, px_enty_attr_validation_id)
71: ,DECODE( p_last_update_date, Fnd_Api.g_miss_date, NULL, p_last_update_date)
72: ,DECODE( p_last_updated_by, Fnd_Api.g_miss_num, NULL, p_last_updated_by)
73: ,DECODE( p_creation_date, Fnd_Api.g_miss_date, NULL, p_creation_date)
74: ,DECODE( p_created_by, Fnd_Api.g_miss_num, NULL, p_created_by)
75: ,DECODE( p_last_update_login, Fnd_Api.g_miss_num, NULL, p_last_update_login)

Line 72: ,DECODE( p_last_updated_by, Fnd_Api.g_miss_num, NULL, p_last_updated_by)

68: VALIDATION_NOTE
69: ) VALUES (
70: DECODE( px_enty_attr_validation_id, Fnd_Api.g_miss_num, NULL, px_enty_attr_validation_id)
71: ,DECODE( p_last_update_date, Fnd_Api.g_miss_date, NULL, p_last_update_date)
72: ,DECODE( p_last_updated_by, Fnd_Api.g_miss_num, NULL, p_last_updated_by)
73: ,DECODE( p_creation_date, Fnd_Api.g_miss_date, NULL, p_creation_date)
74: ,DECODE( p_created_by, Fnd_Api.g_miss_num, NULL, p_created_by)
75: ,DECODE( p_last_update_login, Fnd_Api.g_miss_num, NULL, p_last_update_login)
76: ,DECODE( px_object_version_number, Fnd_Api.g_miss_num, NULL, px_object_version_number)

Line 73: ,DECODE( p_creation_date, Fnd_Api.g_miss_date, NULL, p_creation_date)

69: ) VALUES (
70: DECODE( px_enty_attr_validation_id, Fnd_Api.g_miss_num, NULL, px_enty_attr_validation_id)
71: ,DECODE( p_last_update_date, Fnd_Api.g_miss_date, NULL, p_last_update_date)
72: ,DECODE( p_last_updated_by, Fnd_Api.g_miss_num, NULL, p_last_updated_by)
73: ,DECODE( p_creation_date, Fnd_Api.g_miss_date, NULL, p_creation_date)
74: ,DECODE( p_created_by, Fnd_Api.g_miss_num, NULL, p_created_by)
75: ,DECODE( p_last_update_login, Fnd_Api.g_miss_num, NULL, p_last_update_login)
76: ,DECODE( px_object_version_number, Fnd_Api.g_miss_num, NULL, px_object_version_number)
77: ,DECODE( p_validation_date, Fnd_Api.g_miss_date, NULL, p_validation_date)

Line 74: ,DECODE( p_created_by, Fnd_Api.g_miss_num, NULL, p_created_by)

70: DECODE( px_enty_attr_validation_id, Fnd_Api.g_miss_num, NULL, px_enty_attr_validation_id)
71: ,DECODE( p_last_update_date, Fnd_Api.g_miss_date, NULL, p_last_update_date)
72: ,DECODE( p_last_updated_by, Fnd_Api.g_miss_num, NULL, p_last_updated_by)
73: ,DECODE( p_creation_date, Fnd_Api.g_miss_date, NULL, p_creation_date)
74: ,DECODE( p_created_by, Fnd_Api.g_miss_num, NULL, p_created_by)
75: ,DECODE( p_last_update_login, Fnd_Api.g_miss_num, NULL, p_last_update_login)
76: ,DECODE( px_object_version_number, Fnd_Api.g_miss_num, NULL, px_object_version_number)
77: ,DECODE( p_validation_date, Fnd_Api.g_miss_date, NULL, p_validation_date)
78: ,DECODE( p_validated_by_resource_id, Fnd_Api.g_miss_num, NULL, p_validated_by_resource_id)

Line 75: ,DECODE( p_last_update_login, Fnd_Api.g_miss_num, NULL, p_last_update_login)

71: ,DECODE( p_last_update_date, Fnd_Api.g_miss_date, NULL, p_last_update_date)
72: ,DECODE( p_last_updated_by, Fnd_Api.g_miss_num, NULL, p_last_updated_by)
73: ,DECODE( p_creation_date, Fnd_Api.g_miss_date, NULL, p_creation_date)
74: ,DECODE( p_created_by, Fnd_Api.g_miss_num, NULL, p_created_by)
75: ,DECODE( p_last_update_login, Fnd_Api.g_miss_num, NULL, p_last_update_login)
76: ,DECODE( px_object_version_number, Fnd_Api.g_miss_num, NULL, px_object_version_number)
77: ,DECODE( p_validation_date, Fnd_Api.g_miss_date, NULL, p_validation_date)
78: ,DECODE( p_validated_by_resource_id, Fnd_Api.g_miss_num, NULL, p_validated_by_resource_id)
79: ,DECODE( p_validation_document_id, Fnd_Api.g_miss_num, NULL, p_validation_document_id)

Line 76: ,DECODE( px_object_version_number, Fnd_Api.g_miss_num, NULL, px_object_version_number)

72: ,DECODE( p_last_updated_by, Fnd_Api.g_miss_num, NULL, p_last_updated_by)
73: ,DECODE( p_creation_date, Fnd_Api.g_miss_date, NULL, p_creation_date)
74: ,DECODE( p_created_by, Fnd_Api.g_miss_num, NULL, p_created_by)
75: ,DECODE( p_last_update_login, Fnd_Api.g_miss_num, NULL, p_last_update_login)
76: ,DECODE( px_object_version_number, Fnd_Api.g_miss_num, NULL, px_object_version_number)
77: ,DECODE( p_validation_date, Fnd_Api.g_miss_date, NULL, p_validation_date)
78: ,DECODE( p_validated_by_resource_id, Fnd_Api.g_miss_num, NULL, p_validated_by_resource_id)
79: ,DECODE( p_validation_document_id, Fnd_Api.g_miss_num, NULL, p_validation_document_id)
80: ,DECODE( p_validation_note, Fnd_Api.g_miss_char, NULL, p_validation_note)

Line 77: ,DECODE( p_validation_date, Fnd_Api.g_miss_date, NULL, p_validation_date)

73: ,DECODE( p_creation_date, Fnd_Api.g_miss_date, NULL, p_creation_date)
74: ,DECODE( p_created_by, Fnd_Api.g_miss_num, NULL, p_created_by)
75: ,DECODE( p_last_update_login, Fnd_Api.g_miss_num, NULL, p_last_update_login)
76: ,DECODE( px_object_version_number, Fnd_Api.g_miss_num, NULL, px_object_version_number)
77: ,DECODE( p_validation_date, Fnd_Api.g_miss_date, NULL, p_validation_date)
78: ,DECODE( p_validated_by_resource_id, Fnd_Api.g_miss_num, NULL, p_validated_by_resource_id)
79: ,DECODE( p_validation_document_id, Fnd_Api.g_miss_num, NULL, p_validation_document_id)
80: ,DECODE( p_validation_note, Fnd_Api.g_miss_char, NULL, p_validation_note)
81: );

Line 78: ,DECODE( p_validated_by_resource_id, Fnd_Api.g_miss_num, NULL, p_validated_by_resource_id)

74: ,DECODE( p_created_by, Fnd_Api.g_miss_num, NULL, p_created_by)
75: ,DECODE( p_last_update_login, Fnd_Api.g_miss_num, NULL, p_last_update_login)
76: ,DECODE( px_object_version_number, Fnd_Api.g_miss_num, NULL, px_object_version_number)
77: ,DECODE( p_validation_date, Fnd_Api.g_miss_date, NULL, p_validation_date)
78: ,DECODE( p_validated_by_resource_id, Fnd_Api.g_miss_num, NULL, p_validated_by_resource_id)
79: ,DECODE( p_validation_document_id, Fnd_Api.g_miss_num, NULL, p_validation_document_id)
80: ,DECODE( p_validation_note, Fnd_Api.g_miss_char, NULL, p_validation_note)
81: );
82:

Line 79: ,DECODE( p_validation_document_id, Fnd_Api.g_miss_num, NULL, p_validation_document_id)

75: ,DECODE( p_last_update_login, Fnd_Api.g_miss_num, NULL, p_last_update_login)
76: ,DECODE( px_object_version_number, Fnd_Api.g_miss_num, NULL, px_object_version_number)
77: ,DECODE( p_validation_date, Fnd_Api.g_miss_date, NULL, p_validation_date)
78: ,DECODE( p_validated_by_resource_id, Fnd_Api.g_miss_num, NULL, p_validated_by_resource_id)
79: ,DECODE( p_validation_document_id, Fnd_Api.g_miss_num, NULL, p_validation_document_id)
80: ,DECODE( p_validation_note, Fnd_Api.g_miss_char, NULL, p_validation_note)
81: );
82:
83: END Insert_Row;

Line 80: ,DECODE( p_validation_note, Fnd_Api.g_miss_char, NULL, p_validation_note)

76: ,DECODE( px_object_version_number, Fnd_Api.g_miss_num, NULL, px_object_version_number)
77: ,DECODE( p_validation_date, Fnd_Api.g_miss_date, NULL, p_validation_date)
78: ,DECODE( p_validated_by_resource_id, Fnd_Api.g_miss_num, NULL, p_validated_by_resource_id)
79: ,DECODE( p_validation_document_id, Fnd_Api.g_miss_num, NULL, p_validation_document_id)
80: ,DECODE( p_validation_note, Fnd_Api.g_miss_char, NULL, p_validation_note)
81: );
82:
83: END Insert_Row;
84:

Line 120: validation_id = DECODE( p_enty_attr_validation_id, Fnd_Api.g_miss_num, validation_id, p_enty_attr_validation_id)

116: BEGIN
117:
118: UPDATE PV_ENTY_ATTR_VALIDATIONS
119: SET
120: validation_id = DECODE( p_enty_attr_validation_id, Fnd_Api.g_miss_num, validation_id, p_enty_attr_validation_id)
121: ,last_update_date = DECODE( p_last_update_date, Fnd_Api.g_miss_date, last_update_date, p_last_update_date)
122: ,last_updated_by = DECODE( p_last_updated_by, Fnd_Api.g_miss_num, last_updated_by, p_last_updated_by)
123: ,last_update_login = DECODE( p_last_update_login, Fnd_Api.g_miss_num, last_update_login, p_last_update_login)
124: ,object_version_number = DECODE( p_object_version_number, Fnd_Api.g_miss_num, object_version_number, p_object_version_number+1)

Line 121: ,last_update_date = DECODE( p_last_update_date, Fnd_Api.g_miss_date, last_update_date, p_last_update_date)

117:
118: UPDATE PV_ENTY_ATTR_VALIDATIONS
119: SET
120: validation_id = DECODE( p_enty_attr_validation_id, Fnd_Api.g_miss_num, validation_id, p_enty_attr_validation_id)
121: ,last_update_date = DECODE( p_last_update_date, Fnd_Api.g_miss_date, last_update_date, p_last_update_date)
122: ,last_updated_by = DECODE( p_last_updated_by, Fnd_Api.g_miss_num, last_updated_by, p_last_updated_by)
123: ,last_update_login = DECODE( p_last_update_login, Fnd_Api.g_miss_num, last_update_login, p_last_update_login)
124: ,object_version_number = DECODE( p_object_version_number, Fnd_Api.g_miss_num, object_version_number, p_object_version_number+1)
125: ,validation_date = DECODE( p_validation_date, Fnd_Api.g_miss_date, validation_date, p_validation_date)

Line 122: ,last_updated_by = DECODE( p_last_updated_by, Fnd_Api.g_miss_num, last_updated_by, p_last_updated_by)

118: UPDATE PV_ENTY_ATTR_VALIDATIONS
119: SET
120: validation_id = DECODE( p_enty_attr_validation_id, Fnd_Api.g_miss_num, validation_id, p_enty_attr_validation_id)
121: ,last_update_date = DECODE( p_last_update_date, Fnd_Api.g_miss_date, last_update_date, p_last_update_date)
122: ,last_updated_by = DECODE( p_last_updated_by, Fnd_Api.g_miss_num, last_updated_by, p_last_updated_by)
123: ,last_update_login = DECODE( p_last_update_login, Fnd_Api.g_miss_num, last_update_login, p_last_update_login)
124: ,object_version_number = DECODE( p_object_version_number, Fnd_Api.g_miss_num, object_version_number, p_object_version_number+1)
125: ,validation_date = DECODE( p_validation_date, Fnd_Api.g_miss_date, validation_date, p_validation_date)
126: ,validated_by_resource_id = DECODE( p_validated_by_resource_id, Fnd_Api.g_miss_num, validated_by_resource_id, p_validated_by_resource_id)

Line 123: ,last_update_login = DECODE( p_last_update_login, Fnd_Api.g_miss_num, last_update_login, p_last_update_login)

119: SET
120: validation_id = DECODE( p_enty_attr_validation_id, Fnd_Api.g_miss_num, validation_id, p_enty_attr_validation_id)
121: ,last_update_date = DECODE( p_last_update_date, Fnd_Api.g_miss_date, last_update_date, p_last_update_date)
122: ,last_updated_by = DECODE( p_last_updated_by, Fnd_Api.g_miss_num, last_updated_by, p_last_updated_by)
123: ,last_update_login = DECODE( p_last_update_login, Fnd_Api.g_miss_num, last_update_login, p_last_update_login)
124: ,object_version_number = DECODE( p_object_version_number, Fnd_Api.g_miss_num, object_version_number, p_object_version_number+1)
125: ,validation_date = DECODE( p_validation_date, Fnd_Api.g_miss_date, validation_date, p_validation_date)
126: ,validated_by_resource_id = DECODE( p_validated_by_resource_id, Fnd_Api.g_miss_num, validated_by_resource_id, p_validated_by_resource_id)
127: ,validation_document_id = DECODE( p_validation_document_id, Fnd_Api.g_miss_num, validation_document_id, p_validation_document_id)

Line 124: ,object_version_number = DECODE( p_object_version_number, Fnd_Api.g_miss_num, object_version_number, p_object_version_number+1)

120: validation_id = DECODE( p_enty_attr_validation_id, Fnd_Api.g_miss_num, validation_id, p_enty_attr_validation_id)
121: ,last_update_date = DECODE( p_last_update_date, Fnd_Api.g_miss_date, last_update_date, p_last_update_date)
122: ,last_updated_by = DECODE( p_last_updated_by, Fnd_Api.g_miss_num, last_updated_by, p_last_updated_by)
123: ,last_update_login = DECODE( p_last_update_login, Fnd_Api.g_miss_num, last_update_login, p_last_update_login)
124: ,object_version_number = DECODE( p_object_version_number, Fnd_Api.g_miss_num, object_version_number, p_object_version_number+1)
125: ,validation_date = DECODE( p_validation_date, Fnd_Api.g_miss_date, validation_date, p_validation_date)
126: ,validated_by_resource_id = DECODE( p_validated_by_resource_id, Fnd_Api.g_miss_num, validated_by_resource_id, p_validated_by_resource_id)
127: ,validation_document_id = DECODE( p_validation_document_id, Fnd_Api.g_miss_num, validation_document_id, p_validation_document_id)
128: ,validation_note = DECODE( p_validation_note, Fnd_Api.g_miss_char, validation_note, p_validation_note)

Line 125: ,validation_date = DECODE( p_validation_date, Fnd_Api.g_miss_date, validation_date, p_validation_date)

121: ,last_update_date = DECODE( p_last_update_date, Fnd_Api.g_miss_date, last_update_date, p_last_update_date)
122: ,last_updated_by = DECODE( p_last_updated_by, Fnd_Api.g_miss_num, last_updated_by, p_last_updated_by)
123: ,last_update_login = DECODE( p_last_update_login, Fnd_Api.g_miss_num, last_update_login, p_last_update_login)
124: ,object_version_number = DECODE( p_object_version_number, Fnd_Api.g_miss_num, object_version_number, p_object_version_number+1)
125: ,validation_date = DECODE( p_validation_date, Fnd_Api.g_miss_date, validation_date, p_validation_date)
126: ,validated_by_resource_id = DECODE( p_validated_by_resource_id, Fnd_Api.g_miss_num, validated_by_resource_id, p_validated_by_resource_id)
127: ,validation_document_id = DECODE( p_validation_document_id, Fnd_Api.g_miss_num, validation_document_id, p_validation_document_id)
128: ,validation_note = DECODE( p_validation_note, Fnd_Api.g_miss_char, validation_note, p_validation_note)
129:

Line 126: ,validated_by_resource_id = DECODE( p_validated_by_resource_id, Fnd_Api.g_miss_num, validated_by_resource_id, p_validated_by_resource_id)

122: ,last_updated_by = DECODE( p_last_updated_by, Fnd_Api.g_miss_num, last_updated_by, p_last_updated_by)
123: ,last_update_login = DECODE( p_last_update_login, Fnd_Api.g_miss_num, last_update_login, p_last_update_login)
124: ,object_version_number = DECODE( p_object_version_number, Fnd_Api.g_miss_num, object_version_number, p_object_version_number+1)
125: ,validation_date = DECODE( p_validation_date, Fnd_Api.g_miss_date, validation_date, p_validation_date)
126: ,validated_by_resource_id = DECODE( p_validated_by_resource_id, Fnd_Api.g_miss_num, validated_by_resource_id, p_validated_by_resource_id)
127: ,validation_document_id = DECODE( p_validation_document_id, Fnd_Api.g_miss_num, validation_document_id, p_validation_document_id)
128: ,validation_note = DECODE( p_validation_note, Fnd_Api.g_miss_char, validation_note, p_validation_note)
129:
130: WHERE VALIDATION_ID = P_ENTY_ATTR_VALIDATION_ID

Line 127: ,validation_document_id = DECODE( p_validation_document_id, Fnd_Api.g_miss_num, validation_document_id, p_validation_document_id)

123: ,last_update_login = DECODE( p_last_update_login, Fnd_Api.g_miss_num, last_update_login, p_last_update_login)
124: ,object_version_number = DECODE( p_object_version_number, Fnd_Api.g_miss_num, object_version_number, p_object_version_number+1)
125: ,validation_date = DECODE( p_validation_date, Fnd_Api.g_miss_date, validation_date, p_validation_date)
126: ,validated_by_resource_id = DECODE( p_validated_by_resource_id, Fnd_Api.g_miss_num, validated_by_resource_id, p_validated_by_resource_id)
127: ,validation_document_id = DECODE( p_validation_document_id, Fnd_Api.g_miss_num, validation_document_id, p_validation_document_id)
128: ,validation_note = DECODE( p_validation_note, Fnd_Api.g_miss_char, validation_note, p_validation_note)
129:
130: WHERE VALIDATION_ID = P_ENTY_ATTR_VALIDATION_ID
131: AND object_version_number = p_object_version_number;

Line 128: ,validation_note = DECODE( p_validation_note, Fnd_Api.g_miss_char, validation_note, p_validation_note)

124: ,object_version_number = DECODE( p_object_version_number, Fnd_Api.g_miss_num, object_version_number, p_object_version_number+1)
125: ,validation_date = DECODE( p_validation_date, Fnd_Api.g_miss_date, validation_date, p_validation_date)
126: ,validated_by_resource_id = DECODE( p_validated_by_resource_id, Fnd_Api.g_miss_num, validated_by_resource_id, p_validated_by_resource_id)
127: ,validation_document_id = DECODE( p_validation_document_id, Fnd_Api.g_miss_num, validation_document_id, p_validation_document_id)
128: ,validation_note = DECODE( p_validation_note, Fnd_Api.g_miss_char, validation_note, p_validation_note)
129:
130: WHERE VALIDATION_ID = P_ENTY_ATTR_VALIDATION_ID
131: AND object_version_number = p_object_version_number;
132:

Line 134: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

130: WHERE VALIDATION_ID = P_ENTY_ATTR_VALIDATION_ID
131: AND object_version_number = p_object_version_number;
132:
133: IF (SQL%NOTFOUND) THEN
134: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
135: END IF;
136:
137: END Update_Row;
138:

Line 166: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

162: DELETE FROM PV_ENTY_ATTR_VALIDATIONS
163: WHERE validation_id = p_enty_attr_validation_id;
164:
165: IF (SQL%NOTFOUND) THEN
166: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
167: END IF;
168:
169: END Delete_Row ;
170: