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

Line 82: DECODE( px_entity_approver_id, FND_API.G_MISS_NUM, NULL, px_entity_approver_id),

78: last_updated_by,
79: last_update_date,
80: last_update_login
81: ) VALUES (
82: DECODE( px_entity_approver_id, FND_API.G_MISS_NUM, NULL, px_entity_approver_id),
83: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
84: DECODE( p_arc_appr_for_entity_code, FND_API.g_miss_char, NULL, p_arc_appr_for_entity_code),
85: DECODE( p_appr_for_entity_id, FND_API.G_MISS_NUM, NULL, p_appr_for_entity_id),
86: DECODE( p_approver_id, FND_API.G_MISS_NUM, NULL, p_approver_id),

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

79: last_update_date,
80: last_update_login
81: ) VALUES (
82: DECODE( px_entity_approver_id, FND_API.G_MISS_NUM, NULL, px_entity_approver_id),
83: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
84: DECODE( p_arc_appr_for_entity_code, FND_API.g_miss_char, NULL, p_arc_appr_for_entity_code),
85: DECODE( p_appr_for_entity_id, FND_API.G_MISS_NUM, NULL, p_appr_for_entity_id),
86: DECODE( p_approver_id, FND_API.G_MISS_NUM, NULL, p_approver_id),
87: DECODE( p_approver_type_code, FND_API.g_miss_char, NULL, p_approver_type_code),

Line 84: DECODE( p_arc_appr_for_entity_code, FND_API.g_miss_char, NULL, p_arc_appr_for_entity_code),

80: last_update_login
81: ) VALUES (
82: DECODE( px_entity_approver_id, FND_API.G_MISS_NUM, NULL, px_entity_approver_id),
83: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
84: DECODE( p_arc_appr_for_entity_code, FND_API.g_miss_char, NULL, p_arc_appr_for_entity_code),
85: DECODE( p_appr_for_entity_id, FND_API.G_MISS_NUM, NULL, p_appr_for_entity_id),
86: DECODE( p_approver_id, FND_API.G_MISS_NUM, NULL, p_approver_id),
87: DECODE( p_approver_type_code, FND_API.g_miss_char, NULL, p_approver_type_code),
88: DECODE( p_approval_status_code, FND_API.g_miss_char, NULL, p_approval_status_code),

Line 85: DECODE( p_appr_for_entity_id, FND_API.G_MISS_NUM, NULL, p_appr_for_entity_id),

81: ) VALUES (
82: DECODE( px_entity_approver_id, FND_API.G_MISS_NUM, NULL, px_entity_approver_id),
83: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
84: DECODE( p_arc_appr_for_entity_code, FND_API.g_miss_char, NULL, p_arc_appr_for_entity_code),
85: DECODE( p_appr_for_entity_id, FND_API.G_MISS_NUM, NULL, p_appr_for_entity_id),
86: DECODE( p_approver_id, FND_API.G_MISS_NUM, NULL, p_approver_id),
87: DECODE( p_approver_type_code, FND_API.g_miss_char, NULL, p_approver_type_code),
88: DECODE( p_approval_status_code, FND_API.g_miss_char, NULL, p_approval_status_code),
89: DECODE( p_workflow_item_key, FND_API.g_miss_char, NULL, p_workflow_item_key),

Line 86: DECODE( p_approver_id, FND_API.G_MISS_NUM, NULL, p_approver_id),

82: DECODE( px_entity_approver_id, FND_API.G_MISS_NUM, NULL, px_entity_approver_id),
83: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
84: DECODE( p_arc_appr_for_entity_code, FND_API.g_miss_char, NULL, p_arc_appr_for_entity_code),
85: DECODE( p_appr_for_entity_id, FND_API.G_MISS_NUM, NULL, p_appr_for_entity_id),
86: DECODE( p_approver_id, FND_API.G_MISS_NUM, NULL, p_approver_id),
87: DECODE( p_approver_type_code, FND_API.g_miss_char, NULL, p_approver_type_code),
88: DECODE( p_approval_status_code, FND_API.g_miss_char, NULL, p_approval_status_code),
89: DECODE( p_workflow_item_key, FND_API.g_miss_char, NULL, p_workflow_item_key),
90: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),

Line 87: DECODE( p_approver_type_code, FND_API.g_miss_char, NULL, p_approver_type_code),

83: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
84: DECODE( p_arc_appr_for_entity_code, FND_API.g_miss_char, NULL, p_arc_appr_for_entity_code),
85: DECODE( p_appr_for_entity_id, FND_API.G_MISS_NUM, NULL, p_appr_for_entity_id),
86: DECODE( p_approver_id, FND_API.G_MISS_NUM, NULL, p_approver_id),
87: DECODE( p_approver_type_code, FND_API.g_miss_char, NULL, p_approver_type_code),
88: DECODE( p_approval_status_code, FND_API.g_miss_char, NULL, p_approval_status_code),
89: DECODE( p_workflow_item_key, FND_API.g_miss_char, NULL, p_workflow_item_key),
90: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
91: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),

Line 88: DECODE( p_approval_status_code, FND_API.g_miss_char, NULL, p_approval_status_code),

84: DECODE( p_arc_appr_for_entity_code, FND_API.g_miss_char, NULL, p_arc_appr_for_entity_code),
85: DECODE( p_appr_for_entity_id, FND_API.G_MISS_NUM, NULL, p_appr_for_entity_id),
86: DECODE( p_approver_id, FND_API.G_MISS_NUM, NULL, p_approver_id),
87: DECODE( p_approver_type_code, FND_API.g_miss_char, NULL, p_approver_type_code),
88: DECODE( p_approval_status_code, FND_API.g_miss_char, NULL, p_approval_status_code),
89: DECODE( p_workflow_item_key, FND_API.g_miss_char, NULL, p_workflow_item_key),
90: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
91: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
92: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),

Line 89: DECODE( p_workflow_item_key, FND_API.g_miss_char, NULL, p_workflow_item_key),

85: DECODE( p_appr_for_entity_id, FND_API.G_MISS_NUM, NULL, p_appr_for_entity_id),
86: DECODE( p_approver_id, FND_API.G_MISS_NUM, NULL, p_approver_id),
87: DECODE( p_approver_type_code, FND_API.g_miss_char, NULL, p_approver_type_code),
88: DECODE( p_approval_status_code, FND_API.g_miss_char, NULL, p_approval_status_code),
89: DECODE( p_workflow_item_key, FND_API.g_miss_char, NULL, p_workflow_item_key),
90: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
91: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
92: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
93: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),

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

86: DECODE( p_approver_id, FND_API.G_MISS_NUM, NULL, p_approver_id),
87: DECODE( p_approver_type_code, FND_API.g_miss_char, NULL, p_approver_type_code),
88: DECODE( p_approval_status_code, FND_API.g_miss_char, NULL, p_approval_status_code),
89: DECODE( p_workflow_item_key, FND_API.g_miss_char, NULL, p_workflow_item_key),
90: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
91: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
92: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
93: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
94: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));

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

87: DECODE( p_approver_type_code, FND_API.g_miss_char, NULL, p_approver_type_code),
88: DECODE( p_approval_status_code, FND_API.g_miss_char, NULL, p_approval_status_code),
89: DECODE( p_workflow_item_key, FND_API.g_miss_char, NULL, p_workflow_item_key),
90: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
91: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
92: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
93: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
94: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));
95:

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

88: DECODE( p_approval_status_code, FND_API.g_miss_char, NULL, p_approval_status_code),
89: DECODE( p_workflow_item_key, FND_API.g_miss_char, NULL, p_workflow_item_key),
90: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
91: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
92: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
93: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
94: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));
95:
96: END Insert_Row;

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

89: DECODE( p_workflow_item_key, FND_API.g_miss_char, NULL, p_workflow_item_key),
90: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
91: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
92: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
93: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
94: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));
95:
96: END Insert_Row;
97:

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

90: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
91: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
92: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
93: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
94: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));
95:
96: END Insert_Row;
97:
98:

Line 130: entity_approver_id = DECODE( p_entity_approver_id, null, entity_approver_id, FND_API.G_MISS_NUM, null, p_entity_approver_id),

126: IS
127: BEGIN
128: Update pv_ge_temp_approvers
129: SET
130: entity_approver_id = DECODE( p_entity_approver_id, null, entity_approver_id, FND_API.G_MISS_NUM, null, p_entity_approver_id),
131: object_version_number = nvl(p_object_version_number,0) + 1 ,
132: arc_appr_for_entity_code = DECODE( p_arc_appr_for_entity_code, null, arc_appr_for_entity_code, FND_API.g_miss_char, null, p_arc_appr_for_entity_code),
133: appr_for_entity_id = DECODE( p_appr_for_entity_id, null, appr_for_entity_id, FND_API.G_MISS_NUM, null, p_appr_for_entity_id),
134: approver_id = DECODE( p_approver_id, null, approver_id, FND_API.G_MISS_NUM, null, p_approver_id),

Line 132: arc_appr_for_entity_code = DECODE( p_arc_appr_for_entity_code, null, arc_appr_for_entity_code, FND_API.g_miss_char, null, p_arc_appr_for_entity_code),

128: Update pv_ge_temp_approvers
129: SET
130: entity_approver_id = DECODE( p_entity_approver_id, null, entity_approver_id, FND_API.G_MISS_NUM, null, p_entity_approver_id),
131: object_version_number = nvl(p_object_version_number,0) + 1 ,
132: arc_appr_for_entity_code = DECODE( p_arc_appr_for_entity_code, null, arc_appr_for_entity_code, FND_API.g_miss_char, null, p_arc_appr_for_entity_code),
133: appr_for_entity_id = DECODE( p_appr_for_entity_id, null, appr_for_entity_id, FND_API.G_MISS_NUM, null, p_appr_for_entity_id),
134: approver_id = DECODE( p_approver_id, null, approver_id, FND_API.G_MISS_NUM, null, p_approver_id),
135: approver_type_code = DECODE( p_approver_type_code, null, approver_type_code, FND_API.g_miss_char, null, p_approver_type_code),
136: approval_status_code = DECODE( p_approval_status_code, null, approval_status_code, FND_API.g_miss_char, null, p_approval_status_code),

Line 133: appr_for_entity_id = DECODE( p_appr_for_entity_id, null, appr_for_entity_id, FND_API.G_MISS_NUM, null, p_appr_for_entity_id),

129: SET
130: entity_approver_id = DECODE( p_entity_approver_id, null, entity_approver_id, FND_API.G_MISS_NUM, null, p_entity_approver_id),
131: object_version_number = nvl(p_object_version_number,0) + 1 ,
132: arc_appr_for_entity_code = DECODE( p_arc_appr_for_entity_code, null, arc_appr_for_entity_code, FND_API.g_miss_char, null, p_arc_appr_for_entity_code),
133: appr_for_entity_id = DECODE( p_appr_for_entity_id, null, appr_for_entity_id, FND_API.G_MISS_NUM, null, p_appr_for_entity_id),
134: approver_id = DECODE( p_approver_id, null, approver_id, FND_API.G_MISS_NUM, null, p_approver_id),
135: approver_type_code = DECODE( p_approver_type_code, null, approver_type_code, FND_API.g_miss_char, null, p_approver_type_code),
136: approval_status_code = DECODE( p_approval_status_code, null, approval_status_code, FND_API.g_miss_char, null, p_approval_status_code),
137: workflow_item_key = DECODE( p_workflow_item_key, null, workflow_item_key, FND_API.g_miss_char, null, p_workflow_item_key),

Line 134: approver_id = DECODE( p_approver_id, null, approver_id, FND_API.G_MISS_NUM, null, p_approver_id),

130: entity_approver_id = DECODE( p_entity_approver_id, null, entity_approver_id, FND_API.G_MISS_NUM, null, p_entity_approver_id),
131: object_version_number = nvl(p_object_version_number,0) + 1 ,
132: arc_appr_for_entity_code = DECODE( p_arc_appr_for_entity_code, null, arc_appr_for_entity_code, FND_API.g_miss_char, null, p_arc_appr_for_entity_code),
133: appr_for_entity_id = DECODE( p_appr_for_entity_id, null, appr_for_entity_id, FND_API.G_MISS_NUM, null, p_appr_for_entity_id),
134: approver_id = DECODE( p_approver_id, null, approver_id, FND_API.G_MISS_NUM, null, p_approver_id),
135: approver_type_code = DECODE( p_approver_type_code, null, approver_type_code, FND_API.g_miss_char, null, p_approver_type_code),
136: approval_status_code = DECODE( p_approval_status_code, null, approval_status_code, FND_API.g_miss_char, null, p_approval_status_code),
137: workflow_item_key = DECODE( p_workflow_item_key, null, workflow_item_key, FND_API.g_miss_char, null, p_workflow_item_key),
138: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),

Line 135: approver_type_code = DECODE( p_approver_type_code, null, approver_type_code, FND_API.g_miss_char, null, p_approver_type_code),

131: object_version_number = nvl(p_object_version_number,0) + 1 ,
132: arc_appr_for_entity_code = DECODE( p_arc_appr_for_entity_code, null, arc_appr_for_entity_code, FND_API.g_miss_char, null, p_arc_appr_for_entity_code),
133: appr_for_entity_id = DECODE( p_appr_for_entity_id, null, appr_for_entity_id, FND_API.G_MISS_NUM, null, p_appr_for_entity_id),
134: approver_id = DECODE( p_approver_id, null, approver_id, FND_API.G_MISS_NUM, null, p_approver_id),
135: approver_type_code = DECODE( p_approver_type_code, null, approver_type_code, FND_API.g_miss_char, null, p_approver_type_code),
136: approval_status_code = DECODE( p_approval_status_code, null, approval_status_code, FND_API.g_miss_char, null, p_approval_status_code),
137: workflow_item_key = DECODE( p_workflow_item_key, null, workflow_item_key, FND_API.g_miss_char, null, p_workflow_item_key),
138: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
139: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),

Line 136: approval_status_code = DECODE( p_approval_status_code, null, approval_status_code, FND_API.g_miss_char, null, p_approval_status_code),

132: arc_appr_for_entity_code = DECODE( p_arc_appr_for_entity_code, null, arc_appr_for_entity_code, FND_API.g_miss_char, null, p_arc_appr_for_entity_code),
133: appr_for_entity_id = DECODE( p_appr_for_entity_id, null, appr_for_entity_id, FND_API.G_MISS_NUM, null, p_appr_for_entity_id),
134: approver_id = DECODE( p_approver_id, null, approver_id, FND_API.G_MISS_NUM, null, p_approver_id),
135: approver_type_code = DECODE( p_approver_type_code, null, approver_type_code, FND_API.g_miss_char, null, p_approver_type_code),
136: approval_status_code = DECODE( p_approval_status_code, null, approval_status_code, FND_API.g_miss_char, null, p_approval_status_code),
137: workflow_item_key = DECODE( p_workflow_item_key, null, workflow_item_key, FND_API.g_miss_char, null, p_workflow_item_key),
138: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
139: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
140: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)

Line 137: workflow_item_key = DECODE( p_workflow_item_key, null, workflow_item_key, FND_API.g_miss_char, null, p_workflow_item_key),

133: appr_for_entity_id = DECODE( p_appr_for_entity_id, null, appr_for_entity_id, FND_API.G_MISS_NUM, null, p_appr_for_entity_id),
134: approver_id = DECODE( p_approver_id, null, approver_id, FND_API.G_MISS_NUM, null, p_approver_id),
135: approver_type_code = DECODE( p_approver_type_code, null, approver_type_code, FND_API.g_miss_char, null, p_approver_type_code),
136: approval_status_code = DECODE( p_approval_status_code, null, approval_status_code, FND_API.g_miss_char, null, p_approval_status_code),
137: workflow_item_key = DECODE( p_workflow_item_key, null, workflow_item_key, FND_API.g_miss_char, null, p_workflow_item_key),
138: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
139: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
140: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
141: WHERE entity_approver_id = p_entity_approver_id

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

134: approver_id = DECODE( p_approver_id, null, approver_id, FND_API.G_MISS_NUM, null, p_approver_id),
135: approver_type_code = DECODE( p_approver_type_code, null, approver_type_code, FND_API.g_miss_char, null, p_approver_type_code),
136: approval_status_code = DECODE( p_approval_status_code, null, approval_status_code, FND_API.g_miss_char, null, p_approval_status_code),
137: workflow_item_key = DECODE( p_workflow_item_key, null, workflow_item_key, FND_API.g_miss_char, null, p_workflow_item_key),
138: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
139: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
140: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
141: WHERE entity_approver_id = p_entity_approver_id
142: AND object_version_number = p_object_version_number;

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

135: approver_type_code = DECODE( p_approver_type_code, null, approver_type_code, FND_API.g_miss_char, null, p_approver_type_code),
136: approval_status_code = DECODE( p_approval_status_code, null, approval_status_code, FND_API.g_miss_char, null, p_approval_status_code),
137: workflow_item_key = DECODE( p_workflow_item_key, null, workflow_item_key, FND_API.g_miss_char, null, p_workflow_item_key),
138: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
139: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
140: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
141: WHERE entity_approver_id = p_entity_approver_id
142: AND object_version_number = p_object_version_number;
143:

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

136: approval_status_code = DECODE( p_approval_status_code, null, approval_status_code, FND_API.g_miss_char, null, p_approval_status_code),
137: workflow_item_key = DECODE( p_workflow_item_key, null, workflow_item_key, FND_API.g_miss_char, null, p_workflow_item_key),
138: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
139: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
140: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
141: WHERE entity_approver_id = p_entity_approver_id
142: AND object_version_number = p_object_version_number;
143:
144:

Line 176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

172: DELETE FROM pv_ge_temp_approvers
173: WHERE entity_approver_id = p_entity_approver_id
174: AND object_version_number = p_object_version_number;
175: If (SQL%NOTFOUND) then
176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
177: End If;
178: END Delete_Row ;
179:
180:

Line 214: RAISE FND_API.g_exc_error;

210: FETCH c INTO Recinfo;
211: IF (c%NOTFOUND) THEN
212: CLOSE c;
213: AMS_Utility_PVT.error_message ('AMS_API_RECORD_NOT_FOUND');
214: RAISE FND_API.g_exc_error;
215: END IF;
216: CLOSE c;
217: END Lock_Row;
218: