APPS.JL_AR_DOC_NUMBERING_PKG dependencies on RA_BATCH_SOURCES_ALL

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 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 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: