APPS.ARP_CRM_PKG dependencies on RA_CUST_RECEIPT_METHODS

Line 17: FROM ra_cust_receipt_methods cpm

13: if (x_meth_type = 'CUST' ) then
14: --
15: SELECT count(1)
16: into overlap_count
17: FROM ra_cust_receipt_methods cpm
18: WHERE cpm.receipt_method_id = x_receipt_method_id
19: AND cpm.customer_id = x_id
20: AND cpm.site_use_id is null
21: AND ((x_cust_receipt_method_id is null) or (cpm.cust_receipt_method_id <> X_cust_receipt_method_id))

Line 36: FROM ra_cust_receipt_methods cpm

32: elsif (x_meth_type = 'SITE') then
33: --
34: SELECT count(1)
35: into overlap_count
36: FROM ra_cust_receipt_methods cpm
37: WHERE cpm.receipt_method_id = x_receipt_method_id
38: AND cpm.site_use_id = x_id
39: AND ((x_cust_receipt_method_id is null) or (cpm.cust_receipt_method_id <> X_cust_receipt_method_id))
40: AND ( trunc(x_start_date) BETWEEN cpm.start_date

Line 67: FROM ra_cust_receipt_methods cpm

63: begin
64: if (x_meth_type = 'CUST' ) then
65: SELECT count(1)
66: INTO primary_count
67: FROM ra_cust_receipt_methods cpm
68: WHERE cpm.primary_flag = 'Y'
69: AND cpm.customer_id = x_id
70: AND cpm.site_use_id is null
71: AND ((x_cust_receipt_method_id is null) or (cpm.cust_receipt_method_id <> x_cust_receipt_method_id))

Line 87: FROM ra_cust_receipt_methods cpm

83:
84: elsif( x_meth_type = 'SITE' ) then
85: SELECT count(1)
86: INTO primary_count
87: FROM ra_cust_receipt_methods cpm
88: WHERE cpm.primary_flag = 'Y'
89: AND cpm.site_use_id = x_id
90: AND ((x_cust_receipt_method_id is null) or (cpm.cust_receipt_method_id <> x_cust_receipt_method_id))
91: AND (trunc(x_start_date) BETWEEN cpm.start_date

Line 137: CURSOR C IS SELECT rowid FROM ra_cust_receipt_methods

133: X_Attribute13 VARCHAR2,
134: X_Attribute14 VARCHAR2,
135: X_Attribute15 VARCHAR2
136: ) IS
137: CURSOR C IS SELECT rowid FROM ra_cust_receipt_methods
138: WHERE cust_receipt_method_id = X_Cust_Receipt_Method_Id;
139:
140: meth_type varchar2(4);
141: id number(15);

Line 157: select ra_cust_receipt_methods_s.nextval

153: if (x_primary_flag = 'Y') then
154: check_primary(x_cust_receipt_method_id,x_start_date,x_end_date,meth_type,id);
155: end if;
156:
157: select ra_cust_receipt_methods_s.nextval
158: into x_cust_receipt_method_id
159: from dual;
160:
161: INSERT INTO ra_cust_receipt_methods(

Line 161: INSERT INTO ra_cust_receipt_methods(

157: select ra_cust_receipt_methods_s.nextval
158: into x_cust_receipt_method_id
159: from dual;
160:
161: INSERT INTO ra_cust_receipt_methods(
162: cust_receipt_method_id,
163: created_by,
164: creation_date,
165: customer_id,

Line 259: FROM ra_cust_receipt_methods

255: X_Attribute15 VARCHAR2
256: ) IS
257: CURSOR C IS
258: SELECT *
259: FROM ra_cust_receipt_methods
260: WHERE rowid = X_Rowid
261: FOR UPDATE of Cust_Receipt_Method_Id NOWAIT;
262: Recinfo C%ROWTYPE;
263:

Line 389: UPDATE ra_cust_receipt_methods

385: if (x_primary_flag = 'Y') then
386: check_primary(x_cust_receipt_method_id,x_start_date,x_end_date,meth_type,id);
387: end if;
388:
389: UPDATE ra_cust_receipt_methods
390: SET
391: cust_receipt_method_id = X_Cust_Receipt_Method_Id,
392: customer_id = X_Customer_Id,
393: last_updated_by = X_Last_Updated_By,