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.IGS_SC_DATA_SEC_APIS_PKG dependencies on UTL_FILE

Line 8167: p_file_ptr UTL_FILE.FILE_TYPE,

8163: END get_obj_name;
8164:
8165:
8166: PROCEDURE Cut_String (
8167: p_file_ptr UTL_FILE.FILE_TYPE,
8168: p_string IN VARCHAR2
8169: ) IS
8170: l_new_string VARCHAR2(255);
8171: l_result_string VARCHAR2(4000);

Line 8196: UTL_FILE.PUT_LINE ( p_file_ptr, l_new_string);

8192:
8193: l_new_string := substr(l_new_string,1,l_pos);
8194:
8195: -- put to the file
8196: UTL_FILE.PUT_LINE ( p_file_ptr, l_new_string);
8197:
8198: -- modify string
8199: l_result_string := substr(l_result_string,length(l_new_string)+1,4000);
8200:

Line 8203: UTL_FILE.PUT_LINE ( p_file_ptr, l_result_string);

8199: l_result_string := substr(l_result_string,length(l_new_string)+1,4000);
8200:
8201: END LOOP;
8202:
8203: UTL_FILE.PUT_LINE ( p_file_ptr, l_result_string);
8204:
8205: END Cut_String;
8206:
8207: PROCEDURE Generate_Table_SQL (

Line 8211: p_file_ptr UTL_FILE.FILE_TYPE

8207: PROCEDURE Generate_Table_SQL (
8208: p_table_name IN VARCHAR2,
8209: p_where_clause IN VARCHAR2,
8210: p_pk_value IN VARCHAR2,
8211: p_file_ptr UTL_FILE.FILE_TYPE
8212: )
8213: IS
8214: l_query_str VARCHAR2(32000);
8215: l_result VARCHAR2(32000);

Line 8281: -- UTL_FILE.PUT_LINE ( p_file_ptr, l_query_str);

8277: -- l_concat_col_list := l_concat_col_list||'||''''''''';
8278: l_concat_col_list := l_concat_col_list||'''';
8279:
8280: l_query_str := 'SELECT '||l_concat_col_list||' FROM '||p_table_name||' WHERE '||p_where_clause;
8281: -- UTL_FILE.PUT_LINE ( p_file_ptr, l_query_str);
8282:
8283: OPEN c_query FOR l_query_str USING p_pk_value;
8284: LOOP
8285:

Line 8295: UTL_FILE.FFLUSH ( p_file_ptr );

8291:
8292: l_str := l_result||');' ;
8293: Cut_String ( p_file_ptr, l_str);
8294:
8295: UTL_FILE.FFLUSH ( p_file_ptr );
8296:
8297: END LOOP;
8298: CLOSE c_query;
8299:

Line 8304: p_file_ptr UTL_FILE.FILE_TYPE

8300:
8301: END Generate_Table_SQL;
8302:
8303: PROCEDURE Generate_Objects_SQL (
8304: p_file_ptr UTL_FILE.FILE_TYPE
8305: )
8306: IS
8307:
8308: l_comm_string VARCHAR2(700) ;

Line 8333: UTL_FILE.PUT_LINE ( p_file_ptr,' DECLARE');

8329: BEGIN
8330:
8331: -- Put script begginning part
8332:
8333: UTL_FILE.PUT_LINE ( p_file_ptr,' DECLARE');
8334:
8335: UTL_FILE.PUT_LINE ( p_file_ptr,' CURSOR c_obj (v_database_object_name VARCHAR2 ) IS');
8336: UTL_FILE.PUT_LINE ( p_file_ptr,' SELECT object_id');
8337: UTL_FILE.PUT_LINE ( p_file_ptr,' FROM fnd_objects ');

Line 8335: UTL_FILE.PUT_LINE ( p_file_ptr,' CURSOR c_obj (v_database_object_name VARCHAR2 ) IS');

8331: -- Put script begginning part
8332:
8333: UTL_FILE.PUT_LINE ( p_file_ptr,' DECLARE');
8334:
8335: UTL_FILE.PUT_LINE ( p_file_ptr,' CURSOR c_obj (v_database_object_name VARCHAR2 ) IS');
8336: UTL_FILE.PUT_LINE ( p_file_ptr,' SELECT object_id');
8337: UTL_FILE.PUT_LINE ( p_file_ptr,' FROM fnd_objects ');
8338: UTL_FILE.PUT_LINE ( p_file_ptr,' WHERE database_object_name = v_database_object_name;');
8339:

Line 8336: UTL_FILE.PUT_LINE ( p_file_ptr,' SELECT object_id');

8332:
8333: UTL_FILE.PUT_LINE ( p_file_ptr,' DECLARE');
8334:
8335: UTL_FILE.PUT_LINE ( p_file_ptr,' CURSOR c_obj (v_database_object_name VARCHAR2 ) IS');
8336: UTL_FILE.PUT_LINE ( p_file_ptr,' SELECT object_id');
8337: UTL_FILE.PUT_LINE ( p_file_ptr,' FROM fnd_objects ');
8338: UTL_FILE.PUT_LINE ( p_file_ptr,' WHERE database_object_name = v_database_object_name;');
8339:
8340: UTL_FILE.PUT_LINE ( p_file_ptr,' TYPE l_obj_rec_tbl IS TABLE OF fnd_objects%ROWTYPE INDEX BY BINARY_INTEGER;');

Line 8337: UTL_FILE.PUT_LINE ( p_file_ptr,' FROM fnd_objects ');

8333: UTL_FILE.PUT_LINE ( p_file_ptr,' DECLARE');
8334:
8335: UTL_FILE.PUT_LINE ( p_file_ptr,' CURSOR c_obj (v_database_object_name VARCHAR2 ) IS');
8336: UTL_FILE.PUT_LINE ( p_file_ptr,' SELECT object_id');
8337: UTL_FILE.PUT_LINE ( p_file_ptr,' FROM fnd_objects ');
8338: UTL_FILE.PUT_LINE ( p_file_ptr,' WHERE database_object_name = v_database_object_name;');
8339:
8340: UTL_FILE.PUT_LINE ( p_file_ptr,' TYPE l_obj_rec_tbl IS TABLE OF fnd_objects%ROWTYPE INDEX BY BINARY_INTEGER;');
8341:

Line 8338: UTL_FILE.PUT_LINE ( p_file_ptr,' WHERE database_object_name = v_database_object_name;');

8334:
8335: UTL_FILE.PUT_LINE ( p_file_ptr,' CURSOR c_obj (v_database_object_name VARCHAR2 ) IS');
8336: UTL_FILE.PUT_LINE ( p_file_ptr,' SELECT object_id');
8337: UTL_FILE.PUT_LINE ( p_file_ptr,' FROM fnd_objects ');
8338: UTL_FILE.PUT_LINE ( p_file_ptr,' WHERE database_object_name = v_database_object_name;');
8339:
8340: UTL_FILE.PUT_LINE ( p_file_ptr,' TYPE l_obj_rec_tbl IS TABLE OF fnd_objects%ROWTYPE INDEX BY BINARY_INTEGER;');
8341:
8342: UTL_FILE.PUT_LINE ( p_file_ptr,' l_obj_tbl l_obj_rec_tbl;');

Line 8340: UTL_FILE.PUT_LINE ( p_file_ptr,' TYPE l_obj_rec_tbl IS TABLE OF fnd_objects%ROWTYPE INDEX BY BINARY_INTEGER;');

8336: UTL_FILE.PUT_LINE ( p_file_ptr,' SELECT object_id');
8337: UTL_FILE.PUT_LINE ( p_file_ptr,' FROM fnd_objects ');
8338: UTL_FILE.PUT_LINE ( p_file_ptr,' WHERE database_object_name = v_database_object_name;');
8339:
8340: UTL_FILE.PUT_LINE ( p_file_ptr,' TYPE l_obj_rec_tbl IS TABLE OF fnd_objects%ROWTYPE INDEX BY BINARY_INTEGER;');
8341:
8342: UTL_FILE.PUT_LINE ( p_file_ptr,' l_obj_tbl l_obj_rec_tbl;');
8343: UTL_FILE.PUT_LINE ( p_file_ptr,' l_object_id fnd_objects.object_id%TYPE;');
8344: UTL_FILE.PUT_LINE ( p_file_ptr,' l_record_num NUMBER(10);');

Line 8342: UTL_FILE.PUT_LINE ( p_file_ptr,' l_obj_tbl l_obj_rec_tbl;');

8338: UTL_FILE.PUT_LINE ( p_file_ptr,' WHERE database_object_name = v_database_object_name;');
8339:
8340: UTL_FILE.PUT_LINE ( p_file_ptr,' TYPE l_obj_rec_tbl IS TABLE OF fnd_objects%ROWTYPE INDEX BY BINARY_INTEGER;');
8341:
8342: UTL_FILE.PUT_LINE ( p_file_ptr,' l_obj_tbl l_obj_rec_tbl;');
8343: UTL_FILE.PUT_LINE ( p_file_ptr,' l_object_id fnd_objects.object_id%TYPE;');
8344: UTL_FILE.PUT_LINE ( p_file_ptr,' l_record_num NUMBER(10);');
8345: UTL_FILE.PUT_LINE ( p_file_ptr,' l_cur_num NUMBER(10) := 0;');
8346: UTL_FILE.PUT_LINE ( p_file_ptr,' l_total NUMBER(9) :=0;');

Line 8343: UTL_FILE.PUT_LINE ( p_file_ptr,' l_object_id fnd_objects.object_id%TYPE;');

8339:
8340: UTL_FILE.PUT_LINE ( p_file_ptr,' TYPE l_obj_rec_tbl IS TABLE OF fnd_objects%ROWTYPE INDEX BY BINARY_INTEGER;');
8341:
8342: UTL_FILE.PUT_LINE ( p_file_ptr,' l_obj_tbl l_obj_rec_tbl;');
8343: UTL_FILE.PUT_LINE ( p_file_ptr,' l_object_id fnd_objects.object_id%TYPE;');
8344: UTL_FILE.PUT_LINE ( p_file_ptr,' l_record_num NUMBER(10);');
8345: UTL_FILE.PUT_LINE ( p_file_ptr,' l_cur_num NUMBER(10) := 0;');
8346: UTL_FILE.PUT_LINE ( p_file_ptr,' l_total NUMBER(9) :=0;');
8347: UTL_FILE.PUT_LINE ( p_file_ptr,' l_rowid VARCHAR2(255);');

Line 8344: UTL_FILE.PUT_LINE ( p_file_ptr,' l_record_num NUMBER(10);');

8340: UTL_FILE.PUT_LINE ( p_file_ptr,' TYPE l_obj_rec_tbl IS TABLE OF fnd_objects%ROWTYPE INDEX BY BINARY_INTEGER;');
8341:
8342: UTL_FILE.PUT_LINE ( p_file_ptr,' l_obj_tbl l_obj_rec_tbl;');
8343: UTL_FILE.PUT_LINE ( p_file_ptr,' l_object_id fnd_objects.object_id%TYPE;');
8344: UTL_FILE.PUT_LINE ( p_file_ptr,' l_record_num NUMBER(10);');
8345: UTL_FILE.PUT_LINE ( p_file_ptr,' l_cur_num NUMBER(10) := 0;');
8346: UTL_FILE.PUT_LINE ( p_file_ptr,' l_total NUMBER(9) :=0;');
8347: UTL_FILE.PUT_LINE ( p_file_ptr,' l_rowid VARCHAR2(255);');
8348: UTL_FILE.PUT_LINE ( p_file_ptr,' BEGIN');

Line 8345: UTL_FILE.PUT_LINE ( p_file_ptr,' l_cur_num NUMBER(10) := 0;');

8341:
8342: UTL_FILE.PUT_LINE ( p_file_ptr,' l_obj_tbl l_obj_rec_tbl;');
8343: UTL_FILE.PUT_LINE ( p_file_ptr,' l_object_id fnd_objects.object_id%TYPE;');
8344: UTL_FILE.PUT_LINE ( p_file_ptr,' l_record_num NUMBER(10);');
8345: UTL_FILE.PUT_LINE ( p_file_ptr,' l_cur_num NUMBER(10) := 0;');
8346: UTL_FILE.PUT_LINE ( p_file_ptr,' l_total NUMBER(9) :=0;');
8347: UTL_FILE.PUT_LINE ( p_file_ptr,' l_rowid VARCHAR2(255);');
8348: UTL_FILE.PUT_LINE ( p_file_ptr,' BEGIN');
8349:

Line 8346: UTL_FILE.PUT_LINE ( p_file_ptr,' l_total NUMBER(9) :=0;');

8342: UTL_FILE.PUT_LINE ( p_file_ptr,' l_obj_tbl l_obj_rec_tbl;');
8343: UTL_FILE.PUT_LINE ( p_file_ptr,' l_object_id fnd_objects.object_id%TYPE;');
8344: UTL_FILE.PUT_LINE ( p_file_ptr,' l_record_num NUMBER(10);');
8345: UTL_FILE.PUT_LINE ( p_file_ptr,' l_cur_num NUMBER(10) := 0;');
8346: UTL_FILE.PUT_LINE ( p_file_ptr,' l_total NUMBER(9) :=0;');
8347: UTL_FILE.PUT_LINE ( p_file_ptr,' l_rowid VARCHAR2(255);');
8348: UTL_FILE.PUT_LINE ( p_file_ptr,' BEGIN');
8349:
8350: l_cur_object := 0;

Line 8347: UTL_FILE.PUT_LINE ( p_file_ptr,' l_rowid VARCHAR2(255);');

8343: UTL_FILE.PUT_LINE ( p_file_ptr,' l_object_id fnd_objects.object_id%TYPE;');
8344: UTL_FILE.PUT_LINE ( p_file_ptr,' l_record_num NUMBER(10);');
8345: UTL_FILE.PUT_LINE ( p_file_ptr,' l_cur_num NUMBER(10) := 0;');
8346: UTL_FILE.PUT_LINE ( p_file_ptr,' l_total NUMBER(9) :=0;');
8347: UTL_FILE.PUT_LINE ( p_file_ptr,' l_rowid VARCHAR2(255);');
8348: UTL_FILE.PUT_LINE ( p_file_ptr,' BEGIN');
8349:
8350: l_cur_object := 0;
8351:

Line 8348: UTL_FILE.PUT_LINE ( p_file_ptr,' BEGIN');

8344: UTL_FILE.PUT_LINE ( p_file_ptr,' l_record_num NUMBER(10);');
8345: UTL_FILE.PUT_LINE ( p_file_ptr,' l_cur_num NUMBER(10) := 0;');
8346: UTL_FILE.PUT_LINE ( p_file_ptr,' l_total NUMBER(9) :=0;');
8347: UTL_FILE.PUT_LINE ( p_file_ptr,' l_rowid VARCHAR2(255);');
8348: UTL_FILE.PUT_LINE ( p_file_ptr,' BEGIN');
8349:
8350: l_cur_object := 0;
8351:
8352: FOR c_objects_rec IN c_objects LOOP

Line 8354: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );

8350: l_cur_object := 0;
8351:
8352: FOR c_objects_rec IN c_objects LOOP
8353: l_comm_string := ' l_obj_tbl('||l_cur_object||').DATABASE_OBJECT_NAME := '''||c_objects_rec.DATABASE_OBJECT_NAME||''';';
8354: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );
8355: l_comm_string := ' l_obj_tbl('||l_cur_object||').PK1_COLUMN_NAME := '''||c_objects_rec.PK1_COLUMN_NAME||''';';
8356: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );
8357: l_comm_string := ' l_obj_tbl('||l_cur_object||').PK1_COLUMN_TYPE := '''||c_objects_rec.PK1_COLUMN_TYPE||''';';
8358: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );

Line 8356: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );

8352: FOR c_objects_rec IN c_objects LOOP
8353: l_comm_string := ' l_obj_tbl('||l_cur_object||').DATABASE_OBJECT_NAME := '''||c_objects_rec.DATABASE_OBJECT_NAME||''';';
8354: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );
8355: l_comm_string := ' l_obj_tbl('||l_cur_object||').PK1_COLUMN_NAME := '''||c_objects_rec.PK1_COLUMN_NAME||''';';
8356: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );
8357: l_comm_string := ' l_obj_tbl('||l_cur_object||').PK1_COLUMN_TYPE := '''||c_objects_rec.PK1_COLUMN_TYPE||''';';
8358: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );
8359: l_comm_string := ' l_obj_tbl('||l_cur_object||').PK2_COLUMN_NAME := '''||c_objects_rec.PK2_COLUMN_NAME||''';';
8360: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );

Line 8358: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );

8354: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );
8355: l_comm_string := ' l_obj_tbl('||l_cur_object||').PK1_COLUMN_NAME := '''||c_objects_rec.PK1_COLUMN_NAME||''';';
8356: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );
8357: l_comm_string := ' l_obj_tbl('||l_cur_object||').PK1_COLUMN_TYPE := '''||c_objects_rec.PK1_COLUMN_TYPE||''';';
8358: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );
8359: l_comm_string := ' l_obj_tbl('||l_cur_object||').PK2_COLUMN_NAME := '''||c_objects_rec.PK2_COLUMN_NAME||''';';
8360: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );
8361: l_comm_string := ' l_obj_tbl('||l_cur_object||').PK2_COLUMN_TYPE := '''||c_objects_rec.PK2_COLUMN_TYPE||''';';
8362: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );

Line 8360: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );

8356: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );
8357: l_comm_string := ' l_obj_tbl('||l_cur_object||').PK1_COLUMN_TYPE := '''||c_objects_rec.PK1_COLUMN_TYPE||''';';
8358: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );
8359: l_comm_string := ' l_obj_tbl('||l_cur_object||').PK2_COLUMN_NAME := '''||c_objects_rec.PK2_COLUMN_NAME||''';';
8360: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );
8361: l_comm_string := ' l_obj_tbl('||l_cur_object||').PK2_COLUMN_TYPE := '''||c_objects_rec.PK2_COLUMN_TYPE||''';';
8362: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );
8363:
8364: l_comm_string := ' l_obj_tbl('||l_cur_object||').PK3_COLUMN_NAME := '''||c_objects_rec.PK3_COLUMN_NAME||''';';

Line 8362: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );

8358: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );
8359: l_comm_string := ' l_obj_tbl('||l_cur_object||').PK2_COLUMN_NAME := '''||c_objects_rec.PK2_COLUMN_NAME||''';';
8360: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );
8361: l_comm_string := ' l_obj_tbl('||l_cur_object||').PK2_COLUMN_TYPE := '''||c_objects_rec.PK2_COLUMN_TYPE||''';';
8362: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );
8363:
8364: l_comm_string := ' l_obj_tbl('||l_cur_object||').PK3_COLUMN_NAME := '''||c_objects_rec.PK3_COLUMN_NAME||''';';
8365: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );
8366: l_comm_string := ' l_obj_tbl('||l_cur_object||').PK3_COLUMN_TYPE := '''||c_objects_rec.PK3_COLUMN_TYPE||''';';

Line 8365: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );

8361: l_comm_string := ' l_obj_tbl('||l_cur_object||').PK2_COLUMN_TYPE := '''||c_objects_rec.PK2_COLUMN_TYPE||''';';
8362: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );
8363:
8364: l_comm_string := ' l_obj_tbl('||l_cur_object||').PK3_COLUMN_NAME := '''||c_objects_rec.PK3_COLUMN_NAME||''';';
8365: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );
8366: l_comm_string := ' l_obj_tbl('||l_cur_object||').PK3_COLUMN_TYPE := '''||c_objects_rec.PK3_COLUMN_TYPE||''';';
8367: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );
8368:
8369: l_comm_string := ' l_obj_tbl('||l_cur_object||').PK4_COLUMN_NAME := '''||c_objects_rec.PK4_COLUMN_NAME||''';';

Line 8367: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );

8363:
8364: l_comm_string := ' l_obj_tbl('||l_cur_object||').PK3_COLUMN_NAME := '''||c_objects_rec.PK3_COLUMN_NAME||''';';
8365: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );
8366: l_comm_string := ' l_obj_tbl('||l_cur_object||').PK3_COLUMN_TYPE := '''||c_objects_rec.PK3_COLUMN_TYPE||''';';
8367: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );
8368:
8369: l_comm_string := ' l_obj_tbl('||l_cur_object||').PK4_COLUMN_NAME := '''||c_objects_rec.PK4_COLUMN_NAME||''';';
8370: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );
8371: l_comm_string := ' l_obj_tbl('||l_cur_object||').PK4_COLUMN_TYPE := '''||c_objects_rec.PK4_COLUMN_TYPE||''';';

Line 8370: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );

8366: l_comm_string := ' l_obj_tbl('||l_cur_object||').PK3_COLUMN_TYPE := '''||c_objects_rec.PK3_COLUMN_TYPE||''';';
8367: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );
8368:
8369: l_comm_string := ' l_obj_tbl('||l_cur_object||').PK4_COLUMN_NAME := '''||c_objects_rec.PK4_COLUMN_NAME||''';';
8370: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );
8371: l_comm_string := ' l_obj_tbl('||l_cur_object||').PK4_COLUMN_TYPE := '''||c_objects_rec.PK4_COLUMN_TYPE||''';';
8372: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );
8373:
8374: l_comm_string := ' l_obj_tbl('||l_cur_object||').PK5_COLUMN_NAME := '''||c_objects_rec.PK5_COLUMN_NAME||''';';

Line 8372: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );

8368:
8369: l_comm_string := ' l_obj_tbl('||l_cur_object||').PK4_COLUMN_NAME := '''||c_objects_rec.PK4_COLUMN_NAME||''';';
8370: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );
8371: l_comm_string := ' l_obj_tbl('||l_cur_object||').PK4_COLUMN_TYPE := '''||c_objects_rec.PK4_COLUMN_TYPE||''';';
8372: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );
8373:
8374: l_comm_string := ' l_obj_tbl('||l_cur_object||').PK5_COLUMN_NAME := '''||c_objects_rec.PK5_COLUMN_NAME||''';';
8375: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );
8376: l_comm_string := ' l_obj_tbl('||l_cur_object||').PK5_COLUMN_TYPE := '''||c_objects_rec.PK5_COLUMN_TYPE||''';';

Line 8375: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );

8371: l_comm_string := ' l_obj_tbl('||l_cur_object||').PK4_COLUMN_TYPE := '''||c_objects_rec.PK4_COLUMN_TYPE||''';';
8372: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );
8373:
8374: l_comm_string := ' l_obj_tbl('||l_cur_object||').PK5_COLUMN_NAME := '''||c_objects_rec.PK5_COLUMN_NAME||''';';
8375: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );
8376: l_comm_string := ' l_obj_tbl('||l_cur_object||').PK5_COLUMN_TYPE := '''||c_objects_rec.PK5_COLUMN_TYPE||''';';
8377: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );
8378: l_comm_string := ' l_obj_tbl('||l_cur_object||').APPLICATION_ID := '''||c_objects_rec.APPLICATION_ID||''';';
8379: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );

Line 8377: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );

8373:
8374: l_comm_string := ' l_obj_tbl('||l_cur_object||').PK5_COLUMN_NAME := '''||c_objects_rec.PK5_COLUMN_NAME||''';';
8375: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );
8376: l_comm_string := ' l_obj_tbl('||l_cur_object||').PK5_COLUMN_TYPE := '''||c_objects_rec.PK5_COLUMN_TYPE||''';';
8377: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );
8378: l_comm_string := ' l_obj_tbl('||l_cur_object||').APPLICATION_ID := '''||c_objects_rec.APPLICATION_ID||''';';
8379: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );
8380: l_comm_string := ' l_obj_tbl('||l_cur_object||').OBJ_NAME := '''||c_objects_rec.OBJ_NAME||''';';
8381: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );

Line 8379: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );

8375: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );
8376: l_comm_string := ' l_obj_tbl('||l_cur_object||').PK5_COLUMN_TYPE := '''||c_objects_rec.PK5_COLUMN_TYPE||''';';
8377: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );
8378: l_comm_string := ' l_obj_tbl('||l_cur_object||').APPLICATION_ID := '''||c_objects_rec.APPLICATION_ID||''';';
8379: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );
8380: l_comm_string := ' l_obj_tbl('||l_cur_object||').OBJ_NAME := '''||c_objects_rec.OBJ_NAME||''';';
8381: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );
8382:
8383: UTL_FILE.FFLUSH ( p_file_ptr );

Line 8381: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );

8377: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );
8378: l_comm_string := ' l_obj_tbl('||l_cur_object||').APPLICATION_ID := '''||c_objects_rec.APPLICATION_ID||''';';
8379: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );
8380: l_comm_string := ' l_obj_tbl('||l_cur_object||').OBJ_NAME := '''||c_objects_rec.OBJ_NAME||''';';
8381: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );
8382:
8383: UTL_FILE.FFLUSH ( p_file_ptr );
8384: l_cur_object := l_cur_object+1;
8385:

Line 8383: UTL_FILE.FFLUSH ( p_file_ptr );

8379: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );
8380: l_comm_string := ' l_obj_tbl('||l_cur_object||').OBJ_NAME := '''||c_objects_rec.OBJ_NAME||''';';
8381: UTL_FILE.PUT_LINE ( p_file_ptr,l_comm_string );
8382:
8383: UTL_FILE.FFLUSH ( p_file_ptr );
8384: l_cur_object := l_cur_object+1;
8385:
8386: END LOOP;
8387:

Line 8388: UTL_FILE.PUT_LINE ( p_file_ptr,' l_total :='||(l_cur_object-1)||';' );

8384: l_cur_object := l_cur_object+1;
8385:
8386: END LOOP;
8387:
8388: UTL_FILE.PUT_LINE ( p_file_ptr,' l_total :='||(l_cur_object-1)||';' );
8389: UTL_FILE.FFLUSH ( p_file_ptr );
8390:
8391: --Add last part of the script
8392: UTL_FILE.PUT_LINE ( p_file_ptr,' FOR l_cur_num IN 0..l_total LOOP ');

Line 8389: UTL_FILE.FFLUSH ( p_file_ptr );

8385:
8386: END LOOP;
8387:
8388: UTL_FILE.PUT_LINE ( p_file_ptr,' l_total :='||(l_cur_object-1)||';' );
8389: UTL_FILE.FFLUSH ( p_file_ptr );
8390:
8391: --Add last part of the script
8392: UTL_FILE.PUT_LINE ( p_file_ptr,' FOR l_cur_num IN 0..l_total LOOP ');
8393: UTL_FILE.PUT_LINE ( p_file_ptr,' l_object_id := null; ');

Line 8392: UTL_FILE.PUT_LINE ( p_file_ptr,' FOR l_cur_num IN 0..l_total LOOP ');

8388: UTL_FILE.PUT_LINE ( p_file_ptr,' l_total :='||(l_cur_object-1)||';' );
8389: UTL_FILE.FFLUSH ( p_file_ptr );
8390:
8391: --Add last part of the script
8392: UTL_FILE.PUT_LINE ( p_file_ptr,' FOR l_cur_num IN 0..l_total LOOP ');
8393: UTL_FILE.PUT_LINE ( p_file_ptr,' l_object_id := null; ');
8394:
8395: UTL_FILE.PUT_LINE ( p_file_ptr,' OPEN c_obj ( l_obj_tbl(l_cur_num).DATABASE_OBJECT_NAME);');
8396: UTL_FILE.PUT_LINE ( p_file_ptr,' FETCH c_obj INTO l_object_id;');

Line 8393: UTL_FILE.PUT_LINE ( p_file_ptr,' l_object_id := null; ');

8389: UTL_FILE.FFLUSH ( p_file_ptr );
8390:
8391: --Add last part of the script
8392: UTL_FILE.PUT_LINE ( p_file_ptr,' FOR l_cur_num IN 0..l_total LOOP ');
8393: UTL_FILE.PUT_LINE ( p_file_ptr,' l_object_id := null; ');
8394:
8395: UTL_FILE.PUT_LINE ( p_file_ptr,' OPEN c_obj ( l_obj_tbl(l_cur_num).DATABASE_OBJECT_NAME);');
8396: UTL_FILE.PUT_LINE ( p_file_ptr,' FETCH c_obj INTO l_object_id;');
8397: UTL_FILE.PUT_LINE ( p_file_ptr,' CLOSE c_obj;');

Line 8395: UTL_FILE.PUT_LINE ( p_file_ptr,' OPEN c_obj ( l_obj_tbl(l_cur_num).DATABASE_OBJECT_NAME);');

8391: --Add last part of the script
8392: UTL_FILE.PUT_LINE ( p_file_ptr,' FOR l_cur_num IN 0..l_total LOOP ');
8393: UTL_FILE.PUT_LINE ( p_file_ptr,' l_object_id := null; ');
8394:
8395: UTL_FILE.PUT_LINE ( p_file_ptr,' OPEN c_obj ( l_obj_tbl(l_cur_num).DATABASE_OBJECT_NAME);');
8396: UTL_FILE.PUT_LINE ( p_file_ptr,' FETCH c_obj INTO l_object_id;');
8397: UTL_FILE.PUT_LINE ( p_file_ptr,' CLOSE c_obj;');
8398: UTL_FILE.PUT_LINE ( p_file_ptr,' IF l_object_id IS NULL THEN ');
8399: UTL_FILE.PUT_LINE ( p_file_ptr,' SELECT fnd_objects_s.nextval INTO l_object_id FROM DUAL;');

Line 8396: UTL_FILE.PUT_LINE ( p_file_ptr,' FETCH c_obj INTO l_object_id;');

8392: UTL_FILE.PUT_LINE ( p_file_ptr,' FOR l_cur_num IN 0..l_total LOOP ');
8393: UTL_FILE.PUT_LINE ( p_file_ptr,' l_object_id := null; ');
8394:
8395: UTL_FILE.PUT_LINE ( p_file_ptr,' OPEN c_obj ( l_obj_tbl(l_cur_num).DATABASE_OBJECT_NAME);');
8396: UTL_FILE.PUT_LINE ( p_file_ptr,' FETCH c_obj INTO l_object_id;');
8397: UTL_FILE.PUT_LINE ( p_file_ptr,' CLOSE c_obj;');
8398: UTL_FILE.PUT_LINE ( p_file_ptr,' IF l_object_id IS NULL THEN ');
8399: UTL_FILE.PUT_LINE ( p_file_ptr,' SELECT fnd_objects_s.nextval INTO l_object_id FROM DUAL;');
8400: UTL_FILE.PUT_LINE ( p_file_ptr,' FND_OBJECTS_PKG.INSERT_ROW (');

Line 8397: UTL_FILE.PUT_LINE ( p_file_ptr,' CLOSE c_obj;');

8393: UTL_FILE.PUT_LINE ( p_file_ptr,' l_object_id := null; ');
8394:
8395: UTL_FILE.PUT_LINE ( p_file_ptr,' OPEN c_obj ( l_obj_tbl(l_cur_num).DATABASE_OBJECT_NAME);');
8396: UTL_FILE.PUT_LINE ( p_file_ptr,' FETCH c_obj INTO l_object_id;');
8397: UTL_FILE.PUT_LINE ( p_file_ptr,' CLOSE c_obj;');
8398: UTL_FILE.PUT_LINE ( p_file_ptr,' IF l_object_id IS NULL THEN ');
8399: UTL_FILE.PUT_LINE ( p_file_ptr,' SELECT fnd_objects_s.nextval INTO l_object_id FROM DUAL;');
8400: UTL_FILE.PUT_LINE ( p_file_ptr,' FND_OBJECTS_PKG.INSERT_ROW (');
8401: UTL_FILE.PUT_LINE ( p_file_ptr,' x_rowid => l_rowid,');

Line 8398: UTL_FILE.PUT_LINE ( p_file_ptr,' IF l_object_id IS NULL THEN ');

8394:
8395: UTL_FILE.PUT_LINE ( p_file_ptr,' OPEN c_obj ( l_obj_tbl(l_cur_num).DATABASE_OBJECT_NAME);');
8396: UTL_FILE.PUT_LINE ( p_file_ptr,' FETCH c_obj INTO l_object_id;');
8397: UTL_FILE.PUT_LINE ( p_file_ptr,' CLOSE c_obj;');
8398: UTL_FILE.PUT_LINE ( p_file_ptr,' IF l_object_id IS NULL THEN ');
8399: UTL_FILE.PUT_LINE ( p_file_ptr,' SELECT fnd_objects_s.nextval INTO l_object_id FROM DUAL;');
8400: UTL_FILE.PUT_LINE ( p_file_ptr,' FND_OBJECTS_PKG.INSERT_ROW (');
8401: UTL_FILE.PUT_LINE ( p_file_ptr,' x_rowid => l_rowid,');
8402: UTL_FILE.PUT_LINE ( p_file_ptr,' x_object_id =>l_object_id,');

Line 8399: UTL_FILE.PUT_LINE ( p_file_ptr,' SELECT fnd_objects_s.nextval INTO l_object_id FROM DUAL;');

8395: UTL_FILE.PUT_LINE ( p_file_ptr,' OPEN c_obj ( l_obj_tbl(l_cur_num).DATABASE_OBJECT_NAME);');
8396: UTL_FILE.PUT_LINE ( p_file_ptr,' FETCH c_obj INTO l_object_id;');
8397: UTL_FILE.PUT_LINE ( p_file_ptr,' CLOSE c_obj;');
8398: UTL_FILE.PUT_LINE ( p_file_ptr,' IF l_object_id IS NULL THEN ');
8399: UTL_FILE.PUT_LINE ( p_file_ptr,' SELECT fnd_objects_s.nextval INTO l_object_id FROM DUAL;');
8400: UTL_FILE.PUT_LINE ( p_file_ptr,' FND_OBJECTS_PKG.INSERT_ROW (');
8401: UTL_FILE.PUT_LINE ( p_file_ptr,' x_rowid => l_rowid,');
8402: UTL_FILE.PUT_LINE ( p_file_ptr,' x_object_id =>l_object_id,');
8403: UTL_FILE.PUT_LINE ( p_file_ptr,' x_obj_name => l_obj_tbl(l_cur_num).OBJ_NAME,');

Line 8400: UTL_FILE.PUT_LINE ( p_file_ptr,' FND_OBJECTS_PKG.INSERT_ROW (');

8396: UTL_FILE.PUT_LINE ( p_file_ptr,' FETCH c_obj INTO l_object_id;');
8397: UTL_FILE.PUT_LINE ( p_file_ptr,' CLOSE c_obj;');
8398: UTL_FILE.PUT_LINE ( p_file_ptr,' IF l_object_id IS NULL THEN ');
8399: UTL_FILE.PUT_LINE ( p_file_ptr,' SELECT fnd_objects_s.nextval INTO l_object_id FROM DUAL;');
8400: UTL_FILE.PUT_LINE ( p_file_ptr,' FND_OBJECTS_PKG.INSERT_ROW (');
8401: UTL_FILE.PUT_LINE ( p_file_ptr,' x_rowid => l_rowid,');
8402: UTL_FILE.PUT_LINE ( p_file_ptr,' x_object_id =>l_object_id,');
8403: UTL_FILE.PUT_LINE ( p_file_ptr,' x_obj_name => l_obj_tbl(l_cur_num).OBJ_NAME,');
8404: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk1_column_name => l_obj_tbl(l_cur_num).PK1_COLUMN_NAME ,');

Line 8401: UTL_FILE.PUT_LINE ( p_file_ptr,' x_rowid => l_rowid,');

8397: UTL_FILE.PUT_LINE ( p_file_ptr,' CLOSE c_obj;');
8398: UTL_FILE.PUT_LINE ( p_file_ptr,' IF l_object_id IS NULL THEN ');
8399: UTL_FILE.PUT_LINE ( p_file_ptr,' SELECT fnd_objects_s.nextval INTO l_object_id FROM DUAL;');
8400: UTL_FILE.PUT_LINE ( p_file_ptr,' FND_OBJECTS_PKG.INSERT_ROW (');
8401: UTL_FILE.PUT_LINE ( p_file_ptr,' x_rowid => l_rowid,');
8402: UTL_FILE.PUT_LINE ( p_file_ptr,' x_object_id =>l_object_id,');
8403: UTL_FILE.PUT_LINE ( p_file_ptr,' x_obj_name => l_obj_tbl(l_cur_num).OBJ_NAME,');
8404: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk1_column_name => l_obj_tbl(l_cur_num).PK1_COLUMN_NAME ,');
8405: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk2_column_name => l_obj_tbl(l_cur_num).PK2_COLUMN_NAME ,');

Line 8402: UTL_FILE.PUT_LINE ( p_file_ptr,' x_object_id =>l_object_id,');

8398: UTL_FILE.PUT_LINE ( p_file_ptr,' IF l_object_id IS NULL THEN ');
8399: UTL_FILE.PUT_LINE ( p_file_ptr,' SELECT fnd_objects_s.nextval INTO l_object_id FROM DUAL;');
8400: UTL_FILE.PUT_LINE ( p_file_ptr,' FND_OBJECTS_PKG.INSERT_ROW (');
8401: UTL_FILE.PUT_LINE ( p_file_ptr,' x_rowid => l_rowid,');
8402: UTL_FILE.PUT_LINE ( p_file_ptr,' x_object_id =>l_object_id,');
8403: UTL_FILE.PUT_LINE ( p_file_ptr,' x_obj_name => l_obj_tbl(l_cur_num).OBJ_NAME,');
8404: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk1_column_name => l_obj_tbl(l_cur_num).PK1_COLUMN_NAME ,');
8405: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk2_column_name => l_obj_tbl(l_cur_num).PK2_COLUMN_NAME ,');
8406: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk3_column_name => l_obj_tbl(l_cur_num).PK3_COLUMN_NAME ,');

Line 8403: UTL_FILE.PUT_LINE ( p_file_ptr,' x_obj_name => l_obj_tbl(l_cur_num).OBJ_NAME,');

8399: UTL_FILE.PUT_LINE ( p_file_ptr,' SELECT fnd_objects_s.nextval INTO l_object_id FROM DUAL;');
8400: UTL_FILE.PUT_LINE ( p_file_ptr,' FND_OBJECTS_PKG.INSERT_ROW (');
8401: UTL_FILE.PUT_LINE ( p_file_ptr,' x_rowid => l_rowid,');
8402: UTL_FILE.PUT_LINE ( p_file_ptr,' x_object_id =>l_object_id,');
8403: UTL_FILE.PUT_LINE ( p_file_ptr,' x_obj_name => l_obj_tbl(l_cur_num).OBJ_NAME,');
8404: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk1_column_name => l_obj_tbl(l_cur_num).PK1_COLUMN_NAME ,');
8405: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk2_column_name => l_obj_tbl(l_cur_num).PK2_COLUMN_NAME ,');
8406: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk3_column_name => l_obj_tbl(l_cur_num).PK3_COLUMN_NAME ,');
8407: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk4_column_name => l_obj_tbl(l_cur_num).PK4_COLUMN_NAME ,');

Line 8404: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk1_column_name => l_obj_tbl(l_cur_num).PK1_COLUMN_NAME ,');

8400: UTL_FILE.PUT_LINE ( p_file_ptr,' FND_OBJECTS_PKG.INSERT_ROW (');
8401: UTL_FILE.PUT_LINE ( p_file_ptr,' x_rowid => l_rowid,');
8402: UTL_FILE.PUT_LINE ( p_file_ptr,' x_object_id =>l_object_id,');
8403: UTL_FILE.PUT_LINE ( p_file_ptr,' x_obj_name => l_obj_tbl(l_cur_num).OBJ_NAME,');
8404: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk1_column_name => l_obj_tbl(l_cur_num).PK1_COLUMN_NAME ,');
8405: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk2_column_name => l_obj_tbl(l_cur_num).PK2_COLUMN_NAME ,');
8406: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk3_column_name => l_obj_tbl(l_cur_num).PK3_COLUMN_NAME ,');
8407: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk4_column_name => l_obj_tbl(l_cur_num).PK4_COLUMN_NAME ,');
8408: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk5_column_name => l_obj_tbl(l_cur_num).PK5_COLUMN_NAME ,');

Line 8405: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk2_column_name => l_obj_tbl(l_cur_num).PK2_COLUMN_NAME ,');

8401: UTL_FILE.PUT_LINE ( p_file_ptr,' x_rowid => l_rowid,');
8402: UTL_FILE.PUT_LINE ( p_file_ptr,' x_object_id =>l_object_id,');
8403: UTL_FILE.PUT_LINE ( p_file_ptr,' x_obj_name => l_obj_tbl(l_cur_num).OBJ_NAME,');
8404: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk1_column_name => l_obj_tbl(l_cur_num).PK1_COLUMN_NAME ,');
8405: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk2_column_name => l_obj_tbl(l_cur_num).PK2_COLUMN_NAME ,');
8406: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk3_column_name => l_obj_tbl(l_cur_num).PK3_COLUMN_NAME ,');
8407: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk4_column_name => l_obj_tbl(l_cur_num).PK4_COLUMN_NAME ,');
8408: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk5_column_name => l_obj_tbl(l_cur_num).PK5_COLUMN_NAME ,');
8409: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk1_column_type => l_obj_tbl(l_cur_num).PK1_COLUMN_TYPE ,');

Line 8406: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk3_column_name => l_obj_tbl(l_cur_num).PK3_COLUMN_NAME ,');

8402: UTL_FILE.PUT_LINE ( p_file_ptr,' x_object_id =>l_object_id,');
8403: UTL_FILE.PUT_LINE ( p_file_ptr,' x_obj_name => l_obj_tbl(l_cur_num).OBJ_NAME,');
8404: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk1_column_name => l_obj_tbl(l_cur_num).PK1_COLUMN_NAME ,');
8405: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk2_column_name => l_obj_tbl(l_cur_num).PK2_COLUMN_NAME ,');
8406: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk3_column_name => l_obj_tbl(l_cur_num).PK3_COLUMN_NAME ,');
8407: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk4_column_name => l_obj_tbl(l_cur_num).PK4_COLUMN_NAME ,');
8408: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk5_column_name => l_obj_tbl(l_cur_num).PK5_COLUMN_NAME ,');
8409: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk1_column_type => l_obj_tbl(l_cur_num).PK1_COLUMN_TYPE ,');
8410: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk2_column_type => l_obj_tbl(l_cur_num).PK2_COLUMN_TYPE ,');

Line 8407: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk4_column_name => l_obj_tbl(l_cur_num).PK4_COLUMN_NAME ,');

8403: UTL_FILE.PUT_LINE ( p_file_ptr,' x_obj_name => l_obj_tbl(l_cur_num).OBJ_NAME,');
8404: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk1_column_name => l_obj_tbl(l_cur_num).PK1_COLUMN_NAME ,');
8405: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk2_column_name => l_obj_tbl(l_cur_num).PK2_COLUMN_NAME ,');
8406: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk3_column_name => l_obj_tbl(l_cur_num).PK3_COLUMN_NAME ,');
8407: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk4_column_name => l_obj_tbl(l_cur_num).PK4_COLUMN_NAME ,');
8408: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk5_column_name => l_obj_tbl(l_cur_num).PK5_COLUMN_NAME ,');
8409: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk1_column_type => l_obj_tbl(l_cur_num).PK1_COLUMN_TYPE ,');
8410: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk2_column_type => l_obj_tbl(l_cur_num).PK2_COLUMN_TYPE ,');
8411: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk3_column_type => l_obj_tbl(l_cur_num).PK3_COLUMN_TYPE ,');

Line 8408: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk5_column_name => l_obj_tbl(l_cur_num).PK5_COLUMN_NAME ,');

8404: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk1_column_name => l_obj_tbl(l_cur_num).PK1_COLUMN_NAME ,');
8405: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk2_column_name => l_obj_tbl(l_cur_num).PK2_COLUMN_NAME ,');
8406: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk3_column_name => l_obj_tbl(l_cur_num).PK3_COLUMN_NAME ,');
8407: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk4_column_name => l_obj_tbl(l_cur_num).PK4_COLUMN_NAME ,');
8408: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk5_column_name => l_obj_tbl(l_cur_num).PK5_COLUMN_NAME ,');
8409: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk1_column_type => l_obj_tbl(l_cur_num).PK1_COLUMN_TYPE ,');
8410: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk2_column_type => l_obj_tbl(l_cur_num).PK2_COLUMN_TYPE ,');
8411: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk3_column_type => l_obj_tbl(l_cur_num).PK3_COLUMN_TYPE ,');
8412: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk4_column_type => l_obj_tbl(l_cur_num).PK4_COLUMN_TYPE ,');

Line 8409: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk1_column_type => l_obj_tbl(l_cur_num).PK1_COLUMN_TYPE ,');

8405: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk2_column_name => l_obj_tbl(l_cur_num).PK2_COLUMN_NAME ,');
8406: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk3_column_name => l_obj_tbl(l_cur_num).PK3_COLUMN_NAME ,');
8407: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk4_column_name => l_obj_tbl(l_cur_num).PK4_COLUMN_NAME ,');
8408: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk5_column_name => l_obj_tbl(l_cur_num).PK5_COLUMN_NAME ,');
8409: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk1_column_type => l_obj_tbl(l_cur_num).PK1_COLUMN_TYPE ,');
8410: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk2_column_type => l_obj_tbl(l_cur_num).PK2_COLUMN_TYPE ,');
8411: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk3_column_type => l_obj_tbl(l_cur_num).PK3_COLUMN_TYPE ,');
8412: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk4_column_type => l_obj_tbl(l_cur_num).PK4_COLUMN_TYPE ,');
8413: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk5_column_type => l_obj_tbl(l_cur_num).PK5_COLUMN_TYPE ,');

Line 8410: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk2_column_type => l_obj_tbl(l_cur_num).PK2_COLUMN_TYPE ,');

8406: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk3_column_name => l_obj_tbl(l_cur_num).PK3_COLUMN_NAME ,');
8407: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk4_column_name => l_obj_tbl(l_cur_num).PK4_COLUMN_NAME ,');
8408: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk5_column_name => l_obj_tbl(l_cur_num).PK5_COLUMN_NAME ,');
8409: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk1_column_type => l_obj_tbl(l_cur_num).PK1_COLUMN_TYPE ,');
8410: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk2_column_type => l_obj_tbl(l_cur_num).PK2_COLUMN_TYPE ,');
8411: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk3_column_type => l_obj_tbl(l_cur_num).PK3_COLUMN_TYPE ,');
8412: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk4_column_type => l_obj_tbl(l_cur_num).PK4_COLUMN_TYPE ,');
8413: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk5_column_type => l_obj_tbl(l_cur_num).PK5_COLUMN_TYPE ,');
8414: UTL_FILE.PUT_LINE ( p_file_ptr,' x_application_id => l_obj_tbl(l_cur_num).APPLICATION_ID ,');

Line 8411: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk3_column_type => l_obj_tbl(l_cur_num).PK3_COLUMN_TYPE ,');

8407: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk4_column_name => l_obj_tbl(l_cur_num).PK4_COLUMN_NAME ,');
8408: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk5_column_name => l_obj_tbl(l_cur_num).PK5_COLUMN_NAME ,');
8409: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk1_column_type => l_obj_tbl(l_cur_num).PK1_COLUMN_TYPE ,');
8410: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk2_column_type => l_obj_tbl(l_cur_num).PK2_COLUMN_TYPE ,');
8411: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk3_column_type => l_obj_tbl(l_cur_num).PK3_COLUMN_TYPE ,');
8412: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk4_column_type => l_obj_tbl(l_cur_num).PK4_COLUMN_TYPE ,');
8413: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk5_column_type => l_obj_tbl(l_cur_num).PK5_COLUMN_TYPE ,');
8414: UTL_FILE.PUT_LINE ( p_file_ptr,' x_application_id => l_obj_tbl(l_cur_num).APPLICATION_ID ,');
8415: UTL_FILE.PUT_LINE ( p_file_ptr,' x_database_object_name => l_obj_tbl(l_cur_num).DATABASE_OBJECT_NAME,');

Line 8412: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk4_column_type => l_obj_tbl(l_cur_num).PK4_COLUMN_TYPE ,');

8408: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk5_column_name => l_obj_tbl(l_cur_num).PK5_COLUMN_NAME ,');
8409: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk1_column_type => l_obj_tbl(l_cur_num).PK1_COLUMN_TYPE ,');
8410: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk2_column_type => l_obj_tbl(l_cur_num).PK2_COLUMN_TYPE ,');
8411: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk3_column_type => l_obj_tbl(l_cur_num).PK3_COLUMN_TYPE ,');
8412: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk4_column_type => l_obj_tbl(l_cur_num).PK4_COLUMN_TYPE ,');
8413: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk5_column_type => l_obj_tbl(l_cur_num).PK5_COLUMN_TYPE ,');
8414: UTL_FILE.PUT_LINE ( p_file_ptr,' x_application_id => l_obj_tbl(l_cur_num).APPLICATION_ID ,');
8415: UTL_FILE.PUT_LINE ( p_file_ptr,' x_database_object_name => l_obj_tbl(l_cur_num).DATABASE_OBJECT_NAME,');
8416: UTL_FILE.PUT_LINE ( p_file_ptr,' x_display_name => l_obj_tbl(l_cur_num).OBJ_NAME,');

Line 8413: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk5_column_type => l_obj_tbl(l_cur_num).PK5_COLUMN_TYPE ,');

8409: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk1_column_type => l_obj_tbl(l_cur_num).PK1_COLUMN_TYPE ,');
8410: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk2_column_type => l_obj_tbl(l_cur_num).PK2_COLUMN_TYPE ,');
8411: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk3_column_type => l_obj_tbl(l_cur_num).PK3_COLUMN_TYPE ,');
8412: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk4_column_type => l_obj_tbl(l_cur_num).PK4_COLUMN_TYPE ,');
8413: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk5_column_type => l_obj_tbl(l_cur_num).PK5_COLUMN_TYPE ,');
8414: UTL_FILE.PUT_LINE ( p_file_ptr,' x_application_id => l_obj_tbl(l_cur_num).APPLICATION_ID ,');
8415: UTL_FILE.PUT_LINE ( p_file_ptr,' x_database_object_name => l_obj_tbl(l_cur_num).DATABASE_OBJECT_NAME,');
8416: UTL_FILE.PUT_LINE ( p_file_ptr,' x_display_name => l_obj_tbl(l_cur_num).OBJ_NAME,');
8417: UTL_FILE.PUT_LINE ( p_file_ptr,' x_description => l_obj_tbl(l_cur_num).OBJ_NAME,');

Line 8414: UTL_FILE.PUT_LINE ( p_file_ptr,' x_application_id => l_obj_tbl(l_cur_num).APPLICATION_ID ,');

8410: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk2_column_type => l_obj_tbl(l_cur_num).PK2_COLUMN_TYPE ,');
8411: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk3_column_type => l_obj_tbl(l_cur_num).PK3_COLUMN_TYPE ,');
8412: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk4_column_type => l_obj_tbl(l_cur_num).PK4_COLUMN_TYPE ,');
8413: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk5_column_type => l_obj_tbl(l_cur_num).PK5_COLUMN_TYPE ,');
8414: UTL_FILE.PUT_LINE ( p_file_ptr,' x_application_id => l_obj_tbl(l_cur_num).APPLICATION_ID ,');
8415: UTL_FILE.PUT_LINE ( p_file_ptr,' x_database_object_name => l_obj_tbl(l_cur_num).DATABASE_OBJECT_NAME,');
8416: UTL_FILE.PUT_LINE ( p_file_ptr,' x_display_name => l_obj_tbl(l_cur_num).OBJ_NAME,');
8417: UTL_FILE.PUT_LINE ( p_file_ptr,' x_description => l_obj_tbl(l_cur_num).OBJ_NAME,');
8418: UTL_FILE.PUT_LINE ( p_file_ptr,' x_creation_date => sysdate,');

Line 8415: UTL_FILE.PUT_LINE ( p_file_ptr,' x_database_object_name => l_obj_tbl(l_cur_num).DATABASE_OBJECT_NAME,');

8411: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk3_column_type => l_obj_tbl(l_cur_num).PK3_COLUMN_TYPE ,');
8412: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk4_column_type => l_obj_tbl(l_cur_num).PK4_COLUMN_TYPE ,');
8413: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk5_column_type => l_obj_tbl(l_cur_num).PK5_COLUMN_TYPE ,');
8414: UTL_FILE.PUT_LINE ( p_file_ptr,' x_application_id => l_obj_tbl(l_cur_num).APPLICATION_ID ,');
8415: UTL_FILE.PUT_LINE ( p_file_ptr,' x_database_object_name => l_obj_tbl(l_cur_num).DATABASE_OBJECT_NAME,');
8416: UTL_FILE.PUT_LINE ( p_file_ptr,' x_display_name => l_obj_tbl(l_cur_num).OBJ_NAME,');
8417: UTL_FILE.PUT_LINE ( p_file_ptr,' x_description => l_obj_tbl(l_cur_num).OBJ_NAME,');
8418: UTL_FILE.PUT_LINE ( p_file_ptr,' x_creation_date => sysdate,');
8419: UTL_FILE.PUT_LINE ( p_file_ptr,' x_created_by => nvl(fnd_global.user_id,-1),');

Line 8416: UTL_FILE.PUT_LINE ( p_file_ptr,' x_display_name => l_obj_tbl(l_cur_num).OBJ_NAME,');

8412: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk4_column_type => l_obj_tbl(l_cur_num).PK4_COLUMN_TYPE ,');
8413: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk5_column_type => l_obj_tbl(l_cur_num).PK5_COLUMN_TYPE ,');
8414: UTL_FILE.PUT_LINE ( p_file_ptr,' x_application_id => l_obj_tbl(l_cur_num).APPLICATION_ID ,');
8415: UTL_FILE.PUT_LINE ( p_file_ptr,' x_database_object_name => l_obj_tbl(l_cur_num).DATABASE_OBJECT_NAME,');
8416: UTL_FILE.PUT_LINE ( p_file_ptr,' x_display_name => l_obj_tbl(l_cur_num).OBJ_NAME,');
8417: UTL_FILE.PUT_LINE ( p_file_ptr,' x_description => l_obj_tbl(l_cur_num).OBJ_NAME,');
8418: UTL_FILE.PUT_LINE ( p_file_ptr,' x_creation_date => sysdate,');
8419: UTL_FILE.PUT_LINE ( p_file_ptr,' x_created_by => nvl(fnd_global.user_id,-1),');
8420: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_update_date => sysdate,');

Line 8417: UTL_FILE.PUT_LINE ( p_file_ptr,' x_description => l_obj_tbl(l_cur_num).OBJ_NAME,');

8413: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk5_column_type => l_obj_tbl(l_cur_num).PK5_COLUMN_TYPE ,');
8414: UTL_FILE.PUT_LINE ( p_file_ptr,' x_application_id => l_obj_tbl(l_cur_num).APPLICATION_ID ,');
8415: UTL_FILE.PUT_LINE ( p_file_ptr,' x_database_object_name => l_obj_tbl(l_cur_num).DATABASE_OBJECT_NAME,');
8416: UTL_FILE.PUT_LINE ( p_file_ptr,' x_display_name => l_obj_tbl(l_cur_num).OBJ_NAME,');
8417: UTL_FILE.PUT_LINE ( p_file_ptr,' x_description => l_obj_tbl(l_cur_num).OBJ_NAME,');
8418: UTL_FILE.PUT_LINE ( p_file_ptr,' x_creation_date => sysdate,');
8419: UTL_FILE.PUT_LINE ( p_file_ptr,' x_created_by => nvl(fnd_global.user_id,-1),');
8420: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_update_date => sysdate,');
8421: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_updated_by => nvl(fnd_global.user_id,-1),');

Line 8418: UTL_FILE.PUT_LINE ( p_file_ptr,' x_creation_date => sysdate,');

8414: UTL_FILE.PUT_LINE ( p_file_ptr,' x_application_id => l_obj_tbl(l_cur_num).APPLICATION_ID ,');
8415: UTL_FILE.PUT_LINE ( p_file_ptr,' x_database_object_name => l_obj_tbl(l_cur_num).DATABASE_OBJECT_NAME,');
8416: UTL_FILE.PUT_LINE ( p_file_ptr,' x_display_name => l_obj_tbl(l_cur_num).OBJ_NAME,');
8417: UTL_FILE.PUT_LINE ( p_file_ptr,' x_description => l_obj_tbl(l_cur_num).OBJ_NAME,');
8418: UTL_FILE.PUT_LINE ( p_file_ptr,' x_creation_date => sysdate,');
8419: UTL_FILE.PUT_LINE ( p_file_ptr,' x_created_by => nvl(fnd_global.user_id,-1),');
8420: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_update_date => sysdate,');
8421: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_updated_by => nvl(fnd_global.user_id,-1),');
8422: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_update_login => nvl(fnd_global.login_id, -1));');

Line 8419: UTL_FILE.PUT_LINE ( p_file_ptr,' x_created_by => nvl(fnd_global.user_id,-1),');

8415: UTL_FILE.PUT_LINE ( p_file_ptr,' x_database_object_name => l_obj_tbl(l_cur_num).DATABASE_OBJECT_NAME,');
8416: UTL_FILE.PUT_LINE ( p_file_ptr,' x_display_name => l_obj_tbl(l_cur_num).OBJ_NAME,');
8417: UTL_FILE.PUT_LINE ( p_file_ptr,' x_description => l_obj_tbl(l_cur_num).OBJ_NAME,');
8418: UTL_FILE.PUT_LINE ( p_file_ptr,' x_creation_date => sysdate,');
8419: UTL_FILE.PUT_LINE ( p_file_ptr,' x_created_by => nvl(fnd_global.user_id,-1),');
8420: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_update_date => sysdate,');
8421: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_updated_by => nvl(fnd_global.user_id,-1),');
8422: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_update_login => nvl(fnd_global.login_id, -1));');
8423:

Line 8420: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_update_date => sysdate,');

8416: UTL_FILE.PUT_LINE ( p_file_ptr,' x_display_name => l_obj_tbl(l_cur_num).OBJ_NAME,');
8417: UTL_FILE.PUT_LINE ( p_file_ptr,' x_description => l_obj_tbl(l_cur_num).OBJ_NAME,');
8418: UTL_FILE.PUT_LINE ( p_file_ptr,' x_creation_date => sysdate,');
8419: UTL_FILE.PUT_LINE ( p_file_ptr,' x_created_by => nvl(fnd_global.user_id,-1),');
8420: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_update_date => sysdate,');
8421: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_updated_by => nvl(fnd_global.user_id,-1),');
8422: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_update_login => nvl(fnd_global.login_id, -1));');
8423:
8424: UTL_FILE.PUT_LINE ( p_file_ptr,' ELSE');

Line 8421: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_updated_by => nvl(fnd_global.user_id,-1),');

8417: UTL_FILE.PUT_LINE ( p_file_ptr,' x_description => l_obj_tbl(l_cur_num).OBJ_NAME,');
8418: UTL_FILE.PUT_LINE ( p_file_ptr,' x_creation_date => sysdate,');
8419: UTL_FILE.PUT_LINE ( p_file_ptr,' x_created_by => nvl(fnd_global.user_id,-1),');
8420: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_update_date => sysdate,');
8421: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_updated_by => nvl(fnd_global.user_id,-1),');
8422: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_update_login => nvl(fnd_global.login_id, -1));');
8423:
8424: UTL_FILE.PUT_LINE ( p_file_ptr,' ELSE');
8425:

Line 8422: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_update_login => nvl(fnd_global.login_id, -1));');

8418: UTL_FILE.PUT_LINE ( p_file_ptr,' x_creation_date => sysdate,');
8419: UTL_FILE.PUT_LINE ( p_file_ptr,' x_created_by => nvl(fnd_global.user_id,-1),');
8420: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_update_date => sysdate,');
8421: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_updated_by => nvl(fnd_global.user_id,-1),');
8422: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_update_login => nvl(fnd_global.login_id, -1));');
8423:
8424: UTL_FILE.PUT_LINE ( p_file_ptr,' ELSE');
8425:
8426: UTL_FILE.PUT_LINE ( p_file_ptr,' FND_OBJECTS_PKG.UPDATE_ROW (');

Line 8424: UTL_FILE.PUT_LINE ( p_file_ptr,' ELSE');

8420: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_update_date => sysdate,');
8421: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_updated_by => nvl(fnd_global.user_id,-1),');
8422: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_update_login => nvl(fnd_global.login_id, -1));');
8423:
8424: UTL_FILE.PUT_LINE ( p_file_ptr,' ELSE');
8425:
8426: UTL_FILE.PUT_LINE ( p_file_ptr,' FND_OBJECTS_PKG.UPDATE_ROW (');
8427: UTL_FILE.PUT_LINE ( p_file_ptr,' x_object_id =>l_object_id,');
8428: UTL_FILE.PUT_LINE ( p_file_ptr,' x_obj_name => l_obj_tbl(l_cur_num).OBJ_NAME,');

Line 8426: UTL_FILE.PUT_LINE ( p_file_ptr,' FND_OBJECTS_PKG.UPDATE_ROW (');

8422: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_update_login => nvl(fnd_global.login_id, -1));');
8423:
8424: UTL_FILE.PUT_LINE ( p_file_ptr,' ELSE');
8425:
8426: UTL_FILE.PUT_LINE ( p_file_ptr,' FND_OBJECTS_PKG.UPDATE_ROW (');
8427: UTL_FILE.PUT_LINE ( p_file_ptr,' x_object_id =>l_object_id,');
8428: UTL_FILE.PUT_LINE ( p_file_ptr,' x_obj_name => l_obj_tbl(l_cur_num).OBJ_NAME,');
8429: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk1_column_name => l_obj_tbl(l_cur_num).PK1_COLUMN_NAME ,');
8430: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk2_column_name => l_obj_tbl(l_cur_num).PK2_COLUMN_NAME ,');

Line 8427: UTL_FILE.PUT_LINE ( p_file_ptr,' x_object_id =>l_object_id,');

8423:
8424: UTL_FILE.PUT_LINE ( p_file_ptr,' ELSE');
8425:
8426: UTL_FILE.PUT_LINE ( p_file_ptr,' FND_OBJECTS_PKG.UPDATE_ROW (');
8427: UTL_FILE.PUT_LINE ( p_file_ptr,' x_object_id =>l_object_id,');
8428: UTL_FILE.PUT_LINE ( p_file_ptr,' x_obj_name => l_obj_tbl(l_cur_num).OBJ_NAME,');
8429: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk1_column_name => l_obj_tbl(l_cur_num).PK1_COLUMN_NAME ,');
8430: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk2_column_name => l_obj_tbl(l_cur_num).PK2_COLUMN_NAME ,');
8431: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk3_column_name => l_obj_tbl(l_cur_num).PK3_COLUMN_NAME ,');

Line 8428: UTL_FILE.PUT_LINE ( p_file_ptr,' x_obj_name => l_obj_tbl(l_cur_num).OBJ_NAME,');

8424: UTL_FILE.PUT_LINE ( p_file_ptr,' ELSE');
8425:
8426: UTL_FILE.PUT_LINE ( p_file_ptr,' FND_OBJECTS_PKG.UPDATE_ROW (');
8427: UTL_FILE.PUT_LINE ( p_file_ptr,' x_object_id =>l_object_id,');
8428: UTL_FILE.PUT_LINE ( p_file_ptr,' x_obj_name => l_obj_tbl(l_cur_num).OBJ_NAME,');
8429: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk1_column_name => l_obj_tbl(l_cur_num).PK1_COLUMN_NAME ,');
8430: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk2_column_name => l_obj_tbl(l_cur_num).PK2_COLUMN_NAME ,');
8431: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk3_column_name => l_obj_tbl(l_cur_num).PK3_COLUMN_NAME ,');
8432: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk4_column_name => l_obj_tbl(l_cur_num).PK4_COLUMN_NAME ,');

Line 8429: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk1_column_name => l_obj_tbl(l_cur_num).PK1_COLUMN_NAME ,');

8425:
8426: UTL_FILE.PUT_LINE ( p_file_ptr,' FND_OBJECTS_PKG.UPDATE_ROW (');
8427: UTL_FILE.PUT_LINE ( p_file_ptr,' x_object_id =>l_object_id,');
8428: UTL_FILE.PUT_LINE ( p_file_ptr,' x_obj_name => l_obj_tbl(l_cur_num).OBJ_NAME,');
8429: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk1_column_name => l_obj_tbl(l_cur_num).PK1_COLUMN_NAME ,');
8430: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk2_column_name => l_obj_tbl(l_cur_num).PK2_COLUMN_NAME ,');
8431: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk3_column_name => l_obj_tbl(l_cur_num).PK3_COLUMN_NAME ,');
8432: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk4_column_name => l_obj_tbl(l_cur_num).PK4_COLUMN_NAME ,');
8433: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk5_column_name => l_obj_tbl(l_cur_num).PK5_COLUMN_NAME ,');

Line 8430: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk2_column_name => l_obj_tbl(l_cur_num).PK2_COLUMN_NAME ,');

8426: UTL_FILE.PUT_LINE ( p_file_ptr,' FND_OBJECTS_PKG.UPDATE_ROW (');
8427: UTL_FILE.PUT_LINE ( p_file_ptr,' x_object_id =>l_object_id,');
8428: UTL_FILE.PUT_LINE ( p_file_ptr,' x_obj_name => l_obj_tbl(l_cur_num).OBJ_NAME,');
8429: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk1_column_name => l_obj_tbl(l_cur_num).PK1_COLUMN_NAME ,');
8430: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk2_column_name => l_obj_tbl(l_cur_num).PK2_COLUMN_NAME ,');
8431: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk3_column_name => l_obj_tbl(l_cur_num).PK3_COLUMN_NAME ,');
8432: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk4_column_name => l_obj_tbl(l_cur_num).PK4_COLUMN_NAME ,');
8433: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk5_column_name => l_obj_tbl(l_cur_num).PK5_COLUMN_NAME ,');
8434: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk1_column_type => l_obj_tbl(l_cur_num).PK1_COLUMN_TYPE ,');

Line 8431: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk3_column_name => l_obj_tbl(l_cur_num).PK3_COLUMN_NAME ,');

8427: UTL_FILE.PUT_LINE ( p_file_ptr,' x_object_id =>l_object_id,');
8428: UTL_FILE.PUT_LINE ( p_file_ptr,' x_obj_name => l_obj_tbl(l_cur_num).OBJ_NAME,');
8429: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk1_column_name => l_obj_tbl(l_cur_num).PK1_COLUMN_NAME ,');
8430: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk2_column_name => l_obj_tbl(l_cur_num).PK2_COLUMN_NAME ,');
8431: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk3_column_name => l_obj_tbl(l_cur_num).PK3_COLUMN_NAME ,');
8432: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk4_column_name => l_obj_tbl(l_cur_num).PK4_COLUMN_NAME ,');
8433: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk5_column_name => l_obj_tbl(l_cur_num).PK5_COLUMN_NAME ,');
8434: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk1_column_type => l_obj_tbl(l_cur_num).PK1_COLUMN_TYPE ,');
8435: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk2_column_type => l_obj_tbl(l_cur_num).PK2_COLUMN_TYPE ,');

Line 8432: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk4_column_name => l_obj_tbl(l_cur_num).PK4_COLUMN_NAME ,');

8428: UTL_FILE.PUT_LINE ( p_file_ptr,' x_obj_name => l_obj_tbl(l_cur_num).OBJ_NAME,');
8429: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk1_column_name => l_obj_tbl(l_cur_num).PK1_COLUMN_NAME ,');
8430: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk2_column_name => l_obj_tbl(l_cur_num).PK2_COLUMN_NAME ,');
8431: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk3_column_name => l_obj_tbl(l_cur_num).PK3_COLUMN_NAME ,');
8432: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk4_column_name => l_obj_tbl(l_cur_num).PK4_COLUMN_NAME ,');
8433: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk5_column_name => l_obj_tbl(l_cur_num).PK5_COLUMN_NAME ,');
8434: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk1_column_type => l_obj_tbl(l_cur_num).PK1_COLUMN_TYPE ,');
8435: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk2_column_type => l_obj_tbl(l_cur_num).PK2_COLUMN_TYPE ,');
8436: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk3_column_type => l_obj_tbl(l_cur_num).PK3_COLUMN_TYPE ,');

Line 8433: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk5_column_name => l_obj_tbl(l_cur_num).PK5_COLUMN_NAME ,');

8429: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk1_column_name => l_obj_tbl(l_cur_num).PK1_COLUMN_NAME ,');
8430: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk2_column_name => l_obj_tbl(l_cur_num).PK2_COLUMN_NAME ,');
8431: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk3_column_name => l_obj_tbl(l_cur_num).PK3_COLUMN_NAME ,');
8432: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk4_column_name => l_obj_tbl(l_cur_num).PK4_COLUMN_NAME ,');
8433: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk5_column_name => l_obj_tbl(l_cur_num).PK5_COLUMN_NAME ,');
8434: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk1_column_type => l_obj_tbl(l_cur_num).PK1_COLUMN_TYPE ,');
8435: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk2_column_type => l_obj_tbl(l_cur_num).PK2_COLUMN_TYPE ,');
8436: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk3_column_type => l_obj_tbl(l_cur_num).PK3_COLUMN_TYPE ,');
8437: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk4_column_type => l_obj_tbl(l_cur_num).PK4_COLUMN_TYPE ,');

Line 8434: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk1_column_type => l_obj_tbl(l_cur_num).PK1_COLUMN_TYPE ,');

8430: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk2_column_name => l_obj_tbl(l_cur_num).PK2_COLUMN_NAME ,');
8431: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk3_column_name => l_obj_tbl(l_cur_num).PK3_COLUMN_NAME ,');
8432: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk4_column_name => l_obj_tbl(l_cur_num).PK4_COLUMN_NAME ,');
8433: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk5_column_name => l_obj_tbl(l_cur_num).PK5_COLUMN_NAME ,');
8434: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk1_column_type => l_obj_tbl(l_cur_num).PK1_COLUMN_TYPE ,');
8435: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk2_column_type => l_obj_tbl(l_cur_num).PK2_COLUMN_TYPE ,');
8436: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk3_column_type => l_obj_tbl(l_cur_num).PK3_COLUMN_TYPE ,');
8437: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk4_column_type => l_obj_tbl(l_cur_num).PK4_COLUMN_TYPE ,');
8438: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk5_column_type => l_obj_tbl(l_cur_num).PK5_COLUMN_TYPE ,');

Line 8435: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk2_column_type => l_obj_tbl(l_cur_num).PK2_COLUMN_TYPE ,');

8431: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk3_column_name => l_obj_tbl(l_cur_num).PK3_COLUMN_NAME ,');
8432: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk4_column_name => l_obj_tbl(l_cur_num).PK4_COLUMN_NAME ,');
8433: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk5_column_name => l_obj_tbl(l_cur_num).PK5_COLUMN_NAME ,');
8434: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk1_column_type => l_obj_tbl(l_cur_num).PK1_COLUMN_TYPE ,');
8435: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk2_column_type => l_obj_tbl(l_cur_num).PK2_COLUMN_TYPE ,');
8436: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk3_column_type => l_obj_tbl(l_cur_num).PK3_COLUMN_TYPE ,');
8437: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk4_column_type => l_obj_tbl(l_cur_num).PK4_COLUMN_TYPE ,');
8438: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk5_column_type => l_obj_tbl(l_cur_num).PK5_COLUMN_TYPE ,');
8439: UTL_FILE.PUT_LINE ( p_file_ptr,' x_application_id => l_obj_tbl(l_cur_num).APPLICATION_ID ,');

Line 8436: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk3_column_type => l_obj_tbl(l_cur_num).PK3_COLUMN_TYPE ,');

8432: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk4_column_name => l_obj_tbl(l_cur_num).PK4_COLUMN_NAME ,');
8433: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk5_column_name => l_obj_tbl(l_cur_num).PK5_COLUMN_NAME ,');
8434: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk1_column_type => l_obj_tbl(l_cur_num).PK1_COLUMN_TYPE ,');
8435: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk2_column_type => l_obj_tbl(l_cur_num).PK2_COLUMN_TYPE ,');
8436: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk3_column_type => l_obj_tbl(l_cur_num).PK3_COLUMN_TYPE ,');
8437: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk4_column_type => l_obj_tbl(l_cur_num).PK4_COLUMN_TYPE ,');
8438: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk5_column_type => l_obj_tbl(l_cur_num).PK5_COLUMN_TYPE ,');
8439: UTL_FILE.PUT_LINE ( p_file_ptr,' x_application_id => l_obj_tbl(l_cur_num).APPLICATION_ID ,');
8440: UTL_FILE.PUT_LINE ( p_file_ptr,' x_database_object_name => l_obj_tbl(l_cur_num).DATABASE_OBJECT_NAME,');

Line 8437: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk4_column_type => l_obj_tbl(l_cur_num).PK4_COLUMN_TYPE ,');

8433: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk5_column_name => l_obj_tbl(l_cur_num).PK5_COLUMN_NAME ,');
8434: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk1_column_type => l_obj_tbl(l_cur_num).PK1_COLUMN_TYPE ,');
8435: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk2_column_type => l_obj_tbl(l_cur_num).PK2_COLUMN_TYPE ,');
8436: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk3_column_type => l_obj_tbl(l_cur_num).PK3_COLUMN_TYPE ,');
8437: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk4_column_type => l_obj_tbl(l_cur_num).PK4_COLUMN_TYPE ,');
8438: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk5_column_type => l_obj_tbl(l_cur_num).PK5_COLUMN_TYPE ,');
8439: UTL_FILE.PUT_LINE ( p_file_ptr,' x_application_id => l_obj_tbl(l_cur_num).APPLICATION_ID ,');
8440: UTL_FILE.PUT_LINE ( p_file_ptr,' x_database_object_name => l_obj_tbl(l_cur_num).DATABASE_OBJECT_NAME,');
8441: UTL_FILE.PUT_LINE ( p_file_ptr,' x_display_name => l_obj_tbl(l_cur_num).OBJ_NAME,');

Line 8438: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk5_column_type => l_obj_tbl(l_cur_num).PK5_COLUMN_TYPE ,');

8434: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk1_column_type => l_obj_tbl(l_cur_num).PK1_COLUMN_TYPE ,');
8435: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk2_column_type => l_obj_tbl(l_cur_num).PK2_COLUMN_TYPE ,');
8436: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk3_column_type => l_obj_tbl(l_cur_num).PK3_COLUMN_TYPE ,');
8437: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk4_column_type => l_obj_tbl(l_cur_num).PK4_COLUMN_TYPE ,');
8438: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk5_column_type => l_obj_tbl(l_cur_num).PK5_COLUMN_TYPE ,');
8439: UTL_FILE.PUT_LINE ( p_file_ptr,' x_application_id => l_obj_tbl(l_cur_num).APPLICATION_ID ,');
8440: UTL_FILE.PUT_LINE ( p_file_ptr,' x_database_object_name => l_obj_tbl(l_cur_num).DATABASE_OBJECT_NAME,');
8441: UTL_FILE.PUT_LINE ( p_file_ptr,' x_display_name => l_obj_tbl(l_cur_num).OBJ_NAME,');
8442: UTL_FILE.PUT_LINE ( p_file_ptr,' x_description => l_obj_tbl(l_cur_num).OBJ_NAME,');

Line 8439: UTL_FILE.PUT_LINE ( p_file_ptr,' x_application_id => l_obj_tbl(l_cur_num).APPLICATION_ID ,');

8435: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk2_column_type => l_obj_tbl(l_cur_num).PK2_COLUMN_TYPE ,');
8436: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk3_column_type => l_obj_tbl(l_cur_num).PK3_COLUMN_TYPE ,');
8437: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk4_column_type => l_obj_tbl(l_cur_num).PK4_COLUMN_TYPE ,');
8438: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk5_column_type => l_obj_tbl(l_cur_num).PK5_COLUMN_TYPE ,');
8439: UTL_FILE.PUT_LINE ( p_file_ptr,' x_application_id => l_obj_tbl(l_cur_num).APPLICATION_ID ,');
8440: UTL_FILE.PUT_LINE ( p_file_ptr,' x_database_object_name => l_obj_tbl(l_cur_num).DATABASE_OBJECT_NAME,');
8441: UTL_FILE.PUT_LINE ( p_file_ptr,' x_display_name => l_obj_tbl(l_cur_num).OBJ_NAME,');
8442: UTL_FILE.PUT_LINE ( p_file_ptr,' x_description => l_obj_tbl(l_cur_num).OBJ_NAME,');
8443: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_update_date => sysdate,');

Line 8440: UTL_FILE.PUT_LINE ( p_file_ptr,' x_database_object_name => l_obj_tbl(l_cur_num).DATABASE_OBJECT_NAME,');

8436: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk3_column_type => l_obj_tbl(l_cur_num).PK3_COLUMN_TYPE ,');
8437: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk4_column_type => l_obj_tbl(l_cur_num).PK4_COLUMN_TYPE ,');
8438: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk5_column_type => l_obj_tbl(l_cur_num).PK5_COLUMN_TYPE ,');
8439: UTL_FILE.PUT_LINE ( p_file_ptr,' x_application_id => l_obj_tbl(l_cur_num).APPLICATION_ID ,');
8440: UTL_FILE.PUT_LINE ( p_file_ptr,' x_database_object_name => l_obj_tbl(l_cur_num).DATABASE_OBJECT_NAME,');
8441: UTL_FILE.PUT_LINE ( p_file_ptr,' x_display_name => l_obj_tbl(l_cur_num).OBJ_NAME,');
8442: UTL_FILE.PUT_LINE ( p_file_ptr,' x_description => l_obj_tbl(l_cur_num).OBJ_NAME,');
8443: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_update_date => sysdate,');
8444: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_updated_by => nvl(fnd_global.user_id,-1),');

Line 8441: UTL_FILE.PUT_LINE ( p_file_ptr,' x_display_name => l_obj_tbl(l_cur_num).OBJ_NAME,');

8437: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk4_column_type => l_obj_tbl(l_cur_num).PK4_COLUMN_TYPE ,');
8438: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk5_column_type => l_obj_tbl(l_cur_num).PK5_COLUMN_TYPE ,');
8439: UTL_FILE.PUT_LINE ( p_file_ptr,' x_application_id => l_obj_tbl(l_cur_num).APPLICATION_ID ,');
8440: UTL_FILE.PUT_LINE ( p_file_ptr,' x_database_object_name => l_obj_tbl(l_cur_num).DATABASE_OBJECT_NAME,');
8441: UTL_FILE.PUT_LINE ( p_file_ptr,' x_display_name => l_obj_tbl(l_cur_num).OBJ_NAME,');
8442: UTL_FILE.PUT_LINE ( p_file_ptr,' x_description => l_obj_tbl(l_cur_num).OBJ_NAME,');
8443: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_update_date => sysdate,');
8444: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_updated_by => nvl(fnd_global.user_id,-1),');
8445: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_update_login => nvl(fnd_global.login_id, -1));');

Line 8442: UTL_FILE.PUT_LINE ( p_file_ptr,' x_description => l_obj_tbl(l_cur_num).OBJ_NAME,');

8438: UTL_FILE.PUT_LINE ( p_file_ptr,' x_pk5_column_type => l_obj_tbl(l_cur_num).PK5_COLUMN_TYPE ,');
8439: UTL_FILE.PUT_LINE ( p_file_ptr,' x_application_id => l_obj_tbl(l_cur_num).APPLICATION_ID ,');
8440: UTL_FILE.PUT_LINE ( p_file_ptr,' x_database_object_name => l_obj_tbl(l_cur_num).DATABASE_OBJECT_NAME,');
8441: UTL_FILE.PUT_LINE ( p_file_ptr,' x_display_name => l_obj_tbl(l_cur_num).OBJ_NAME,');
8442: UTL_FILE.PUT_LINE ( p_file_ptr,' x_description => l_obj_tbl(l_cur_num).OBJ_NAME,');
8443: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_update_date => sysdate,');
8444: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_updated_by => nvl(fnd_global.user_id,-1),');
8445: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_update_login => nvl(fnd_global.login_id, -1));');
8446:

Line 8443: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_update_date => sysdate,');

8439: UTL_FILE.PUT_LINE ( p_file_ptr,' x_application_id => l_obj_tbl(l_cur_num).APPLICATION_ID ,');
8440: UTL_FILE.PUT_LINE ( p_file_ptr,' x_database_object_name => l_obj_tbl(l_cur_num).DATABASE_OBJECT_NAME,');
8441: UTL_FILE.PUT_LINE ( p_file_ptr,' x_display_name => l_obj_tbl(l_cur_num).OBJ_NAME,');
8442: UTL_FILE.PUT_LINE ( p_file_ptr,' x_description => l_obj_tbl(l_cur_num).OBJ_NAME,');
8443: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_update_date => sysdate,');
8444: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_updated_by => nvl(fnd_global.user_id,-1),');
8445: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_update_login => nvl(fnd_global.login_id, -1));');
8446:
8447: UTL_FILE.PUT_LINE ( p_file_ptr,' END IF;');

Line 8444: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_updated_by => nvl(fnd_global.user_id,-1),');

8440: UTL_FILE.PUT_LINE ( p_file_ptr,' x_database_object_name => l_obj_tbl(l_cur_num).DATABASE_OBJECT_NAME,');
8441: UTL_FILE.PUT_LINE ( p_file_ptr,' x_display_name => l_obj_tbl(l_cur_num).OBJ_NAME,');
8442: UTL_FILE.PUT_LINE ( p_file_ptr,' x_description => l_obj_tbl(l_cur_num).OBJ_NAME,');
8443: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_update_date => sysdate,');
8444: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_updated_by => nvl(fnd_global.user_id,-1),');
8445: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_update_login => nvl(fnd_global.login_id, -1));');
8446:
8447: UTL_FILE.PUT_LINE ( p_file_ptr,' END IF;');
8448: UTL_FILE.PUT_LINE ( p_file_ptr,' END LOOP;');

Line 8445: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_update_login => nvl(fnd_global.login_id, -1));');

8441: UTL_FILE.PUT_LINE ( p_file_ptr,' x_display_name => l_obj_tbl(l_cur_num).OBJ_NAME,');
8442: UTL_FILE.PUT_LINE ( p_file_ptr,' x_description => l_obj_tbl(l_cur_num).OBJ_NAME,');
8443: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_update_date => sysdate,');
8444: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_updated_by => nvl(fnd_global.user_id,-1),');
8445: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_update_login => nvl(fnd_global.login_id, -1));');
8446:
8447: UTL_FILE.PUT_LINE ( p_file_ptr,' END IF;');
8448: UTL_FILE.PUT_LINE ( p_file_ptr,' END LOOP;');
8449:

Line 8447: UTL_FILE.PUT_LINE ( p_file_ptr,' END IF;');

8443: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_update_date => sysdate,');
8444: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_updated_by => nvl(fnd_global.user_id,-1),');
8445: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_update_login => nvl(fnd_global.login_id, -1));');
8446:
8447: UTL_FILE.PUT_LINE ( p_file_ptr,' END IF;');
8448: UTL_FILE.PUT_LINE ( p_file_ptr,' END LOOP;');
8449:
8450: UTL_FILE.PUT_LINE ( p_file_ptr,'END;');
8451: UTL_FILE.PUT_LINE ( p_file_ptr,'/');

Line 8448: UTL_FILE.PUT_LINE ( p_file_ptr,' END LOOP;');

8444: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_updated_by => nvl(fnd_global.user_id,-1),');
8445: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_update_login => nvl(fnd_global.login_id, -1));');
8446:
8447: UTL_FILE.PUT_LINE ( p_file_ptr,' END IF;');
8448: UTL_FILE.PUT_LINE ( p_file_ptr,' END LOOP;');
8449:
8450: UTL_FILE.PUT_LINE ( p_file_ptr,'END;');
8451: UTL_FILE.PUT_LINE ( p_file_ptr,'/');
8452: UTL_FILE.FFLUSH ( p_file_ptr );

Line 8450: UTL_FILE.PUT_LINE ( p_file_ptr,'END;');

8446:
8447: UTL_FILE.PUT_LINE ( p_file_ptr,' END IF;');
8448: UTL_FILE.PUT_LINE ( p_file_ptr,' END LOOP;');
8449:
8450: UTL_FILE.PUT_LINE ( p_file_ptr,'END;');
8451: UTL_FILE.PUT_LINE ( p_file_ptr,'/');
8452: UTL_FILE.FFLUSH ( p_file_ptr );
8453:
8454:

Line 8451: UTL_FILE.PUT_LINE ( p_file_ptr,'/');

8447: UTL_FILE.PUT_LINE ( p_file_ptr,' END IF;');
8448: UTL_FILE.PUT_LINE ( p_file_ptr,' END LOOP;');
8449:
8450: UTL_FILE.PUT_LINE ( p_file_ptr,'END;');
8451: UTL_FILE.PUT_LINE ( p_file_ptr,'/');
8452: UTL_FILE.FFLUSH ( p_file_ptr );
8453:
8454:
8455: END Generate_Objects_SQL;

Line 8452: UTL_FILE.FFLUSH ( p_file_ptr );

8448: UTL_FILE.PUT_LINE ( p_file_ptr,' END LOOP;');
8449:
8450: UTL_FILE.PUT_LINE ( p_file_ptr,'END;');
8451: UTL_FILE.PUT_LINE ( p_file_ptr,'/');
8452: UTL_FILE.FFLUSH ( p_file_ptr );
8453:
8454:
8455: END Generate_Objects_SQL;
8456:

Line 8479: l_in_file_ptr UTL_FILE.FILE_TYPE;

8475:
8476:
8477: l_api_name CONSTANT VARCHAR2(30) := 'Generate_SQL_file';
8478: l_api_version CONSTANT NUMBER := 1.0;
8479: l_in_file_ptr UTL_FILE.FILE_TYPE;
8480: l_out_file_ptr UTL_FILE.FILE_TYPE;
8481: l_line VARCHAR2(2000);
8482: l_line2 VARCHAR2(2000);
8483: l_attr_val VARCHAR2(255);

Line 8480: l_out_file_ptr UTL_FILE.FILE_TYPE;

8476:
8477: l_api_name CONSTANT VARCHAR2(30) := 'Generate_SQL_file';
8478: l_api_version CONSTANT NUMBER := 1.0;
8479: l_in_file_ptr UTL_FILE.FILE_TYPE;
8480: l_out_file_ptr UTL_FILE.FILE_TYPE;
8481: l_line VARCHAR2(2000);
8482: l_line2 VARCHAR2(2000);
8483: l_attr_val VARCHAR2(255);
8484:

Line 8506: l_in_file_ptr := UTL_FILE.FOPEN ( p_dirpath, p_in_file_name, 'r',2000 );

8502: IF FND_API.to_Boolean (p_init_msg_list) THEN
8503: FND_MSG_PUB.initialize;
8504: END IF;
8505:
8506: l_in_file_ptr := UTL_FILE.FOPEN ( p_dirpath, p_in_file_name, 'r',2000 );
8507: l_out_file_ptr := UTL_FILE.FOPEN ( p_dirpath, p_out_file_name, 'a',2000 );
8508:
8509: -- Put header infomation
8510: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM +=======================================================================+' );

Line 8507: l_out_file_ptr := UTL_FILE.FOPEN ( p_dirpath, p_out_file_name, 'a',2000 );

8503: FND_MSG_PUB.initialize;
8504: END IF;
8505:
8506: l_in_file_ptr := UTL_FILE.FOPEN ( p_dirpath, p_in_file_name, 'r',2000 );
8507: l_out_file_ptr := UTL_FILE.FOPEN ( p_dirpath, p_out_file_name, 'a',2000 );
8508:
8509: -- Put header infomation
8510: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM +=======================================================================+' );
8511: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | Copyright (c) 1998 Oracle Corporation, Redwood Shores, CA, USA |' );

Line 8510: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM +=======================================================================+' );

8506: l_in_file_ptr := UTL_FILE.FOPEN ( p_dirpath, p_in_file_name, 'r',2000 );
8507: l_out_file_ptr := UTL_FILE.FOPEN ( p_dirpath, p_out_file_name, 'a',2000 );
8508:
8509: -- Put header infomation
8510: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM +=======================================================================+' );
8511: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | Copyright (c) 1998 Oracle Corporation, Redwood Shores, CA, USA |' );
8512: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM +=======================================================================+' );
8513: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | FILENAME |' );
8514: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | IGSSC001.sql |' );

Line 8511: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | Copyright (c) 1998 Oracle Corporation, Redwood Shores, CA, USA |' );

8507: l_out_file_ptr := UTL_FILE.FOPEN ( p_dirpath, p_out_file_name, 'a',2000 );
8508:
8509: -- Put header infomation
8510: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM +=======================================================================+' );
8511: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | Copyright (c) 1998 Oracle Corporation, Redwood Shores, CA, USA |' );
8512: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM +=======================================================================+' );
8513: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | FILENAME |' );
8514: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | IGSSC001.sql |' );
8515: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | |' );

Line 8512: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM +=======================================================================+' );

8508:
8509: -- Put header infomation
8510: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM +=======================================================================+' );
8511: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | Copyright (c) 1998 Oracle Corporation, Redwood Shores, CA, USA |' );
8512: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM +=======================================================================+' );
8513: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | FILENAME |' );
8514: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | IGSSC001.sql |' );
8515: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | |' );
8516: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | DESCRIPTION |' );

Line 8513: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | FILENAME |' );

8509: -- Put header infomation
8510: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM +=======================================================================+' );
8511: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | Copyright (c) 1998 Oracle Corporation, Redwood Shores, CA, USA |' );
8512: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM +=======================================================================+' );
8513: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | FILENAME |' );
8514: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | IGSSC001.sql |' );
8515: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | |' );
8516: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | DESCRIPTION |' );
8517: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | this file si generated by IGS security package |' );

Line 8514: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | IGSSC001.sql |' );

8510: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM +=======================================================================+' );
8511: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | Copyright (c) 1998 Oracle Corporation, Redwood Shores, CA, USA |' );
8512: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM +=======================================================================+' );
8513: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | FILENAME |' );
8514: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | IGSSC001.sql |' );
8515: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | |' );
8516: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | DESCRIPTION |' );
8517: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | this file si generated by IGS security package |' );
8518: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | It contains seed data SQL for SEED115 ONLY | ' );

Line 8515: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | |' );

8511: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | Copyright (c) 1998 Oracle Corporation, Redwood Shores, CA, USA |' );
8512: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM +=======================================================================+' );
8513: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | FILENAME |' );
8514: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | IGSSC001.sql |' );
8515: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | |' );
8516: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | DESCRIPTION |' );
8517: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | this file si generated by IGS security package |' );
8518: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | It contains seed data SQL for SEED115 ONLY | ' );
8519: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | Never apply to any other environments |' );

Line 8516: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | DESCRIPTION |' );

8512: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM +=======================================================================+' );
8513: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | FILENAME |' );
8514: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | IGSSC001.sql |' );
8515: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | |' );
8516: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | DESCRIPTION |' );
8517: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | this file si generated by IGS security package |' );
8518: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | It contains seed data SQL for SEED115 ONLY | ' );
8519: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | Never apply to any other environments |' );
8520: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM +=======================================================================+' );

Line 8517: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | this file si generated by IGS security package |' );

8513: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | FILENAME |' );
8514: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | IGSSC001.sql |' );
8515: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | |' );
8516: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | DESCRIPTION |' );
8517: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | this file si generated by IGS security package |' );
8518: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | It contains seed data SQL for SEED115 ONLY | ' );
8519: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | Never apply to any other environments |' );
8520: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM +=======================================================================+' );
8521:

Line 8518: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | It contains seed data SQL for SEED115 ONLY | ' );

8514: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | IGSSC001.sql |' );
8515: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | |' );
8516: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | DESCRIPTION |' );
8517: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | this file si generated by IGS security package |' );
8518: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | It contains seed data SQL for SEED115 ONLY | ' );
8519: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | Never apply to any other environments |' );
8520: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM +=======================================================================+' );
8521:
8522: UTL_FILE.PUT_LINE ( l_out_file_ptr,'SET VERIFY OFF;' );

Line 8519: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | Never apply to any other environments |' );

8515: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | |' );
8516: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | DESCRIPTION |' );
8517: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | this file si generated by IGS security package |' );
8518: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | It contains seed data SQL for SEED115 ONLY | ' );
8519: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | Never apply to any other environments |' );
8520: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM +=======================================================================+' );
8521:
8522: UTL_FILE.PUT_LINE ( l_out_file_ptr,'SET VERIFY OFF;' );
8523: UTL_FILE.PUT_LINE ( l_out_file_ptr,'WHENEVER OSERROR EXIT FAILURE ROLLBACK;' );

Line 8520: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM +=======================================================================+' );

8516: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | DESCRIPTION |' );
8517: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | this file si generated by IGS security package |' );
8518: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | It contains seed data SQL for SEED115 ONLY | ' );
8519: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | Never apply to any other environments |' );
8520: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM +=======================================================================+' );
8521:
8522: UTL_FILE.PUT_LINE ( l_out_file_ptr,'SET VERIFY OFF;' );
8523: UTL_FILE.PUT_LINE ( l_out_file_ptr,'WHENEVER OSERROR EXIT FAILURE ROLLBACK;' );
8524: UTL_FILE.PUT_LINE ( l_out_file_ptr,'WHENEVER SQLERROR EXIT FAILURE ROLLBACK;' );

Line 8522: UTL_FILE.PUT_LINE ( l_out_file_ptr,'SET VERIFY OFF;' );

8518: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | It contains seed data SQL for SEED115 ONLY | ' );
8519: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | Never apply to any other environments |' );
8520: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM +=======================================================================+' );
8521:
8522: UTL_FILE.PUT_LINE ( l_out_file_ptr,'SET VERIFY OFF;' );
8523: UTL_FILE.PUT_LINE ( l_out_file_ptr,'WHENEVER OSERROR EXIT FAILURE ROLLBACK;' );
8524: UTL_FILE.PUT_LINE ( l_out_file_ptr,'WHENEVER SQLERROR EXIT FAILURE ROLLBACK;' );
8525:
8526:

Line 8523: UTL_FILE.PUT_LINE ( l_out_file_ptr,'WHENEVER OSERROR EXIT FAILURE ROLLBACK;' );

8519: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM | Never apply to any other environments |' );
8520: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM +=======================================================================+' );
8521:
8522: UTL_FILE.PUT_LINE ( l_out_file_ptr,'SET VERIFY OFF;' );
8523: UTL_FILE.PUT_LINE ( l_out_file_ptr,'WHENEVER OSERROR EXIT FAILURE ROLLBACK;' );
8524: UTL_FILE.PUT_LINE ( l_out_file_ptr,'WHENEVER SQLERROR EXIT FAILURE ROLLBACK;' );
8525:
8526:
8527:

Line 8524: UTL_FILE.PUT_LINE ( l_out_file_ptr,'WHENEVER SQLERROR EXIT FAILURE ROLLBACK;' );

8520: UTL_FILE.PUT_LINE ( l_out_file_ptr,'REM +=======================================================================+' );
8521:
8522: UTL_FILE.PUT_LINE ( l_out_file_ptr,'SET VERIFY OFF;' );
8523: UTL_FILE.PUT_LINE ( l_out_file_ptr,'WHENEVER OSERROR EXIT FAILURE ROLLBACK;' );
8524: UTL_FILE.PUT_LINE ( l_out_file_ptr,'WHENEVER SQLERROR EXIT FAILURE ROLLBACK;' );
8525:
8526:
8527:
8528: -- UTL_FILE.PUT_LINE ( l_out_file_ptr, '# ' );

Line 8528: -- UTL_FILE.PUT_LINE ( l_out_file_ptr, '# ' );

8524: UTL_FILE.PUT_LINE ( l_out_file_ptr,'WHENEVER SQLERROR EXIT FAILURE ROLLBACK;' );
8525:
8526:
8527:
8528: -- UTL_FILE.PUT_LINE ( l_out_file_ptr, '# ' );
8529: -- UTL_FILE.FFLUSH ( l_out_file_ptr );
8530: Generate_Objects_SQL (l_out_file_ptr);
8531:
8532: BEGIN

Line 8529: -- UTL_FILE.FFLUSH ( l_out_file_ptr );

8525:
8526:
8527:
8528: -- UTL_FILE.PUT_LINE ( l_out_file_ptr, '# ' );
8529: -- UTL_FILE.FFLUSH ( l_out_file_ptr );
8530: Generate_Objects_SQL (l_out_file_ptr);
8531:
8532: BEGIN
8533: LOOP

Line 8534: UTL_FILE.GET_LINE ( l_in_file_ptr, l_line );

8530: Generate_Objects_SQL (l_out_file_ptr);
8531:
8532: BEGIN
8533: LOOP
8534: UTL_FILE.GET_LINE ( l_in_file_ptr, l_line );
8535: UTL_FILE.GET_LINE ( l_in_file_ptr, l_line2 );
8536:
8537: UTL_FILE.PUT_LINE ( l_out_file_ptr, 'DELETE FROM '||ltrim(rtrim(l_line))||' WHERE '||replace_string(l_line2,':1','1')||';' );
8538: UTL_FILE.FFLUSH ( l_out_file_ptr );

Line 8535: UTL_FILE.GET_LINE ( l_in_file_ptr, l_line2 );

8531:
8532: BEGIN
8533: LOOP
8534: UTL_FILE.GET_LINE ( l_in_file_ptr, l_line );
8535: UTL_FILE.GET_LINE ( l_in_file_ptr, l_line2 );
8536:
8537: UTL_FILE.PUT_LINE ( l_out_file_ptr, 'DELETE FROM '||ltrim(rtrim(l_line))||' WHERE '||replace_string(l_line2,':1','1')||';' );
8538: UTL_FILE.FFLUSH ( l_out_file_ptr );
8539:

Line 8537: UTL_FILE.PUT_LINE ( l_out_file_ptr, 'DELETE FROM '||ltrim(rtrim(l_line))||' WHERE '||replace_string(l_line2,':1','1')||';' );

8533: LOOP
8534: UTL_FILE.GET_LINE ( l_in_file_ptr, l_line );
8535: UTL_FILE.GET_LINE ( l_in_file_ptr, l_line2 );
8536:
8537: UTL_FILE.PUT_LINE ( l_out_file_ptr, 'DELETE FROM '||ltrim(rtrim(l_line))||' WHERE '||replace_string(l_line2,':1','1')||';' );
8538: UTL_FILE.FFLUSH ( l_out_file_ptr );
8539:
8540: Generate_Table_SQL (ltrim(rtrim(l_line)),l_line2,'1', l_out_file_ptr);
8541:

Line 8538: UTL_FILE.FFLUSH ( l_out_file_ptr );

8534: UTL_FILE.GET_LINE ( l_in_file_ptr, l_line );
8535: UTL_FILE.GET_LINE ( l_in_file_ptr, l_line2 );
8536:
8537: UTL_FILE.PUT_LINE ( l_out_file_ptr, 'DELETE FROM '||ltrim(rtrim(l_line))||' WHERE '||replace_string(l_line2,':1','1')||';' );
8538: UTL_FILE.FFLUSH ( l_out_file_ptr );
8539:
8540: Generate_Table_SQL (ltrim(rtrim(l_line)),l_line2,'1', l_out_file_ptr);
8541:
8542:

Line 8552: UTL_FILE.PUT_LINE ( l_out_file_ptr,'COMMIT;');

8548: WHEN OTHERS THEN
8549: RAISE;
8550: END;
8551:
8552: UTL_FILE.PUT_LINE ( l_out_file_ptr,'COMMIT;');
8553: UTL_FILE.PUT_LINE ( l_out_file_ptr,'EXIT;');
8554: UTL_FILE.FFLUSH ( l_out_file_ptr );
8555:
8556: IF (UTL_FILE.IS_OPEN ( l_out_file_ptr )) THEN

Line 8553: UTL_FILE.PUT_LINE ( l_out_file_ptr,'EXIT;');

8549: RAISE;
8550: END;
8551:
8552: UTL_FILE.PUT_LINE ( l_out_file_ptr,'COMMIT;');
8553: UTL_FILE.PUT_LINE ( l_out_file_ptr,'EXIT;');
8554: UTL_FILE.FFLUSH ( l_out_file_ptr );
8555:
8556: IF (UTL_FILE.IS_OPEN ( l_out_file_ptr )) THEN
8557: UTL_FILE.FCLOSE ( l_out_file_ptr );

Line 8554: UTL_FILE.FFLUSH ( l_out_file_ptr );

8550: END;
8551:
8552: UTL_FILE.PUT_LINE ( l_out_file_ptr,'COMMIT;');
8553: UTL_FILE.PUT_LINE ( l_out_file_ptr,'EXIT;');
8554: UTL_FILE.FFLUSH ( l_out_file_ptr );
8555:
8556: IF (UTL_FILE.IS_OPEN ( l_out_file_ptr )) THEN
8557: UTL_FILE.FCLOSE ( l_out_file_ptr );
8558: END IF;

Line 8556: IF (UTL_FILE.IS_OPEN ( l_out_file_ptr )) THEN

8552: UTL_FILE.PUT_LINE ( l_out_file_ptr,'COMMIT;');
8553: UTL_FILE.PUT_LINE ( l_out_file_ptr,'EXIT;');
8554: UTL_FILE.FFLUSH ( l_out_file_ptr );
8555:
8556: IF (UTL_FILE.IS_OPEN ( l_out_file_ptr )) THEN
8557: UTL_FILE.FCLOSE ( l_out_file_ptr );
8558: END IF;
8559:
8560: EXCEPTION

Line 8557: UTL_FILE.FCLOSE ( l_out_file_ptr );

8553: UTL_FILE.PUT_LINE ( l_out_file_ptr,'EXIT;');
8554: UTL_FILE.FFLUSH ( l_out_file_ptr );
8555:
8556: IF (UTL_FILE.IS_OPEN ( l_out_file_ptr )) THEN
8557: UTL_FILE.FCLOSE ( l_out_file_ptr );
8558: END IF;
8559:
8560: EXCEPTION
8561: WHEN UTL_FILE.INVALID_PATH THEN

Line 8561: WHEN UTL_FILE.INVALID_PATH THEN

8557: UTL_FILE.FCLOSE ( l_out_file_ptr );
8558: END IF;
8559:
8560: EXCEPTION
8561: WHEN UTL_FILE.INVALID_PATH THEN
8562: ROLLBACK TO Generate_SQL_file;
8563: x_return_status := FND_API.G_RET_STS_ERROR;
8564: FND_MESSAGE.set_name('IGS', 'IGS_DS_INVALID_PATH');
8565: FND_MSG_PUB.Add;

Line 8567: WHEN UTL_FILE.WRITE_ERROR THEN

8563: x_return_status := FND_API.G_RET_STS_ERROR;
8564: FND_MESSAGE.set_name('IGS', 'IGS_DS_INVALID_PATH');
8565: FND_MSG_PUB.Add;
8566:
8567: WHEN UTL_FILE.WRITE_ERROR THEN
8568: ROLLBACK TO Generate_SQL_file;
8569: x_return_status := FND_API.G_RET_STS_ERROR;
8570: FND_MESSAGE.set_name('IGS', 'IGS_DS_WRITE_ERROR');
8571: FND_MSG_PUB.Add;

Line 8573: WHEN UTL_FILE.INVALID_FILEHANDLE THEN

8569: x_return_status := FND_API.G_RET_STS_ERROR;
8570: FND_MESSAGE.set_name('IGS', 'IGS_DS_WRITE_ERROR');
8571: FND_MSG_PUB.Add;
8572:
8573: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
8574: ROLLBACK TO Generate_SQL_file;
8575: x_return_status := FND_API.G_RET_STS_ERROR;
8576: FND_MESSAGE.set_name('IGS', 'IGS_DS_INVALID_FILEHANDLE');
8577: FND_MSG_PUB.Add;

Line 8583: IF (UTL_FILE.IS_OPEN ( l_out_file_ptr )) THEN

8579: WHEN FND_API.G_EXC_ERROR THEN
8580:
8581: ROLLBACK TO Generate_SQL_file;
8582: x_return_status := FND_API.G_RET_STS_ERROR;
8583: IF (UTL_FILE.IS_OPEN ( l_out_file_ptr )) THEN
8584: UTL_FILE.FCLOSE ( l_out_file_ptr );
8585: END IF;
8586: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
8587: p_data => x_msg_data );

Line 8584: UTL_FILE.FCLOSE ( l_out_file_ptr );

8580:
8581: ROLLBACK TO Generate_SQL_file;
8582: x_return_status := FND_API.G_RET_STS_ERROR;
8583: IF (UTL_FILE.IS_OPEN ( l_out_file_ptr )) THEN
8584: UTL_FILE.FCLOSE ( l_out_file_ptr );
8585: END IF;
8586: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
8587: p_data => x_msg_data );
8588:

Line 8594: IF (UTL_FILE.IS_OPEN ( l_out_file_ptr )) THEN

8590:
8591: ROLLBACK TO Generate_SQL_file;
8592:
8593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8594: IF (UTL_FILE.IS_OPEN ( l_out_file_ptr )) THEN
8595: UTL_FILE.FCLOSE ( l_out_file_ptr );
8596: END IF;
8597: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
8598: p_data => x_msg_data );

Line 8595: UTL_FILE.FCLOSE ( l_out_file_ptr );

8591: ROLLBACK TO Generate_SQL_file;
8592:
8593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8594: IF (UTL_FILE.IS_OPEN ( l_out_file_ptr )) THEN
8595: UTL_FILE.FCLOSE ( l_out_file_ptr );
8596: END IF;
8597: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
8598: p_data => x_msg_data );
8599:

Line 8609: IF (UTL_FILE.IS_OPEN ( l_out_file_ptr )) THEN

8605: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
8606: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
8607: END IF;
8608:
8609: IF (UTL_FILE.IS_OPEN ( l_out_file_ptr )) THEN
8610: UTL_FILE.FCLOSE ( l_out_file_ptr );
8611: END IF;
8612:
8613: END Generate_SQL_file;

Line 8610: UTL_FILE.FCLOSE ( l_out_file_ptr );

8606: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
8607: END IF;
8608:
8609: IF (UTL_FILE.IS_OPEN ( l_out_file_ptr )) THEN
8610: UTL_FILE.FCLOSE ( l_out_file_ptr );
8611: END IF;
8612:
8613: END Generate_SQL_file;
8614: