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.AS_RTTAP_OPPTY dependencies on FND_GLOBAL

Line 665: ACC.last_updated_by = FND_GLOBAL.USER_ID,

661: IF p_WinningTerrMember_tbl.resource_type(l_index) = 'RS_EMPLOYEE' THEN
662: UPDATE AS_ACCESSES_ALL_ALL ACC
663: SET object_version_number = nvl(object_version_number,0) + 1,
664: ACC.last_update_date = SYSDATE,
665: ACC.last_updated_by = FND_GLOBAL.USER_ID,
666: ACC.last_update_login = FND_GLOBAL.USER_ID,
667: ACC.team_leader_flag = NVL(p_WinningTerrMember_tbl.full_access_flag(l_index),'N')
668: WHERE ACC.lead_id = G_LEAD_ID
669: AND ACC.salesforce_id = p_WinningTerrMember_tbl.resource_id(l_index)

Line 666: ACC.last_update_login = FND_GLOBAL.USER_ID,

662: UPDATE AS_ACCESSES_ALL_ALL ACC
663: SET object_version_number = nvl(object_version_number,0) + 1,
664: ACC.last_update_date = SYSDATE,
665: ACC.last_updated_by = FND_GLOBAL.USER_ID,
666: ACC.last_update_login = FND_GLOBAL.USER_ID,
667: ACC.team_leader_flag = NVL(p_WinningTerrMember_tbl.full_access_flag(l_index),'N')
668: WHERE ACC.lead_id = G_LEAD_ID
669: AND ACC.salesforce_id = p_WinningTerrMember_tbl.resource_id(l_index)
670: AND ACC.sales_group_id = p_WinningTerrMember_tbl.group_id(l_index)

Line 720: FND_GLOBAL.USER_ID,

716: owner_flag,
717: open_flag,org_id)
718: SELECT AS_ACCESSES_S.NEXTVAL,
719: SYSDATE,
720: FND_GLOBAL.USER_ID,
721: SYSDATE,
722: FND_GLOBAL.USER_ID,
723: FND_GLOBAL.USER_ID,
724: 'Online',

Line 722: FND_GLOBAL.USER_ID,

718: SELECT AS_ACCESSES_S.NEXTVAL,
719: SYSDATE,
720: FND_GLOBAL.USER_ID,
721: SYSDATE,
722: FND_GLOBAL.USER_ID,
723: FND_GLOBAL.USER_ID,
724: 'Online',
725: 'N',
726: 'N',

Line 723: FND_GLOBAL.USER_ID,

719: SYSDATE,
720: FND_GLOBAL.USER_ID,
721: SYSDATE,
722: FND_GLOBAL.USER_ID,
723: FND_GLOBAL.USER_ID,
724: 'Online',
725: 'N',
726: 'N',
727: DECODE(p_WinningTerrMember_tbl.full_access_flag(l_index),'Y','Y','N'),

Line 793: FND_GLOBAL.USER_ID,

789: ACC.access_id,
790: p_WinningTerrMember_tbl.terr_id(l_index),
791: p_WinningTerrMember_tbl.terr_id(l_index),
792: SYSDATE,
793: FND_GLOBAL.USER_ID,
794: SYSDATE,
795: FND_GLOBAL.USER_ID,
796: FND_GLOBAL.USER_ID
797: FROM AS_ACCESSES_ALL ACC

Line 795: FND_GLOBAL.USER_ID,

791: p_WinningTerrMember_tbl.terr_id(l_index),
792: SYSDATE,
793: FND_GLOBAL.USER_ID,
794: SYSDATE,
795: FND_GLOBAL.USER_ID,
796: FND_GLOBAL.USER_ID
797: FROM AS_ACCESSES_ALL ACC
798: WHERE ACC.lead_id = G_LEAD_ID
799: AND ACC.salesforce_id = p_WinningTerrMember_tbl.resource_id(l_index)

Line 796: FND_GLOBAL.USER_ID

792: SYSDATE,
793: FND_GLOBAL.USER_ID,
794: SYSDATE,
795: FND_GLOBAL.USER_ID,
796: FND_GLOBAL.USER_ID
797: FROM AS_ACCESSES_ALL ACC
798: WHERE ACC.lead_id = G_LEAD_ID
799: AND ACC.salesforce_id = p_WinningTerrMember_tbl.resource_id(l_index)
800: AND ACC.sales_group_id = p_WinningTerrMember_tbl.group_id(l_index)

Line 893: SL.last_updated_by = FND_GLOBAL.USER_ID,

889: IF oppty_owner_rt%NOTFOUND THEN
890: UPDATE AS_LEADS_ALL sl
891: SET SL.object_version_number = nvl(sl.object_version_number,0) + 1,
892: SL.last_update_date = SYSDATE,
893: SL.last_updated_by = FND_GLOBAL.USER_ID,
894: SL.last_update_login = FND_GLOBAL.USER_ID,
895: SL.owner_salesforce_id = NULL,
896: SL.owner_sales_group_id = NULL
897: WHERE SL.lead_id = G_LEAD_ID ;

Line 894: SL.last_update_login = FND_GLOBAL.USER_ID,

890: UPDATE AS_LEADS_ALL sl
891: SET SL.object_version_number = nvl(sl.object_version_number,0) + 1,
892: SL.last_update_date = SYSDATE,
893: SL.last_updated_by = FND_GLOBAL.USER_ID,
894: SL.last_update_login = FND_GLOBAL.USER_ID,
895: SL.owner_salesforce_id = NULL,
896: SL.owner_sales_group_id = NULL
897: WHERE SL.lead_id = G_LEAD_ID ;
898: UPDATE AS_SALES_CREDITS_DENORM SCD

Line 901: SCD.last_updated_by = FND_GLOBAL.USER_ID,

897: WHERE SL.lead_id = G_LEAD_ID ;
898: UPDATE AS_SALES_CREDITS_DENORM SCD
899: SET SCD.object_version_number = nvl(scd.object_version_number,0) + 1,
900: SCD.last_update_date = SYSDATE,
901: SCD.last_updated_by = FND_GLOBAL.USER_ID,
902: SCD.last_update_login = FND_GLOBAL.USER_ID,
903: SCD.owner_salesforce_id = NULL,
904: SCD.owner_sales_group_id = NULL
905: WHERE SCD.lead_id = G_LEAD_ID ;

Line 902: SCD.last_update_login = FND_GLOBAL.USER_ID,

898: UPDATE AS_SALES_CREDITS_DENORM SCD
899: SET SCD.object_version_number = nvl(scd.object_version_number,0) + 1,
900: SCD.last_update_date = SYSDATE,
901: SCD.last_updated_by = FND_GLOBAL.USER_ID,
902: SCD.last_update_login = FND_GLOBAL.USER_ID,
903: SCD.owner_salesforce_id = NULL,
904: SCD.owner_sales_group_id = NULL
905: WHERE SCD.lead_id = G_LEAD_ID ;
906: ELSE

Line 911: AAA.last_updated_by = FND_GLOBAL.USER_ID,

907: UPDATE AS_ACCESSES_ALL AAA
908: SET AAA.owner_flag = 'Y',
909: AAA.object_version_number = nvl(AAA.object_version_number,0) + 1,
910: AAA.last_update_date = SYSDATE,
911: AAA.last_updated_by = FND_GLOBAL.USER_ID,
912: AAA.last_update_login = FND_GLOBAL.USER_ID
913: WHERE access_id = v_acc_id
914: RETURNING salesforce_id,sales_group_id INTO v_srep_id,v_grp_id;
915: UPDATE AS_LEADS_ALL sl

Line 912: AAA.last_update_login = FND_GLOBAL.USER_ID

908: SET AAA.owner_flag = 'Y',
909: AAA.object_version_number = nvl(AAA.object_version_number,0) + 1,
910: AAA.last_update_date = SYSDATE,
911: AAA.last_updated_by = FND_GLOBAL.USER_ID,
912: AAA.last_update_login = FND_GLOBAL.USER_ID
913: WHERE access_id = v_acc_id
914: RETURNING salesforce_id,sales_group_id INTO v_srep_id,v_grp_id;
915: UPDATE AS_LEADS_ALL sl
916: SET SL.object_version_number = nvl(sl.object_version_number,0) + 1,

Line 918: SL.last_updated_by = FND_GLOBAL.USER_ID,

914: RETURNING salesforce_id,sales_group_id INTO v_srep_id,v_grp_id;
915: UPDATE AS_LEADS_ALL sl
916: SET SL.object_version_number = nvl(sl.object_version_number,0) + 1,
917: SL.last_update_date = SYSDATE,
918: SL.last_updated_by = FND_GLOBAL.USER_ID,
919: SL.last_update_login = FND_GLOBAL.USER_ID,
920: SL.owner_salesforce_id = v_srep_id,
921: SL.owner_sales_group_id = v_grp_id
922: WHERE SL.lead_id = G_LEAD_ID ;

Line 919: SL.last_update_login = FND_GLOBAL.USER_ID,

915: UPDATE AS_LEADS_ALL sl
916: SET SL.object_version_number = nvl(sl.object_version_number,0) + 1,
917: SL.last_update_date = SYSDATE,
918: SL.last_updated_by = FND_GLOBAL.USER_ID,
919: SL.last_update_login = FND_GLOBAL.USER_ID,
920: SL.owner_salesforce_id = v_srep_id,
921: SL.owner_sales_group_id = v_grp_id
922: WHERE SL.lead_id = G_LEAD_ID ;
923: UPDATE AS_SALES_CREDITS_DENORM SCD

Line 926: SCD.last_updated_by = FND_GLOBAL.USER_ID,

922: WHERE SL.lead_id = G_LEAD_ID ;
923: UPDATE AS_SALES_CREDITS_DENORM SCD
924: SET SCD.object_version_number = nvl(scd.object_version_number,0) + 1,
925: SCD.last_update_date = SYSDATE,
926: SCD.last_updated_by = FND_GLOBAL.USER_ID,
927: SCD.last_update_login = FND_GLOBAL.USER_ID,
928: SCD.owner_salesforce_id = v_srep_id,
929: SCD.owner_sales_group_id = v_grp_id
930: WHERE SCD.lead_id = G_LEAD_ID ;

Line 927: SCD.last_update_login = FND_GLOBAL.USER_ID,

923: UPDATE AS_SALES_CREDITS_DENORM SCD
924: SET SCD.object_version_number = nvl(scd.object_version_number,0) + 1,
925: SCD.last_update_date = SYSDATE,
926: SCD.last_updated_by = FND_GLOBAL.USER_ID,
927: SCD.last_update_login = FND_GLOBAL.USER_ID,
928: SCD.owner_salesforce_id = v_srep_id,
929: SCD.owner_sales_group_id = v_grp_id
930: WHERE SCD.lead_id = G_LEAD_ID ;
931: END IF;