DBA Data[Home] [Help]

APPS.PV_AME_API_W dependencies on PV_GE_TEMP_APPROVERS_S

Line 232: * then that approver must be removed from pv_ge_temp_approvers so that he/she is not added

228:
229:
230: /**
231: * This loop makes sure that if an approver from AME already exists in pv_ge_temp_approvers
232: * then that approver must be removed from pv_ge_temp_approvers so that he/she is not added
233: * again into the table.
234: */
235: FOR l_prior_appr IN lc_prior_approvers
236: LOOP

Line 281: pv_ge_temp_approvers_s.NEXTVAL

277: ,LAST_UPDATE_LOGIN
278: )
279: VALUES
280: (
281: pv_ge_temp_approvers_s.NEXTVAL
282: ,1
283: ,p_approval_entity
284: ,p_referral_id
285: ,approverUserIds(i)

Line 1060: pv_ge_temp_approvers_s.NEXTVAL

1056: ,LAST_UPDATED_BY
1057: ,LAST_UPDATE_DATE
1058: ,LAST_UPDATE_LOGIN
1059: )VALUES(
1060: pv_ge_temp_approvers_s.NEXTVAL
1061: ,1
1062: ,p_approval_entity
1063: ,p_referral_id
1064: ,l_approval_list(i)