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.ASG_CONS_QPKG dependencies on DBMS_SQL

Line 71: l_cursor_id := DBMS_SQL.OPEN_CURSOR;

67: l_select_pi_sqlstring :=
68: 'SELECT name, comp_ref ' ||
69: 'FROM ' || asg_base.G_OLITE_SCHEMA ||'.' ||'c$pub_list_q';
70:
71: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
72: DBMS_SQL.PARSE (l_cursor_id, l_select_pi_sqlstring, DBMS_SQL.v7);
73: DBMS_SQL.DEFINE_COLUMN (l_cursor_id, 1, l_pubitem_name, 30);
74: DBMS_SQL.DEFINE_COLUMN (l_cursor_id, 2, l_comp_ref, 1);
75:

Line 72: DBMS_SQL.PARSE (l_cursor_id, l_select_pi_sqlstring, DBMS_SQL.v7);

68: 'SELECT name, comp_ref ' ||
69: 'FROM ' || asg_base.G_OLITE_SCHEMA ||'.' ||'c$pub_list_q';
70:
71: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
72: DBMS_SQL.PARSE (l_cursor_id, l_select_pi_sqlstring, DBMS_SQL.v7);
73: DBMS_SQL.DEFINE_COLUMN (l_cursor_id, 1, l_pubitem_name, 30);
74: DBMS_SQL.DEFINE_COLUMN (l_cursor_id, 2, l_comp_ref, 1);
75:
76: l_cursor_ret := DBMS_SQL.EXECUTE (l_cursor_id);

Line 73: DBMS_SQL.DEFINE_COLUMN (l_cursor_id, 1, l_pubitem_name, 30);

69: 'FROM ' || asg_base.G_OLITE_SCHEMA ||'.' ||'c$pub_list_q';
70:
71: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
72: DBMS_SQL.PARSE (l_cursor_id, l_select_pi_sqlstring, DBMS_SQL.v7);
73: DBMS_SQL.DEFINE_COLUMN (l_cursor_id, 1, l_pubitem_name, 30);
74: DBMS_SQL.DEFINE_COLUMN (l_cursor_id, 2, l_comp_ref, 1);
75:
76: l_cursor_ret := DBMS_SQL.EXECUTE (l_cursor_id);
77: counter := 1;

Line 74: DBMS_SQL.DEFINE_COLUMN (l_cursor_id, 2, l_comp_ref, 1);

70:
71: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
72: DBMS_SQL.PARSE (l_cursor_id, l_select_pi_sqlstring, DBMS_SQL.v7);
73: DBMS_SQL.DEFINE_COLUMN (l_cursor_id, 1, l_pubitem_name, 30);
74: DBMS_SQL.DEFINE_COLUMN (l_cursor_id, 2, l_comp_ref, 1);
75:
76: l_cursor_ret := DBMS_SQL.EXECUTE (l_cursor_id);
77: counter := 1;
78: WHILE ( DBMS_SQL.FETCH_ROWS(l_cursor_id) > 0 ) LOOP

Line 76: l_cursor_ret := DBMS_SQL.EXECUTE (l_cursor_id);

72: DBMS_SQL.PARSE (l_cursor_id, l_select_pi_sqlstring, DBMS_SQL.v7);
73: DBMS_SQL.DEFINE_COLUMN (l_cursor_id, 1, l_pubitem_name, 30);
74: DBMS_SQL.DEFINE_COLUMN (l_cursor_id, 2, l_comp_ref, 1);
75:
76: l_cursor_ret := DBMS_SQL.EXECUTE (l_cursor_id);
77: counter := 1;
78: WHILE ( DBMS_SQL.FETCH_ROWS(l_cursor_id) > 0 ) LOOP
79: DBMS_SQL.COLUMN_VALUE (l_cursor_id, 1, l_pubitem_name);
80: DBMS_SQL.COLUMN_VALUE (l_cursor_id, 2, l_comp_ref);

Line 78: WHILE ( DBMS_SQL.FETCH_ROWS(l_cursor_id) > 0 ) LOOP

74: DBMS_SQL.DEFINE_COLUMN (l_cursor_id, 2, l_comp_ref, 1);
75:
76: l_cursor_ret := DBMS_SQL.EXECUTE (l_cursor_id);
77: counter := 1;
78: WHILE ( DBMS_SQL.FETCH_ROWS(l_cursor_id) > 0 ) LOOP
79: DBMS_SQL.COLUMN_VALUE (l_cursor_id, 1, l_pubitem_name);
80: DBMS_SQL.COLUMN_VALUE (l_cursor_id, 2, l_comp_ref);
81: p_pubitem_tbl(counter).name := l_pubitem_name;
82: p_pubitem_tbl(counter).comp_ref := l_comp_ref;

Line 79: DBMS_SQL.COLUMN_VALUE (l_cursor_id, 1, l_pubitem_name);

75:
76: l_cursor_ret := DBMS_SQL.EXECUTE (l_cursor_id);
77: counter := 1;
78: WHILE ( DBMS_SQL.FETCH_ROWS(l_cursor_id) > 0 ) LOOP
79: DBMS_SQL.COLUMN_VALUE (l_cursor_id, 1, l_pubitem_name);
80: DBMS_SQL.COLUMN_VALUE (l_cursor_id, 2, l_comp_ref);
81: p_pubitem_tbl(counter).name := l_pubitem_name;
82: p_pubitem_tbl(counter).comp_ref := l_comp_ref;
83: counter := counter +1;

Line 80: DBMS_SQL.COLUMN_VALUE (l_cursor_id, 2, l_comp_ref);

76: l_cursor_ret := DBMS_SQL.EXECUTE (l_cursor_id);
77: counter := 1;
78: WHILE ( DBMS_SQL.FETCH_ROWS(l_cursor_id) > 0 ) LOOP
79: DBMS_SQL.COLUMN_VALUE (l_cursor_id, 1, l_pubitem_name);
80: DBMS_SQL.COLUMN_VALUE (l_cursor_id, 2, l_comp_ref);
81: p_pubitem_tbl(counter).name := l_pubitem_name;
82: p_pubitem_tbl(counter).comp_ref := l_comp_ref;
83: counter := counter +1;
84: END LOOP;

Line 86: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);

82: p_pubitem_tbl(counter).comp_ref := l_comp_ref;
83: counter := counter +1;
84: END LOOP;
85:
86: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
87:
88: END get_pubitem_list;
89:
90: FUNCTION is_previous_synch_successful(p_user_name IN VARCHAR2,

Line 862: l_cursor_id := DBMS_SQL.OPEN_CURSOR;

858: 'WHERE ci.clid$$cs = :1 AND ' ||
859: ' ci.tranid$$ = :2 AND ' ||
860: ' ci.store = api.name';
861:
862: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
863: DBMS_SQL.PARSE (l_cursor_id, l_query_string, DBMS_SQL.v7);
864: DBMS_SQL.bind_variable(l_cursor_id,':1',p_user_name);
865: DBMS_SQL.bind_variable(l_cursor_id,':2',p_upload_tranid);
866: DBMS_SQL.DEFINE_COLUMN (l_cursor_id, 1, l_pub_name, 30);

Line 863: DBMS_SQL.PARSE (l_cursor_id, l_query_string, DBMS_SQL.v7);

859: ' ci.tranid$$ = :2 AND ' ||
860: ' ci.store = api.name';
861:
862: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
863: DBMS_SQL.PARSE (l_cursor_id, l_query_string, DBMS_SQL.v7);
864: DBMS_SQL.bind_variable(l_cursor_id,':1',p_user_name);
865: DBMS_SQL.bind_variable(l_cursor_id,':2',p_upload_tranid);
866: DBMS_SQL.DEFINE_COLUMN (l_cursor_id, 1, l_pub_name, 30);
867:

Line 864: DBMS_SQL.bind_variable(l_cursor_id,':1',p_user_name);

860: ' ci.store = api.name';
861:
862: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
863: DBMS_SQL.PARSE (l_cursor_id, l_query_string, DBMS_SQL.v7);
864: DBMS_SQL.bind_variable(l_cursor_id,':1',p_user_name);
865: DBMS_SQL.bind_variable(l_cursor_id,':2',p_upload_tranid);
866: DBMS_SQL.DEFINE_COLUMN (l_cursor_id, 1, l_pub_name, 30);
867:
868: l_cursor_ret := DBMS_SQL.EXECUTE (l_cursor_id);

Line 865: DBMS_SQL.bind_variable(l_cursor_id,':2',p_upload_tranid);

861:
862: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
863: DBMS_SQL.PARSE (l_cursor_id, l_query_string, DBMS_SQL.v7);
864: DBMS_SQL.bind_variable(l_cursor_id,':1',p_user_name);
865: DBMS_SQL.bind_variable(l_cursor_id,':2',p_upload_tranid);
866: DBMS_SQL.DEFINE_COLUMN (l_cursor_id, 1, l_pub_name, 30);
867:
868: l_cursor_ret := DBMS_SQL.EXECUTE (l_cursor_id);
869: l_counter := 1;

Line 866: DBMS_SQL.DEFINE_COLUMN (l_cursor_id, 1, l_pub_name, 30);

862: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
863: DBMS_SQL.PARSE (l_cursor_id, l_query_string, DBMS_SQL.v7);
864: DBMS_SQL.bind_variable(l_cursor_id,':1',p_user_name);
865: DBMS_SQL.bind_variable(l_cursor_id,':2',p_upload_tranid);
866: DBMS_SQL.DEFINE_COLUMN (l_cursor_id, 1, l_pub_name, 30);
867:
868: l_cursor_ret := DBMS_SQL.EXECUTE (l_cursor_id);
869: l_counter := 1;
870:

Line 868: l_cursor_ret := DBMS_SQL.EXECUTE (l_cursor_id);

864: DBMS_SQL.bind_variable(l_cursor_id,':1',p_user_name);
865: DBMS_SQL.bind_variable(l_cursor_id,':2',p_upload_tranid);
866: DBMS_SQL.DEFINE_COLUMN (l_cursor_id, 1, l_pub_name, 30);
867:
868: l_cursor_ret := DBMS_SQL.EXECUTE (l_cursor_id);
869: l_counter := 1;
870:
871: -- Go through all the publications whose pis were uploaded
872: WHILE ( DBMS_SQL.FETCH_ROWS(l_cursor_id) > 0 ) LOOP

Line 872: WHILE ( DBMS_SQL.FETCH_ROWS(l_cursor_id) > 0 ) LOOP

868: l_cursor_ret := DBMS_SQL.EXECUTE (l_cursor_id);
869: l_counter := 1;
870:
871: -- Go through all the publications whose pis were uploaded
872: WHILE ( DBMS_SQL.FETCH_ROWS(l_cursor_id) > 0 ) LOOP
873: DBMS_SQL.COLUMN_VALUE (l_cursor_id, 1, l_pub_name);
874:
875: SELECT wrapper_name into l_pub_callback
876: FROM asg_pub

Line 873: DBMS_SQL.COLUMN_VALUE (l_cursor_id, 1, l_pub_name);

869: l_counter := 1;
870:
871: -- Go through all the publications whose pis were uploaded
872: WHILE ( DBMS_SQL.FETCH_ROWS(l_cursor_id) > 0 ) LOOP
873: DBMS_SQL.COLUMN_VALUE (l_cursor_id, 1, l_pub_name);
874:
875: SELECT wrapper_name into l_pub_callback
876: FROM asg_pub
877: WHERE name = l_pub_name;

Line 896: l_cursor_id2 := DBMS_SQL.OPEN_CuRSOR();

892: 'asg_cons_qpkg',g_stmt_level);
893: END IF;
894: BEGIN
895: /*
896: l_cursor_id2 := DBMS_SQL.OPEN_CuRSOR();
897: DBMS_SQL.PARSE(l_cursor_id2, l_query_string2, DBMS_SQL.v7);
898: DBMS_SQL.DEFINE_COLUMN(l_cursor_id2, 1, l_pub_detect_conflict, 1);
899: l_cursor_ret2 := DBMS_SQL.EXECUTE(l_cursor_id2);
900: DBMS_SQL.COLUMN_VALUE(l_cursor_id2, 1, l_pub_detect_conflict);

Line 897: DBMS_SQL.PARSE(l_cursor_id2, l_query_string2, DBMS_SQL.v7);

893: END IF;
894: BEGIN
895: /*
896: l_cursor_id2 := DBMS_SQL.OPEN_CuRSOR();
897: DBMS_SQL.PARSE(l_cursor_id2, l_query_string2, DBMS_SQL.v7);
898: DBMS_SQL.DEFINE_COLUMN(l_cursor_id2, 1, l_pub_detect_conflict, 1);
899: l_cursor_ret2 := DBMS_SQL.EXECUTE(l_cursor_id2);
900: DBMS_SQL.COLUMN_VALUE(l_cursor_id2, 1, l_pub_detect_conflict);
901: DBMS_SQL.CLOSE_CURSOR(l_cursor_id2);

Line 898: DBMS_SQL.DEFINE_COLUMN(l_cursor_id2, 1, l_pub_detect_conflict, 1);

894: BEGIN
895: /*
896: l_cursor_id2 := DBMS_SQL.OPEN_CuRSOR();
897: DBMS_SQL.PARSE(l_cursor_id2, l_query_string2, DBMS_SQL.v7);
898: DBMS_SQL.DEFINE_COLUMN(l_cursor_id2, 1, l_pub_detect_conflict, 1);
899: l_cursor_ret2 := DBMS_SQL.EXECUTE(l_cursor_id2);
900: DBMS_SQL.COLUMN_VALUE(l_cursor_id2, 1, l_pub_detect_conflict);
901: DBMS_SQL.CLOSE_CURSOR(l_cursor_id2);
902: */

Line 899: l_cursor_ret2 := DBMS_SQL.EXECUTE(l_cursor_id2);

895: /*
896: l_cursor_id2 := DBMS_SQL.OPEN_CuRSOR();
897: DBMS_SQL.PARSE(l_cursor_id2, l_query_string2, DBMS_SQL.v7);
898: DBMS_SQL.DEFINE_COLUMN(l_cursor_id2, 1, l_pub_detect_conflict, 1);
899: l_cursor_ret2 := DBMS_SQL.EXECUTE(l_cursor_id2);
900: DBMS_SQL.COLUMN_VALUE(l_cursor_id2, 1, l_pub_detect_conflict);
901: DBMS_SQL.CLOSE_CURSOR(l_cursor_id2);
902: */
903: EXECUTE IMMEDIATE l_query_string2

Line 900: DBMS_SQL.COLUMN_VALUE(l_cursor_id2, 1, l_pub_detect_conflict);

896: l_cursor_id2 := DBMS_SQL.OPEN_CuRSOR();
897: DBMS_SQL.PARSE(l_cursor_id2, l_query_string2, DBMS_SQL.v7);
898: DBMS_SQL.DEFINE_COLUMN(l_cursor_id2, 1, l_pub_detect_conflict, 1);
899: l_cursor_ret2 := DBMS_SQL.EXECUTE(l_cursor_id2);
900: DBMS_SQL.COLUMN_VALUE(l_cursor_id2, 1, l_pub_detect_conflict);
901: DBMS_SQL.CLOSE_CURSOR(l_cursor_id2);
902: */
903: EXECUTE IMMEDIATE l_query_string2
904: INTO l_pub_detect_conflict

Line 901: DBMS_SQL.CLOSE_CURSOR(l_cursor_id2);

897: DBMS_SQL.PARSE(l_cursor_id2, l_query_string2, DBMS_SQL.v7);
898: DBMS_SQL.DEFINE_COLUMN(l_cursor_id2, 1, l_pub_detect_conflict, 1);
899: l_cursor_ret2 := DBMS_SQL.EXECUTE(l_cursor_id2);
900: DBMS_SQL.COLUMN_VALUE(l_cursor_id2, 1, l_pub_detect_conflict);
901: DBMS_SQL.CLOSE_CURSOR(l_cursor_id2);
902: */
903: EXECUTE IMMEDIATE l_query_string2
904: INTO l_pub_detect_conflict
905: USING p_user_name;

Line 930: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);

926: 'asg_cons_qpkg',g_stmt_level);
927: END IF;
928: END;
929: END LOOP;
930: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
931:
932: -- Some pubs need conflict detection
933: IF (l_counter > 1) THEN
934: p_detect_conflict := FND_API.G_TRUE;

Line 1018: l_cursor_id := DBMS_SQL.OPEN_CURSOR;

1014: ' cpq.comp_ref <> ''Y'' AND ' ||
1015: ' api.detect_conflict = ''Y'' AND ' ||
1016: ' api.pub_name in (' || l_conf_pubs || ')';
1017:
1018: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
1019: DBMS_SQL.PARSE (l_cursor_id, l_query_string, DBMS_SQL.v7);
1020: DBMS_SQL.bind_variable(l_cursor_id,':1',p_user_name);
1021: DBMS_SQL.bind_variable(l_cursor_id,':2',p_upload_tranid);
1022: DBMS_SQL.DEFINE_COLUMN (l_cursor_id, 1, l_pubitem, 30);

Line 1019: DBMS_SQL.PARSE (l_cursor_id, l_query_string, DBMS_SQL.v7);

1015: ' api.detect_conflict = ''Y'' AND ' ||
1016: ' api.pub_name in (' || l_conf_pubs || ')';
1017:
1018: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
1019: DBMS_SQL.PARSE (l_cursor_id, l_query_string, DBMS_SQL.v7);
1020: DBMS_SQL.bind_variable(l_cursor_id,':1',p_user_name);
1021: DBMS_SQL.bind_variable(l_cursor_id,':2',p_upload_tranid);
1022: DBMS_SQL.DEFINE_COLUMN (l_cursor_id, 1, l_pubitem, 30);
1023:

Line 1020: DBMS_SQL.bind_variable(l_cursor_id,':1',p_user_name);

1016: ' api.pub_name in (' || l_conf_pubs || ')';
1017:
1018: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
1019: DBMS_SQL.PARSE (l_cursor_id, l_query_string, DBMS_SQL.v7);
1020: DBMS_SQL.bind_variable(l_cursor_id,':1',p_user_name);
1021: DBMS_SQL.bind_variable(l_cursor_id,':2',p_upload_tranid);
1022: DBMS_SQL.DEFINE_COLUMN (l_cursor_id, 1, l_pubitem, 30);
1023:
1024: l_cursor_ret := DBMS_SQL.EXECUTE (l_cursor_id);

Line 1021: DBMS_SQL.bind_variable(l_cursor_id,':2',p_upload_tranid);

1017:
1018: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
1019: DBMS_SQL.PARSE (l_cursor_id, l_query_string, DBMS_SQL.v7);
1020: DBMS_SQL.bind_variable(l_cursor_id,':1',p_user_name);
1021: DBMS_SQL.bind_variable(l_cursor_id,':2',p_upload_tranid);
1022: DBMS_SQL.DEFINE_COLUMN (l_cursor_id, 1, l_pubitem, 30);
1023:
1024: l_cursor_ret := DBMS_SQL.EXECUTE (l_cursor_id);
1025: l_counter := 1;

Line 1022: DBMS_SQL.DEFINE_COLUMN (l_cursor_id, 1, l_pubitem, 30);

1018: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
1019: DBMS_SQL.PARSE (l_cursor_id, l_query_string, DBMS_SQL.v7);
1020: DBMS_SQL.bind_variable(l_cursor_id,':1',p_user_name);
1021: DBMS_SQL.bind_variable(l_cursor_id,':2',p_upload_tranid);
1022: DBMS_SQL.DEFINE_COLUMN (l_cursor_id, 1, l_pubitem, 30);
1023:
1024: l_cursor_ret := DBMS_SQL.EXECUTE (l_cursor_id);
1025: l_counter := 1;
1026:

Line 1024: l_cursor_ret := DBMS_SQL.EXECUTE (l_cursor_id);

1020: DBMS_SQL.bind_variable(l_cursor_id,':1',p_user_name);
1021: DBMS_SQL.bind_variable(l_cursor_id,':2',p_upload_tranid);
1022: DBMS_SQL.DEFINE_COLUMN (l_cursor_id, 1, l_pubitem, 30);
1023:
1024: l_cursor_ret := DBMS_SQL.EXECUTE (l_cursor_id);
1025: l_counter := 1;
1026:
1027: -- Go through all the publications whose pis were uploaded
1028: WHILE ( DBMS_SQL.FETCH_ROWS(l_cursor_id) > 0 ) LOOP

Line 1028: WHILE ( DBMS_SQL.FETCH_ROWS(l_cursor_id) > 0 ) LOOP

1024: l_cursor_ret := DBMS_SQL.EXECUTE (l_cursor_id);
1025: l_counter := 1;
1026:
1027: -- Go through all the publications whose pis were uploaded
1028: WHILE ( DBMS_SQL.FETCH_ROWS(l_cursor_id) > 0 ) LOOP
1029: DBMS_SQL.COLUMN_VALUE (l_cursor_id, 1, l_pubitem);
1030: p_pubitem_tbl(l_counter).name := l_pubitem;
1031: l_counter := l_counter +1;
1032: IF(asg_helper.check_is_log_enabled(g_stmt_level)) THEN

Line 1029: DBMS_SQL.COLUMN_VALUE (l_cursor_id, 1, l_pubitem);

1025: l_counter := 1;
1026:
1027: -- Go through all the publications whose pis were uploaded
1028: WHILE ( DBMS_SQL.FETCH_ROWS(l_cursor_id) > 0 ) LOOP
1029: DBMS_SQL.COLUMN_VALUE (l_cursor_id, 1, l_pubitem);
1030: p_pubitem_tbl(l_counter).name := l_pubitem;
1031: l_counter := l_counter +1;
1032: IF(asg_helper.check_is_log_enabled(g_stmt_level)) THEN
1033: asg_helper.log('Pub item that will be checked for conflicts: ' ||

Line 1062: l_cursor_id := dbms_sql.open_cursor();

1058: asg_helper.log('Processing Purge SDQ','asg_cons_qpkg',g_stmt_level);
1059:
1060: l_qry_string := 'select distinct pub_name from asg_pub_item where item_id in '||
1061: ' ( select name from '||asg_base.G_OLITE_SCHEMA||'.c$pub_list_q )';
1062: l_cursor_id := dbms_sql.open_cursor();
1063: DBMS_SQL.parse(l_cursor_id,l_qry_string,DBMS_SQL.v7);
1064: DBMS_SQL.define_column(l_cursor_id,1,l_pub_name,30);
1065: l_ret_val := DBMS_SQL.execute(l_cursor_id);
1066:

Line 1063: DBMS_SQL.parse(l_cursor_id,l_qry_string,DBMS_SQL.v7);

1059:
1060: l_qry_string := 'select distinct pub_name from asg_pub_item where item_id in '||
1061: ' ( select name from '||asg_base.G_OLITE_SCHEMA||'.c$pub_list_q )';
1062: l_cursor_id := dbms_sql.open_cursor();
1063: DBMS_SQL.parse(l_cursor_id,l_qry_string,DBMS_SQL.v7);
1064: DBMS_SQL.define_column(l_cursor_id,1,l_pub_name,30);
1065: l_ret_val := DBMS_SQL.execute(l_cursor_id);
1066:
1067: WHILE ( DBMS_SQL.FETCH_ROWS(l_cursor_id) > 0 )

Line 1064: DBMS_SQL.define_column(l_cursor_id,1,l_pub_name,30);

1060: l_qry_string := 'select distinct pub_name from asg_pub_item where item_id in '||
1061: ' ( select name from '||asg_base.G_OLITE_SCHEMA||'.c$pub_list_q )';
1062: l_cursor_id := dbms_sql.open_cursor();
1063: DBMS_SQL.parse(l_cursor_id,l_qry_string,DBMS_SQL.v7);
1064: DBMS_SQL.define_column(l_cursor_id,1,l_pub_name,30);
1065: l_ret_val := DBMS_SQL.execute(l_cursor_id);
1066:
1067: WHILE ( DBMS_SQL.FETCH_ROWS(l_cursor_id) > 0 )
1068: LOOP

Line 1065: l_ret_val := DBMS_SQL.execute(l_cursor_id);

1061: ' ( select name from '||asg_base.G_OLITE_SCHEMA||'.c$pub_list_q )';
1062: l_cursor_id := dbms_sql.open_cursor();
1063: DBMS_SQL.parse(l_cursor_id,l_qry_string,DBMS_SQL.v7);
1064: DBMS_SQL.define_column(l_cursor_id,1,l_pub_name,30);
1065: l_ret_val := DBMS_SQL.execute(l_cursor_id);
1066:
1067: WHILE ( DBMS_SQL.FETCH_ROWS(l_cursor_id) > 0 )
1068: LOOP
1069: DBMS_SQL.COLUMN_VALUE (l_cursor_id, 1, l_pub_name);

Line 1067: WHILE ( DBMS_SQL.FETCH_ROWS(l_cursor_id) > 0 )

1063: DBMS_SQL.parse(l_cursor_id,l_qry_string,DBMS_SQL.v7);
1064: DBMS_SQL.define_column(l_cursor_id,1,l_pub_name,30);
1065: l_ret_val := DBMS_SQL.execute(l_cursor_id);
1066:
1067: WHILE ( DBMS_SQL.FETCH_ROWS(l_cursor_id) > 0 )
1068: LOOP
1069: DBMS_SQL.COLUMN_VALUE (l_cursor_id, 1, l_pub_name);
1070:
1071: l_tran_id := -200;

Line 1069: DBMS_SQL.COLUMN_VALUE (l_cursor_id, 1, l_pub_name);

1065: l_ret_val := DBMS_SQL.execute(l_cursor_id);
1066:
1067: WHILE ( DBMS_SQL.FETCH_ROWS(l_cursor_id) > 0 )
1068: LOOP
1069: DBMS_SQL.COLUMN_VALUE (l_cursor_id, 1, l_pub_name);
1070:
1071: l_tran_id := -200;
1072:
1073: OPEN c_purgeSdq(p_clientid,l_pub_name);

Line 1119: dbms_sql.close_cursor(l_cursor_id);

1115: END if;
1116: CLOSE c_purgeSdq;
1117: END LOOP;
1118:
1119: dbms_sql.close_cursor(l_cursor_id);
1120: asg_helper.log('End processing purgeSDQ','asg_cons_qpkg',g_stmt_level);
1121: EXCEPTION
1122: WHEN OTHERS THEN
1123: asg_helper.log('Exception in process_purge_sdq: ' || sqlerrm,