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_QUOTA_PAY_ELEMENTS_PVT dependencies on CN_QUOTA_PAY_ELEMENTS

Line 1: PACKAGE BODY CN_QUOTA_PAY_ELEMENTS_PVT AS

1: PACKAGE BODY CN_QUOTA_PAY_ELEMENTS_PVT AS
2: /* $Header: cnvqpeb.pls 115.16.115100.2 2004/05/13 00:52:57 jjhuang ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_QUOTA_PAY_ELEMENT_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cnvqpeb.pls';

Line 92: cn_quota_pay_elements qpe,

88: SELECT qpe.quota_pay_element_id,qpe.quota_id,qpe.pay_element_type_id,qpe.status,
89: MIN(ps.start_date) start_date, MAX(ps.end_date) end_date
90: FROM cn_period_statuses ps,
91: cn_payment_transactions pt,
92: cn_quota_pay_elements qpe,
93: cn_salesreps cs,
94: cn_quotas cq
95: WHERE pt.credited_salesrep_id = cs.salesrep_id
96: AND pt.pay_period_id = ps.period_id

Line 114: cn_quota_pay_elements qpe,

110: SELECT qpe.quota_pay_element_id,qpe.quota_id,qpe.pay_element_type_id,qpe.status,
111: MIN(ps.start_date) start_date, MAX(ps.end_date) end_date
112: FROM cn_period_statuses ps,
113: cn_payment_transactions pt,
114: cn_quota_pay_elements qpe,
115: cn_salesreps cs,
116: cn_quotas cq
117: WHERE pt.credited_salesrep_id = cs.salesrep_id
118: AND pt.pay_period_id = ps.period_id

Line 160: cn_quota_pay_elements qpe,

156: SELECT qpe.quota_pay_element_id,qpe.quota_id,qpe.pay_element_type_id,qpe.status,
157: MIN(ps.start_date) start_date, MAX(ps.end_date) end_date
158: FROM cn_period_statuses ps,
159: cn_payment_transactions pt,
160: cn_quota_pay_elements qpe,
161: cn_salesreps cs,
162: cn_quotas cq
163: WHERE pt.credited_salesrep_id = cs.salesrep_id
164: AND pt.pay_period_id = ps.period_id

Line 182: cn_quota_pay_elements qpe,

178: SELECT qpe.quota_pay_element_id,qpe.quota_id,qpe.pay_element_type_id,qpe.status,
179: MIN(ps.start_date) start_date, MAX(ps.end_date) end_date
180: FROM cn_period_statuses ps,
181: cn_payment_transactions pt,
182: cn_quota_pay_elements qpe,
183: cn_salesreps cs,
184: cn_quotas cq
185: WHERE pt.credited_salesrep_id = cs.salesrep_id
186: AND pt.pay_period_id = ps.period_id

Line 343: from cn_quota_pay_elements

339: l_quota_id NUMBER;
340:
341: cursor get_old( p_quota_pay_element_id NUMBER) is
342: select *
343: from cn_quota_pay_elements
344: where quota_pay_element_id = p_quota_pay_element_id;
345:
346: l_old_rec get_old%ROWTYPE;
347:

Line 441: FROM cn_quota_pay_elements

437: BEGIN
438: SELECT 1 INTO l_dummy FROM dual
439: WHERE NOT EXISTS
440: ( SELECT 1
441: FROM cn_quota_pay_elements
442: WHERE quota_id = p_quota_pay_element_rec.quota_id
443: AND pay_element_type_id = p_quota_pay_element_rec.pay_element_type_id
444: AND nvl(status,'A') = nvl(p_quota_pay_element_rec.status,'A')
445: AND start_date = p_quota_pay_element_rec.start_date

Line 481: FROM cn_quota_pay_elements

477: BEGIN
478: SELECT 1 INTO l_dummy FROM dual
479: WHERE NOT EXISTS
480: ( SELECT 1
481: FROM cn_quota_pay_elements
482: WHERE (((end_date IS NULL)
483: AND (p_quota_pay_element_rec.end_date IS NULL))
484: OR
485: ((end_date IS NULL) AND

Line 610: l_qpe_row cn_quota_pay_elements%ROWTYPE ;

606: l_api_name CONSTANT VARCHAR2(30) := 'Create_quota_pay_element';
607: l_api_version CONSTANT NUMBER := 1.0;
608:
609: l_quota_pay_element_rec quota_pay_element_rec_type := G_MISS_QUOTA_PAY_ELEMENT_REC;
610: l_qpe_row cn_quota_pay_elements%ROWTYPE ;
611:
612: l_salesrep_id cn_srp_pmt_plans.salesrep_id%TYPE;
613: l_role_id cn_srp_pmt_plans.role_id%TYPE;
614: l_start_date cn_srp_pmt_plans.start_date%TYPE;

Line 710: -- Create cn_quota_pay_elements

706: );
707: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
708: RAISE FND_API.G_EXC_ERROR ;
709: ELSE
710: -- Create cn_quota_pay_elements
711: cn_quota_pay_elements_pkg.insert_row
712: (x_quota_pay_element_id => l_quota_pay_element_rec.quota_pay_element_id
713: ,p_quota_id => l_quota_pay_element_rec.quota_id
714: ,p_pay_element_type_id => l_quota_pay_element_rec.pay_element_type_id

Line 711: cn_quota_pay_elements_pkg.insert_row

707: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
708: RAISE FND_API.G_EXC_ERROR ;
709: ELSE
710: -- Create cn_quota_pay_elements
711: cn_quota_pay_elements_pkg.insert_row
712: (x_quota_pay_element_id => l_quota_pay_element_rec.quota_pay_element_id
713: ,p_quota_id => l_quota_pay_element_rec.quota_id
714: ,p_pay_element_type_id => l_quota_pay_element_rec.pay_element_type_id
715: ,p_status => l_quota_pay_element_rec.status

Line 892: cn_quota_pay_elements_pkg.update_row

888: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
889: RAISE FND_API.G_EXC_ERROR ;
890: ELSE
891: -- Update
892: cn_quota_pay_elements_pkg.update_row
893: (p_quota_pay_element_id => l_quota_pay_element_rec.quota_pay_element_id
894: ,p_quota_id => l_quota_pay_element_rec.quota_id
895: ,p_pay_element_type_id => l_quota_pay_element_rec.pay_element_type_id
896: ,p_status => l_quota_pay_element_rec.status

Line 1014: cn_quota_pay_elements_pkg.delete_row

1010:
1011: END IF;
1012:
1013: -- Delete record
1014: cn_quota_pay_elements_pkg.delete_row
1015: (p_quota_pay_element_id =>p_quota_pay_element_id);
1016: --
1017: -- End of API body.
1018: --

Line 1103: l_status cn_quota_pay_elements.status%TYPE;

1099:
1100: l_quota_pay_element_id NUMBER;
1101: l_quota_id NUMBER;
1102: l_pay_element_type_id NUMBER;
1103: l_status cn_quota_pay_elements.status%TYPE;
1104: l_start_date DATE;
1105: l_end_date DATE;
1106:
1107: l_quota_name cn_quotas.name%type;

Line 1122: FROM cn_quota_pay_elements cqpe,

1118: cq.name,
1119: cpet.element_name,
1120: cpet.effective_start_date,
1121: cpet.effective_end_Date
1122: FROM cn_quota_pay_elements cqpe,
1123: pay_element_types_f cpet,
1124: cn_quota_lookups_v cq,
1125: gl_sets_of_books glsob,
1126: cn_repositories cnr

Line 1147: FROM cn_quota_pay_elements cqpe,

1143: cq.name,
1144: cpet.element_name,
1145: cpet.effective_start_date,
1146: cpet.effective_end_Date
1147: FROM cn_quota_pay_elements cqpe,
1148: pay_element_types_f cpet,
1149: cn_quota_lookups_v cq,
1150: gl_sets_of_books glsob,
1151: cn_repositories cnr

Line 1317: END CN_QUOTA_PAY_ELEMENTS_PVT ;

1313: p_encoded => FND_API.G_FALSE
1314: );
1315: END Get_quota_pay_element;
1316:
1317: END CN_QUOTA_PAY_ELEMENTS_PVT ;