APPS.JG_ZZ_AR_AUTO_INVOICE dependencies on RA_CUSTOMER_TRX_ALL

Line 47: From ra_customer_trx_all l

43: Procedure Trx_Num_Upd (p_request_id In Number) Is
44: Cursor C_Trx_Lines (x_request_id Number) Is
45: Select l.trx_number
46: ,l.customer_trx_id
47: From ra_customer_trx_all l
48: Where l.request_id = x_request_id
49: And l.complete_flag = 'Y'
50: And l.customer_trx_id Is Not Null;
51:

Line 61: TYPE trx_id is Table of ra_customer_trx_all.customer_trx_id%Type;

57: global_attribute9
58: FROM ra_batch_sources_all
59: WHERE batch_source_id = l_batch_source_id;
60:
61: TYPE trx_id is Table of ra_customer_trx_all.customer_trx_id%Type;
62: TYPE trx_num is Table of ra_customer_trx_all.trx_number%Type;
63:
64: customer_trx_id trx_id;
65: trx_number trx_num;

Line 62: TYPE trx_num is Table of ra_customer_trx_all.trx_number%Type;

58: FROM ra_batch_sources_all
59: WHERE batch_source_id = l_batch_source_id;
60:
61: TYPE trx_id is Table of ra_customer_trx_all.customer_trx_id%Type;
62: TYPE trx_num is Table of ra_customer_trx_all.trx_number%Type;
63:
64: customer_trx_id trx_id;
65: trx_number trx_num;
66:

Line 137: Update ra_customer_trx_all

133: End If;
134: End Loop;
135:
136: Forall j in customer_trx_id.FIRST .. customer_trx_id.LAST
137: Update ra_customer_trx_all
138: Set trx_number = trx_number(j)
139: Where customer_trx_id = customer_trx_id(j)
140: and request_id = p_request_id;
141: End If;

Line 161: FROM ra_customer_trx_all A, ra_customer_trx_all B

157: --Start
158: IF l_batch_source_id IS NULL THEN
159:
160: SELECT B.batch_source_id INTO temp1
161: FROM ra_customer_trx_all A, ra_customer_trx_all B
162: WHERE A.RECURRED_FROM_TRX_NUMBER = B.trx_number
163: AND A.trx_number = trx_number(1) AND B.ORG_ID = f_org_id and rownum =1;
164: BEGIN
165:

Line 209: UPDATE ra_customer_trx_all

205: END IF;
206: END LOOP;
207:
208: FORALL j IN customer_trx_id.FIRST .. customer_trx_id.LAST
209: UPDATE ra_customer_trx_all
210: SET trx_number = trx_number(j),
211: global_attribute17 = l_cai_num,
212: global_attribute18 = l_cai_due_date
213: WHERE customer_trx_id = customer_trx_id(j)

Line 227: FROM ra_customer_trx_all l

223:
224: PROCEDURE val_trx_range (p_request_id IN Number, p_flag OUT NOCOPY Number) IS
225: CURSOR C_Trx_Lines IS
226: SELECT l.customer_trx_id
227: FROM ra_customer_trx_all l
228: WHERE l.request_id = p_request_id
229: --And l.complete_flag = 'Y'
230: AND l.customer_trx_id IS NOT NULL;
231:

Line 239: TYPE trx_id IS TABLE OF ra_customer_trx_all.customer_trx_id%Type;

235: WHERE A.customer_trx_id = p_trx_id AND
236: A.customer_trx_line_id = B.customer_trx_line_id
237: AND ROWNUM = 1;
238:
239: TYPE trx_id IS TABLE OF ra_customer_trx_all.customer_trx_id%Type;
240:
241: customer_trx_id trx_id;
242:
243: l_batch_source_id Number;