APPS.JL_AR_DOC_NUMBERING_PKG dependencies on RA_CUSTOMER_TRX

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

911: FUNCTION get_flex_delimiter RETURN VARCHAR2 IS
912: l_dfinfo_rec FND_FLEX_SERVER1.DESCFLEXINFO;
913: l_success_bln BOOLEAN;
914: BEGIN
915: l_success_bln:= FND_FLEX_SERVER2.GET_DESCSTRUCT('JG','JG_RA_CUSTOMER_TRX',l_dfinfo_rec);
916: IF l_success_bln = TRUE THEN
917: RETURN l_dfinfo_rec.segment_delimiter;
918: ELSE
919: RETURN NULL;

Line 972: FROM ra_customer_trx

968: BEGIN
969: BEGIN
970: SELECT nvl(printing_count,0)
971: INTO l_return_code
972: FROM ra_customer_trx
973: WHERE customer_trx_id = p_cust_trx_id;
974: EXCEPTION
975: WHEN OTHERS THEN
976: l_return_code := 0;

Line 1095: l_trx_number ra_customer_trx_all.trx_number%TYPE;

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