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.

[Home] [Help]

APPS.EGO_FUNCTIONS_BULKLOAD_PVT dependencies on EGO_FUNCTIONS_B

Line 1: PACKAGE BODY EGO_FUNCTIONS_BULKLOAD_PVT AS

1: PACKAGE BODY EGO_FUNCTIONS_BULKLOAD_PVT AS
2: /* $Header: EGOVFNBB.pls 120.0.12010000.7 2010/05/17 12:48:59 snandana noship $ */
3:
4: ---------------------------------------------------------------------------------------------
5: -- Procedure Name: write_debug --

Line 139: FROM ego_functions_b

135: invalid_function_id := 0;
136:
137: SELECT internal_name
138: INTO func_header_rec.internal_name
139: FROM ego_functions_b
140: WHERE ( function_id = func_header_rec.function_id );
141: EXCEPTION
142: WHEN no_data_found THEN
143: invalid_function_id := 1;

Line 174: FROM ego_functions_b

170: invalid_internal_name := 0;
171:
172: SELECT function_id
173: INTO func_header_rec.function_id
174: FROM ego_functions_b
175: WHERE ( internal_name = func_header_rec.internal_name );
176: EXCEPTION
177: WHEN no_data_found THEN
178: invalid_internal_name := 1;

Line 231: temporary_record ego_functions_b%ROWTYPE;

227: -- IN OUT --
228: -- func_header_rec - Represents a row of type ego_functions_interface%ROWTYPE. --
229: ---------------------------------------------------------------------------------------------
230: PROCEDURE validate_function(func_header_rec IN OUT NOCOPY ego_functions_interface%ROWTYPE) IS
231: temporary_record ego_functions_b%ROWTYPE;
232: temporary_record_tl ego_functions_tl%ROWTYPE;
233: valid_function_type NUMBER(1);
234: duplicate_internal_name NUMBER(1);
235: function_is_used NUMBER(1);

Line 302: FROM ego_functions_b

298: /* 3. Make sure that Function Internal Name is unique. */
299: BEGIN
300: SELECT 1
301: INTO duplicate_internal_name
302: FROM ego_functions_b
303: WHERE ( internal_name = func_header_rec.internal_name );
304: EXCEPTION
305: WHEN no_data_found THEN
306: duplicate_internal_name := 0;

Line 332: FROM ego_functions_b

328: AND func_header_rec.process_status <> G_ERROR_RECORD ) THEN
329: /* Fetch the existing data from base tables and merge it with interface table row func_header_rec. */
330: SELECT *
331: INTO temporary_record
332: FROM ego_functions_b
333: WHERE ( function_id = func_header_rec.function_id );
334:
335: SELECT *
336: INTO temporary_record_tl

Line 478: INSERT INTO ego_functions_b

474: SELECT ego_functions_s.nextval
475: INTO func_header_rec.function_id
476: FROM dual;
477:
478: INSERT INTO ego_functions_b
479: (function_id,
480: internal_name,
481: function_type,
482: function_info_1,

Line 525: UPDATE ego_functions_b

521: FROM fnd_languages l
522: WHERE installed_flag IN ( 'I', 'B' );
523:
524: ELSIF ( func_header_rec.transaction_type = G_UPDATE_TRANSACTION ) THEN
525: UPDATE ego_functions_b
526: SET function_type = func_header_rec.function_type,
527: function_info_1 = func_header_rec.function_info_1,
528: function_info_2 = func_header_rec.function_info_2,
529: last_updated_by = G_USER_ID,

Line 544: DELETE ego_functions_b WHERE (function_id=func_header_rec.function_id);

540: WHERE ( function_id = func_header_rec.function_id )
541: AND Userenv('LANG') IN ( language, source_lang );
542:
543: ELSIF (func_header_rec.transaction_type = G_DELETE_TRANSACTION) THEN
544: DELETE ego_functions_b WHERE (function_id=func_header_rec.function_id);
545: DELETE ego_functions_tl WHERE (function_id=func_header_rec.function_id);
546: /* Bug 9647937. Delete rows from ego_func_params_tl table, before deleting rows from
547: ego_func_params_b table. */
548: DELETE ego_func_params_tl WHERE func_param_id IN (SELECT func_param_id FROM ego_func_params_b

Line 819: FROM ego_functions_b b

815: SYSDATE
816: FROM ego_functions_interface i
817: WHERE transaction_type IN ( G_UPDATE_TRANSACTION, G_DELETE_TRANSACTION )
818: AND NOT EXISTS (SELECT function_id
819: FROM ego_functions_b b
820: WHERE ( b.function_id = i.function_id ))
821: AND function_id IS NOT NULL
822: AND (p_set_process_id IS NULL OR set_process_id = p_set_process_id)
823: AND process_status = G_PROCESS_RECORD;

Line 829: FROM ego_functions_b b

825: UPDATE ego_functions_interface i
826: SET process_status = G_ERROR_RECORD,last_update_date=sysdate, last_updated_by=G_USER_ID,program_update_date=SYSDATE
827: WHERE transaction_type IN ( G_UPDATE_TRANSACTION, G_DELETE_TRANSACTION )
828: AND NOT EXISTS (SELECT *
829: FROM ego_functions_b b
830: WHERE ( b.function_id = i.function_id ))
831: AND function_id IS NOT NULL
832: AND (p_set_process_id IS NULL OR set_process_id = p_set_process_id)
833: AND process_status = G_PROCESS_RECORD;

Line 879: FROM ego_functions_b b

875: SYSDATE
876: FROM ego_functions_interface i
877: WHERE transaction_type IN ( G_UPDATE_TRANSACTION, G_DELETE_TRANSACTION )
878: AND NOT EXISTS (SELECT internal_name
879: FROM ego_functions_b b
880: WHERE ( b.internal_name = i.internal_name )
881: UNION
882: SELECT internal_name
883: FROM ego_functions_interface ii

Line 897: FROM ego_functions_b b

893: UPDATE ego_functions_interface i
894: SET process_status = G_ERROR_RECORD, last_update_date=sysdate, last_updated_by=G_USER_ID,program_update_date=SYSDATE
895: WHERE transaction_type IN ( G_UPDATE_TRANSACTION, G_DELETE_TRANSACTION )
896: AND NOT EXISTS (SELECT internal_name
897: FROM ego_functions_b b
898: WHERE ( b.internal_name = i.internal_name )
899: UNION
900: SELECT internal_name
901: FROM ego_functions_interface ii

Line 1014: FROM ego_functions_b

1010: invalid_function_id := 0;
1011:
1012: SELECT internal_name
1013: INTO func_param_rec.function_internal_name
1014: FROM ego_functions_b
1015: WHERE ( function_id = func_param_rec.function_id );
1016: EXCEPTION
1017: WHEN no_data_found THEN
1018: invalid_function_id := 1;

Line 1042: FROM ego_functions_b

1038: invalid_function_internal_name := 0;
1039:
1040: SELECT function_id
1041: INTO func_param_rec.function_id
1042: FROM ego_functions_b
1043: WHERE ( internal_name = func_param_rec.function_internal_name );
1044: EXCEPTION
1045: WHEN no_data_found THEN
1046: invalid_function_internal_name := 1;

Line 1191: x_function_type ego_functions_b.function_type%TYPE;

1187: -- func_param_rec - Represents a row of type ego_func_params_interface%ROWTYPE. --
1188: ---------------------------------------------------------------------------------------------
1189: PROCEDURE validate_func_param(func_param_rec IN OUT NOCOPY ego_func_params_interface%ROWTYPE)
1190: IS
1191: x_function_type ego_functions_b.function_type%TYPE;
1192: x_lookup_code fnd_lookup_values.lookup_code%TYPE;
1193: valid_data_type NUMBER(1);
1194: valid_param_type NUMBER(1);
1195: duplicate_internal_name NUMBER(1);

Line 1208: FROM ego_functions_b

1204: AND func_param_rec.process_status <> G_ERROR_RECORD ) THEN
1205: /* 1. Validation for Data Type. */
1206: SELECT function_type
1207: INTO x_function_type
1208: FROM ego_functions_b
1209: WHERE ( function_id = func_param_rec.function_id );
1210:
1211: IF ( func_param_rec.data_type IS NOT NULL ) THEN
1212: IF ( x_function_type = 'P' ) THEN

Line 1853: FROM ego_functions_b b

1849: G_PROGRAM_ID,
1850: SYSDATE
1851: FROM ego_func_params_interface i
1852: WHERE NOT EXISTS (SELECT *
1853: FROM ego_functions_b b
1854: WHERE ( b.function_id = i.function_id ))
1855: AND function_id IS NOT NULL
1856: AND (p_set_process_id IS NULL OR set_process_id = p_set_process_id)
1857: AND process_status = G_PROCESS_RECORD;

Line 1862: FROM ego_functions_b b

1858:
1859: UPDATE ego_func_params_interface i
1860: SET process_status = G_ERROR_RECORD,last_update_date=sysdate, last_updated_by=G_USER_ID,program_update_date=SYSDATE
1861: WHERE NOT EXISTS (SELECT *
1862: FROM ego_functions_b b
1863: WHERE ( b.function_id = i.function_id ))
1864: AND function_id IS NOT NULL
1865: AND (p_set_process_id IS NULL OR set_process_id = p_set_process_id)
1866: AND process_status = G_PROCESS_RECORD;

Line 1912: FROM ego_functions_b b

1908: G_PROGRAM_ID,
1909: SYSDATE
1910: FROM ego_func_params_interface i
1911: WHERE NOT EXISTS (SELECT internal_name
1912: FROM ego_functions_b b
1913: WHERE ( b.internal_name = i.function_internal_name )
1914: )
1915: AND function_id IS NULL
1916: AND function_internal_name IS NOT NULL

Line 1923: FROM ego_functions_b b

1919:
1920: UPDATE ego_func_params_interface i
1921: SET process_status = G_ERROR_RECORD, last_update_date=sysdate, last_updated_by=G_USER_ID,program_update_date=SYSDATE
1922: WHERE NOT EXISTS (SELECT internal_name
1923: FROM ego_functions_b b
1924: WHERE ( b.internal_name = i.function_internal_name )
1925: )
1926: AND function_id IS NULL
1927: AND function_internal_name IS NOT NULL

Line 2031: (b.function_id IN (SELECT function_id FROM ego_functions_b

2027: AND NOT EXISTS (SELECT *
2028: FROM ego_func_params_b b
2029: WHERE ( b.func_param_id = i.func_param_id )
2030: AND ((b.function_id = i.function_id AND i.function_id IS NOT NULL) OR
2031: (b.function_id IN (SELECT function_id FROM ego_functions_b
2032: WHERE (internal_name=i.function_internal_name))
2033: AND i.function_id IS NULL AND i.function_internal_name IS NOT NULL)
2034: ) )
2035: AND func_param_id IS NOT NULL

Line 2046: (b.function_id IN (SELECT function_id FROM ego_functions_b

2042: AND NOT EXISTS (SELECT *
2043: FROM ego_func_params_b b
2044: WHERE ( b.func_param_id = i.func_param_id )
2045: AND ((b.function_id = i.function_id AND i.function_id IS NOT NULL) OR
2046: (b.function_id IN (SELECT function_id FROM ego_functions_b
2047: WHERE (internal_name=i.function_internal_name))
2048: AND i.function_id IS NULL AND i.function_internal_name IS NOT NULL)
2049: ) )
2050: AND func_param_id IS NOT NULL

Line 2109: (b.function_id IN (SELECT function_id FROM ego_functions_b

2105: AND NOT EXISTS (SELECT internal_name
2106: FROM ego_func_params_b b
2107: WHERE ( b.internal_name = i.internal_name )
2108: AND ((b.function_id = i.function_id AND i.function_id IS NOT NULL) OR
2109: (b.function_id IN (SELECT function_id FROM ego_functions_b
2110: WHERE (internal_name=i.function_internal_name))
2111: AND i.function_id IS NULL AND i.function_internal_name IS NOT NULL)
2112: )
2113: UNION

Line 2137: (b.function_id IN (SELECT function_id FROM ego_functions_b

2133: AND NOT EXISTS (SELECT internal_name
2134: FROM ego_func_params_b b
2135: WHERE ( b.internal_name = i.internal_name )
2136: AND ((b.function_id = i.function_id AND i.function_id IS NOT NULL) OR
2137: (b.function_id IN (SELECT function_id FROM ego_functions_b
2138: WHERE (internal_name=i.function_internal_name))
2139: AND i.function_id IS NULL AND i.function_internal_name IS NOT NULL)
2140: )
2141: UNION

Line 2214: END EGO_FUNCTIONS_BULKLOAD_PVT;

2210: AND (p_set_process_id IS NULL OR set_process_id = p_set_process_id)
2211: AND process_status = G_PROCESS_RECORD;
2212: write_debug(G_PCK_NAME||'.'||l_proc_name||'->'||' Exiting from the procedure');
2213: END bulk_validate_func_params;
2214: END EGO_FUNCTIONS_BULKLOAD_PVT;