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.PO_GEN_DIFF_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 91


l_insert_stmt CLOB;

Line: 245


l_temp := 'INSERT INTO PO_ENTITY_GT ( PK1_VALUE, PK2_VALUE, PK3_VALUE, PK4_VALUE, PK5_VALUE, COL_NAME, COL_VALUE, COL_DESC )
	   select PK1_VALUE, PK2_VALUE, PK3_VALUE, PK4_VALUE, PK5_VALUE, COL_NAME, COL_VALUE, COL_DESC from '|| base_doc_source;

Line: 251


      	FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' base records inserted into gt');

Line: 257


l_temp := 'INSERT INTO PO_ENTITY_GT ( PK1_VALUE, PK2_VALUE, PK3_VALUE, PK4_VALUE, PK5_VALUE, COL_NAME, COL_VALUE, COL_DESC )
	   select PK1_VALUE, PK2_VALUE, PK3_VALUE, PK4_VALUE, PK5_VALUE, COL_NAME, COL_VALUE, COL_DESC from '|| mod_doc_source;

Line: 263


      	FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' mod records inserted into gt');

Line: 285


l_sql_stmt := 'SELECT ' || base_source_alias || '.pk1_value, ' ||
			base_source_alias || '.pk2_value, ' ||
			base_source_alias || '.pk3_value, ' ||
			base_source_alias || '.pk4_value, ' ||
			base_source_alias || '.pk5_value, ' ||
			mod_source_alias || '.pk1_value, ' ||
			mod_source_alias || '.pk2_value, ' ||
			mod_source_alias || '.pk3_value, ' ||
			mod_source_alias || '.pk4_value, ' ||
			mod_source_alias || '.pk5_value, ' ||
			mod_source_alias || '.col_name, ' ||
			base_source_alias || '.col_value old_value, ' ||
			mod_source_alias || '.col_value new_value, ' ||
			base_source_alias || '.col_desc old_desc, ' ||
			mod_source_alias || '.col_desc new_desc '||
		' FROM PO_ENTITY_GT ' || base_source_alias || ', PO_ENTITY_GT ' || mod_source_alias ||
		' WHERE '|| l_sql_where;

Line: 315


          	INSERT INTO po_entity_differences (diff_id, document_type, entity_name, mod_doc_source_name, base_doc_pk1_val, base_doc_pk2_val,
							base_doc_pk3_val, base_doc_pk4_val, base_doc_pk5_val, mod_doc_pk1_val, mod_doc_pk2_val,
							mod_doc_pk3_val, mod_doc_pk4_val, mod_doc_pk5_val, column_name, mod_value, orig_value,
							mod_value_desc, orig_value_desc, creation_date,	created_by, last_update_date, last_updated_by)
			    values(PO_ENTITY_DIFFERENCES_S.nextval, p_document_type, p_entity_name, mod_doc_source, base_pk1_value_tbl(i), base_pk2_value_tbl(i),
						base_pk3_value_tbl(i), base_pk4_value_tbl(i), base_pk5_value_tbl(i), mod_pk1_value_tbl(i), mod_pk2_value_tbl(i),
						mod_pk3_value_tbl(i), mod_pk4_value_tbl(i), mod_pk5_value_tbl(i), l_colname_tbl(i), l_newvalue_tbl(i),
						l_oldvalue_tbl(i), l_newvalue_desc_tbl(i), l_oldvalue_desc_tbl(i), sysdate, l_current_user_id, sysdate, l_current_user_id);

Line: 326


	        INSERT INTO pon_entity_differences (diff_id, document_type, entity_name, mod_doc_source_name, base_doc_pk1_val, base_doc_pk2_val,
							base_doc_pk3_val, base_doc_pk4_val, base_doc_pk5_val, mod_doc_pk1_val, mod_doc_pk2_val,
							mod_doc_pk3_val, mod_doc_pk4_val, mod_doc_pk5_val, column_name, mod_value, orig_value,
							mod_value_desc, orig_value_desc, creation_date,	created_by, last_update_date, last_updated_by)
			    values(PON_ENTITY_DIFFERENCES_S.nextval,p_document_type, p_entity_name, mod_doc_source, base_pk1_value_tbl(i), base_pk2_value_tbl(i),
						base_pk3_value_tbl(i), base_pk4_value_tbl(i), base_pk5_value_tbl(i), mod_pk1_value_tbl(i), mod_pk2_value_tbl(i),
						mod_pk3_value_tbl(i), mod_pk4_value_tbl(i), mod_pk5_value_tbl(i), l_colname_tbl(i), l_newvalue_tbl(i),
						l_oldvalue_tbl(i), l_newvalue_desc_tbl(i), l_oldvalue_desc_tbl(i), sysdate, l_current_user_id, sysdate, l_current_user_id);

Line: 339


      	FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' differences inserted into '||dest_table_name);

Line: 344


delete from PO_ENTITY_GT;

Line: 348


      	FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' deleted records from gt');

Line: 386


SELECT DISTINCT entity_name, base_doc_source_name, mod_doc_source_name FROM po_diff_config WHERE document_type = p_document_type and nvl(ignore_source_flag, 'N') = 'N';

Line: 389


SELECT DISTINCT base_doc_source_name, mod_doc_source_name FROM po_diff_config WHERE document_type = p_document_type and entity_name = p_entity_name and nvl(ignore_source_flag, 'N') = 'N';

Line: 392


SELECT column_name FROM po_diff_config WHERE document_type = p_document_type and entity_name = l_entity_name and
						base_doc_source_name = l_base_doc_source_name and mod_doc_source_name = l_mod_doc_source_name
						and nvl(cmp_filter_pred_flag, 'N') = 'Y';

Line: 495


PROCEDURE delete_differences (p_document_type VARCHAR2,
				p_entity_name VARCHAR2,
				dest_table_name VARCHAR2,
				base_pk1_value NUMBER,
				base_pk2_value NUMBER,
				base_pk3_value NUMBER,
				base_pk4_value NUMBER,
				base_pk5_value NUMBER,
				mod_pk1_value NUMBER,
				mod_pk2_value NUMBER,
				mod_pk3_value NUMBER,
				mod_pk4_value NUMBER,
				mod_pk5_value NUMBER) IS

l_sql_stmt VARCHAR2(2000);

Line: 517


      	FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Begin proc: delete_differences');

Line: 613


l_sql_stmt := 'DELETE FROM ' || dest_table_name || ' ' || l_where_stmt;

Line: 618


      	FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' deleted differences from '||dest_table_name);

Line: 624


      	FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' End proc: delete_differences');

Line: 719


  SELECT      base.pk1_value,
              base.pk2_value,
              base.pk3_value,
              base.pk4_value,
              base.pk5_value,
              par.pk1_value,
              par.pk2_value,
              par.pk3_value,
              par.pk4_value,
              par.pk5_value,
              par.col_name,
              base.col_value old_value,
              par.col_value new_value,
              par.col_desc
  BULK COLLECT
  INTO        base_pk1_value_tbl,
              base_pk2_value_tbl,
              base_pk3_value_tbl,
              base_pk4_value_tbl,
              base_pk5_value_tbl,
              par_pk1_value_tbl,
              par_pk2_value_tbl,
              par_pk3_value_tbl,
              par_pk4_value_tbl,
              par_pk5_value_tbl,
              l_colname_tbl,
              l_oldvalue_tbl,
              l_newvalue_tbl,
              l_entity_tbl
  FROM PO_ENTITY_GT base, PO_ENTITY_GT par
  WHERE base.pk1_value (+) = base_pk1
  AND   base.pk2_value (+) = -1
  AND   par.pk1_value = mod_pk1
  AND   par.pk2_value = mod_pk2
  AND   base.col_name (+) = par.col_name
  AND   base.col_desc (+) = par.col_desc   --col_desc in case of PAR comparisons corresponds to entity level
  AND   Nvl(base.pk3_value (+), -9999)  = Nvl(par.pk3_value, -9999)
  AND   Nvl(base.pk4_value (+), -9999)  = Nvl(par.pk4_value, -9999)
  AND   Nvl(base.pk5_value (+), -9999) = Nvl(par.pk5_value, -9999)
  AND   nvl(base.col_value, G_NULL_CHAR) <> Nvl(par.col_value, G_NULL_CHAR);

Line: 764


    INSERT INTO po_entity_differences (
       diff_id,
       document_type,
       entity_name,
       mod_doc_source_name,
       base_doc_pk1_val,
       base_doc_pk2_val,
       base_doc_pk3_val,
       base_doc_pk4_val,
       base_doc_pk5_val,
       mod_doc_pk1_val,
       mod_doc_pk2_val,
       mod_doc_pk3_val,
       mod_doc_pk4_val,
       mod_doc_pk5_val,
       column_name,
       mod_value,
       orig_value,
       creation_date,
       created_by,
       last_update_date,
       last_updated_by)
    VALUES (
       PO_ENTITY_DIFFERENCES_S.nextval,
       p_document_type,
       Decode(l_entity_tbl(i), 'PO_HEADERS'           , 'HEADER',
                               'PO_LINES'             , 'LINE',
                               'PO_LINELOCS'          , 'LINELOCATION',
                               'PO_DISTRIBUTIONS'     , 'DISTRIBUTION',
                               'PO_HEADERS_UDA'       , 'HEADER',
                               'PO_HEADERS_ADDRESSES' , 'HEADER',
                               'PO_LINES_UDA'         , 'LINE',
                               'PO_LINELOCS_UDA'      , 'LINELOCATION',
			       'PO_ELINS'             , 'ELINS'),

       Decode(l_entity_tbl(i), 'PO_HEADERS'       , 'PO_HEADERS_DRAFT_DIFF_V',
                               'PO_LINES'         , 'PO_LINES_DRAFT_DIFF_V',
                               'PO_LINELOCS'      , 'PO_LINELOCS_DRAFT_DIFF_V',
                               'PO_DISTRIBUTIONS' , 'PO_DISTRIBUTIONS_DRAFT_DIFF_V',
                               'PO_HEADERS_UDA'   , 'PO_HEADERS_EXT_DRAFT_DIFF_V',
                               'PO_LINES_UDA'     , 'PO_LINES_EXT_DRAFT_DIFF_V',
                               'PO_LINELOCS_UDA'  , 'PO_LINE_LOCS_DRAFT_EXT_DIFF_V',
                               'PO_HEADERS_ADDRESSES' , 'PO_ADDRESSES_DRAFT_DIFF_V',
			       'PO_ELINS'         , 'PO_EXHIBITS_DRAFT_DIFF_V'),
       base_pk1_value_tbl(i),
       base_pk2_value_tbl(i),
       base_pk3_value_tbl(i),
       base_pk4_value_tbl(i),
       base_pk5_value_tbl(i),
       par_pk1_value_tbl(i),
       par_pk2_value_tbl(i),
       par_pk3_value_tbl(i),
       par_pk4_value_tbl(i),
       par_pk5_value_tbl(i),
       l_colname_tbl(i),
       l_newvalue_tbl(i),
       l_oldvalue_tbl(i),
       sysdate,
       l_current_user_id,
       sysdate,
       l_current_user_id);

Line: 826


  delete from PO_ENTITY_GT;

Line: 833


      delete from PO_ENTITY_GT;

Line: 858


  INSERT INTO PO_ENTITY_GT ( PK1_VALUE,
                             PK2_VALUE,
                             PK3_VALUE,
                             PK4_VALUE,
                             PK5_VALUE,
                             COL_NAME,
                             COL_VALUE,
                             COL_DESC
                           )
  SELECT phdv.PK1_VALUE,
         phdv.PK2_VALUE,
         phdv.PK3_VALUE,
         phdv.PK4_VALUE,
         phdv.PK5_VALUE,
         phdv.COL_NAME,
         phdv.COL_VALUE,
         'PO_HEADERS'
  FROM   PO_HEADERS_DIFF_V phdv, po_headers_draft_all phd
  WHERE  phdv.pk1_value = base_pk1
  AND    phdv.pk2_value = -1
  AND    phdv.pk1_value = phd.po_header_id
  AND    phd.draft_id   = mod_pk2
  AND    phdv.revision_num = phd.revision_num;

Line: 885


    FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from archive : ' || SQL%ROWCOUNT);

Line: 890


  INSERT INTO PO_ENTITY_GT ( PK1_VALUE,
                             PK2_VALUE,
                             PK3_VALUE,
                             PK4_VALUE,
                             PK5_VALUE,
                             COL_NAME,
                             COL_VALUE,
                             COL_DESC
                           )
  SELECT phdv.PK1_VALUE,
         phdv.PK2_VALUE,
         phdv.PK3_VALUE,
         phdv.PK4_VALUE,
         phdv.PK5_VALUE,
         phdv.COL_NAME,
         phdv.COL_VALUE,
         'PO_HEADERS_UDA'
  FROM   PO_HEADERS_EXT_DIFF_V phdv, po_headers_draft_all phd
  WHERE  phdv.pk1_value = base_pk1
  AND    phdv.pk2_value = -1
  AND    phdv.pk1_value = phd.po_header_id
  AND    phd.draft_id   = mod_pk2
  AND    phdv.revision_num = phd.revision_num;

Line: 917


    FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from uda archive : ' || SQL%ROWCOUNT);

Line: 921


  INSERT INTO PO_ENTITY_GT ( PK1_VALUE,
                             PK2_VALUE,
                             PK3_VALUE,
                             PK4_VALUE,
                             PK5_VALUE,
                             COL_NAME,
                             COL_VALUE,
                             COL_DESC
                           )
  SELECT phdv.PK1_VALUE,
         phdv.PK2_VALUE,
         phdv.PK3_VALUE,
         phdv.PK4_VALUE,
         phdv.PK5_VALUE,
         phdv.COL_NAME,
         phdv.COL_VALUE,
         'PO_HEADERS_ADDRESSES'
  FROM   PO_ADDRESSES_DIFF_V phdv, po_headers_draft_all phd
  WHERE  phdv.pk1_value = base_pk1
  AND    phdv.pk2_value = -1
  AND    phdv.pk1_value = phd.po_header_id
  AND    phd.draft_id   = mod_pk2
  AND    phdv.revision_num = phd.revision_num;

Line: 948


    FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from addresses uda archive : ' || SQL%ROWCOUNT);

Line: 952


  INSERT INTO PO_ENTITY_GT ( PK1_VALUE,
                             PK2_VALUE,
                             PK3_VALUE,
                             PK4_VALUE,
                             PK5_VALUE,
                             COL_NAME,
                             COL_VALUE,
                             COL_DESC
                           )
  SELECT phdv.PK1_VALUE,
         phdv.PK2_VALUE,
         phdv.PK3_VALUE,
         phdv.PK4_VALUE,
         phdv.PK5_VALUE,
         phdv.COL_NAME,
         phdv.COL_VALUE,
         'PO_HEADERS'
  FROM   PO_HEADERS_DRAFT_DIFF_V phdv
  WHERE  phdv.pk1_value = mod_pk1
  AND    phdv.pk2_value = mod_pk2;

Line: 975


    FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from draft : ' || SQL%ROWCOUNT);

Line: 979


  INSERT INTO PO_ENTITY_GT ( PK1_VALUE,
                             PK2_VALUE,
                             PK3_VALUE,
                             PK4_VALUE,
                             PK5_VALUE,
                             COL_NAME,
                             COL_VALUE,
                             COL_DESC
                           )
  SELECT phdv.PK1_VALUE,
         phdv.PK2_VALUE,
         phdv.PK3_VALUE,
         phdv.PK4_VALUE,
         phdv.PK5_VALUE,
         phdv.COL_NAME,
         phdv.COL_VALUE,
         'PO_HEADERS_UDA'
  FROM   PO_HEADERS_EXT_DRAFT_DIFF_V phdv
  WHERE  phdv.pk1_value = mod_pk1
  AND    phdv.pk2_value = mod_pk2;

Line: 1002


    FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from draft : ' || SQL%ROWCOUNT);

Line: 1006


  INSERT INTO PO_ENTITY_GT ( PK1_VALUE,
                             PK2_VALUE,
                             PK3_VALUE,
                             PK4_VALUE,
                             PK5_VALUE,
                             COL_NAME,
                             COL_VALUE,
                             COL_DESC
                           )
  SELECT phdv.PK1_VALUE,
         phdv.PK2_VALUE,
         phdv.PK3_VALUE,
         phdv.PK4_VALUE,
         phdv.PK5_VALUE,
         phdv.COL_NAME,
         phdv.COL_VALUE,
         'PO_HEADERS_ADDRESSES'
  FROM   PO_ADDRESSES_DRAFT_DIFF_V phdv
  WHERE  phdv.pk1_value = mod_pk1
  AND    phdv.pk2_value = mod_pk2;

Line: 1029


    FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from draft : ' || SQL%ROWCOUNT);

Line: 1039


    DELETE FROM PO_ENTITY_GT;

Line: 1064


  INSERT INTO PO_ENTITY_GT ( PK1_VALUE,
                             PK2_VALUE,
                             PK3_VALUE,
                             PK4_VALUE,
                             PK5_VALUE,
                             COL_NAME,
                             COL_VALUE,
                             COL_DESC
                           )
  SELECT pldv.PK1_VALUE,
         pldv.PK2_VALUE,
         pldv.PK3_VALUE,
         pldv.PK4_VALUE,
         pldv.PK5_VALUE,
         pldv.COL_NAME,
         pldv.COL_VALUE,
         'PO_LINES'
  FROM   PO_LINES_DIFF_V pldv, po_lines_draft_all pld
  WHERE  pldv.pk1_value = base_pk1
  AND    pldv.pk2_value = -1
  AND    pldv.pk1_value = pld.po_header_id
  AND    pldv.pk3_value = pld.po_line_id
  AND    pld.draft_id   = mod_pk2
  AND    pldv.revision_num = pld.revision_num;

Line: 1092


    FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from archive : ' || SQL%ROWCOUNT);

Line: 1096


  INSERT INTO PO_ENTITY_GT ( PK1_VALUE,
                             PK2_VALUE,
                             PK3_VALUE,
                             PK4_VALUE,
                             PK5_VALUE,
                             COL_NAME,
                             COL_VALUE,
                             COL_DESC
                           )
  SELECT pldv.PK1_VALUE,
         pldv.PK2_VALUE,
         pldv.PK3_VALUE,
         pldv.PK4_VALUE,
         pldv.PK5_VALUE,
         pldv.COL_NAME,
         pldv.COL_VALUE,
         'PO_LINES_UDA'
  FROM   PO_LINES_EXT_DIFF_V pldv, po_lines_draft_all pld
  WHERE  pldv.pk1_value = base_pk1
  AND    pldv.pk2_value = -1
  AND    pldv.pk1_value = pld.po_header_id
  AND    pldv.pk3_value = pld.po_line_id
  AND    pld.draft_id   = mod_pk2
  AND    pldv.revision_num = pld.revision_num;

Line: 1124


    FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from uda archive : ' || SQL%ROWCOUNT);

Line: 1128


  INSERT INTO PO_ENTITY_GT ( PK1_VALUE,
                             PK2_VALUE,
                             PK3_VALUE,
                             PK4_VALUE,
                             PK5_VALUE,
                             COL_NAME,
                             COL_VALUE,
                             COL_DESC
                           )
  SELECT pldv.PK1_VALUE,
         pldv.PK2_VALUE,
         pldv.PK3_VALUE,
         pldv.PK4_VALUE,
         pldv.PK5_VALUE,
         pldv.COL_NAME,
         pldv.COL_VALUE,
         'PO_LINES'
  FROM   PO_LINES_DRAFT_DIFF_V pldv
  WHERE  pldv.pk1_value = mod_pk1
  AND    pldv.pk2_value = mod_pk2;

Line: 1151


    FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from draft : ' || SQL%ROWCOUNT);

Line: 1155


  INSERT INTO PO_ENTITY_GT ( PK1_VALUE,
                             PK2_VALUE,
                             PK3_VALUE,
                             PK4_VALUE,
                             PK5_VALUE,
                             COL_NAME,
                             COL_VALUE,
                             COL_DESC
                           )
  SELECT pldv.PK1_VALUE,
         pldv.PK2_VALUE,
         pldv.PK3_VALUE,
         pldv.PK4_VALUE,
         pldv.PK5_VALUE,
         pldv.COL_NAME,
         pldv.COL_VALUE,
         'PO_LINES_UDA'
  FROM   PO_LINES_EXT_DRAFT_DIFF_V pldv
  WHERE  pldv.pk1_value = mod_pk1
  AND    pldv.pk2_value = mod_pk2;

Line: 1178


    FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from draft : ' || SQL%ROWCOUNT);

Line: 1188


    DELETE FROM PO_ENTITY_GT;

Line: 1213


  INSERT INTO PO_ENTITY_GT ( PK1_VALUE,
                             PK2_VALUE,
                             PK3_VALUE,
                             PK4_VALUE,
                             PK5_VALUE,
                             COL_NAME,
                             COL_VALUE,
                             COL_DESC
                           )
  SELECT pldv.PK1_VALUE,
         pldv.PK2_VALUE,
         pldv.PK3_VALUE,
         pldv.PK4_VALUE,
         pldv.PK5_VALUE,
         pldv.COL_NAME,
         pldv.COL_VALUE,
         'PO_LINELOCS'
  FROM   PO_LINE_LOCS_DIFF_V pldv, po_line_locations_draft_all pld
  WHERE  pldv.pk1_value = base_pk1
  AND    pldv.pk2_value = -1
  AND    pldv.pk1_value = pld.po_header_id
  AND    pldv.pk4_value = pld.line_location_id
  AND    pld.draft_id   = mod_pk2
  AND    pldv.revision_num = pld.revision_num;

Line: 1241


    FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from archive : ' || SQL%ROWCOUNT);

Line: 1245


  INSERT INTO PO_ENTITY_GT ( PK1_VALUE,
                             PK2_VALUE,
                             PK3_VALUE,
                             PK4_VALUE,
                             PK5_VALUE,
                             COL_NAME,
                             COL_VALUE,
                             COL_DESC
                           )
  SELECT pldv.PK1_VALUE,
         pldv.PK2_VALUE,
         pldv.PK3_VALUE,
         pldv.PK4_VALUE,
         pldv.PK5_VALUE,
         pldv.COL_NAME,
         pldv.COL_VALUE,
         'PO_LINELOCS_UDA'
  FROM   PO_LINE_LOCS_EXT_DIFF_V pldv, po_line_locations_draft_all pld
  WHERE  pldv.pk1_value = base_pk1
  AND    pldv.pk2_value = -1
  AND    pldv.pk1_value = pld.po_header_id
  AND    pldv.pk4_value = pld.line_location_id
  AND    pld.draft_id   = mod_pk2
  AND    pldv.revision_num = pld.revision_num;

Line: 1273


    FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from uda archive : ' || SQL%ROWCOUNT);

Line: 1277


  INSERT INTO PO_ENTITY_GT ( PK1_VALUE,
                             PK2_VALUE,
                             PK3_VALUE,
                             PK4_VALUE,
                             PK5_VALUE,
                             COL_NAME,
                             COL_VALUE,
                             COL_DESC
                           )
  SELECT pldv.PK1_VALUE,
         pldv.PK2_VALUE,
         pldv.PK3_VALUE,
         pldv.PK4_VALUE,
         pldv.PK5_VALUE,
         pldv.COL_NAME,
         pldv.COL_VALUE,
         'PO_LINELOCS'
  FROM   PO_LINE_LOCS_DRAFT_DIFF_V pldv
  WHERE  pldv.pk1_value = mod_pk1
  AND    pldv.pk2_value = mod_pk2;

Line: 1300


    FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from draft : ' || SQL%ROWCOUNT);

Line: 1304


  INSERT INTO PO_ENTITY_GT ( PK1_VALUE,
                             PK2_VALUE,
                             PK3_VALUE,
                             PK4_VALUE,
                             PK5_VALUE,
                             COL_NAME,
                             COL_VALUE,
                             COL_DESC
                           )
  SELECT pldv.PK1_VALUE,
         pldv.PK2_VALUE,
         pldv.PK3_VALUE,
         pldv.PK4_VALUE,
         pldv.PK5_VALUE,
         pldv.COL_NAME,
         pldv.COL_VALUE,
         'PO_LINELOCS_UDA'
  FROM   PO_LINE_LOCS_EXT_DRAFT_DIFF_V pldv
  WHERE  pldv.pk1_value = mod_pk1
  AND    pldv.pk2_value = mod_pk2;

Line: 1327


    FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from uda : ' || SQL%ROWCOUNT);

Line: 1338


    DELETE FROM PO_ENTITY_GT;

Line: 1363


  INSERT INTO PO_ENTITY_GT ( PK1_VALUE,
                             PK2_VALUE,
                             PK3_VALUE,
                             PK4_VALUE,
                             PK5_VALUE,
                             COL_NAME,
                             COL_VALUE,
                             COL_DESC
                           )
  SELECT pdv.PK1_VALUE,
         pdv.PK2_VALUE,
         pdv.PK3_VALUE,
         pdv.PK4_VALUE,
         pdv.PK5_VALUE,
         pdv.COL_NAME,
         pdv.COL_VALUE,
         'PO_DISTRIBUTIONS'
  FROM   PO_DISTRIBUTIONS_DIFF_V pdv, po_distributions_draft_all pd
  WHERE  pdv.pk1_value = base_pk1
  AND    pdv.pk2_value = -1
  AND    pdv.pk1_value = pd.po_header_id
  AND    pdv.pk5_value = pd.po_distribution_id
  AND    pd.draft_id   = mod_pk2
  AND    pdv.revision_num = pd.revision_num;

Line: 1391


    FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from archive : ' || SQL%ROWCOUNT);

Line: 1395


  INSERT INTO PO_ENTITY_GT ( PK1_VALUE,
                             PK2_VALUE,
                             PK3_VALUE,
                             PK4_VALUE,
                             PK5_VALUE,
                             COL_NAME,
                             COL_VALUE,
                             COL_DESC
                           )
  SELECT pdv.PK1_VALUE,
         pdv.PK2_VALUE,
         pdv.PK3_VALUE,
         pdv.PK4_VALUE,
         pdv.PK5_VALUE,
         pdv.COL_NAME,
         pdv.COL_VALUE,
         'PO_DISTRIBUTIONS'
  FROM   PO_DISTRIBUTIONS_DRAFT_DIFF_V pdv
  WHERE  pdv.pk1_value = mod_pk1
  AND    pdv.pk2_value = mod_pk2;

Line: 1418


    FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from draft : ' || SQL%ROWCOUNT);

Line: 1428


    DELETE FROM PO_ENTITY_GT;

Line: 1450


  po_wf_debug_pkg.Insert_debug(itemtype,itemkey, l_progress );

Line: 1475


  po_wf_debug_pkg.Insert_debug(itemtype,itemkey, l_progress );

Line: 1499


  INSERT INTO PO_ENTITY_GT ( PK1_VALUE,
                             PK2_VALUE,
                             PK3_VALUE,
                             PK4_VALUE,
                             PK5_VALUE,
                             COL_NAME,
                             COL_VALUE,
                             COL_DESC
                           )
  SELECT pdv.PK1_VALUE,
         pdv.PK2_VALUE,
         pdv.PK3_VALUE,
         pdv.PK4_VALUE,
         pdv.PK5_VALUE,
         pdv.COL_NAME,
         pdv.COL_VALUE,
         'PO_ELINS'
  FROM   po_exhibits_diff_v pdv, po_exhibit_details_draft pd
  WHERE  pdv.pk1_value = base_pk1
  AND    pdv.pk2_value = -1
  AND    pdv.pk1_value = pd.po_header_id
  AND    pdv.pk3_value = pd.po_exhibit_details_id
  AND    pd.draft_id   = mod_pk2
  AND    pdv.revision_num = pd.revision_num;

Line: 1527


    FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from archive : ' || SQL%ROWCOUNT);

Line: 1531


  INSERT INTO PO_ENTITY_GT ( PK1_VALUE,
                             PK2_VALUE,
                             PK3_VALUE,
                             PK4_VALUE,
                             PK5_VALUE,
                             COL_NAME,
                             COL_VALUE,
                             COL_DESC
                           )
  SELECT pdv.PK1_VALUE,
         pdv.PK2_VALUE,
         pdv.PK3_VALUE,
         pdv.PK4_VALUE,
         pdv.PK5_VALUE,
         pdv.COL_NAME,
         pdv.COL_VALUE,
         'PO_ELINS'
  FROM   po_exhibits_draft_diff_v pdv
  WHERE  pdv.pk1_value = mod_pk1
  AND    pdv.pk2_value = mod_pk2;

Line: 1554


    FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from draft : ' || SQL%ROWCOUNT);

Line: 1564


    DELETE FROM PO_ENTITY_GT;