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

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

65: object_version_number,
66: attribute_id,
67: jtf_auth_principal_id
68: ) VALUES (
69: DECODE( px_attr_principal_id, FND_API.g_miss_num, NULL, px_attr_principal_id),
70: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
71: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
72: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
73: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),

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

66: attribute_id,
67: jtf_auth_principal_id
68: ) VALUES (
69: DECODE( px_attr_principal_id, FND_API.g_miss_num, NULL, px_attr_principal_id),
70: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
71: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
72: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
73: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
74: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

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

67: jtf_auth_principal_id
68: ) VALUES (
69: DECODE( px_attr_principal_id, FND_API.g_miss_num, NULL, px_attr_principal_id),
70: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
71: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
72: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
73: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
74: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
75: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),

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

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

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

69: DECODE( px_attr_principal_id, FND_API.g_miss_num, NULL, px_attr_principal_id),
70: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
71: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
72: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
73: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
74: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
75: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
76: DECODE( p_attribute_id, FND_API.g_miss_num, NULL, p_attribute_id),
77: DECODE( p_jtf_auth_principal_id, FND_API.g_miss_num, NULL, p_jtf_auth_principal_id)

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

70: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
71: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
72: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
73: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
74: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
75: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
76: DECODE( p_attribute_id, FND_API.g_miss_num, NULL, p_attribute_id),
77: DECODE( p_jtf_auth_principal_id, FND_API.g_miss_num, NULL, p_jtf_auth_principal_id)
78: );

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

71: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
72: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
73: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
74: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
75: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
76: DECODE( p_attribute_id, FND_API.g_miss_num, NULL, p_attribute_id),
77: DECODE( p_jtf_auth_principal_id, FND_API.g_miss_num, NULL, p_jtf_auth_principal_id)
78: );
79: END Insert_Row;

Line 76: DECODE( p_attribute_id, FND_API.g_miss_num, NULL, p_attribute_id),

72: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
73: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
74: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
75: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
76: DECODE( p_attribute_id, FND_API.g_miss_num, NULL, p_attribute_id),
77: DECODE( p_jtf_auth_principal_id, FND_API.g_miss_num, NULL, p_jtf_auth_principal_id)
78: );
79: END Insert_Row;
80:

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

73: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
74: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
75: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
76: DECODE( p_attribute_id, FND_API.g_miss_num, NULL, p_attribute_id),
77: DECODE( p_jtf_auth_principal_id, FND_API.g_miss_num, NULL, p_jtf_auth_principal_id)
78: );
79: END Insert_Row;
80:
81:

Line 102: p_creation_date DATE := FND_API.g_miss_date ,

98: PROCEDURE Update_Row(
99: p_attr_principal_id NUMBER,
100: p_last_update_date DATE,
101: p_last_updated_by NUMBER,
102: p_creation_date DATE := FND_API.g_miss_date ,
103: p_created_by NUMBER := FND_API.g_miss_num ,
104: p_last_update_login NUMBER,
105: p_object_version_number NUMBER,
106: p_attribute_id NUMBER,

Line 103: p_created_by NUMBER := FND_API.g_miss_num ,

99: p_attr_principal_id NUMBER,
100: p_last_update_date DATE,
101: p_last_updated_by NUMBER,
102: p_creation_date DATE := FND_API.g_miss_date ,
103: p_created_by NUMBER := FND_API.g_miss_num ,
104: p_last_update_login NUMBER,
105: p_object_version_number NUMBER,
106: p_attribute_id NUMBER,
107: p_jtf_auth_principal_id NUMBER

Line 114: attr_principal_id = DECODE( p_attr_principal_id, FND_API.g_miss_num, attr_principal_id, p_attr_principal_id),

110: IS
111: BEGIN
112: Update PV_ATTR_PRINCIPALS
113: SET
114: attr_principal_id = DECODE( p_attr_principal_id, FND_API.g_miss_num, attr_principal_id, p_attr_principal_id),
115: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
116: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
117: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
118: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),

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

111: BEGIN
112: Update PV_ATTR_PRINCIPALS
113: SET
114: attr_principal_id = DECODE( p_attr_principal_id, FND_API.g_miss_num, attr_principal_id, p_attr_principal_id),
115: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
116: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
117: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
118: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
119: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

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

112: Update PV_ATTR_PRINCIPALS
113: SET
114: attr_principal_id = DECODE( p_attr_principal_id, FND_API.g_miss_num, attr_principal_id, p_attr_principal_id),
115: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
116: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
117: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
118: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
119: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
120: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),

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

113: SET
114: attr_principal_id = DECODE( p_attr_principal_id, FND_API.g_miss_num, attr_principal_id, p_attr_principal_id),
115: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
116: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
117: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
118: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
119: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
120: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
121: attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id),

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

114: attr_principal_id = DECODE( p_attr_principal_id, FND_API.g_miss_num, attr_principal_id, p_attr_principal_id),
115: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
116: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
117: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
118: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
119: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
120: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
121: attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id),
122: jtf_auth_principal_id = DECODE( p_jtf_auth_principal_id, FND_API.g_miss_num, jtf_auth_principal_id, p_jtf_auth_principal_id)

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

115: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
116: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
117: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
118: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
119: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
120: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
121: attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id),
122: jtf_auth_principal_id = DECODE( p_jtf_auth_principal_id, FND_API.g_miss_num, jtf_auth_principal_id, p_jtf_auth_principal_id)
123: WHERE attr_principal_id = p_attr_principal_id

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

116: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
117: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
118: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
119: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
120: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
121: attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id),
122: jtf_auth_principal_id = DECODE( p_jtf_auth_principal_id, FND_API.g_miss_num, jtf_auth_principal_id, p_jtf_auth_principal_id)
123: WHERE attr_principal_id = p_attr_principal_id
124: AND object_version_number = p_object_version_number;

Line 121: attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id),

117: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
118: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
119: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
120: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
121: attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id),
122: jtf_auth_principal_id = DECODE( p_jtf_auth_principal_id, FND_API.g_miss_num, jtf_auth_principal_id, p_jtf_auth_principal_id)
123: WHERE attr_principal_id = p_attr_principal_id
124: AND object_version_number = p_object_version_number;
125:

Line 122: jtf_auth_principal_id = DECODE( p_jtf_auth_principal_id, FND_API.g_miss_num, jtf_auth_principal_id, p_jtf_auth_principal_id)

118: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
119: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
120: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
121: attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id),
122: jtf_auth_principal_id = DECODE( p_jtf_auth_principal_id, FND_API.g_miss_num, jtf_auth_principal_id, p_jtf_auth_principal_id)
123: WHERE attr_principal_id = p_attr_principal_id
124: AND object_version_number = p_object_version_number;
125:
126: IF (SQL%NOTFOUND) THEN

Line 127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

123: WHERE attr_principal_id = p_attr_principal_id
124: AND object_version_number = p_object_version_number;
125:
126: IF (SQL%NOTFOUND) THEN
127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
128: END IF;
129: END Update_Row;
130:
131:

Line 155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

151: BEGIN
152: DELETE FROM PV_ATTR_PRINCIPALS
153: WHERE attr_principal_id = p_attr_principal_id;
154: If (SQL%NOTFOUND) then
155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
156: End If;
157: END Delete_Row ;
158:
159: