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_STEAM_TEMP

Line 570: DELETE FROM ASO_STEAM_TEMP;

566: aso_debug_pub.add('Operation_Code: '||P_Operation,1,'Y');
567: aso_debug_pub.add('Before Truncating Temp Table',1,'Y');
568: END IF;
569:
570: DELETE FROM ASO_STEAM_TEMP;
571:
572: IF P_Operation <> 'CREATE' THEN
573:
574: OPEN C_Get_Header_Info (p_qte_header_rec.Quote_header_id);

Line 1053: INSERT INTO ASO_STEAM_TEMP ( Access_Id,

1049: aso_debug_pub.add('Before Temp_Insert'||NVL(lx_gen_return_Rec.resource_id.COUNT,0),1,'Y');
1050: END IF;
1051:
1052: FORALL i IN lx_gen_return_Rec.resource_id.FIRST..lx_gen_return_Rec.resource_id.LAST
1053: INSERT INTO ASO_STEAM_TEMP ( Access_Id,
1054: Quote_Number,
1055: Resource_Id,
1056: Resource_Grp_Id,
1057: Created_By,

Line 1092: select count(*) into i from aso_steam_temp;

1088:
1089: IF l_Reassign_Flag = 'Y' THEN
1090:
1091: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1092: select count(*) into i from aso_steam_temp;
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;

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 1110: select count(*) into i from aso_steam_temp;

1106: AND A.Quote_Number = l_qte_header_rec.quote_number)
1107: AND C.Quote_Number = l_qte_header_rec.quote_number;
1108:
1109: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1110: select count(*) into i from aso_steam_temp;
1111: aso_debug_pub.add('count: '||i,1,'Y');
1112:
1113: aso_debug_pub.add('Before Delete Kept Res ',1,'Y');
1114: END IF;

Line 1124: DELETE FROM ASO_STEAM_TEMP

1120: aso_debug_pub.add('Keep_Res_Id.COUNT: '||NVL(Keep_Res_Id.COUNT,0),1,'Y');
1121: END IF;
1122: IF NVL(Keep_Res_Id.COUNT,0) > 0 THEN
1123: FORALL i IN Keep_Res_Id.FIRST..Keep_Res_Id.LAST
1124: DELETE FROM ASO_STEAM_TEMP
1125: WHERE Resource_Id = Keep_Res_Id(i);
1126: END IF;
1127: END IF;
1128:

Line 1130: select count(*) into i from aso_steam_temp;

1126: END IF;
1127: END IF;
1128:
1129: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1130: select count(*) into i from aso_steam_temp;
1131: aso_debug_pub.add('count: '||i,1,'Y');
1132:
1133: aso_debug_pub.add('Before Delete Invalid Roles ',1,'Y');
1134: END IF;

Line 1135: DELETE FROM ASO_STEAM_TEMP

1131: aso_debug_pub.add('count: '||i,1,'Y');
1132:
1133: aso_debug_pub.add('Before Delete Invalid Roles ',1,'Y');
1134: END IF;
1135: DELETE FROM ASO_STEAM_TEMP
1136: WHERE Role_Id IS NOT NULL
1137: AND Role_Id NOT IN ( SELECT Role_Id
1138: FROM JTF_RS_ROLES_B
1139: WHERE Role_Type_Code IN ('TELESALES', 'SALES','FIELDSALES','PRM'));

Line 1142: select count(*) into i from aso_steam_temp;

1138: FROM JTF_RS_ROLES_B
1139: WHERE Role_Type_Code IN ('TELESALES', 'SALES','FIELDSALES','PRM'));
1140:
1141: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1142: select count(*) into i from aso_steam_temp;
1143: aso_debug_pub.add('count: '||i,1,'Y');
1144:
1145: aso_debug_pub.add('Before Delete Duplicate Res/Roles/Grp combos ',1,'Y');
1146: END IF;

Line 1147: l_dynamic := 'DELETE FROM ASO_STEAM_TEMP '||

1143: aso_debug_pub.add('count: '||i,1,'Y');
1144:
1145: aso_debug_pub.add('Before Delete Duplicate Res/Roles/Grp combos ',1,'Y');
1146: END IF;
1147: l_dynamic := 'DELETE FROM ASO_STEAM_TEMP '||
1148: 'WHERE rowid NOT IN ( SELECT rowid '||
1149: 'FROM ( SELECT rowid, dense_rank() OVER '||
1150: '( PARTITION BY Resource_Id '||
1151: 'ORDER BY Role_Id DESC nulls last, Resource_Grp_Id DESC nulls last) AS Rank_Val '||

Line 1152: 'FROM ASO_STEAM_TEMP '||

1148: 'WHERE rowid NOT IN ( SELECT rowid '||
1149: 'FROM ( SELECT rowid, dense_rank() OVER '||
1150: '( PARTITION BY Resource_Id '||
1151: 'ORDER BY Role_Id DESC nulls last, Resource_Grp_Id DESC nulls last) AS Rank_Val '||
1152: 'FROM ASO_STEAM_TEMP '||
1153: 'ORDER BY Role_Id DESC nulls last, Resource_Grp_Id DESC nulls last ) '||
1154: 'WHERE Rank_Val = 1 )';
1155:
1156: EXECUTE IMMEDIATE l_dynamic;

Line 1159: select count(*) into i from aso_steam_temp;

1155:
1156: EXECUTE IMMEDIATE l_dynamic;
1157:
1158: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1159: select count(*) into i from aso_steam_temp;
1160: aso_debug_pub.add('count: '||i,1,'Y');
1161:
1162: aso_debug_pub.add('Before Delete Duplicate Resources ',1,'Y');
1163: END IF;

Line 1164: DELETE FROM ASO_STEAM_TEMP

1160: aso_debug_pub.add('count: '||i,1,'Y');
1161:
1162: aso_debug_pub.add('Before Delete Duplicate Resources ',1,'Y');
1163: END IF;
1164: DELETE FROM ASO_STEAM_TEMP
1165: WHERE rowid IN (
1166: SELECT rowid FROM ASO_STEAM_TEMP
1167: GROUP BY rowid, Resource_Id
1168: MINUS

Line 1166: SELECT rowid FROM ASO_STEAM_TEMP

1162: aso_debug_pub.add('Before Delete Duplicate Resources ',1,'Y');
1163: END IF;
1164: DELETE FROM ASO_STEAM_TEMP
1165: WHERE rowid IN (
1166: SELECT rowid FROM ASO_STEAM_TEMP
1167: GROUP BY rowid, Resource_Id
1168: MINUS
1169: SELECT min(rowid) FROM ASO_STEAM_TEMP
1170: GROUP BY Resource_Id);

Line 1169: SELECT min(rowid) FROM ASO_STEAM_TEMP

1165: WHERE rowid IN (
1166: SELECT rowid FROM ASO_STEAM_TEMP
1167: GROUP BY rowid, Resource_Id
1168: MINUS
1169: SELECT min(rowid) FROM ASO_STEAM_TEMP
1170: GROUP BY Resource_Id);
1171:
1172: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1173: select count(*) into i from aso_steam_temp;

Line 1173: select count(*) into i from aso_steam_temp;

1169: SELECT min(rowid) FROM ASO_STEAM_TEMP
1170: GROUP BY Resource_Id);
1171:
1172: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1173: select count(*) into i from aso_steam_temp;
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;

Line 1204: FROM ASO_STEAM_TEMP

1200: Full_Access_Flag,
1201: Territory_Id,
1202: Territory_Source_Flag,
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);

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');