DBA Data[Home] [Help]

APPS.EGO_ITEM_PUB dependencies on DBMS_SQL

Line 4082: l_attr_grp_table DBMS_SQL.VARCHAR2_TABLE;

4078: -----------------------------------------------------------------------
4079: -- Variables used to query UCCnet Attr Groups to exclude from
4080: -- Template Application. (PPEDDAMA)
4081: -----------------------------------------------------------------------
4082: l_attr_grp_table DBMS_SQL.VARCHAR2_TABLE;
4083: l_attr_grp_cursor INTEGER;
4084: l_attr_grp_exec INTEGER;
4085: l_attr_grp_dyn_sql VARCHAR2(10000);
4086: l_attr_grp_rows_cnt NUMBER;

Line 4259: l_attr_grp_cursor := DBMS_SQL.OPEN_CURSOR;

4255: l_attr_grp_dyn_sql := l_attr_grp_dyn_sql || ' WHERE E.ATTR_GROUP_ID = T.ATTRIBUTE_GROUP_ID ';
4256: l_attr_grp_dyn_sql := l_attr_grp_dyn_sql || ' ) ';
4257: l_attr_grp_dyn_sql := l_attr_grp_dyn_sql || ' IN (''EGO_ITEM_GTIN_ATTRS'', ''EGO_ITEM_GTIN_MULTI_ATTRS'') ';
4258:
4259: l_attr_grp_cursor := DBMS_SQL.OPEN_CURSOR;
4260: DBMS_SQL.PARSE(l_attr_grp_cursor, l_attr_grp_dyn_sql, DBMS_SQL.NATIVE);
4261:
4262: LOOP -- Loop for every 2500 rows.
4263:

Line 4260: DBMS_SQL.PARSE(l_attr_grp_cursor, l_attr_grp_dyn_sql, DBMS_SQL.NATIVE);

4256: l_attr_grp_dyn_sql := l_attr_grp_dyn_sql || ' ) ';
4257: l_attr_grp_dyn_sql := l_attr_grp_dyn_sql || ' IN (''EGO_ITEM_GTIN_ATTRS'', ''EGO_ITEM_GTIN_MULTI_ATTRS'') ';
4258:
4259: l_attr_grp_cursor := DBMS_SQL.OPEN_CURSOR;
4260: DBMS_SQL.PARSE(l_attr_grp_cursor, l_attr_grp_dyn_sql, DBMS_SQL.NATIVE);
4261:
4262: LOOP -- Loop for every 2500 rows.
4263:
4264: DBMS_SQL.DEFINE_ARRAY(

Line 4264: DBMS_SQL.DEFINE_ARRAY(

4260: DBMS_SQL.PARSE(l_attr_grp_cursor, l_attr_grp_dyn_sql, DBMS_SQL.NATIVE);
4261:
4262: LOOP -- Loop for every 2500 rows.
4263:
4264: DBMS_SQL.DEFINE_ARRAY(
4265: c => l_attr_grp_cursor -- cursor --
4266: , position => 1 -- select position --
4267: , c_tab => l_attr_grp_table -- table of numbers --
4268: , cnt => 2500 -- rows requested --

Line 4272: DBMS_SQL.BIND_VARIABLE(l_attr_grp_cursor, ':TEMPL_ID', p_template_id);

4268: , cnt => 2500 -- rows requested --
4269: , lower_bound => 1 -- start at --
4270: );
4271:
4272: DBMS_SQL.BIND_VARIABLE(l_attr_grp_cursor, ':TEMPL_ID', p_template_id);
4273:
4274: l_attr_grp_exec := DBMS_SQL.EXECUTE(l_attr_grp_cursor);
4275: l_attr_grp_rows_cnt := DBMS_SQL.FETCH_ROWS(l_attr_grp_cursor);
4276:

Line 4274: l_attr_grp_exec := DBMS_SQL.EXECUTE(l_attr_grp_cursor);

4270: );
4271:
4272: DBMS_SQL.BIND_VARIABLE(l_attr_grp_cursor, ':TEMPL_ID', p_template_id);
4273:
4274: l_attr_grp_exec := DBMS_SQL.EXECUTE(l_attr_grp_cursor);
4275: l_attr_grp_rows_cnt := DBMS_SQL.FETCH_ROWS(l_attr_grp_cursor);
4276:
4277: DBMS_SQL.COLUMN_VALUE(l_attr_grp_cursor, 1, l_attr_grp_table);
4278:

Line 4275: l_attr_grp_rows_cnt := DBMS_SQL.FETCH_ROWS(l_attr_grp_cursor);

4271:
4272: DBMS_SQL.BIND_VARIABLE(l_attr_grp_cursor, ':TEMPL_ID', p_template_id);
4273:
4274: l_attr_grp_exec := DBMS_SQL.EXECUTE(l_attr_grp_cursor);
4275: l_attr_grp_rows_cnt := DBMS_SQL.FETCH_ROWS(l_attr_grp_cursor);
4276:
4277: DBMS_SQL.COLUMN_VALUE(l_attr_grp_cursor, 1, l_attr_grp_table);
4278:
4279: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('load_item_oper_attr_values: Retrieved rows => '||To_char(l_attr_grp_rows_cnt));

Line 4277: DBMS_SQL.COLUMN_VALUE(l_attr_grp_cursor, 1, l_attr_grp_table);

4273:
4274: l_attr_grp_exec := DBMS_SQL.EXECUTE(l_attr_grp_cursor);
4275: l_attr_grp_rows_cnt := DBMS_SQL.FETCH_ROWS(l_attr_grp_cursor);
4276:
4277: DBMS_SQL.COLUMN_VALUE(l_attr_grp_cursor, 1, l_attr_grp_table);
4278:
4279: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('load_item_oper_attr_values: Retrieved rows => '||To_char(l_attr_grp_rows_cnt));
4280:
4281: FOR i IN 1..l_attr_grp_table.COUNT LOOP

Line 4304: DBMS_SQL.Close_Cursor(l_attr_grp_cursor);

4300: END LOOP; --end: FOR (i:=0; i < l_attr_grp_table.COUNT; i++)
4301:
4302: EXIT WHEN l_attr_grp_rows_cnt < 2500;
4303: END LOOP; --end: Loop for every 2500 rows.
4304: DBMS_SQL.Close_Cursor(l_attr_grp_cursor);
4305:
4306: EGO_USER_ATTRS_DATA_PVT.Debug_Msg(' UCCnet exclusion code complete.');
4307:
4308: -----------------------------------------------------------------

Line 4400: DBMS_SQL.Close_Cursor(l_attr_grp_cursor);

4396: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Apply_Templ_User_Attrs_To_Item -- Done');
4397: EXCEPTION
4398: WHEN OTHERS THEN
4399: IF (l_attr_grp_cursor IS NOT NULL) THEN
4400: DBMS_SQL.Close_Cursor(l_attr_grp_cursor);
4401: END IF;
4402: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('In Apply_Templ_User_Attrs_To_Item, got exception '||SQLERRM, 3);
4403:
4404: END Apply_Templ_User_Attrs_To_Item;