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 1128: dbms_sql.bind_variable(c, 'p_reporting_entity_id', var.p_reporting_entity_id);

1124:
1125: -- Bug 4219081
1126: IF var.p_reporting_level = 3000 then
1127: IF var.p_reporting_entity_id IS NOT NULL THEN
1128: dbms_sql.bind_variable(c, 'p_reporting_entity_id', var.p_reporting_entity_id);
1129: END IF;
1130: END IF;
1131:
1132: IF var.p_deposit_date_low IS NOT NULL THEN

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

1129: END IF;
1130: END IF;
1131:
1132: IF var.p_deposit_date_low IS NOT NULL THEN
1133: dbms_sql.bind_variable(c, 'p_deposit_date_low', var.p_deposit_date_low);
1134: END IF;
1135: IF var.p_deposit_date_high IS NOT NULL THEN
1136: dbms_sql.bind_variable(c, 'p_deposit_date_high', var.p_deposit_date_high);
1137: END IF;

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

1132: IF var.p_deposit_date_low IS NOT NULL THEN
1133: dbms_sql.bind_variable(c, 'p_deposit_date_low', var.p_deposit_date_low);
1134: END IF;
1135: IF var.p_deposit_date_high IS NOT NULL THEN
1136: dbms_sql.bind_variable(c, 'p_deposit_date_high', var.p_deposit_date_high);
1137: END IF;
1138:
1139: IF var.p_receipt_date_low IS NOT NULL THEN
1140: dbms_sql.bind_variable(c, 'p_receipt_date_low', var.p_receipt_date_low);

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

1136: dbms_sql.bind_variable(c, 'p_deposit_date_high', var.p_deposit_date_high);
1137: END IF;
1138:
1139: IF var.p_receipt_date_low IS NOT NULL THEN
1140: dbms_sql.bind_variable(c, 'p_receipt_date_low', var.p_receipt_date_low);
1141: END IF;
1142: IF var.p_receipt_date_high IS NOT NULL THEN
1143: dbms_sql.bind_variable(c, 'p_receipt_date_high', var.p_receipt_date_high);
1144: END IF;

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

1139: IF var.p_receipt_date_low IS NOT NULL THEN
1140: dbms_sql.bind_variable(c, 'p_receipt_date_low', var.p_receipt_date_low);
1141: END IF;
1142: IF var.p_receipt_date_high IS NOT NULL THEN
1143: dbms_sql.bind_variable(c, 'p_receipt_date_high', var.p_receipt_date_high);
1144: END IF;
1145:
1146: IF var.p_gl_date_low IS NOT NULL THEN
1147: dbms_sql.bind_variable(c, 'p_gl_date_low', var.p_gl_date_low);

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

1143: dbms_sql.bind_variable(c, 'p_receipt_date_high', var.p_receipt_date_high);
1144: END IF;
1145:
1146: IF var.p_gl_date_low IS NOT NULL THEN
1147: dbms_sql.bind_variable(c, 'p_gl_date_low', var.p_gl_date_low);
1148: END IF;
1149: IF var.p_gl_date_high IS NOT NULL THEN
1150: dbms_sql.bind_variable(c, 'p_gl_date_high', var.p_gl_date_high);
1151: END IF;

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

1146: IF var.p_gl_date_low IS NOT NULL THEN
1147: dbms_sql.bind_variable(c, 'p_gl_date_low', var.p_gl_date_low);
1148: END IF;
1149: IF var.p_gl_date_high IS NOT NULL THEN
1150: dbms_sql.bind_variable(c, 'p_gl_date_high', var.p_gl_date_high);
1151: END IF;
1152:
1153: IF var.p_batch_name_low IS NOT NULL THEN
1154: dbms_sql.bind_variable(c, 'p_batch_name_low', var.p_batch_name_low);

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

1150: dbms_sql.bind_variable(c, 'p_gl_date_high', var.p_gl_date_high);
1151: END IF;
1152:
1153: IF var.p_batch_name_low IS NOT NULL THEN
1154: dbms_sql.bind_variable(c, 'p_batch_name_low', var.p_batch_name_low);
1155: END IF;
1156: IF var.p_batch_name_high IS NOT NULL THEN
1157: dbms_sql.bind_variable(c, 'p_batch_name_high', var.p_batch_name_high);
1158: END IF;

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

1153: IF var.p_batch_name_low IS NOT NULL THEN
1154: dbms_sql.bind_variable(c, 'p_batch_name_low', var.p_batch_name_low);
1155: END IF;
1156: IF var.p_batch_name_high IS NOT NULL THEN
1157: dbms_sql.bind_variable(c, 'p_batch_name_high', var.p_batch_name_high);
1158: END IF;
1159: /* bug 5724171*/
1160: IF var.p_customer_name_low IS NOT NULL THEN
1161: dbms_sql.bind_variable(c, 'p_customer_name_low', var.p_customer_name_low);

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

1157: dbms_sql.bind_variable(c, 'p_batch_name_high', var.p_batch_name_high);
1158: END IF;
1159: /* bug 5724171*/
1160: IF var.p_customer_name_low IS NOT NULL THEN
1161: dbms_sql.bind_variable(c, 'p_customer_name_low', var.p_customer_name_low);
1162: dbms_sql.bind_variable(c, 'len1',var.len1);
1163: END IF;
1164: IF var.p_customer_name_high IS NOT NULL THEN
1165: dbms_sql.bind_variable(c, 'p_customer_name_high', var.p_customer_name_high);

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

1158: END IF;
1159: /* bug 5724171*/
1160: IF var.p_customer_name_low IS NOT NULL THEN
1161: dbms_sql.bind_variable(c, 'p_customer_name_low', var.p_customer_name_low);
1162: dbms_sql.bind_variable(c, 'len1',var.len1);
1163: END IF;
1164: IF var.p_customer_name_high IS NOT NULL THEN
1165: dbms_sql.bind_variable(c, 'p_customer_name_high', var.p_customer_name_high);
1166: dbms_sql.bind_variable(c, 'len2',var.len2);

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

1161: dbms_sql.bind_variable(c, 'p_customer_name_low', var.p_customer_name_low);
1162: dbms_sql.bind_variable(c, 'len1',var.len1);
1163: END IF;
1164: IF var.p_customer_name_high IS NOT NULL THEN
1165: dbms_sql.bind_variable(c, 'p_customer_name_high', var.p_customer_name_high);
1166: dbms_sql.bind_variable(c, 'len2',var.len2);
1167: END IF;
1168:
1169: IF var.p_receipt_status_low IS NOT NULL THEN

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

1162: dbms_sql.bind_variable(c, 'len1',var.len1);
1163: END IF;
1164: IF var.p_customer_name_high IS NOT NULL THEN
1165: dbms_sql.bind_variable(c, 'p_customer_name_high', var.p_customer_name_high);
1166: dbms_sql.bind_variable(c, 'len2',var.len2);
1167: END IF;
1168:
1169: IF var.p_receipt_status_low IS NOT NULL THEN
1170: dbms_sql.bind_variable(c, 'p_receipt_status_low', var.p_receipt_status_low);

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

1166: dbms_sql.bind_variable(c, 'len2',var.len2);
1167: END IF;
1168:
1169: IF var.p_receipt_status_low IS NOT NULL THEN
1170: dbms_sql.bind_variable(c, 'p_receipt_status_low', var.p_receipt_status_low);
1171: END IF;
1172: IF var.p_receipt_status_high IS NOT NULL THEN
1173: dbms_sql.bind_variable(c, 'p_receipt_status_high', var.p_receipt_status_high);
1174: END IF;

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

1169: IF var.p_receipt_status_low IS NOT NULL THEN
1170: dbms_sql.bind_variable(c, 'p_receipt_status_low', var.p_receipt_status_low);
1171: END IF;
1172: IF var.p_receipt_status_high IS NOT NULL THEN
1173: dbms_sql.bind_variable(c, 'p_receipt_status_high', var.p_receipt_status_high);
1174: END IF;
1175:
1176: IF var.p_receipt_number_low IS NOT NULL THEN
1177: dbms_sql.bind_variable(c, 'p_receipt_number_low', var.p_receipt_number_low);

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

1173: dbms_sql.bind_variable(c, 'p_receipt_status_high', var.p_receipt_status_high);
1174: END IF;
1175:
1176: IF var.p_receipt_number_low IS NOT NULL THEN
1177: dbms_sql.bind_variable(c, 'p_receipt_number_low', var.p_receipt_number_low);
1178: END IF;
1179: IF var.p_receipt_number_high IS NOT NULL THEN
1180: dbms_sql.bind_variable(c, 'p_receipt_number_high', var.p_receipt_number_high);
1181: END IF;

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

1176: IF var.p_receipt_number_low IS NOT NULL THEN
1177: dbms_sql.bind_variable(c, 'p_receipt_number_low', var.p_receipt_number_low);
1178: END IF;
1179: IF var.p_receipt_number_high IS NOT NULL THEN
1180: dbms_sql.bind_variable(c, 'p_receipt_number_high', var.p_receipt_number_high);
1181: END IF;
1182:
1183: IF var.p_invoice_number_low IS NOT NULL THEN
1184: dbms_sql.bind_variable(c, 'p_invoice_number_low', var.p_invoice_number_low);

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

1180: dbms_sql.bind_variable(c, 'p_receipt_number_high', var.p_receipt_number_high);
1181: END IF;
1182:
1183: IF var.p_invoice_number_low IS NOT NULL THEN
1184: dbms_sql.bind_variable(c, 'p_invoice_number_low', var.p_invoice_number_low);
1185: END IF;
1186: IF var.p_invoice_number_high IS NOT NULL THEN
1187: dbms_sql.bind_variable(c, 'p_invoice_number_high', var.p_invoice_number_high);
1188: END IF;

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

1183: IF var.p_invoice_number_low IS NOT NULL THEN
1184: dbms_sql.bind_variable(c, 'p_invoice_number_low', var.p_invoice_number_low);
1185: END IF;
1186: IF var.p_invoice_number_high IS NOT NULL THEN
1187: dbms_sql.bind_variable(c, 'p_invoice_number_high', var.p_invoice_number_high);
1188: END IF;
1189:
1190: IF var.p_currency_code IS NOT NULL THEN
1191: dbms_sql.bind_variable(c, 'p_currency_code', var.p_currency_code);

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

1187: dbms_sql.bind_variable(c, 'p_invoice_number_high', var.p_invoice_number_high);
1188: END IF;
1189:
1190: IF var.p_currency_code IS NOT NULL THEN
1191: dbms_sql.bind_variable(c, 'p_currency_code', var.p_currency_code);
1192: END IF;
1193:
1194: IF var.p_bank_account_name IS NOT NULL THEN
1195: dbms_sql.bind_variable(c, 'p_bank_account_name', var.p_bank_account_name);

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

1191: dbms_sql.bind_variable(c, 'p_currency_code', var.p_currency_code);
1192: END IF;
1193:
1194: IF var.p_bank_account_name IS NOT NULL THEN
1195: dbms_sql.bind_variable(c, 'p_bank_account_name', var.p_bank_account_name);
1196: END IF;
1197:
1198: IF var.p_payment_method IS NOT NULL THEN
1199: dbms_sql.bind_variable(c, 'p_payment_method', var.p_payment_method);

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

1195: dbms_sql.bind_variable(c, 'p_bank_account_name', var.p_bank_account_name);
1196: END IF;
1197:
1198: IF var.p_payment_method IS NOT NULL THEN
1199: dbms_sql.bind_variable(c, 'p_payment_method', var.p_payment_method);
1200: END IF;
1201:
1202: IF var.p_confirmed_flag IS NOT NULL THEN
1203: dbms_sql.bind_variable(c, 'p_confirmed_flag', var.p_confirmed_flag);

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

1199: dbms_sql.bind_variable(c, 'p_payment_method', var.p_payment_method);
1200: END IF;
1201:
1202: IF var.p_confirmed_flag IS NOT NULL THEN
1203: dbms_sql.bind_variable(c, 'p_confirmed_flag', var.p_confirmed_flag);
1204: END IF;
1205:
1206: select MEANING into L_CASH from ar_lookups where lookup_type='PAYMENT_CATEGORY_TYPE' and lookup_code='CASH';
1207: select MEANING into L_MISC from ar_lookups where lookup_type='PAYMENT_CATEGORY_TYPE' and lookup_code='MISC';

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

1219: select MEANING into L_CONFIRMED from ar_lookups where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='CONFIRMED';
1220: select MEANING into L_REMITTED from ar_lookups where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='REMITTED';
1221: select MEANING into L_REVERSED from ar_lookups where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='REVERSED';
1222:
1223: dbms_sql.bind_variable(c, 'L_CASH' , L_CASH);
1224: dbms_sql.bind_variable(c, 'L_MISC' , L_MISC);
1225: dbms_sql.bind_variable(c, 'L_APP' , var.l_app);
1226: dbms_sql.bind_variable(c, 'L_NSF' , var.l_nsf);
1227: dbms_sql.bind_variable(c, 'L_REV' , var.l_rev);

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

1220: select MEANING into L_REMITTED from ar_lookups where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='REMITTED';
1221: select MEANING into L_REVERSED from ar_lookups where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='REVERSED';
1222:
1223: dbms_sql.bind_variable(c, 'L_CASH' , L_CASH);
1224: dbms_sql.bind_variable(c, 'L_MISC' , L_MISC);
1225: dbms_sql.bind_variable(c, 'L_APP' , var.l_app);
1226: dbms_sql.bind_variable(c, 'L_NSF' , var.l_nsf);
1227: dbms_sql.bind_variable(c, 'L_REV' , var.l_rev);
1228: dbms_sql.bind_variable(c, 'L_STOP' , var.l_stop);

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

1221: select MEANING into L_REVERSED from ar_lookups where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='REVERSED';
1222:
1223: dbms_sql.bind_variable(c, 'L_CASH' , L_CASH);
1224: dbms_sql.bind_variable(c, 'L_MISC' , L_MISC);
1225: dbms_sql.bind_variable(c, 'L_APP' , var.l_app);
1226: dbms_sql.bind_variable(c, 'L_NSF' , var.l_nsf);
1227: dbms_sql.bind_variable(c, 'L_REV' , var.l_rev);
1228: dbms_sql.bind_variable(c, 'L_STOP' , var.l_stop);
1229: dbms_sql.bind_variable(c, 'L_UNAPP' , var.l_unapp);

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

1222:
1223: dbms_sql.bind_variable(c, 'L_CASH' , L_CASH);
1224: dbms_sql.bind_variable(c, 'L_MISC' , L_MISC);
1225: dbms_sql.bind_variable(c, 'L_APP' , var.l_app);
1226: dbms_sql.bind_variable(c, 'L_NSF' , var.l_nsf);
1227: dbms_sql.bind_variable(c, 'L_REV' , var.l_rev);
1228: dbms_sql.bind_variable(c, 'L_STOP' , var.l_stop);
1229: dbms_sql.bind_variable(c, 'L_UNAPP' , var.l_unapp);
1230: dbms_sql.bind_variable(c, 'L_UNID' , var.l_unid);

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

1223: dbms_sql.bind_variable(c, 'L_CASH' , L_CASH);
1224: dbms_sql.bind_variable(c, 'L_MISC' , L_MISC);
1225: dbms_sql.bind_variable(c, 'L_APP' , var.l_app);
1226: dbms_sql.bind_variable(c, 'L_NSF' , var.l_nsf);
1227: dbms_sql.bind_variable(c, 'L_REV' , var.l_rev);
1228: dbms_sql.bind_variable(c, 'L_STOP' , var.l_stop);
1229: dbms_sql.bind_variable(c, 'L_UNAPP' , var.l_unapp);
1230: dbms_sql.bind_variable(c, 'L_UNID' , var.l_unid);
1231: dbms_sql.bind_variable(c, 'L_PAYMENT' , L_PAYMENT);

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

1224: dbms_sql.bind_variable(c, 'L_MISC' , L_MISC);
1225: dbms_sql.bind_variable(c, 'L_APP' , var.l_app);
1226: dbms_sql.bind_variable(c, 'L_NSF' , var.l_nsf);
1227: dbms_sql.bind_variable(c, 'L_REV' , var.l_rev);
1228: dbms_sql.bind_variable(c, 'L_STOP' , var.l_stop);
1229: dbms_sql.bind_variable(c, 'L_UNAPP' , var.l_unapp);
1230: dbms_sql.bind_variable(c, 'L_UNID' , var.l_unid);
1231: dbms_sql.bind_variable(c, 'L_PAYMENT' , L_PAYMENT);
1232: dbms_sql.bind_variable(c, 'L_RECEIPT' , L_RECEIPT);

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

1225: dbms_sql.bind_variable(c, 'L_APP' , var.l_app);
1226: dbms_sql.bind_variable(c, 'L_NSF' , var.l_nsf);
1227: dbms_sql.bind_variable(c, 'L_REV' , var.l_rev);
1228: dbms_sql.bind_variable(c, 'L_STOP' , var.l_stop);
1229: dbms_sql.bind_variable(c, 'L_UNAPP' , var.l_unapp);
1230: dbms_sql.bind_variable(c, 'L_UNID' , var.l_unid);
1231: dbms_sql.bind_variable(c, 'L_PAYMENT' , L_PAYMENT);
1232: dbms_sql.bind_variable(c, 'L_RECEIPT' , L_RECEIPT);
1233: dbms_sql.bind_variable(c, 'L_REMITTANCE' , L_REMITTANCE);

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

1226: dbms_sql.bind_variable(c, 'L_NSF' , var.l_nsf);
1227: dbms_sql.bind_variable(c, 'L_REV' , var.l_rev);
1228: dbms_sql.bind_variable(c, 'L_STOP' , var.l_stop);
1229: dbms_sql.bind_variable(c, 'L_UNAPP' , var.l_unapp);
1230: dbms_sql.bind_variable(c, 'L_UNID' , var.l_unid);
1231: dbms_sql.bind_variable(c, 'L_PAYMENT' , L_PAYMENT);
1232: dbms_sql.bind_variable(c, 'L_RECEIPT' , L_RECEIPT);
1233: dbms_sql.bind_variable(c, 'L_REMITTANCE' , L_REMITTANCE);
1234: dbms_sql.bind_variable(c, 'L_APPROVED' , L_APPROVED);

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

1227: dbms_sql.bind_variable(c, 'L_REV' , var.l_rev);
1228: dbms_sql.bind_variable(c, 'L_STOP' , var.l_stop);
1229: dbms_sql.bind_variable(c, 'L_UNAPP' , var.l_unapp);
1230: dbms_sql.bind_variable(c, 'L_UNID' , var.l_unid);
1231: dbms_sql.bind_variable(c, 'L_PAYMENT' , L_PAYMENT);
1232: dbms_sql.bind_variable(c, 'L_RECEIPT' , L_RECEIPT);
1233: dbms_sql.bind_variable(c, 'L_REMITTANCE' , L_REMITTANCE);
1234: dbms_sql.bind_variable(c, 'L_APPROVED' , L_APPROVED);
1235: dbms_sql.bind_variable(c, 'L_CLEARED' , L_CLEARED);

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

1228: dbms_sql.bind_variable(c, 'L_STOP' , var.l_stop);
1229: dbms_sql.bind_variable(c, 'L_UNAPP' , var.l_unapp);
1230: dbms_sql.bind_variable(c, 'L_UNID' , var.l_unid);
1231: dbms_sql.bind_variable(c, 'L_PAYMENT' , L_PAYMENT);
1232: dbms_sql.bind_variable(c, 'L_RECEIPT' , L_RECEIPT);
1233: dbms_sql.bind_variable(c, 'L_REMITTANCE' , L_REMITTANCE);
1234: dbms_sql.bind_variable(c, 'L_APPROVED' , L_APPROVED);
1235: dbms_sql.bind_variable(c, 'L_CLEARED' , L_CLEARED);
1236: dbms_sql.bind_variable(c, 'L_CONFIRMED' , L_CONFIRMED);

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

1229: dbms_sql.bind_variable(c, 'L_UNAPP' , var.l_unapp);
1230: dbms_sql.bind_variable(c, 'L_UNID' , var.l_unid);
1231: dbms_sql.bind_variable(c, 'L_PAYMENT' , L_PAYMENT);
1232: dbms_sql.bind_variable(c, 'L_RECEIPT' , L_RECEIPT);
1233: dbms_sql.bind_variable(c, 'L_REMITTANCE' , L_REMITTANCE);
1234: dbms_sql.bind_variable(c, 'L_APPROVED' , L_APPROVED);
1235: dbms_sql.bind_variable(c, 'L_CLEARED' , L_CLEARED);
1236: dbms_sql.bind_variable(c, 'L_CONFIRMED' , L_CONFIRMED);
1237: dbms_sql.bind_variable(c, 'L_REMITTED' , L_REMITTED);

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

1230: dbms_sql.bind_variable(c, 'L_UNID' , var.l_unid);
1231: dbms_sql.bind_variable(c, 'L_PAYMENT' , L_PAYMENT);
1232: dbms_sql.bind_variable(c, 'L_RECEIPT' , L_RECEIPT);
1233: dbms_sql.bind_variable(c, 'L_REMITTANCE' , L_REMITTANCE);
1234: dbms_sql.bind_variable(c, 'L_APPROVED' , L_APPROVED);
1235: dbms_sql.bind_variable(c, 'L_CLEARED' , L_CLEARED);
1236: dbms_sql.bind_variable(c, 'L_CONFIRMED' , L_CONFIRMED);
1237: dbms_sql.bind_variable(c, 'L_REMITTED' , L_REMITTED);
1238: dbms_sql.bind_variable(c, 'L_REVERSED' , L_REVERSED);

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

1231: dbms_sql.bind_variable(c, 'L_PAYMENT' , L_PAYMENT);
1232: dbms_sql.bind_variable(c, 'L_RECEIPT' , L_RECEIPT);
1233: dbms_sql.bind_variable(c, 'L_REMITTANCE' , L_REMITTANCE);
1234: dbms_sql.bind_variable(c, 'L_APPROVED' , L_APPROVED);
1235: dbms_sql.bind_variable(c, 'L_CLEARED' , L_CLEARED);
1236: dbms_sql.bind_variable(c, 'L_CONFIRMED' , L_CONFIRMED);
1237: dbms_sql.bind_variable(c, 'L_REMITTED' , L_REMITTED);
1238: dbms_sql.bind_variable(c, 'L_REVERSED' , L_REVERSED);
1239:

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

1232: dbms_sql.bind_variable(c, 'L_RECEIPT' , L_RECEIPT);
1233: dbms_sql.bind_variable(c, 'L_REMITTANCE' , L_REMITTANCE);
1234: dbms_sql.bind_variable(c, 'L_APPROVED' , L_APPROVED);
1235: dbms_sql.bind_variable(c, 'L_CLEARED' , L_CLEARED);
1236: dbms_sql.bind_variable(c, 'L_CONFIRMED' , L_CONFIRMED);
1237: dbms_sql.bind_variable(c, 'L_REMITTED' , L_REMITTED);
1238: dbms_sql.bind_variable(c, 'L_REVERSED' , L_REVERSED);
1239:
1240: if var.calling_program = 'ACTUAL' then

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

1233: dbms_sql.bind_variable(c, 'L_REMITTANCE' , L_REMITTANCE);
1234: dbms_sql.bind_variable(c, 'L_APPROVED' , L_APPROVED);
1235: dbms_sql.bind_variable(c, 'L_CLEARED' , L_CLEARED);
1236: dbms_sql.bind_variable(c, 'L_CONFIRMED' , L_CONFIRMED);
1237: dbms_sql.bind_variable(c, 'L_REMITTED' , L_REMITTED);
1238: dbms_sql.bind_variable(c, 'L_REVERSED' , L_REVERSED);
1239:
1240: if var.calling_program = 'ACTUAL' then
1241:

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

1234: dbms_sql.bind_variable(c, 'L_APPROVED' , L_APPROVED);
1235: dbms_sql.bind_variable(c, 'L_CLEARED' , L_CLEARED);
1236: dbms_sql.bind_variable(c, 'L_CONFIRMED' , L_CONFIRMED);
1237: dbms_sql.bind_variable(c, 'L_REMITTED' , L_REMITTED);
1238: dbms_sql.bind_variable(c, 'L_REVERSED' , L_REVERSED);
1239:
1240: if var.calling_program = 'ACTUAL' then
1241:
1242: fa_rx_util_pkg.debug('Define additional BIND variables for Actual Receipts Register');

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

1245: select MEANING into L_APPL from ar_lookups where lookup_type='PAYMENT_TYPE' and lookup_code='APP';
1246: select MEANING into L_UNAPPL from ar_lookups where lookup_type='PAYMENT_TYPE' and lookup_code='UNAPP';
1247: select MEANING into L_UNIDE from ar_lookups where lookup_type='PAYMENT_TYPE' and lookup_code='UNID';
1248:
1249: dbms_sql.bind_variable(c, 'L_ACCO' , L_ACCO);
1250: dbms_sql.bind_variable(c, 'L_APPL' , L_APPL);
1251: dbms_sql.bind_variable(c, 'L_UNAPPL' , L_UNAPPL);
1252: dbms_sql.bind_variable(c, 'L_UNIDE' , L_UNIDE);
1253: dbms_sql.bind_variable(c, 'l_trx_on_acc', l_acco);

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

1246: select MEANING into L_UNAPPL from ar_lookups where lookup_type='PAYMENT_TYPE' and lookup_code='UNAPP';
1247: select MEANING into L_UNIDE from ar_lookups where lookup_type='PAYMENT_TYPE' and lookup_code='UNID';
1248:
1249: dbms_sql.bind_variable(c, 'L_ACCO' , L_ACCO);
1250: dbms_sql.bind_variable(c, 'L_APPL' , L_APPL);
1251: dbms_sql.bind_variable(c, 'L_UNAPPL' , L_UNAPPL);
1252: dbms_sql.bind_variable(c, 'L_UNIDE' , L_UNIDE);
1253: dbms_sql.bind_variable(c, 'l_trx_on_acc', l_acco);
1254:

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

1247: select MEANING into L_UNIDE from ar_lookups where lookup_type='PAYMENT_TYPE' and lookup_code='UNID';
1248:
1249: dbms_sql.bind_variable(c, 'L_ACCO' , L_ACCO);
1250: dbms_sql.bind_variable(c, 'L_APPL' , L_APPL);
1251: dbms_sql.bind_variable(c, 'L_UNAPPL' , L_UNAPPL);
1252: dbms_sql.bind_variable(c, 'L_UNIDE' , L_UNIDE);
1253: dbms_sql.bind_variable(c, 'l_trx_on_acc', l_acco);
1254:
1255: elsif var.calling_program = 'APPLIED' then

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

1248:
1249: dbms_sql.bind_variable(c, 'L_ACCO' , L_ACCO);
1250: dbms_sql.bind_variable(c, 'L_APPL' , L_APPL);
1251: dbms_sql.bind_variable(c, 'L_UNAPPL' , L_UNAPPL);
1252: dbms_sql.bind_variable(c, 'L_UNIDE' , L_UNIDE);
1253: dbms_sql.bind_variable(c, 'l_trx_on_acc', l_acco);
1254:
1255: elsif var.calling_program = 'APPLIED' then
1256:

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

1249: dbms_sql.bind_variable(c, 'L_ACCO' , L_ACCO);
1250: dbms_sql.bind_variable(c, 'L_APPL' , L_APPL);
1251: dbms_sql.bind_variable(c, 'L_UNAPPL' , L_UNAPPL);
1252: dbms_sql.bind_variable(c, 'L_UNIDE' , L_UNIDE);
1253: dbms_sql.bind_variable(c, 'l_trx_on_acc', l_acco);
1254:
1255: elsif var.calling_program = 'APPLIED' then
1256:
1257: fa_rx_util_pkg.debug('Define additional BIND variables for Applied Receipts Register');

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

1257: fa_rx_util_pkg.debug('Define additional BIND variables for Applied Receipts Register');
1258:
1259: SELECT substrb(meaning,1,20) INTO L_ONACCOUNT FROM ar_lookups WHERE lookup_type='PAYMENT_TYPE' AND lookup_code='ACC';
1260:
1261: dbms_sql.bind_variable(c, 'L_ONACCOUNT' , L_ONACCOUNT);
1262:
1263: IF var.p_apply_date_low IS NOT NULL THEN
1264: dbms_sql.bind_variable(c, 'p_apply_date_low', var.p_apply_date_low);
1265: END IF;

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

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

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

1263: IF var.p_apply_date_low IS NOT NULL THEN
1264: dbms_sql.bind_variable(c, 'p_apply_date_low', var.p_apply_date_low);
1265: END IF;
1266: IF var.p_apply_date_high IS NOT NULL THEN
1267: dbms_sql.bind_variable(c, 'p_apply_date_high', var.p_apply_date_high);
1268: END IF;
1269:
1270: IF var.p_customer_number_low IS NOT NULL THEN
1271: dbms_sql.bind_variable(c, 'p_customer_number_low', var.p_customer_number_low);

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

1267: dbms_sql.bind_variable(c, 'p_apply_date_high', var.p_apply_date_high);
1268: END IF;
1269:
1270: IF var.p_customer_number_low IS NOT NULL THEN
1271: dbms_sql.bind_variable(c, 'p_customer_number_low', var.p_customer_number_low);
1272: END IF;
1273: IF var.p_customer_number_high IS NOT NULL THEN
1274: dbms_sql.bind_variable(c, 'p_customer_number_high', var.p_customer_number_high);
1275: END IF;

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

1270: IF var.p_customer_number_low IS NOT NULL THEN
1271: dbms_sql.bind_variable(c, 'p_customer_number_low', var.p_customer_number_low);
1272: END IF;
1273: IF var.p_customer_number_high IS NOT NULL THEN
1274: dbms_sql.bind_variable(c, 'p_customer_number_high', var.p_customer_number_high);
1275: END IF;
1276:
1277: IF var.p_invoice_type_low IS NOT NULL THEN
1278: dbms_sql.bind_variable(c,'p_invoice_type_low', var.p_invoice_type_low);

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

1274: dbms_sql.bind_variable(c, 'p_customer_number_high', var.p_customer_number_high);
1275: END IF;
1276:
1277: IF var.p_invoice_type_low IS NOT NULL THEN
1278: dbms_sql.bind_variable(c,'p_invoice_type_low', var.p_invoice_type_low);
1279: END IF;
1280: IF var.p_invoice_type_high IS NOT NULL THEN
1281: dbms_sql.bind_variable(c, 'p_invoice_type_high',var.p_invoice_type_high);
1282: END IF;

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

1277: IF var.p_invoice_type_low IS NOT NULL THEN
1278: dbms_sql.bind_variable(c,'p_invoice_type_low', var.p_invoice_type_low);
1279: END IF;
1280: IF var.p_invoice_type_high IS NOT NULL THEN
1281: dbms_sql.bind_variable(c, 'p_invoice_type_high',var.p_invoice_type_high);
1282: END IF;
1283:
1284: end if;
1285: