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.AP_1099_UTILITIES_PKG dependencies on AP_1099_TAPE_DATA

Line 49: 'INSERT INTO ap_1099_tape_data '

45: AND gl.set_of_books_id = p_sob_id;
46:
47:
48: l_dynamic_sql1:=
49: 'INSERT INTO ap_1099_tape_data '
50: || '(vendor_id,region_code,'
51: || 'misc1,misc2,misc3,misc4,misc5,'
52: || ' misc6,misc7,misc8,misc9,misc10,'
53: || 'misc13, misc14, misc15aNT, misc15aT, misc15b,org_id) ' -- Bug 4946930

Line 417: select count(*) into x from ap_1099_tape_data;

413: end;
414:
415: execute immediate l_dynamic_sql1 || l_dynamic_sql2 || l_dynamic_sql2_1 || l_dynamic_sql3;
416:
417: select count(*) into x from ap_1099_tape_data;
418: fnd_file.put_line(FND_FILE.LOG, to_char(x));
419:
420:
421: end insert_1099_data;

Line 454: vendor_id AP_1099_TAPE_DATA_ALL.vendor_id%TYPE,

450: l_org_id number; -- Bug 4946930
451: x number;
452:
453: TYPE r_backup_awt_info IS RECORD(
454: vendor_id AP_1099_TAPE_DATA_ALL.vendor_id%TYPE,
455: region_code AP_1099_TAPE_DATA_ALL.region_code%TYPE,
456: misc1 AP_1099_TAPE_DATA_ALL.misc1%TYPE,
457: misc2 AP_1099_TAPE_DATA_ALL.misc2%TYPE,
458: misc3 AP_1099_TAPE_DATA_ALL.misc3%TYPE,

Line 455: region_code AP_1099_TAPE_DATA_ALL.region_code%TYPE,

451: x number;
452:
453: TYPE r_backup_awt_info IS RECORD(
454: vendor_id AP_1099_TAPE_DATA_ALL.vendor_id%TYPE,
455: region_code AP_1099_TAPE_DATA_ALL.region_code%TYPE,
456: misc1 AP_1099_TAPE_DATA_ALL.misc1%TYPE,
457: misc2 AP_1099_TAPE_DATA_ALL.misc2%TYPE,
458: misc3 AP_1099_TAPE_DATA_ALL.misc3%TYPE,
459: misc4 AP_1099_TAPE_DATA_ALL.misc4%TYPE,

Line 456: misc1 AP_1099_TAPE_DATA_ALL.misc1%TYPE,

452:
453: TYPE r_backup_awt_info IS RECORD(
454: vendor_id AP_1099_TAPE_DATA_ALL.vendor_id%TYPE,
455: region_code AP_1099_TAPE_DATA_ALL.region_code%TYPE,
456: misc1 AP_1099_TAPE_DATA_ALL.misc1%TYPE,
457: misc2 AP_1099_TAPE_DATA_ALL.misc2%TYPE,
458: misc3 AP_1099_TAPE_DATA_ALL.misc3%TYPE,
459: misc4 AP_1099_TAPE_DATA_ALL.misc4%TYPE,
460: misc5 AP_1099_TAPE_DATA_ALL.misc5%TYPE,

Line 457: misc2 AP_1099_TAPE_DATA_ALL.misc2%TYPE,

453: TYPE r_backup_awt_info IS RECORD(
454: vendor_id AP_1099_TAPE_DATA_ALL.vendor_id%TYPE,
455: region_code AP_1099_TAPE_DATA_ALL.region_code%TYPE,
456: misc1 AP_1099_TAPE_DATA_ALL.misc1%TYPE,
457: misc2 AP_1099_TAPE_DATA_ALL.misc2%TYPE,
458: misc3 AP_1099_TAPE_DATA_ALL.misc3%TYPE,
459: misc4 AP_1099_TAPE_DATA_ALL.misc4%TYPE,
460: misc5 AP_1099_TAPE_DATA_ALL.misc5%TYPE,
461: misc6 AP_1099_TAPE_DATA_ALL.misc6%TYPE,

Line 458: misc3 AP_1099_TAPE_DATA_ALL.misc3%TYPE,

454: vendor_id AP_1099_TAPE_DATA_ALL.vendor_id%TYPE,
455: region_code AP_1099_TAPE_DATA_ALL.region_code%TYPE,
456: misc1 AP_1099_TAPE_DATA_ALL.misc1%TYPE,
457: misc2 AP_1099_TAPE_DATA_ALL.misc2%TYPE,
458: misc3 AP_1099_TAPE_DATA_ALL.misc3%TYPE,
459: misc4 AP_1099_TAPE_DATA_ALL.misc4%TYPE,
460: misc5 AP_1099_TAPE_DATA_ALL.misc5%TYPE,
461: misc6 AP_1099_TAPE_DATA_ALL.misc6%TYPE,
462: misc7 AP_1099_TAPE_DATA_ALL.misc7%TYPE,

Line 459: misc4 AP_1099_TAPE_DATA_ALL.misc4%TYPE,

455: region_code AP_1099_TAPE_DATA_ALL.region_code%TYPE,
456: misc1 AP_1099_TAPE_DATA_ALL.misc1%TYPE,
457: misc2 AP_1099_TAPE_DATA_ALL.misc2%TYPE,
458: misc3 AP_1099_TAPE_DATA_ALL.misc3%TYPE,
459: misc4 AP_1099_TAPE_DATA_ALL.misc4%TYPE,
460: misc5 AP_1099_TAPE_DATA_ALL.misc5%TYPE,
461: misc6 AP_1099_TAPE_DATA_ALL.misc6%TYPE,
462: misc7 AP_1099_TAPE_DATA_ALL.misc7%TYPE,
463: misc8 AP_1099_TAPE_DATA_ALL.misc8%TYPE,

Line 460: misc5 AP_1099_TAPE_DATA_ALL.misc5%TYPE,

456: misc1 AP_1099_TAPE_DATA_ALL.misc1%TYPE,
457: misc2 AP_1099_TAPE_DATA_ALL.misc2%TYPE,
458: misc3 AP_1099_TAPE_DATA_ALL.misc3%TYPE,
459: misc4 AP_1099_TAPE_DATA_ALL.misc4%TYPE,
460: misc5 AP_1099_TAPE_DATA_ALL.misc5%TYPE,
461: misc6 AP_1099_TAPE_DATA_ALL.misc6%TYPE,
462: misc7 AP_1099_TAPE_DATA_ALL.misc7%TYPE,
463: misc8 AP_1099_TAPE_DATA_ALL.misc8%TYPE,
464: misc9 AP_1099_TAPE_DATA_ALL.misc9%TYPE,

Line 461: misc6 AP_1099_TAPE_DATA_ALL.misc6%TYPE,

457: misc2 AP_1099_TAPE_DATA_ALL.misc2%TYPE,
458: misc3 AP_1099_TAPE_DATA_ALL.misc3%TYPE,
459: misc4 AP_1099_TAPE_DATA_ALL.misc4%TYPE,
460: misc5 AP_1099_TAPE_DATA_ALL.misc5%TYPE,
461: misc6 AP_1099_TAPE_DATA_ALL.misc6%TYPE,
462: misc7 AP_1099_TAPE_DATA_ALL.misc7%TYPE,
463: misc8 AP_1099_TAPE_DATA_ALL.misc8%TYPE,
464: misc9 AP_1099_TAPE_DATA_ALL.misc9%TYPE,
465: misc10 AP_1099_TAPE_DATA_ALL.misc10%TYPE,

Line 462: misc7 AP_1099_TAPE_DATA_ALL.misc7%TYPE,

458: misc3 AP_1099_TAPE_DATA_ALL.misc3%TYPE,
459: misc4 AP_1099_TAPE_DATA_ALL.misc4%TYPE,
460: misc5 AP_1099_TAPE_DATA_ALL.misc5%TYPE,
461: misc6 AP_1099_TAPE_DATA_ALL.misc6%TYPE,
462: misc7 AP_1099_TAPE_DATA_ALL.misc7%TYPE,
463: misc8 AP_1099_TAPE_DATA_ALL.misc8%TYPE,
464: misc9 AP_1099_TAPE_DATA_ALL.misc9%TYPE,
465: misc10 AP_1099_TAPE_DATA_ALL.misc10%TYPE,
466: misc13 AP_1099_TAPE_DATA_ALL.misc13%TYPE,

Line 463: misc8 AP_1099_TAPE_DATA_ALL.misc8%TYPE,

459: misc4 AP_1099_TAPE_DATA_ALL.misc4%TYPE,
460: misc5 AP_1099_TAPE_DATA_ALL.misc5%TYPE,
461: misc6 AP_1099_TAPE_DATA_ALL.misc6%TYPE,
462: misc7 AP_1099_TAPE_DATA_ALL.misc7%TYPE,
463: misc8 AP_1099_TAPE_DATA_ALL.misc8%TYPE,
464: misc9 AP_1099_TAPE_DATA_ALL.misc9%TYPE,
465: misc10 AP_1099_TAPE_DATA_ALL.misc10%TYPE,
466: misc13 AP_1099_TAPE_DATA_ALL.misc13%TYPE,
467: misc14 AP_1099_TAPE_DATA_ALL.misc14%TYPE,

Line 464: misc9 AP_1099_TAPE_DATA_ALL.misc9%TYPE,

460: misc5 AP_1099_TAPE_DATA_ALL.misc5%TYPE,
461: misc6 AP_1099_TAPE_DATA_ALL.misc6%TYPE,
462: misc7 AP_1099_TAPE_DATA_ALL.misc7%TYPE,
463: misc8 AP_1099_TAPE_DATA_ALL.misc8%TYPE,
464: misc9 AP_1099_TAPE_DATA_ALL.misc9%TYPE,
465: misc10 AP_1099_TAPE_DATA_ALL.misc10%TYPE,
466: misc13 AP_1099_TAPE_DATA_ALL.misc13%TYPE,
467: misc14 AP_1099_TAPE_DATA_ALL.misc14%TYPE,
468: misc15aNT AP_1099_TAPE_DATA_ALL.misc15aNT%TYPE,

Line 465: misc10 AP_1099_TAPE_DATA_ALL.misc10%TYPE,

461: misc6 AP_1099_TAPE_DATA_ALL.misc6%TYPE,
462: misc7 AP_1099_TAPE_DATA_ALL.misc7%TYPE,
463: misc8 AP_1099_TAPE_DATA_ALL.misc8%TYPE,
464: misc9 AP_1099_TAPE_DATA_ALL.misc9%TYPE,
465: misc10 AP_1099_TAPE_DATA_ALL.misc10%TYPE,
466: misc13 AP_1099_TAPE_DATA_ALL.misc13%TYPE,
467: misc14 AP_1099_TAPE_DATA_ALL.misc14%TYPE,
468: misc15aNT AP_1099_TAPE_DATA_ALL.misc15aNT%TYPE,
469: misc15aT AP_1099_TAPE_DATA_ALL.misc15aT%TYPE,

Line 466: misc13 AP_1099_TAPE_DATA_ALL.misc13%TYPE,

462: misc7 AP_1099_TAPE_DATA_ALL.misc7%TYPE,
463: misc8 AP_1099_TAPE_DATA_ALL.misc8%TYPE,
464: misc9 AP_1099_TAPE_DATA_ALL.misc9%TYPE,
465: misc10 AP_1099_TAPE_DATA_ALL.misc10%TYPE,
466: misc13 AP_1099_TAPE_DATA_ALL.misc13%TYPE,
467: misc14 AP_1099_TAPE_DATA_ALL.misc14%TYPE,
468: misc15aNT AP_1099_TAPE_DATA_ALL.misc15aNT%TYPE,
469: misc15aT AP_1099_TAPE_DATA_ALL.misc15aT%TYPE,
470: misc15b AP_1099_TAPE_DATA_ALL.misc15b%TYPE

Line 467: misc14 AP_1099_TAPE_DATA_ALL.misc14%TYPE,

463: misc8 AP_1099_TAPE_DATA_ALL.misc8%TYPE,
464: misc9 AP_1099_TAPE_DATA_ALL.misc9%TYPE,
465: misc10 AP_1099_TAPE_DATA_ALL.misc10%TYPE,
466: misc13 AP_1099_TAPE_DATA_ALL.misc13%TYPE,
467: misc14 AP_1099_TAPE_DATA_ALL.misc14%TYPE,
468: misc15aNT AP_1099_TAPE_DATA_ALL.misc15aNT%TYPE,
469: misc15aT AP_1099_TAPE_DATA_ALL.misc15aT%TYPE,
470: misc15b AP_1099_TAPE_DATA_ALL.misc15b%TYPE
471: ) ;

Line 468: misc15aNT AP_1099_TAPE_DATA_ALL.misc15aNT%TYPE,

464: misc9 AP_1099_TAPE_DATA_ALL.misc9%TYPE,
465: misc10 AP_1099_TAPE_DATA_ALL.misc10%TYPE,
466: misc13 AP_1099_TAPE_DATA_ALL.misc13%TYPE,
467: misc14 AP_1099_TAPE_DATA_ALL.misc14%TYPE,
468: misc15aNT AP_1099_TAPE_DATA_ALL.misc15aNT%TYPE,
469: misc15aT AP_1099_TAPE_DATA_ALL.misc15aT%TYPE,
470: misc15b AP_1099_TAPE_DATA_ALL.misc15b%TYPE
471: ) ;
472:

Line 469: misc15aT AP_1099_TAPE_DATA_ALL.misc15aT%TYPE,

465: misc10 AP_1099_TAPE_DATA_ALL.misc10%TYPE,
466: misc13 AP_1099_TAPE_DATA_ALL.misc13%TYPE,
467: misc14 AP_1099_TAPE_DATA_ALL.misc14%TYPE,
468: misc15aNT AP_1099_TAPE_DATA_ALL.misc15aNT%TYPE,
469: misc15aT AP_1099_TAPE_DATA_ALL.misc15aT%TYPE,
470: misc15b AP_1099_TAPE_DATA_ALL.misc15b%TYPE
471: ) ;
472:
473: l_backup_awt_rec r_backup_awt_info ;

Line 470: misc15b AP_1099_TAPE_DATA_ALL.misc15b%TYPE

466: misc13 AP_1099_TAPE_DATA_ALL.misc13%TYPE,
467: misc14 AP_1099_TAPE_DATA_ALL.misc14%TYPE,
468: misc15aNT AP_1099_TAPE_DATA_ALL.misc15aNT%TYPE,
469: misc15aT AP_1099_TAPE_DATA_ALL.misc15aT%TYPE,
470: misc15b AP_1099_TAPE_DATA_ALL.misc15b%TYPE
471: ) ;
472:
473: l_backup_awt_rec r_backup_awt_info ;
474:

Line 814: update ap_1099_tape_data atd

810:
811: fetch c_awt into l_backup_awt_rec ;
812: exit when c_awt%NOTFOUND ;
813:
814: update ap_1099_tape_data atd
815: set misc1 = decode(atd.misc1, 0, l_backup_awt_rec.misc1, atd.misc1),
816: misc2 = decode(atd.misc2, 0, l_backup_awt_rec.misc2, atd.misc2),
817: misc3 = decode(atd.misc3, 0, l_backup_awt_rec.misc3, atd.misc3),
818: misc5 = decode(atd.misc5, 0, l_backup_awt_rec.misc5, atd.misc5),

Line 890: FROM ap_1099_tape_data TD,

886: decode(nvl(pvw.province, pvw.state), '', 'No state. ') ||
887: decode(replace(replace(pvw.zip, '-', ''), ' ', ''),
888: '',
889: 'No postal code. ')) current_error_text
890: FROM ap_1099_tape_data TD,
891: (SELECT P.vendor_id VENDOR_ID,
892: P.vendor_name VENDOR_NAME,
893: P.tax_reporting_name TAX_REPORTING_NAME,
894: p.organization_type_lookup_code ORGANIZATION_TYPE_LOOKUP_CODE,

Line 1119: UPDATE ap_1099_tape_data

1115: BEGIN
1116: FOR rec_1099_curs IN curs_1099
1117: LOOP
1118: IF rec_1099_curs.current_error_text is not null THEN
1119: UPDATE ap_1099_tape_data
1120: SET
1121: misc1 =null,
1122: misc2 =null,
1123: misc3 =null,