APPS.IGS_FI_PRC_BALANCES dependencies on IGS_FI_INV_INT

Line 93: p_n_amount IN igs_fi_inv_int.invoice_amount%TYPE ,

89: p_n_party_id IN igs_fi_balances.party_id%TYPE ,
90: /* Removed th parameter p_n_subaccount_id, as a part of Bug # 2564643 */
91: p_c_balance_type IN igs_lookups_view.lookup_code%TYPE ,
92: p_d_balance_date IN igs_fi_balances.balance_date%TYPE ,
93: p_n_amount IN igs_fi_inv_int.invoice_amount%TYPE ,
94: p_c_message OUT NOCOPY fnd_new_messages.message_name%TYPE
95: )
96: RETURN BOOLEAN;
97:

Line 188: FROM igs_fi_inv_int inv

184:
185: -- cursor reads from the charges tables
186: CURSOR cur_chrgs_for_balance IS
187: SELECT inv.*
188: FROM igs_fi_inv_int inv
189: WHERE person_id = p_person_id /*for person id passed as parameter*/
190: AND ((p_action = l_for_baldate AND TRUNC(inv.invoice_creation_date) = TRUNC(p_balance_date))
191: OR (p_action = l_as_on_baldate AND TRUNC(inv.invoice_creation_date) <= TRUNC(NVL(p_balance_date,sysdate)))
192: )

Line 228: l_rowid igs_fi_inv_int_v.row_id%TYPE;

224: l_cur_rec_exists cur_rec_exists%ROWTYPE;
225: l_invoice_amount igs_fi_balances.standard_balance%TYPE := 0.0;
226: l_credit_amount igs_fi_credits_all.amount%TYPE := 0.0;
227: l_balance igs_fi_balances.standard_balance%TYPE := 0.0;
228: l_rowid igs_fi_inv_int_v.row_id%TYPE;
229: l_balance_id igs_fi_balances.balance_id%TYPE;
230: l_bal_standard igs_fi_balances.standard_balance%TYPE := 0.0;
231: l_bal_fee igs_fi_balances.standard_balance%TYPE := 0.0;
232: l_bal_hold igs_fi_balances.standard_balance%TYPE := 0.0;

Line 437: p_amount IN igs_fi_inv_int.invoice_amount%TYPE ,

433: /**************The below procedure added as part of SFCR 10 **************/
434: PROCEDURE update_balances ( p_party_id IN igs_fi_balances.party_id%TYPE ,
435: p_balance_type IN igs_lookups_view.lookup_code%TYPE ,
436: p_balance_date IN igs_fi_balances.balance_date%TYPE ,
437: p_amount IN igs_fi_inv_int.invoice_amount%TYPE ,
438: p_source IN VARCHAR2 ,
439: p_source_id IN NUMBER ,
440: p_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE
441: ) IS

Line 908: l_fee_type igs_fi_inv_int_v.fee_type%TYPE;

904: -- smadathi 10-APR-2002 Bug 2289191. References to enabled_flag column removed from cursor
905: -- c_subacct_excl, c_ftype_excl, c_ctyp_excl select list.
906: -- (reverse chronological order - newest change first)
907: -------------------------------------------------------------------------------
908: l_fee_type igs_fi_inv_int_v.fee_type%TYPE;
909: l_credit_type_id igs_fi_credits_v.credit_type_id%TYPE;
910: l_balance_rule_id igs_fi_balance_rules.balance_rule_id%TYPE := p_balance_rule_id;
911: l_std_bal igs_lookup_values.lookup_code%TYPE := 'STANDARD';
912: l_sysdate DATE := TRUNC(SYSDATE);

Line 927: CURSOR c_charge(cp_source_id igs_fi_inv_int.invoice_id%TYPE) IS

923: NVL(TRUNC(end_date_active),l_sysdate);
924:
925: --removed cursor c_balance.
926:
927: CURSOR c_charge(cp_source_id igs_fi_inv_int.invoice_id%TYPE) IS
928: SELECT fee_type, invoice_creation_date
929: FROM igs_fi_inv_int_v
930: WHERE invoice_id = cp_source_id;
931:

Line 929: FROM igs_fi_inv_int_v

925: --removed cursor c_balance.
926:
927: CURSOR c_charge(cp_source_id igs_fi_inv_int.invoice_id%TYPE) IS
928: SELECT fee_type, invoice_creation_date
929: FROM igs_fi_inv_int_v
930: WHERE invoice_id = cp_source_id;
931:
932: CURSOR c_credit(cp_source_id igs_fi_credits_all.credit_id%TYPE)IS
933: SELECT credit_type_id, effective_date

Line 1077: p_n_amount IN igs_fi_inv_int.invoice_amount%TYPE ,

1073: p_n_party_id IN igs_fi_balances.party_id%TYPE ,
1074: /* Removed the parameter p_subaccount_id as a part of Bug # 2564643 */
1075: p_c_balance_type IN igs_lookups_view.lookup_code%TYPE ,
1076: p_d_balance_date IN igs_fi_balances.balance_date%TYPE ,
1077: p_n_amount IN igs_fi_inv_int.invoice_amount%TYPE ,
1078: p_c_message OUT NOCOPY fnd_new_messages.message_name%TYPE
1079: )
1080: RETURN BOOLEAN AS
1081: ------------------------------------------------------------------