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

Line 74: DECODE( px_mmbr_transition_id, FND_API.G_MISS_NUM, NULL, px_mmbr_transition_id),

70: last_updated_by,
71: last_update_date,
72: last_update_login
73: ) VALUES (
74: DECODE( px_mmbr_transition_id, FND_API.G_MISS_NUM, NULL, px_mmbr_transition_id),
75: DECODE( p_from_membership_id, FND_API.G_MISS_NUM, NULL, p_from_membership_id),
76: DECODE( p_to_membership_id, FND_API.G_MISS_NUM, NULL, p_to_membership_id),
77: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
78: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),

Line 75: DECODE( p_from_membership_id, FND_API.G_MISS_NUM, NULL, p_from_membership_id),

71: last_update_date,
72: last_update_login
73: ) VALUES (
74: DECODE( px_mmbr_transition_id, FND_API.G_MISS_NUM, NULL, px_mmbr_transition_id),
75: DECODE( p_from_membership_id, FND_API.G_MISS_NUM, NULL, p_from_membership_id),
76: DECODE( p_to_membership_id, FND_API.G_MISS_NUM, NULL, p_to_membership_id),
77: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
78: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
79: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),

Line 76: DECODE( p_to_membership_id, FND_API.G_MISS_NUM, NULL, p_to_membership_id),

72: last_update_login
73: ) VALUES (
74: DECODE( px_mmbr_transition_id, FND_API.G_MISS_NUM, NULL, px_mmbr_transition_id),
75: DECODE( p_from_membership_id, FND_API.G_MISS_NUM, NULL, p_from_membership_id),
76: DECODE( p_to_membership_id, FND_API.G_MISS_NUM, NULL, p_to_membership_id),
77: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
78: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
79: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
80: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),

Line 77: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),

73: ) VALUES (
74: DECODE( px_mmbr_transition_id, FND_API.G_MISS_NUM, NULL, px_mmbr_transition_id),
75: DECODE( p_from_membership_id, FND_API.G_MISS_NUM, NULL, p_from_membership_id),
76: DECODE( p_to_membership_id, FND_API.G_MISS_NUM, NULL, p_to_membership_id),
77: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
78: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
79: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
80: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
81: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),

Line 78: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),

74: DECODE( px_mmbr_transition_id, FND_API.G_MISS_NUM, NULL, px_mmbr_transition_id),
75: DECODE( p_from_membership_id, FND_API.G_MISS_NUM, NULL, p_from_membership_id),
76: DECODE( p_to_membership_id, FND_API.G_MISS_NUM, NULL, p_to_membership_id),
77: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
78: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
79: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
80: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
81: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
82: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));

Line 79: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),

75: DECODE( p_from_membership_id, FND_API.G_MISS_NUM, NULL, p_from_membership_id),
76: DECODE( p_to_membership_id, FND_API.G_MISS_NUM, NULL, p_to_membership_id),
77: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
78: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
79: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
80: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
81: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
82: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));
83:

Line 80: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),

76: DECODE( p_to_membership_id, FND_API.G_MISS_NUM, NULL, p_to_membership_id),
77: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
78: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
79: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
80: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
81: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
82: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));
83:
84: END Insert_Row;

Line 81: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),

77: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
78: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
79: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
80: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
81: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
82: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));
83:
84: END Insert_Row;
85:

Line 82: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));

78: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
79: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
80: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
81: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
82: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));
83:
84: END Insert_Row;
85:
86:

Line 114: mmbr_transition_id = DECODE( p_mmbr_transition_id, null, mmbr_transition_id, FND_API.G_MISS_NUM, null, p_mmbr_transition_id),

110: IS
111: BEGIN
112: Update pv_pg_mmbr_transitions
113: SET
114: mmbr_transition_id = DECODE( p_mmbr_transition_id, null, mmbr_transition_id, FND_API.G_MISS_NUM, null, p_mmbr_transition_id),
115: from_membership_id = DECODE( p_from_membership_id, null, from_membership_id, FND_API.G_MISS_NUM, null, p_from_membership_id),
116: to_membership_id = DECODE( p_to_membership_id, null, to_membership_id, FND_API.G_MISS_NUM, null, p_to_membership_id),
117: object_version_number = nvl(p_object_version_number,0) + 1 ,
118: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),

Line 115: from_membership_id = DECODE( p_from_membership_id, null, from_membership_id, FND_API.G_MISS_NUM, null, p_from_membership_id),

111: BEGIN
112: Update pv_pg_mmbr_transitions
113: SET
114: mmbr_transition_id = DECODE( p_mmbr_transition_id, null, mmbr_transition_id, FND_API.G_MISS_NUM, null, p_mmbr_transition_id),
115: from_membership_id = DECODE( p_from_membership_id, null, from_membership_id, FND_API.G_MISS_NUM, null, p_from_membership_id),
116: to_membership_id = DECODE( p_to_membership_id, null, to_membership_id, FND_API.G_MISS_NUM, null, p_to_membership_id),
117: object_version_number = nvl(p_object_version_number,0) + 1 ,
118: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
119: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),

Line 116: to_membership_id = DECODE( p_to_membership_id, null, to_membership_id, FND_API.G_MISS_NUM, null, p_to_membership_id),

112: Update pv_pg_mmbr_transitions
113: SET
114: mmbr_transition_id = DECODE( p_mmbr_transition_id, null, mmbr_transition_id, FND_API.G_MISS_NUM, null, p_mmbr_transition_id),
115: from_membership_id = DECODE( p_from_membership_id, null, from_membership_id, FND_API.G_MISS_NUM, null, p_from_membership_id),
116: to_membership_id = DECODE( p_to_membership_id, null, to_membership_id, FND_API.G_MISS_NUM, null, p_to_membership_id),
117: object_version_number = nvl(p_object_version_number,0) + 1 ,
118: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
119: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
120: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)

Line 118: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),

114: mmbr_transition_id = DECODE( p_mmbr_transition_id, null, mmbr_transition_id, FND_API.G_MISS_NUM, null, p_mmbr_transition_id),
115: from_membership_id = DECODE( p_from_membership_id, null, from_membership_id, FND_API.G_MISS_NUM, null, p_from_membership_id),
116: to_membership_id = DECODE( p_to_membership_id, null, to_membership_id, FND_API.G_MISS_NUM, null, p_to_membership_id),
117: object_version_number = nvl(p_object_version_number,0) + 1 ,
118: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
119: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
120: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
121: WHERE mmbr_transition_id = p_mmbr_transition_id
122: AND object_version_number = p_object_version_number;

Line 119: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),

115: from_membership_id = DECODE( p_from_membership_id, null, from_membership_id, FND_API.G_MISS_NUM, null, p_from_membership_id),
116: to_membership_id = DECODE( p_to_membership_id, null, to_membership_id, FND_API.G_MISS_NUM, null, p_to_membership_id),
117: object_version_number = nvl(p_object_version_number,0) + 1 ,
118: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
119: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
120: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
121: WHERE mmbr_transition_id = p_mmbr_transition_id
122: AND object_version_number = p_object_version_number;
123:

Line 120: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)

116: to_membership_id = DECODE( p_to_membership_id, null, to_membership_id, FND_API.G_MISS_NUM, null, p_to_membership_id),
117: object_version_number = nvl(p_object_version_number,0) + 1 ,
118: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
119: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
120: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
121: WHERE mmbr_transition_id = p_mmbr_transition_id
122: AND object_version_number = p_object_version_number;
123:
124:

Line 126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

152: DELETE FROM pv_pg_mmbr_transitions
153: WHERE mmbr_transition_id = p_mmbr_transition_id
154: AND object_version_number = p_object_version_number;
155: If (SQL%NOTFOUND) then
156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
157: End If;
158: END Delete_Row ;
159:
160:

Line 194: RAISE FND_API.g_exc_error;

190: FETCH c INTO Recinfo;
191: IF (c%NOTFOUND) THEN
192: CLOSE c;
193: AMS_Utility_PVT.error_message ('AMS_API_RECORD_NOT_FOUND');
194: RAISE FND_API.g_exc_error;
195: END IF;
196: CLOSE c;
197: END Lock_Row;
198: