DBA Data[Home] [Help]

APPS.POA_PORTAL_POPULATE_C dependencies on POA_PORTAL_RCPT_SUM

Line 92: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema ||'.POA_PORTAL_RCPT_SUM';

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';
93: EXECUTE IMMEDIATE l_stmt;
94: END IF;
95:
96: END IF;

Line 1189: INSERT into POA_PORTAL_RCPT_SUM (

1185: p_count OUT NOCOPY NUMBER,
1186: success OUT NOCOPY varchar2) IS
1187: BEGIN
1188:
1189: INSERT into POA_PORTAL_RCPT_SUM (
1190: Operating_Unit_PK_Key,
1191: Operating_Unit_Name,
1192: Organization_PK_Key,
1193: Organization_Name,