APPS.ARP_ACCT_EVENT_PKG dependencies on RA_CUST_TRX_LINE_GL_DIST_ALL

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