APPS.FV_SLA_CST_PROCESSING_PKG dependencies on RCV_RECEIVING_SUB_LEDGER

Line 61: p_accounting_event_id IN rcv_receiving_sub_ledger.accounting_event_id%TYPE,

57: PROCEDURE get_enc_amount
58: (
59: p_transacton_id IN NUMBER,
60: p_event_type_code IN xla_events_gt.event_type_code%TYPE,
61: p_accounting_event_id IN rcv_receiving_sub_ledger.accounting_event_id%TYPE,
62: p_enc_accounted_amount OUT NOCOPY NUMBER,
63: p_enc_entered_amount OUT NOCOPY NUMBER,
64: p_error_code OUT NOCOPY NUMBER,
65: p_error_desc OUT NOCOPY VARCHAR2

Line 86: FROM rcv_receiving_sub_ledger rrs

82: SELECT -1*DECODE(rrs.accounted_dr, NULL, -1*rrs.accounted_cr, rrs.accounted_dr) accounted_amount,
83: -1*DECODE(rrs.entered_dr, NULL, -1*rrs.entered_cr, rrs.entered_dr ) entered_amount
84: INTO p_enc_accounted_amount,
85: p_enc_entered_amount
86: FROM rcv_receiving_sub_ledger rrs
87: WHERE rrs.rcv_transaction_id = p_transacton_id
88: AND DECODE(p_event_type_code, 'PERIOD_END_ACCRUAL', rrs.reference9, p_accounting_event_id) = p_accounting_event_id
89: AND rrs.accounting_line_type = 'Encumbrance Reversal';
90: EXCEPTION

Line 99: stack_error (l_procedure_name, 'SELECT_RCV_RECEIVING_SUB_LEDGER', p_error_desc);

95: p_error_code := c_FAILURE;
96: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
97: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
98: p_error_desc := fnd_message.get;
99: stack_error (l_procedure_name, 'SELECT_RCV_RECEIVING_SUB_LEDGER', p_error_desc);
100: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_RCV_RECEIVING_SUB_LEDGER:'||p_error_desc);
101: END;
102: ELSIF (p_event_type_code IN ('PO_DEL_INV', 'RET_RI_INV')) THEN
103: BEGIN

Line 100: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_RCV_RECEIVING_SUB_LEDGER:'||p_error_desc);

96: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
97: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
98: p_error_desc := fnd_message.get;
99: stack_error (l_procedure_name, 'SELECT_RCV_RECEIVING_SUB_LEDGER', p_error_desc);
100: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_RCV_RECEIVING_SUB_LEDGER:'||p_error_desc);
101: END;
102: ELSIF (p_event_type_code IN ('PO_DEL_INV', 'RET_RI_INV')) THEN
103: BEGIN
104: SELECT -1*mta.base_transaction_value accounted_amount,

Line 189: FROM rcv_receiving_sub_ledger rrs,

185: pod.budget_account_id budget_account,
186: rrs.currency_conversion_rate,
187: rrs.rcv_transaction_id transaction_id,
188: rrs.accounting_event_id
189: FROM rcv_receiving_sub_ledger rrs,
190: xla_events_gt xeg,
191: rcv_accounting_events rae,
192: po_distributions_all pod
193: WHERE c_acct_at_rcpt = 'N'

Line 222: FROM rcv_receiving_sub_ledger rrs,

218: pod.budget_account_id budget_account,
219: rrs.currency_conversion_rate,
220: rrs.rcv_transaction_id transaction_id,
221: rrs.accounting_event_id
222: FROM rcv_receiving_sub_ledger rrs,
223: xla_events_gt xeg,
224: rcv_accounting_events rae,
225: po_distributions_all pod
226: WHERE c_acct_at_rcpt = 'Y'