APPS.CN_SRP_PERIOD_QUOTAS_PKG dependencies on CN_SRP_PERIOD_QUOTAS_EXT_ALL

Line 1438: insert into cn_srp_period_quotas_ext_all

1434: l_number_dim := x_number_dim;
1435: END IF;
1436:
1437: FOR i_seq in 2..l_number_dim LOOP
1438: insert into cn_srp_period_quotas_ext_all
1439: (
1440: srp_period_quota_ext_id,
1441: srp_period_quota_id,
1442: input_sequence,

Line 1458: from dual where not exists ( select 1 from cn_srp_period_quotas_ext_all

1454: l_login_id,
1455: sysdate,
1456: l_user_id,
1457: x_org_id
1458: from dual where not exists ( select 1 from cn_srp_period_quotas_ext_all
1459: where srp_period_quota_id = x_srp_period_quota_id
1460: and input_sequence = i_seq );
1461: END LOOP;
1462: ELSIF x_operation = 'DELETE' THEN

Line 1463: DELETE FROM cn_srp_period_quotas_ext_all

1459: where srp_period_quota_id = x_srp_period_quota_id
1460: and input_sequence = i_seq );
1461: END LOOP;
1462: ELSIF x_operation = 'DELETE' THEN
1463: DELETE FROM cn_srp_period_quotas_ext_all
1464: WHERE srp_period_quota_id = x_srp_period_quota_id;
1465: END IF;
1466: END;
1467: