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.FV_SLA_UTL_PROCESSING_PKG dependencies on FV_EXTRACT_DETAIL_GT

Line 98: p_fv_extract_detail IN OUT NOCOPY fv_extract_detail_gt%ROWTYPE

94:
95: PROCEDURE init_extract_record
96: (
97: p_application_id IN NUMBER,
98: p_fv_extract_detail IN OUT NOCOPY fv_extract_detail_gt%ROWTYPE
99: )
100: IS
101: BEGIN
102: p_fv_extract_detail.application_id := p_application_id;

Line 1098: FROM fv_extract_detail_gt;

1094:
1095: IF (l_debug = 'Y') THEN
1096: SELECT *
1097: BULK COLLECT INTO l_fv_extract_detail
1098: FROM fv_extract_detail_gt;
1099:
1100: dump_gt_table
1101: (
1102: p_fv_extract_detail => l_fv_extract_detail,

Line 1140: INSERT INTO fv_extract_detail_gt_logs

1136: END IF;
1137:
1138: IF (l_debug = 'Y') THEN
1139: FOR i IN p_fv_extract_detail.first..p_fv_extract_detail.last LOOP
1140: INSERT INTO fv_extract_detail_gt_logs
1141: (
1142: event_id,
1143: line_number,
1144: application_id,

Line 1568: p_extract_rec IN OUT NOCOPY fv_extract_detail_gt%ROWTYPE,

1564: PROCEDURE po_pya_processor
1565: (
1566: p_application_id IN NUMBER,
1567: p_event_rec IN xla_events_gt%ROWTYPE,
1568: p_extract_rec IN OUT NOCOPY fv_extract_detail_gt%ROWTYPE,
1569: p_error_code OUT NOCOPY NUMBER,
1570: p_error_desc OUT NOCOPY VARCHAR2
1571: )
1572: IS

Line 1645: p_extract_rec IN OUT NOCOPY fv_extract_detail_gt%ROWTYPE,

1641: PROCEDURE ap_pya_processor
1642: (
1643: p_application_id IN NUMBER,
1644: p_event_rec IN xla_events_gt%ROWTYPE,
1645: p_extract_rec IN OUT NOCOPY fv_extract_detail_gt%ROWTYPE,
1646: p_error_code OUT NOCOPY NUMBER,
1647: p_error_desc OUT NOCOPY VARCHAR2
1648: )
1649: IS

Line 1703: l_adjustment_type fv_extract_detail_gt.adjustment_type%TYPE;

1699: l_procedure_name VARCHAR2(100) :='.pya_processor';
1700: l_tot_acc_unant_bud_amount NUMBER;
1701: l_tot_acc_charge_amount NUMBER;
1702: l_tot_acc_unreserve_bud_amount NUMBER;
1703: l_adjustment_type fv_extract_detail_gt.adjustment_type%TYPE;
1704: l_exchange_rate NUMBER;
1705: l_tot_acc_anticipated_amt NUMBER;
1706: l_tot_acc_commitment_amt NUMBER;
1707: l_curr_ts_id NUMBER := -1;

Line 1731: FROM fv_extract_detail_gt f

1727: ------------------------------
1728: --Bug#16478406 Added logic to process invoices that are po matched and non matched seperately
1729: FOR ts_rec IN (SELECT distinct treasury_symbol_id treasury_symbol_id,
1730: DECODE(f.application_id, 200, DECODE (f.po_distribution_id, NULL, -1, -2), -2) po_match_type
1731: FROM fv_extract_detail_gt f
1732: WHERE f.event_id = event_rec.event_id
1733: AND f.prior_year_flag = 'Y') LOOP
1734: trace(C_STATE_LEVEL, l_procedure_name, 'Processing TS:'||ts_rec.treasury_symbol_id);
1735:

Line 1782: FROM fv_extract_detail_gt f

1778: INTO l_tot_acc_unant_bud_amount,
1779: l_tot_acc_charge_amount,
1780: l_tot_acc_unreserve_bud_amount,
1781: l_tot_acc_commitment_amt
1782: FROM fv_extract_detail_gt f
1783: WHERE f.event_id = event_rec.event_id
1784: AND f.treasury_symbol_id = ts_rec.treasury_symbol_id
1785: AND DECODE(f.application_id, 200, DECODE (f.po_distribution_id, NULL, -1, -2), -2) = ts_rec.po_match_type
1786: AND f.prior_year_flag = 'Y';

Line 1796: stack_error (l_procedure_name, 'SELECT_fv_extract_detail_gt', p_error_desc);

1792: WHEN OTHERS THEN
1793: p_error_code := c_FAILURE;
1794: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
1795: p_error_desc := fnd_message.get;
1796: stack_error (l_procedure_name, 'SELECT_fv_extract_detail_gt', p_error_desc);
1797: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_fv_extract_detail_gt:'||p_error_desc);
1798: END;
1799: END IF;
1800:

Line 1797: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_fv_extract_detail_gt:'||p_error_desc);

1793: p_error_code := c_FAILURE;
1794: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
1795: p_error_desc := fnd_message.get;
1796: stack_error (l_procedure_name, 'SELECT_fv_extract_detail_gt', p_error_desc);
1797: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_fv_extract_detail_gt:'||p_error_desc);
1798: END;
1799: END IF;
1800:
1801: IF (p_error_code = c_SUCCESS) THEN

Line 1826: UPDATE fv_extract_detail_gt f

1822: IF (p_error_code = c_SUCCESS) THEN
1823: -- Move all Commitments to Unanticipated Budget
1824: BEGIN
1825: trace(C_STATE_LEVEL, l_procedure_name, 'Moving Commitments to Unanticipated Budget');
1826: UPDATE fv_extract_detail_gt f
1827: SET f.acc_unanticipated_bud_amount = NVL(f.acc_unanticipated_bud_amount, 0) + NVL(f.acc_commitment_amount, 0),
1828: f.ent_unanticipated_bud_amount = NVL(f.ent_unanticipated_bud_amount, 0) + NVL(f.ent_commitment_amount, 0),
1829: f.acc_commitment_amount = 0,
1830: f.ent_commitment_amount = 0

Line 1840: stack_error (l_procedure_name, 'UPDATE_fv_extract_detail_gt', p_error_desc);

1836: WHEN OTHERS THEN
1837: p_error_code := c_FAILURE;
1838: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
1839: p_error_desc := fnd_message.get;
1840: stack_error (l_procedure_name, 'UPDATE_fv_extract_detail_gt', p_error_desc);
1841: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:UPDATE_fv_extract_detail_gt:'||p_error_desc);
1842: END;
1843: END IF;
1844: */

Line 1841: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:UPDATE_fv_extract_detail_gt:'||p_error_desc);

1837: p_error_code := c_FAILURE;
1838: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
1839: p_error_desc := fnd_message.get;
1840: stack_error (l_procedure_name, 'UPDATE_fv_extract_detail_gt', p_error_desc);
1841: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:UPDATE_fv_extract_detail_gt:'||p_error_desc);
1842: END;
1843: END IF;
1844: */
1845:

Line 1848: FROM fv_extract_detail_gt f

1844: */
1845:
1846: IF (p_error_code = c_SUCCESS) THEN
1847: FOR pya_rec IN (SELECT *
1848: FROM fv_extract_detail_gt f
1849: WHERE f.event_id = event_rec.event_id
1850: AND f.treasury_symbol_id = ts_rec.treasury_symbol_id
1851: AND DECODE(f.application_id, 200, DECODE (f.po_distribution_id, NULL, -1, -2), -2) = ts_rec.po_match_type
1852: AND f.prior_year_flag = 'Y') LOOP

Line 1926: UPDATE fv_extract_detail_gt f

1922: trace(C_STATE_LEVEL, l_procedure_name, 'ent_paid_exp_amount='||pya_rec.ent_paid_exp_amount);
1923: trace(C_STATE_LEVEL, l_procedure_name, 'adjustment_type='||pya_rec.adjustment_type);
1924:
1925: BEGIN
1926: UPDATE fv_extract_detail_gt f
1927: SET adjustment_type = pya_rec.adjustment_type,
1928: acc_anticipated_budget_amount = pya_rec.acc_anticipated_budget_amount,
1929: ent_anticipated_budget_amount = pya_rec.ent_anticipated_budget_amount,
1930: acc_unanticipated_bud_amount = pya_rec.acc_unanticipated_bud_amount,

Line 1952: stack_error (l_procedure_name, 'UPDATE_fv_extract_detail_gt', p_error_desc);

1948: WHEN OTHERS THEN
1949: p_error_code := c_FAILURE;
1950: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
1951: p_error_desc := fnd_message.get;
1952: stack_error (l_procedure_name, 'UPDATE_fv_extract_detail_gt', p_error_desc);
1953: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:UPDATE_fv_extract_detail_gt:'||p_error_desc);
1954: END;
1955:
1956: trace(C_STATE_LEVEL, l_procedure_name, 'Updated'||SQL%ROWCOUNT||' rows.');

Line 1953: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:UPDATE_fv_extract_detail_gt:'||p_error_desc);

1949: p_error_code := c_FAILURE;
1950: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
1951: p_error_desc := fnd_message.get;
1952: stack_error (l_procedure_name, 'UPDATE_fv_extract_detail_gt', p_error_desc);
1953: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:UPDATE_fv_extract_detail_gt:'||p_error_desc);
1954: END;
1955:
1956: trace(C_STATE_LEVEL, l_procedure_name, 'Updated'||SQL%ROWCOUNT||' rows.');
1957: IF (p_error_code <> c_SUCCESS) THEN

Line 1993: l_adjustment_type fv_extract_detail_gt.adjustment_type%TYPE;

1989: l_procedure_name VARCHAR2(100) :='.check_errors';
1990: l_tot_acc_unant_bud_amount NUMBER;
1991: l_tot_acc_charge_amount NUMBER;
1992: l_tot_acc_unreserve_bud_amount NUMBER;
1993: l_adjustment_type fv_extract_detail_gt.adjustment_type%TYPE;
1994: l_exchange_rate NUMBER;
1995: l_tot_acc_anticipated_amt NUMBER;
1996: BEGIN
1997: l_procedure_name := g_path_name || l_procedure_name;

Line 2003: FROM fv_extract_detail_gt g

1999: p_error_desc := NULL;
2000: trace(C_STATE_LEVEL, l_procedure_name, 'BEGIN');
2001: /* Check for Expired Funds used in current Year*/
2002: FOR exp_funds_rec IN (SELECT *
2003: FROM fv_extract_detail_gt g
2004: WHERE g.fund_expired_status = 'Expired'
2005: AND g.prior_year_flag = 'N'
2006: AND NOT EXISTS (SELECT 1 --Bug14593920
2007: FROM fv_treasury_symbols t