DBA Data[Home] [Help]

APPS.EGO_ITEM_PUB dependencies on DBMS_SQL

Line 3834: l_attr_grp_table DBMS_SQL.VARCHAR2_TABLE;

3830: -----------------------------------------------------------------------
3831: -- Variables used to query UCCnet Attr Groups to exclude from
3832: -- Template Application. (PPEDDAMA)
3833: -----------------------------------------------------------------------
3834: l_attr_grp_table DBMS_SQL.VARCHAR2_TABLE;
3835: l_attr_grp_cursor INTEGER;
3836: l_attr_grp_exec INTEGER;
3837: l_attr_grp_dyn_sql VARCHAR2(10000);
3838: l_attr_grp_rows_cnt NUMBER;

Line 4011: l_attr_grp_cursor := DBMS_SQL.OPEN_CURSOR;

4007: l_attr_grp_dyn_sql := l_attr_grp_dyn_sql || ' WHERE E.ATTR_GROUP_ID = T.ATTRIBUTE_GROUP_ID ';
4008: l_attr_grp_dyn_sql := l_attr_grp_dyn_sql || ' ) ';
4009: l_attr_grp_dyn_sql := l_attr_grp_dyn_sql || ' IN (''EGO_ITEM_GTIN_ATTRS'', ''EGO_ITEM_GTIN_MULTI_ATTRS'') ';
4010:
4011: l_attr_grp_cursor := DBMS_SQL.OPEN_CURSOR;
4012: DBMS_SQL.PARSE(l_attr_grp_cursor, l_attr_grp_dyn_sql, DBMS_SQL.NATIVE);
4013:
4014: LOOP -- Loop for every 2500 rows.
4015:

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

4008: l_attr_grp_dyn_sql := l_attr_grp_dyn_sql || ' ) ';
4009: l_attr_grp_dyn_sql := l_attr_grp_dyn_sql || ' IN (''EGO_ITEM_GTIN_ATTRS'', ''EGO_ITEM_GTIN_MULTI_ATTRS'') ';
4010:
4011: l_attr_grp_cursor := DBMS_SQL.OPEN_CURSOR;
4012: DBMS_SQL.PARSE(l_attr_grp_cursor, l_attr_grp_dyn_sql, DBMS_SQL.NATIVE);
4013:
4014: LOOP -- Loop for every 2500 rows.
4015:
4016: DBMS_SQL.DEFINE_ARRAY(

Line 4016: DBMS_SQL.DEFINE_ARRAY(

4012: DBMS_SQL.PARSE(l_attr_grp_cursor, l_attr_grp_dyn_sql, DBMS_SQL.NATIVE);
4013:
4014: LOOP -- Loop for every 2500 rows.
4015:
4016: DBMS_SQL.DEFINE_ARRAY(
4017: c => l_attr_grp_cursor -- cursor --
4018: , position => 1 -- select position --
4019: , c_tab => l_attr_grp_table -- table of numbers --
4020: , cnt => 2500 -- rows requested --

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

4020: , cnt => 2500 -- rows requested --
4021: , lower_bound => 1 -- start at --
4022: );
4023:
4024: DBMS_SQL.BIND_VARIABLE(l_attr_grp_cursor, ':TEMPL_ID', p_template_id);
4025:
4026: l_attr_grp_exec := DBMS_SQL.EXECUTE(l_attr_grp_cursor);
4027: l_attr_grp_rows_cnt := DBMS_SQL.FETCH_ROWS(l_attr_grp_cursor);
4028:

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

4022: );
4023:
4024: DBMS_SQL.BIND_VARIABLE(l_attr_grp_cursor, ':TEMPL_ID', p_template_id);
4025:
4026: l_attr_grp_exec := DBMS_SQL.EXECUTE(l_attr_grp_cursor);
4027: l_attr_grp_rows_cnt := DBMS_SQL.FETCH_ROWS(l_attr_grp_cursor);
4028:
4029: DBMS_SQL.COLUMN_VALUE(l_attr_grp_cursor, 1, l_attr_grp_table);
4030:

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

4023:
4024: DBMS_SQL.BIND_VARIABLE(l_attr_grp_cursor, ':TEMPL_ID', p_template_id);
4025:
4026: l_attr_grp_exec := DBMS_SQL.EXECUTE(l_attr_grp_cursor);
4027: l_attr_grp_rows_cnt := DBMS_SQL.FETCH_ROWS(l_attr_grp_cursor);
4028:
4029: DBMS_SQL.COLUMN_VALUE(l_attr_grp_cursor, 1, l_attr_grp_table);
4030:
4031: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('load_item_oper_attr_values: Retrieved rows => '||To_char(l_attr_grp_rows_cnt));

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

4025:
4026: l_attr_grp_exec := DBMS_SQL.EXECUTE(l_attr_grp_cursor);
4027: l_attr_grp_rows_cnt := DBMS_SQL.FETCH_ROWS(l_attr_grp_cursor);
4028:
4029: DBMS_SQL.COLUMN_VALUE(l_attr_grp_cursor, 1, l_attr_grp_table);
4030:
4031: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('load_item_oper_attr_values: Retrieved rows => '||To_char(l_attr_grp_rows_cnt));
4032:
4033: FOR i IN 1..l_attr_grp_table.COUNT LOOP

Line 4056: DBMS_SQL.Close_Cursor(l_attr_grp_cursor);

4052: END LOOP; --end: FOR (i:=0; i < l_attr_grp_table.COUNT; i++)
4053:
4054: EXIT WHEN l_attr_grp_rows_cnt < 2500;
4055: END LOOP; --end: Loop for every 2500 rows.
4056: DBMS_SQL.Close_Cursor(l_attr_grp_cursor);
4057:
4058: EGO_USER_ATTRS_DATA_PVT.Debug_Msg(' UCCnet exclusion code complete.');
4059:
4060: -----------------------------------------------------------------

Line 4152: DBMS_SQL.Close_Cursor(l_attr_grp_cursor);

4148: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Apply_Templ_User_Attrs_To_Item -- Done');
4149: EXCEPTION
4150: WHEN OTHERS THEN
4151: IF (l_attr_grp_cursor IS NOT NULL) THEN
4152: DBMS_SQL.Close_Cursor(l_attr_grp_cursor);
4153: END IF;
4154: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('In Apply_Templ_User_Attrs_To_Item, got exception '||SQLERRM, 3);
4155:
4156: END Apply_Templ_User_Attrs_To_Item;