[Home] [Help]
387: AND tu.team_id = t.team_id
388: AND tu.usage IN ('SALES','PRM')
389: AND tm.team_member_id = trr.role_resource_id
390: AND tm.delete_flag <> 'Y'
391: AND tm.resource_type = 'INDIVIDUAL'
392: AND trr.role_resource_type = 'RS_TEAM_MEMBER'
393: AND trr.delete_flag <> 'Y'
394: AND SYSDATE BETWEEN trr.start_date_active AND
395: NVL(trr.end_date_active,SYSDATE)
809: WHEN OTHERS THEN
810: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_STLEAD || AS_GAR.G_IND_UPD || AS_GAR.G_GENERAL_EXCEPTION);
811: AS_GAR.LOG('PROPOSAL_ID/RESOURCE_id/SALESGROUP_ID/ORG_ID - ' || l_proposal_id(i) || '/' || l_resource_id(i) || '/' || l_resource_group_id(i));
812: END;
813: END LOOP; -- for each record individually
814: COMMIT;
815: END IF;
816: END; -- end of deadlock exception
817: WHEN OTHERS THEN
969: ,SYSDATE
970: ,p_terr_globals.user_id
971: ,SYSDATE
972: ,p_terr_globals.last_update_login
973: FROM DUAL
974: WHERE NOT EXISTS ( SELECT 'X'
975: FROM PRP_PROPOSAL_ACCESSES AA
976: WHERE AA.proposal_id = l_proposal_id(i)
977: AND AA.resource_id = l_resource_id(i)
1012: ,SYSDATE
1013: ,p_terr_globals.user_id
1014: ,SYSDATE
1015: ,p_terr_globals.last_update_login
1016: FROM DUAL
1017: WHERE NOT EXISTS ( SELECT 'X'
1018: FROM PRP_PROPOSAL_ACCESSES AA
1019: WHERE AA.proposal_id = l_proposal_id(i)
1020: AND AA.resource_id = l_resource_id(i)
1024: EXCEPTION
1025: WHEN OTHERS THEN
1026: NULL;
1027: END;
1028: END LOOP; /* loop for DUP_VAL_ON_INDEX individual insert */
1029: COMMIT;
1030: WHEN OTHERS THEN
1031: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSACC || AS_GAR.G_BULK_INS, SQLERRM, TO_CHAR(SQLCODE));
1032: x_errbuf := SQLERRM;