APPS.POA_PORTAL_POPULATE_C dependencies on POA_PORTAL_RISK_IND

Line 86: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema ||'.POA_PORTAL_RISK_IND';

82: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema ||'.POA_PORTAL_PDIST2';
83: EXECUTE IMMEDIATE l_stmt;
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';

Line 883: insert into POA_PORTAL_RISK_IND (

879: Supplier.tprt_name;
880:
881: p_count := p_count + sql%rowcount;
882:
883: insert into POA_PORTAL_RISK_IND (
884: Status,
885: Aggregate,
886: Price,
887: Quality,

Line 899: insert into POA_PORTAL_RISK_IND (

895: Risk_Category = 1);
896:
897: p_count := p_count + sql%rowcount;
898:
899: insert into POA_PORTAL_RISK_IND (
900: Status,
901: Aggregate,
902: Price,
903: Quality,

Line 915: insert into POA_PORTAL_RISK_IND (

911: Risk_Category = 1);
912:
913: p_count := p_count + sql%rowcount;
914:
915: insert into POA_PORTAL_RISK_IND (
916: Status,
917: Aggregate,
918: Price,
919: Quality,

Line 931: insert into POA_PORTAL_RISK_IND (

927: Risk_Category = 1);
928:
929: p_count := p_count + sql%rowcount;
930:
931: insert into POA_PORTAL_RISK_IND (
932: Status,
933: Aggregate,
934: Price,
935: Quality,

Line 947: insert into POA_PORTAL_RISK_IND (

943: Risk_Category = 1);
944:
945: p_count := p_count + sql%rowcount;
946:
947: insert into POA_PORTAL_RISK_IND (
948: Status,
949: Aggregate,
950: Price,
951: Quality,

Line 963: insert into POA_PORTAL_RISK_IND (

959: Risk_Category = 1);
960:
961: p_count := p_count + sql%rowcount;
962:
963: insert into POA_PORTAL_RISK_IND (
964: Status,
965: Aggregate,
966: Price,
967: Quality,

Line 979: insert into POA_PORTAL_RISK_IND (

975: Risk_Category = 2);
976:
977: p_count := p_count + sql%rowcount;
978:
979: insert into POA_PORTAL_RISK_IND (
980: Status,
981: Aggregate,
982: Price,
983: Quality,

Line 995: insert into POA_PORTAL_RISK_IND (

991: Risk_Category = 2);
992:
993: p_count := p_count + sql%rowcount;
994:
995: insert into POA_PORTAL_RISK_IND (
996: Status,
997: Aggregate,
998: Price,
999: Quality,

Line 1011: insert into POA_PORTAL_RISK_IND (

1007: Risk_Category = 2);
1008:
1009: p_count := p_count + sql%rowcount;
1010:
1011: insert into POA_PORTAL_RISK_IND (
1012: Status,
1013: Aggregate,
1014: Price,
1015: Quality,

Line 1027: insert into POA_PORTAL_RISK_IND (

1023: Risk_Category = 2);
1024:
1025: p_count := p_count + sql%rowcount;
1026:
1027: insert into POA_PORTAL_RISK_IND (
1028: Status,
1029: Aggregate,
1030: Price,
1031: Quality,

Line 1043: insert into POA_PORTAL_RISK_IND (

1039: Risk_Category = 2);
1040:
1041: p_count := p_count + sql%rowcount;
1042:
1043: insert into POA_PORTAL_RISK_IND (
1044: Status,
1045: Aggregate,
1046: Price,
1047: Quality,

Line 1059: insert into POA_PORTAL_RISK_IND (

1055: Risk_Category = 3);
1056:
1057: p_count := p_count + sql%rowcount;
1058:
1059: insert into POA_PORTAL_RISK_IND (
1060: Status,
1061: Aggregate,
1062: Price,
1063: Quality,

Line 1075: insert into POA_PORTAL_RISK_IND (

1071: Risk_Category = 3);
1072:
1073: p_count := p_count + sql%rowcount;
1074:
1075: insert into POA_PORTAL_RISK_IND (
1076: Status,
1077: Aggregate,
1078: Price,
1079: Quality,

Line 1091: insert into POA_PORTAL_RISK_IND (

1087: Risk_Category = 3);
1088:
1089: p_count := p_count + sql%rowcount;
1090:
1091: insert into POA_PORTAL_RISK_IND (
1092: Status,
1093: Aggregate,
1094: Price,
1095: Quality,

Line 1107: insert into POA_PORTAL_RISK_IND (

1103: Risk_Category = 3);
1104:
1105: p_count := p_count + sql%rowcount;
1106:
1107: insert into POA_PORTAL_RISK_IND (
1108: Status,
1109: Aggregate,
1110: Price,
1111: Quality,