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 97: v_attribute_category fv_be_interface.attribute_category%TYPE,

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

Line 98: v_attribute1 fv_be_interface.attribute1%TYPE,

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

Line 99: v_attribute2 fv_be_interface.attribute2%TYPE,

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

Line 100: v_attribute3 fv_be_interface.attribute3%TYPE,

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

Line 101: v_attribute4 fv_be_interface.attribute4%TYPE,

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

Line 102: v_attribute5 fv_be_interface.attribute5%TYPE,

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

Line 103: v_attribute6 fv_be_interface.attribute6%TYPE,

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

Line 104: v_attribute7 fv_be_interface.attribute7%TYPE,

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

Line 105: v_attribute8 fv_be_interface.attribute8%TYPE,

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

Line 106: v_attribute9 fv_be_interface.attribute9%TYPE,

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

Line 107: v_attribute10 fv_be_interface.attribute10%TYPE,

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

Line 108: v_attribute11 fv_be_interface.attribute11%TYPE,

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

Line 109: v_attribute12 fv_be_interface.attribute12%TYPE,

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

Line 110: v_attribute13 fv_be_interface.attribute13%TYPE,

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

Line 111: v_attribute14 fv_be_interface.attribute14%TYPE,

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

Line 112: v_attribute15 fv_be_interface.attribute15%TYPE,

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

Line 134: -- fv_be_interface

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

Line 152: FROM fv_be_interface

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

Line 250: UPDATE fv_be_interface_control

246: parm_ledger_id := ledger_id;
247:
248: -- Update the control table with the
249: -- appropriate status
250: UPDATE fv_be_interface_control
251: SET status = 'IN PROCESS',
252: date_processed = SYSDATE
253: WHERE source = parm_source
254: AND group_id = parm_group_id

Line 264: FROM fv_be_interface

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

Line 294: UPDATE fv_be_interface

290:
291:
292: -- Reset the error_code
293: -- and error_reason to null
294: UPDATE fv_be_interface
295: SET error_code = NULL,
296: error_reason = NULL
297: WHERE source = parm_source
298: AND group_id = parm_group_id

Line 1117: UPDATE fv_be_interface

1113: -------------------------------------------------------------------------------
1114: -- Since no more validations are needed, update
1115: -- the status of this record to accepted,
1116: -- exit the loop and go to next rec, if any
1117: UPDATE fv_be_interface
1118: SET status = 'ACCEPTED',
1119: processed_flag = 'Y'
1120: WHERE rowid = int_rec.rowid ;
1121:

Line 1139: FROM fv_be_interface

1135: v_rej_rec_count := 0;
1136:
1137: SELECT count(*)
1138: INTO v_rej_rec_count
1139: FROM fv_be_interface
1140: WHERE group_id = parm_group_id
1141: AND source = parm_source
1142: AND set_of_books_id = parm_ledger_id
1143: AND status = 'REJECTED';

Line 1876: -- fv_be_interface table

1872: --------------------------------------------------------------------------------
1873: -- Procedures being used by the above code
1874: --------------------------------------------------------------------------------
1875: -- Procedure to update error records in the
1876: -- fv_be_interface table
1877: PROCEDURE update_err_code(l_rowid VARCHAR2, l_err_code VARCHAR2,
1878: l_err_reason VARCHAR2) IS
1879: l_module_name VARCHAR2(200);
1880: BEGIN

Line 1882: UPDATE fv_be_interface

1878: l_err_reason VARCHAR2) IS
1879: l_module_name VARCHAR2(200);
1880: BEGIN
1881: l_module_name := g_module_name || 'update_err_code';
1882: UPDATE fv_be_interface
1883: SET error_code = l_err_code,
1884: error_reason = l_err_reason,
1885: status = 'REJECTED',
1886: processed_flag = 'Y'

Line 2299: v_attribute_category fv_be_interface.attribute_category%TYPE,

2295: --------------------------------------------------------------------------------
2296: -- Procedure to validate DFF
2297: PROCEDURE validate_dff
2298: (
2299: v_attribute_category fv_be_interface.attribute_category%TYPE,
2300: v_attribute1 fv_be_interface.attribute1%TYPE,
2301: v_attribute2 fv_be_interface.attribute2%TYPE,
2302: v_attribute3 fv_be_interface.attribute3%TYPE,
2303: v_attribute4 fv_be_interface.attribute4%TYPE,

Line 2300: v_attribute1 fv_be_interface.attribute1%TYPE,

2296: -- Procedure to validate DFF
2297: PROCEDURE validate_dff
2298: (
2299: v_attribute_category fv_be_interface.attribute_category%TYPE,
2300: v_attribute1 fv_be_interface.attribute1%TYPE,
2301: v_attribute2 fv_be_interface.attribute2%TYPE,
2302: v_attribute3 fv_be_interface.attribute3%TYPE,
2303: v_attribute4 fv_be_interface.attribute4%TYPE,
2304: v_attribute5 fv_be_interface.attribute5%TYPE,

Line 2301: v_attribute2 fv_be_interface.attribute2%TYPE,

2297: PROCEDURE validate_dff
2298: (
2299: v_attribute_category fv_be_interface.attribute_category%TYPE,
2300: v_attribute1 fv_be_interface.attribute1%TYPE,
2301: v_attribute2 fv_be_interface.attribute2%TYPE,
2302: v_attribute3 fv_be_interface.attribute3%TYPE,
2303: v_attribute4 fv_be_interface.attribute4%TYPE,
2304: v_attribute5 fv_be_interface.attribute5%TYPE,
2305: v_attribute6 fv_be_interface.attribute6%TYPE,

Line 2302: v_attribute3 fv_be_interface.attribute3%TYPE,

2298: (
2299: v_attribute_category fv_be_interface.attribute_category%TYPE,
2300: v_attribute1 fv_be_interface.attribute1%TYPE,
2301: v_attribute2 fv_be_interface.attribute2%TYPE,
2302: v_attribute3 fv_be_interface.attribute3%TYPE,
2303: v_attribute4 fv_be_interface.attribute4%TYPE,
2304: v_attribute5 fv_be_interface.attribute5%TYPE,
2305: v_attribute6 fv_be_interface.attribute6%TYPE,
2306: v_attribute7 fv_be_interface.attribute7%TYPE,

Line 2303: v_attribute4 fv_be_interface.attribute4%TYPE,

2299: v_attribute_category fv_be_interface.attribute_category%TYPE,
2300: v_attribute1 fv_be_interface.attribute1%TYPE,
2301: v_attribute2 fv_be_interface.attribute2%TYPE,
2302: v_attribute3 fv_be_interface.attribute3%TYPE,
2303: v_attribute4 fv_be_interface.attribute4%TYPE,
2304: v_attribute5 fv_be_interface.attribute5%TYPE,
2305: v_attribute6 fv_be_interface.attribute6%TYPE,
2306: v_attribute7 fv_be_interface.attribute7%TYPE,
2307: v_attribute8 fv_be_interface.attribute8%TYPE,

Line 2304: v_attribute5 fv_be_interface.attribute5%TYPE,

2300: v_attribute1 fv_be_interface.attribute1%TYPE,
2301: v_attribute2 fv_be_interface.attribute2%TYPE,
2302: v_attribute3 fv_be_interface.attribute3%TYPE,
2303: v_attribute4 fv_be_interface.attribute4%TYPE,
2304: v_attribute5 fv_be_interface.attribute5%TYPE,
2305: v_attribute6 fv_be_interface.attribute6%TYPE,
2306: v_attribute7 fv_be_interface.attribute7%TYPE,
2307: v_attribute8 fv_be_interface.attribute8%TYPE,
2308: v_attribute9 fv_be_interface.attribute9%TYPE,

Line 2305: v_attribute6 fv_be_interface.attribute6%TYPE,

2301: v_attribute2 fv_be_interface.attribute2%TYPE,
2302: v_attribute3 fv_be_interface.attribute3%TYPE,
2303: v_attribute4 fv_be_interface.attribute4%TYPE,
2304: v_attribute5 fv_be_interface.attribute5%TYPE,
2305: v_attribute6 fv_be_interface.attribute6%TYPE,
2306: v_attribute7 fv_be_interface.attribute7%TYPE,
2307: v_attribute8 fv_be_interface.attribute8%TYPE,
2308: v_attribute9 fv_be_interface.attribute9%TYPE,
2309: v_attribute10 fv_be_interface.attribute10%TYPE,

Line 2306: v_attribute7 fv_be_interface.attribute7%TYPE,

2302: v_attribute3 fv_be_interface.attribute3%TYPE,
2303: v_attribute4 fv_be_interface.attribute4%TYPE,
2304: v_attribute5 fv_be_interface.attribute5%TYPE,
2305: v_attribute6 fv_be_interface.attribute6%TYPE,
2306: v_attribute7 fv_be_interface.attribute7%TYPE,
2307: v_attribute8 fv_be_interface.attribute8%TYPE,
2308: v_attribute9 fv_be_interface.attribute9%TYPE,
2309: v_attribute10 fv_be_interface.attribute10%TYPE,
2310: v_attribute11 fv_be_interface.attribute11%TYPE,

Line 2307: v_attribute8 fv_be_interface.attribute8%TYPE,

2303: v_attribute4 fv_be_interface.attribute4%TYPE,
2304: v_attribute5 fv_be_interface.attribute5%TYPE,
2305: v_attribute6 fv_be_interface.attribute6%TYPE,
2306: v_attribute7 fv_be_interface.attribute7%TYPE,
2307: v_attribute8 fv_be_interface.attribute8%TYPE,
2308: v_attribute9 fv_be_interface.attribute9%TYPE,
2309: v_attribute10 fv_be_interface.attribute10%TYPE,
2310: v_attribute11 fv_be_interface.attribute11%TYPE,
2311: v_attribute12 fv_be_interface.attribute12%TYPE,

Line 2308: v_attribute9 fv_be_interface.attribute9%TYPE,

2304: v_attribute5 fv_be_interface.attribute5%TYPE,
2305: v_attribute6 fv_be_interface.attribute6%TYPE,
2306: v_attribute7 fv_be_interface.attribute7%TYPE,
2307: v_attribute8 fv_be_interface.attribute8%TYPE,
2308: v_attribute9 fv_be_interface.attribute9%TYPE,
2309: v_attribute10 fv_be_interface.attribute10%TYPE,
2310: v_attribute11 fv_be_interface.attribute11%TYPE,
2311: v_attribute12 fv_be_interface.attribute12%TYPE,
2312: v_attribute13 fv_be_interface.attribute13%TYPE,

Line 2309: v_attribute10 fv_be_interface.attribute10%TYPE,

2305: v_attribute6 fv_be_interface.attribute6%TYPE,
2306: v_attribute7 fv_be_interface.attribute7%TYPE,
2307: v_attribute8 fv_be_interface.attribute8%TYPE,
2308: v_attribute9 fv_be_interface.attribute9%TYPE,
2309: v_attribute10 fv_be_interface.attribute10%TYPE,
2310: v_attribute11 fv_be_interface.attribute11%TYPE,
2311: v_attribute12 fv_be_interface.attribute12%TYPE,
2312: v_attribute13 fv_be_interface.attribute13%TYPE,
2313: v_attribute14 fv_be_interface.attribute14%TYPE,

Line 2310: v_attribute11 fv_be_interface.attribute11%TYPE,

2306: v_attribute7 fv_be_interface.attribute7%TYPE,
2307: v_attribute8 fv_be_interface.attribute8%TYPE,
2308: v_attribute9 fv_be_interface.attribute9%TYPE,
2309: v_attribute10 fv_be_interface.attribute10%TYPE,
2310: v_attribute11 fv_be_interface.attribute11%TYPE,
2311: v_attribute12 fv_be_interface.attribute12%TYPE,
2312: v_attribute13 fv_be_interface.attribute13%TYPE,
2313: v_attribute14 fv_be_interface.attribute14%TYPE,
2314: v_attribute15 fv_be_interface.attribute15%TYPE,

Line 2311: v_attribute12 fv_be_interface.attribute12%TYPE,

2307: v_attribute8 fv_be_interface.attribute8%TYPE,
2308: v_attribute9 fv_be_interface.attribute9%TYPE,
2309: v_attribute10 fv_be_interface.attribute10%TYPE,
2310: v_attribute11 fv_be_interface.attribute11%TYPE,
2311: v_attribute12 fv_be_interface.attribute12%TYPE,
2312: v_attribute13 fv_be_interface.attribute13%TYPE,
2313: v_attribute14 fv_be_interface.attribute14%TYPE,
2314: v_attribute15 fv_be_interface.attribute15%TYPE,
2315: v_error_mesg OUT NOCOPY VARCHAR2

Line 2312: v_attribute13 fv_be_interface.attribute13%TYPE,

2308: v_attribute9 fv_be_interface.attribute9%TYPE,
2309: v_attribute10 fv_be_interface.attribute10%TYPE,
2310: v_attribute11 fv_be_interface.attribute11%TYPE,
2311: v_attribute12 fv_be_interface.attribute12%TYPE,
2312: v_attribute13 fv_be_interface.attribute13%TYPE,
2313: v_attribute14 fv_be_interface.attribute14%TYPE,
2314: v_attribute15 fv_be_interface.attribute15%TYPE,
2315: v_error_mesg OUT NOCOPY VARCHAR2
2316: ) IS

Line 2313: v_attribute14 fv_be_interface.attribute14%TYPE,

2309: v_attribute10 fv_be_interface.attribute10%TYPE,
2310: v_attribute11 fv_be_interface.attribute11%TYPE,
2311: v_attribute12 fv_be_interface.attribute12%TYPE,
2312: v_attribute13 fv_be_interface.attribute13%TYPE,
2313: v_attribute14 fv_be_interface.attribute14%TYPE,
2314: v_attribute15 fv_be_interface.attribute15%TYPE,
2315: v_error_mesg OUT NOCOPY VARCHAR2
2316: ) IS
2317:

Line 2314: v_attribute15 fv_be_interface.attribute15%TYPE,

2310: v_attribute11 fv_be_interface.attribute11%TYPE,
2311: v_attribute12 fv_be_interface.attribute12%TYPE,
2312: v_attribute13 fv_be_interface.attribute13%TYPE,
2313: v_attribute14 fv_be_interface.attribute14%TYPE,
2314: v_attribute15 fv_be_interface.attribute15%TYPE,
2315: v_error_mesg OUT NOCOPY VARCHAR2
2316: ) IS
2317:
2318: l_module_name VARCHAR2(200);

Line 2398: 'UPDATE fv_be_interface

2394: lv_stmt := NULL;
2395:
2396: IF lv_seg_type = 'D' THEN
2397: lv_stmt :=
2398: 'UPDATE fv_be_interface
2399: SET '||app_col_name.application_column_name||
2400: ' = '||''''||lv_seg_value||''''||
2401: ' WHERE rowid = :rowid ';
2402:

Line 2516: UPDATE fv_be_interface_control

2512:
2513: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2514: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'UPDATING STATUS IN CONTROL TABLE');
2515: END IF;
2516: UPDATE fv_be_interface_control
2517: SET status = 'IMPORTED'
2518: WHERE source = parm_source
2519: AND group_id = parm_group_id;
2520:

Line 2529: INSERT INTO fv_be_interface_history

2525: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2526: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'INSERTING INTO HISTORY TABLE');
2527: END IF;
2528:
2529: INSERT INTO fv_be_interface_history
2530: (record_number, set_of_books_id, source, group_id, error_code,
2531: error_reason, budget_level_id,
2532: budgeting_segments, transaction_type, sub_type,
2533: fund_value, period_name, segment1, segment2, segment3,

Line 2567: FROM fv_be_interface

2563: date_created, created_by, corrected_flag, sysdate,
2564: fnd_global.user_id, public_law_code, advance_type,
2565: dept_id, main_account, transfer_description,budget_user_id,
2566: gl_date
2567: FROM fv_be_interface
2568: WHERE source = parm_source
2569: AND group_id = parm_group_id
2570: AND set_of_books_id = parm_ledger_id
2571: AND status = 'ACCEPTED'

Line 2578: DELETE FROM fv_be_interface

2574:
2575: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2576: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'DELETING FROM BE_INTERFACE');
2577: END IF;
2578: DELETE FROM fv_be_interface
2579: WHERE source = parm_source
2580: AND group_id = parm_group_id
2581: AND set_of_books_id = parm_ledger_id
2582: AND status = 'ACCEPTED'

Line 2604: UPDATE fv_be_interface

2600: l_module_name VARCHAR2(200);
2601: BEGIN
2602: l_module_name := g_module_name || 'update_err_rec';
2603:
2604: UPDATE fv_be_interface
2605: -- SET status = 'REJECTED',
2606: SET status = 'ACCEPTED',
2607: error_code = 'EM42',
2608: error_reason = 'Budgeting Segments do not exist for

Line 2632: UPDATE fv_be_interface_control

2628: l_module_name := g_module_name || 'reset_control_status';
2629: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2630: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RESETTING STATUS IN THE CONTROL TABLE');
2631: END IF;
2632: UPDATE fv_be_interface_control
2633: SET status = 'REJECTED'
2634: WHERE source = parm_source
2635: AND group_id = parm_group_id;
2636: