The following lines contain the word 'select', 'insert', 'update' or 'delete':
G_INDENT || ' ( SELECT /*+ NO_MERGE */ ' || g_new_line ||
G_INDENT || ' jtdr.terr_id ' || g_new_line ||
G_INDENT || ' , jtdr.source_id ' || g_new_line ||
G_INDENT || ' , jqtu.qual_type_id ' || g_new_line ||
G_INDENT || ' , jtdr.top_level_terr_id ' || g_new_line ||
G_INDENT || ' , jta.absolute_rank ' || g_new_line ||
G_INDENT || ' , jta.num_winners ' || g_new_line ||
G_INDENT || ' , jta.org_id ' || g_new_line ||
G_INDENT || ' FROM jty_denorm_dea_rules_all jtdr ' || g_new_line ||
G_INDENT || ' ,jtf_terr_qtype_usgs_all jtqu ' || g_new_line ||
G_INDENT || ' ,jtf_qual_type_usgs_all jqtu ' || g_new_line ||
G_INDENT || ' ,jtf_terr_all jta ' || g_new_line ||
G_INDENT || ' WHERE jtdr.source_id = ' || p_source_id || g_new_line ||
G_INDENT || ' AND jtdr.terr_id= jtdr.related_terr_id' || g_new_line ||
G_INDENT || ' AND jtdr.terr_id= jta.terr_id' || g_new_line ||
G_INDENT || ' AND jqtu.source_id = jtdr.source_id ' || g_new_line ||
G_INDENT || ' AND jqtu.qual_type_id = ' || p_trans_id || g_new_line ||
G_INDENT || ' AND jtdr.terr_id = jtqu.terr_id ' || g_new_line ||
G_INDENT || ' AND jtqu.qual_type_usg_id = jqtu.qual_type_usg_id ' || g_new_line ||
G_INDENT || ' --AND jtdr.resource_exists_flag = ''Y'' '|| g_new_line ||
G_INDENT || ' AND jtqu.qual_relation_product = ' || p_qual_relation_prd || g_new_line ||
G_INDENT || ' ) ILV' || g_new_line;
G_INDENT || ' ( SELECT /*+ NO_MERGE */ ' || g_new_line ||
G_INDENT || ' jtdr.terr_id ' || g_new_line ||
G_INDENT || ' , jtdr.source_id ' || g_new_line ||
G_INDENT || ' , jqtu.qual_type_id ' || g_new_line ||
G_INDENT || ' , jtdr.top_level_terr_id ' || g_new_line ||
G_INDENT || ' , jta.absolute_rank ' || g_new_line ||
G_INDENT || ' , jta.num_winners ' || g_new_line ||
G_INDENT || ' , jta.org_id ' || g_new_line ||
G_INDENT || ' FROM jtf_terr_denorm_rules_all jtdr ' || g_new_line ||
G_INDENT || ' ,jtf_terr_qtype_usgs_all jtqu ' || g_new_line ||
G_INDENT || ' ,jtf_qual_type_usgs_all jqtu ' || g_new_line ||
G_INDENT || ' ,jtf_terr_all jta ' || g_new_line ||
G_INDENT || ' WHERE jtdr.source_id = ' || p_source_id || g_new_line ||
G_INDENT || ' AND jtdr.terr_id= jtdr.related_terr_id' || g_new_line ||
G_INDENT || ' AND jtdr.terr_id= jta.terr_id' || g_new_line ||
G_INDENT || ' AND jqtu.source_id = jtdr.source_id ' || g_new_line ||
G_INDENT || ' AND jqtu.qual_type_id = ' || p_trans_id || g_new_line ||
G_INDENT || ' AND jtdr.terr_id = jtqu.terr_id ' || g_new_line ||
G_INDENT || ' AND jtqu.qual_type_usg_id = jqtu.qual_type_usg_id ' || g_new_line ||
G_INDENT || ' --AND jtdr.resource_exists_flag = ''Y'' '|| g_new_line ||
G_INDENT || ' AND jtqu.qual_relation_product = ' || p_qual_relation_prd || g_new_line ||
G_INDENT || ' ) ILV' || g_new_line;
G_INDENT || ' ( SELECT /*+ NO_MERGE */ DISTINCT ' || g_new_line ||
G_INDENT || ' jtdr.terr_id ' || g_new_line ||
G_INDENT || ' , jtdr.source_id ' || g_new_line ||
G_INDENT || ' , jqtu.qual_type_id ' || g_new_line ||
G_INDENT || ' , jtdr.top_level_terr_id ' || g_new_line ||
G_INDENT || ' , jta.absolute_rank ' || g_new_line ||
G_INDENT || ' , jta.num_winners ' || g_new_line ||
G_INDENT || ' , jta.org_id ' || g_new_line ||
G_INDENT || ' FROM jtf_terr_denorm_rules_all jtdr ' || g_new_line ||
G_INDENT || ' ,jty_changed_terrs jct ' || g_new_line ||
G_INDENT || ' ,jtf_terr_qtype_usgs_all jtqu ' || g_new_line ||
G_INDENT || ' ,jtf_qual_type_usgs_all jqtu ' || g_new_line ||
G_INDENT || ' ,jtf_terr_all jta ' || g_new_line ||
G_INDENT || ' WHERE jqtu.source_id = ' || p_source_id || g_new_line ||
G_INDENT || ' AND jtdr.terr_id= jct.terr_id ' || g_new_line ||
G_INDENT || ' AND jtdr.terr_id= jtdr.related_terr_id' || g_new_line ||
G_INDENT || ' AND jtdr.terr_id= jta.terr_id' || g_new_line ||
G_INDENT || ' AND jqtu.source_id = jtdr.source_id ' || g_new_line ||
G_INDENT || ' AND jqtu.qual_type_id = ' || p_trans_id || g_new_line ||
G_INDENT || ' AND jct.terr_id = jtqu.terr_id ' || g_new_line ||
G_INDENT || ' AND jtqu.qual_type_usg_id = jqtu.qual_type_usg_id ' || g_new_line ||
-- G_INDENT || ' AND jtdr.resource_exists_flag = ''Y'' '|| g_new_line ||
G_INDENT || ' AND jct.tap_request_id = :REQUEST_ID ' || g_new_line ||
G_INDENT || ' AND :CURR_DATE BETWEEN jtdr.start_date and jtdr.end_date ' || g_new_line ||
G_INDENT || ' AND jtqu.qual_relation_product = ' || p_qual_relation_prd || g_new_line ||
G_INDENT || ' ) ILV'||g_new_line;
/* this procedure returns the insert and select clause of the SQL */
/* statement that inserts objects into NM_TRANS from TRANS table */
PROCEDURE get_insert_select_nmtrans(
p_match_table_name IN VARCHAR2,
p_insert_stmt OUT NOCOPY VARCHAR2,
p_select_stmt OUT NOCOPY VARCHAR2,
errbuf OUT NOCOPY VARCHAR2,
retcode OUT NOCOPY VARCHAR2)
AS
l_status VARCHAR2(30);
SELECT column_name
FROM all_tab_columns
WHERE table_name = cl_table_name
AND owner = cl_owner
AND column_name not in ('LAST_UPDATE_DATE', 'LAST_UPDATED_BY', 'CREATION_DATE', 'CREATED_BY', 'LAST_UPDATE_LOGIN',
'REQUEST_ID', 'PROGRAM_APPLICATION_ID', 'PROGRAM_ID', 'PROGRAM_UPDATE_DATE');
'jtf.plsql.JTY_TAE_GEN_PVT.get_insert_select_nmtrans.start',
'Start of the procedure JTY_TAE_GEN_PVT.get_insert_select_nmtrans');
/* Form the insert statement to insert transaction objects into TRANS table */
p_insert_stmt := 'INSERT INTO ' || p_match_table_name || '(';
p_select_stmt := 'SELECT DISTINCT ';
p_insert_stmt := p_insert_stmt || g_new_line || l_indent || column_names.column_name;
p_select_stmt := p_select_stmt || g_new_line || l_indent || 'A.' || column_names.column_name;
p_insert_stmt := p_insert_stmt || g_new_line || l_indent || ',' || column_names.column_name;
p_select_stmt := p_select_stmt || g_new_line || l_indent || ',' || 'A.' || column_names.column_name;
p_insert_stmt := p_insert_stmt || g_new_line || l_indent || ',LAST_UPDATE_DATE ' ||
g_new_line || l_indent || ',LAST_UPDATED_BY ' ||
g_new_line || l_indent || ',CREATION_DATE ' ||
g_new_line || l_indent || ',CREATED_BY ' ||
g_new_line || l_indent || ',LAST_UPDATE_LOGIN ' ||
g_new_line || l_indent || ',REQUEST_ID ' ||
g_new_line || l_indent || ',PROGRAM_APPLICATION_ID ' ||
g_new_line || l_indent || ',PROGRAM_ID ' ||
g_new_line || l_indent || ',PROGRAM_UPDATE_DATE ' ||
g_new_line || ')';
p_select_stmt := p_select_stmt || g_new_line || l_indent || ',:LAST_UPDATE_DATE ' ||
g_new_line || l_indent || ',:LAST_UPDATED_BY ' ||
g_new_line || l_indent || ',:CREATION_DATE ' ||
g_new_line || l_indent || ',:CREATED_BY ' ||
g_new_line || l_indent || ',:LAST_UPDATE_LOGIN ' ||
g_new_line || l_indent || ',:REQUEST_ID ' ||
g_new_line || l_indent || ',:PROGRAM_APPLICATION_ID ' ||
g_new_line || l_indent || ',:PROGRAM_ID ' ||
g_new_line || l_indent || ',:PROGRAM_UPDATE_DATE ' ||
' FROM ';
'jtf.plsql.JTY_TAE_GEN_PVT.get_insert_select_nmtrans.end',
'End of the procedure JTY_TAE_GEN_PVT.get_insert_select_nmtrans');
'jtf.plsql.JTY_TAE_GEN_PVT.get_insert_select_nmtrans.l_schema_notfound',
errbuf);
END get_insert_select_nmtrans;
l_select CLOB;
SELECT distinct
jtqf.qual_usg_id
,jqu.alias_rule1
,jqu.op_eql
,jqu.op_like
,jqu.op_between
,jqu.op_common_where
FROM jtf_qual_usgs_all jqu,
jtf_tae_qual_factors jtqf,
jtf_tae_qual_products jtqp,
jtf_tae_qual_prod_factors jtpf
WHERE jqu.org_id = -3113
AND jqu.qual_usg_id = jtqf.qual_usg_id
AND jtpf.qual_factor_id = jtqf.qual_factor_id
AND jtqf.relation_factor = cl_relation_factor
AND jtqp.qual_product_id = jtpf.qual_product_id
AND jtqp.relation_product = cl_relation_product
AND jtqp.source_id = cl_source_id
AND jtqp.trans_object_type_id = cl_trans_id
AND jqu.op_not_eql IS NULL
AND jqu.op_not_like IS NULL
AND jqu.op_not_between IS NULL
ORDER BY jtqf.qual_usg_id;
SELECT distinct
jtqf.qual_usg_id
,jqu.alias_rule1
,jqu.op_eql
,jqu.op_like
,jqu.op_between
,jqu.op_common_where
FROM jtf_qual_usgs_all jqu,
jty_dea_attr_factors jtqf,
jty_dea_attr_products jtqp,
jty_dea_attr_prod_factors jtpf
WHERE jqu.org_id = -3113
AND jqu.qual_usg_id = jtqf.qual_usg_id
AND jtpf.dea_attr_factors_id = jtqf.dea_attr_factors_id
AND jtqf.relation_factor = cl_relation_factor
AND jtqp.dea_attr_products_id = jtpf.dea_attr_products_id
AND jtqp.attr_relation_product = cl_relation_product
AND jtqp.source_id = cl_source_id
AND jtqp.trans_type_id = cl_trans_id
AND jqu.op_not_eql IS NULL
AND jqu.op_not_like IS NULL
AND jqu.op_not_between IS NULL
ORDER BY jtqf.qual_usg_id;
l_select := G_INDENT || 'SELECT ' || g_new_line ||
G_INDENT || ' AI.customer_id' || g_new_line ||
G_INDENT || ' , AI.address_id' || g_new_line;
l_select := G_INDENT || 'SELECT ' || g_new_line ||
G_INDENT || ' ASLLP.sales_lead_id' || g_new_line ||
G_INDENT || ' , ASLLP.sales_lead_line_id' || g_new_line;
l_select := G_INDENT || 'SELECT ' || g_new_line ||
G_INDENT || ' ASLL.sales_lead_id' || g_new_line ||
G_INDENT || ' , ASLL.sales_lead_line_id' || g_new_line;
l_select := G_INDENT || 'SELECT ' || g_new_line ||
G_INDENT || ' ASLLI.sales_lead_id' || g_new_line ||
G_INDENT || ' , ASLLI.sales_lead_line_id' || g_new_line;
l_select := G_INDENT || 'SELECT ' || g_new_line ||
G_INDENT || ' ALLP.lead_id' || g_new_line ||
G_INDENT || ' , ALLP.lead_line_id' || g_new_line;
l_select := G_INDENT || 'SELECT ' || g_new_line ||
G_INDENT || ' ALLI.lead_id' || g_new_line ||
G_INDENT || ' , ALLI.lead_line_id' || g_new_line;
l_select := G_INDENT || 'SELECT ' || g_new_line ||
G_INDENT || ' OAI.lead_id' || g_new_line ;
l_select := l_select ||
G_INDENT || ' , ILV.terr_id ' || g_new_line ||
G_INDENT || ' , ILV.top_level_terr_id ' || g_new_line ||
G_INDENT || ' , ILV.absolute_rank ' || g_new_line ||
G_INDENT || ' , ILV.num_winners ' || g_new_line ||
G_INDENT || ' , ILV.org_id ' || g_new_line;
p_sql := l_select || g_new_line ||
l_from_str || g_new_line ||
l_where_str || g_new_line ||
l_predicate;
SELECT DISTINCT
jqu.qual_usg_id
,jqu.alias_rule1
,jqu.op_eql
,jqu.op_like
,jqu.op_between
,jqu.op_common_where
FROM
jtf_qual_usgs_all jqu
,jtf_tae_qual_factors jtqf
,jtf_tae_qual_products jtqp
,jtf_tae_qual_prod_factors jtpf
WHERE jqu.org_id = -3113
AND jqu.qual_usg_id = jtqf.qual_usg_id
AND jtpf.qual_factor_id= jtqf.qual_factor_id
AND jtqf.relation_factor <> cl_relation_factor
AND jtqp.qual_product_id = jtpf.qual_product_id
AND jtqp.relation_product = cl_relation_product
AND jtqp.source_id = cl_source_id
AND jtqp.trans_object_type_id= cl_trans_id
ORDER BY jqu.qual_usg_id;
SELECT DISTINCT
jqu.qual_usg_id
,jqu.alias_rule1
,jqu.op_eql
,jqu.op_like
,jqu.op_between
,jqu.op_common_where
FROM
jtf_qual_usgs_all jqu
,jty_dea_attr_factors jtqf
,jty_dea_attr_products jtqp
,jty_dea_attr_prod_factors jtpf
WHERE jqu.org_id = -3113
AND jqu.qual_usg_id = jtqf.qual_usg_id
AND jtpf.dea_attr_factors_id = jtqf.dea_attr_factors_id
AND jtqf.relation_factor <> cl_relation_factor
AND jtqp.dea_attr_products_id = jtpf.dea_attr_products_id
AND jtqp.attr_relation_product = cl_relation_product
AND jtqp.source_id = cl_source_id
AND jtqp.trans_type_id= cl_trans_id
ORDER BY jqu.qual_usg_id;
p_sql := 'SELECT A.*,ILV.terr_id,ILV.absolute_rank,ILV.top_level_terr_id ,ILV.num_winners FROM ';
p_sql := 'SELECT a.trans_object_id,a.trans_detail_object_id,a.worker_id,a.txn_date, ' ||
'ILV.terr_id,ILV.absolute_rank,ILV.top_level_terr_id ,ILV.num_winners,ILV.org_id, A.SQUAL_NUM01, A.SQUAL_NUM02 FROM ' ;
p_sql := 'SELECT a.trans_object_id,a.trans_detail_object_id,a.worker_id,a.txn_date, ' ||
'ILV.terr_id,ILV.absolute_rank,ILV.top_level_terr_id ,ILV.num_winners,ILV.org_id FROM ' ;
SELECT DISTINCT
jqu.qual_usg_id
,jqu.alias_rule1
,jqu.op_eql
,jqu.op_like
,jqu.op_between
,jqu.op_common_where
FROM
jtf_qual_usgs_all jqu
,jtf_tae_qual_factors jtqf
,jtf_tae_qual_products jtqp
,jtf_tae_qual_prod_factors jtpf
WHERE jqu.org_id = -3113
AND jqu.qual_usg_id = jtqf.qual_usg_id
AND jtpf.qual_factor_id= jtqf.qual_factor_id
AND jtqf.relation_factor <> cl_relation_factor
AND jtqp.qual_product_id = jtpf.qual_product_id
AND jtqp.relation_product = cl_relation_product
AND jtqp.source_id = cl_source_id
AND jtqp.trans_object_type_id= cl_trans_id
ORDER BY jqu.qual_usg_id;
SELECT DISTINCT
jqu.qual_usg_id
,jqu.alias_rule1
,jqu.op_eql
,jqu.op_like
,jqu.op_between
,jqu.op_common_where
FROM
jtf_qual_usgs_all jqu
,jty_dea_attr_factors jtqf
,jty_dea_attr_products jtqp
,jty_dea_attr_prod_factors jtpf
WHERE jqu.org_id = -3113
AND jqu.qual_usg_id = jtqf.qual_usg_id
AND jtpf.dea_attr_factors_id = jtqf.dea_attr_factors_id
AND jtqf.relation_factor <> cl_relation_factor
AND jtqp.dea_attr_products_id = jtpf.dea_attr_products_id
AND jtqp.attr_relation_product = cl_relation_product
AND jtqp.source_id = cl_source_id
AND jtqp.trans_type_id= cl_trans_id
ORDER BY jqu.qual_usg_id;
SELECT column_name
FROM all_tab_columns
WHERE table_name = cl_table_name
AND owner = cl_owner
AND column_name not in ('LAST_UPDATE_DATE', 'LAST_UPDATED_BY', 'CREATION_DATE', 'CREATED_BY', 'LAST_UPDATE_LOGIN',
'REQUEST_ID', 'PROGRAM_APPLICATION_ID', 'PROGRAM_ID', 'PROGRAM_UPDATE_DATE');
p_sql := 'SELECT /*+ NO_MERGE(ILV1) NO_MERGE(ILV2) USE_HASH(ILV1 ILV2) */ ';
l_insert_nm_trans VARCHAR2(3000);
l_select_nm_trans VARCHAR2(3000);
get_insert_select_nmtrans(
p_match_table_name => p_match_table_name,
p_insert_stmt => l_insert_nm_trans,
p_select_stmt => l_select_nm_trans,
errbuf => errbuf,
retcode => retcode);
'jtf.plsql.JTY_TAE_GEN_PVT.gen_terr_rules_recurse.get_insert_select_nmtrans',
'JTY_TAE_GEN_PVT.get_insert_select_nmtrans API has failed');
l_match_sql := l_insert_nm_trans;
' INSERT INTO '|| p_match_table_name || ' i' ||
' (' ||
' trans_object_id' ||
' ,trans_detail_object_id' ||
' ,worker_id' ||
' ,source_id' ||
' ,trans_object_type_id' ||
' ,last_update_date' ||
' ,last_updated_by' ||
' ,creation_date' ||
' ,created_by' ||
' ,last_update_login' ||
' ,request_id' ||
' ,program_application_id' ||
' ,program_id' ||
' ,program_update_date' ||
' ,terr_id' ||
' ,absolute_rank' ||
' ,top_level_terr_id' ||
' ,num_winners' ||
' ,org_id' ||
' ,txn_date' ||
' )' ;
l_match_sql := l_match_sql || ' ' || l_select_nm_trans;
' SELECT /*+ USE_CONCAT */ DISTINCT ' ||
' ILV2.trans_object_id' ||
' ,ILV2.trans_detail_object_id' ||
' ,ILV2.worker_id' ||
' ,' || p_source_id ||
' ,' || p_trans_id ||
' ,:LAST_UPDATED_DATE ' ||
' ,:LAST_UPDATED_BY ' ||
' ,:CREATION_DATE ' ||
' ,:CREATED_BY ' ||
' ,:LAST_UPDATE_LOGIN ' ||
' ,:REQUEST_ID ' ||
' ,:PROGRAM_APPLICATION_ID ' ||
' ,:PROGRAM_ID ' ||
' ,:PROGRAM_UPDATE_DATE ' ||
' ,ILV2.terr_id' ||
' ,ILV2.absolute_rank' ||
' ,ILV2.top_level_terr_id' ||
' ,ILV2.num_winners' ||
' ,ILV2.org_id' ||
' ,ILV2.txn_date' ||
' FROM ';
' SELECT /*+ USE_CONCAT */ DISTINCT ' ||
' A.trans_object_id' ||
' ,A.trans_detail_object_id' ||
' ,A.worker_id' ||
' ,' || p_source_id ||
' ,' || p_trans_id ||
' ,:LAST_UPDATED_DATE ' ||
' ,:LAST_UPDATED_BY ' ||
' ,:CREATION_DATE ' ||
' ,:CREATED_BY ' ||
' ,:LAST_UPDATE_LOGIN ' ||
' ,:REQUEST_ID ' ||
' ,:PROGRAM_APPLICATION_ID ' ||
' ,:PROGRAM_ID ' ||
' ,:PROGRAM_UPDATE_DATE ' ||
' ,ILV.terr_id' ||
' ,ILV.absolute_rank' ||
' ,ILV.top_level_terr_id' ||
' ,ILV.num_winners' ||
' ,ILV.org_id' ||
' ,A.txn_date' ||
' FROM ';
select
a.program_name
,decode(cl_mode, 'DATE EFFECTIVE', a.batch_dea_trans_table_name, a.batch_trans_table_name)
,a.batch_nm_trans_table_name
,a.batch_match_table_name
from jty_trans_usg_pgm_details a
where a.source_id = cl_source_id
and a.trans_type_id = cl_trans_id
and a.batch_enable_flag = 'Y';
SELECT denorm_dea_value_table_name
INTO l_denorm_table_name
FROM jtf_sources_all
WHERE source_id = p_source_id;
SELECT denorm_value_table_name
INTO l_denorm_table_name
FROM jtf_sources_all
WHERE source_id = p_source_id;
SELECT count(*)
INTO l_no_of_records
FROM jty_dea_attr_products_sql
WHERE source_id = p_source_id
AND trans_type_id = p_trans_id
AND program_name = l_pgm_name_tbl(i)
AND attr_relation_product = p_qual_prd_tbl(j);
SELECT count(*)
INTO l_no_of_records
FROM jty_tae_attr_products_sql
WHERE source_id = p_source_id
AND trans_type_id = p_trans_id
AND program_name = l_pgm_name_tbl(i)
AND attr_relation_product = p_qual_prd_tbl(j);
INSERT INTO JTY_TAE_ATTR_PRODUCTS_SQL(
ATTR_PRODUCTS_SQL_ID
,SOURCE_ID
,TRANS_TYPE_ID
,PROGRAM_NAME
,ATTR_RELATION_PRODUCT
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,CREATION_DATE
,CREATED_BY
,LAST_UPDATE_LOGIN
,BATCH_MATCH_SQL
,BATCH_NM_MATCH_SQL
,BATCH_NMC_MATCH_SQL
,KEEP_FLAG
,PROGRAM_ID
,PROGRAM_LOGIN_ID
,PROGRAM_APPLICATION_ID
,REQUEST_ID
,PROGRAM_UPDATE_DATE)
VALUES(
JTY_TAE_ATTR_PRODUCTS_SQL_S.NEXTVAL
,p_source_id
,p_trans_id
,l_pgm_name_tbl(i)
,p_qual_prd_tbl(j)
,G_SYSDATE
,G_USER_ID
,G_SYSDATE
,G_USER_ID
,G_USER_ID
,l_match_sql
,l_nm_match_sql
,l_nmc_match_sql
,'N'
,G_REQUEST_ID
,G_PROGRAM_APPL_ID
,G_PROGRAM_ID
,G_REQUEST_ID
,G_SYSDATE
);
INSERT INTO JTY_DEA_ATTR_PRODUCTS_SQL(
DEA_ATTR_PRODUCTS_SQL_ID
,SOURCE_ID
,TRANS_TYPE_ID
,PROGRAM_NAME
,ATTR_RELATION_PRODUCT
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,CREATION_DATE
,CREATED_BY
,LAST_UPDATE_LOGIN
,BATCH_DEA_MATCH_SQL
,KEEP_FLAG
,PROGRAM_ID
,PROGRAM_LOGIN_ID
,PROGRAM_APPLICATION_ID
,REQUEST_ID
,PROGRAM_UPDATE_DATE)
VALUES(
JTY_DEA_ATTR_PRODUCTS_SQL_S.NEXTVAL
,p_source_id
,p_trans_id
,l_pgm_name_tbl(i)
,p_qual_prd_tbl(j)
,G_SYSDATE
,G_USER_ID
,G_SYSDATE
,G_USER_ID
,G_USER_ID
,l_match_sql
,'N'
,G_REQUEST_ID
,G_PROGRAM_APPL_ID
,G_PROGRAM_ID
,G_REQUEST_ID
,G_SYSDATE
);