DBA Data[Home] [Help]

APPS.IGS_FI_GEN_007 dependencies on IGS_FI_CR_ACTIVITIES

Line 570: p_dr_gl_ccid OUT NOCOPY igs_fi_cr_activities.dr_gl_ccid%TYPE,

566: p_invoice_id IN igs_fi_inv_int.invoice_id%TYPE,
567: p_amount_apply IN igs_fi_applications.amount_applied%TYPE,
568: p_cur_credit IN cur_credit%ROWTYPE,
569: p_cur_invoice IN cur_invoice%ROWTYPE,
570: p_dr_gl_ccid OUT NOCOPY igs_fi_cr_activities.dr_gl_ccid%TYPE,
571: p_cr_gl_ccid OUT NOCOPY igs_fi_cr_activities.cr_gl_ccid%TYPE,
572: p_dr_account_cd OUT NOCOPY igs_fi_cr_activities.dr_account_cd%TYPE,
573: p_cr_account_cd OUT NOCOPY igs_fi_cr_activities.cr_account_cd%TYPE,
574: p_application_id OUT NOCOPY igs_fi_applications.application_id%TYPE,

Line 571: p_cr_gl_ccid OUT NOCOPY igs_fi_cr_activities.cr_gl_ccid%TYPE,

567: p_amount_apply IN igs_fi_applications.amount_applied%TYPE,
568: p_cur_credit IN cur_credit%ROWTYPE,
569: p_cur_invoice IN cur_invoice%ROWTYPE,
570: p_dr_gl_ccid OUT NOCOPY igs_fi_cr_activities.dr_gl_ccid%TYPE,
571: p_cr_gl_ccid OUT NOCOPY igs_fi_cr_activities.cr_gl_ccid%TYPE,
572: p_dr_account_cd OUT NOCOPY igs_fi_cr_activities.dr_account_cd%TYPE,
573: p_cr_account_cd OUT NOCOPY igs_fi_cr_activities.cr_account_cd%TYPE,
574: p_application_id OUT NOCOPY igs_fi_applications.application_id%TYPE,
575: p_appl_hierarchy_id IN igs_fi_applications.appl_hierarchy_id%TYPE,

Line 572: p_dr_account_cd OUT NOCOPY igs_fi_cr_activities.dr_account_cd%TYPE,

568: p_cur_credit IN cur_credit%ROWTYPE,
569: p_cur_invoice IN cur_invoice%ROWTYPE,
570: p_dr_gl_ccid OUT NOCOPY igs_fi_cr_activities.dr_gl_ccid%TYPE,
571: p_cr_gl_ccid OUT NOCOPY igs_fi_cr_activities.cr_gl_ccid%TYPE,
572: p_dr_account_cd OUT NOCOPY igs_fi_cr_activities.dr_account_cd%TYPE,
573: p_cr_account_cd OUT NOCOPY igs_fi_cr_activities.cr_account_cd%TYPE,
574: p_application_id OUT NOCOPY igs_fi_applications.application_id%TYPE,
575: p_appl_hierarchy_id IN igs_fi_applications.appl_hierarchy_id%TYPE,
576: p_unapp_amount OUT NOCOPY igs_fi_credits_all.unapplied_amount%TYPE,

Line 573: p_cr_account_cd OUT NOCOPY igs_fi_cr_activities.cr_account_cd%TYPE,

569: p_cur_invoice IN cur_invoice%ROWTYPE,
570: p_dr_gl_ccid OUT NOCOPY igs_fi_cr_activities.dr_gl_ccid%TYPE,
571: p_cr_gl_ccid OUT NOCOPY igs_fi_cr_activities.cr_gl_ccid%TYPE,
572: p_dr_account_cd OUT NOCOPY igs_fi_cr_activities.dr_account_cd%TYPE,
573: p_cr_account_cd OUT NOCOPY igs_fi_cr_activities.cr_account_cd%TYPE,
574: p_application_id OUT NOCOPY igs_fi_applications.application_id%TYPE,
575: p_appl_hierarchy_id IN igs_fi_applications.appl_hierarchy_id%TYPE,
576: p_unapp_amount OUT NOCOPY igs_fi_credits_all.unapplied_amount%TYPE,
577: p_inv_amt_due OUT NOCOPY igs_fi_inv_int_all.invoice_amount_due%TYPE,

Line 601: FROM igs_fi_cr_activities

597: || (reverse chronological order - newest change first) */
598:
599: CURSOR cur_cr_act IS
600: SELECT credit_activity_id
601: FROM igs_fi_cr_activities
602: WHERE credit_id = p_credit_id;
603: l_cur_cr_act cur_cr_act%ROWTYPE;
604:
605: CURSOR cur_invln IS

Line 868: PROCEDURE get_appl_acc(p_cr_activity_id IN igs_fi_cr_activities.credit_activity_id%TYPE,

864:
865: END unapplication;
866:
867:
868: PROCEDURE get_appl_acc(p_cr_activity_id IN igs_fi_cr_activities.credit_activity_id%TYPE,
869: p_invoice_lines_id IN igs_fi_invln_int.invoice_lines_id%TYPE,
870: p_dr_gl_ccid OUT NOCOPY igs_fi_cr_activities.dr_gl_ccid%TYPE,
871: p_cr_gl_ccid OUT NOCOPY igs_fi_cr_activities.cr_gl_ccid%TYPE,
872: p_dr_account_cd OUT NOCOPY igs_fi_cr_activities.dr_account_cd%TYPE,

Line 870: p_dr_gl_ccid OUT NOCOPY igs_fi_cr_activities.dr_gl_ccid%TYPE,

866:
867:
868: PROCEDURE get_appl_acc(p_cr_activity_id IN igs_fi_cr_activities.credit_activity_id%TYPE,
869: p_invoice_lines_id IN igs_fi_invln_int.invoice_lines_id%TYPE,
870: p_dr_gl_ccid OUT NOCOPY igs_fi_cr_activities.dr_gl_ccid%TYPE,
871: p_cr_gl_ccid OUT NOCOPY igs_fi_cr_activities.cr_gl_ccid%TYPE,
872: p_dr_account_cd OUT NOCOPY igs_fi_cr_activities.dr_account_cd%TYPE,
873: p_cr_account_cd OUT NOCOPY igs_fi_cr_activities.cr_account_cd%TYPE,
874: p_status OUT NOCOPY BOOLEAN) AS

Line 871: p_cr_gl_ccid OUT NOCOPY igs_fi_cr_activities.cr_gl_ccid%TYPE,

867:
868: PROCEDURE get_appl_acc(p_cr_activity_id IN igs_fi_cr_activities.credit_activity_id%TYPE,
869: p_invoice_lines_id IN igs_fi_invln_int.invoice_lines_id%TYPE,
870: p_dr_gl_ccid OUT NOCOPY igs_fi_cr_activities.dr_gl_ccid%TYPE,
871: p_cr_gl_ccid OUT NOCOPY igs_fi_cr_activities.cr_gl_ccid%TYPE,
872: p_dr_account_cd OUT NOCOPY igs_fi_cr_activities.dr_account_cd%TYPE,
873: p_cr_account_cd OUT NOCOPY igs_fi_cr_activities.cr_account_cd%TYPE,
874: p_status OUT NOCOPY BOOLEAN) AS
875: /*|| Created By :Sarakshi

Line 872: p_dr_account_cd OUT NOCOPY igs_fi_cr_activities.dr_account_cd%TYPE,

868: PROCEDURE get_appl_acc(p_cr_activity_id IN igs_fi_cr_activities.credit_activity_id%TYPE,
869: p_invoice_lines_id IN igs_fi_invln_int.invoice_lines_id%TYPE,
870: p_dr_gl_ccid OUT NOCOPY igs_fi_cr_activities.dr_gl_ccid%TYPE,
871: p_cr_gl_ccid OUT NOCOPY igs_fi_cr_activities.cr_gl_ccid%TYPE,
872: p_dr_account_cd OUT NOCOPY igs_fi_cr_activities.dr_account_cd%TYPE,
873: p_cr_account_cd OUT NOCOPY igs_fi_cr_activities.cr_account_cd%TYPE,
874: p_status OUT NOCOPY BOOLEAN) AS
875: /*|| Created By :Sarakshi
876: || Created On :23-Jan-2002

Line 873: p_cr_account_cd OUT NOCOPY igs_fi_cr_activities.cr_account_cd%TYPE,

869: p_invoice_lines_id IN igs_fi_invln_int.invoice_lines_id%TYPE,
870: p_dr_gl_ccid OUT NOCOPY igs_fi_cr_activities.dr_gl_ccid%TYPE,
871: p_cr_gl_ccid OUT NOCOPY igs_fi_cr_activities.cr_gl_ccid%TYPE,
872: p_dr_account_cd OUT NOCOPY igs_fi_cr_activities.dr_account_cd%TYPE,
873: p_cr_account_cd OUT NOCOPY igs_fi_cr_activities.cr_account_cd%TYPE,
874: p_status OUT NOCOPY BOOLEAN) AS
875: /*|| Created By :Sarakshi
876: || Created On :23-Jan-2002
877: || Purpose :To derive the Accounting Information for the Application Record.

Line 885: FROM igs_fi_cr_activities

881: || (reverse chronological order - newest change first) */
882:
883: CURSOR cur_cr_act IS
884: SELECT dr_gl_ccid,cr_gl_ccid,dr_account_cd,cr_account_cd
885: FROM igs_fi_cr_activities
886: WHERE credit_activity_id = p_cr_activity_id;
887: l_cur_cr_act cur_cr_act%ROWTYPE;
888:
889: CURSOR cur_inv IS

Line 900: igs_fi_cr_activities ca

896: CURSOR cur_class IS
897: SELECT ct.credit_class
898: FROM igs_fi_cr_types ct,
899: igs_fi_credits c,
900: igs_fi_cr_activities ca
901: WHERE ct.credit_type_id=c.credit_type_id
902: AND c.credit_id=ca.credit_id
903: AND ca.credit_activity_id=p_cr_activity_id;
904: l_cur_class cur_class%ROWTYPE;

Line 1027: p_dr_gl_ccid OUT NOCOPY igs_fi_cr_activities.dr_gl_ccid%TYPE,

1023: p_amount_apply IN igs_fi_applications.amount_applied%TYPE,
1024: p_appl_type IN igs_fi_applications.application_type%TYPE,
1025: p_appl_hierarchy_id IN igs_fi_applications.appl_hierarchy_Id%TYPE,
1026: p_validation IN VARCHAR2 ,
1027: p_dr_gl_ccid OUT NOCOPY igs_fi_cr_activities.dr_gl_ccid%TYPE,
1028: p_cr_gl_ccid OUT NOCOPY igs_fi_cr_activities.cr_gl_ccid%TYPE,
1029: p_dr_account_cd OUT NOCOPY igs_fi_cr_activities.dr_account_cd%TYPE,
1030: p_cr_account_cd OUT NOCOPY igs_fi_cr_activities.cr_account_cd%TYPE,
1031: p_unapp_amount OUT NOCOPY igs_fi_credits_all.unapplied_amount%TYPE,

Line 1028: p_cr_gl_ccid OUT NOCOPY igs_fi_cr_activities.cr_gl_ccid%TYPE,

1024: p_appl_type IN igs_fi_applications.application_type%TYPE,
1025: p_appl_hierarchy_id IN igs_fi_applications.appl_hierarchy_Id%TYPE,
1026: p_validation IN VARCHAR2 ,
1027: p_dr_gl_ccid OUT NOCOPY igs_fi_cr_activities.dr_gl_ccid%TYPE,
1028: p_cr_gl_ccid OUT NOCOPY igs_fi_cr_activities.cr_gl_ccid%TYPE,
1029: p_dr_account_cd OUT NOCOPY igs_fi_cr_activities.dr_account_cd%TYPE,
1030: p_cr_account_cd OUT NOCOPY igs_fi_cr_activities.cr_account_cd%TYPE,
1031: p_unapp_amount OUT NOCOPY igs_fi_credits_all.unapplied_amount%TYPE,
1032: p_inv_amt_due OUT NOCOPY igs_fi_inv_int_all.invoice_amount_due%TYPE,

Line 1029: p_dr_account_cd OUT NOCOPY igs_fi_cr_activities.dr_account_cd%TYPE,

1025: p_appl_hierarchy_id IN igs_fi_applications.appl_hierarchy_Id%TYPE,
1026: p_validation IN VARCHAR2 ,
1027: p_dr_gl_ccid OUT NOCOPY igs_fi_cr_activities.dr_gl_ccid%TYPE,
1028: p_cr_gl_ccid OUT NOCOPY igs_fi_cr_activities.cr_gl_ccid%TYPE,
1029: p_dr_account_cd OUT NOCOPY igs_fi_cr_activities.dr_account_cd%TYPE,
1030: p_cr_account_cd OUT NOCOPY igs_fi_cr_activities.cr_account_cd%TYPE,
1031: p_unapp_amount OUT NOCOPY igs_fi_credits_all.unapplied_amount%TYPE,
1032: p_inv_amt_due OUT NOCOPY igs_fi_inv_int_all.invoice_amount_due%TYPE,
1033: p_err_msg OUT NOCOPY fnd_new_messages.message_name%TYPE,

Line 1030: p_cr_account_cd OUT NOCOPY igs_fi_cr_activities.cr_account_cd%TYPE,

1026: p_validation IN VARCHAR2 ,
1027: p_dr_gl_ccid OUT NOCOPY igs_fi_cr_activities.dr_gl_ccid%TYPE,
1028: p_cr_gl_ccid OUT NOCOPY igs_fi_cr_activities.cr_gl_ccid%TYPE,
1029: p_dr_account_cd OUT NOCOPY igs_fi_cr_activities.dr_account_cd%TYPE,
1030: p_cr_account_cd OUT NOCOPY igs_fi_cr_activities.cr_account_cd%TYPE,
1031: p_unapp_amount OUT NOCOPY igs_fi_credits_all.unapplied_amount%TYPE,
1032: p_inv_amt_due OUT NOCOPY igs_fi_inv_int_all.invoice_amount_due%TYPE,
1033: p_err_msg OUT NOCOPY fnd_new_messages.message_name%TYPE,
1034: p_status OUT NOCOPY BOOLEAN,