APPS.JAI_AR_RCTA_TRIGGER_PKG dependencies on RA_CUST_TRX_TYPES_ALL

Line 101: From RA_CUST_TRX_TYPES_ALL

97: WHERE trx_number = v_parent_trx_number;
98:
99: Cursor transaction_type_cur IS
100: Select type
101: From RA_CUST_TRX_TYPES_ALL
102: Where cust_trx_type_id = pr_new.cust_trx_type_id
103: And NVL(org_id,0) = NVL(pr_new.org_id,0);
104:
105: Cursor localization_header_info IS

Line 349: FROM RA_CUST_TRX_TYPES_ALL

345: ;
346:
347: CURSOR transaction_type_cur IS
348: SELECT TYPE
349: FROM RA_CUST_TRX_TYPES_ALL
350: WHERE cust_trx_type_id = pr_new.cust_trx_type_id
351: AND NVL(org_id,0) = NVL(pr_new.org_id,0);
352:
353:

Line 529: From RA_CUST_TRX_TYPES_ALL

525: v_ref_line_id varchar2(30); -- := pr_new.interface_header_attribute7; --Ramananda for File.Sql.35
526:
527: Cursor transaction_type_cur IS
528: Select type
529: From RA_CUST_TRX_TYPES_ALL
530: Where cust_trx_type_id = pr_new.cust_trx_type_id
531: And NVL(org_id,0) = NVL(pr_new.org_id,0);
532:
533: v_currency_code gl_sets_of_books.currency_code%type;

Line 637: v_trans_type RA_CUST_TRX_TYPES_ALL.TYPE%TYPE ;

633: */
634: PROCEDURE ARU_T3 ( pr_old t_rec%type , pr_new t_rec%type , pv_action varchar2 , pv_return_code out nocopy varchar2 , pv_return_message out nocopy varchar2 ) IS
635: v_organization_id NUMBER ;
636: v_loc_id NUMBER ;
637: v_trans_type RA_CUST_TRX_TYPES_ALL.TYPE%TYPE ;
638: lv_vat_invoice_no JAI_AR_TRXS.VAT_INVOICE_NO%TYPE ;
639: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;
640: ln_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE ;
641: lv_process_flag VARCHAR2(10) ;

Line 670: ra_cust_trx_types_all

666: IS
667: SELECT
668: type
669: FROM
670: ra_cust_trx_types_all
671: WHERE
672: cust_trx_type_id = pr_new.cust_trx_type_id AND
673: NVL(org_id,0) = NVL(pr_new.org_id,0);
674:

Line 1146: FROM RA_CUST_TRX_TYPES_ALL

1142: location_id = p_loc_id;
1143:
1144: CURSOR transaction_type_cur IS
1145: SELECT TYPE
1146: FROM RA_CUST_TRX_TYPES_ALL
1147: WHERE cust_trx_type_id = pr_new.cust_trx_type_id
1148: AND (org_id = pr_new.org_id
1149: OR
1150: (org_id is null and pr_new.org_id is null)) ; /* Modified by Ramananda for removal of SQL LITERALs */

Line 2851: From RA_CUST_TRX_TYPES_ALL a

2847: v_trans_type Varchar2(30);
2848:
2849: Cursor transaction_type_cur IS
2850: Select a.type
2851: From RA_CUST_TRX_TYPES_ALL a
2852: Where a.cust_trx_type_id = pr_new.cust_trx_type_id
2853: And a.org_id = v_org_id; /* Modified by Ramananda for removal of SQL LITERALs */
2854: -- And NVL(a.org_id,0) = v_org_id;
2855: