APPS.CN_PAYRUN_PVT dependencies on CN_SRP_PERIODS

Line 2810: l_srp_prd_rec cn_srp_periods_pvt.delta_srp_period_rec_type

2806: -- for API calls
2807: l_loading_status VARCHAR2(30);
2808: l_rowid VARCHAR2(30);
2809:
2810: l_srp_prd_rec cn_srp_periods_pvt.delta_srp_period_rec_type
2811: := cn_srp_periods_pvt.g_miss_delta_srp_period_rec;
2812: l_note_msg VARCHAR2(240);
2813: l_note_id NUMBER;
2814: l_status_meaning cn_payruns.status%TYPE;

Line 2811: := cn_srp_periods_pvt.g_miss_delta_srp_period_rec;

2807: l_loading_status VARCHAR2(30);
2808: l_rowid VARCHAR2(30);
2809:
2810: l_srp_prd_rec cn_srp_periods_pvt.delta_srp_period_rec_type
2811: := cn_srp_periods_pvt.g_miss_delta_srp_period_rec;
2812: l_note_msg VARCHAR2(240);
2813: l_note_id NUMBER;
2814: l_status_meaning cn_payruns.status%TYPE;
2815:

Line 2847: FROM cn_srp_periods

2843: p_period_id NUMBER,
2844: p_quota_id NUMBER,
2845: p_org_id cn_payruns.org_id%TYPE) IS
2846: SELECT srp_period_id
2847: FROM cn_srp_periods
2848: WHERE salesrep_id = p_salesrep_id
2849: AND credit_type_id = l_credit_type_id
2850: AND period_id = p_period_id
2851: AND (quota_id = p_quota_id

Line 2946: FROM cn_srp_periods sprd

2942: CURSOR carry_over_srp_period(c_salesrep_id NUMBER,
2943: c_period_id NUMBER,
2944: p_org_id cn_payruns.org_id%TYPE) IS
2945: SELECT sprd.srp_period_id
2946: FROM cn_srp_periods sprd
2947: WHERE
2948: sprd.salesrep_id = c_salesrep_id
2949: AND sprd.period_id = c_period_id
2950: AND sprd.quota_id = -1000

Line 2960: FROM cn_srp_periods sprd

2956: CURSOR sync_accum(c_salesrep_id NUMBER,
2957: c_period_id NUMBER,
2958: p_org_id cn_payruns.org_id%TYPE) IS
2959: SELECT DISTINCT sprd.role_id
2960: FROM cn_srp_periods sprd
2961: WHERE
2962: sprd.salesrep_id = c_salesrep_id
2963: AND sprd.period_id = c_period_id
2964: AND sprd.credit_type_id = -1000

Line 3217: cn_srp_periods_pvt.Update_Delta_Srp_Pds_No_Sync

3213: l_tot_recovery := l_tot_recovery + l_recovery;
3214:
3215:
3216: -- update srp periods.09-22-03 BUG 3151860 : change to No_Sync
3217: cn_srp_periods_pvt.Update_Delta_Srp_Pds_No_Sync
3218: (p_api_version => 1.0,
3219: x_return_status => x_return_status,
3220: x_msg_count => x_msg_count,
3221: x_msg_data => x_msg_data,

Line 3251: cn_srp_periods_pvt.Update_Delta_Srp_Pds_No_Sync

3247: FETCH carry_over_srp_period INTO l_srp_prd_rec.srp_period_id;
3248: CLOSE carry_over_srp_period;
3249:
3250: -- update srp periods.09-22-03 BUG 3151860 : change to No_Sync
3251: cn_srp_periods_pvt.Update_Delta_Srp_Pds_No_Sync
3252: (p_api_version => 1.0,
3253: x_return_status => x_return_status,
3254: x_msg_count => x_msg_count,
3255: x_msg_data => x_msg_data,

Line 3309: cn_srp_periods_pvt.Sync_Accum_Balances_Start_Pd

3305: -- record with null quota_id, so remove code for handle null quota_id
3306:
3307: -- call sync_accum for this salesrep. 09-22-03 BUG 3151860
3308: FOR l_sync_accum IN sync_accum(each_srp.salesrep_id,l_payrun_rec.pay_period_id, l_payrun_rec.org_id) LOOP
3309: cn_srp_periods_pvt.Sync_Accum_Balances_Start_Pd
3310: (p_salesrep_id => each_srp.salesrep_id,
3311: --R12
3312: p_org_id => l_payrun_rec.org_id,
3313: p_credit_type_id => -1000,