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 121: FROM ASO_QUOTE_ACCESSES

117: WHERE Quote_Header_Id = qte_hdr_id;
118:
119: CURSOR C_Team_Exists (l_qte_number NUMBER) IS
120: SELECT 'Y'
121: FROM ASO_QUOTE_ACCESSES
122: WHERE Quote_Number = l_qte_number;
123:
124: CURSOR C_Get_All_Resource (l_qte_number NUMBER) IS
125: SELECT Resource_Id

Line 126: FROM ASO_QUOTE_ACCESSES

122: WHERE Quote_Number = l_qte_number;
123:
124: CURSOR C_Get_All_Resource (l_qte_number NUMBER) IS
125: SELECT Resource_Id
126: FROM ASO_QUOTE_ACCESSES
127: WHERE Quote_Number = l_qte_number;
128:
129: CURSOR C_Get_Creator_Res (l_user_id NUMBER) IS
130: SELECT resource_id

Line 137: FROM ASO_QUOTE_ACCESSES

133: AND SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE);
134:
135: CURSOR C_Check_Creator_Res (l_qte_num NUMBER, l_res NUMBER) IS
136: SELECT 'Y', Resource_Grp_Id
137: FROM ASO_QUOTE_ACCESSES
138: WHERE Quote_Number = l_qte_num
139: AND Resource_Id = l_res;
140:
141: CURSOR C_Valid_SalesRep (l_res_id NUMBER) IS

Line 503: ASO_QUOTE_ACCESSES_PKG.Insert_Row(

499: END IF;
500:
501: l_sequence := NULL;
502:
503: ASO_QUOTE_ACCESSES_PKG.Insert_Row(
504: px_ACCESS_ID => l_sequence,
505: p_QUOTE_NUMBER => l_Qte_Header_Rec.Quote_Number,
506: p_RESOURCE_ID => l_creator_res,
507: p_RESOURCE_GRP_ID => l_creator_grp,

Line 686: ASO_QUOTE_ACCESSES_PKG.Insert_Row(

682: aso_debug_pub.add('nores:create:Assign_Sales_Team: Before primary salesagent insert:l_valid '||l_valid,1,'N');
683: END IF;
684: l_sequence := NULL;
685:
686: ASO_QUOTE_ACCESSES_PKG.Insert_Row(
687: px_ACCESS_ID => l_sequence,
688: p_QUOTE_NUMBER => P_Qte_Header_Rec.Quote_Number,
689: p_RESOURCE_ID => l_primary_salesagent,
690: p_RESOURCE_GRP_ID => l_primary_res_grp,

Line 806: DELETE FROM ASO_QUOTE_ACCESSES C

802: aso_debug_pub.add('count: '||i,1,'Y');
803:
804: aso_debug_pub.add('Before Delete Not Kept Existing Res ',1,'Y');
805: END IF;
806: DELETE FROM ASO_QUOTE_ACCESSES C
807: WHERE C.resource_id NOT IN
808: (SELECT A.resource_id
809: FROM ASO_QUOTE_ACCESSES A , ASO_STEAM_TEMP B
810: WHERE ((A.resource_id = B.resource_id

Line 809: FROM ASO_QUOTE_ACCESSES A , ASO_STEAM_TEMP B

805: END IF;
806: DELETE FROM ASO_QUOTE_ACCESSES C
807: WHERE C.resource_id NOT IN
808: (SELECT A.resource_id
809: FROM ASO_QUOTE_ACCESSES A , ASO_STEAM_TEMP B
810: WHERE ((A.resource_id = B.resource_id
811: AND NVL(A.resource_grp_id, -999) = NVL(B.resource_grp_id, -999)
812: AND NVL(A.role_id, -999) = NVL(B.role_id, -999)
813: AND NVL(A.keep_flag,'N') = 'N')

Line 887: INSERT INTO ASO_QUOTE_ACCESSES ( ACCESS_ID,

883: aso_debug_pub.add('count: '||i,1,'Y');
884:
885: aso_debug_pub.add('Before Insert into Quote_Accesses ',1,'Y');
886: END IF;
887: INSERT INTO ASO_QUOTE_ACCESSES ( ACCESS_ID,
888: QUOTE_NUMBER,
889: RESOURCE_ID,
890: RESOURCE_GRP_ID,
891: CREATED_BY,

Line 900: SELECT ASO_QUOTE_ACCESSES_S.nextval,

896: UPDATE_ACCESS_FLAG,
897: TERRITORY_ID,
898: TERRITORY_SOURCE_FLAG,
899: ROLE_ID )
900: SELECT ASO_QUOTE_ACCESSES_S.nextval,
901: Quote_Number,
902: Resource_Id,
903: Resource_Grp_Id,
904: Created_By,

Line 1054: ASO_QUOTE_ACCESSES_PKG.Insert_Row(

1050: END IF;
1051:
1052: l_sequence := NULL;
1053:
1054: ASO_QUOTE_ACCESSES_PKG.Insert_Row(
1055: px_ACCESS_ID => l_sequence,
1056: p_QUOTE_NUMBER => l_Qte_Header_Rec.Quote_Number,
1057: p_RESOURCE_ID => l_creator_res,
1058: p_RESOURCE_GRP_ID => l_creator_grp,

Line 1574: FROM ASO_QUOTE_ACCESSES

1570: AND Max_Version_Flag = 'Y';
1571:
1572: CURSOR C_Primary_Res_Kept (l_res NUMBER, l_qte_num NUMBER) IS
1573: SELECT 'Y'
1574: FROM ASO_QUOTE_ACCESSES
1575: WHERE Resource_Id = l_res
1576: AND Quote_Number = l_qte_num;
1577:
1578: CURSOR C_Valid_Salesagent (l_qte_num NUMBER) IS

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

1576: AND Quote_Number = l_qte_num;
1577:
1578: CURSOR C_Valid_Salesagent (l_qte_num NUMBER) IS
1579: SELECT A.Resource_Id, A.Resource_Grp_Id, A.Role_Id
1580: /* FROM ASO_QUOTE_ACCESSES A, JTF_RS_SALESREPS B, */ --Commented Code Yogeshwar (MOAC)
1581: FROM ASO_QUOTE_ACCESSES A, JTF_RS_SALESREPS_MO_V B, --New Code Yogeshwar (MOAC)
1582: OE_SALES_CREDIT_TYPES ST
1583: WHERE B.sales_credit_type_id = ST.sales_credit_type_id
1584: AND A.Resource_Id = B.Resource_Id

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

1577:
1578: CURSOR C_Valid_Salesagent (l_qte_num NUMBER) IS
1579: SELECT A.Resource_Id, A.Resource_Grp_Id, A.Role_Id
1580: /* FROM ASO_QUOTE_ACCESSES A, JTF_RS_SALESREPS B, */ --Commented Code Yogeshwar (MOAC)
1581: FROM ASO_QUOTE_ACCESSES A, JTF_RS_SALESREPS_MO_V B, --New Code Yogeshwar (MOAC)
1582: OE_SALES_CREDIT_TYPES ST
1583: WHERE B.sales_credit_type_id = ST.sales_credit_type_id
1584: AND A.Resource_Id = B.Resource_Id
1585: AND A.Update_Access_Flag = 'Y'

Line 1830: ASO_QUOTE_ACCESSES_PKG.Insert_Row(

1826: aso_debug_pub.add('Assign_Sales_Team: Before primary salesagent insert: ',1,'N');
1827: END IF;
1828: l_sequence := NULL;
1829:
1830: ASO_QUOTE_ACCESSES_PKG.Insert_Row(
1831: px_ACCESS_ID => l_sequence,
1832: p_QUOTE_NUMBER => P_Qte_Header_Rec.Quote_Number,
1833: p_RESOURCE_ID => l_primary_salesagent,
1834: p_RESOURCE_GRP_ID => l_primary_res_grp,

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

2008: --Commented Code End Yogeshwar (MOAC)
2009:
2010: CURSOR C_Valid_Salesagent (l_qte_num NUMBER) IS
2011: SELECT A.Resource_Id, A.Resource_Grp_Id
2012: /* FROM ASO_QUOTE_ACCESSES A, JTF_RS_SALESREPS B, */ --Commented Code Yogeshwar ( MOAC)
2013: FROM ASO_QUOTE_ACCESSES A,JTF_RS_SALESREPS_MO_V B, --New Code Yogeshwar (MOAC)
2014: OE_SALES_CREDIT_TYPES ST
2015: WHERE B.sales_credit_type_id = ST.sales_credit_type_id
2016: AND A.Resource_Id = B.Resource_Id

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

2009:
2010: CURSOR C_Valid_Salesagent (l_qte_num NUMBER) IS
2011: SELECT A.Resource_Id, A.Resource_Grp_Id
2012: /* FROM ASO_QUOTE_ACCESSES A, JTF_RS_SALESREPS B, */ --Commented Code Yogeshwar ( MOAC)
2013: FROM ASO_QUOTE_ACCESSES A,JTF_RS_SALESREPS_MO_V B, --New Code Yogeshwar (MOAC)
2014: OE_SALES_CREDIT_TYPES ST
2015: WHERE B.sales_credit_type_id = ST.sales_credit_type_id
2016: AND A.Resource_Id = B.Resource_Id
2017: AND A.Update_Access_Flag = 'Y'

Line 2031: FROM ASO_QUOTE_ACCESSES

2027: --Commented Code End Yogeshwar (MOAC)
2028:
2029: CURSOR C_Check_Creator_Res (l_qte_num NUMBER, l_res NUMBER) IS
2030: SELECT 'Y', Resource_Grp_Id
2031: FROM ASO_QUOTE_ACCESSES
2032: WHERE Quote_Number = l_qte_num
2033: AND Resource_Id = l_res;
2034:
2035: CURSOR C_Get_Role_From_Code (l_code VARCHAR2) IS

Line 2229: ASO_QUOTE_ACCESSES_PKG.Insert_Row(

2225: END IF;
2226:
2227: l_sequence := NULL;
2228:
2229: ASO_QUOTE_ACCESSES_PKG.Insert_Row(
2230: px_ACCESS_ID => l_sequence,
2231: p_QUOTE_NUMBER => P_Qte_Header_Rec.Quote_Number,
2232: p_RESOURCE_ID => l_creator_res,
2233: p_RESOURCE_GRP_ID => l_primary_res_grp,

Line 2408: ASO_QUOTE_ACCESSES_PKG.Insert_Row(

2404: aso_debug_pub.add('Opp_Qte_PS: Before primary salesagent insert: ',1,'N');
2405: END IF;
2406: l_sequence := NULL;
2407:
2408: ASO_QUOTE_ACCESSES_PKG.Insert_Row(
2409: px_ACCESS_ID => l_sequence,
2410: p_QUOTE_NUMBER => P_Qte_Header_Rec.Quote_Number,
2411: p_RESOURCE_ID => l_primary_salesagent,
2412: p_RESOURCE_GRP_ID => l_primary_res_grp,