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.JL_AR_DOC_NUMBERING_PKG dependencies on RA_BATCH_SOURCES

Line 32: FROM jg_zz_ar_src_trx_ty st, ra_batch_sources_all src

28: END IF;
29: BEGIN
30: SELECT 'Success'
31: INTO l_dummy_code
32: FROM jg_zz_ar_src_trx_ty st, ra_batch_sources_all src
33: WHERE st.cust_trx_type_id = p_trx_type
34: AND st.batch_source_id = p_batch_source_id
35: AND invoice_class = p_invoice_class
36: AND st.batch_source_id = src.batch_source_id

Line 74: FROM ra_batch_sources a

70: BEGIN
71: --
72: SELECT substr(global_attribute2,1,4)
73: INTO l_branch_number
74: FROM ra_batch_sources a
75: WHERE a.batch_source_id = p_batch_source_id;
76: --
77: SELECT count(*)
78: INTO l_count

Line 79: FROM jg_zz_ar_src_trx_ty ty, ra_batch_sources_all src

75: WHERE a.batch_source_id = p_batch_source_id;
76: --
77: SELECT count(*)
78: INTO l_count
79: FROM jg_zz_ar_src_trx_ty ty, ra_batch_sources_all src
80: WHERE ty.cust_trx_type_id = p_trx_type
81: AND ty.batch_source_id = src.batch_source_id
82: AND substr(src.global_attribute3,1,1) <> p_document_letter
83: AND substr(src.global_attribute2,1,4) <> l_branch_number

Line 211: FROM ra_batch_sources

207: END IF;
208: BEGIN
209: SELECT 'Success'
210: INTO l_dummy_code
211: FROM ra_batch_sources
212: WHERE substr(global_attribute2,1,4) = l_product_line_code
213: AND batch_source_id = p_batch_source_id;
214: EXCEPTION
215: WHEN NO_DATA_FOUND THEN

Line 283: FROM ra_batch_sources

279: BEGIN
280: SELECT substr(global_attribute3,1,1),substr(global_attribute2,1,4)
281: ,global_attribute8, to_char(fnd_date.canonical_to_date(global_attribute9),'YYYY/MM/DD')
282: INTO l_doc_letter, l_branch_num, l_cai_num, l_cai_date
283: FROM ra_batch_sources
284: WHERE batch_source_id = p_batch_source_id;
285:
286: SELECT REPLACE(l_cai_date,'/') INTO l_cai_date from dual;
287:

Line 404: FROM ra_batch_sources

400: IF p_created_from = 'ARXTWMAI' THEN
401: BEGIN
402: SELECT global_attribute3
403: INTO p_document_letter
404: FROM ra_batch_sources
405: WHERE batch_source_id = p_batch_source_id;
406: EXCEPTION
407: WHEN OTHERS THEN
408: l_return_code := 'JL_AR_AR_INVALID_DOC_LETTER';

Line 719: FROM ra_batch_sources

715: INTO l_auto_trx_numbering_flag
716: ,l_document_letter
717: ,l_last_trx_date
718: ,l_advance_days
719: FROM ra_batch_sources
720: WHERE batch_source_id = l_batch_source_id;
721: END;
722: IF PG_DEBUG in ('Y', 'C') THEN
723: arp_standard.debug('validate_interface_lines: ' || '-- the batch source gdf segments found');

Line 832: UPDATE ra_batch_sources

828: IF PG_DEBUG in ('Y', 'C') THEN
829: arp_standard.debug('validate_interface_lines: ' || '-- update the dates');
830: END IF;
831: IF l_last_trx_date <> l_max_trx_date THEN
832: UPDATE ra_batch_sources
833: SET global_attribute4 = fnd_date.date_to_canonical(l_max_trx_date)
834: WHERE batch_source_id = l_batch_source_id;
835: END IF;
836:

Line 874: FROM ra_batch_sources

870: BEGIN
871: SELECT decode(batch_source_type, 'INV',to_number(global_attribute1),
872: batch_source_id)
873: INTO l_imp_batch_src
874: FROM ra_batch_sources
875: WHERE batch_source_id = p_batch_source_id;
876: EXCEPTION
877: WHEN OTHERS THEN
878: l_imp_batch_src := NULL;

Line 920: FROM ra_batch_sources

916: l_imp_batch_src_type := NULL;
917: BEGIN
918: SELECT batch_source_type
919: INTO l_imp_batch_src_type
920: FROM ra_batch_sources
921: WHERE batch_source_id = p_batch_source_id;
922: EXCEPTION
923: WHEN OTHERS THEN
924: l_imp_batch_src_type := NULL;

Line 938: FROM ra_batch_sources

934: l_return_code := 'SUCCESS';
935: BEGIN
936: SELECT 'SUCCESS'
937: INTO l_return_code
938: FROM ra_batch_sources
939: WHERE batch_source_id = p_batch_source_id
940: AND batch_source_type = 'FOREIGN'
941: AND p_trx_date BETWEEN
942: to_date(global_attribute4,'YYYY/MM/DD HH24:MI:SS')

Line 1006: FROM ra_batch_sources rbs

1002: BEGIN
1003: BEGIN
1004: SELECT substr(rbs.global_attribute3,1,1)
1005: INTO l_doc_letter
1006: FROM ra_batch_sources rbs
1007: WHERE rbs.batch_source_id = p_batch_source_id;
1008: EXCEPTION
1009: WHEN OTHERS THEN
1010: l_doc_letter := null;

Line 1021: FROM ra_batch_sources rbs

1017: BEGIN
1018: BEGIN
1019: SELECT lpad(substr(rbs.global_attribute2,1,4),4,'0')
1020: INTO l_br_number
1021: FROM ra_batch_sources rbs
1022: WHERE rbs.batch_source_id = p_batch_source_id;
1023: EXCEPTION
1024: WHEN OTHERS THEN
1025: l_br_number := null;

Line 1036: FROM ra_batch_sources rbs

1032: BEGIN
1033: BEGIN
1034: SELECT to_date(rbs.global_attribute4,'YYYY/MM/DD HH24:MI:SS')
1035: INTO l_last_trx_date
1036: FROM ra_batch_sources rbs
1037: WHERE rbs.batch_source_id = p_batch_source_id;
1038: EXCEPTION
1039: WHEN OTHERS THEN
1040: l_last_trx_date := null;

Line 1051: FROM ra_batch_sources rbs

1047: BEGIN
1048: BEGIN
1049: SELECT substr(rbs.global_attribute5,1,3)
1050: INTO l_adv_days
1051: FROM ra_batch_sources rbs
1052: WHERE rbs.batch_source_id = p_batch_source_id;
1053: EXCEPTION
1054: WHEN OTHERS THEN
1055: l_adv_days := null;

Line 1080: l_auto_trx_numbering_flag ra_batch_sources_all.auto_trx_numbering_flag%TYPE;

1076: p_trx_number IN VARCHAR2) RETURN VARCHAR2 IS
1077: l_country_code VARCHAR2(2);
1078: l_document_letter VARCHAR2(1);
1079: l_branch_number VARCHAR2(4);
1080: l_auto_trx_numbering_flag ra_batch_sources_all.auto_trx_numbering_flag%TYPE;
1081: l_trx_number ra_customer_trx_all.trx_number%TYPE;
1082: l_org_id NUMBER;
1083: l_ledger_id NUMBER;
1084: l_batch_src_type ra_batch_sources_all.batch_source_type%TYPE;

Line 1084: l_batch_src_type ra_batch_sources_all.batch_source_type%TYPE;

1080: l_auto_trx_numbering_flag ra_batch_sources_all.auto_trx_numbering_flag%TYPE;
1081: l_trx_number ra_customer_trx_all.trx_number%TYPE;
1082: l_org_id NUMBER;
1083: l_ledger_id NUMBER;
1084: l_batch_src_type ra_batch_sources_all.batch_source_type%TYPE;
1085: l_source_id ra_batch_sources_all.batch_source_id%TYPE;
1086: l_seq_name VARCHAR2(100);
1087: -- This function is being called from auto invoice.
1088: l_trx_num_cursor INTEGER;

Line 1085: l_source_id ra_batch_sources_all.batch_source_id%TYPE;

1081: l_trx_number ra_customer_trx_all.trx_number%TYPE;
1082: l_org_id NUMBER;
1083: l_ledger_id NUMBER;
1084: l_batch_src_type ra_batch_sources_all.batch_source_type%TYPE;
1085: l_source_id ra_batch_sources_all.batch_source_id%TYPE;
1086: l_seq_name VARCHAR2(100);
1087: -- This function is being called from auto invoice.
1088: l_trx_num_cursor INTEGER;
1089: --l_seq_name VARCHAR2(100);

Line 1105: FROM ra_batch_sources_all

1101:
1102: IF l_country_code = 'AR' THEN
1103:
1104: SELECT batch_source_type into l_batch_src_type
1105: FROM ra_batch_sources_all
1106: WHERE batch_source_id = p_batch_source_id;
1107:
1108: IF l_batch_src_type <> 'FOREIGN' THEN
1109:

Line 1111: FROM ra_batch_sources_all

1107:
1108: IF l_batch_src_type <> 'FOREIGN' THEN
1109:
1110: SELECT global_attribute1 into l_source_id
1111: FROM ra_batch_sources_all
1112: WHERE batch_source_id = p_batch_source_id;
1113:
1114: SELECT substr(global_attribute2,1,4),
1115: substr(global_attribute3,1,1),

Line 1120: FROM ra_batch_sources_all

1116: auto_trx_numbering_flag
1117: INTO l_branch_number,
1118: l_document_letter,
1119: l_auto_trx_numbering_flag
1120: FROM ra_batch_sources_all
1121: WHERE batch_source_id = l_source_id;
1122: --Bug#7697795
1123: --Start
1124: l_seq_name := 'RA_TRX_NUMBER_'

Line 1148: FROM ra_batch_sources_all

1144: auto_trx_numbering_flag
1145: INTO l_branch_number,
1146: l_document_letter,
1147: l_auto_trx_numbering_flag
1148: FROM ra_batch_sources_all
1149: WHERE batch_source_id = p_batch_source_id;
1150:
1151: END IF;
1152: