APPS.AMS_XML_ELEMENT_PVT dependencies on DBMS_SQL

Line 56: g_cursor INT DEFAULT dbms_sql.open_cursor;

52:
53: l_update_statement VARCHAR2(2000) := ' UPDATE ' || p_view_name
54: || ' SET LOAD_STATUS = ''RELOAD'' ';
55: l_status integer;
56: g_cursor INT DEFAULT dbms_sql.open_cursor;
57:
58: l_error VARCHAR2(2000);
59: BEGIN
60: FOR i IN p_xml_elements_col_name.FIRST .. p_xml_elements_col_name.LAST

Line 74: dbms_sql.parse (g_cursor, l_update_statement, dbms_sql.native);

70:
71: BEGIN
72: write_msg(' test1::');
73:
74: dbms_sql.parse (g_cursor, l_update_statement, dbms_sql.native);
75:
76: write_msg(' test2::');
77: FOR j IN p_xml_elements_data.FIRST .. p_xml_elements_data.LAST
78: LOOP

Line 80: dbms_sql.bind_variable (g_cursor, ':v' || j, p_xml_elements_data(j));

76: write_msg(' test2::');
77: FOR j IN p_xml_elements_data.FIRST .. p_xml_elements_data.LAST
78: LOOP
79: write_msg(' test3::');
80: dbms_sql.bind_variable (g_cursor, ':v' || j, p_xml_elements_data(j));
81: END LOOP;
82:
83: write_msg(' test4::');
84: dbms_sql.bind_variable (g_cursor, ':p1', p_prim_key);

Line 84: dbms_sql.bind_variable (g_cursor, ':p1', p_prim_key);

80: dbms_sql.bind_variable (g_cursor, ':v' || j, p_xml_elements_data(j));
81: END LOOP;
82:
83: write_msg(' test4::');
84: dbms_sql.bind_variable (g_cursor, ':p1', p_prim_key);
85:
86: l_status := dbms_sql.EXECUTE(g_cursor);
87: dbms_sql.close_cursor (g_cursor);
88:

Line 86: l_status := dbms_sql.EXECUTE(g_cursor);

82:
83: write_msg(' test4::');
84: dbms_sql.bind_variable (g_cursor, ':p1', p_prim_key);
85:
86: l_status := dbms_sql.EXECUTE(g_cursor);
87: dbms_sql.close_cursor (g_cursor);
88:
89: EXCEPTION
90: WHEN OTHERS THEN

Line 87: dbms_sql.close_cursor (g_cursor);

83: write_msg(' test4::');
84: dbms_sql.bind_variable (g_cursor, ':p1', p_prim_key);
85:
86: l_status := dbms_sql.EXECUTE(g_cursor);
87: dbms_sql.close_cursor (g_cursor);
88:
89: EXCEPTION
90: WHEN OTHERS THEN
91: dbms_sql.close_cursor (g_cursor);

Line 91: dbms_sql.close_cursor (g_cursor);

87: dbms_sql.close_cursor (g_cursor);
88:
89: EXCEPTION
90: WHEN OTHERS THEN
91: dbms_sql.close_cursor (g_cursor);
92: --IF (AMS_DEBUG_HIGH_ON) THENAMS_UTILITY_PVT.debug_message('Error Update_Xml_Source_Lines_Util in cursor execution');END IF;
93: l_error := SQLERRM;
94: IF (AMS_DEBUG_HIGH_ON) THEN
95: