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.ASO_SALES_TEAM_PVT dependencies on ASO_QUOTE_ACCESSES

Line 36: Insert into ASO_QUOTE_ACCESSES

32:
33: IF p_WinningTerrMember_tbl.resource_type(l_index) = 'RS_EMPLOYEE' AND p_WinningTerrMember_tbl.group_id(l_index) IS NOT NULL THEN
34: aso_debug_pub.add('Begin INSERT_ACCESSES_ACCOUNTS'|| p_WinningTerrMember_tbl.resource_type(l_index),1,'Y');
35:
36: Insert into ASO_QUOTE_ACCESSES
37: (ACCESS_ID,
38: QUOTE_NUMBER,
39: RESOURCE_ID,
40: RESOURCE_GRP_ID,

Line 49: ASO_QUOTE_ACCESSES_S.nextval,

45: LAST_UPDATE_DATE,
46: ROLE_ID,
47: OBJECT_VERSION_NUMBER )
48: select
49: ASO_QUOTE_ACCESSES_S.nextval,
50: P_Qte_Header_Rec.quote_number,
51: p_WinningTerrMember_tbl.resource_id(l_index),
52: p_WinningTerrMember_tbl.group_ID(l_index),
53: FND_GLOBAL.USER_ID ,

Line 61: ASO_QUOTE_ACCESSES where resource_id = p_WinningTerrMember_tbl.resource_id(l_index)

57: SYSDATE,
58: null,
59: null
60: from dual where not exists (select 1 from
61: ASO_QUOTE_ACCESSES where resource_id = p_WinningTerrMember_tbl.resource_id(l_index)
62: and quote_number = P_Qte_Header_Rec.quote_number);
63:
64:
65: END IF;

Line 398: FROM ASO_QUOTE_ACCESSES

394: WHERE Quote_Header_Id = qte_hdr_id;
395:
396: CURSOR C_Team_Exists (l_qte_number NUMBER) IS
397: SELECT 'Y'
398: FROM ASO_QUOTE_ACCESSES
399: WHERE Quote_Number = l_qte_number;
400:
401: CURSOR C_Get_All_Resource (l_qte_number NUMBER) IS
402: SELECT Resource_Id

Line 403: FROM ASO_QUOTE_ACCESSES

399: WHERE Quote_Number = l_qte_number;
400:
401: CURSOR C_Get_All_Resource (l_qte_number NUMBER) IS
402: SELECT Resource_Id
403: FROM ASO_QUOTE_ACCESSES
404: WHERE Quote_Number = l_qte_number;
405:
406: CURSOR C_Get_Creator_Res (l_user_id NUMBER) IS
407: SELECT resource_id

Line 414: FROM ASO_QUOTE_ACCESSES

410: AND SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE);
411:
412: CURSOR C_Check_Creator_Res (l_qte_num NUMBER, l_res NUMBER) IS
413: SELECT 'Y', Resource_Grp_Id
414: FROM ASO_QUOTE_ACCESSES
415: WHERE Quote_Number = l_qte_num
416: AND Resource_Id = l_res;
417:
418: CURSOR C_Valid_SalesRep (l_res_id NUMBER) IS

Line 794: ASO_QUOTE_ACCESSES_PKG.Insert_Row(

790: END IF;
791:
792: l_sequence := NULL;
793:
794: ASO_QUOTE_ACCESSES_PKG.Insert_Row(
795: px_ACCESS_ID => l_sequence,
796: p_QUOTE_NUMBER => l_Qte_Header_Rec.Quote_Number,
797: p_RESOURCE_ID => l_creator_res,
798: p_RESOURCE_GRP_ID => l_creator_grp,

Line 977: ASO_QUOTE_ACCESSES_PKG.Insert_Row(

973: aso_debug_pub.add('nores:create:Assign_Sales_Team: Before primary salesagent insert:l_valid '||l_valid,1,'N');
974: END IF;
975: l_sequence := NULL;
976:
977: ASO_QUOTE_ACCESSES_PKG.Insert_Row(
978: px_ACCESS_ID => l_sequence,
979: p_QUOTE_NUMBER => P_Qte_Header_Rec.Quote_Number,
980: p_RESOURCE_ID => l_primary_salesagent,
981: p_RESOURCE_GRP_ID => l_primary_res_grp,

Line 1097: DELETE FROM ASO_QUOTE_ACCESSES C

1093: aso_debug_pub.add('count: '||i,1,'Y');
1094:
1095: aso_debug_pub.add('Before Delete Not Kept Existing Res ',1,'Y');
1096: END IF;
1097: DELETE FROM ASO_QUOTE_ACCESSES C
1098: WHERE C.resource_id NOT IN
1099: (SELECT A.resource_id
1100: FROM ASO_QUOTE_ACCESSES A , ASO_STEAM_TEMP B
1101: WHERE ((A.resource_id = B.resource_id

Line 1100: FROM ASO_QUOTE_ACCESSES A , ASO_STEAM_TEMP B

1096: END IF;
1097: DELETE FROM ASO_QUOTE_ACCESSES C
1098: WHERE C.resource_id NOT IN
1099: (SELECT A.resource_id
1100: FROM ASO_QUOTE_ACCESSES A , ASO_STEAM_TEMP B
1101: WHERE ((A.resource_id = B.resource_id
1102: AND NVL(A.resource_grp_id, -999) = NVL(B.resource_grp_id, -999)
1103: AND NVL(A.role_id, -999) = NVL(B.role_id, -999)
1104: AND NVL(A.keep_flag,'N') = 'N')

Line 1178: INSERT INTO ASO_QUOTE_ACCESSES ( ACCESS_ID,

1174: aso_debug_pub.add('count: '||i,1,'Y');
1175:
1176: aso_debug_pub.add('Before Insert into Quote_Accesses ',1,'Y');
1177: END IF;
1178: INSERT INTO ASO_QUOTE_ACCESSES ( ACCESS_ID,
1179: QUOTE_NUMBER,
1180: RESOURCE_ID,
1181: RESOURCE_GRP_ID,
1182: CREATED_BY,

Line 1191: SELECT ASO_QUOTE_ACCESSES_S.nextval,

1187: UPDATE_ACCESS_FLAG,
1188: TERRITORY_ID,
1189: TERRITORY_SOURCE_FLAG,
1190: ROLE_ID )
1191: SELECT ASO_QUOTE_ACCESSES_S.nextval,
1192: Quote_Number,
1193: Resource_Id,
1194: Resource_Grp_Id,
1195: Created_By,

Line 1207: ASO_QUOTE_ACCESSES where resource_id = ASO_STEAM_TEMP.resource_id

1203: Role_Id
1204: FROM ASO_STEAM_TEMP
1205: WHERE Quote_Number = l_Qte_Header_Rec.Quote_Number
1206: and not exists (select 1 from
1207: ASO_QUOTE_ACCESSES where resource_id = ASO_STEAM_TEMP.resource_id
1208: and quote_number = l_Qte_Header_Rec.Quote_Number);
1209:
1210: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1211: aso_debug_pub.add('After Insert into Quote_Accesses ',1,'Y');

Line 1348: ASO_QUOTE_ACCESSES_PKG.Insert_Row(

1344: END IF;
1345:
1346: l_sequence := NULL;
1347:
1348: ASO_QUOTE_ACCESSES_PKG.Insert_Row(
1349: px_ACCESS_ID => l_sequence,
1350: p_QUOTE_NUMBER => l_Qte_Header_Rec.Quote_Number,
1351: p_RESOURCE_ID => l_creator_res,
1352: p_RESOURCE_GRP_ID => l_creator_grp,

Line 2013: FROM ASO_QUOTE_ACCESSES

2009: AND Max_Version_Flag = 'Y';
2010:
2011: CURSOR C_Primary_Res_Kept (l_res NUMBER, l_qte_num NUMBER) IS
2012: SELECT 'Y'
2013: FROM ASO_QUOTE_ACCESSES
2014: WHERE Resource_Id = l_res
2015: AND Quote_Number = l_qte_num;
2016:
2017: CURSOR C_Valid_Salesagent (l_qte_num NUMBER) IS

Line 2019: /* FROM ASO_QUOTE_ACCESSES A, JTF_RS_SALESREPS B, */ --Commented Code Yogeshwar (MOAC)

2015: AND Quote_Number = l_qte_num;
2016:
2017: CURSOR C_Valid_Salesagent (l_qte_num NUMBER) IS
2018: SELECT A.Resource_Id, A.Resource_Grp_Id, A.Role_Id
2019: /* FROM ASO_QUOTE_ACCESSES A, JTF_RS_SALESREPS B, */ --Commented Code Yogeshwar (MOAC)
2020: FROM ASO_QUOTE_ACCESSES A, JTF_RS_SALESREPS_MO_V B, --New Code Yogeshwar (MOAC)
2021: OE_SALES_CREDIT_TYPES ST
2022: WHERE B.sales_credit_type_id = ST.sales_credit_type_id
2023: AND A.Resource_Id = B.Resource_Id

Line 2020: FROM ASO_QUOTE_ACCESSES A, JTF_RS_SALESREPS_MO_V B, --New Code Yogeshwar (MOAC)

2016:
2017: CURSOR C_Valid_Salesagent (l_qte_num NUMBER) IS
2018: SELECT A.Resource_Id, A.Resource_Grp_Id, A.Role_Id
2019: /* FROM ASO_QUOTE_ACCESSES A, JTF_RS_SALESREPS B, */ --Commented Code Yogeshwar (MOAC)
2020: FROM ASO_QUOTE_ACCESSES A, JTF_RS_SALESREPS_MO_V B, --New Code Yogeshwar (MOAC)
2021: OE_SALES_CREDIT_TYPES ST
2022: WHERE B.sales_credit_type_id = ST.sales_credit_type_id
2023: AND A.Resource_Id = B.Resource_Id
2024: AND A.Update_Access_Flag = 'Y'

Line 2269: ASO_QUOTE_ACCESSES_PKG.Insert_Row(

2265: aso_debug_pub.add('Assign_Sales_Team: Before primary salesagent insert: ',1,'N');
2266: END IF;
2267: l_sequence := NULL;
2268:
2269: ASO_QUOTE_ACCESSES_PKG.Insert_Row(
2270: px_ACCESS_ID => l_sequence,
2271: p_QUOTE_NUMBER => P_Qte_Header_Rec.Quote_Number,
2272: p_RESOURCE_ID => l_primary_salesagent,
2273: p_RESOURCE_GRP_ID => l_primary_res_grp,

Line 2451: /* FROM ASO_QUOTE_ACCESSES A, JTF_RS_SALESREPS B, */ --Commented Code Yogeshwar ( MOAC)

2447: --Commented Code End Yogeshwar (MOAC)
2448:
2449: CURSOR C_Valid_Salesagent (l_qte_num NUMBER) IS
2450: SELECT A.Resource_Id, A.Resource_Grp_Id
2451: /* FROM ASO_QUOTE_ACCESSES A, JTF_RS_SALESREPS B, */ --Commented Code Yogeshwar ( MOAC)
2452: FROM ASO_QUOTE_ACCESSES A,JTF_RS_SALESREPS_MO_V B, --New Code Yogeshwar (MOAC)
2453: OE_SALES_CREDIT_TYPES ST
2454: WHERE B.sales_credit_type_id = ST.sales_credit_type_id
2455: AND A.Resource_Id = B.Resource_Id

Line 2452: FROM ASO_QUOTE_ACCESSES A,JTF_RS_SALESREPS_MO_V B, --New Code Yogeshwar (MOAC)

2448:
2449: CURSOR C_Valid_Salesagent (l_qte_num NUMBER) IS
2450: SELECT A.Resource_Id, A.Resource_Grp_Id
2451: /* FROM ASO_QUOTE_ACCESSES A, JTF_RS_SALESREPS B, */ --Commented Code Yogeshwar ( MOAC)
2452: FROM ASO_QUOTE_ACCESSES A,JTF_RS_SALESREPS_MO_V B, --New Code Yogeshwar (MOAC)
2453: OE_SALES_CREDIT_TYPES ST
2454: WHERE B.sales_credit_type_id = ST.sales_credit_type_id
2455: AND A.Resource_Id = B.Resource_Id
2456: AND A.Update_Access_Flag = 'Y'

Line 2470: FROM ASO_QUOTE_ACCESSES

2466: --Commented Code End Yogeshwar (MOAC)
2467:
2468: CURSOR C_Check_Creator_Res (l_qte_num NUMBER, l_res NUMBER) IS
2469: SELECT 'Y', Resource_Grp_Id
2470: FROM ASO_QUOTE_ACCESSES
2471: WHERE Quote_Number = l_qte_num
2472: AND Resource_Id = l_res;
2473:
2474: CURSOR C_Get_Role_From_Code (l_code VARCHAR2) IS

Line 2668: ASO_QUOTE_ACCESSES_PKG.Insert_Row(

2664: END IF;
2665:
2666: l_sequence := NULL;
2667:
2668: ASO_QUOTE_ACCESSES_PKG.Insert_Row(
2669: px_ACCESS_ID => l_sequence,
2670: p_QUOTE_NUMBER => P_Qte_Header_Rec.Quote_Number,
2671: p_RESOURCE_ID => l_creator_res,
2672: p_RESOURCE_GRP_ID => l_primary_res_grp,

Line 2847: ASO_QUOTE_ACCESSES_PKG.Insert_Row(

2843: aso_debug_pub.add('Opp_Qte_PS: Before primary salesagent insert: ',1,'N');
2844: END IF;
2845: l_sequence := NULL;
2846:
2847: ASO_QUOTE_ACCESSES_PKG.Insert_Row(
2848: px_ACCESS_ID => l_sequence,
2849: p_QUOTE_NUMBER => P_Qte_Header_Rec.Quote_Number,
2850: p_RESOURCE_ID => l_primary_salesagent,
2851: p_RESOURCE_GRP_ID => l_primary_res_grp,