APPS.JL_AR_DOC_NUMBERING_PKG dependencies on RA_CUSTOMER_TRX

Line 901: l_success_bln:= FND_FLEX_SERVER2.GET_DESCSTRUCT('JG','JG_RA_CUSTOMER_TRX',l_dfinfo_rec);

897: FUNCTION get_flex_delimiter RETURN VARCHAR2 IS
898: l_dfinfo_rec FND_FLEX_SERVER1.DESCFLEXINFO;
899: l_success_bln BOOLEAN;
900: BEGIN
901: l_success_bln:= FND_FLEX_SERVER2.GET_DESCSTRUCT('JG','JG_RA_CUSTOMER_TRX',l_dfinfo_rec);
902: IF l_success_bln = TRUE THEN
903: RETURN l_dfinfo_rec.segment_delimiter;
904: ELSE
905: RETURN NULL;

Line 958: FROM ra_customer_trx

954: BEGIN
955: BEGIN
956: SELECT nvl(printing_count,0)
957: INTO l_return_code
958: FROM ra_customer_trx
959: WHERE customer_trx_id = p_cust_trx_id;
960: EXCEPTION
961: WHEN OTHERS THEN
962: l_return_code := 0;

Line 1081: l_trx_number ra_customer_trx_all.trx_number%TYPE;

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;
1085: l_source_id ra_batch_sources_all.batch_source_id%TYPE;