APPS.ARP_ACCT_EVENT_PKG dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 99: IF p_entity = 'RA_CUST_TRX_LINE_GL_DIST_ALL' THEN

95: END IF;
96: CLOSE c_ou;
97: END IF;
98:
99: IF p_entity = 'RA_CUST_TRX_LINE_GL_DIST_ALL' THEN
100: IF p_type NOT IN ('INV', 'CM', 'CB', 'DM', 'DEP', 'GUAR', 'ALL','INVDEPGUAR') THEN
101: FND_MESSAGE.SET_NAME( 'AR', 'AR_ONLY_VALUE_ALLOWED' );
102: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'trx_type' );
103: FND_MESSAGE.SET_TOKEN( 'VALUES', 'INV,CM,CB,DM,DEP,GUAR,ALL,INVDEPGUAR');

Line 166: ra_cust_trx_line_gl_dist gld,

162: distev.event_status_code dist_event_status,
163: distev.event_date dist_event_date,
164: distev.transaction_date dist_ev_trx_date
165: FROM ra_customer_trx trx,
166: ra_cust_trx_line_gl_dist gld,
167: ra_cust_trx_types ctt,
168: xla_transaction_entities_upg xet,
169: xla_events ev,
170: xla_events distev

Line 371: FROM ra_cust_trx_line_gl_dist d

367: FROM
368: (SELECT d.gl_date gl_date,
369: d.customer_trx_id trx_id,
370: d.event_id event_id
371: FROM ra_cust_trx_line_gl_dist d
372: WHERE customer_trx_id = p_source_int_id
373: AND account_set_flag = 'N'
374: AND gl_date IS NOT NULL
375: UNION ALL

Line 753: FROM ra_cust_trx_line_gl_dist_all ctlgd,

749: p_org_id IN NUMBER,
750: p_type IN VARCHAR2)
751: IS
752: SELECT ctlgd.customer_trx_id
753: FROM ra_cust_trx_line_gl_dist_all ctlgd,
754: ra_customer_trx_all trx,
755: ra_cust_trx_types_all tty
756: WHERE ctlgd.gl_date BETWEEN p_start_date AND p_end_date
757: AND ctlgd.posting_control_id = -3

Line 776: AND lk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'

772: FROM xla_distribution_links lk,
773: xla_ae_lines ae
774: WHERE ctlgd.cust_trx_line_gl_dist_id = lk.source_distribution_id_num_1
775: AND lk.application_id = 222
776: AND lk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'
777: AND ae.application_id = 222
778: AND lk.ae_header_id = ae.ae_header_id
779: AND lk.ae_line_num = ae.ae_line_num);
780: l_trx_id NUMBER;

Line 790: p_entity => 'RA_CUST_TRX_LINE_GL_DIST_ALL',

786: (p_start_date => p_start_date,
787: p_end_date => p_end_date,
788: p_org_id => p_org_id,
789: p_type => p_type,
790: p_entity => 'RA_CUST_TRX_LINE_GL_DIST_ALL',
791: x_return_status => x_return_status);
792: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
793: RAISE fnd_api.g_exc_error;
794: END IF;