APPS.JL_AR_DOC_NUMBERING_PKG dependencies on RA_BATCH_SOURCES_ALL

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