DBA Data[Home] [Help]

APPS.CN_SRP_QUOTA_ASSIGNS_PKG dependencies on CN_SRP_ROLLOVER_QUOTAS_PKG

Line 323: CN_SRP_ROLLOVER_QUOTAS_PKG.INSERT_ROW

319: -- clku, populate_srp_rollover_quotas
320: FOR l_srp_quota_assign_c IN l_srp_quota_assign_csr(x_quota_id, x_srp_plan_assign_id) LOOP
321: FOR l_rollover_quota_c IN l_rollover_quota_csr(x_quota_id) LOOP
322:
323: CN_SRP_ROLLOVER_QUOTAS_PKG.INSERT_ROW
324: (X_ROWID => l_rowid,
325: X_SRP_ROLLOVER_QUOTA_ID => l_srp_rollover_quota_id,
326: X_SRP_QUOTA_ASSIGN_ID => l_srp_quota_assign_c.srp_quota_assign_id,
327: X_ROLLOVER_QUOTA_ID => l_rollover_quota_c.rollover_quota_id,

Line 408: CN_SRP_ROLLOVER_QUOTAS_PKG.INSERT_ROW

404: -- clku, populate_srp_rollover_quotas
405: FOR l_srp_quota_assign_c2 IN l_srp_quota_assign_csr2(x_srp_plan_assign_id) LOOP
406: FOR l_rollover_quota_c IN l_rollover_quota_csr(l_srp_quota_assign_c2.quota_id) LOOP
407:
408: CN_SRP_ROLLOVER_QUOTAS_PKG.INSERT_ROW
409: (X_ROWID => l_rowid,
410: X_SRP_ROLLOVER_QUOTA_ID => l_srp_rollover_quota_id,
411: X_SRP_QUOTA_ASSIGN_ID => l_srp_quota_assign_c2.srp_quota_assign_id,
412: X_ROLLOVER_QUOTA_ID => l_rollover_quota_c.rollover_quota_id,

Line 939: CN_SRP_ROLLOVER_QUOTAS_PKG.DELETE_ROW

935:
936: -- Delete cn_srp_rollover_quotas records
937:
938: FOR l_srp_rollover_quota_c IN l_srp_rollover_quota_csr(recinfo.srp_quota_assign_id) LOOP
939: CN_SRP_ROLLOVER_QUOTAS_PKG.DELETE_ROW
940: (X_SRP_ROLLOVER_QUOTA_ID => l_srp_rollover_quota_c.srp_rollover_quota_id);
941: END LOOP;
942: END LOOP;
943: close srp_quota_curs;

Line 970: CN_SRP_ROLLOVER_QUOTAS_PKG.DELETE_ROW

966: END LOOP;
967:
968: FOR l_srp_rollover_quota_c IN l_srp_rollover_quota_csr(recinfo.srp_quota_assign_id) LOOP
969:
970: CN_SRP_ROLLOVER_QUOTAS_PKG.DELETE_ROW
971: (X_SRP_ROLLOVER_QUOTA_ID => l_srp_rollover_quota_c.srp_rollover_quota_id);
972: END LOOP;
973:
974: END LOOP;