eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_SRP_PMT_PLANS_PUB dependencies on CN_SALESREPS

Line 25: x_srp_start_date OUT NOCOPY cn_salesreps.start_date_active%TYPE,

21: x_msg_count OUT NOCOPY NUMBER ,
22: x_msg_data OUT NOCOPY VARCHAR2 ,
23: p_srp_pmt_plans_rec IN srp_pmt_plans_rec_type,
24: x_srp_pmt_plans_row IN OUT NOCOPY cn_srp_pmt_plans%ROWTYPE ,
25: x_srp_start_date OUT NOCOPY cn_salesreps.start_date_active%TYPE,
26: x_srp_end_date OUT NOCOPY cn_salesreps.end_date_active%TYPE,
27: x_pp_start_date OUT NOCOPY cn_pmt_plans.start_date%TYPE,
28: x_pp_end_date OUT NOCOPY cn_pmt_plans.end_date%TYPE,
29: p_action IN VARCHAR2 := 'VALIDATE',

Line 26: x_srp_end_date OUT NOCOPY cn_salesreps.end_date_active%TYPE,

22: x_msg_data OUT NOCOPY VARCHAR2 ,
23: p_srp_pmt_plans_rec IN srp_pmt_plans_rec_type,
24: x_srp_pmt_plans_row IN OUT NOCOPY cn_srp_pmt_plans%ROWTYPE ,
25: x_srp_start_date OUT NOCOPY cn_salesreps.start_date_active%TYPE,
26: x_srp_end_date OUT NOCOPY cn_salesreps.end_date_active%TYPE,
27: x_pp_start_date OUT NOCOPY cn_pmt_plans.start_date%TYPE,
28: x_pp_end_date OUT NOCOPY cn_pmt_plans.end_date%TYPE,
29: p_action IN VARCHAR2 := 'VALIDATE',
30: p_loading_status IN VARCHAR2,

Line 92: FROM cn_salesreps

88: -- get salesrep start date, end date
89: BEGIN
90: SELECT start_date_active,end_date_active
91: INTO x_srp_start_date,x_srp_end_date
92: FROM cn_salesreps
93: WHERE salesrep_id = x_srp_pmt_plans_row.salesrep_id
94: AND org_id = x_srp_pmt_plans_row.org_id;
95: EXCEPTION
96: WHEN NO_DATA_FOUND THEN

Line 158: l_srp_start_date cn_salesreps.start_date_active%TYPE;

154: --Bug 3432689 by Julia Huang on 4/29/04.
155:
156: l_dummy NUMBER;
157: l_dummy2 NUMBER;
158: l_srp_start_date cn_salesreps.start_date_active%TYPE;
159: l_srp_end_date cn_salesreps.end_date_active%TYPE;
160: l_pp_start_date cn_pmt_plans.start_date%TYPE;
161: l_pp_end_date cn_pmt_plans.end_date%TYPE;
162: l_pp_min cn_pmt_plans.minimum_amount%TYPE;

Line 159: l_srp_end_date cn_salesreps.end_date_active%TYPE;

155:
156: l_dummy NUMBER;
157: l_dummy2 NUMBER;
158: l_srp_start_date cn_salesreps.start_date_active%TYPE;
159: l_srp_end_date cn_salesreps.end_date_active%TYPE;
160: l_pp_start_date cn_pmt_plans.start_date%TYPE;
161: l_pp_end_date cn_pmt_plans.end_date%TYPE;
162: l_pp_min cn_pmt_plans.minimum_amount%TYPE;
163: l_pp_max cn_pmt_plans.maximum_amount%TYPE;

Line 652: l_srp_start_date cn_salesreps.start_date_active%TYPE;

648: l_status VARCHAR2(1);
649:
650: l_start_date cn_srp_pmt_plans.start_date%TYPE;
651: l_end_date cn_srp_pmt_plans.end_date%TYPE;
652: l_srp_start_date cn_salesreps.start_date_active%TYPE;
653: l_srp_end_date cn_salesreps.end_date_active%TYPE;
654: l_pp_start_date cn_pmt_plans.start_date%TYPE;
655: l_pp_end_date cn_pmt_plans.end_date%TYPE;
656: l_action VARCHAR2(30) := 'UPDATE';

Line 653: l_srp_end_date cn_salesreps.end_date_active%TYPE;

649:
650: l_start_date cn_srp_pmt_plans.start_date%TYPE;
651: l_end_date cn_srp_pmt_plans.end_date%TYPE;
652: l_srp_start_date cn_salesreps.start_date_active%TYPE;
653: l_srp_end_date cn_salesreps.end_date_active%TYPE;
654: l_pp_start_date cn_pmt_plans.start_date%TYPE;
655: l_pp_end_date cn_pmt_plans.end_date%TYPE;
656: l_action VARCHAR2(30) := 'UPDATE';
657: l_srp_pmt_plan_id cn_srp_pmt_plans.srp_pmt_plan_id%TYPE;

Line 1076: l_srp_start_date cn_salesreps.start_date_active%TYPE;

1072: l_api_version CONSTANT NUMBER := 1.0;
1073: l_spp_rec srp_pmt_plans_rec_type := G_MISS_SRP_PMT_PLANS_REC;
1074: l_spp_row cn_srp_pmt_plans%ROWTYPE;
1075:
1076: l_srp_start_date cn_salesreps.start_date_active%TYPE;
1077: l_srp_end_date cn_salesreps.end_date_active%TYPE;
1078: l_pp_start_date cn_pmt_plans.start_date%TYPE;
1079: l_pp_end_date cn_pmt_plans.end_date%TYPE;
1080:

Line 1077: l_srp_end_date cn_salesreps.end_date_active%TYPE;

1073: l_spp_rec srp_pmt_plans_rec_type := G_MISS_SRP_PMT_PLANS_REC;
1074: l_spp_row cn_srp_pmt_plans%ROWTYPE;
1075:
1076: l_srp_start_date cn_salesreps.start_date_active%TYPE;
1077: l_srp_end_date cn_salesreps.end_date_active%TYPE;
1078: l_pp_start_date cn_pmt_plans.start_date%TYPE;
1079: l_pp_end_date cn_pmt_plans.end_date%TYPE;
1080:
1081: l_org_id NUMBER;