APPS.POA_PORTAL_POPULATE_C dependencies on POA_PORTAL_RISK_SUMMARY

Line 88: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema ||'.POA_PORTAL_RISK_SUMMARY';

84: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema ||'.POA_PORTAL_SPERF';
85: EXECUTE IMMEDIATE l_stmt;
86: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema ||'.POA_PORTAL_RISK_IND';
87: EXECUTE IMMEDIATE l_stmt;
88: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema ||'.POA_PORTAL_RISK_SUMMARY';
89: EXECUTE IMMEDIATE l_stmt;
90: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema ||'.POA_PORTAL_SUP_RISK';
91: EXECUTE IMMEDIATE l_stmt;
92: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema ||'.POA_PORTAL_RCPT_SUM';

Line 598: insert into POA_PORTAL_RISK_SUMMARY (

594: p_end IN DATE,
595: p_count OUT NOCOPY NUMBER,
596: success OUT NOCOPY varchar2) IS
597: BEGIN
598: insert into POA_PORTAL_RISK_SUMMARY (
599: Status,
600: Risk_Category,
601: Supplier_PK_Key,
602: Supplier_Name,

Line 693: insert into POA_PORTAL_RISK_SUMMARY (

689: Supplier.tprt_name;
690:
691: p_count := sql%rowcount;
692:
693: insert into POA_PORTAL_RISK_SUMMARY (
694: Status,
695: Risk_Category,
696: Supplier_PK_Key,
697: Supplier_Name,

Line 788: insert into POA_PORTAL_RISK_SUMMARY (

784: Supplier.tprt_name;
785:
786: p_count := p_count + sql%rowcount;
787:
788: insert into POA_PORTAL_RISK_SUMMARY (
789: Status,
790: Risk_Category,
791: Supplier_PK_Key,
792: Supplier_Name,

Line 893: from POA_PORTAL_RISK_SUMMARY

889: Service,
890: Risk_Category)
891: select 'Problem Suppliers',
892: count(distinct Supplier_PK_key), 0,0,0,0,1
893: from POA_PORTAL_RISK_SUMMARY
894: where (Total_Score <> -999 and
895: Risk_Category = 1);
896:
897: p_count := p_count + sql%rowcount;

Line 909: from POA_PORTAL_RISK_SUMMARY

905: Service,
906: Risk_Category)
907: select 'Problem Suppliers',
908: 0, count(distinct Supplier_PK_key), 0,0,0,1
909: from POA_PORTAL_RISK_SUMMARY
910: where (Price_Score <> -999 and
911: Risk_Category = 1);
912:
913: p_count := p_count + sql%rowcount;

Line 925: from POA_PORTAL_RISK_SUMMARY

921: Service,
922: Risk_Category)
923: select 'Problem Suppliers',
924: 0, 0, count(distinct Supplier_PK_key), 0,0,1
925: from POA_PORTAL_RISK_SUMMARY
926: where (Quality_Score <> -999 and
927: Risk_Category = 1);
928:
929: p_count := p_count + sql%rowcount;

Line 941: from POA_PORTAL_RISK_SUMMARY

937: Service,
938: Risk_Category)
939: select 'Problem Suppliers',
940: 0, 0, 0, count(distinct Supplier_PK_key), 0,1
941: from POA_PORTAL_RISK_SUMMARY
942: where (Delivery_Score <> -999 and
943: Risk_Category = 1);
944:
945: p_count := p_count + sql%rowcount;

Line 957: from POA_PORTAL_RISK_SUMMARY

953: Service,
954: Risk_Category)
955: select 'Problem Suppliers',
956: 0, 0, 0, 0, count(distinct Supplier_PK_key),1
957: from POA_PORTAL_RISK_SUMMARY
958: where (Service_Score <> -999 and
959: Risk_Category = 1);
960:
961: p_count := p_count + sql%rowcount;

Line 973: from POA_PORTAL_RISK_SUMMARY

969: Service,
970: Risk_Category)
971: select 'At Risk Suppliers',
972: count(distinct Supplier_PK_key), 0,0,0,0,2
973: from POA_PORTAL_RISK_SUMMARY
974: where (Total_Score <> -999 and
975: Risk_Category = 2);
976:
977: p_count := p_count + sql%rowcount;

Line 989: from POA_PORTAL_RISK_SUMMARY

985: Service,
986: Risk_Category)
987: select 'At Risk Suppliers',
988: 0, count(distinct Supplier_PK_key), 0,0,0,2
989: from POA_PORTAL_RISK_SUMMARY
990: where (Price_Score <> -999 and
991: Risk_Category = 2);
992:
993: p_count := p_count + sql%rowcount;

Line 1005: from POA_PORTAL_RISK_SUMMARY

1001: Service,
1002: Risk_Category)
1003: select 'At Risk Suppliers',
1004: 0, 0, count(distinct Supplier_PK_key), 0,0,2
1005: from POA_PORTAL_RISK_SUMMARY
1006: where (Quality_Score <> -999 and
1007: Risk_Category = 2);
1008:
1009: p_count := p_count + sql%rowcount;

Line 1021: from POA_PORTAL_RISK_SUMMARY

1017: Service,
1018: Risk_Category)
1019: select 'At Risk Suppliers',
1020: 0, 0, 0, count(distinct Supplier_PK_key), 0,2
1021: from POA_PORTAL_RISK_SUMMARY
1022: where (Delivery_Score <> -999 and
1023: Risk_Category = 2);
1024:
1025: p_count := p_count + sql%rowcount;

Line 1037: from POA_PORTAL_RISK_SUMMARY

1033: Service,
1034: Risk_Category)
1035: select 'At Risk Suppliers',
1036: 0, 0, 0, 0, count(distinct Supplier_PK_key),2
1037: from POA_PORTAL_RISK_SUMMARY
1038: where (Service_Score <> -999 and
1039: Risk_Category = 2);
1040:
1041: p_count := p_count + sql%rowcount;

Line 1053: from POA_PORTAL_RISK_SUMMARY

1049: Service,
1050: Risk_Category)
1051: select 'Good Suppliers',
1052: count(distinct Supplier_PK_key), 0,0,0,0,3
1053: from POA_PORTAL_RISK_SUMMARY
1054: where (Total_Score <> -999 and
1055: Risk_Category = 3);
1056:
1057: p_count := p_count + sql%rowcount;

Line 1069: from POA_PORTAL_RISK_SUMMARY

1065: Service,
1066: Risk_Category)
1067: select 'Good Suppliers',
1068: 0, count(distinct Supplier_PK_key), 0,0,0,3
1069: from POA_PORTAL_RISK_SUMMARY
1070: where (Price_Score <> -999 and
1071: Risk_Category = 3);
1072:
1073: p_count := p_count + sql%rowcount;

Line 1085: from POA_PORTAL_RISK_SUMMARY

1081: Service,
1082: Risk_Category)
1083: select 'Good Suppliers',
1084: 0, 0, count(distinct Supplier_PK_key), 0,0,3
1085: from POA_PORTAL_RISK_SUMMARY
1086: where (Quality_Score <> -999 and
1087: Risk_Category = 3);
1088:
1089: p_count := p_count + sql%rowcount;

Line 1101: from POA_PORTAL_RISK_SUMMARY

1097: Service,
1098: Risk_Category)
1099: select 'Good Suppliers',
1100: 0, 0, 0, count(distinct Supplier_PK_key), 0,3
1101: from POA_PORTAL_RISK_SUMMARY
1102: where (Delivery_Score <> -999 and
1103: Risk_Category = 3);
1104:
1105: p_count := p_count + sql%rowcount;

Line 1117: from POA_PORTAL_RISK_SUMMARY

1113: Service,
1114: Risk_Category)
1115: select 'Good Suppliers',
1116: 0, 0, 0, 0, count(distinct Supplier_PK_key),3
1117: from POA_PORTAL_RISK_SUMMARY
1118: where (Service_Score <> -999 and
1119: Risk_Category = 3);
1120:
1121: p_count := p_count + sql%rowcount;