eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FUN_WEBADI_PKG dependencies on FUN_INTERFACE_DIST_LINES

Line 93: Insert Into Fun_Interface_Dist_Lines(

89: Procedure Insert_Dists(
90: p_dist_lines_tbl In FUN_TRX_PUB.full_dist_line_tbl_type,
91: p_count In Number) Is
92: Begin
93: Insert Into Fun_Interface_Dist_Lines(
94: trx_id,
95: dist_id,
96: batch_dist_id,
97: dist_number,

Line 613: p_id_ccid In Fun_Interface_Dist_Lines.ccid%type,

609: p_h_attribute13 In Fun_Interface_Headers.attribute13%type,
610: p_h_attribute14 In Fun_Interface_Headers.attribute14%type,
611: p_h_attribute15 In Fun_Interface_Headers.attribute15%type,
612: p_h_attribute_category In Fun_Interface_Headers.attribute_category%type,
613: p_id_ccid In Fun_Interface_Dist_Lines.ccid%type,
614: p_id_amount_dr In Fun_Interface_Dist_Lines.amount_dr%type,
615: p_id_amount_cr In Fun_Interface_Dist_Lines.amount_cr%type,
616: p_id_description In Fun_Interface_Dist_Lines.description%type,
617: p_id_attribute1 In Fun_Interface_Dist_Lines.attribute1%type,

Line 614: p_id_amount_dr In Fun_Interface_Dist_Lines.amount_dr%type,

610: p_h_attribute14 In Fun_Interface_Headers.attribute14%type,
611: p_h_attribute15 In Fun_Interface_Headers.attribute15%type,
612: p_h_attribute_category In Fun_Interface_Headers.attribute_category%type,
613: p_id_ccid In Fun_Interface_Dist_Lines.ccid%type,
614: p_id_amount_dr In Fun_Interface_Dist_Lines.amount_dr%type,
615: p_id_amount_cr In Fun_Interface_Dist_Lines.amount_cr%type,
616: p_id_description In Fun_Interface_Dist_Lines.description%type,
617: p_id_attribute1 In Fun_Interface_Dist_Lines.attribute1%type,
618: p_id_attribute2 In Fun_Interface_Dist_Lines.attribute2%type,

Line 615: p_id_amount_cr In Fun_Interface_Dist_Lines.amount_cr%type,

611: p_h_attribute15 In Fun_Interface_Headers.attribute15%type,
612: p_h_attribute_category In Fun_Interface_Headers.attribute_category%type,
613: p_id_ccid In Fun_Interface_Dist_Lines.ccid%type,
614: p_id_amount_dr In Fun_Interface_Dist_Lines.amount_dr%type,
615: p_id_amount_cr In Fun_Interface_Dist_Lines.amount_cr%type,
616: p_id_description In Fun_Interface_Dist_Lines.description%type,
617: p_id_attribute1 In Fun_Interface_Dist_Lines.attribute1%type,
618: p_id_attribute2 In Fun_Interface_Dist_Lines.attribute2%type,
619: p_id_attribute3 In Fun_Interface_Dist_Lines.attribute3%type,

Line 616: p_id_description In Fun_Interface_Dist_Lines.description%type,

612: p_h_attribute_category In Fun_Interface_Headers.attribute_category%type,
613: p_id_ccid In Fun_Interface_Dist_Lines.ccid%type,
614: p_id_amount_dr In Fun_Interface_Dist_Lines.amount_dr%type,
615: p_id_amount_cr In Fun_Interface_Dist_Lines.amount_cr%type,
616: p_id_description In Fun_Interface_Dist_Lines.description%type,
617: p_id_attribute1 In Fun_Interface_Dist_Lines.attribute1%type,
618: p_id_attribute2 In Fun_Interface_Dist_Lines.attribute2%type,
619: p_id_attribute3 In Fun_Interface_Dist_Lines.attribute3%type,
620: p_id_attribute4 In Fun_Interface_Dist_Lines.attribute4%type,

Line 617: p_id_attribute1 In Fun_Interface_Dist_Lines.attribute1%type,

613: p_id_ccid In Fun_Interface_Dist_Lines.ccid%type,
614: p_id_amount_dr In Fun_Interface_Dist_Lines.amount_dr%type,
615: p_id_amount_cr In Fun_Interface_Dist_Lines.amount_cr%type,
616: p_id_description In Fun_Interface_Dist_Lines.description%type,
617: p_id_attribute1 In Fun_Interface_Dist_Lines.attribute1%type,
618: p_id_attribute2 In Fun_Interface_Dist_Lines.attribute2%type,
619: p_id_attribute3 In Fun_Interface_Dist_Lines.attribute3%type,
620: p_id_attribute4 In Fun_Interface_Dist_Lines.attribute4%type,
621: p_id_attribute5 In Fun_Interface_Dist_Lines.attribute5%type,

Line 618: p_id_attribute2 In Fun_Interface_Dist_Lines.attribute2%type,

614: p_id_amount_dr In Fun_Interface_Dist_Lines.amount_dr%type,
615: p_id_amount_cr In Fun_Interface_Dist_Lines.amount_cr%type,
616: p_id_description In Fun_Interface_Dist_Lines.description%type,
617: p_id_attribute1 In Fun_Interface_Dist_Lines.attribute1%type,
618: p_id_attribute2 In Fun_Interface_Dist_Lines.attribute2%type,
619: p_id_attribute3 In Fun_Interface_Dist_Lines.attribute3%type,
620: p_id_attribute4 In Fun_Interface_Dist_Lines.attribute4%type,
621: p_id_attribute5 In Fun_Interface_Dist_Lines.attribute5%type,
622: p_id_attribute6 In Fun_Interface_Dist_Lines.attribute6%type,

Line 619: p_id_attribute3 In Fun_Interface_Dist_Lines.attribute3%type,

615: p_id_amount_cr In Fun_Interface_Dist_Lines.amount_cr%type,
616: p_id_description In Fun_Interface_Dist_Lines.description%type,
617: p_id_attribute1 In Fun_Interface_Dist_Lines.attribute1%type,
618: p_id_attribute2 In Fun_Interface_Dist_Lines.attribute2%type,
619: p_id_attribute3 In Fun_Interface_Dist_Lines.attribute3%type,
620: p_id_attribute4 In Fun_Interface_Dist_Lines.attribute4%type,
621: p_id_attribute5 In Fun_Interface_Dist_Lines.attribute5%type,
622: p_id_attribute6 In Fun_Interface_Dist_Lines.attribute6%type,
623: p_id_attribute7 In Fun_Interface_Dist_Lines.attribute7%type,

Line 620: p_id_attribute4 In Fun_Interface_Dist_Lines.attribute4%type,

616: p_id_description In Fun_Interface_Dist_Lines.description%type,
617: p_id_attribute1 In Fun_Interface_Dist_Lines.attribute1%type,
618: p_id_attribute2 In Fun_Interface_Dist_Lines.attribute2%type,
619: p_id_attribute3 In Fun_Interface_Dist_Lines.attribute3%type,
620: p_id_attribute4 In Fun_Interface_Dist_Lines.attribute4%type,
621: p_id_attribute5 In Fun_Interface_Dist_Lines.attribute5%type,
622: p_id_attribute6 In Fun_Interface_Dist_Lines.attribute6%type,
623: p_id_attribute7 In Fun_Interface_Dist_Lines.attribute7%type,
624: p_id_attribute8 In Fun_Interface_Dist_Lines.attribute8%type,

Line 621: p_id_attribute5 In Fun_Interface_Dist_Lines.attribute5%type,

617: p_id_attribute1 In Fun_Interface_Dist_Lines.attribute1%type,
618: p_id_attribute2 In Fun_Interface_Dist_Lines.attribute2%type,
619: p_id_attribute3 In Fun_Interface_Dist_Lines.attribute3%type,
620: p_id_attribute4 In Fun_Interface_Dist_Lines.attribute4%type,
621: p_id_attribute5 In Fun_Interface_Dist_Lines.attribute5%type,
622: p_id_attribute6 In Fun_Interface_Dist_Lines.attribute6%type,
623: p_id_attribute7 In Fun_Interface_Dist_Lines.attribute7%type,
624: p_id_attribute8 In Fun_Interface_Dist_Lines.attribute8%type,
625: p_id_attribute9 In Fun_Interface_Dist_Lines.attribute9%type,

Line 622: p_id_attribute6 In Fun_Interface_Dist_Lines.attribute6%type,

618: p_id_attribute2 In Fun_Interface_Dist_Lines.attribute2%type,
619: p_id_attribute3 In Fun_Interface_Dist_Lines.attribute3%type,
620: p_id_attribute4 In Fun_Interface_Dist_Lines.attribute4%type,
621: p_id_attribute5 In Fun_Interface_Dist_Lines.attribute5%type,
622: p_id_attribute6 In Fun_Interface_Dist_Lines.attribute6%type,
623: p_id_attribute7 In Fun_Interface_Dist_Lines.attribute7%type,
624: p_id_attribute8 In Fun_Interface_Dist_Lines.attribute8%type,
625: p_id_attribute9 In Fun_Interface_Dist_Lines.attribute9%type,
626: p_id_attribute10 In Fun_Interface_Dist_Lines.attribute10%type,

Line 623: p_id_attribute7 In Fun_Interface_Dist_Lines.attribute7%type,

619: p_id_attribute3 In Fun_Interface_Dist_Lines.attribute3%type,
620: p_id_attribute4 In Fun_Interface_Dist_Lines.attribute4%type,
621: p_id_attribute5 In Fun_Interface_Dist_Lines.attribute5%type,
622: p_id_attribute6 In Fun_Interface_Dist_Lines.attribute6%type,
623: p_id_attribute7 In Fun_Interface_Dist_Lines.attribute7%type,
624: p_id_attribute8 In Fun_Interface_Dist_Lines.attribute8%type,
625: p_id_attribute9 In Fun_Interface_Dist_Lines.attribute9%type,
626: p_id_attribute10 In Fun_Interface_Dist_Lines.attribute10%type,
627: p_id_attribute11 In Fun_Interface_Dist_Lines.attribute11%type,

Line 624: p_id_attribute8 In Fun_Interface_Dist_Lines.attribute8%type,

620: p_id_attribute4 In Fun_Interface_Dist_Lines.attribute4%type,
621: p_id_attribute5 In Fun_Interface_Dist_Lines.attribute5%type,
622: p_id_attribute6 In Fun_Interface_Dist_Lines.attribute6%type,
623: p_id_attribute7 In Fun_Interface_Dist_Lines.attribute7%type,
624: p_id_attribute8 In Fun_Interface_Dist_Lines.attribute8%type,
625: p_id_attribute9 In Fun_Interface_Dist_Lines.attribute9%type,
626: p_id_attribute10 In Fun_Interface_Dist_Lines.attribute10%type,
627: p_id_attribute11 In Fun_Interface_Dist_Lines.attribute11%type,
628: p_id_attribute12 In Fun_Interface_Dist_Lines.attribute12%type,

Line 625: p_id_attribute9 In Fun_Interface_Dist_Lines.attribute9%type,

621: p_id_attribute5 In Fun_Interface_Dist_Lines.attribute5%type,
622: p_id_attribute6 In Fun_Interface_Dist_Lines.attribute6%type,
623: p_id_attribute7 In Fun_Interface_Dist_Lines.attribute7%type,
624: p_id_attribute8 In Fun_Interface_Dist_Lines.attribute8%type,
625: p_id_attribute9 In Fun_Interface_Dist_Lines.attribute9%type,
626: p_id_attribute10 In Fun_Interface_Dist_Lines.attribute10%type,
627: p_id_attribute11 In Fun_Interface_Dist_Lines.attribute11%type,
628: p_id_attribute12 In Fun_Interface_Dist_Lines.attribute12%type,
629: p_id_attribute13 In Fun_Interface_Dist_Lines.attribute13%type,

Line 626: p_id_attribute10 In Fun_Interface_Dist_Lines.attribute10%type,

622: p_id_attribute6 In Fun_Interface_Dist_Lines.attribute6%type,
623: p_id_attribute7 In Fun_Interface_Dist_Lines.attribute7%type,
624: p_id_attribute8 In Fun_Interface_Dist_Lines.attribute8%type,
625: p_id_attribute9 In Fun_Interface_Dist_Lines.attribute9%type,
626: p_id_attribute10 In Fun_Interface_Dist_Lines.attribute10%type,
627: p_id_attribute11 In Fun_Interface_Dist_Lines.attribute11%type,
628: p_id_attribute12 In Fun_Interface_Dist_Lines.attribute12%type,
629: p_id_attribute13 In Fun_Interface_Dist_Lines.attribute13%type,
630: p_id_attribute14 In Fun_Interface_Dist_Lines.attribute14%type,

Line 627: p_id_attribute11 In Fun_Interface_Dist_Lines.attribute11%type,

623: p_id_attribute7 In Fun_Interface_Dist_Lines.attribute7%type,
624: p_id_attribute8 In Fun_Interface_Dist_Lines.attribute8%type,
625: p_id_attribute9 In Fun_Interface_Dist_Lines.attribute9%type,
626: p_id_attribute10 In Fun_Interface_Dist_Lines.attribute10%type,
627: p_id_attribute11 In Fun_Interface_Dist_Lines.attribute11%type,
628: p_id_attribute12 In Fun_Interface_Dist_Lines.attribute12%type,
629: p_id_attribute13 In Fun_Interface_Dist_Lines.attribute13%type,
630: p_id_attribute14 In Fun_Interface_Dist_Lines.attribute14%type,
631: p_id_attribute15 In Fun_Interface_Dist_Lines.attribute15%type,

Line 628: p_id_attribute12 In Fun_Interface_Dist_Lines.attribute12%type,

624: p_id_attribute8 In Fun_Interface_Dist_Lines.attribute8%type,
625: p_id_attribute9 In Fun_Interface_Dist_Lines.attribute9%type,
626: p_id_attribute10 In Fun_Interface_Dist_Lines.attribute10%type,
627: p_id_attribute11 In Fun_Interface_Dist_Lines.attribute11%type,
628: p_id_attribute12 In Fun_Interface_Dist_Lines.attribute12%type,
629: p_id_attribute13 In Fun_Interface_Dist_Lines.attribute13%type,
630: p_id_attribute14 In Fun_Interface_Dist_Lines.attribute14%type,
631: p_id_attribute15 In Fun_Interface_Dist_Lines.attribute15%type,
632: p_id_attribute_category In Fun_Interface_Dist_Lines.attribute_category%type,

Line 629: p_id_attribute13 In Fun_Interface_Dist_Lines.attribute13%type,

625: p_id_attribute9 In Fun_Interface_Dist_Lines.attribute9%type,
626: p_id_attribute10 In Fun_Interface_Dist_Lines.attribute10%type,
627: p_id_attribute11 In Fun_Interface_Dist_Lines.attribute11%type,
628: p_id_attribute12 In Fun_Interface_Dist_Lines.attribute12%type,
629: p_id_attribute13 In Fun_Interface_Dist_Lines.attribute13%type,
630: p_id_attribute14 In Fun_Interface_Dist_Lines.attribute14%type,
631: p_id_attribute15 In Fun_Interface_Dist_Lines.attribute15%type,
632: p_id_attribute_category In Fun_Interface_Dist_Lines.attribute_category%type,
633: p_rd_ccid_segments In Varchar2,

Line 630: p_id_attribute14 In Fun_Interface_Dist_Lines.attribute14%type,

626: p_id_attribute10 In Fun_Interface_Dist_Lines.attribute10%type,
627: p_id_attribute11 In Fun_Interface_Dist_Lines.attribute11%type,
628: p_id_attribute12 In Fun_Interface_Dist_Lines.attribute12%type,
629: p_id_attribute13 In Fun_Interface_Dist_Lines.attribute13%type,
630: p_id_attribute14 In Fun_Interface_Dist_Lines.attribute14%type,
631: p_id_attribute15 In Fun_Interface_Dist_Lines.attribute15%type,
632: p_id_attribute_category In Fun_Interface_Dist_Lines.attribute_category%type,
633: p_rd_ccid_segments In Varchar2,
634: p_rd_ccid In Fun_Interface_Dist_Lines.ccid%type,

Line 631: p_id_attribute15 In Fun_Interface_Dist_Lines.attribute15%type,

627: p_id_attribute11 In Fun_Interface_Dist_Lines.attribute11%type,
628: p_id_attribute12 In Fun_Interface_Dist_Lines.attribute12%type,
629: p_id_attribute13 In Fun_Interface_Dist_Lines.attribute13%type,
630: p_id_attribute14 In Fun_Interface_Dist_Lines.attribute14%type,
631: p_id_attribute15 In Fun_Interface_Dist_Lines.attribute15%type,
632: p_id_attribute_category In Fun_Interface_Dist_Lines.attribute_category%type,
633: p_rd_ccid_segments In Varchar2,
634: p_rd_ccid In Fun_Interface_Dist_Lines.ccid%type,
635: p_rd_amount_dr In Fun_Interface_Dist_Lines.amount_dr%type,

Line 632: p_id_attribute_category In Fun_Interface_Dist_Lines.attribute_category%type,

628: p_id_attribute12 In Fun_Interface_Dist_Lines.attribute12%type,
629: p_id_attribute13 In Fun_Interface_Dist_Lines.attribute13%type,
630: p_id_attribute14 In Fun_Interface_Dist_Lines.attribute14%type,
631: p_id_attribute15 In Fun_Interface_Dist_Lines.attribute15%type,
632: p_id_attribute_category In Fun_Interface_Dist_Lines.attribute_category%type,
633: p_rd_ccid_segments In Varchar2,
634: p_rd_ccid In Fun_Interface_Dist_Lines.ccid%type,
635: p_rd_amount_dr In Fun_Interface_Dist_Lines.amount_dr%type,
636: p_rd_amount_cr In Fun_Interface_Dist_Lines.amount_cr%type,

Line 634: p_rd_ccid In Fun_Interface_Dist_Lines.ccid%type,

630: p_id_attribute14 In Fun_Interface_Dist_Lines.attribute14%type,
631: p_id_attribute15 In Fun_Interface_Dist_Lines.attribute15%type,
632: p_id_attribute_category In Fun_Interface_Dist_Lines.attribute_category%type,
633: p_rd_ccid_segments In Varchar2,
634: p_rd_ccid In Fun_Interface_Dist_Lines.ccid%type,
635: p_rd_amount_dr In Fun_Interface_Dist_Lines.amount_dr%type,
636: p_rd_amount_cr In Fun_Interface_Dist_Lines.amount_cr%type,
637: p_rd_description In Fun_Interface_Dist_Lines.description%type,
638: p_dist_number In Fun_Interface_Dist_Lines.dist_number%type) Is

Line 635: p_rd_amount_dr In Fun_Interface_Dist_Lines.amount_dr%type,

631: p_id_attribute15 In Fun_Interface_Dist_Lines.attribute15%type,
632: p_id_attribute_category In Fun_Interface_Dist_Lines.attribute_category%type,
633: p_rd_ccid_segments In Varchar2,
634: p_rd_ccid In Fun_Interface_Dist_Lines.ccid%type,
635: p_rd_amount_dr In Fun_Interface_Dist_Lines.amount_dr%type,
636: p_rd_amount_cr In Fun_Interface_Dist_Lines.amount_cr%type,
637: p_rd_description In Fun_Interface_Dist_Lines.description%type,
638: p_dist_number In Fun_Interface_Dist_Lines.dist_number%type) Is
639:

Line 636: p_rd_amount_cr In Fun_Interface_Dist_Lines.amount_cr%type,

632: p_id_attribute_category In Fun_Interface_Dist_Lines.attribute_category%type,
633: p_rd_ccid_segments In Varchar2,
634: p_rd_ccid In Fun_Interface_Dist_Lines.ccid%type,
635: p_rd_amount_dr In Fun_Interface_Dist_Lines.amount_dr%type,
636: p_rd_amount_cr In Fun_Interface_Dist_Lines.amount_cr%type,
637: p_rd_description In Fun_Interface_Dist_Lines.description%type,
638: p_dist_number In Fun_Interface_Dist_Lines.dist_number%type) Is
639:
640: Cursor C_Batch_Exists(cp_batch_number In Fun_Interface_Batches.batch_number%type) Is

Line 637: p_rd_description In Fun_Interface_Dist_Lines.description%type,

633: p_rd_ccid_segments In Varchar2,
634: p_rd_ccid In Fun_Interface_Dist_Lines.ccid%type,
635: p_rd_amount_dr In Fun_Interface_Dist_Lines.amount_dr%type,
636: p_rd_amount_cr In Fun_Interface_Dist_Lines.amount_cr%type,
637: p_rd_description In Fun_Interface_Dist_Lines.description%type,
638: p_dist_number In Fun_Interface_Dist_Lines.dist_number%type) Is
639:
640: Cursor C_Batch_Exists(cp_batch_number In Fun_Interface_Batches.batch_number%type) Is
641: Select *

Line 638: p_dist_number In Fun_Interface_Dist_Lines.dist_number%type) Is

634: p_rd_ccid In Fun_Interface_Dist_Lines.ccid%type,
635: p_rd_amount_dr In Fun_Interface_Dist_Lines.amount_dr%type,
636: p_rd_amount_cr In Fun_Interface_Dist_Lines.amount_cr%type,
637: p_rd_description In Fun_Interface_Dist_Lines.description%type,
638: p_dist_number In Fun_Interface_Dist_Lines.dist_number%type) Is
639:
640: Cursor C_Batch_Exists(cp_batch_number In Fun_Interface_Batches.batch_number%type) Is
641: Select *
642: From Fun_Interface_Batches

Line 699: cp_trx_id In Fun_Interface_Dist_Lines.trx_id%type,

695: And trx_number <> cp_trx_number
696: And recipient_name = cp_party_name;
697:
698: Cursor C_Dist_Lines_Exists(
699: cp_trx_id In Fun_Interface_Dist_Lines.trx_id%type,
700: cp_party_id In Fun_Interface_Dist_Lines.party_id%type,
701: cp_ccid In Fun_Interface_Dist_Lines.ccid%type,
702: cp_party_type_flag In Fun_Interface_Dist_Lines.party_type_flag%type,
703: cp_dist_number in Fun_Interface_Dist_Lines.dist_number%type) Is

Line 700: cp_party_id In Fun_Interface_Dist_Lines.party_id%type,

696: And recipient_name = cp_party_name;
697:
698: Cursor C_Dist_Lines_Exists(
699: cp_trx_id In Fun_Interface_Dist_Lines.trx_id%type,
700: cp_party_id In Fun_Interface_Dist_Lines.party_id%type,
701: cp_ccid In Fun_Interface_Dist_Lines.ccid%type,
702: cp_party_type_flag In Fun_Interface_Dist_Lines.party_type_flag%type,
703: cp_dist_number in Fun_Interface_Dist_Lines.dist_number%type) Is
704: Select *

Line 701: cp_ccid In Fun_Interface_Dist_Lines.ccid%type,

697:
698: Cursor C_Dist_Lines_Exists(
699: cp_trx_id In Fun_Interface_Dist_Lines.trx_id%type,
700: cp_party_id In Fun_Interface_Dist_Lines.party_id%type,
701: cp_ccid In Fun_Interface_Dist_Lines.ccid%type,
702: cp_party_type_flag In Fun_Interface_Dist_Lines.party_type_flag%type,
703: cp_dist_number in Fun_Interface_Dist_Lines.dist_number%type) Is
704: Select *
705: From Fun_Interface_Dist_Lines

Line 702: cp_party_type_flag In Fun_Interface_Dist_Lines.party_type_flag%type,

698: Cursor C_Dist_Lines_Exists(
699: cp_trx_id In Fun_Interface_Dist_Lines.trx_id%type,
700: cp_party_id In Fun_Interface_Dist_Lines.party_id%type,
701: cp_ccid In Fun_Interface_Dist_Lines.ccid%type,
702: cp_party_type_flag In Fun_Interface_Dist_Lines.party_type_flag%type,
703: cp_dist_number in Fun_Interface_Dist_Lines.dist_number%type) Is
704: Select *
705: From Fun_Interface_Dist_Lines
706: Where trx_id = cp_trx_id

Line 703: cp_dist_number in Fun_Interface_Dist_Lines.dist_number%type) Is

699: cp_trx_id In Fun_Interface_Dist_Lines.trx_id%type,
700: cp_party_id In Fun_Interface_Dist_Lines.party_id%type,
701: cp_ccid In Fun_Interface_Dist_Lines.ccid%type,
702: cp_party_type_flag In Fun_Interface_Dist_Lines.party_type_flag%type,
703: cp_dist_number in Fun_Interface_Dist_Lines.dist_number%type) Is
704: Select *
705: From Fun_Interface_Dist_Lines
706: Where trx_id = cp_trx_id
707: And party_id = cp_party_id

Line 705: From Fun_Interface_Dist_Lines

701: cp_ccid In Fun_Interface_Dist_Lines.ccid%type,
702: cp_party_type_flag In Fun_Interface_Dist_Lines.party_type_flag%type,
703: cp_dist_number in Fun_Interface_Dist_Lines.dist_number%type) Is
704: Select *
705: From Fun_Interface_Dist_Lines
706: Where trx_id = cp_trx_id
707: And party_id = cp_party_id
708: And ccid = cp_ccid
709: And party_type_flag = cp_party_type_flag

Line 734: cp_trx_id In Fun_Interface_Dist_Lines.trx_id%type,

730: And id_flex_num = cp_chart_of_accounts_id
731: And id_flex_code = 'GL#';
732:
733: Cursor C_Sum_Dist(
734: cp_trx_id In Fun_Interface_Dist_Lines.trx_id%type,
735: cp_party_id In Fun_Interface_Dist_Lines.party_id%type,
736: cp_party_type_flag In Fun_Interface_Dist_Lines.party_type_flag%type) Is
737: Select nvl(Sum(nvl(amount_dr,0)),0) Dr_Sum,
738: nvl(Sum(nvl(amount_cr,0)),0) Cr_Sum

Line 735: cp_party_id In Fun_Interface_Dist_Lines.party_id%type,

731: And id_flex_code = 'GL#';
732:
733: Cursor C_Sum_Dist(
734: cp_trx_id In Fun_Interface_Dist_Lines.trx_id%type,
735: cp_party_id In Fun_Interface_Dist_Lines.party_id%type,
736: cp_party_type_flag In Fun_Interface_Dist_Lines.party_type_flag%type) Is
737: Select nvl(Sum(nvl(amount_dr,0)),0) Dr_Sum,
738: nvl(Sum(nvl(amount_cr,0)),0) Cr_Sum
739: From Fun_Interface_Dist_Lines

Line 736: cp_party_type_flag In Fun_Interface_Dist_Lines.party_type_flag%type) Is

732:
733: Cursor C_Sum_Dist(
734: cp_trx_id In Fun_Interface_Dist_Lines.trx_id%type,
735: cp_party_id In Fun_Interface_Dist_Lines.party_id%type,
736: cp_party_type_flag In Fun_Interface_Dist_Lines.party_type_flag%type) Is
737: Select nvl(Sum(nvl(amount_dr,0)),0) Dr_Sum,
738: nvl(Sum(nvl(amount_cr,0)),0) Cr_Sum
739: From Fun_Interface_Dist_Lines
740: Where trx_id = cp_trx_id

Line 739: From Fun_Interface_Dist_Lines

735: cp_party_id In Fun_Interface_Dist_Lines.party_id%type,
736: cp_party_type_flag In Fun_Interface_Dist_Lines.party_type_flag%type) Is
737: Select nvl(Sum(nvl(amount_dr,0)),0) Dr_Sum,
738: nvl(Sum(nvl(amount_cr,0)),0) Cr_Sum
739: From Fun_Interface_Dist_Lines
740: Where trx_id = cp_trx_id
741: And party_id = cp_party_id
742: And party_type_flag = cp_party_type_flag;
743:

Line 758: l_dr_sum Fun_Interface_Dist_Lines.amount_dr%type;

754: l_reci_chart_of_accounts Fnd_Id_Flex_Structures.id_flex_num%type;
755: l_appl_short_name Fnd_Application.application_short_name%type;
756: l_reci_dist_line_insert Varchar2(1);
757: l_data varchar2(2000);
758: l_dr_sum Fun_Interface_Dist_Lines.amount_dr%type;
759: l_cr_sum Fun_Interface_Dist_Lines.amount_cr%type;
760: l_trx_id Fun_trx_headers.trx_id%type;
761: l_recipient_id Fun_trx_headers.recipient_id%type;
762: l_init_amount_cr Fun_Interface_Headers.init_amount_cr%type;

Line 759: l_cr_sum Fun_Interface_Dist_Lines.amount_cr%type;

755: l_appl_short_name Fnd_Application.application_short_name%type;
756: l_reci_dist_line_insert Varchar2(1);
757: l_data varchar2(2000);
758: l_dr_sum Fun_Interface_Dist_Lines.amount_dr%type;
759: l_cr_sum Fun_Interface_Dist_Lines.amount_cr%type;
760: l_trx_id Fun_trx_headers.trx_id%type;
761: l_recipient_id Fun_trx_headers.recipient_id%type;
762: l_init_amount_cr Fun_Interface_Headers.init_amount_cr%type;
763: l_init_amount_dr Fun_Interface_Headers.init_amount_dr%type;

Line 1418: DELETE Fun_Interface_Dist_Lines

1414:
1415:
1416: BEGIN
1417:
1418: DELETE Fun_Interface_Dist_Lines
1419: WHERE trx_id in (SELECT trx_id
1420: FROM Fun_Interface_Headers fih,
1421: fun_interface_batches fib
1422: WHERE fih.batch_id = fib.batch_id

Line 1464: FROM fun_interface_headers trxH, FUN_INTERFACE_DIST_LINES fd

1460: (SELECT trxH.trx_id,
1461: fd.dist_type_flag,
1462: party_type_flag ,
1463: sum(decode(fd.amount_cr, null, fd.amount_dr, fd.amount_cr)) DIST_AMOUNT
1464: FROM fun_interface_headers trxH, FUN_INTERFACE_DIST_LINES fd
1465: WHERE trxH.trx_id = fd.trx_id
1466: AND dist_type_flag = 'L'
1467: GROUP BY trxH.trx_id,
1468: fd.dist_type_flag,