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 352: CN_SRP_PERIODS_PVT.Update_Delta_Srp_Pds_No_Sync

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

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

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

Line 383: CN_SRP_PERIODS_PVT.Sync_Accum_Balances_Start_Pd

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

Line 411: cn_srp_periods_pvt.sync_accum_balances_start_pd

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