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 36: FROM jg_zz_ar_src_trx_ty st, ra_batch_sources_all src

32: -- Bug 8825457 End
33: BEGIN
34: SELECT 'Success'
35: INTO l_dummy_code
36: FROM jg_zz_ar_src_trx_ty st, ra_batch_sources_all src
37: WHERE st.cust_trx_type_id = p_trx_type
38: AND st.batch_source_id = p_batch_source_id
39: AND invoice_class = p_invoice_class
40: AND st.batch_source_id = src.batch_source_id

Line 81: FROM ra_batch_sources a

77: BEGIN
78: --
79: SELECT substr(global_attribute2,1,4)
80: INTO l_branch_number
81: FROM ra_batch_sources a
82: WHERE a.batch_source_id = p_batch_source_id;
83: --
84: SELECT count(*)
85: INTO l_count

Line 86: FROM jg_zz_ar_src_trx_ty ty, ra_batch_sources_all src

82: WHERE a.batch_source_id = p_batch_source_id;
83: --
84: SELECT count(*)
85: INTO l_count
86: FROM jg_zz_ar_src_trx_ty ty, ra_batch_sources_all src
87: WHERE ty.cust_trx_type_id = p_trx_type
88: AND ty.batch_source_id = src.batch_source_id
89: AND substr(src.global_attribute3,1,1) <> p_document_letter
90: AND substr(src.global_attribute2,1,4) <> l_branch_number

Line 218: FROM ra_batch_sources

214: END IF;
215: BEGIN
216: SELECT 'Success'
217: INTO l_dummy_code
218: FROM ra_batch_sources
219: WHERE substr(global_attribute2,1,4) = l_product_line_code
220: AND batch_source_id = p_batch_source_id;
221: EXCEPTION
222: WHEN NO_DATA_FOUND THEN

Line 290: FROM ra_batch_sources

286: BEGIN
287: SELECT substr(global_attribute3,1,1),substr(global_attribute2,1,4)
288: ,global_attribute8, to_char(fnd_date.canonical_to_date(global_attribute9),'YYYY/MM/DD')
289: INTO l_doc_letter, l_branch_num, l_cai_num, l_cai_date
290: FROM ra_batch_sources
291: WHERE batch_source_id = p_batch_source_id;
292:
293: SELECT REPLACE(l_cai_date,'/') INTO l_cai_date from dual;
294:

Line 418: FROM ra_batch_sources

414: IF p_created_from = 'ARXTWMAI' THEN
415: BEGIN
416: SELECT global_attribute3
417: INTO p_document_letter
418: FROM ra_batch_sources
419: WHERE batch_source_id = p_batch_source_id;
420: EXCEPTION
421: WHEN OTHERS THEN
422: l_return_code := 'JL_AR_AR_INVALID_DOC_LETTER';

Line 733: FROM ra_batch_sources

729: INTO l_auto_trx_numbering_flag
730: ,l_document_letter
731: ,l_last_trx_date
732: ,l_advance_days
733: FROM ra_batch_sources
734: WHERE batch_source_id = l_batch_source_id;
735: END;
736: IF PG_DEBUG in ('Y', 'C') THEN
737: arp_standard.debug('validate_interface_lines: ' || '-- the batch source gdf segments found');

Line 846: UPDATE ra_batch_sources

842: IF PG_DEBUG in ('Y', 'C') THEN
843: arp_standard.debug('validate_interface_lines: ' || '-- update the dates');
844: END IF;
845: IF l_last_trx_date <> l_max_trx_date THEN
846: UPDATE ra_batch_sources
847: SET global_attribute4 = fnd_date.date_to_canonical(l_max_trx_date)
848: WHERE batch_source_id = l_batch_source_id;
849: END IF;
850:

Line 888: FROM ra_batch_sources

884: BEGIN
885: SELECT decode(batch_source_type, 'INV',to_number(global_attribute1),
886: batch_source_id)
887: INTO l_imp_batch_src
888: FROM ra_batch_sources
889: WHERE batch_source_id = p_batch_source_id;
890: EXCEPTION
891: WHEN OTHERS THEN
892: l_imp_batch_src := NULL;

Line 934: FROM ra_batch_sources

930: l_imp_batch_src_type := NULL;
931: BEGIN
932: SELECT batch_source_type
933: INTO l_imp_batch_src_type
934: FROM ra_batch_sources
935: WHERE batch_source_id = p_batch_source_id;
936: EXCEPTION
937: WHEN OTHERS THEN
938: l_imp_batch_src_type := NULL;

Line 952: FROM ra_batch_sources

948: l_return_code := 'SUCCESS';
949: BEGIN
950: SELECT 'SUCCESS'
951: INTO l_return_code
952: FROM ra_batch_sources
953: WHERE batch_source_id = p_batch_source_id
954: AND batch_source_type = 'FOREIGN'
955: AND p_trx_date BETWEEN
956: to_date(global_attribute4,'YYYY/MM/DD HH24:MI:SS')

Line 1020: FROM ra_batch_sources rbs

1016: BEGIN
1017: BEGIN
1018: SELECT substr(rbs.global_attribute3,1,1)
1019: INTO l_doc_letter
1020: FROM ra_batch_sources rbs
1021: WHERE rbs.batch_source_id = p_batch_source_id;
1022: EXCEPTION
1023: WHEN OTHERS THEN
1024: l_doc_letter := null;

Line 1035: FROM ra_batch_sources rbs

1031: BEGIN
1032: BEGIN
1033: SELECT lpad(substr(rbs.global_attribute2,1,4),4,'0')
1034: INTO l_br_number
1035: FROM ra_batch_sources rbs
1036: WHERE rbs.batch_source_id = p_batch_source_id;
1037: EXCEPTION
1038: WHEN OTHERS THEN
1039: l_br_number := null;

Line 1050: FROM ra_batch_sources rbs

1046: BEGIN
1047: BEGIN
1048: SELECT to_date(rbs.global_attribute4,'YYYY/MM/DD HH24:MI:SS')
1049: INTO l_last_trx_date
1050: FROM ra_batch_sources rbs
1051: WHERE rbs.batch_source_id = p_batch_source_id;
1052: EXCEPTION
1053: WHEN OTHERS THEN
1054: l_last_trx_date := null;

Line 1065: FROM ra_batch_sources rbs

1061: BEGIN
1062: BEGIN
1063: SELECT substr(rbs.global_attribute5,1,3)
1064: INTO l_adv_days
1065: FROM ra_batch_sources rbs
1066: WHERE rbs.batch_source_id = p_batch_source_id;
1067: EXCEPTION
1068: WHEN OTHERS THEN
1069: l_adv_days := null;

Line 1094: l_auto_trx_numbering_flag ra_batch_sources_all.auto_trx_numbering_flag%TYPE;

1090: p_trx_number IN VARCHAR2) RETURN VARCHAR2 IS
1091: l_country_code VARCHAR2(2);
1092: l_document_letter VARCHAR2(1);
1093: l_branch_number VARCHAR2(4);
1094: l_auto_trx_numbering_flag ra_batch_sources_all.auto_trx_numbering_flag%TYPE;
1095: l_trx_number ra_customer_trx_all.trx_number%TYPE;
1096: l_org_id NUMBER;
1097: l_ledger_id NUMBER;
1098: l_batch_src_type ra_batch_sources_all.batch_source_type%TYPE;

Line 1098: l_batch_src_type ra_batch_sources_all.batch_source_type%TYPE;

1094: l_auto_trx_numbering_flag ra_batch_sources_all.auto_trx_numbering_flag%TYPE;
1095: l_trx_number ra_customer_trx_all.trx_number%TYPE;
1096: l_org_id NUMBER;
1097: l_ledger_id NUMBER;
1098: l_batch_src_type ra_batch_sources_all.batch_source_type%TYPE;
1099: l_source_id ra_batch_sources_all.batch_source_id%TYPE;
1100: l_seq_name VARCHAR2(100);
1101: -- This function is being called from auto invoice.
1102: l_trx_num_cursor INTEGER;

Line 1099: l_source_id ra_batch_sources_all.batch_source_id%TYPE;

1095: l_trx_number ra_customer_trx_all.trx_number%TYPE;
1096: l_org_id NUMBER;
1097: l_ledger_id NUMBER;
1098: l_batch_src_type ra_batch_sources_all.batch_source_type%TYPE;
1099: l_source_id ra_batch_sources_all.batch_source_id%TYPE;
1100: l_seq_name VARCHAR2(100);
1101: -- This function is being called from auto invoice.
1102: l_trx_num_cursor INTEGER;
1103: --l_seq_name VARCHAR2(100);

Line 1119: FROM ra_batch_sources_all

1115:
1116: IF l_country_code = 'AR' THEN
1117:
1118: SELECT batch_source_type into l_batch_src_type
1119: FROM ra_batch_sources_all
1120: WHERE batch_source_id = p_batch_source_id;
1121:
1122: IF l_batch_src_type <> 'FOREIGN' THEN
1123:

Line 1125: FROM ra_batch_sources_all

1121:
1122: IF l_batch_src_type <> 'FOREIGN' THEN
1123:
1124: SELECT global_attribute1 into l_source_id
1125: FROM ra_batch_sources_all
1126: WHERE batch_source_id = p_batch_source_id;
1127:
1128: SELECT substr(global_attribute2,1,4),
1129: substr(global_attribute3,1,1),

Line 1134: FROM ra_batch_sources_all

1130: auto_trx_numbering_flag
1131: INTO l_branch_number,
1132: l_document_letter,
1133: l_auto_trx_numbering_flag
1134: FROM ra_batch_sources_all
1135: WHERE batch_source_id = l_source_id;
1136: --Bug#7697795
1137: --Start
1138: l_seq_name := 'RA_TRX_NUMBER_'

Line 1162: FROM ra_batch_sources_all

1158: auto_trx_numbering_flag
1159: INTO l_branch_number,
1160: l_document_letter,
1161: l_auto_trx_numbering_flag
1162: FROM ra_batch_sources_all
1163: WHERE batch_source_id = p_batch_source_id;
1164:
1165: END IF;
1166: