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 4573: ,p_org_id_tbl IN DBMS_SQL.VARCHAR2_TABLE

4569: -- API to return a Sequence of Item Numbers, given the Item Catalog Group ID.
4570: --
4571: -- -----------------------------------------------------------------------------
4572: PROCEDURE Get_Seq_Gen_Item_Nums( p_item_catalog_group_id IN NUMBER
4573: ,p_org_id_tbl IN DBMS_SQL.VARCHAR2_TABLE
4574: ,x_item_num_tbl IN OUT NOCOPY EGO_VARCHAR_TBL_TYPE
4575: ) IS
4576:
4577: -----------------------------------------------------------------------

Line 4580: l_itemgen_method_table DBMS_SQL.VARCHAR2_TABLE;

4576:
4577: -----------------------------------------------------------------------
4578: -- Variables used to query Item Number Generation Method
4579: -----------------------------------------------------------------------
4580: l_itemgen_method_table DBMS_SQL.VARCHAR2_TABLE;
4581: l_itemgen_seq_table DBMS_SQL.VARCHAR2_TABLE;
4582: l_itemgen_prefix_table DBMS_SQL.VARCHAR2_TABLE;
4583: l_itemgen_suffix_table DBMS_SQL.VARCHAR2_TABLE;
4584: l_itemgen_method_cursor INTEGER;

Line 4581: l_itemgen_seq_table DBMS_SQL.VARCHAR2_TABLE;

4577: -----------------------------------------------------------------------
4578: -- Variables used to query Item Number Generation Method
4579: -----------------------------------------------------------------------
4580: l_itemgen_method_table DBMS_SQL.VARCHAR2_TABLE;
4581: l_itemgen_seq_table DBMS_SQL.VARCHAR2_TABLE;
4582: l_itemgen_prefix_table DBMS_SQL.VARCHAR2_TABLE;
4583: l_itemgen_suffix_table DBMS_SQL.VARCHAR2_TABLE;
4584: l_itemgen_method_cursor INTEGER;
4585: l_itemgen_method_exec INTEGER;

Line 4582: l_itemgen_prefix_table DBMS_SQL.VARCHAR2_TABLE;

4578: -- Variables used to query Item Number Generation Method
4579: -----------------------------------------------------------------------
4580: l_itemgen_method_table DBMS_SQL.VARCHAR2_TABLE;
4581: l_itemgen_seq_table DBMS_SQL.VARCHAR2_TABLE;
4582: l_itemgen_prefix_table DBMS_SQL.VARCHAR2_TABLE;
4583: l_itemgen_suffix_table DBMS_SQL.VARCHAR2_TABLE;
4584: l_itemgen_method_cursor INTEGER;
4585: l_itemgen_method_exec INTEGER;
4586: l_itemgen_method_rows_cnt NUMBER;

Line 4583: l_itemgen_suffix_table DBMS_SQL.VARCHAR2_TABLE;

4579: -----------------------------------------------------------------------
4580: l_itemgen_method_table DBMS_SQL.VARCHAR2_TABLE;
4581: l_itemgen_seq_table DBMS_SQL.VARCHAR2_TABLE;
4582: l_itemgen_prefix_table DBMS_SQL.VARCHAR2_TABLE;
4583: l_itemgen_suffix_table DBMS_SQL.VARCHAR2_TABLE;
4584: l_itemgen_method_cursor INTEGER;
4585: l_itemgen_method_exec INTEGER;
4586: l_itemgen_method_rows_cnt NUMBER;
4587:

Line 4620: l_itemgen_method_cursor := DBMS_SQL.OPEN_CURSOR;

4616: AND organization_id = cp_organization_id;
4617:
4618: BEGIN
4619:
4620: l_itemgen_method_cursor := DBMS_SQL.OPEN_CURSOR;
4621: DBMS_SQL.PARSE(l_itemgen_method_cursor, l_itemgen_hierarchy_sql, DBMS_SQL.NATIVE);
4622:
4623: LOOP -- Loop for every 2500 rows.
4624:

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

4617:
4618: BEGIN
4619:
4620: l_itemgen_method_cursor := DBMS_SQL.OPEN_CURSOR;
4621: DBMS_SQL.PARSE(l_itemgen_method_cursor, l_itemgen_hierarchy_sql, DBMS_SQL.NATIVE);
4622:
4623: LOOP -- Loop for every 2500 rows.
4624:
4625: DBMS_SQL.DEFINE_ARRAY(

Line 4625: DBMS_SQL.DEFINE_ARRAY(

4621: DBMS_SQL.PARSE(l_itemgen_method_cursor, l_itemgen_hierarchy_sql, DBMS_SQL.NATIVE);
4622:
4623: LOOP -- Loop for every 2500 rows.
4624:
4625: DBMS_SQL.DEFINE_ARRAY(
4626: c => l_itemgen_method_cursor -- cursor --
4627: , position => 3 -- select position --
4628: , c_tab => l_itemgen_method_table -- table of chars --
4629: , cnt => 2500 -- rows requested --

Line 4633: DBMS_SQL.DEFINE_ARRAY(

4629: , cnt => 2500 -- rows requested --
4630: , lower_bound => 1 -- start at --
4631: );
4632:
4633: DBMS_SQL.DEFINE_ARRAY(
4634: c => l_itemgen_method_cursor -- cursor --
4635: , position => 4 -- select position --
4636: , c_tab => l_itemgen_seq_table -- table of chars --
4637: , cnt => 2500 -- rows requested --

Line 4641: DBMS_SQL.DEFINE_ARRAY(

4637: , cnt => 2500 -- rows requested --
4638: , lower_bound => 1 -- start at --
4639: );
4640:
4641: DBMS_SQL.DEFINE_ARRAY(
4642: c => l_itemgen_method_cursor -- cursor --
4643: , position => 5 -- select position --
4644: , c_tab => l_itemgen_prefix_table -- table of chars --
4645: , cnt => 2500 -- rows requested --

Line 4649: DBMS_SQL.DEFINE_ARRAY(

4645: , cnt => 2500 -- rows requested --
4646: , lower_bound => 1 -- start at --
4647: );
4648:
4649: DBMS_SQL.DEFINE_ARRAY(
4650: c => l_itemgen_method_cursor -- cursor --
4651: , position => 6 -- select position --
4652: , c_tab => l_itemgen_suffix_table -- table of chars --
4653: , cnt => 2500 -- rows requested --

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

4653: , cnt => 2500 -- rows requested --
4654: , lower_bound => 1 -- start at --
4655: );
4656:
4657: DBMS_SQL.BIND_VARIABLE(l_itemgen_method_cursor, ':ITEM_CATALOG_GROUP_ID', p_item_catalog_group_id);
4658:
4659: l_itemgen_method_exec := DBMS_SQL.EXECUTE(l_itemgen_method_cursor);
4660: l_itemgen_method_rows_cnt := DBMS_SQL.FETCH_ROWS(l_itemgen_method_cursor);
4661:

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

4655: );
4656:
4657: DBMS_SQL.BIND_VARIABLE(l_itemgen_method_cursor, ':ITEM_CATALOG_GROUP_ID', p_item_catalog_group_id);
4658:
4659: l_itemgen_method_exec := DBMS_SQL.EXECUTE(l_itemgen_method_cursor);
4660: l_itemgen_method_rows_cnt := DBMS_SQL.FETCH_ROWS(l_itemgen_method_cursor);
4661:
4662: DBMS_SQL.COLUMN_VALUE(l_itemgen_method_cursor, 3, l_itemgen_method_table);
4663: DBMS_SQL.COLUMN_VALUE(l_itemgen_method_cursor, 4, l_itemgen_seq_table);

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

4656:
4657: DBMS_SQL.BIND_VARIABLE(l_itemgen_method_cursor, ':ITEM_CATALOG_GROUP_ID', p_item_catalog_group_id);
4658:
4659: l_itemgen_method_exec := DBMS_SQL.EXECUTE(l_itemgen_method_cursor);
4660: l_itemgen_method_rows_cnt := DBMS_SQL.FETCH_ROWS(l_itemgen_method_cursor);
4661:
4662: DBMS_SQL.COLUMN_VALUE(l_itemgen_method_cursor, 3, l_itemgen_method_table);
4663: DBMS_SQL.COLUMN_VALUE(l_itemgen_method_cursor, 4, l_itemgen_seq_table);
4664: DBMS_SQL.COLUMN_VALUE(l_itemgen_method_cursor, 5, l_itemgen_prefix_table);

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

4658:
4659: l_itemgen_method_exec := DBMS_SQL.EXECUTE(l_itemgen_method_cursor);
4660: l_itemgen_method_rows_cnt := DBMS_SQL.FETCH_ROWS(l_itemgen_method_cursor);
4661:
4662: DBMS_SQL.COLUMN_VALUE(l_itemgen_method_cursor, 3, l_itemgen_method_table);
4663: DBMS_SQL.COLUMN_VALUE(l_itemgen_method_cursor, 4, l_itemgen_seq_table);
4664: DBMS_SQL.COLUMN_VALUE(l_itemgen_method_cursor, 5, l_itemgen_prefix_table);
4665: DBMS_SQL.COLUMN_VALUE(l_itemgen_method_cursor, 6, l_itemgen_suffix_table);
4666:

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

4659: l_itemgen_method_exec := DBMS_SQL.EXECUTE(l_itemgen_method_cursor);
4660: l_itemgen_method_rows_cnt := DBMS_SQL.FETCH_ROWS(l_itemgen_method_cursor);
4661:
4662: DBMS_SQL.COLUMN_VALUE(l_itemgen_method_cursor, 3, l_itemgen_method_table);
4663: DBMS_SQL.COLUMN_VALUE(l_itemgen_method_cursor, 4, l_itemgen_seq_table);
4664: DBMS_SQL.COLUMN_VALUE(l_itemgen_method_cursor, 5, l_itemgen_prefix_table);
4665: DBMS_SQL.COLUMN_VALUE(l_itemgen_method_cursor, 6, l_itemgen_suffix_table);
4666:
4667: --DBMS_OUTPUT.PUT_LINE('load_item_oper_attr_values: Retrieved rows => '||To_char(l_itemgen_method_rows_cnt));

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

4660: l_itemgen_method_rows_cnt := DBMS_SQL.FETCH_ROWS(l_itemgen_method_cursor);
4661:
4662: DBMS_SQL.COLUMN_VALUE(l_itemgen_method_cursor, 3, l_itemgen_method_table);
4663: DBMS_SQL.COLUMN_VALUE(l_itemgen_method_cursor, 4, l_itemgen_seq_table);
4664: DBMS_SQL.COLUMN_VALUE(l_itemgen_method_cursor, 5, l_itemgen_prefix_table);
4665: DBMS_SQL.COLUMN_VALUE(l_itemgen_method_cursor, 6, l_itemgen_suffix_table);
4666:
4667: --DBMS_OUTPUT.PUT_LINE('load_item_oper_attr_values: Retrieved rows => '||To_char(l_itemgen_method_rows_cnt));
4668:

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

4661:
4662: DBMS_SQL.COLUMN_VALUE(l_itemgen_method_cursor, 3, l_itemgen_method_table);
4663: DBMS_SQL.COLUMN_VALUE(l_itemgen_method_cursor, 4, l_itemgen_seq_table);
4664: DBMS_SQL.COLUMN_VALUE(l_itemgen_method_cursor, 5, l_itemgen_prefix_table);
4665: DBMS_SQL.COLUMN_VALUE(l_itemgen_method_cursor, 6, l_itemgen_suffix_table);
4666:
4667: --DBMS_OUTPUT.PUT_LINE('load_item_oper_attr_values: Retrieved rows => '||To_char(l_itemgen_method_rows_cnt));
4668:
4669: l_can_itemnum_gen := FALSE;