APPS.ARP_ACCT_EVENT_PKG dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 98: IF p_entity = 'RA_CUST_TRX_LINE_GL_DIST_ALL' THEN

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

Line 165: ra_cust_trx_line_gl_dist gld,

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

Line 370: FROM ra_cust_trx_line_gl_dist d

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

Line 751: FROM ra_cust_trx_line_gl_dist_all ctlgd,

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

Line 774: AND lk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'

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

Line 788: p_entity => 'RA_CUST_TRX_LINE_GL_DIST_ALL',

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