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.ECE_AR_TRANSACTION dependencies on ECE_EXTRACT_UTILS_PUB

Line 3451: -- The ece_extract_utils_pub.select_clause uses the EDI data dictionary for the build.

3447: -- ***************************************************************************
3448: --
3449: -- Here, I am building the SELECT, FROM, and WHERE clauses for the dynamic
3450: -- SQL call
3451: -- The ece_extract_utils_pub.select_clause uses the EDI data dictionary for the build.
3452: --
3453: -- **************************************************************************
3454:
3455: xProgress := '2160-70';

Line 3456: ece_extract_utils_pub.select_clause ( cTransaction_Type,

3452: --
3453: -- **************************************************************************
3454:
3455: xProgress := '2160-70';
3456: ece_extract_utils_pub.select_clause ( cTransaction_Type,
3457: cCommunication_Method,
3458: cHeader_Interface,
3459: l_header_tbl,
3460: cHeader_select,

Line 3465: ece_extract_utils_pub.select_clause ( cTransaction_Type,

3461: cHeader_from,
3462: cHeader_where );
3463:
3464: xProgress := '2170-70';
3465: ece_extract_utils_pub.select_clause ( cTransaction_Type,
3466: cCommunication_Method,
3467: cHeader_1_Interface,
3468: l_header_1_tbl,
3469: cHeader_1_select,

Line 3474: ece_extract_utils_pub.select_clause ( cTransaction_Type,

3470: cHeader_1_from,
3471: cHeader_1_where );
3472:
3473: xProgress := '2180-70';
3474: ece_extract_utils_pub.select_clause ( cTransaction_Type,
3475: cCommunication_Method,
3476: cAlw_chg_Interface,
3477: l_alw_chg_tbl,
3478: cAlw_chg_select,

Line 3483: ece_extract_utils_pub.select_clause ( cTransaction_Type,

3479: cAlw_chg_from,
3480: cAlw_chg_where );
3481:
3482: xProgress := '2190-70';
3483: ece_extract_utils_pub.select_clause ( cTransaction_Type,
3484: cCommunication_Method,
3485: cLine_Interface,
3486: l_line_tbl,
3487: cLine_select,

Line 3492: ece_extract_utils_pub.select_clause ( cTransaction_Type,

3488: cLine_from ,
3489: cLine_where );
3490:
3491: xProgress := '2200-70';
3492: ece_extract_utils_pub.select_clause ( cTransaction_Type,
3493: cCommunication_Method,
3494: cLine_t_Interface,
3495: l_line_t_tbl,
3496: cLine_t_select,

Line 3808: ece_extract_utils_PUB.G_MaxColWidth,

3804:
3805: xProgress := '2380-70';
3806: define_interface_column ( Header_sel_c,
3807: cHeader_select,
3808: ece_extract_utils_PUB.G_MaxColWidth,
3809: l_header_tbl );
3810:
3811: xProgress := '2382-70';
3812: define_interface_column ( Header_1_sel_c,

Line 3814: ece_extract_utils_PUB.G_MaxColWidth,

3810:
3811: xProgress := '2382-70';
3812: define_interface_column ( Header_1_sel_c,
3813: cHeader_1_select,
3814: ece_extract_utils_PUB.G_MaxColWidth,
3815: l_header_1_tbl );
3816:
3817: xProgress := '2384-70';
3818: define_interface_column ( Alw_chg_sel_c,

Line 3820: ece_extract_utils_PUB.G_MaxColWidth,

3816:
3817: xProgress := '2384-70';
3818: define_interface_column ( Alw_chg_sel_c,
3819: cAlw_chg_select,
3820: ece_extract_utils_PUB.G_MaxColWidth,
3821: l_alw_chg_tbl );
3822:
3823: xProgress := '2386-70';
3824: define_interface_column ( Line_sel_c,

Line 3826: ece_extract_utils_PUB.G_MaxColWidth,

3822:
3823: xProgress := '2386-70';
3824: define_interface_column ( Line_sel_c,
3825: cLine_select,
3826: ece_extract_utils_PUB.G_MaxColWidth,
3827: l_line_tbl );
3828: xProgress := '2388-70';
3829: define_interface_column ( Line_t_sel_c,
3830: cLine_t_select,

Line 3831: ece_extract_utils_PUB.G_MaxColWidth,

3827: l_line_tbl );
3828: xProgress := '2388-70';
3829: define_interface_column ( Line_t_sel_c,
3830: cLine_t_select,
3831: ece_extract_utils_PUB.G_MaxColWidth,
3832: l_line_t_tbl );
3833: -- Bind Variables
3834: xProgress := '2388-70';
3835: IF cCreate_Date_From IS NOT NULL

Line 3933: ece_extract_utils_pub.Find_pos ( l_header_tbl,

3929: l_key_tbl(i).value );
3930: END LOOP;
3931:
3932: xProgress := '2420-70';
3933: ece_extract_utils_pub.Find_pos ( l_header_tbl,
3934: 'TRANSACTION_ID',
3935: nPos1 );
3936: ec_debug.pl ( 3, 'nPos1: ',nPos1 );
3937:

Line 3939: ece_extract_utils_pub.Find_pos ( l_header_tbl,

3935: nPos1 );
3936: ec_debug.pl ( 3, 'nPos1: ',nPos1 );
3937:
3938: xProgress := '2422-70';
3939: ece_extract_utils_pub.Find_pos ( l_header_tbl,
3940: 'INSTALLMENT_NUMBER',
3941: nPos2 );
3942: ec_debug.pl ( 3, 'nPos2: ',nPos2 );
3943:

Line 3945: ece_extract_utils_pub.Find_pos ( l_header_tbl,

3941: nPos2 );
3942: ec_debug.pl ( 3, 'nPos2: ',nPos2 );
3943:
3944: xProgress := '2424-70';
3945: ece_extract_utils_pub.Find_pos ( l_header_tbl,
3946: 'DOCUMENT_TYPE',
3947: nPos3 );
3948: ec_debug.pl ( 3, 'nPos3: ',nPos3 );
3949:

Line 3951: ece_extract_utils_pub.Find_pos ( l_header_tbl ,

3947: nPos3 );
3948: ec_debug.pl ( 3, 'nPos3: ',nPos3 );
3949:
3950: xProgress := '2426-70';
3951: ece_extract_utils_pub.Find_pos ( l_header_tbl ,
3952: 'PAYMENT_TERM_ID',
3953: nPos4 );
3954: ec_debug.pl ( 3, 'nPos4: ',nPos4 );
3955:

Line 3957: ece_extract_utils_pub.Find_pos ( l_header_tbl ,

3953: nPos4 );
3954: ec_debug.pl ( 3, 'nPos4: ',nPos4 );
3955:
3956: xProgress := '2428-70';
3957: ece_extract_utils_pub.Find_pos ( l_header_tbl ,
3958: 'SHIP_TO_ADDRESS_ID',
3959: nPos5 );
3960: ec_debug.pl ( 3, 'nPos5: ',nPos5 );
3961:

Line 3963: ece_extract_utils_pub.Find_pos ( l_header_tbl ,

3959: nPos5 );
3960: ec_debug.pl ( 3, 'nPos5: ',nPos5 );
3961:
3962: xProgress := '2430-70';
3963: ece_extract_utils_pub.Find_pos ( l_header_tbl ,
3964: 'SOLD_TO_ADDRESS_ID',
3965: nPos6 );
3966: ec_debug.pl ( 3, 'nPos6: ',nPos6 );
3967:

Line 3969: ece_extract_utils_pub.Find_pos ( l_header_tbl ,

3965: nPos6 );
3966: ec_debug.pl ( 3, 'nPos6: ',nPos6 );
3967:
3968: xProgress := '2431-70';
3969: ece_extract_utils_pub.Find_pos ( l_header_tbl ,
3970: 'BILL_TO_ADDRESS_ID',
3971: nPos8 );
3972: ec_debug.pl ( 3, 'nPos8: ',nPos8 );
3973:

Line 3975: ece_extract_utils_pub.Find_pos ( l_header_tbl ,

3971: nPos8 );
3972: ec_debug.pl ( 3, 'nPos8: ',nPos8 );
3973:
3974: xProgress := '2432-70';
3975: ece_extract_utils_pub.Find_pos ( l_header_tbl ,
3976: 'TP_LOCATION_CODE_EXT',
3977: nPos7 );
3978: ec_debug.pl ( 3, 'nPos7: ',nPos7 );
3979:

Line 3981: ece_extract_utils_pub.Find_pos ( l_header_tbl ,

3977: nPos7 );
3978: ec_debug.pl ( 3, 'nPos7: ',nPos7 );
3979:
3980: xProgress := '2434-70';
3981: ece_extract_utils_pub.Find_pos ( l_header_tbl ,
3982: 'REMIT_TO_ADDRESS1',
3983: nPos10 );
3984: ec_debug.pl ( 3, 'nPos10: ',nPos10 );
3985:

Line 3987: ece_extract_utils_pub.Find_pos ( l_header_tbl ,

3983: nPos10 );
3984: ec_debug.pl ( 3, 'nPos10: ',nPos10 );
3985:
3986: xProgress := '2436-70';
3987: ece_extract_utils_pub.Find_pos ( l_header_tbl ,
3988: 'REMIT_TO_ADDRESS2',
3989: nPos11 );
3990: ec_debug.pl ( 3, 'nPos11: ',nPos11 );
3991:

Line 3993: ece_extract_utils_pub.Find_pos ( l_header_tbl ,

3989: nPos11 );
3990: ec_debug.pl ( 3, 'nPos11: ',nPos11 );
3991:
3992: xProgress := '2438-70';
3993: ece_extract_utils_pub.Find_pos ( l_header_tbl ,
3994: 'REMIT_TO_ADDRESS3',
3995: nPos12 );
3996: ec_debug.pl ( 3, 'nPos12: ',nPos12 );
3997:

Line 3999: ece_extract_utils_pub.Find_pos ( l_header_tbl ,

3995: nPos12 );
3996: ec_debug.pl ( 3, 'nPos12: ',nPos12 );
3997:
3998: xProgress := '2440-70';
3999: ece_extract_utils_pub.Find_pos ( l_header_tbl ,
4000: 'REMIT_TO_ADDRESS4',
4001: nPos13 );
4002: ec_debug.pl ( 3, 'nPos13: ',nPos13 );
4003:

Line 4005: ece_extract_utils_pub.Find_pos ( l_header_tbl ,

4001: nPos13 );
4002: ec_debug.pl ( 3, 'nPos13: ',nPos13 );
4003:
4004: xProgress := '2442-70';
4005: ece_extract_utils_pub.Find_pos ( l_header_tbl ,
4006: 'REMIT_TO_CITY',
4007: nPos14 );
4008: ec_debug.pl ( 3, 'nPos14: ',nPos14 );
4009:

Line 4011: ece_extract_utils_pub.Find_pos ( l_header_tbl ,

4007: nPos14 );
4008: ec_debug.pl ( 3, 'nPos14: ',nPos14 );
4009:
4010: xProgress := '2444-70';
4011: ece_extract_utils_pub.Find_pos ( l_header_tbl ,
4012: 'REMIT_TO_COUNTY',
4013: nPos15 );
4014: ec_debug.pl ( 3, 'nPos15: ',nPos15 );
4015:

Line 4017: ece_extract_utils_pub.Find_pos ( l_header_tbl ,

4013: nPos15 );
4014: ec_debug.pl ( 3, 'nPos15: ',nPos15 );
4015:
4016: xProgress := '2446-70';
4017: ece_extract_utils_pub.Find_pos ( l_header_tbl ,
4018: 'REMIT_TO_STATE',
4019: nPos16 );
4020: ec_debug.pl ( 3, 'nPos16: ',nPos16 );
4021:

Line 4023: ece_extract_utils_pub.Find_pos ( l_header_tbl ,

4019: nPos16 );
4020: ec_debug.pl ( 3, 'nPos16: ',nPos16 );
4021:
4022: xProgress := '2448-70';
4023: ece_extract_utils_pub.Find_pos ( l_header_tbl ,
4024: 'REMIT_TO_PROVINCE',
4025: nPos17 );
4026: ec_debug.pl ( 3, 'nPos17: ',nPos17 );
4027:

Line 4029: ece_extract_utils_pub.Find_pos ( l_header_tbl ,

4025: nPos17 );
4026: ec_debug.pl ( 3, 'nPos17: ',nPos17 );
4027:
4028: xProgress := '2450-70';
4029: ece_extract_utils_pub.Find_pos ( l_header_tbl ,
4030: 'REMIT_TO_COUNTRY',
4031: nPos18 );
4032: ec_debug.pl ( 3, 'nPos18: ',nPos18 );
4033:

Line 4035: ece_extract_utils_pub.Find_pos ( l_header_tbl ,

4031: nPos18 );
4032: ec_debug.pl ( 3, 'nPos18: ',nPos18 );
4033:
4034: xProgress := '2452-70';
4035: ece_extract_utils_pub.Find_pos ( l_header_tbl ,
4036: 'REMIT_TO_POSTAL_CODE',
4037: nPos19 );
4038: ec_debug.pl ( 3, 'nPos19: ',nPos19 );
4039:

Line 4041: ece_extract_utils_pub.Find_pos ( l_header_tbl ,

4037: nPos19 );
4038: ec_debug.pl ( 3, 'nPos19: ',nPos19 );
4039:
4040: xProgress := '2452-71'; --Bug 2389231
4041: ece_extract_utils_pub.Find_pos ( l_header_tbl ,
4042: 'INV_TRANSACTION_DATE',
4043: nPos28 );
4044: ec_debug.pl ( 3, 'nPos28: ',nPos28 );
4045: ec_debug.pl(3, 'l_header_tbl(nPos28).value',l_header_tbl(nPos28).value);

Line 4054: ece_extract_utils_pub.Find_pos ( l_header_tbl,

4050: --
4051: -- ***************************************************
4052:
4053: xProgress := '2460-70';
4054: ece_extract_utils_pub.Find_pos ( l_header_tbl,
4055: ece_flatfile_pvt.G_Transaction_date,
4056: n_trx_date_pos );
4057:
4058: xProgress := '2470-70';

Line 4382: ece_Extract_Utils_PUB.insert_into_interface_tbl ( iRun_id,

4378: 'ECE_AR_TRX_HEADERS_S' );
4379: END;
4380:
4381: xProgress := '2580-70';
4382: ece_Extract_Utils_PUB.insert_into_interface_tbl ( iRun_id,
4383: cTransaction_Type,
4384: cCommunication_Method,
4385: cHeader_Interface,
4386: l_header_tbl,

Line 4537: ece_extract_utils_pub.Find_pos ( l_header_1_tbl,

4533: -- pass the pl/sql table in for xref
4534: -- ***************************************************
4535:
4536: xProgress := '2650-70';
4537: ece_extract_utils_pub.Find_pos ( l_header_1_tbl,
4538: 'PACKING_SLIP_NUMBER',
4539: nPos4 );
4540: ec_debug.pl ( 3, 'nPos4: ',nPos4 );
4541: xProgress := '2660-70';

Line 4542: ece_extract_utils_pub.Find_pos ( l_header_1_tbl,

4538: 'PACKING_SLIP_NUMBER',
4539: nPos4 );
4540: ec_debug.pl ( 3, 'nPos4: ',nPos4 );
4541: xProgress := '2660-70';
4542: ece_extract_utils_pub.Find_pos ( l_header_1_tbl,
4543: 'SHIP_FROM_CODE_INT',
4544: nPos5 );
4545: ec_debug.pl ( 3, 'nPos5: ',nPos5 );
4546:

Line 4548: ece_extract_utils_pub.Find_pos ( l_header_1_tbl,

4544: nPos5 );
4545: ec_debug.pl ( 3, 'nPos5: ',nPos5 );
4546:
4547: xProgress := '2664-70';
4548: ece_extract_utils_pub.Find_pos ( l_header_1_tbl,
4549: 'INTERFACE_ATTRIBUTE3',
4550: pos_1 );
4551: ec_debug.pl ( 3, 'pos_1: ',pos_1 );
4552:

Line 4554: ece_extract_utils_pub.Find_pos ( l_header_1_tbl,

4550: pos_1 );
4551: ec_debug.pl ( 3, 'pos_1: ',pos_1 );
4552:
4553: xProgress := '2665-70';
4554: ece_extract_utils_pub.Find_pos ( l_header_1_tbl,
4555: 'EQUIPMENT_PREFIX',
4556: nPos8);
4557:
4558: xProgress := '2666-70';

Line 4559: ece_extract_utils_pub.Find_pos ( l_header_1_tbl,

4555: 'EQUIPMENT_PREFIX',
4556: nPos8);
4557:
4558: xProgress := '2666-70';
4559: ece_extract_utils_pub.Find_pos ( l_header_1_tbl,
4560: 'EQUIPMENT_NUMBER',
4561: nPos9);
4562: xProgress := '2667-70';
4563: ece_extract_utils_pub.Find_pos ( l_header_1_tbl,

Line 4563: ece_extract_utils_pub.Find_pos ( l_header_1_tbl,

4559: ece_extract_utils_pub.Find_pos ( l_header_1_tbl,
4560: 'EQUIPMENT_NUMBER',
4561: nPos9);
4562: xProgress := '2667-70';
4563: ece_extract_utils_pub.Find_pos ( l_header_1_tbl,
4564: 'ROUTING_INSTRUCTIONS',
4565: nPos10);
4566:
4567: xProgress := '2667-72';

Line 4568: ece_extract_utils_pub.Find_pos ( l_header_1_tbl,

4564: 'ROUTING_INSTRUCTIONS',
4565: nPos10);
4566:
4567: xProgress := '2667-72';
4568: ece_extract_utils_pub.Find_pos ( l_header_1_tbl,
4569: 'TRANSACTION_ID',
4570: nPos12);
4571:
4572: BEGIN

Line 4643: ece_Extract_Utils_PUB.insert_into_interface_tbl ( iRun_id,

4639: END;
4640: ec_debug.pl ( 3, 'l_header_1_fkey: ',l_header_1_fkey );
4641:
4642: xProgress := '2700-70';
4643: ece_Extract_Utils_PUB.insert_into_interface_tbl ( iRun_id,
4644: cTransaction_Type,
4645: cCommunication_Method,
4646: cHeader_1_Interface,
4647: l_header_1_tbl,

Line 4746: ece_extract_utils_pub.Find_pos ( l_alw_chg_tbl,

4742: -- pass the pl/sql table in for xref
4743: -- ***************************************************
4744:
4745: xProgress := '2760-70';
4746: ece_extract_utils_pub.Find_pos ( l_alw_chg_tbl,
4747: 'TRANSACTION_ID',
4748: nPos1 );
4749: ec_debug.pl ( 3, 'nPos1: ',nPos1 );
4750:

Line 4752: ece_extract_utils_pub.Find_pos ( l_alw_chg_tbl,

4748: nPos1 );
4749: ec_debug.pl ( 3, 'nPos1: ',nPos1 );
4750:
4751: xProgress := '2761-70';
4752: ece_extract_utils_pub.Find_pos ( l_alw_chg_tbl,
4753: 'CUSTOMER_TRX_LINE_ID',
4754: nPos2 );
4755: ec_debug.pl ( 3, 'nPos2: ',nPos2 );
4756:

Line 4758: ece_extract_utils_pub.Find_pos ( l_alw_chg_tbl,

4754: nPos2 );
4755: ec_debug.pl ( 3, 'nPos2: ',nPos2 );
4756:
4757: xProgress := '2762-70';
4758: ece_extract_utils_pub.Find_pos ( l_alw_chg_tbl,
4759: 'LINK_TO_CUST_TRX_LINE_ID',
4760: nPos3 );
4761: ec_debug.pl ( 3, 'nPos3: ',nPos3 );
4762:

Line 4764: ece_extract_utils_pub.Find_pos ( l_alw_chg_tbl,

4760: nPos3 );
4761: ec_debug.pl ( 3, 'nPos3: ',nPos3 );
4762:
4763: xProgress := '2763-70';
4764: ece_extract_utils_pub.Find_pos ( l_alw_chg_tbl,
4765: 'LINE_NUMBER',
4766: nPos5 );
4767: ec_debug.pl ( 3, 'nPos5: ',nPos5 );
4768:

Line 4770: ece_extract_utils_pub.Find_pos ( l_alw_chg_tbl,

4766: nPos5 );
4767: ec_debug.pl ( 3, 'nPos5: ',nPos5 );
4768:
4769: xProgress := '2764-70';
4770: ece_extract_utils_pub.Find_pos ( l_alw_chg_tbl,
4771: 'ALLOWANCE_CHARGE_INDICATOR',
4772: nPos6 );
4773: ec_debug.pl ( 3, 'nPos6: ',nPos6 );
4774:

Line 4776: ece_extract_utils_pub.Find_pos ( l_alw_chg_tbl,

4772: nPos6 );
4773: ec_debug.pl ( 3, 'nPos6: ',nPos6 );
4774:
4775: xProgress := '2765-70';
4776: ece_extract_utils_pub.Find_pos ( l_alw_chg_tbl,
4777: 'ALLOWANCE_CHARGE_AMOUNT',
4778: nPos7 );
4779: ec_debug.pl ( 3, 'nPos7: ',nPos7 );
4780:

Line 4782: ece_extract_utils_pub.Find_pos ( l_alw_chg_tbl,

4778: nPos7 );
4779: ec_debug.pl ( 3, 'nPos7: ',nPos7 );
4780:
4781: xProgress := '2766-70';
4782: ece_extract_utils_pub.Find_pos ( l_alw_chg_tbl,
4783: 'SPECIAL_SERVICES_CODE',
4784: nPos8 );
4785: ec_debug.pl ( 3, 'nPos8: ',nPos8 );
4786:

Line 4788: ece_extract_utils_pub.Find_pos ( l_alw_chg_tbl,

4784: nPos8 );
4785: ec_debug.pl ( 3, 'nPos8: ',nPos8 );
4786:
4787: xProgress := '2767-70';
4788: ece_extract_utils_pub.Find_pos ( l_alw_chg_tbl,
4789: 'METHOD_HANDLING_CODE',
4790: nPos9 );
4791: ec_debug.pl ( 3, 'nPos9: ',nPos9 );
4792:

Line 4794: ece_extract_utils_pub.Find_pos ( l_alw_chg_tbl,

4790: nPos9 );
4791: ec_debug.pl ( 3, 'nPos9: ',nPos9 );
4792:
4793: xProgress := '2768-70';
4794: ece_extract_utils_pub.Find_pos ( l_alw_chg_tbl,
4795: 'SPECIAL_CHARGES_CODE',
4796: nPos10 );
4797: ec_debug.pl ( 3, 'nPos10: ',nPos10 );
4798:

Line 4800: ece_extract_utils_pub.Find_pos ( l_alw_chg_tbl,

4796: nPos10 );
4797: ec_debug.pl ( 3, 'nPos10: ',nPos10 );
4798:
4799: xProgress := '2769-70';
4800: ece_extract_utils_pub.Find_pos ( l_alw_chg_tbl,
4801: 'ALLOWANCE_CHARGE_DESC',
4802: nPos11 );
4803: ec_debug.pl ( 3, 'nPos11: ',nPos11 );
4804:

Line 4806: ece_extract_utils_pub.Find_pos ( l_alw_chg_tbl,

4802: nPos11 );
4803: ec_debug.pl ( 3, 'nPos11: ',nPos11 );
4804:
4805: xProgress := '2770-70';
4806: ece_extract_utils_pub.Find_pos ( l_alw_chg_tbl,
4807: 'AGENCY_QUALIFIER_CODE',
4808: nPos12 );
4809: ec_debug.pl ( 3, 'nPos12: ',nPos12 );
4810:

Line 4812: ece_extract_utils_pub.Find_pos ( l_alw_chg_tbl,

4808: nPos12 );
4809: ec_debug.pl ( 3, 'nPos12: ',nPos12 );
4810:
4811: xProgress := '2771-70';
4812: ece_extract_utils_pub.Find_pos ( l_alw_chg_tbl,
4813: 'ALLOWANCE_CHARGE_RATE',
4814: nPos13 );
4815: ec_debug.pl ( 3, 'nPos13: ',nPos13 );
4816:

Line 4818: ece_extract_utils_pub.Find_pos ( l_alw_chg_tbl,

4814: nPos13 );
4815: ec_debug.pl ( 3, 'nPos13: ',nPos13 );
4816:
4817: xProgress := '2772-70';
4818: ece_extract_utils_pub.Find_pos ( l_alw_chg_tbl,
4819: 'ALLOWANCE_CHARGE_PCT_QUALIFIER',
4820: nPos14 );
4821: ec_debug.pl ( 3, 'nPos14: ',nPos14 );
4822:

Line 4824: ece_extract_utils_pub.Find_pos ( l_alw_chg_tbl,

4820: nPos14 );
4821: ec_debug.pl ( 3, 'nPos14: ',nPos14 );
4822:
4823: xProgress := '2773-70';
4824: ece_extract_utils_pub.Find_pos ( l_alw_chg_tbl,
4825: 'ALLOWANCE_CHARGE_PCT',
4826: nPos15 );
4827: ec_debug.pl ( 3, 'nPos15: ',nPos15 );
4828:

Line 4830: ece_extract_utils_pub.Find_pos ( l_alw_chg_tbl,

4826: nPos15 );
4827: ec_debug.pl ( 3, 'nPos15: ',nPos15 );
4828:
4829: xProgress := '2774-70';
4830: ece_extract_utils_pub.Find_pos ( l_alw_chg_tbl,
4831: 'ALLOWANCE_CHARGE_UOM_CODE',
4832: nPos16 );
4833: ec_debug.pl ( 3, 'nPos16: ',nPos16 );
4834:

Line 4836: ece_extract_utils_pub.Find_pos ( l_alw_chg_tbl,

4832: nPos16 );
4833: ec_debug.pl ( 3, 'nPos16: ',nPos16 );
4834:
4835: xProgress := '2775-70';
4836: ece_extract_utils_pub.Find_pos ( l_alw_chg_tbl,
4837: 'ALLOWANCE_CHARGE_QUANTITY',
4838: nPos17 );
4839: ec_debug.pl ( 3, 'nPos17: ',nPos17 );
4840:

Line 4842: ece_extract_utils_pub.Find_pos ( l_alw_chg_tbl,

4838: nPos17 );
4839: ec_debug.pl ( 3, 'nPos17: ',nPos17 );
4840:
4841: xProgress := '2776-70';
4842: ece_extract_utils_pub.Find_pos ( l_alw_chg_tbl,
4843: 'HEADER_DETAIL_INDICATOR',
4844: nPos18 );
4845: ec_debug.pl ( 3, 'nPos18: ',nPos18 );
4846:

Line 4961: ece_Extract_Utils_PUB.insert_into_interface_tbl ( iRun_id,

4957: END;
4958: ec_debug.pl ( 3, 'l_alw_chg_fkey: ',l_alw_chg_fkey );
4959:
4960: xProgress := '2850-70';
4961: ece_Extract_Utils_PUB.insert_into_interface_tbl ( iRun_id,
4962: cTransaction_Type,
4963: cCommunication_Method,
4964: cAlw_chg_Interface,
4965: l_alw_chg_tbl,

Line 5032: ece_extract_utils_pub.Find_pos ( l_line_tbl,

5028: l_key_tbl(j+iHeader_count).value );
5029: END LOOP;
5030:
5031: xProgress := '2890-70';
5032: ece_extract_utils_pub.Find_pos ( l_line_tbl,
5033: 'ITEM_ID',
5034: nPos1 );
5035: ec_debug.pl ( 3, 'nPos1: ',nPos1 );
5036:

Line 5038: ece_extract_utils_pub.Find_pos ( l_line_tbl,

5034: nPos1 );
5035: ec_debug.pl ( 3, 'nPos1: ',nPos1 );
5036:
5037: xProgress := '2891-70';
5038: ece_extract_utils_pub.Find_pos ( l_line_tbl,
5039: 'LINE_NUMBER',
5040: nPos9 );
5041: ec_debug.pl ( 3, 'nPos9: ',nPos9 );
5042:

Line 5098: ece_Extract_Utils_PUB.insert_into_interface_tbl ( iRun_id,

5094: END;
5095: ec_debug.pl ( 3, 'l_line_fkey: ',l_line_fkey );
5096:
5097: xProgress := '2930-70';
5098: ece_Extract_Utils_PUB.insert_into_interface_tbl ( iRun_id,
5099: cTransaction_Type,
5100: cCommunication_Method,
5101: cLine_Interface,
5102: l_line_tbl,

Line 5144: ece_extract_utils_pub.Find_pos ( l_line_tbl,

5140: END IF;
5141:
5142:
5143: xProgress := '2941-70';
5144: ece_extract_utils_pub.Find_pos ( l_line_tbl,
5145: 'NET_WEIGHT',
5146: nPos20 );
5147: ec_debug.pl ( 3, 'nPos20: ',nPos20);
5148:

Line 5150: ece_extract_utils_pub.Find_pos ( l_line_tbl,

5146: nPos20 );
5147: ec_debug.pl ( 3, 'nPos20: ',nPos20);
5148:
5149: xProgress := '2942-70';
5150: ece_extract_utils_pub.Find_pos ( l_line_tbl,
5151: 'GROSS_WEIGHT',
5152: nPos21 );
5153: ec_debug.pl ( 3, 'nPos21: ',nPos21);
5154:

Line 5156: ece_extract_utils_pub.Find_pos ( l_line_tbl,

5152: nPos21 );
5153: ec_debug.pl ( 3, 'nPos21: ',nPos21);
5154:
5155: xProgress := '2943-70';
5156: ece_extract_utils_pub.Find_pos ( l_line_tbl,
5157: 'VOLUME',
5158: nPos23 );
5159: ec_debug.pl ( 3, 'nPos23: ',nPos23);
5160:

Line 5162: ece_extract_utils_pub.Find_pos ( l_line_tbl,

5158: nPos23 );
5159: ec_debug.pl ( 3, 'nPos23: ',nPos23);
5160:
5161: xProgress := '2944-70';
5162: ece_extract_utils_pub.Find_pos ( l_line_tbl,
5163: 'WEIGHT_UOM_CODE_INT',
5164: nPos24 );
5165: ec_debug.pl ( 3, 'nPos24: ',nPos24);
5166:

Line 5168: ece_extract_utils_pub.Find_pos ( l_line_tbl,

5164: nPos24 );
5165: ec_debug.pl ( 3, 'nPos24: ',nPos24);
5166:
5167: xProgress := '2945-70';
5168: ece_extract_utils_pub.Find_pos ( l_line_tbl,
5169: 'VOLUME_UOM_CODE_INT',
5170: nPos25 );
5171: ec_debug.pl ( 3, 'nPos25: ',nPos25);
5172:

Line 5174: ece_extract_utils_pub.Find_pos ( l_line_tbl,

5170: nPos25 );
5171: ec_debug.pl ( 3, 'nPos25: ',nPos25);
5172:
5173: xProgress := '2946-70';
5174: ece_extract_utils_pub.Find_pos ( l_line_tbl,
5175: 'SHIPMENT_NUMBER',
5176: nPos26 );
5177: ec_debug.pl ( 3, 'nPos26: ',nPos26);
5178:

Line 5180: ece_extract_utils_pub.Find_pos ( l_line_tbl,

5176: nPos26 );
5177: ec_debug.pl ( 3, 'nPos26: ',nPos26);
5178:
5179: xProgress := '2947-70';
5180: ece_extract_utils_pub.Find_pos ( l_line_tbl,
5181: 'BOOKING_NUMBER',
5182: nPos27 );
5183: ec_debug.pl ( 3, 'nPos27: ',nPos27);
5184:

Line 5263: ece_extract_utils_pub.Find_pos ( l_line_t_tbl,

5259: END LOOP;
5260:
5261:
5262: xProgress := '3000-70';
5263: ece_extract_utils_pub.Find_pos ( l_line_t_tbl,
5264: 'LINE_TYPE',
5265: nPos1 );
5266: ec_debug.pl ( 3, 'nPos1: ',nPos1 );
5267:

Line 5269: ece_extract_utils_pub.Find_pos ( l_line_t_tbl,

5265: nPos1 );
5266: ec_debug.pl ( 3, 'nPos1: ',nPos1 );
5267:
5268: xProgress := '3002-70';
5269: ece_extract_utils_pub.Find_pos ( l_line_t_tbl,
5270: 'LINK_TO_CUST_TRX_LINE_ID',
5271: nPos2 );
5272: ec_debug.pl ( 3, 'nPos2: ',nPos2 );
5273:

Line 5275: ece_extract_utils_pub.Find_pos ( l_line_t_tbl,

5271: nPos2 );
5272: ec_debug.pl ( 3, 'nPos2: ',nPos2 );
5273:
5274: xProgress := '3004-70';
5275: ece_extract_utils_pub.Find_pos ( l_line_t_tbl,
5276: 'CUSTOMER_TRX_LINE_ID',
5277: nPos3 );
5278: ec_debug.pl ( 3, 'nPos3: ',nPos3 );
5279:

Line 5281: ece_extract_utils_pub.Find_pos ( l_line_t_tbl,

5277: nPos3 );
5278: ec_debug.pl ( 3, 'nPos3: ',nPos3 );
5279:
5280: xProgress := '3006-70';
5281: ece_extract_utils_pub.Find_pos ( l_line_t_tbl,
5282: 'TAX_AMOUNT',
5283: nPos4 );
5284: ec_debug.pl ( 3, 'nPos4: ',nPos4 );
5285:

Line 5323: ece_Extract_Utils_PUB.insert_into_interface_tbl ( iRun_id,

5319: p_key_tbl => l_key_tbl,
5320: p_tbl => l_line_t_tbl );
5321:
5322: xProgress := '3030-70';
5323: ece_Extract_Utils_PUB.insert_into_interface_tbl ( iRun_id,
5324: cTransaction_Type,
5325: cCommunication_Method,
5326: cLine_t_Interface,
5327: l_line_t_tbl,