598: Access_level,
599: Keep_flag)
600: SELECT PRP_PROPOSAL_ACCESSES_S1.NEXTVAL,
601: SYSDATE,
602: FND_GLOBAL.USER_ID,
603: SYSDATE,
604: FND_GLOBAL.USER_ID,
605: FND_GLOBAL.USER_ID,
606: pp.Proposal_id,
600: SELECT PRP_PROPOSAL_ACCESSES_S1.NEXTVAL,
601: SYSDATE,
602: FND_GLOBAL.USER_ID,
603: SYSDATE,
604: FND_GLOBAL.USER_ID,
605: FND_GLOBAL.USER_ID,
606: pp.Proposal_id,
607: p_WinningTerrMember_tbl.resource_id(l_index),
608: p_WinningTerrMember_tbl.group_id(l_index),
601: SYSDATE,
602: FND_GLOBAL.USER_ID,
603: SYSDATE,
604: FND_GLOBAL.USER_ID,
605: FND_GLOBAL.USER_ID,
606: pp.Proposal_id,
607: p_WinningTerrMember_tbl.resource_id(l_index),
608: p_WinningTerrMember_tbl.group_id(l_index),
609: DECODE(p_WinningTerrMember_tbl.full_access_flag(l_index),'Y','FULL','READ'),
671: ACC.proposal_access_id,
672: p_WinningTerrMember_tbl.terr_id(l_index),
673: 1,
674: SYSDATE,
675: FND_GLOBAL.USER_ID,
676: SYSDATE,
677: FND_GLOBAL.USER_ID,
678: FND_GLOBAL.USER_ID
679: FROM PRP_PROPOSAL_ACCESSES ACC
673: 1,
674: SYSDATE,
675: FND_GLOBAL.USER_ID,
676: SYSDATE,
677: FND_GLOBAL.USER_ID,
678: FND_GLOBAL.USER_ID
679: FROM PRP_PROPOSAL_ACCESSES ACC
680: WHERE ACC.proposal_id = G_PROPOSAL_ID
681: AND ACC.resource_id = p_WinningTerrMember_tbl.resource_id(l_index)
674: SYSDATE,
675: FND_GLOBAL.USER_ID,
676: SYSDATE,
677: FND_GLOBAL.USER_ID,
678: FND_GLOBAL.USER_ID
679: FROM PRP_PROPOSAL_ACCESSES ACC
680: WHERE ACC.proposal_id = G_PROPOSAL_ID
681: AND ACC.resource_id = p_WinningTerrMember_tbl.resource_id(l_index)
682: AND ACC.resource_group_id = p_WinningTerrMember_tbl.group_id(l_index)