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.ARRX_RC dependencies on DBMS_SQL

Line 1196: dbms_sql.bind_variable(c, 'p_reporting_entity_id', var.p_reporting_entity_id);

1192: if var.calling_program not in ('RECEIPT','APPLIED','MISC','ACTUAL') THEN
1193:
1194: IF var.p_reporting_level = 3000 then
1195: IF var.p_reporting_entity_id IS NOT NULL THEN
1196: dbms_sql.bind_variable(c, 'p_reporting_entity_id', var.p_reporting_entity_id);
1197: END IF;
1198: END IF;
1199: END IF;
1200:

Line 1202: dbms_sql.bind_variable(c, 'p_deposit_date_low', var.p_deposit_date_low);

1198: END IF;
1199: END IF;
1200:
1201: IF var.p_deposit_date_low IS NOT NULL THEN
1202: dbms_sql.bind_variable(c, 'p_deposit_date_low', var.p_deposit_date_low);
1203: END IF;
1204: IF var.p_deposit_date_high IS NOT NULL THEN
1205: dbms_sql.bind_variable(c, 'p_deposit_date_high', var.p_deposit_date_high);
1206: END IF;

Line 1205: dbms_sql.bind_variable(c, 'p_deposit_date_high', var.p_deposit_date_high);

1201: IF var.p_deposit_date_low IS NOT NULL THEN
1202: dbms_sql.bind_variable(c, 'p_deposit_date_low', var.p_deposit_date_low);
1203: END IF;
1204: IF var.p_deposit_date_high IS NOT NULL THEN
1205: dbms_sql.bind_variable(c, 'p_deposit_date_high', var.p_deposit_date_high);
1206: END IF;
1207:
1208: IF var.p_receipt_date_low IS NOT NULL THEN
1209: dbms_sql.bind_variable(c, 'p_receipt_date_low', var.p_receipt_date_low);

Line 1209: dbms_sql.bind_variable(c, 'p_receipt_date_low', var.p_receipt_date_low);

1205: dbms_sql.bind_variable(c, 'p_deposit_date_high', var.p_deposit_date_high);
1206: END IF;
1207:
1208: IF var.p_receipt_date_low IS NOT NULL THEN
1209: dbms_sql.bind_variable(c, 'p_receipt_date_low', var.p_receipt_date_low);
1210: END IF;
1211: IF var.p_receipt_date_high IS NOT NULL THEN
1212: dbms_sql.bind_variable(c, 'p_receipt_date_high', var.p_receipt_date_high);
1213: END IF;

Line 1212: dbms_sql.bind_variable(c, 'p_receipt_date_high', var.p_receipt_date_high);

1208: IF var.p_receipt_date_low IS NOT NULL THEN
1209: dbms_sql.bind_variable(c, 'p_receipt_date_low', var.p_receipt_date_low);
1210: END IF;
1211: IF var.p_receipt_date_high IS NOT NULL THEN
1212: dbms_sql.bind_variable(c, 'p_receipt_date_high', var.p_receipt_date_high);
1213: END IF;
1214:
1215: IF var.p_gl_date_low IS NOT NULL THEN
1216: dbms_sql.bind_variable(c, 'p_gl_date_low', var.p_gl_date_low);

Line 1216: dbms_sql.bind_variable(c, 'p_gl_date_low', var.p_gl_date_low);

1212: dbms_sql.bind_variable(c, 'p_receipt_date_high', var.p_receipt_date_high);
1213: END IF;
1214:
1215: IF var.p_gl_date_low IS NOT NULL THEN
1216: dbms_sql.bind_variable(c, 'p_gl_date_low', var.p_gl_date_low);
1217: END IF;
1218: IF var.p_gl_date_high IS NOT NULL THEN
1219: dbms_sql.bind_variable(c, 'p_gl_date_high', var.p_gl_date_high);
1220: END IF;

Line 1219: dbms_sql.bind_variable(c, 'p_gl_date_high', var.p_gl_date_high);

1215: IF var.p_gl_date_low IS NOT NULL THEN
1216: dbms_sql.bind_variable(c, 'p_gl_date_low', var.p_gl_date_low);
1217: END IF;
1218: IF var.p_gl_date_high IS NOT NULL THEN
1219: dbms_sql.bind_variable(c, 'p_gl_date_high', var.p_gl_date_high);
1220: END IF;
1221:
1222: IF nvl(var.calling_program ,'not receipt') = 'RECEIPT' THEN
1223: dbms_sql.bind_variable(c, 'c_gl_date_low', var.c_gl_date_low);

Line 1223: dbms_sql.bind_variable(c, 'c_gl_date_low', var.c_gl_date_low);

1219: dbms_sql.bind_variable(c, 'p_gl_date_high', var.p_gl_date_high);
1220: END IF;
1221:
1222: IF nvl(var.calling_program ,'not receipt') = 'RECEIPT' THEN
1223: dbms_sql.bind_variable(c, 'c_gl_date_low', var.c_gl_date_low);
1224: END IF;
1225:
1226: IF var.p_batch_name_low IS NOT NULL THEN
1227: dbms_sql.bind_variable(c, 'p_batch_name_low', var.p_batch_name_low);

Line 1227: dbms_sql.bind_variable(c, 'p_batch_name_low', var.p_batch_name_low);

1223: dbms_sql.bind_variable(c, 'c_gl_date_low', var.c_gl_date_low);
1224: END IF;
1225:
1226: IF var.p_batch_name_low IS NOT NULL THEN
1227: dbms_sql.bind_variable(c, 'p_batch_name_low', var.p_batch_name_low);
1228: END IF;
1229: IF var.p_batch_name_high IS NOT NULL THEN
1230: dbms_sql.bind_variable(c, 'p_batch_name_high', var.p_batch_name_high);
1231: END IF;

Line 1230: dbms_sql.bind_variable(c, 'p_batch_name_high', var.p_batch_name_high);

1226: IF var.p_batch_name_low IS NOT NULL THEN
1227: dbms_sql.bind_variable(c, 'p_batch_name_low', var.p_batch_name_low);
1228: END IF;
1229: IF var.p_batch_name_high IS NOT NULL THEN
1230: dbms_sql.bind_variable(c, 'p_batch_name_high', var.p_batch_name_high);
1231: END IF;
1232: /* bug 5724171*/
1233: IF var.p_customer_name_low IS NOT NULL THEN
1234: dbms_sql.bind_variable(c, 'p_customer_name_low', var.p_customer_name_low);

Line 1234: dbms_sql.bind_variable(c, 'p_customer_name_low', var.p_customer_name_low);

1230: dbms_sql.bind_variable(c, 'p_batch_name_high', var.p_batch_name_high);
1231: END IF;
1232: /* bug 5724171*/
1233: IF var.p_customer_name_low IS NOT NULL THEN
1234: dbms_sql.bind_variable(c, 'p_customer_name_low', var.p_customer_name_low);
1235: dbms_sql.bind_variable(c, 'len1',var.len1);
1236: END IF;
1237: IF var.p_customer_name_high IS NOT NULL THEN
1238: dbms_sql.bind_variable(c, 'p_customer_name_high', var.p_customer_name_high);

Line 1235: dbms_sql.bind_variable(c, 'len1',var.len1);

1231: END IF;
1232: /* bug 5724171*/
1233: IF var.p_customer_name_low IS NOT NULL THEN
1234: dbms_sql.bind_variable(c, 'p_customer_name_low', var.p_customer_name_low);
1235: dbms_sql.bind_variable(c, 'len1',var.len1);
1236: END IF;
1237: IF var.p_customer_name_high IS NOT NULL THEN
1238: dbms_sql.bind_variable(c, 'p_customer_name_high', var.p_customer_name_high);
1239: dbms_sql.bind_variable(c, 'len2',var.len2);

Line 1238: dbms_sql.bind_variable(c, 'p_customer_name_high', var.p_customer_name_high);

1234: dbms_sql.bind_variable(c, 'p_customer_name_low', var.p_customer_name_low);
1235: dbms_sql.bind_variable(c, 'len1',var.len1);
1236: END IF;
1237: IF var.p_customer_name_high IS NOT NULL THEN
1238: dbms_sql.bind_variable(c, 'p_customer_name_high', var.p_customer_name_high);
1239: dbms_sql.bind_variable(c, 'len2',var.len2);
1240: END IF;
1241:
1242: IF var.p_receipt_status_low IS NOT NULL THEN

Line 1239: dbms_sql.bind_variable(c, 'len2',var.len2);

1235: dbms_sql.bind_variable(c, 'len1',var.len1);
1236: END IF;
1237: IF var.p_customer_name_high IS NOT NULL THEN
1238: dbms_sql.bind_variable(c, 'p_customer_name_high', var.p_customer_name_high);
1239: dbms_sql.bind_variable(c, 'len2',var.len2);
1240: END IF;
1241:
1242: IF var.p_receipt_status_low IS NOT NULL THEN
1243: dbms_sql.bind_variable(c, 'p_receipt_status_low', var.p_receipt_status_low);

Line 1243: dbms_sql.bind_variable(c, 'p_receipt_status_low', var.p_receipt_status_low);

1239: dbms_sql.bind_variable(c, 'len2',var.len2);
1240: END IF;
1241:
1242: IF var.p_receipt_status_low IS NOT NULL THEN
1243: dbms_sql.bind_variable(c, 'p_receipt_status_low', var.p_receipt_status_low);
1244: END IF;
1245: IF var.p_receipt_status_high IS NOT NULL THEN
1246: dbms_sql.bind_variable(c, 'p_receipt_status_high', var.p_receipt_status_high);
1247: END IF;

Line 1246: dbms_sql.bind_variable(c, 'p_receipt_status_high', var.p_receipt_status_high);

1242: IF var.p_receipt_status_low IS NOT NULL THEN
1243: dbms_sql.bind_variable(c, 'p_receipt_status_low', var.p_receipt_status_low);
1244: END IF;
1245: IF var.p_receipt_status_high IS NOT NULL THEN
1246: dbms_sql.bind_variable(c, 'p_receipt_status_high', var.p_receipt_status_high);
1247: END IF;
1248:
1249: IF var.p_receipt_number_low IS NOT NULL THEN
1250: dbms_sql.bind_variable(c, 'p_receipt_number_low', var.p_receipt_number_low);

Line 1250: dbms_sql.bind_variable(c, 'p_receipt_number_low', var.p_receipt_number_low);

1246: dbms_sql.bind_variable(c, 'p_receipt_status_high', var.p_receipt_status_high);
1247: END IF;
1248:
1249: IF var.p_receipt_number_low IS NOT NULL THEN
1250: dbms_sql.bind_variable(c, 'p_receipt_number_low', var.p_receipt_number_low);
1251: END IF;
1252: IF var.p_receipt_number_high IS NOT NULL THEN
1253: dbms_sql.bind_variable(c, 'p_receipt_number_high', var.p_receipt_number_high);
1254: END IF;

Line 1253: dbms_sql.bind_variable(c, 'p_receipt_number_high', var.p_receipt_number_high);

1249: IF var.p_receipt_number_low IS NOT NULL THEN
1250: dbms_sql.bind_variable(c, 'p_receipt_number_low', var.p_receipt_number_low);
1251: END IF;
1252: IF var.p_receipt_number_high IS NOT NULL THEN
1253: dbms_sql.bind_variable(c, 'p_receipt_number_high', var.p_receipt_number_high);
1254: END IF;
1255:
1256: IF var.p_invoice_number_low IS NOT NULL THEN
1257: dbms_sql.bind_variable(c, 'p_invoice_number_low', var.p_invoice_number_low);

Line 1257: dbms_sql.bind_variable(c, 'p_invoice_number_low', var.p_invoice_number_low);

1253: dbms_sql.bind_variable(c, 'p_receipt_number_high', var.p_receipt_number_high);
1254: END IF;
1255:
1256: IF var.p_invoice_number_low IS NOT NULL THEN
1257: dbms_sql.bind_variable(c, 'p_invoice_number_low', var.p_invoice_number_low);
1258: END IF;
1259: IF var.p_invoice_number_high IS NOT NULL THEN
1260: dbms_sql.bind_variable(c, 'p_invoice_number_high', var.p_invoice_number_high);
1261: END IF;

Line 1260: dbms_sql.bind_variable(c, 'p_invoice_number_high', var.p_invoice_number_high);

1256: IF var.p_invoice_number_low IS NOT NULL THEN
1257: dbms_sql.bind_variable(c, 'p_invoice_number_low', var.p_invoice_number_low);
1258: END IF;
1259: IF var.p_invoice_number_high IS NOT NULL THEN
1260: dbms_sql.bind_variable(c, 'p_invoice_number_high', var.p_invoice_number_high);
1261: END IF;
1262:
1263: IF var.p_currency_code IS NOT NULL THEN
1264: dbms_sql.bind_variable(c, 'p_currency_code', var.p_currency_code);

Line 1264: dbms_sql.bind_variable(c, 'p_currency_code', var.p_currency_code);

1260: dbms_sql.bind_variable(c, 'p_invoice_number_high', var.p_invoice_number_high);
1261: END IF;
1262:
1263: IF var.p_currency_code IS NOT NULL THEN
1264: dbms_sql.bind_variable(c, 'p_currency_code', var.p_currency_code);
1265: END IF;
1266:
1267: IF var.p_bank_account_name IS NOT NULL THEN
1268: dbms_sql.bind_variable(c, 'p_bank_account_name', var.p_bank_account_name);

Line 1268: dbms_sql.bind_variable(c, 'p_bank_account_name', var.p_bank_account_name);

1264: dbms_sql.bind_variable(c, 'p_currency_code', var.p_currency_code);
1265: END IF;
1266:
1267: IF var.p_bank_account_name IS NOT NULL THEN
1268: dbms_sql.bind_variable(c, 'p_bank_account_name', var.p_bank_account_name);
1269: END IF;
1270:
1271: IF var.p_payment_method IS NOT NULL THEN
1272: dbms_sql.bind_variable(c, 'p_payment_method', var.p_payment_method);

Line 1272: dbms_sql.bind_variable(c, 'p_payment_method', var.p_payment_method);

1268: dbms_sql.bind_variable(c, 'p_bank_account_name', var.p_bank_account_name);
1269: END IF;
1270:
1271: IF var.p_payment_method IS NOT NULL THEN
1272: dbms_sql.bind_variable(c, 'p_payment_method', var.p_payment_method);
1273: END IF;
1274:
1275: IF var.p_confirmed_flag IS NOT NULL THEN
1276: dbms_sql.bind_variable(c, 'p_confirmed_flag', var.p_confirmed_flag);

Line 1276: dbms_sql.bind_variable(c, 'p_confirmed_flag', var.p_confirmed_flag);

1272: dbms_sql.bind_variable(c, 'p_payment_method', var.p_payment_method);
1273: END IF;
1274:
1275: IF var.p_confirmed_flag IS NOT NULL THEN
1276: dbms_sql.bind_variable(c, 'p_confirmed_flag', var.p_confirmed_flag);
1277: END IF;
1278:
1279: select MEANING into L_CASH from ar_lookups where lookup_type='PAYMENT_CATEGORY_TYPE' and lookup_code='CASH';
1280: select MEANING into L_MISC from ar_lookups where lookup_type='PAYMENT_CATEGORY_TYPE' and lookup_code='MISC';

Line 1296: dbms_sql.bind_variable(c, 'L_CASH' , L_CASH);

1292: select MEANING into L_CONFIRMED from ar_lookups where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='CONFIRMED';
1293: select MEANING into L_REMITTED from ar_lookups where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='REMITTED';
1294: select MEANING into L_REVERSED from ar_lookups where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='REVERSED';
1295:
1296: dbms_sql.bind_variable(c, 'L_CASH' , L_CASH);
1297: dbms_sql.bind_variable(c, 'L_MISC' , L_MISC);
1298: dbms_sql.bind_variable(c, 'L_APP' , var.l_app);
1299: dbms_sql.bind_variable(c, 'L_NSF' , var.l_nsf);
1300: dbms_sql.bind_variable(c, 'L_REV' , var.l_rev);

Line 1297: dbms_sql.bind_variable(c, 'L_MISC' , L_MISC);

1293: select MEANING into L_REMITTED from ar_lookups where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='REMITTED';
1294: select MEANING into L_REVERSED from ar_lookups where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='REVERSED';
1295:
1296: dbms_sql.bind_variable(c, 'L_CASH' , L_CASH);
1297: dbms_sql.bind_variable(c, 'L_MISC' , L_MISC);
1298: dbms_sql.bind_variable(c, 'L_APP' , var.l_app);
1299: dbms_sql.bind_variable(c, 'L_NSF' , var.l_nsf);
1300: dbms_sql.bind_variable(c, 'L_REV' , var.l_rev);
1301: dbms_sql.bind_variable(c, 'L_STOP' , var.l_stop);

Line 1298: dbms_sql.bind_variable(c, 'L_APP' , var.l_app);

1294: select MEANING into L_REVERSED from ar_lookups where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='REVERSED';
1295:
1296: dbms_sql.bind_variable(c, 'L_CASH' , L_CASH);
1297: dbms_sql.bind_variable(c, 'L_MISC' , L_MISC);
1298: dbms_sql.bind_variable(c, 'L_APP' , var.l_app);
1299: dbms_sql.bind_variable(c, 'L_NSF' , var.l_nsf);
1300: dbms_sql.bind_variable(c, 'L_REV' , var.l_rev);
1301: dbms_sql.bind_variable(c, 'L_STOP' , var.l_stop);
1302: dbms_sql.bind_variable(c, 'L_UNAPP' , var.l_unapp);

Line 1299: dbms_sql.bind_variable(c, 'L_NSF' , var.l_nsf);

1295:
1296: dbms_sql.bind_variable(c, 'L_CASH' , L_CASH);
1297: dbms_sql.bind_variable(c, 'L_MISC' , L_MISC);
1298: dbms_sql.bind_variable(c, 'L_APP' , var.l_app);
1299: dbms_sql.bind_variable(c, 'L_NSF' , var.l_nsf);
1300: dbms_sql.bind_variable(c, 'L_REV' , var.l_rev);
1301: dbms_sql.bind_variable(c, 'L_STOP' , var.l_stop);
1302: dbms_sql.bind_variable(c, 'L_UNAPP' , var.l_unapp);
1303: dbms_sql.bind_variable(c, 'L_UNID' , var.l_unid);

Line 1300: dbms_sql.bind_variable(c, 'L_REV' , var.l_rev);

1296: dbms_sql.bind_variable(c, 'L_CASH' , L_CASH);
1297: dbms_sql.bind_variable(c, 'L_MISC' , L_MISC);
1298: dbms_sql.bind_variable(c, 'L_APP' , var.l_app);
1299: dbms_sql.bind_variable(c, 'L_NSF' , var.l_nsf);
1300: dbms_sql.bind_variable(c, 'L_REV' , var.l_rev);
1301: dbms_sql.bind_variable(c, 'L_STOP' , var.l_stop);
1302: dbms_sql.bind_variable(c, 'L_UNAPP' , var.l_unapp);
1303: dbms_sql.bind_variable(c, 'L_UNID' , var.l_unid);
1304: dbms_sql.bind_variable(c, 'L_PAYMENT' , L_PAYMENT);

Line 1301: dbms_sql.bind_variable(c, 'L_STOP' , var.l_stop);

1297: dbms_sql.bind_variable(c, 'L_MISC' , L_MISC);
1298: dbms_sql.bind_variable(c, 'L_APP' , var.l_app);
1299: dbms_sql.bind_variable(c, 'L_NSF' , var.l_nsf);
1300: dbms_sql.bind_variable(c, 'L_REV' , var.l_rev);
1301: dbms_sql.bind_variable(c, 'L_STOP' , var.l_stop);
1302: dbms_sql.bind_variable(c, 'L_UNAPP' , var.l_unapp);
1303: dbms_sql.bind_variable(c, 'L_UNID' , var.l_unid);
1304: dbms_sql.bind_variable(c, 'L_PAYMENT' , L_PAYMENT);
1305: dbms_sql.bind_variable(c, 'L_RECEIPT' , L_RECEIPT);

Line 1302: dbms_sql.bind_variable(c, 'L_UNAPP' , var.l_unapp);

1298: dbms_sql.bind_variable(c, 'L_APP' , var.l_app);
1299: dbms_sql.bind_variable(c, 'L_NSF' , var.l_nsf);
1300: dbms_sql.bind_variable(c, 'L_REV' , var.l_rev);
1301: dbms_sql.bind_variable(c, 'L_STOP' , var.l_stop);
1302: dbms_sql.bind_variable(c, 'L_UNAPP' , var.l_unapp);
1303: dbms_sql.bind_variable(c, 'L_UNID' , var.l_unid);
1304: dbms_sql.bind_variable(c, 'L_PAYMENT' , L_PAYMENT);
1305: dbms_sql.bind_variable(c, 'L_RECEIPT' , L_RECEIPT);
1306: dbms_sql.bind_variable(c, 'L_REMITTANCE' , L_REMITTANCE);

Line 1303: dbms_sql.bind_variable(c, 'L_UNID' , var.l_unid);

1299: dbms_sql.bind_variable(c, 'L_NSF' , var.l_nsf);
1300: dbms_sql.bind_variable(c, 'L_REV' , var.l_rev);
1301: dbms_sql.bind_variable(c, 'L_STOP' , var.l_stop);
1302: dbms_sql.bind_variable(c, 'L_UNAPP' , var.l_unapp);
1303: dbms_sql.bind_variable(c, 'L_UNID' , var.l_unid);
1304: dbms_sql.bind_variable(c, 'L_PAYMENT' , L_PAYMENT);
1305: dbms_sql.bind_variable(c, 'L_RECEIPT' , L_RECEIPT);
1306: dbms_sql.bind_variable(c, 'L_REMITTANCE' , L_REMITTANCE);
1307: dbms_sql.bind_variable(c, 'L_APPROVED' , L_APPROVED);

Line 1304: dbms_sql.bind_variable(c, 'L_PAYMENT' , L_PAYMENT);

1300: dbms_sql.bind_variable(c, 'L_REV' , var.l_rev);
1301: dbms_sql.bind_variable(c, 'L_STOP' , var.l_stop);
1302: dbms_sql.bind_variable(c, 'L_UNAPP' , var.l_unapp);
1303: dbms_sql.bind_variable(c, 'L_UNID' , var.l_unid);
1304: dbms_sql.bind_variable(c, 'L_PAYMENT' , L_PAYMENT);
1305: dbms_sql.bind_variable(c, 'L_RECEIPT' , L_RECEIPT);
1306: dbms_sql.bind_variable(c, 'L_REMITTANCE' , L_REMITTANCE);
1307: dbms_sql.bind_variable(c, 'L_APPROVED' , L_APPROVED);
1308: dbms_sql.bind_variable(c, 'L_CLEARED' , L_CLEARED);

Line 1305: dbms_sql.bind_variable(c, 'L_RECEIPT' , L_RECEIPT);

1301: dbms_sql.bind_variable(c, 'L_STOP' , var.l_stop);
1302: dbms_sql.bind_variable(c, 'L_UNAPP' , var.l_unapp);
1303: dbms_sql.bind_variable(c, 'L_UNID' , var.l_unid);
1304: dbms_sql.bind_variable(c, 'L_PAYMENT' , L_PAYMENT);
1305: dbms_sql.bind_variable(c, 'L_RECEIPT' , L_RECEIPT);
1306: dbms_sql.bind_variable(c, 'L_REMITTANCE' , L_REMITTANCE);
1307: dbms_sql.bind_variable(c, 'L_APPROVED' , L_APPROVED);
1308: dbms_sql.bind_variable(c, 'L_CLEARED' , L_CLEARED);
1309: dbms_sql.bind_variable(c, 'L_CONFIRMED' , L_CONFIRMED);

Line 1306: dbms_sql.bind_variable(c, 'L_REMITTANCE' , L_REMITTANCE);

1302: dbms_sql.bind_variable(c, 'L_UNAPP' , var.l_unapp);
1303: dbms_sql.bind_variable(c, 'L_UNID' , var.l_unid);
1304: dbms_sql.bind_variable(c, 'L_PAYMENT' , L_PAYMENT);
1305: dbms_sql.bind_variable(c, 'L_RECEIPT' , L_RECEIPT);
1306: dbms_sql.bind_variable(c, 'L_REMITTANCE' , L_REMITTANCE);
1307: dbms_sql.bind_variable(c, 'L_APPROVED' , L_APPROVED);
1308: dbms_sql.bind_variable(c, 'L_CLEARED' , L_CLEARED);
1309: dbms_sql.bind_variable(c, 'L_CONFIRMED' , L_CONFIRMED);
1310: dbms_sql.bind_variable(c, 'L_REMITTED' , L_REMITTED);

Line 1307: dbms_sql.bind_variable(c, 'L_APPROVED' , L_APPROVED);

1303: dbms_sql.bind_variable(c, 'L_UNID' , var.l_unid);
1304: dbms_sql.bind_variable(c, 'L_PAYMENT' , L_PAYMENT);
1305: dbms_sql.bind_variable(c, 'L_RECEIPT' , L_RECEIPT);
1306: dbms_sql.bind_variable(c, 'L_REMITTANCE' , L_REMITTANCE);
1307: dbms_sql.bind_variable(c, 'L_APPROVED' , L_APPROVED);
1308: dbms_sql.bind_variable(c, 'L_CLEARED' , L_CLEARED);
1309: dbms_sql.bind_variable(c, 'L_CONFIRMED' , L_CONFIRMED);
1310: dbms_sql.bind_variable(c, 'L_REMITTED' , L_REMITTED);
1311: dbms_sql.bind_variable(c, 'L_REVERSED' , L_REVERSED);

Line 1308: dbms_sql.bind_variable(c, 'L_CLEARED' , L_CLEARED);

1304: dbms_sql.bind_variable(c, 'L_PAYMENT' , L_PAYMENT);
1305: dbms_sql.bind_variable(c, 'L_RECEIPT' , L_RECEIPT);
1306: dbms_sql.bind_variable(c, 'L_REMITTANCE' , L_REMITTANCE);
1307: dbms_sql.bind_variable(c, 'L_APPROVED' , L_APPROVED);
1308: dbms_sql.bind_variable(c, 'L_CLEARED' , L_CLEARED);
1309: dbms_sql.bind_variable(c, 'L_CONFIRMED' , L_CONFIRMED);
1310: dbms_sql.bind_variable(c, 'L_REMITTED' , L_REMITTED);
1311: dbms_sql.bind_variable(c, 'L_REVERSED' , L_REVERSED);
1312:

Line 1309: dbms_sql.bind_variable(c, 'L_CONFIRMED' , L_CONFIRMED);

1305: dbms_sql.bind_variable(c, 'L_RECEIPT' , L_RECEIPT);
1306: dbms_sql.bind_variable(c, 'L_REMITTANCE' , L_REMITTANCE);
1307: dbms_sql.bind_variable(c, 'L_APPROVED' , L_APPROVED);
1308: dbms_sql.bind_variable(c, 'L_CLEARED' , L_CLEARED);
1309: dbms_sql.bind_variable(c, 'L_CONFIRMED' , L_CONFIRMED);
1310: dbms_sql.bind_variable(c, 'L_REMITTED' , L_REMITTED);
1311: dbms_sql.bind_variable(c, 'L_REVERSED' , L_REVERSED);
1312:
1313: if var.calling_program = 'ACTUAL' then

Line 1310: dbms_sql.bind_variable(c, 'L_REMITTED' , L_REMITTED);

1306: dbms_sql.bind_variable(c, 'L_REMITTANCE' , L_REMITTANCE);
1307: dbms_sql.bind_variable(c, 'L_APPROVED' , L_APPROVED);
1308: dbms_sql.bind_variable(c, 'L_CLEARED' , L_CLEARED);
1309: dbms_sql.bind_variable(c, 'L_CONFIRMED' , L_CONFIRMED);
1310: dbms_sql.bind_variable(c, 'L_REMITTED' , L_REMITTED);
1311: dbms_sql.bind_variable(c, 'L_REVERSED' , L_REVERSED);
1312:
1313: if var.calling_program = 'ACTUAL' then
1314:

Line 1311: dbms_sql.bind_variable(c, 'L_REVERSED' , L_REVERSED);

1307: dbms_sql.bind_variable(c, 'L_APPROVED' , L_APPROVED);
1308: dbms_sql.bind_variable(c, 'L_CLEARED' , L_CLEARED);
1309: dbms_sql.bind_variable(c, 'L_CONFIRMED' , L_CONFIRMED);
1310: dbms_sql.bind_variable(c, 'L_REMITTED' , L_REMITTED);
1311: dbms_sql.bind_variable(c, 'L_REVERSED' , L_REVERSED);
1312:
1313: if var.calling_program = 'ACTUAL' then
1314:
1315: fa_rx_util_pkg.debug('Define additional BIND variables for Actual Receipts Register');

Line 1322: dbms_sql.bind_variable(c, 'L_ACCO' , L_ACCO);

1318: select MEANING into L_APPL from ar_lookups where lookup_type='PAYMENT_TYPE' and lookup_code='APP';
1319: select MEANING into L_UNAPPL from ar_lookups where lookup_type='PAYMENT_TYPE' and lookup_code='UNAPP';
1320: select MEANING into L_UNIDE from ar_lookups where lookup_type='PAYMENT_TYPE' and lookup_code='UNID';
1321:
1322: dbms_sql.bind_variable(c, 'L_ACCO' , L_ACCO);
1323: dbms_sql.bind_variable(c, 'L_APPL' , L_APPL);
1324: dbms_sql.bind_variable(c, 'L_UNAPPL' , L_UNAPPL);
1325: dbms_sql.bind_variable(c, 'L_UNIDE' , L_UNIDE);
1326: dbms_sql.bind_variable(c, 'l_trx_on_acc', l_acco);

Line 1323: dbms_sql.bind_variable(c, 'L_APPL' , L_APPL);

1319: select MEANING into L_UNAPPL from ar_lookups where lookup_type='PAYMENT_TYPE' and lookup_code='UNAPP';
1320: select MEANING into L_UNIDE from ar_lookups where lookup_type='PAYMENT_TYPE' and lookup_code='UNID';
1321:
1322: dbms_sql.bind_variable(c, 'L_ACCO' , L_ACCO);
1323: dbms_sql.bind_variable(c, 'L_APPL' , L_APPL);
1324: dbms_sql.bind_variable(c, 'L_UNAPPL' , L_UNAPPL);
1325: dbms_sql.bind_variable(c, 'L_UNIDE' , L_UNIDE);
1326: dbms_sql.bind_variable(c, 'l_trx_on_acc', l_acco);
1327:

Line 1324: dbms_sql.bind_variable(c, 'L_UNAPPL' , L_UNAPPL);

1320: select MEANING into L_UNIDE from ar_lookups where lookup_type='PAYMENT_TYPE' and lookup_code='UNID';
1321:
1322: dbms_sql.bind_variable(c, 'L_ACCO' , L_ACCO);
1323: dbms_sql.bind_variable(c, 'L_APPL' , L_APPL);
1324: dbms_sql.bind_variable(c, 'L_UNAPPL' , L_UNAPPL);
1325: dbms_sql.bind_variable(c, 'L_UNIDE' , L_UNIDE);
1326: dbms_sql.bind_variable(c, 'l_trx_on_acc', l_acco);
1327:
1328: elsif var.calling_program = 'APPLIED' then

Line 1325: dbms_sql.bind_variable(c, 'L_UNIDE' , L_UNIDE);

1321:
1322: dbms_sql.bind_variable(c, 'L_ACCO' , L_ACCO);
1323: dbms_sql.bind_variable(c, 'L_APPL' , L_APPL);
1324: dbms_sql.bind_variable(c, 'L_UNAPPL' , L_UNAPPL);
1325: dbms_sql.bind_variable(c, 'L_UNIDE' , L_UNIDE);
1326: dbms_sql.bind_variable(c, 'l_trx_on_acc', l_acco);
1327:
1328: elsif var.calling_program = 'APPLIED' then
1329:

Line 1326: dbms_sql.bind_variable(c, 'l_trx_on_acc', l_acco);

1322: dbms_sql.bind_variable(c, 'L_ACCO' , L_ACCO);
1323: dbms_sql.bind_variable(c, 'L_APPL' , L_APPL);
1324: dbms_sql.bind_variable(c, 'L_UNAPPL' , L_UNAPPL);
1325: dbms_sql.bind_variable(c, 'L_UNIDE' , L_UNIDE);
1326: dbms_sql.bind_variable(c, 'l_trx_on_acc', l_acco);
1327:
1328: elsif var.calling_program = 'APPLIED' then
1329:
1330: fa_rx_util_pkg.debug('Define additional BIND variables for Applied Receipts Register');

Line 1334: dbms_sql.bind_variable(c, 'L_ONACCOUNT' , L_ONACCOUNT);

1330: fa_rx_util_pkg.debug('Define additional BIND variables for Applied Receipts Register');
1331:
1332: SELECT substrb(meaning,1,20) INTO L_ONACCOUNT FROM ar_lookups WHERE lookup_type='PAYMENT_TYPE' AND lookup_code='ACC';
1333:
1334: dbms_sql.bind_variable(c, 'L_ONACCOUNT' , L_ONACCOUNT);
1335:
1336: IF var.p_apply_date_low IS NOT NULL THEN
1337: dbms_sql.bind_variable(c, 'p_apply_date_low', var.p_apply_date_low);
1338: END IF;

Line 1337: dbms_sql.bind_variable(c, 'p_apply_date_low', var.p_apply_date_low);

1333:
1334: dbms_sql.bind_variable(c, 'L_ONACCOUNT' , L_ONACCOUNT);
1335:
1336: IF var.p_apply_date_low IS NOT NULL THEN
1337: dbms_sql.bind_variable(c, 'p_apply_date_low', var.p_apply_date_low);
1338: END IF;
1339: IF var.p_apply_date_high IS NOT NULL THEN
1340: dbms_sql.bind_variable(c, 'p_apply_date_high', var.p_apply_date_high);
1341: END IF;

Line 1340: dbms_sql.bind_variable(c, 'p_apply_date_high', var.p_apply_date_high);

1336: IF var.p_apply_date_low IS NOT NULL THEN
1337: dbms_sql.bind_variable(c, 'p_apply_date_low', var.p_apply_date_low);
1338: END IF;
1339: IF var.p_apply_date_high IS NOT NULL THEN
1340: dbms_sql.bind_variable(c, 'p_apply_date_high', var.p_apply_date_high);
1341: END IF;
1342:
1343: IF var.p_customer_number_low IS NOT NULL THEN
1344: dbms_sql.bind_variable(c, 'p_customer_number_low', var.p_customer_number_low);

Line 1344: dbms_sql.bind_variable(c, 'p_customer_number_low', var.p_customer_number_low);

1340: dbms_sql.bind_variable(c, 'p_apply_date_high', var.p_apply_date_high);
1341: END IF;
1342:
1343: IF var.p_customer_number_low IS NOT NULL THEN
1344: dbms_sql.bind_variable(c, 'p_customer_number_low', var.p_customer_number_low);
1345: END IF;
1346: IF var.p_customer_number_high IS NOT NULL THEN
1347: dbms_sql.bind_variable(c, 'p_customer_number_high', var.p_customer_number_high);
1348: END IF;

Line 1347: dbms_sql.bind_variable(c, 'p_customer_number_high', var.p_customer_number_high);

1343: IF var.p_customer_number_low IS NOT NULL THEN
1344: dbms_sql.bind_variable(c, 'p_customer_number_low', var.p_customer_number_low);
1345: END IF;
1346: IF var.p_customer_number_high IS NOT NULL THEN
1347: dbms_sql.bind_variable(c, 'p_customer_number_high', var.p_customer_number_high);
1348: END IF;
1349:
1350: IF var.p_invoice_type_low IS NOT NULL THEN
1351: dbms_sql.bind_variable(c,'p_invoice_type_low', var.p_invoice_type_low);

Line 1351: dbms_sql.bind_variable(c,'p_invoice_type_low', var.p_invoice_type_low);

1347: dbms_sql.bind_variable(c, 'p_customer_number_high', var.p_customer_number_high);
1348: END IF;
1349:
1350: IF var.p_invoice_type_low IS NOT NULL THEN
1351: dbms_sql.bind_variable(c,'p_invoice_type_low', var.p_invoice_type_low);
1352: END IF;
1353: IF var.p_invoice_type_high IS NOT NULL THEN
1354: dbms_sql.bind_variable(c, 'p_invoice_type_high',var.p_invoice_type_high);
1355: END IF;

Line 1354: dbms_sql.bind_variable(c, 'p_invoice_type_high',var.p_invoice_type_high);

1350: IF var.p_invoice_type_low IS NOT NULL THEN
1351: dbms_sql.bind_variable(c,'p_invoice_type_low', var.p_invoice_type_low);
1352: END IF;
1353: IF var.p_invoice_type_high IS NOT NULL THEN
1354: dbms_sql.bind_variable(c, 'p_invoice_type_high',var.p_invoice_type_high);
1355: END IF;
1356:
1357: end if;
1358: