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.PO_TAX_INTERFACE_PVT dependencies on PO_SESSION_GT

Line 136: l_po_session_gt_key PO_SESSION_GT.key%TYPE;

132: l_msg_count NUMBER;
133: l_msg_data VARCHAR2(1000);
134: l_count NUMBER;
135: l_return_status VARCHAR2(1);
136: l_po_session_gt_key PO_SESSION_GT.key%TYPE;
137: l_transaction_line_rec_type ZX_API_PUB.transaction_line_rec_type;
138: BEGIN
139: -- PO_SESSION_GT mappings:
140: --------------------------------------------------

Line 139: -- PO_SESSION_GT mappings:

135: l_return_status VARCHAR2(1);
136: l_po_session_gt_key PO_SESSION_GT.key%TYPE;
137: l_transaction_line_rec_type ZX_API_PUB.transaction_line_rec_type;
138: BEGIN
139: -- PO_SESSION_GT mappings:
140: --------------------------------------------------
141: -- / INDEX_NUM1 = trx_id \
142: -- / NUM1 = trx_line_id \
143: -- / NUM2 = trx_line_dist_id \

Line 171: SELECT po_session_gt_s.NEXTVAL INTO l_po_session_gt_key FROM dual;

167: initialize_zx_gt_tables(); -- Wipe ZX GT tables clean
168: d_progress := 20;
169: initialize_global_error_record();
170: d_progress := 30;
171: SELECT po_session_gt_s.NEXTVAL INTO l_po_session_gt_key FROM dual;
172:
173: IF PO_LOG.d_stmt THEN
174: PO_LOG.stmt(d_module_base,d_progress,'l_po_session_gt_key='||l_po_session_gt_key);
175: END IF;

Line 174: PO_LOG.stmt(d_module_base,d_progress,'l_po_session_gt_key='||l_po_session_gt_key);

170: d_progress := 30;
171: SELECT po_session_gt_s.NEXTVAL INTO l_po_session_gt_key FROM dual;
172:
173: IF PO_LOG.d_stmt THEN
174: PO_LOG.stmt(d_module_base,d_progress,'l_po_session_gt_key='||l_po_session_gt_key);
175: END IF;
176:
177: d_progress := 40;
178: IF PO_LOG.d_stmt THEN

Line 307: -- If expected errors, store error details in po_session_gt temporarily

303: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
305: END IF;
306:
307: -- If expected errors, store error details in po_session_gt temporarily
308: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
309: d_progress := 140;
310: x_return_status := l_return_status;
311: INSERT INTO po_session_gt(

Line 311: INSERT INTO po_session_gt(

307: -- If expected errors, store error details in po_session_gt temporarily
308: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
309: d_progress := 140;
310: x_return_status := l_return_status;
311: INSERT INTO po_session_gt(
312: key
313: ,index_num1
314: ,num1
315: ,num2

Line 322: l_po_session_gt_key

318: ,char3
319: ,char4
320: )
321: SELECT
322: l_po_session_gt_key
323: ,zxvegt.trx_id
324: ,zxvegt.trx_line_id
325: ,null
326: ,zxvegt.event_class_code

Line 335: INSERT INTO po_session_gt(

331: WHERE zxvegt.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
332: AND zxvegt.trx_id = ph.po_header_id;
333:
334: d_progress := 150;
335: INSERT INTO po_session_gt(
336: key
337: ,index_num1
338: ,num1
339: ,num2

Line 346: l_po_session_gt_key

342: ,char3
343: ,char4
344: )
345: SELECT
346: l_po_session_gt_key
347: ,zxvegt.trx_id
348: ,zxvegt.trx_line_id
349: ,null
350: ,zxvegt.event_class_code

Line 378: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt

374:
375: d_progress := 160;
376: -- Delete data from zx gt tables for which defaulting/redefaulting failed
377: DELETE FROM zx_trx_headers_gt
378: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt
379: WHERE psgt.key = l_po_session_gt_key
380: AND psgt.char1 = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE);
381: d_progress := 170;
382: DELETE FROM zx_transaction_lines_gt

Line 379: WHERE psgt.key = l_po_session_gt_key

375: d_progress := 160;
376: -- Delete data from zx gt tables for which defaulting/redefaulting failed
377: DELETE FROM zx_trx_headers_gt
378: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt
379: WHERE psgt.key = l_po_session_gt_key
380: AND psgt.char1 = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE);
381: d_progress := 170;
382: DELETE FROM zx_transaction_lines_gt
383: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt

Line 383: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt

379: WHERE psgt.key = l_po_session_gt_key
380: AND psgt.char1 = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE);
381: d_progress := 170;
382: DELETE FROM zx_transaction_lines_gt
383: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt
384: WHERE psgt.key = l_po_session_gt_key
385: AND psgt.char1 = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE);
386:
387: ELSIF (p_calling_program <> 'COPY_DOCUMENT') THEN

Line 384: WHERE psgt.key = l_po_session_gt_key

380: AND psgt.char1 = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE);
381: d_progress := 170;
382: DELETE FROM zx_transaction_lines_gt
383: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt
384: WHERE psgt.key = l_po_session_gt_key
385: AND psgt.char1 = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE);
386:
387: ELSIF (p_calling_program <> 'COPY_DOCUMENT') THEN
388: d_progress := 180;

Line 460: -- If expected errors, store error details in po_session_gt temporarily

456: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
458: END IF;
459:
460: -- If expected errors, store error details in po_session_gt temporarily
461: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
462: x_return_status := l_return_status;
463: d_progress := 230;
464: INSERT INTO po_session_gt(

Line 464: INSERT INTO po_session_gt(

460: -- If expected errors, store error details in po_session_gt temporarily
461: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
462: x_return_status := l_return_status;
463: d_progress := 230;
464: INSERT INTO po_session_gt(
465: key
466: ,index_num1
467: ,num1
468: ,num2

Line 475: l_po_session_gt_key

471: ,char3
472: ,char4
473: )
474: SELECT
475: l_po_session_gt_key
476: ,zxegt.trx_id
477: ,zxegt.trx_line_id
478: ,zxegt.trx_line_dist_id
479: ,zxegt.event_class_code

Line 488: INSERT INTO po_session_gt(

484: WHERE zxegt.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
485: AND zxegt.trx_id = ph.po_header_id;
486:
487: d_progress := 240;
488: INSERT INTO po_session_gt(
489: key
490: ,index_num1
491: ,num1
492: ,num2

Line 499: l_po_session_gt_key

495: ,char3
496: ,char4
497: )
498: SELECT
499: l_po_session_gt_key
500: ,zxegt.trx_id
501: ,zxegt.trx_line_id
502: ,zxegt.trx_line_dist_id
503: ,zxegt.event_class_code

Line 530: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt

526:
527: d_progress := 250;
528: -- Delete data from zx gt tables for which defaulting/redefaulting failed
529: DELETE FROM zx_trx_headers_gt
530: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt
531: WHERE psgt.key = l_po_session_gt_key
532: AND psgt.char1 = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
533: AND psgt.char3 = 'CALCULATE_TAX');
534: d_progress := 260;

Line 531: WHERE psgt.key = l_po_session_gt_key

527: d_progress := 250;
528: -- Delete data from zx gt tables for which defaulting/redefaulting failed
529: DELETE FROM zx_trx_headers_gt
530: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt
531: WHERE psgt.key = l_po_session_gt_key
532: AND psgt.char1 = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
533: AND psgt.char3 = 'CALCULATE_TAX');
534: d_progress := 260;
535: DELETE FROM zx_trx_headers_gt

Line 536: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt

532: AND psgt.char1 = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
533: AND psgt.char3 = 'CALCULATE_TAX');
534: d_progress := 260;
535: DELETE FROM zx_trx_headers_gt
536: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt
537: WHERE psgt.key = l_po_session_gt_key
538: AND psgt.char1 = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE
539: AND psgt.char3 = 'CALCULATE_TAX');
540: d_progress := 270;

Line 537: WHERE psgt.key = l_po_session_gt_key

533: AND psgt.char3 = 'CALCULATE_TAX');
534: d_progress := 260;
535: DELETE FROM zx_trx_headers_gt
536: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt
537: WHERE psgt.key = l_po_session_gt_key
538: AND psgt.char1 = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE
539: AND psgt.char3 = 'CALCULATE_TAX');
540: d_progress := 270;
541: DELETE FROM zx_transaction_lines_gt

Line 542: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt

538: AND psgt.char1 = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE
539: AND psgt.char3 = 'CALCULATE_TAX');
540: d_progress := 270;
541: DELETE FROM zx_transaction_lines_gt
542: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt
543: WHERE psgt.key = l_po_session_gt_key
544: AND psgt.char1 = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
545: AND psgt.char3 = 'CALCULATE_TAX');
546: d_progress := 280;

Line 543: WHERE psgt.key = l_po_session_gt_key

539: AND psgt.char3 = 'CALCULATE_TAX');
540: d_progress := 270;
541: DELETE FROM zx_transaction_lines_gt
542: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt
543: WHERE psgt.key = l_po_session_gt_key
544: AND psgt.char1 = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
545: AND psgt.char3 = 'CALCULATE_TAX');
546: d_progress := 280;
547: DELETE FROM zx_transaction_lines_gt

Line 548: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt

544: AND psgt.char1 = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
545: AND psgt.char3 = 'CALCULATE_TAX');
546: d_progress := 280;
547: DELETE FROM zx_transaction_lines_gt
548: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt
549: WHERE psgt.key = l_po_session_gt_key
550: AND psgt.char1 = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE
551: AND psgt.char3 = 'CALCULATE_TAX');
552:

Line 549: WHERE psgt.key = l_po_session_gt_key

545: AND psgt.char3 = 'CALCULATE_TAX');
546: d_progress := 280;
547: DELETE FROM zx_transaction_lines_gt
548: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt
549: WHERE psgt.key = l_po_session_gt_key
550: AND psgt.char1 = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE
551: AND psgt.char3 = 'CALCULATE_TAX');
552:
553: END IF; -- IF (l_count <> 0)

Line 644: -- If expected errors, store error details in po_session_gt temporarily

640: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
642: END IF;
643:
644: -- If expected errors, store error details in po_session_gt temporarily
645: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
646: x_return_status := l_return_status;
647: d_progress := 350;
648: INSERT INTO po_session_gt(

Line 648: INSERT INTO po_session_gt(

644: -- If expected errors, store error details in po_session_gt temporarily
645: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
646: x_return_status := l_return_status;
647: d_progress := 350;
648: INSERT INTO po_session_gt(
649: key
650: ,index_num1
651: ,num1
652: ,num2

Line 659: l_po_session_gt_key

655: ,char3
656: ,char4
657: )
658: SELECT
659: l_po_session_gt_key
660: ,zxegt.trx_id
661: ,zxegt.trx_line_id
662: ,zxegt.trx_line_dist_id
663: ,zxegt.event_class_code

Line 672: INSERT INTO po_session_gt(

668: WHERE zxegt.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
669: AND zxegt.trx_id = ph.po_header_id;
670:
671: d_progress := 360;
672: INSERT INTO po_session_gt(
673: key
674: ,index_num1
675: ,num1
676: ,num2

Line 683: l_po_session_gt_key

679: ,char3
680: ,char4
681: )
682: SELECT
683: l_po_session_gt_key
684: ,zxegt.trx_id
685: ,zxegt.trx_line_id
686: ,zxegt.trx_line_dist_id
687: ,zxegt.event_class_code

Line 720: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt

716: -- get passed as CREATE in the next tax calculation (ie at the time of
717: -- approve)
718: d_progress := 380;
719: DELETE FROM zx_itm_distributions_gt
720: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt
721: WHERE psgt.key = l_po_session_gt_key
722: AND psgt.char1 = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
723: AND psgt.char3 = 'DETERMINE_RECOVERY');
724: d_progress := 390;

Line 721: WHERE psgt.key = l_po_session_gt_key

717: -- approve)
718: d_progress := 380;
719: DELETE FROM zx_itm_distributions_gt
720: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt
721: WHERE psgt.key = l_po_session_gt_key
722: AND psgt.char1 = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
723: AND psgt.char3 = 'DETERMINE_RECOVERY');
724: d_progress := 390;
725: DELETE FROM zx_itm_distributions_gt

Line 726: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt

722: AND psgt.char1 = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
723: AND psgt.char3 = 'DETERMINE_RECOVERY');
724: d_progress := 390;
725: DELETE FROM zx_itm_distributions_gt
726: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt
727: WHERE psgt.key = l_po_session_gt_key
728: AND psgt.char1 = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE
729: AND psgt.char3 = 'DETERMINE_RECOVERY');
730:

Line 727: WHERE psgt.key = l_po_session_gt_key

723: AND psgt.char3 = 'DETERMINE_RECOVERY');
724: d_progress := 390;
725: DELETE FROM zx_itm_distributions_gt
726: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt
727: WHERE psgt.key = l_po_session_gt_key
728: AND psgt.char1 = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE
729: AND psgt.char3 = 'DETERMINE_RECOVERY');
730:
731: d_progress := 400;

Line 739: AND po_distribution_id IN (SELECT psgt.NUM2 FROM po_session_gt psgt

735: -- place despite determine_recovery erroring out for some of them
736: UPDATE po_distributions_all
737: SET tax_attribute_update_code = 'NO_ACTION'
738: WHERE tax_attribute_update_code IS NULL
739: AND po_distribution_id IN (SELECT psgt.NUM2 FROM po_session_gt psgt
740: WHERE psgt.key = l_po_session_gt_key
741: AND psgt.char3 = 'DETERMINE_RECOVERY');
742:
743: END IF; --IF (l_return_status = FND_API.G_RET_STS_ERROR)

Line 740: WHERE psgt.key = l_po_session_gt_key

736: UPDATE po_distributions_all
737: SET tax_attribute_update_code = 'NO_ACTION'
738: WHERE tax_attribute_update_code IS NULL
739: AND po_distribution_id IN (SELECT psgt.NUM2 FROM po_session_gt psgt
740: WHERE psgt.key = l_po_session_gt_key
741: AND psgt.char3 = 'DETERMINE_RECOVERY');
742:
743: END IF; --IF (l_return_status = FND_API.G_RET_STS_ERROR)
744:

Line 879: -- Pour all errors in po_session_gt into global tax error record

875: pll.line_location_id IN (SELECT trx_line_id FROM zx_transaction_lines_gt);
876:
877:
878: d_progress := 520;
879: -- Pour all errors in po_session_gt into global tax error record
880: SELECT
881: psgt.char3 --error_level
882: ,decode(psgt.char1,--document_type_code
883: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE, PO_CONSTANTS_SV.PO,

Line 896: FROM po_session_gt psgt, po_line_locations_all pll, po_distributions_all pd

892: ,pd.po_distribution_id --distribution_id
893: ,pd.distribution_num --distribution_num
894: ,psgt.char2 --message_text
895: BULK COLLECT INTO G_TAX_ERRORS_TBL
896: FROM po_session_gt psgt, po_line_locations_all pll, po_distributions_all pd
897: WHERE psgt.num1 = pll.line_location_id
898: AND psgt.num2 = pd.po_distribution_id(+)
899: AND psgt.key = l_po_session_gt_key;
900:

Line 899: AND psgt.key = l_po_session_gt_key;

895: BULK COLLECT INTO G_TAX_ERRORS_TBL
896: FROM po_session_gt psgt, po_line_locations_all pll, po_distributions_all pd
897: WHERE psgt.num1 = pll.line_location_id
898: AND psgt.num2 = pd.po_distribution_id(+)
899: AND psgt.key = l_po_session_gt_key;
900:
901: IF PO_LOG.d_stmt THEN
902: PO_LOG.stmt(d_module_base,d_progress,'Number of error records collected '||G_TAX_ERRORS_TBL.error_level.COUNT);
903: log_global_error_record(d_module_base, d_progress);

Line 1756: -- If expected errors, store error details in po_session_gt temporarily

1752: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1753: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1754: END IF;
1755:
1756: -- If expected errors, store error details in po_session_gt temporarily
1757: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1758: x_return_status := l_return_status;
1759: -- Read validation errors from zx_errors_gt into the global
1760: -- error record defined in the spec

Line 1974: -- If expected errors, store error details in po_session_gt temporarily

1970: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1971: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1972: END IF;
1973:
1974: -- If expected errors, store error details in po_session_gt temporarily
1975: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1976: x_return_status := l_return_status;
1977: -- Read validation errors from zx_errors_gt into the global
1978: -- error record defined in the spec