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

Line 1571: l_desc_table DBMS_SQL.Desc_Tab;

1567: l_utility_dynamic_sql VARCHAR2(32767); --the largest a VARCHAR2 can be
1568: l_cursor_id NUMBER;
1569: l_column_count NUMBER;
1570: l_dummy NUMBER;
1571: l_desc_table DBMS_SQL.Desc_Tab;
1572: l_retrieved_value VARCHAR2(1000);
1573: l_current_column_index NUMBER;
1574:
1575: l_inventory_item_id NUMBER ;

Line 1854: l_cursor_id := DBMS_SQL.Open_Cursor;

1850:
1851: Write_Debug('SQL:' || l_dynamic_sql );
1852:
1853:
1854: l_cursor_id := DBMS_SQL.Open_Cursor;
1855: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);
1856: DBMS_SQL.Bind_Variable(l_cursor_id, ':1', l_change_line_id);
1857: DBMS_SQL.Describe_Columns(l_cursor_id, l_column_count, l_desc_table);
1858:

Line 1855: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);

1851: Write_Debug('SQL:' || l_dynamic_sql );
1852:
1853:
1854: l_cursor_id := DBMS_SQL.Open_Cursor;
1855: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);
1856: DBMS_SQL.Bind_Variable(l_cursor_id, ':1', l_change_line_id);
1857: DBMS_SQL.Describe_Columns(l_cursor_id, l_column_count, l_desc_table);
1858:
1859:

Line 1856: DBMS_SQL.Bind_Variable(l_cursor_id, ':1', l_change_line_id);

1852:
1853:
1854: l_cursor_id := DBMS_SQL.Open_Cursor;
1855: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);
1856: DBMS_SQL.Bind_Variable(l_cursor_id, ':1', l_change_line_id);
1857: DBMS_SQL.Describe_Columns(l_cursor_id, l_column_count, l_desc_table);
1858:
1859:
1860: FOR i IN 1 .. l_column_count

Line 1857: DBMS_SQL.Describe_Columns(l_cursor_id, l_column_count, l_desc_table);

1853:
1854: l_cursor_id := DBMS_SQL.Open_Cursor;
1855: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);
1856: DBMS_SQL.Bind_Variable(l_cursor_id, ':1', l_change_line_id);
1857: DBMS_SQL.Describe_Columns(l_cursor_id, l_column_count, l_desc_table);
1858:
1859:
1860: FOR i IN 1 .. l_column_count
1861: LOOP

Line 1869: DBMS_SQL.Define_Column(l_cursor_id, i, l_retrieved_value, 1000);

1865: --
1866: -------------------------------------------------------------
1867: -- We define all columns as VARCHAR2(1000) for convenience --
1868: -------------------------------------------------------------
1869: DBMS_SQL.Define_Column(l_cursor_id, i, l_retrieved_value, 1000);
1870: END LOOP;
1871:
1872:
1873: Write_Debug('Execute our dynamic query . . .' );

Line 1879: l_dummy := DBMS_SQL.Execute(l_cursor_id);

1875:
1876: ----------------------------------
1877: -- Execute our dynamic query... --
1878: ----------------------------------
1879: l_dummy := DBMS_SQL.Execute(l_cursor_id);
1880:
1881:
1882: Write_Debug('After Executing our dynamic query . . .' );
1883:

Line 1888: WHILE (DBMS_SQL.Fetch_Rows(l_cursor_id) > 0)

1884: ----------------------------------------------------
1885: -- ...then loop through the result set, gathering
1886: -- the column values
1887: ----------------------------------------------------
1888: WHILE (DBMS_SQL.Fetch_Rows(l_cursor_id) > 0)
1889: LOOP
1890:
1891:
1892: Write_Debug('loop through the result set, gathering the column values . . .' );

Line 1901: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);

1897: ------------------------------------
1898: -- Get the PK values for this row --
1899: ------------------------------------
1900: -- Item Id
1901: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);
1902: l_current_column_index := l_current_column_index + 1;
1903: -- l_pk_column_name_value_pairs(1).VALUE := SUBSTRB(l_retrieved_value, 1, 150);
1904: l_inventory_item_id := TO_NUMBER(l_retrieved_value) ;
1905:

Line 1911: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);

1907:
1908: Write_Debug('Got Item Id ' || to_char(l_inventory_item_id));
1909:
1910: -- Org Id
1911: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);
1912: l_current_column_index := l_current_column_index + 1;
1913: -- l_pk_column_name_value_pairs(2).VALUE := SUBSTRB(l_retrieved_value, 1, 150);
1914: l_organization_id := TO_NUMBER(l_retrieved_value) ;
1915:

Line 1922: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);

1918:
1919: ----------------------------
1920: -- Determine the ACD Type --
1921: ----------------------------
1922: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);
1923: l_current_column_index := l_current_column_index + 1;
1924: l_current_acd_type := l_retrieved_value;
1925:
1926: Write_Debug('Got Acd Id ' || l_current_acd_type);

Line 1931: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);

1927:
1928: ----------------------------
1929: -- Determine the generated Item Number
1930: ----------------------------
1931: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);
1932: l_current_column_index := l_current_column_index + 1;
1933: l_item_number := l_retrieved_value;
1934:
1935: Write_Debug('Got Item Number ' || l_item_number);

Line 1940: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);

1936:
1937: ----------------------------
1938: -- Determine the generated Item Number
1939: ----------------------------
1940: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);
1941: l_current_column_index := l_current_column_index + 1;
1942: l_item_desc := l_retrieved_value;
1943:
1944: Write_Debug('Got Item desc ' || l_item_desc);

Line 1959: DBMS_SQL.Column_Value(l_cursor_id, i, l_retrieved_value);

1955: -----------------------------------------------
1956: -- Get the current column name and its value --
1957: -----------------------------------------------
1958: l_current_column_name := l_desc_table(i).COL_NAME;
1959: DBMS_SQL.Column_Value(l_cursor_id, i, l_retrieved_value);
1960:
1961: ------------------------------------------------------------------------
1962: -- See whether the current column belongs to a User-Defined Attribute --
1963: ------------------------------------------------------------------------

Line 2251: l_dummy_c := DBMS_SQL.OPEN_CURSOR;

2247:
2248:
2249: BEGIN
2250:
2251: l_dummy_c := DBMS_SQL.OPEN_CURSOR;
2252: DBMS_SQL.PARSE(l_dummy_c, l_dynamic_sql, 2);
2253: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_mode_for_current_row', l_mode_for_current_row);
2254: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_inventory_item_id', l_inventory_item_id);
2255: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_item_number', l_item_number);

Line 2252: DBMS_SQL.PARSE(l_dummy_c, l_dynamic_sql, 2);

2248:
2249: BEGIN
2250:
2251: l_dummy_c := DBMS_SQL.OPEN_CURSOR;
2252: DBMS_SQL.PARSE(l_dummy_c, l_dynamic_sql, 2);
2253: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_mode_for_current_row', l_mode_for_current_row);
2254: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_inventory_item_id', l_inventory_item_id);
2255: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_item_number', l_item_number);
2256: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_organization_id', l_organization_id);

Line 2253: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_mode_for_current_row', l_mode_for_current_row);

2249: BEGIN
2250:
2251: l_dummy_c := DBMS_SQL.OPEN_CURSOR;
2252: DBMS_SQL.PARSE(l_dummy_c, l_dynamic_sql, 2);
2253: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_mode_for_current_row', l_mode_for_current_row);
2254: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_inventory_item_id', l_inventory_item_id);
2255: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_item_number', l_item_number);
2256: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_organization_id', l_organization_id);
2257: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_out_inventory_item_id', l_out_inventory_item_id);

Line 2254: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_inventory_item_id', l_inventory_item_id);

2250:
2251: l_dummy_c := DBMS_SQL.OPEN_CURSOR;
2252: DBMS_SQL.PARSE(l_dummy_c, l_dynamic_sql, 2);
2253: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_mode_for_current_row', l_mode_for_current_row);
2254: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_inventory_item_id', l_inventory_item_id);
2255: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_item_number', l_item_number);
2256: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_organization_id', l_organization_id);
2257: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_out_inventory_item_id', l_out_inventory_item_id);
2258: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_out_organization_id', l_out_organization_id);

Line 2255: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_item_number', l_item_number);

2251: l_dummy_c := DBMS_SQL.OPEN_CURSOR;
2252: DBMS_SQL.PARSE(l_dummy_c, l_dynamic_sql, 2);
2253: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_mode_for_current_row', l_mode_for_current_row);
2254: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_inventory_item_id', l_inventory_item_id);
2255: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_item_number', l_item_number);
2256: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_organization_id', l_organization_id);
2257: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_out_inventory_item_id', l_out_inventory_item_id);
2258: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_out_organization_id', l_out_organization_id);
2259: if l_item_desc is not null

Line 2256: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_organization_id', l_organization_id);

2252: DBMS_SQL.PARSE(l_dummy_c, l_dynamic_sql, 2);
2253: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_mode_for_current_row', l_mode_for_current_row);
2254: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_inventory_item_id', l_inventory_item_id);
2255: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_item_number', l_item_number);
2256: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_organization_id', l_organization_id);
2257: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_out_inventory_item_id', l_out_inventory_item_id);
2258: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_out_organization_id', l_out_organization_id);
2259: if l_item_desc is not null
2260: then

Line 2257: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_out_inventory_item_id', l_out_inventory_item_id);

2253: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_mode_for_current_row', l_mode_for_current_row);
2254: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_inventory_item_id', l_inventory_item_id);
2255: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_item_number', l_item_number);
2256: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_organization_id', l_organization_id);
2257: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_out_inventory_item_id', l_out_inventory_item_id);
2258: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_out_organization_id', l_out_organization_id);
2259: if l_item_desc is not null
2260: then
2261: DBMS_SQL.BIND_VARIABLE(l_dummy_c, 'l_item_desc', l_item_desc);

Line 2258: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_out_organization_id', l_out_organization_id);

2254: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_inventory_item_id', l_inventory_item_id);
2255: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_item_number', l_item_number);
2256: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_organization_id', l_organization_id);
2257: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_out_inventory_item_id', l_out_inventory_item_id);
2258: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_out_organization_id', l_out_organization_id);
2259: if l_item_desc is not null
2260: then
2261: DBMS_SQL.BIND_VARIABLE(l_dummy_c, 'l_item_desc', l_item_desc);
2262: end if;

Line 2261: DBMS_SQL.BIND_VARIABLE(l_dummy_c, 'l_item_desc', l_item_desc);

2257: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_out_inventory_item_id', l_out_inventory_item_id);
2258: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_out_organization_id', l_out_organization_id);
2259: if l_item_desc is not null
2260: then
2261: DBMS_SQL.BIND_VARIABLE(l_dummy_c, 'l_item_desc', l_item_desc);
2262: end if;
2263: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_return_status', l_return_status, 1);
2264: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_msg_count', l_msg_count);
2265: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_msg_data', l_msg_data, 2000);

Line 2263: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_return_status', l_return_status, 1);

2259: if l_item_desc is not null
2260: then
2261: DBMS_SQL.BIND_VARIABLE(l_dummy_c, 'l_item_desc', l_item_desc);
2262: end if;
2263: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_return_status', l_return_status, 1);
2264: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_msg_count', l_msg_count);
2265: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_msg_data', l_msg_data, 2000);
2266: l_dummy_r := DBMS_SQL.EXECUTE(l_dummy_c);
2267: DBMS_SQL.VARIABLE_VALUE(l_dummy_c, 'l_return_status', l_return_status);

Line 2264: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_msg_count', l_msg_count);

2260: then
2261: DBMS_SQL.BIND_VARIABLE(l_dummy_c, 'l_item_desc', l_item_desc);
2262: end if;
2263: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_return_status', l_return_status, 1);
2264: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_msg_count', l_msg_count);
2265: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_msg_data', l_msg_data, 2000);
2266: l_dummy_r := DBMS_SQL.EXECUTE(l_dummy_c);
2267: DBMS_SQL.VARIABLE_VALUE(l_dummy_c, 'l_return_status', l_return_status);
2268: DBMS_SQL.VARIABLE_VALUE(l_dummy_c, 'l_msg_count', l_msg_count);

Line 2265: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_msg_data', l_msg_data, 2000);

2261: DBMS_SQL.BIND_VARIABLE(l_dummy_c, 'l_item_desc', l_item_desc);
2262: end if;
2263: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_return_status', l_return_status, 1);
2264: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_msg_count', l_msg_count);
2265: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_msg_data', l_msg_data, 2000);
2266: l_dummy_r := DBMS_SQL.EXECUTE(l_dummy_c);
2267: DBMS_SQL.VARIABLE_VALUE(l_dummy_c, 'l_return_status', l_return_status);
2268: DBMS_SQL.VARIABLE_VALUE(l_dummy_c, 'l_msg_count', l_msg_count);
2269: DBMS_SQL.VARIABLE_VALUE(l_dummy_c, 'l_msg_data', l_msg_data);

Line 2266: l_dummy_r := DBMS_SQL.EXECUTE(l_dummy_c);

2262: end if;
2263: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_return_status', l_return_status, 1);
2264: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_msg_count', l_msg_count);
2265: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_msg_data', l_msg_data, 2000);
2266: l_dummy_r := DBMS_SQL.EXECUTE(l_dummy_c);
2267: DBMS_SQL.VARIABLE_VALUE(l_dummy_c, 'l_return_status', l_return_status);
2268: DBMS_SQL.VARIABLE_VALUE(l_dummy_c, 'l_msg_count', l_msg_count);
2269: DBMS_SQL.VARIABLE_VALUE(l_dummy_c, 'l_msg_data', l_msg_data);
2270:

Line 2267: DBMS_SQL.VARIABLE_VALUE(l_dummy_c, 'l_return_status', l_return_status);

2263: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_return_status', l_return_status, 1);
2264: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_msg_count', l_msg_count);
2265: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_msg_data', l_msg_data, 2000);
2266: l_dummy_r := DBMS_SQL.EXECUTE(l_dummy_c);
2267: DBMS_SQL.VARIABLE_VALUE(l_dummy_c, 'l_return_status', l_return_status);
2268: DBMS_SQL.VARIABLE_VALUE(l_dummy_c, 'l_msg_count', l_msg_count);
2269: DBMS_SQL.VARIABLE_VALUE(l_dummy_c, 'l_msg_data', l_msg_data);
2270:
2271:

Line 2268: DBMS_SQL.VARIABLE_VALUE(l_dummy_c, 'l_msg_count', l_msg_count);

2264: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_msg_count', l_msg_count);
2265: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_msg_data', l_msg_data, 2000);
2266: l_dummy_r := DBMS_SQL.EXECUTE(l_dummy_c);
2267: DBMS_SQL.VARIABLE_VALUE(l_dummy_c, 'l_return_status', l_return_status);
2268: DBMS_SQL.VARIABLE_VALUE(l_dummy_c, 'l_msg_count', l_msg_count);
2269: DBMS_SQL.VARIABLE_VALUE(l_dummy_c, 'l_msg_data', l_msg_data);
2270:
2271:
2272: Write_Debug('After calling EGO_ITEM_PUB.Process_Item' );

Line 2269: DBMS_SQL.VARIABLE_VALUE(l_dummy_c, 'l_msg_data', l_msg_data);

2265: DBMS_SQL.BIND_VARIABLE (l_dummy_c, 'l_msg_data', l_msg_data, 2000);
2266: l_dummy_r := DBMS_SQL.EXECUTE(l_dummy_c);
2267: DBMS_SQL.VARIABLE_VALUE(l_dummy_c, 'l_return_status', l_return_status);
2268: DBMS_SQL.VARIABLE_VALUE(l_dummy_c, 'l_msg_count', l_msg_count);
2269: DBMS_SQL.VARIABLE_VALUE(l_dummy_c, 'l_msg_data', l_msg_data);
2270:
2271:
2272: Write_Debug('After calling EGO_ITEM_PUB.Process_Item' );
2273: Write_Debug('---------------------------------- ' );

Line 2457: END LOOP; -- DBMS_SQL.Fetch_Rows Loop

2453:
2454: END IF; -- l_mode_for_current_row <> 'SKIP'
2455:
2456:
2457: END LOOP; -- DBMS_SQL.Fetch_Rows Loop
2458: DBMS_SQL.Close_Cursor(l_cursor_id);
2459:
2460:
2461: ---------------------------------------------------------------------------

Line 2458: DBMS_SQL.Close_Cursor(l_cursor_id);

2454: END IF; -- l_mode_for_current_row <> 'SKIP'
2455:
2456:
2457: END LOOP; -- DBMS_SQL.Fetch_Rows Loop
2458: DBMS_SQL.Close_Cursor(l_cursor_id);
2459:
2460:
2461: ---------------------------------------------------------------------------
2462: -- Finally, set the IMPLEMENTATION_DATE for all rows we just implemented --

Line 3018: l_desc_table DBMS_SQL.Desc_Tab;

3014: l_utility_dynamic_sql VARCHAR2(32767); --the largest a VARCHAR2 can be
3015: l_cursor_id NUMBER;
3016: l_column_count NUMBER;
3017: l_dummy NUMBER;
3018: l_desc_table DBMS_SQL.Desc_Tab;
3019: l_retrieved_value VARCHAR2(1000);
3020: l_current_column_index NUMBER;
3021:
3022: l_prod_b_table_name CONSTANT VARCHAR2(30) := 'EGO_ITEM_GTN_ATTRS_B' ;

Line 3327: l_cursor_id := DBMS_SQL.Open_Cursor;

3323:
3324:
3325: Write_Debug('Item GDSN Single Change Query:' || l_dynamic_sql );
3326:
3327: l_cursor_id := DBMS_SQL.Open_Cursor;
3328: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);
3329: DBMS_SQL.Bind_Variable(l_cursor_id, ':1', l_change_line_id);
3330: DBMS_SQL.Describe_Columns(l_cursor_id, l_column_count, l_desc_table);
3331:

Line 3328: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);

3324:
3325: Write_Debug('Item GDSN Single Change Query:' || l_dynamic_sql );
3326:
3327: l_cursor_id := DBMS_SQL.Open_Cursor;
3328: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);
3329: DBMS_SQL.Bind_Variable(l_cursor_id, ':1', l_change_line_id);
3330: DBMS_SQL.Describe_Columns(l_cursor_id, l_column_count, l_desc_table);
3331:
3332: FOR i IN 1 .. l_column_count

Line 3329: DBMS_SQL.Bind_Variable(l_cursor_id, ':1', l_change_line_id);

3325: Write_Debug('Item GDSN Single Change Query:' || l_dynamic_sql );
3326:
3327: l_cursor_id := DBMS_SQL.Open_Cursor;
3328: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);
3329: DBMS_SQL.Bind_Variable(l_cursor_id, ':1', l_change_line_id);
3330: DBMS_SQL.Describe_Columns(l_cursor_id, l_column_count, l_desc_table);
3331:
3332: FOR i IN 1 .. l_column_count
3333: LOOP

Line 3330: DBMS_SQL.Describe_Columns(l_cursor_id, l_column_count, l_desc_table);

3326:
3327: l_cursor_id := DBMS_SQL.Open_Cursor;
3328: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);
3329: DBMS_SQL.Bind_Variable(l_cursor_id, ':1', l_change_line_id);
3330: DBMS_SQL.Describe_Columns(l_cursor_id, l_column_count, l_desc_table);
3331:
3332: FOR i IN 1 .. l_column_count
3333: LOOP
3334: --

Line 3340: DBMS_SQL.Define_Column(l_cursor_id, i, l_retrieved_value, 1000);

3336: --
3337: -------------------------------------------------------------
3338: -- We define all columns as VARCHAR2(1000) for convenience --
3339: -------------------------------------------------------------
3340: DBMS_SQL.Define_Column(l_cursor_id, i, l_retrieved_value, 1000);
3341: END LOOP;
3342:
3343: ----------------------------------
3344: -- Execute our dynamic query... --

Line 3346: l_dummy := DBMS_SQL.Execute(l_cursor_id);

3342:
3343: ----------------------------------
3344: -- Execute our dynamic query... --
3345: ----------------------------------
3346: l_dummy := DBMS_SQL.Execute(l_cursor_id);
3347:
3348: ----------------------------------------------------
3349: -- ...then loop through the result set, gathering --
3350: -- the column values and then calling Process_Row --

Line 3352: WHILE (DBMS_SQL.Fetch_Rows(l_cursor_id) > 0)

3348: ----------------------------------------------------
3349: -- ...then loop through the result set, gathering --
3350: -- the column values and then calling Process_Row --
3351: ----------------------------------------------------
3352: WHILE (DBMS_SQL.Fetch_Rows(l_cursor_id) > 0)
3353: LOOP
3354: l_current_column_index := 1;
3355: l_attr_name_value_pairs.DELETE();
3356: ------------------------------------

Line 3360: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);

3356: ------------------------------------
3357: -- Get the PK values for this row --
3358: ------------------------------------
3359: -- Item Id
3360: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);
3361: l_current_column_index := l_current_column_index + 1;
3362: -- l_pk_column_name_value_pairs(1).VALUE := SUBSTRB(l_retrieved_value, 1, 150);
3363: l_inventory_item_id := TO_NUMBER(l_retrieved_value) ;
3364:

Line 3368: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);

3364:
3365: Write_Debug('Item GDSN Single Change Item Id: ' || to_char(l_inventory_item_id));
3366:
3367: -- Org Id
3368: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);
3369: l_current_column_index := l_current_column_index + 1;
3370: -- l_pk_column_name_value_pairs(2).VALUE := SUBSTRB(l_retrieved_value, 1, 150);
3371: l_organization_id := TO_NUMBER(l_retrieved_value) ;
3372: Write_Debug('Item GDSN Single Change Org Id: ' || to_char(l_organization_id));

Line 3377: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);

3373:
3374: ----------------------------
3375: -- Determine the ACD Type --
3376: ----------------------------
3377: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);
3378: l_current_column_index := l_current_column_index + 1;
3379: l_current_acd_type := l_retrieved_value;
3380:
3381: Write_Debug('Item GDSN Single Change ACD Type: ' || l_current_acd_type);

Line 3385: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);

3381: Write_Debug('Item GDSN Single Change ACD Type: ' || l_current_acd_type);
3382: --------------------------
3383: -- Get the extension ID --
3384: --------------------------
3385: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);
3386: l_current_column_index := l_current_column_index + 1;
3387: l_current_pending_ext_id := TO_NUMBER(l_retrieved_value);
3388:
3389: Write_Debug('Item GDSN Single Change Extension Id: ' || to_char(l_current_pending_ext_id));

Line 3403: DBMS_SQL.Column_Value(l_cursor_id, i, l_retrieved_value);

3399: -----------------------------------------------
3400: -- Get the current column name and its value --
3401: -----------------------------------------------
3402: l_current_column_name := l_desc_table(i).COL_NAME;
3403: DBMS_SQL.Column_Value(l_cursor_id, i, l_retrieved_value);
3404:
3405:
3406: ------------------------------------------------------------------------
3407: -- See whether the current column belongs to a User-Defined Attribute --

Line 3736: END LOOP; -- DBMS_SQL.Fetch_Rows Loop

3732:
3733: END IF; -- l_mode_for_current_row <> 'SKIP'
3734:
3735:
3736: END LOOP; -- DBMS_SQL.Fetch_Rows Loop
3737: DBMS_SQL.Close_Cursor(l_cursor_id);
3738:
3739:
3740: Write_Debug('After Processing Item GDSN Single Change . . . ' );

Line 3737: DBMS_SQL.Close_Cursor(l_cursor_id);

3733: END IF; -- l_mode_for_current_row <> 'SKIP'
3734:
3735:
3736: END LOOP; -- DBMS_SQL.Fetch_Rows Loop
3737: DBMS_SQL.Close_Cursor(l_cursor_id);
3738:
3739:
3740: Write_Debug('After Processing Item GDSN Single Change . . . ' );
3741:

Line 3767: l_cursor_id := DBMS_SQL.Open_Cursor;

3763:
3764:
3765: -- Write_Debug('Item GDSN Multi-Row Change Query:' || l_mul_dynamic_sql );
3766:
3767: l_cursor_id := DBMS_SQL.Open_Cursor;
3768: DBMS_SQL.Parse(l_cursor_id, l_mul_dynamic_sql, DBMS_SQL.Native);
3769: DBMS_SQL.Bind_Variable(l_cursor_id, ':1', l_change_line_id);
3770: DBMS_SQL.Describe_Columns(l_cursor_id, l_column_count, l_desc_table);
3771:

Line 3768: DBMS_SQL.Parse(l_cursor_id, l_mul_dynamic_sql, DBMS_SQL.Native);

3764:
3765: -- Write_Debug('Item GDSN Multi-Row Change Query:' || l_mul_dynamic_sql );
3766:
3767: l_cursor_id := DBMS_SQL.Open_Cursor;
3768: DBMS_SQL.Parse(l_cursor_id, l_mul_dynamic_sql, DBMS_SQL.Native);
3769: DBMS_SQL.Bind_Variable(l_cursor_id, ':1', l_change_line_id);
3770: DBMS_SQL.Describe_Columns(l_cursor_id, l_column_count, l_desc_table);
3771:
3772: FOR i IN 1 .. l_column_count

Line 3769: DBMS_SQL.Bind_Variable(l_cursor_id, ':1', l_change_line_id);

3765: -- Write_Debug('Item GDSN Multi-Row Change Query:' || l_mul_dynamic_sql );
3766:
3767: l_cursor_id := DBMS_SQL.Open_Cursor;
3768: DBMS_SQL.Parse(l_cursor_id, l_mul_dynamic_sql, DBMS_SQL.Native);
3769: DBMS_SQL.Bind_Variable(l_cursor_id, ':1', l_change_line_id);
3770: DBMS_SQL.Describe_Columns(l_cursor_id, l_column_count, l_desc_table);
3771:
3772: FOR i IN 1 .. l_column_count
3773: LOOP

Line 3770: DBMS_SQL.Describe_Columns(l_cursor_id, l_column_count, l_desc_table);

3766:
3767: l_cursor_id := DBMS_SQL.Open_Cursor;
3768: DBMS_SQL.Parse(l_cursor_id, l_mul_dynamic_sql, DBMS_SQL.Native);
3769: DBMS_SQL.Bind_Variable(l_cursor_id, ':1', l_change_line_id);
3770: DBMS_SQL.Describe_Columns(l_cursor_id, l_column_count, l_desc_table);
3771:
3772: FOR i IN 1 .. l_column_count
3773: LOOP
3774: --

Line 3780: DBMS_SQL.Define_Column(l_cursor_id, i, l_retrieved_value, 1000);

3776: --
3777: -------------------------------------------------------------
3778: -- We define all columns as VARCHAR2(1000) for convenience --
3779: -------------------------------------------------------------
3780: DBMS_SQL.Define_Column(l_cursor_id, i, l_retrieved_value, 1000);
3781: END LOOP;
3782:
3783: ----------------------------------
3784: -- Execute our dynamic query... --

Line 3786: l_dummy := DBMS_SQL.Execute(l_cursor_id);

3782:
3783: ----------------------------------
3784: -- Execute our dynamic query... --
3785: ----------------------------------
3786: l_dummy := DBMS_SQL.Execute(l_cursor_id);
3787:
3788: ----------------------------------------------------
3789: -- ...then loop through the result set, gathering --
3790: -- the column values and then calling Process_Row --

Line 3805: WHILE (DBMS_SQL.Fetch_Rows(l_cursor_id) > 0)

3801: -- l_ext_table_metadata_obj
3802: -- := EGO_USER_ATTRS_COMMON_PVT.Get_Ext_Table_Metadata(l_object_id);
3803:
3804:
3805: WHILE (DBMS_SQL.Fetch_Rows(l_cursor_id) > 0)
3806: LOOP
3807:
3808: Write_Debug('----------- Fetch Mutl-Row Attr Change Rercord ---------- ' );
3809:

Line 3816: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);

3812: ------------------------------------
3813: -- Get the PK values for this row --
3814: ------------------------------------
3815: -- Item Id
3816: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);
3817: l_current_column_index := l_current_column_index + 1;
3818: l_pk_column_name_value_pairs(1).VALUE := SUBSTRB(l_retrieved_value, 1, 150);
3819: l_inventory_item_id := TO_NUMBER(l_retrieved_value) ;
3820:

Line 3825: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);

3821: Write_Debug('Item GDSN Multi-Row Change Item Id: ' || to_char(l_inventory_item_id));
3822:
3823:
3824: -- Org Id
3825: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);
3826: l_current_column_index := l_current_column_index + 1;
3827: l_pk_column_name_value_pairs(2).VALUE := SUBSTRB(l_retrieved_value, 1, 150);
3828: l_organization_id := TO_NUMBER(l_retrieved_value) ;
3829:

Line 3837: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);

3833:
3834: ----------------------------
3835: -- Determine the ACD Type --
3836: ----------------------------
3837: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);
3838: l_current_column_index := l_current_column_index + 1;
3839: l_current_acd_type := l_retrieved_value;
3840:
3841: Write_Debug('Item GDSN Multi-Row Change ACD Type: ' || l_current_acd_type);

Line 3846: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);

3842:
3843: --------------------------
3844: -- Get the extension ID --
3845: --------------------------
3846: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);
3847: l_current_column_index := l_current_column_index + 1;
3848: l_current_pending_ext_id := TO_NUMBER(l_retrieved_value);
3849:
3850:

Line 3857: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);

3853: ---------------------------------------------------------
3854: -- Find the Attr Group metadata from the Attr Group ID --
3855: ---------------------------------------------------------
3856:
3857: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);
3858: l_current_column_index := l_current_column_index + 1;
3859: l_attr_group_id := TO_NUMBER(l_retrieved_value) ;
3860:
3861: Write_Debug('EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata for ' || to_char(l_attr_group_id));

Line 3881: DBMS_SQL.Column_Value(l_cursor_id, i, l_retrieved_value);

3877: -----------------------------------------------
3878: -- Get the current column name and its value --
3879: -----------------------------------------------
3880: l_current_column_name := l_desc_table(i).COL_NAME;
3881: DBMS_SQL.Column_Value(l_cursor_id, i, l_retrieved_value);
3882:
3883: ------------------------------------------------------------------------
3884: -- See whether the current column belongs to a User-Defined Attribute --
3885: ------------------------------------------------------------------------

Line 4206: END LOOP; -- DBMS_SQL.Fetch_Rows Loop

4202:
4203: END IF; -- l_mode_for_current_row <> 'SKIP'
4204:
4205:
4206: END LOOP; -- DBMS_SQL.Fetch_Rows Loop
4207: DBMS_SQL.Close_Cursor(l_cursor_id);
4208:
4209: Write_Debug('--------------------------------------------------' );
4210: Write_Debug('After Processing Item GDSN Mult-Row Changes . . . ' );

Line 4207: DBMS_SQL.Close_Cursor(l_cursor_id);

4203: END IF; -- l_mode_for_current_row <> 'SKIP'
4204:
4205:
4206: END LOOP; -- DBMS_SQL.Fetch_Rows Loop
4207: DBMS_SQL.Close_Cursor(l_cursor_id);
4208:
4209: Write_Debug('--------------------------------------------------' );
4210: Write_Debug('After Processing Item GDSN Mult-Row Changes . . . ' );
4211:

Line 4541: l_desc_table DBMS_SQL.Desc_Tab;

4537: l_history_tl_prod_cols_list VARCHAR2(10000);
4538: l_dynamic_sql VARCHAR2(32767); --the largest a VARCHAR2 can be
4539: l_cursor_id NUMBER;
4540: l_column_count NUMBER;
4541: l_desc_table DBMS_SQL.Desc_Tab;
4542: l_retrieved_value VARCHAR2(1000);
4543: l_dummy NUMBER;
4544: l_current_column_index NUMBER;
4545: l_current_row_language VARCHAR2(30);

Line 4880: l_cursor_id := DBMS_SQL.Open_Cursor;

4876: ' AND B.CHANGE_LINE_ID = TL.CHANGE_LINE_ID'||
4877: ' AND B.CHANGE_LINE_ID = :1 ' ||
4878: ' ORDER BY B.EXTENSION_ID';
4879:
4880: l_cursor_id := DBMS_SQL.Open_Cursor;
4881: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);
4882: DBMS_SQL.Bind_Variable(l_cursor_id, ':1', p_change_line_id);
4883: DBMS_SQL.Describe_Columns(l_cursor_id, l_column_count, l_desc_table);
4884: write_debug('Sql formed for the attr changes : ' || l_dynamic_sql);

Line 4881: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);

4877: ' AND B.CHANGE_LINE_ID = :1 ' ||
4878: ' ORDER BY B.EXTENSION_ID';
4879:
4880: l_cursor_id := DBMS_SQL.Open_Cursor;
4881: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);
4882: DBMS_SQL.Bind_Variable(l_cursor_id, ':1', p_change_line_id);
4883: DBMS_SQL.Describe_Columns(l_cursor_id, l_column_count, l_desc_table);
4884: write_debug('Sql formed for the attr changes : ' || l_dynamic_sql);
4885: FOR i IN 1 .. l_column_count

Line 4882: DBMS_SQL.Bind_Variable(l_cursor_id, ':1', p_change_line_id);

4878: ' ORDER BY B.EXTENSION_ID';
4879:
4880: l_cursor_id := DBMS_SQL.Open_Cursor;
4881: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);
4882: DBMS_SQL.Bind_Variable(l_cursor_id, ':1', p_change_line_id);
4883: DBMS_SQL.Describe_Columns(l_cursor_id, l_column_count, l_desc_table);
4884: write_debug('Sql formed for the attr changes : ' || l_dynamic_sql);
4885: FOR i IN 1 .. l_column_count
4886: LOOP

Line 4883: DBMS_SQL.Describe_Columns(l_cursor_id, l_column_count, l_desc_table);

4879:
4880: l_cursor_id := DBMS_SQL.Open_Cursor;
4881: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);
4882: DBMS_SQL.Bind_Variable(l_cursor_id, ':1', p_change_line_id);
4883: DBMS_SQL.Describe_Columns(l_cursor_id, l_column_count, l_desc_table);
4884: write_debug('Sql formed for the attr changes : ' || l_dynamic_sql);
4885: FOR i IN 1 .. l_column_count
4886: LOOP
4887:

Line 4894: DBMS_SQL.Define_Column(l_cursor_id, i, l_retrieved_value, 1000);

4890: --
4891: -------------------------------------------------------------
4892: -- We define all columns as VARCHAR2(1000) for convenience --
4893: -------------------------------------------------------------
4894: DBMS_SQL.Define_Column(l_cursor_id, i, l_retrieved_value, 1000);
4895: END LOOP;
4896:
4897: ----------------------------------
4898: -- Execute our dynamic query... --

Line 4900: l_dummy := DBMS_SQL.Execute(l_cursor_id);

4896:
4897: ----------------------------------
4898: -- Execute our dynamic query... --
4899: ----------------------------------
4900: l_dummy := DBMS_SQL.Execute(l_cursor_id);
4901:
4902: ----------------------------------------------------
4903: -- ...then loop through the result set, gathering --
4904: -- the column values and then calling Process_Row --

Line 4906: WHILE (DBMS_SQL.Fetch_Rows(l_cursor_id) > 0)

4902: ----------------------------------------------------
4903: -- ...then loop through the result set, gathering --
4904: -- the column values and then calling Process_Row --
4905: ----------------------------------------------------
4906: WHILE (DBMS_SQL.Fetch_Rows(l_cursor_id) > 0)
4907: LOOP
4908:
4909: l_current_column_index := 1;
4910: l_attr_name_value_pairs.DELETE();

Line 4916: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);

4912: ------------------------------------
4913: -- Get the PK values for this row --
4914: ------------------------------------
4915: IF (l_pk_column_name_value_pairs.COUNT > 0) THEN
4916: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);
4917: l_current_column_index := l_current_column_index + 1;
4918: l_pk_column_name_value_pairs(1).VALUE := SUBSTRB(l_retrieved_value, 1, 150);
4919: END IF;
4920: IF (l_pk_column_name_value_pairs.COUNT > 1) THEN

Line 4921: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);

4917: l_current_column_index := l_current_column_index + 1;
4918: l_pk_column_name_value_pairs(1).VALUE := SUBSTRB(l_retrieved_value, 1, 150);
4919: END IF;
4920: IF (l_pk_column_name_value_pairs.COUNT > 1) THEN
4921: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);
4922: l_current_column_index := l_current_column_index + 1;
4923: l_pk_column_name_value_pairs(2).VALUE := SUBSTRB(l_retrieved_value, 1, 150);
4924: END IF;
4925: IF (l_pk_column_name_value_pairs.COUNT > 2) THEN

Line 4926: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);

4922: l_current_column_index := l_current_column_index + 1;
4923: l_pk_column_name_value_pairs(2).VALUE := SUBSTRB(l_retrieved_value, 1, 150);
4924: END IF;
4925: IF (l_pk_column_name_value_pairs.COUNT > 2) THEN
4926: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);
4927: l_current_column_index := l_current_column_index + 1;
4928: l_pk_column_name_value_pairs(3).VALUE := SUBSTRB(l_retrieved_value, 1, 150);
4929: END IF;
4930: IF (l_pk_column_name_value_pairs.COUNT > 3) THEN

Line 4931: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);

4927: l_current_column_index := l_current_column_index + 1;
4928: l_pk_column_name_value_pairs(3).VALUE := SUBSTRB(l_retrieved_value, 1, 150);
4929: END IF;
4930: IF (l_pk_column_name_value_pairs.COUNT > 3) THEN
4931: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);
4932: l_current_column_index := l_current_column_index + 1;
4933: l_pk_column_name_value_pairs(4).VALUE := SUBSTRB(l_retrieved_value, 1, 150);
4934: END IF;
4935: IF (l_pk_column_name_value_pairs.COUNT > 4) THEN

Line 4936: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);

4932: l_current_column_index := l_current_column_index + 1;
4933: l_pk_column_name_value_pairs(4).VALUE := SUBSTRB(l_retrieved_value, 1, 150);
4934: END IF;
4935: IF (l_pk_column_name_value_pairs.COUNT > 4) THEN
4936: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);
4937: l_current_column_index := l_current_column_index + 1;
4938: l_pk_column_name_value_pairs(5).VALUE := SUBSTRB(l_retrieved_value, 1, 150);
4939: END IF;
4940:

Line 4947: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);

4943: -- and try to get related Class Codes as well --
4944: ------------------------------------------------
4945: IF (l_class_code_name_value_pairs IS NOT NULL AND
4946: l_class_code_name_value_pairs.COUNT > 0) THEN
4947: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);
4948: l_current_column_index := l_current_column_index + 1;
4949: l_class_code_name_value_pairs(1).VALUE := SUBSTRB(l_retrieved_value, 1, 150);
4950:
4951: Write_Debug('Current Item catalog category id in : ' || TO_CHAR(l_class_code_name_value_pairs(1).VALUE));

Line 4964: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);

4960:
4961: ----------------------------
4962: -- Determine the ACD Type --
4963: ----------------------------
4964: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);
4965: l_current_column_index := l_current_column_index + 1;
4966: l_current_acd_type := l_retrieved_value;
4967:
4968: ---------------------------------------------------------

Line 4971: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);

4967:
4968: ---------------------------------------------------------
4969: -- Find the Attr Group metadata from the Attr Group ID --
4970: ---------------------------------------------------------
4971: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);
4972: l_current_column_index := l_current_column_index + 1;
4973: L_ATTR_GROUP_ID := TO_NUMBER(l_retrieved_value);
4974: l_attr_group_metadata_obj :=
4975: EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata(

Line 4982: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);

4978:
4979: --------------------------
4980: -- Get the extension ID --
4981: --------------------------
4982: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);
4983: l_current_column_index := l_current_column_index + 1;
4984: l_current_pending_ext_id := TO_NUMBER(l_retrieved_value);
4985:
4986: Write_Debug('Current Pending Ext Id : ' || TO_CHAR(l_current_pending_ext_id));

Line 4992: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);

4988:
4989: ---------------------------------------------------------
4990: -- Find the Attr Data Level and Data Level Pks
4991: ---------------------------------------------------------
4992: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);
4993: l_current_column_index := l_current_column_index + 1;
4994: L_DATA_LEVEL_ID := TO_NUMBER(l_retrieved_value);
4995: Write_Debug('Current data level Id : ' || TO_CHAR(L_DATA_LEVEL_ID));
4996: if L_DATA_LEVEL_ID is not NULL

Line 5004: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);

5000: Write_Debug('Current data level name : ' || TO_CHAR(L_DATA_LEVEL_NAME));
5001:
5002: IF L_DATA_LEVEL_NAME='ITEM_REVISION_LEVEL'
5003: THEN
5004: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);
5005: l_current_column_index := l_current_column_index + 5;
5006: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ(
5007: L_DATA_LEVEL_META_DATA.PK_COLUMN_NAME1,
5008: l_retrieved_value));

Line 5018: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);

5014: null));
5015: l_current_column_index := l_current_column_index + 1;
5016: if L_DATA_LEVEL_META_DATA.PK_COLUMN_NAME1 IS NOT NULL
5017: THEN
5018: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);
5019:
5020: --l_current_column_index := l_current_column_index + 1;
5021: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ(
5022: L_DATA_LEVEL_META_DATA.PK_COLUMN_NAME1,

Line 5032: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);

5028: l_current_column_index := l_current_column_index + 1;
5029: if L_DATA_LEVEL_META_DATA.PK_COLUMN_NAME2 IS NOT NULL
5030: THEN
5031:
5032: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);
5033: --l_current_column_index := l_current_column_index + 1;
5034: l_data_level_name_value_pairs.EXTEND;
5035: l_data_level_name_value_pairs(l_data_level_name_value_pairs.LAST):= EGO_COL_NAME_VALUE_PAIR_OBJ(
5036: L_DATA_LEVEL_META_DATA.PK_COLUMN_NAME2,

Line 5046: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);

5042: l_current_column_index := l_current_column_index + 1;
5043: if L_DATA_LEVEL_META_DATA.PK_COLUMN_NAME3 IS NOT NULL
5044: THEN
5045:
5046: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);
5047: -- l_current_column_index := l_current_column_index + 1;
5048: l_data_level_name_value_pairs.EXTEND;
5049: l_data_level_name_value_pairs(l_data_level_name_value_pairs.LAST):= EGO_COL_NAME_VALUE_PAIR_OBJ(
5050: L_DATA_LEVEL_META_DATA.PK_COLUMN_NAME3,

Line 5060: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);

5056: l_current_column_index := l_current_column_index + 1;
5057: if L_DATA_LEVEL_META_DATA.PK_COLUMN_NAME4 IS NOT NULL
5058: THEN
5059:
5060: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);
5061: --l_current_column_index := l_current_column_index + 1;
5062: l_data_level_name_value_pairs.EXTEND;
5063: l_data_level_name_value_pairs(l_data_level_name_value_pairs.LAST):= EGO_COL_NAME_VALUE_PAIR_OBJ(
5064: L_DATA_LEVEL_META_DATA.PK_COLUMN_NAME4,

Line 5074: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);

5070: l_current_column_index := l_current_column_index + 1;
5071: if L_DATA_LEVEL_META_DATA.PK_COLUMN_NAME5 IS NOT NULL
5072: THEN
5073:
5074: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);
5075: --l_current_column_index := l_current_column_index + 1;
5076: l_data_level_name_value_pairs.EXTEND;
5077: l_data_level_name_value_pairs(l_data_level_name_value_pairs.LAST):= EGO_COL_NAME_VALUE_PAIR_OBJ(
5078: L_DATA_LEVEL_META_DATA.PK_COLUMN_NAME5,

Line 5134: DBMS_SQL.Column_Value(l_cursor_id, i, l_retrieved_value);

5130: -- Get the current column name and its value --
5131: -----------------------------------------------
5132:
5133: l_current_column_name := l_desc_table(i).COL_NAME;
5134: DBMS_SQL.Column_Value(l_cursor_id, i, l_retrieved_value);
5135: -- write_debug(l_current_column_name||' : ' || l_retrieved_value);
5136: ------------------------------------------------------------------------
5137: -- See whether the current column belongs to a User-Defined Attribute --
5138: ------------------------------------------------------------------------

Line 5701: DBMS_SQL.Close_Cursor(l_cursor_id);

5697: RAISE FND_API.G_EXC_ERROR;
5698: END IF;
5699: END IF;
5700: END LOOP;
5701: DBMS_SQL.Close_Cursor(l_cursor_id);
5702:
5703: ---------------------------------------------------------------------------
5704: -- Finally, set the IMPLEMENTATION_DATE for all rows we just implemented --
5705: ---------------------------------------------------------------------------