DBA Data[Home] [Help]

APPS.CN_CALC_SUBLEDGER_PVT dependencies on CN_SRP_PERIODS_PVT

Line 89: l_delta_subledger cn_srp_periods_pvt.delta_srp_period_rec_type

85: l_period_id NUMBER(15);
86:
87: l_calc_type VARCHAR2(30);
88:
89: l_delta_subledger cn_srp_periods_pvt.delta_srp_period_rec_type
90: := CN_SRP_PERIODS_PVT.G_MISS_DELTA_SRP_PERIOD_REC;
91:
92: CURSOR salesrep_cr IS
93: SELECT salesrep_id, start_date, end_date, period_id, end_period_id

Line 90: := CN_SRP_PERIODS_PVT.G_MISS_DELTA_SRP_PERIOD_REC;

86:
87: l_calc_type VARCHAR2(30);
88:
89: l_delta_subledger cn_srp_periods_pvt.delta_srp_period_rec_type
90: := CN_SRP_PERIODS_PVT.G_MISS_DELTA_SRP_PERIOD_REC;
91:
92: CURSOR salesrep_cr IS
93: SELECT salesrep_id, start_date, end_date, period_id, end_period_id
94: FROM cn_process_batches_all

Line 350: CN_SRP_PERIODS_PVT.Update_Delta_Srp_Pds_No_Sync

346: l_delta_subledger.del_balance2_dtd := nvl(l_earnings, 0) - l_subledger.earnings_due_ptd;
347:
348: -- call update API
349: if (l_delta_subledger.del_balance3_ctd <> 0 OR l_delta_subledger.del_balance2_dtd <> 0) then
350: CN_SRP_PERIODS_PVT.Update_Delta_Srp_Pds_No_Sync
351: (p_api_version => 1.0,
352: x_return_status => l_return_status,
353: x_msg_count => l_msg_count,
354: x_msg_data => l_msg_data,

Line 359: cn_message_pkg.debug('Exception occurs in cn_srp_periods_pvt.update_delta_srp_periods:');

355: p_del_srp_prd_rec => l_delta_subledger,
356: x_loading_status => l_loading_status
357: );
358: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
359: cn_message_pkg.debug('Exception occurs in cn_srp_periods_pvt.update_delta_srp_periods:');
360: cn_message_pkg.debug(l_msg_data);
361: raise FND_API.g_exc_error;
362: end if;
363:

Line 381: CN_SRP_PERIODS_PVT.Sync_Accum_Balances_Start_Pd

377: if r.role_id <> G_PAYEE_ROLE then
378: cn_message_pkg.debug('Synchonizing balances for salesrep (salesrep_id='||l_salesrep_id ||
379: ' role_id=' || r.role_id || ' start_period_id=' || l_start_period_id||')');
380:
381: CN_SRP_PERIODS_PVT.Sync_Accum_Balances_Start_Pd
382: (p_salesrep_id => l_salesrep_id,
383: p_credit_type_id => r.credit_type_id,
384: p_role_id => r.role_id,
385: p_start_period_id => l_start_period_id,

Line 409: cn_srp_periods_pvt.sync_accum_balances_start_pd

405: where srp_period_id = payee.srp_period_id;
406: end loop;
407:
408: for rec in sync_recs_cr loop
409: cn_srp_periods_pvt.sync_accum_balances_start_pd
410: (p_salesrep_id => rec.salesrep_id,
411: p_credit_type_id => rec.credit_type_id,
412: p_role_id => g_payee_role,
413: p_start_period_id => rec.period_id,