APPS.JL_BR_AR_GENERATE_DEBIT_MEMO dependencies on RA_CUST_TRX_TYPES

Line 77: RA_CUST_TRX_TYPES e RA_SALESREPS AR_MEMO_LINES*/

73: FROM ra_account_default_segments
74: WHERE gl_default_id = X_gl_default_id;
75:
76: /* Get the account id to the Revene and Receivables tables
77: RA_CUST_TRX_TYPES e RA_SALESREPS AR_MEMO_LINES*/
78:
79: BEGIN
80: SELECT gl_id_rev, gl_id_rec
81: INTO X_cust_rev_id, X_cust_rec_id

Line 82: FROM ra_cust_trx_types

78:
79: BEGIN
80: SELECT gl_id_rev, gl_id_rec
81: INTO X_cust_rev_id, X_cust_rec_id
82: FROM ra_cust_trx_types
83: WHERE cust_trx_type_id = X_cust_trx_type_id;
84:
85: EXCEPTION
86: WHEN NO_DATA_FOUND THEN NULL;

Line 110: Verifica se o segmento esta' na tab. RA_CUST_TRX_TYPES entao

106:
107: X_select1 := DBMS_SQL.OPEN_CURSOR;
108:
109: /* Se o segmento nao e' uma X_constant entao
110: Verifica se o segmento esta' na tab. RA_CUST_TRX_TYPES entao
111: se o tipo de conta for Revenue Account entao
112: busca o id da conta Rev. da RA_CUST_TRX_TYPES
113: senao se o tipo de conta for Receivable Account entao
114: busca o id da conta Rec. da RA_CUST_TRX_TYPES

Line 112: busca o id da conta Rev. da RA_CUST_TRX_TYPES

108:
109: /* Se o segmento nao e' uma X_constant entao
110: Verifica se o segmento esta' na tab. RA_CUST_TRX_TYPES entao
111: se o tipo de conta for Revenue Account entao
112: busca o id da conta Rev. da RA_CUST_TRX_TYPES
113: senao se o tipo de conta for Receivable Account entao
114: busca o id da conta Rec. da RA_CUST_TRX_TYPES
115: senao verifica se segmento esta tab. RA_SALESREPS entao
116: se o tipo de conta for Revenue Account entao

Line 114: busca o id da conta Rec. da RA_CUST_TRX_TYPES

110: Verifica se o segmento esta' na tab. RA_CUST_TRX_TYPES entao
111: se o tipo de conta for Revenue Account entao
112: busca o id da conta Rev. da RA_CUST_TRX_TYPES
113: senao se o tipo de conta for Receivable Account entao
114: busca o id da conta Rec. da RA_CUST_TRX_TYPES
115: senao verifica se segmento esta tab. RA_SALESREPS entao
116: se o tipo de conta for Revenue Account entao
117: busca o id da conta Rev. da RA_SALESREPS
118: senao se o tipo de conta for Receivable Account entao

Line 122: IF X_table_name = 'RA_CUST_TRX_TYPES' THEN

118: senao se o tipo de conta for Receivable Account entao
119: busca o id da conta Rec. da RA_SALESREPS
120: */
121: IF X_constant IS NULL THEN
122: IF X_table_name = 'RA_CUST_TRX_TYPES' THEN
123: IF X_account_type = 'REV' THEN
124: X_gl_id := X_cust_rev_id;
125: ELSIF X_account_type = 'REC' THEN
126: X_gl_id := X_cust_rec_id;

Line 776: FROM ra_cust_trx_types

772:
773: /* Check if this transaction has to be posted to GL */
774: SELECT post_to_gl
775: INTO X_post_gl
776: FROM ra_cust_trx_types
777: WHERE cust_trx_type_id = X_cust_trx_type_id;
778:
779: IF X_post_gl = 'Y' THEN
780: X_gl_date := X_idm_date;