[Home] [Help]
1429: | |
1430: | |
1431: +========================================================================*/
1432:
1433: PROCEDURE copy_text_record( p_old_text_code IN OP_TEXT_HDR.TEXT_CODE%TYPE ,
1434: p_new_text_code IN OP_TEXT_HDR.TEXT_CODE%TYPE ,
1435: p_user_id IN OP_TEXT_HDR.CREATED_BY%TYPE
1436: ) IS
1437: /* Cursors */
1430: | |
1431: +========================================================================*/
1432:
1433: PROCEDURE copy_text_record( p_old_text_code IN OP_TEXT_HDR.TEXT_CODE%TYPE ,
1434: p_new_text_code IN OP_TEXT_HDR.TEXT_CODE%TYPE ,
1435: p_user_id IN OP_TEXT_HDR.CREATED_BY%TYPE
1436: ) IS
1437: /* Cursors */
1438: CURSOR Cur_text_tbl_tl IS
1431: +========================================================================*/
1432:
1433: PROCEDURE copy_text_record( p_old_text_code IN OP_TEXT_HDR.TEXT_CODE%TYPE ,
1434: p_new_text_code IN OP_TEXT_HDR.TEXT_CODE%TYPE ,
1435: p_user_id IN OP_TEXT_HDR.CREATED_BY%TYPE
1436: ) IS
1437: /* Cursors */
1438: CURSOR Cur_text_tbl_tl IS
1439: SELECT *
1442:
1443: BEGIN
1444:
1445: /* Now create the text header record. */
1446: INSERT INTO OP_TEXT_HDR
1447: ( text_code , creation_date ,
1448: created_by , last_update_date ,
1449: last_updated_by , last_update_login
1450: )