APPS.ARP_ACCT_EVENT_PKG dependencies on RA_CUST_TRX_LINE_GL_DIST_ALL

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 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;