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

Line 5064: ,p_org_id_tbl IN DBMS_SQL.VARCHAR2_TABLE

5060: -- API to return a Sequence of Item Numbers, given the Item Catalog Group ID.
5061: --
5062: -- -----------------------------------------------------------------------------
5063: PROCEDURE Get_Seq_Gen_Item_Nums( p_item_catalog_group_id IN NUMBER
5064: ,p_org_id_tbl IN DBMS_SQL.VARCHAR2_TABLE
5065: ,x_item_num_tbl IN OUT NOCOPY EGO_VARCHAR_TBL_TYPE
5066: ) IS
5067:
5068: -----------------------------------------------------------------------

Line 5071: l_itemgen_method_table DBMS_SQL.VARCHAR2_TABLE;

5067:
5068: -----------------------------------------------------------------------
5069: -- Variables used to query Item Number Generation Method
5070: -----------------------------------------------------------------------
5071: l_itemgen_method_table DBMS_SQL.VARCHAR2_TABLE;
5072: l_itemgen_seq_table DBMS_SQL.VARCHAR2_TABLE;
5073: l_itemgen_prefix_table DBMS_SQL.VARCHAR2_TABLE;
5074: l_itemgen_suffix_table DBMS_SQL.VARCHAR2_TABLE;
5075: l_itemgen_method_cursor INTEGER;

Line 5072: l_itemgen_seq_table DBMS_SQL.VARCHAR2_TABLE;

5068: -----------------------------------------------------------------------
5069: -- Variables used to query Item Number Generation Method
5070: -----------------------------------------------------------------------
5071: l_itemgen_method_table DBMS_SQL.VARCHAR2_TABLE;
5072: l_itemgen_seq_table DBMS_SQL.VARCHAR2_TABLE;
5073: l_itemgen_prefix_table DBMS_SQL.VARCHAR2_TABLE;
5074: l_itemgen_suffix_table DBMS_SQL.VARCHAR2_TABLE;
5075: l_itemgen_method_cursor INTEGER;
5076: l_itemgen_method_exec INTEGER;

Line 5073: l_itemgen_prefix_table DBMS_SQL.VARCHAR2_TABLE;

5069: -- Variables used to query Item Number Generation Method
5070: -----------------------------------------------------------------------
5071: l_itemgen_method_table DBMS_SQL.VARCHAR2_TABLE;
5072: l_itemgen_seq_table DBMS_SQL.VARCHAR2_TABLE;
5073: l_itemgen_prefix_table DBMS_SQL.VARCHAR2_TABLE;
5074: l_itemgen_suffix_table DBMS_SQL.VARCHAR2_TABLE;
5075: l_itemgen_method_cursor INTEGER;
5076: l_itemgen_method_exec INTEGER;
5077: l_itemgen_method_rows_cnt NUMBER;

Line 5074: l_itemgen_suffix_table DBMS_SQL.VARCHAR2_TABLE;

5070: -----------------------------------------------------------------------
5071: l_itemgen_method_table DBMS_SQL.VARCHAR2_TABLE;
5072: l_itemgen_seq_table DBMS_SQL.VARCHAR2_TABLE;
5073: l_itemgen_prefix_table DBMS_SQL.VARCHAR2_TABLE;
5074: l_itemgen_suffix_table DBMS_SQL.VARCHAR2_TABLE;
5075: l_itemgen_method_cursor INTEGER;
5076: l_itemgen_method_exec INTEGER;
5077: l_itemgen_method_rows_cnt NUMBER;
5078:

Line 5111: l_itemgen_method_cursor := DBMS_SQL.OPEN_CURSOR;

5107: AND organization_id = cp_organization_id;
5108:
5109: BEGIN
5110:
5111: l_itemgen_method_cursor := DBMS_SQL.OPEN_CURSOR;
5112: DBMS_SQL.PARSE(l_itemgen_method_cursor, l_itemgen_hierarchy_sql, DBMS_SQL.NATIVE);
5113:
5114: LOOP -- Loop for every 2500 rows.
5115:

Line 5112: DBMS_SQL.PARSE(l_itemgen_method_cursor, l_itemgen_hierarchy_sql, DBMS_SQL.NATIVE);

5108:
5109: BEGIN
5110:
5111: l_itemgen_method_cursor := DBMS_SQL.OPEN_CURSOR;
5112: DBMS_SQL.PARSE(l_itemgen_method_cursor, l_itemgen_hierarchy_sql, DBMS_SQL.NATIVE);
5113:
5114: LOOP -- Loop for every 2500 rows.
5115:
5116: DBMS_SQL.DEFINE_ARRAY(

Line 5116: DBMS_SQL.DEFINE_ARRAY(

5112: DBMS_SQL.PARSE(l_itemgen_method_cursor, l_itemgen_hierarchy_sql, DBMS_SQL.NATIVE);
5113:
5114: LOOP -- Loop for every 2500 rows.
5115:
5116: DBMS_SQL.DEFINE_ARRAY(
5117: c => l_itemgen_method_cursor -- cursor --
5118: , position => 3 -- select position --
5119: , c_tab => l_itemgen_method_table -- table of chars --
5120: , cnt => 2500 -- rows requested --

Line 5124: DBMS_SQL.DEFINE_ARRAY(

5120: , cnt => 2500 -- rows requested --
5121: , lower_bound => 1 -- start at --
5122: );
5123:
5124: DBMS_SQL.DEFINE_ARRAY(
5125: c => l_itemgen_method_cursor -- cursor --
5126: , position => 4 -- select position --
5127: , c_tab => l_itemgen_seq_table -- table of chars --
5128: , cnt => 2500 -- rows requested --

Line 5132: DBMS_SQL.DEFINE_ARRAY(

5128: , cnt => 2500 -- rows requested --
5129: , lower_bound => 1 -- start at --
5130: );
5131:
5132: DBMS_SQL.DEFINE_ARRAY(
5133: c => l_itemgen_method_cursor -- cursor --
5134: , position => 5 -- select position --
5135: , c_tab => l_itemgen_prefix_table -- table of chars --
5136: , cnt => 2500 -- rows requested --

Line 5140: DBMS_SQL.DEFINE_ARRAY(

5136: , cnt => 2500 -- rows requested --
5137: , lower_bound => 1 -- start at --
5138: );
5139:
5140: DBMS_SQL.DEFINE_ARRAY(
5141: c => l_itemgen_method_cursor -- cursor --
5142: , position => 6 -- select position --
5143: , c_tab => l_itemgen_suffix_table -- table of chars --
5144: , cnt => 2500 -- rows requested --

Line 5148: DBMS_SQL.BIND_VARIABLE(l_itemgen_method_cursor, ':ITEM_CATALOG_GROUP_ID', p_item_catalog_group_id);

5144: , cnt => 2500 -- rows requested --
5145: , lower_bound => 1 -- start at --
5146: );
5147:
5148: DBMS_SQL.BIND_VARIABLE(l_itemgen_method_cursor, ':ITEM_CATALOG_GROUP_ID', p_item_catalog_group_id);
5149:
5150: l_itemgen_method_exec := DBMS_SQL.EXECUTE(l_itemgen_method_cursor);
5151: l_itemgen_method_rows_cnt := DBMS_SQL.FETCH_ROWS(l_itemgen_method_cursor);
5152:

Line 5150: l_itemgen_method_exec := DBMS_SQL.EXECUTE(l_itemgen_method_cursor);

5146: );
5147:
5148: DBMS_SQL.BIND_VARIABLE(l_itemgen_method_cursor, ':ITEM_CATALOG_GROUP_ID', p_item_catalog_group_id);
5149:
5150: l_itemgen_method_exec := DBMS_SQL.EXECUTE(l_itemgen_method_cursor);
5151: l_itemgen_method_rows_cnt := DBMS_SQL.FETCH_ROWS(l_itemgen_method_cursor);
5152:
5153: DBMS_SQL.COLUMN_VALUE(l_itemgen_method_cursor, 3, l_itemgen_method_table);
5154: DBMS_SQL.COLUMN_VALUE(l_itemgen_method_cursor, 4, l_itemgen_seq_table);

Line 5151: l_itemgen_method_rows_cnt := DBMS_SQL.FETCH_ROWS(l_itemgen_method_cursor);

5147:
5148: DBMS_SQL.BIND_VARIABLE(l_itemgen_method_cursor, ':ITEM_CATALOG_GROUP_ID', p_item_catalog_group_id);
5149:
5150: l_itemgen_method_exec := DBMS_SQL.EXECUTE(l_itemgen_method_cursor);
5151: l_itemgen_method_rows_cnt := DBMS_SQL.FETCH_ROWS(l_itemgen_method_cursor);
5152:
5153: DBMS_SQL.COLUMN_VALUE(l_itemgen_method_cursor, 3, l_itemgen_method_table);
5154: DBMS_SQL.COLUMN_VALUE(l_itemgen_method_cursor, 4, l_itemgen_seq_table);
5155: DBMS_SQL.COLUMN_VALUE(l_itemgen_method_cursor, 5, l_itemgen_prefix_table);

Line 5153: DBMS_SQL.COLUMN_VALUE(l_itemgen_method_cursor, 3, l_itemgen_method_table);

5149:
5150: l_itemgen_method_exec := DBMS_SQL.EXECUTE(l_itemgen_method_cursor);
5151: l_itemgen_method_rows_cnt := DBMS_SQL.FETCH_ROWS(l_itemgen_method_cursor);
5152:
5153: DBMS_SQL.COLUMN_VALUE(l_itemgen_method_cursor, 3, l_itemgen_method_table);
5154: DBMS_SQL.COLUMN_VALUE(l_itemgen_method_cursor, 4, l_itemgen_seq_table);
5155: DBMS_SQL.COLUMN_VALUE(l_itemgen_method_cursor, 5, l_itemgen_prefix_table);
5156: DBMS_SQL.COLUMN_VALUE(l_itemgen_method_cursor, 6, l_itemgen_suffix_table);
5157:

Line 5154: DBMS_SQL.COLUMN_VALUE(l_itemgen_method_cursor, 4, l_itemgen_seq_table);

5150: l_itemgen_method_exec := DBMS_SQL.EXECUTE(l_itemgen_method_cursor);
5151: l_itemgen_method_rows_cnt := DBMS_SQL.FETCH_ROWS(l_itemgen_method_cursor);
5152:
5153: DBMS_SQL.COLUMN_VALUE(l_itemgen_method_cursor, 3, l_itemgen_method_table);
5154: DBMS_SQL.COLUMN_VALUE(l_itemgen_method_cursor, 4, l_itemgen_seq_table);
5155: DBMS_SQL.COLUMN_VALUE(l_itemgen_method_cursor, 5, l_itemgen_prefix_table);
5156: DBMS_SQL.COLUMN_VALUE(l_itemgen_method_cursor, 6, l_itemgen_suffix_table);
5157:
5158: --begin add for bug 9127677

Line 5155: DBMS_SQL.COLUMN_VALUE(l_itemgen_method_cursor, 5, l_itemgen_prefix_table);

5151: l_itemgen_method_rows_cnt := DBMS_SQL.FETCH_ROWS(l_itemgen_method_cursor);
5152:
5153: DBMS_SQL.COLUMN_VALUE(l_itemgen_method_cursor, 3, l_itemgen_method_table);
5154: DBMS_SQL.COLUMN_VALUE(l_itemgen_method_cursor, 4, l_itemgen_seq_table);
5155: DBMS_SQL.COLUMN_VALUE(l_itemgen_method_cursor, 5, l_itemgen_prefix_table);
5156: DBMS_SQL.COLUMN_VALUE(l_itemgen_method_cursor, 6, l_itemgen_suffix_table);
5157:
5158: --begin add for bug 9127677
5159: IF DBMS_SQL.IS_OPEN(l_itemgen_method_cursor) then

Line 5156: DBMS_SQL.COLUMN_VALUE(l_itemgen_method_cursor, 6, l_itemgen_suffix_table);

5152:
5153: DBMS_SQL.COLUMN_VALUE(l_itemgen_method_cursor, 3, l_itemgen_method_table);
5154: DBMS_SQL.COLUMN_VALUE(l_itemgen_method_cursor, 4, l_itemgen_seq_table);
5155: DBMS_SQL.COLUMN_VALUE(l_itemgen_method_cursor, 5, l_itemgen_prefix_table);
5156: DBMS_SQL.COLUMN_VALUE(l_itemgen_method_cursor, 6, l_itemgen_suffix_table);
5157:
5158: --begin add for bug 9127677
5159: IF DBMS_SQL.IS_OPEN(l_itemgen_method_cursor) then
5160: DBMS_SQL.Close_Cursor(l_itemgen_method_cursor);

Line 5159: IF DBMS_SQL.IS_OPEN(l_itemgen_method_cursor) then

5155: DBMS_SQL.COLUMN_VALUE(l_itemgen_method_cursor, 5, l_itemgen_prefix_table);
5156: DBMS_SQL.COLUMN_VALUE(l_itemgen_method_cursor, 6, l_itemgen_suffix_table);
5157:
5158: --begin add for bug 9127677
5159: IF DBMS_SQL.IS_OPEN(l_itemgen_method_cursor) then
5160: DBMS_SQL.Close_Cursor(l_itemgen_method_cursor);
5161: END IF;
5162: --end add for bug 9127677
5163: --DBMS_OUTPUT.PUT_LINE('load_item_oper_attr_values: Retrieved rows => '||To_char(l_itemgen_method_rows_cnt));

Line 5160: DBMS_SQL.Close_Cursor(l_itemgen_method_cursor);

5156: DBMS_SQL.COLUMN_VALUE(l_itemgen_method_cursor, 6, l_itemgen_suffix_table);
5157:
5158: --begin add for bug 9127677
5159: IF DBMS_SQL.IS_OPEN(l_itemgen_method_cursor) then
5160: DBMS_SQL.Close_Cursor(l_itemgen_method_cursor);
5161: END IF;
5162: --end add for bug 9127677
5163: --DBMS_OUTPUT.PUT_LINE('load_item_oper_attr_values: Retrieved rows => '||To_char(l_itemgen_method_rows_cnt));
5164: