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_BE_INT_PKG dependencies on FV_BE_INTERFACE

Line 96: v_attribute_category fv_be_interface.attribute_category%TYPE,

92: PROCEDURE update_err_rec(v_rec_number IN NUMBER);
93: PROCEDURE reset_control_status;
94: PROCEDURE validate_dff
95: (
96: v_attribute_category fv_be_interface.attribute_category%TYPE,
97: v_attribute1 fv_be_interface.attribute1%TYPE,
98: v_attribute2 fv_be_interface.attribute2%TYPE,
99: v_attribute3 fv_be_interface.attribute3%TYPE,
100: v_attribute4 fv_be_interface.attribute4%TYPE,

Line 97: v_attribute1 fv_be_interface.attribute1%TYPE,

93: PROCEDURE reset_control_status;
94: PROCEDURE validate_dff
95: (
96: v_attribute_category fv_be_interface.attribute_category%TYPE,
97: v_attribute1 fv_be_interface.attribute1%TYPE,
98: v_attribute2 fv_be_interface.attribute2%TYPE,
99: v_attribute3 fv_be_interface.attribute3%TYPE,
100: v_attribute4 fv_be_interface.attribute4%TYPE,
101: v_attribute5 fv_be_interface.attribute5%TYPE,

Line 98: v_attribute2 fv_be_interface.attribute2%TYPE,

94: PROCEDURE validate_dff
95: (
96: v_attribute_category fv_be_interface.attribute_category%TYPE,
97: v_attribute1 fv_be_interface.attribute1%TYPE,
98: v_attribute2 fv_be_interface.attribute2%TYPE,
99: v_attribute3 fv_be_interface.attribute3%TYPE,
100: v_attribute4 fv_be_interface.attribute4%TYPE,
101: v_attribute5 fv_be_interface.attribute5%TYPE,
102: v_attribute6 fv_be_interface.attribute6%TYPE,

Line 99: v_attribute3 fv_be_interface.attribute3%TYPE,

95: (
96: v_attribute_category fv_be_interface.attribute_category%TYPE,
97: v_attribute1 fv_be_interface.attribute1%TYPE,
98: v_attribute2 fv_be_interface.attribute2%TYPE,
99: v_attribute3 fv_be_interface.attribute3%TYPE,
100: v_attribute4 fv_be_interface.attribute4%TYPE,
101: v_attribute5 fv_be_interface.attribute5%TYPE,
102: v_attribute6 fv_be_interface.attribute6%TYPE,
103: v_attribute7 fv_be_interface.attribute7%TYPE,

Line 100: v_attribute4 fv_be_interface.attribute4%TYPE,

96: v_attribute_category fv_be_interface.attribute_category%TYPE,
97: v_attribute1 fv_be_interface.attribute1%TYPE,
98: v_attribute2 fv_be_interface.attribute2%TYPE,
99: v_attribute3 fv_be_interface.attribute3%TYPE,
100: v_attribute4 fv_be_interface.attribute4%TYPE,
101: v_attribute5 fv_be_interface.attribute5%TYPE,
102: v_attribute6 fv_be_interface.attribute6%TYPE,
103: v_attribute7 fv_be_interface.attribute7%TYPE,
104: v_attribute8 fv_be_interface.attribute8%TYPE,

Line 101: v_attribute5 fv_be_interface.attribute5%TYPE,

97: v_attribute1 fv_be_interface.attribute1%TYPE,
98: v_attribute2 fv_be_interface.attribute2%TYPE,
99: v_attribute3 fv_be_interface.attribute3%TYPE,
100: v_attribute4 fv_be_interface.attribute4%TYPE,
101: v_attribute5 fv_be_interface.attribute5%TYPE,
102: v_attribute6 fv_be_interface.attribute6%TYPE,
103: v_attribute7 fv_be_interface.attribute7%TYPE,
104: v_attribute8 fv_be_interface.attribute8%TYPE,
105: v_attribute9 fv_be_interface.attribute9%TYPE,

Line 102: v_attribute6 fv_be_interface.attribute6%TYPE,

98: v_attribute2 fv_be_interface.attribute2%TYPE,
99: v_attribute3 fv_be_interface.attribute3%TYPE,
100: v_attribute4 fv_be_interface.attribute4%TYPE,
101: v_attribute5 fv_be_interface.attribute5%TYPE,
102: v_attribute6 fv_be_interface.attribute6%TYPE,
103: v_attribute7 fv_be_interface.attribute7%TYPE,
104: v_attribute8 fv_be_interface.attribute8%TYPE,
105: v_attribute9 fv_be_interface.attribute9%TYPE,
106: v_attribute10 fv_be_interface.attribute10%TYPE,

Line 103: v_attribute7 fv_be_interface.attribute7%TYPE,

99: v_attribute3 fv_be_interface.attribute3%TYPE,
100: v_attribute4 fv_be_interface.attribute4%TYPE,
101: v_attribute5 fv_be_interface.attribute5%TYPE,
102: v_attribute6 fv_be_interface.attribute6%TYPE,
103: v_attribute7 fv_be_interface.attribute7%TYPE,
104: v_attribute8 fv_be_interface.attribute8%TYPE,
105: v_attribute9 fv_be_interface.attribute9%TYPE,
106: v_attribute10 fv_be_interface.attribute10%TYPE,
107: v_attribute11 fv_be_interface.attribute11%TYPE,

Line 104: v_attribute8 fv_be_interface.attribute8%TYPE,

100: v_attribute4 fv_be_interface.attribute4%TYPE,
101: v_attribute5 fv_be_interface.attribute5%TYPE,
102: v_attribute6 fv_be_interface.attribute6%TYPE,
103: v_attribute7 fv_be_interface.attribute7%TYPE,
104: v_attribute8 fv_be_interface.attribute8%TYPE,
105: v_attribute9 fv_be_interface.attribute9%TYPE,
106: v_attribute10 fv_be_interface.attribute10%TYPE,
107: v_attribute11 fv_be_interface.attribute11%TYPE,
108: v_attribute12 fv_be_interface.attribute12%TYPE,

Line 105: v_attribute9 fv_be_interface.attribute9%TYPE,

101: v_attribute5 fv_be_interface.attribute5%TYPE,
102: v_attribute6 fv_be_interface.attribute6%TYPE,
103: v_attribute7 fv_be_interface.attribute7%TYPE,
104: v_attribute8 fv_be_interface.attribute8%TYPE,
105: v_attribute9 fv_be_interface.attribute9%TYPE,
106: v_attribute10 fv_be_interface.attribute10%TYPE,
107: v_attribute11 fv_be_interface.attribute11%TYPE,
108: v_attribute12 fv_be_interface.attribute12%TYPE,
109: v_attribute13 fv_be_interface.attribute13%TYPE,

Line 106: v_attribute10 fv_be_interface.attribute10%TYPE,

102: v_attribute6 fv_be_interface.attribute6%TYPE,
103: v_attribute7 fv_be_interface.attribute7%TYPE,
104: v_attribute8 fv_be_interface.attribute8%TYPE,
105: v_attribute9 fv_be_interface.attribute9%TYPE,
106: v_attribute10 fv_be_interface.attribute10%TYPE,
107: v_attribute11 fv_be_interface.attribute11%TYPE,
108: v_attribute12 fv_be_interface.attribute12%TYPE,
109: v_attribute13 fv_be_interface.attribute13%TYPE,
110: v_attribute14 fv_be_interface.attribute14%TYPE,

Line 107: v_attribute11 fv_be_interface.attribute11%TYPE,

103: v_attribute7 fv_be_interface.attribute7%TYPE,
104: v_attribute8 fv_be_interface.attribute8%TYPE,
105: v_attribute9 fv_be_interface.attribute9%TYPE,
106: v_attribute10 fv_be_interface.attribute10%TYPE,
107: v_attribute11 fv_be_interface.attribute11%TYPE,
108: v_attribute12 fv_be_interface.attribute12%TYPE,
109: v_attribute13 fv_be_interface.attribute13%TYPE,
110: v_attribute14 fv_be_interface.attribute14%TYPE,
111: v_attribute15 fv_be_interface.attribute15%TYPE,

Line 108: v_attribute12 fv_be_interface.attribute12%TYPE,

104: v_attribute8 fv_be_interface.attribute8%TYPE,
105: v_attribute9 fv_be_interface.attribute9%TYPE,
106: v_attribute10 fv_be_interface.attribute10%TYPE,
107: v_attribute11 fv_be_interface.attribute11%TYPE,
108: v_attribute12 fv_be_interface.attribute12%TYPE,
109: v_attribute13 fv_be_interface.attribute13%TYPE,
110: v_attribute14 fv_be_interface.attribute14%TYPE,
111: v_attribute15 fv_be_interface.attribute15%TYPE,
112: v_error_mesg OUT NOCOPY VARCHAR2

Line 109: v_attribute13 fv_be_interface.attribute13%TYPE,

105: v_attribute9 fv_be_interface.attribute9%TYPE,
106: v_attribute10 fv_be_interface.attribute10%TYPE,
107: v_attribute11 fv_be_interface.attribute11%TYPE,
108: v_attribute12 fv_be_interface.attribute12%TYPE,
109: v_attribute13 fv_be_interface.attribute13%TYPE,
110: v_attribute14 fv_be_interface.attribute14%TYPE,
111: v_attribute15 fv_be_interface.attribute15%TYPE,
112: v_error_mesg OUT NOCOPY VARCHAR2
113: );

Line 110: v_attribute14 fv_be_interface.attribute14%TYPE,

106: v_attribute10 fv_be_interface.attribute10%TYPE,
107: v_attribute11 fv_be_interface.attribute11%TYPE,
108: v_attribute12 fv_be_interface.attribute12%TYPE,
109: v_attribute13 fv_be_interface.attribute13%TYPE,
110: v_attribute14 fv_be_interface.attribute14%TYPE,
111: v_attribute15 fv_be_interface.attribute15%TYPE,
112: v_error_mesg OUT NOCOPY VARCHAR2
113: );
114:

Line 111: v_attribute15 fv_be_interface.attribute15%TYPE,

107: v_attribute11 fv_be_interface.attribute11%TYPE,
108: v_attribute12 fv_be_interface.attribute12%TYPE,
109: v_attribute13 fv_be_interface.attribute13%TYPE,
110: v_attribute14 fv_be_interface.attribute14%TYPE,
111: v_attribute15 fv_be_interface.attribute15%TYPE,
112: v_error_mesg OUT NOCOPY VARCHAR2
113: );
114:
115: --------------------------------------------------------------------------------

Line 133: -- fv_be_interface

129: l_table_stmt VARCHAR2(1000);
130: l_validation_type VARCHAR2(2);
131:
132: -- Cursor for selecting records from
133: -- fv_be_interface
134: -- BCPSA-BE Enhancement - Modified the cursor to get the Sub_Type instead of Transaction_Code
135: CURSOR int IS
136: SELECT rowid, set_of_books_id, gl_date, record_number,
137: budget_level_id, budgeting_segments, fund_value, doc_number,

Line 151: FROM fv_be_interface

147: attribute11, attribute12, attribute13, attribute14, attribute15,
148: source, group_id, corrected_flag, public_law_code, advance_type,
149: dept_id, main_account, transfer_description, attribute_category,
150: budget_user_id
151: FROM fv_be_interface
152: WHERE source = parm_source
153: AND group_id = parm_group_id
154: AND set_of_books_id = parm_ledger_id
155: AND status IN ('NEW','REJECTED','ACCEPTED')

Line 245: UPDATE fv_be_interface_control

241: parm_ledger_id := ledger_id;
242:
243: -- Update the control table with the
244: -- appropriate status
245: UPDATE fv_be_interface_control
246: SET status = 'IN PROCESS',
247: date_processed = SYSDATE
248: WHERE source = parm_source
249: AND group_id = parm_group_id

Line 259: FROM fv_be_interface

255: -- for the source and group_id parameter. If there are no records found
256: -- for this source and group_id then error and return
257: SELECT count(*)
258: INTO v_interface_count
259: FROM fv_be_interface
260: WHERE source = parm_source
261: AND group_id = parm_group_id
262: AND set_of_books_id = parm_ledger_id
263: AND status IN ('NEW', 'REJECTED','ACCEPTED');

Line 287: UPDATE fv_be_interface

283:
284:
285: -- Reset the error_code
286: -- and error_reason to null
287: UPDATE fv_be_interface
288: SET error_code = NULL,
289: error_reason = NULL
290: WHERE source = parm_source
291: AND group_id = parm_group_id

Line 1051: UPDATE fv_be_interface

1047: -------------------------------------------------------------------------------
1048: -- Since no more validations are needed, update
1049: -- the status of this record to accepted,
1050: -- exit the loop and go to next rec, if any
1051: UPDATE fv_be_interface
1052: SET status = 'ACCEPTED',
1053: processed_flag = 'Y'
1054: WHERE rowid = int_rec.rowid ;
1055:

Line 1073: FROM fv_be_interface

1069: v_rej_rec_count := 0;
1070:
1071: SELECT count(*)
1072: INTO v_rej_rec_count
1073: FROM fv_be_interface
1074: WHERE group_id = parm_group_id
1075: AND source = parm_source
1076: AND set_of_books_id = parm_ledger_id
1077: AND status = 'REJECTED';

Line 1789: -- fv_be_interface table

1785: --------------------------------------------------------------------------------
1786: -- Procedures being used by the above code
1787: --------------------------------------------------------------------------------
1788: -- Procedure to update error records in the
1789: -- fv_be_interface table
1790: PROCEDURE update_err_code(l_rowid VARCHAR2, l_err_code VARCHAR2,
1791: l_err_reason VARCHAR2) IS
1792: l_module_name VARCHAR2(200);
1793: BEGIN

Line 1795: UPDATE fv_be_interface

1791: l_err_reason VARCHAR2) IS
1792: l_module_name VARCHAR2(200);
1793: BEGIN
1794: l_module_name := g_module_name || 'update_err_code';
1795: UPDATE fv_be_interface
1796: SET error_code = l_err_code,
1797: error_reason = l_err_reason,
1798: status = 'REJECTED',
1799: processed_flag = 'Y'

Line 2208: v_attribute_category fv_be_interface.attribute_category%TYPE,

2204: --------------------------------------------------------------------------------
2205: -- Procedure to validate DFF
2206: PROCEDURE validate_dff
2207: (
2208: v_attribute_category fv_be_interface.attribute_category%TYPE,
2209: v_attribute1 fv_be_interface.attribute1%TYPE,
2210: v_attribute2 fv_be_interface.attribute2%TYPE,
2211: v_attribute3 fv_be_interface.attribute3%TYPE,
2212: v_attribute4 fv_be_interface.attribute4%TYPE,

Line 2209: v_attribute1 fv_be_interface.attribute1%TYPE,

2205: -- Procedure to validate DFF
2206: PROCEDURE validate_dff
2207: (
2208: v_attribute_category fv_be_interface.attribute_category%TYPE,
2209: v_attribute1 fv_be_interface.attribute1%TYPE,
2210: v_attribute2 fv_be_interface.attribute2%TYPE,
2211: v_attribute3 fv_be_interface.attribute3%TYPE,
2212: v_attribute4 fv_be_interface.attribute4%TYPE,
2213: v_attribute5 fv_be_interface.attribute5%TYPE,

Line 2210: v_attribute2 fv_be_interface.attribute2%TYPE,

2206: PROCEDURE validate_dff
2207: (
2208: v_attribute_category fv_be_interface.attribute_category%TYPE,
2209: v_attribute1 fv_be_interface.attribute1%TYPE,
2210: v_attribute2 fv_be_interface.attribute2%TYPE,
2211: v_attribute3 fv_be_interface.attribute3%TYPE,
2212: v_attribute4 fv_be_interface.attribute4%TYPE,
2213: v_attribute5 fv_be_interface.attribute5%TYPE,
2214: v_attribute6 fv_be_interface.attribute6%TYPE,

Line 2211: v_attribute3 fv_be_interface.attribute3%TYPE,

2207: (
2208: v_attribute_category fv_be_interface.attribute_category%TYPE,
2209: v_attribute1 fv_be_interface.attribute1%TYPE,
2210: v_attribute2 fv_be_interface.attribute2%TYPE,
2211: v_attribute3 fv_be_interface.attribute3%TYPE,
2212: v_attribute4 fv_be_interface.attribute4%TYPE,
2213: v_attribute5 fv_be_interface.attribute5%TYPE,
2214: v_attribute6 fv_be_interface.attribute6%TYPE,
2215: v_attribute7 fv_be_interface.attribute7%TYPE,

Line 2212: v_attribute4 fv_be_interface.attribute4%TYPE,

2208: v_attribute_category fv_be_interface.attribute_category%TYPE,
2209: v_attribute1 fv_be_interface.attribute1%TYPE,
2210: v_attribute2 fv_be_interface.attribute2%TYPE,
2211: v_attribute3 fv_be_interface.attribute3%TYPE,
2212: v_attribute4 fv_be_interface.attribute4%TYPE,
2213: v_attribute5 fv_be_interface.attribute5%TYPE,
2214: v_attribute6 fv_be_interface.attribute6%TYPE,
2215: v_attribute7 fv_be_interface.attribute7%TYPE,
2216: v_attribute8 fv_be_interface.attribute8%TYPE,

Line 2213: v_attribute5 fv_be_interface.attribute5%TYPE,

2209: v_attribute1 fv_be_interface.attribute1%TYPE,
2210: v_attribute2 fv_be_interface.attribute2%TYPE,
2211: v_attribute3 fv_be_interface.attribute3%TYPE,
2212: v_attribute4 fv_be_interface.attribute4%TYPE,
2213: v_attribute5 fv_be_interface.attribute5%TYPE,
2214: v_attribute6 fv_be_interface.attribute6%TYPE,
2215: v_attribute7 fv_be_interface.attribute7%TYPE,
2216: v_attribute8 fv_be_interface.attribute8%TYPE,
2217: v_attribute9 fv_be_interface.attribute9%TYPE,

Line 2214: v_attribute6 fv_be_interface.attribute6%TYPE,

2210: v_attribute2 fv_be_interface.attribute2%TYPE,
2211: v_attribute3 fv_be_interface.attribute3%TYPE,
2212: v_attribute4 fv_be_interface.attribute4%TYPE,
2213: v_attribute5 fv_be_interface.attribute5%TYPE,
2214: v_attribute6 fv_be_interface.attribute6%TYPE,
2215: v_attribute7 fv_be_interface.attribute7%TYPE,
2216: v_attribute8 fv_be_interface.attribute8%TYPE,
2217: v_attribute9 fv_be_interface.attribute9%TYPE,
2218: v_attribute10 fv_be_interface.attribute10%TYPE,

Line 2215: v_attribute7 fv_be_interface.attribute7%TYPE,

2211: v_attribute3 fv_be_interface.attribute3%TYPE,
2212: v_attribute4 fv_be_interface.attribute4%TYPE,
2213: v_attribute5 fv_be_interface.attribute5%TYPE,
2214: v_attribute6 fv_be_interface.attribute6%TYPE,
2215: v_attribute7 fv_be_interface.attribute7%TYPE,
2216: v_attribute8 fv_be_interface.attribute8%TYPE,
2217: v_attribute9 fv_be_interface.attribute9%TYPE,
2218: v_attribute10 fv_be_interface.attribute10%TYPE,
2219: v_attribute11 fv_be_interface.attribute11%TYPE,

Line 2216: v_attribute8 fv_be_interface.attribute8%TYPE,

2212: v_attribute4 fv_be_interface.attribute4%TYPE,
2213: v_attribute5 fv_be_interface.attribute5%TYPE,
2214: v_attribute6 fv_be_interface.attribute6%TYPE,
2215: v_attribute7 fv_be_interface.attribute7%TYPE,
2216: v_attribute8 fv_be_interface.attribute8%TYPE,
2217: v_attribute9 fv_be_interface.attribute9%TYPE,
2218: v_attribute10 fv_be_interface.attribute10%TYPE,
2219: v_attribute11 fv_be_interface.attribute11%TYPE,
2220: v_attribute12 fv_be_interface.attribute12%TYPE,

Line 2217: v_attribute9 fv_be_interface.attribute9%TYPE,

2213: v_attribute5 fv_be_interface.attribute5%TYPE,
2214: v_attribute6 fv_be_interface.attribute6%TYPE,
2215: v_attribute7 fv_be_interface.attribute7%TYPE,
2216: v_attribute8 fv_be_interface.attribute8%TYPE,
2217: v_attribute9 fv_be_interface.attribute9%TYPE,
2218: v_attribute10 fv_be_interface.attribute10%TYPE,
2219: v_attribute11 fv_be_interface.attribute11%TYPE,
2220: v_attribute12 fv_be_interface.attribute12%TYPE,
2221: v_attribute13 fv_be_interface.attribute13%TYPE,

Line 2218: v_attribute10 fv_be_interface.attribute10%TYPE,

2214: v_attribute6 fv_be_interface.attribute6%TYPE,
2215: v_attribute7 fv_be_interface.attribute7%TYPE,
2216: v_attribute8 fv_be_interface.attribute8%TYPE,
2217: v_attribute9 fv_be_interface.attribute9%TYPE,
2218: v_attribute10 fv_be_interface.attribute10%TYPE,
2219: v_attribute11 fv_be_interface.attribute11%TYPE,
2220: v_attribute12 fv_be_interface.attribute12%TYPE,
2221: v_attribute13 fv_be_interface.attribute13%TYPE,
2222: v_attribute14 fv_be_interface.attribute14%TYPE,

Line 2219: v_attribute11 fv_be_interface.attribute11%TYPE,

2215: v_attribute7 fv_be_interface.attribute7%TYPE,
2216: v_attribute8 fv_be_interface.attribute8%TYPE,
2217: v_attribute9 fv_be_interface.attribute9%TYPE,
2218: v_attribute10 fv_be_interface.attribute10%TYPE,
2219: v_attribute11 fv_be_interface.attribute11%TYPE,
2220: v_attribute12 fv_be_interface.attribute12%TYPE,
2221: v_attribute13 fv_be_interface.attribute13%TYPE,
2222: v_attribute14 fv_be_interface.attribute14%TYPE,
2223: v_attribute15 fv_be_interface.attribute15%TYPE,

Line 2220: v_attribute12 fv_be_interface.attribute12%TYPE,

2216: v_attribute8 fv_be_interface.attribute8%TYPE,
2217: v_attribute9 fv_be_interface.attribute9%TYPE,
2218: v_attribute10 fv_be_interface.attribute10%TYPE,
2219: v_attribute11 fv_be_interface.attribute11%TYPE,
2220: v_attribute12 fv_be_interface.attribute12%TYPE,
2221: v_attribute13 fv_be_interface.attribute13%TYPE,
2222: v_attribute14 fv_be_interface.attribute14%TYPE,
2223: v_attribute15 fv_be_interface.attribute15%TYPE,
2224: v_error_mesg OUT NOCOPY VARCHAR2

Line 2221: v_attribute13 fv_be_interface.attribute13%TYPE,

2217: v_attribute9 fv_be_interface.attribute9%TYPE,
2218: v_attribute10 fv_be_interface.attribute10%TYPE,
2219: v_attribute11 fv_be_interface.attribute11%TYPE,
2220: v_attribute12 fv_be_interface.attribute12%TYPE,
2221: v_attribute13 fv_be_interface.attribute13%TYPE,
2222: v_attribute14 fv_be_interface.attribute14%TYPE,
2223: v_attribute15 fv_be_interface.attribute15%TYPE,
2224: v_error_mesg OUT NOCOPY VARCHAR2
2225: ) IS

Line 2222: v_attribute14 fv_be_interface.attribute14%TYPE,

2218: v_attribute10 fv_be_interface.attribute10%TYPE,
2219: v_attribute11 fv_be_interface.attribute11%TYPE,
2220: v_attribute12 fv_be_interface.attribute12%TYPE,
2221: v_attribute13 fv_be_interface.attribute13%TYPE,
2222: v_attribute14 fv_be_interface.attribute14%TYPE,
2223: v_attribute15 fv_be_interface.attribute15%TYPE,
2224: v_error_mesg OUT NOCOPY VARCHAR2
2225: ) IS
2226:

Line 2223: v_attribute15 fv_be_interface.attribute15%TYPE,

2219: v_attribute11 fv_be_interface.attribute11%TYPE,
2220: v_attribute12 fv_be_interface.attribute12%TYPE,
2221: v_attribute13 fv_be_interface.attribute13%TYPE,
2222: v_attribute14 fv_be_interface.attribute14%TYPE,
2223: v_attribute15 fv_be_interface.attribute15%TYPE,
2224: v_error_mesg OUT NOCOPY VARCHAR2
2225: ) IS
2226:
2227: l_module_name VARCHAR2(200);

Line 2307: 'UPDATE fv_be_interface

2303: lv_stmt := NULL;
2304:
2305: IF lv_seg_type = 'D' THEN
2306: lv_stmt :=
2307: 'UPDATE fv_be_interface
2308: SET '||app_col_name.application_column_name||
2309: ' = '||''''||lv_seg_value||''''||
2310: ' WHERE rowid = :rowid ';
2311:

Line 2425: UPDATE fv_be_interface_control

2421:
2422: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2423: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'UPDATING STATUS IN CONTROL TABLE');
2424: END IF;
2425: UPDATE fv_be_interface_control
2426: SET status = 'IMPORTED'
2427: WHERE source = parm_source
2428: AND group_id = parm_group_id;
2429:

Line 2438: INSERT INTO fv_be_interface_history

2434: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2435: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'INSERTING INTO HISTORY TABLE');
2436: END IF;
2437:
2438: INSERT INTO fv_be_interface_history
2439: (record_number, set_of_books_id, source, group_id, error_code,
2440: error_reason, budget_level_id,
2441: budgeting_segments, transaction_type, sub_type,
2442: fund_value, period_name, segment1, segment2, segment3,

Line 2476: FROM fv_be_interface

2472: date_created, created_by, corrected_flag, sysdate,
2473: fnd_global.user_id, public_law_code, advance_type,
2474: dept_id, main_account, transfer_description,budget_user_id,
2475: gl_date
2476: FROM fv_be_interface
2477: WHERE source = parm_source
2478: AND group_id = parm_group_id
2479: AND set_of_books_id = parm_ledger_id
2480: AND status = 'ACCEPTED'

Line 2487: DELETE FROM fv_be_interface

2483:
2484: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2485: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'DELETING FROM BE_INTERFACE');
2486: END IF;
2487: DELETE FROM fv_be_interface
2488: WHERE source = parm_source
2489: AND group_id = parm_group_id
2490: AND set_of_books_id = parm_ledger_id
2491: AND status = 'ACCEPTED'

Line 2513: UPDATE fv_be_interface

2509: l_module_name VARCHAR2(200);
2510: BEGIN
2511: l_module_name := g_module_name || 'update_err_rec';
2512:
2513: UPDATE fv_be_interface
2514: -- SET status = 'REJECTED',
2515: SET status = 'ACCEPTED',
2516: error_code = 'EM42',
2517: error_reason = 'Budgeting Segments do not exist for

Line 2541: UPDATE fv_be_interface_control

2537: l_module_name := g_module_name || 'reset_control_status';
2538: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2539: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RESETTING STATUS IN THE CONTROL TABLE');
2540: END IF;
2541: UPDATE fv_be_interface_control
2542: SET status = 'REJECTED'
2543: WHERE source = parm_source
2544: AND group_id = parm_group_id;
2545: COMMIT;