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

Line 1786: l_cursor_id := DBMS_SQL.OPEN_CURSOR;

1782: ,msg.created_by);
1783: */
1784:
1785:
1786: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
1787:
1788:
1789: IF p_order_type_id is null
1790: AND p_order_number_from is null

Line 1877: DBMS_SQL.PARSE(l_cursor_id, l_stmt, DBMS_SQL.native);

1873: END IF;
1874:
1875: OE_DEBUG_PUB.Add(substr(l_stmt,1,length(l_stmt)),1);
1876:
1877: DBMS_SQL.PARSE(l_cursor_id, l_stmt, DBMS_SQL.native);
1878:
1879: OE_DEBUG_PUB.Add('after parse',1);
1880: --5121760
1881: SELECT fnd_date.chardt_to_date(p_creation_date_from),

Line 1886: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':message_source_code',p_message_source_code);

1882: fnd_date.chardt_to_date(p_creation_date_to)
1883: INTO l_creation_date_from,l_creation_date_to
1884: FROM DUAL;
1885: IF p_message_source_code IS NOT NULL THEN
1886: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':message_source_code',p_message_source_code);
1887: END IF;
1888:
1889: IF p_request_id_from IS NOT NULL THEN
1890: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':request_id_from',p_request_id_from);

Line 1890: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':request_id_from',p_request_id_from);

1886: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':message_source_code',p_message_source_code);
1887: END IF;
1888:
1889: IF p_request_id_from IS NOT NULL THEN
1890: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':request_id_from',p_request_id_from);
1891: END IF;
1892:
1893: IF p_request_id_to IS NOT NULL THEN
1894: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':request_id_to',p_request_id_to);

Line 1894: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':request_id_to',p_request_id_to);

1890: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':request_id_from',p_request_id_from);
1891: END IF;
1892:
1893: IF p_request_id_to IS NOT NULL THEN
1894: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':request_id_to',p_request_id_to);
1895: END IF;
1896: --5121760
1897: IF p_creation_date_from IS NOT NULL THEN
1898: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':creation_date_from',trunc(l_creation_date_from));

Line 1898: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':creation_date_from',trunc(l_creation_date_from));

1894: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':request_id_to',p_request_id_to);
1895: END IF;
1896: --5121760
1897: IF p_creation_date_from IS NOT NULL THEN
1898: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':creation_date_from',trunc(l_creation_date_from));
1899: END IF;
1900: IF p_creation_date_to IS NOT NULL THEN
1901: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':creation_date_to',trunc(l_creation_date_to));
1902: END IF;

Line 1901: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':creation_date_to',trunc(l_creation_date_to));

1897: IF p_creation_date_from IS NOT NULL THEN
1898: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':creation_date_from',trunc(l_creation_date_from));
1899: END IF;
1900: IF p_creation_date_to IS NOT NULL THEN
1901: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':creation_date_to',trunc(l_creation_date_to));
1902: END IF;
1903:
1904: IF p_program_id IS NOT NULL THEN
1905: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':program_id',p_program_id);

Line 1905: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':program_id',p_program_id);

1901: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':creation_date_to',trunc(l_creation_date_to));
1902: END IF;
1903:
1904: IF p_program_id IS NOT NULL THEN
1905: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':program_id',p_program_id);
1906: END IF;
1907:
1908: IF p_attribute_code IS NOT NULL THEN
1909: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':attribute_code',p_attribute_code);

Line 1909: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':attribute_code',p_attribute_code);

1905: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':program_id',p_program_id);
1906: END IF;
1907:
1908: IF p_attribute_code IS NOT NULL THEN
1909: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':attribute_code',p_attribute_code);
1910: END IF;
1911:
1912: IF p_created_by IS NOT NULL THEN
1913: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':created_by',p_created_by);

Line 1913: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':created_by',p_created_by);

1909: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':attribute_code',p_attribute_code);
1910: END IF;
1911:
1912: IF p_created_by IS NOT NULL THEN
1913: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':created_by',p_created_by);
1914: END IF;
1915:
1916: IF p_order_number_from IS NOT NULL THEN
1917: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_number_from',p_order_number_from);

Line 1917: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_number_from',p_order_number_from);

1913: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':created_by',p_created_by);
1914: END IF;
1915:
1916: IF p_order_number_from IS NOT NULL THEN
1917: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_number_from',p_order_number_from);
1918: END IF;
1919:
1920: IF p_order_number_to IS NOT NULL THEN
1921: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_number_to',p_order_number_to);

Line 1921: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_number_to',p_order_number_to);

1917: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_number_from',p_order_number_from);
1918: END IF;
1919:
1920: IF p_order_number_to IS NOT NULL THEN
1921: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_number_to',p_order_number_to);
1922: END IF;
1923:
1924: IF p_order_type_id IS NOT NULL THEN
1925: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_type_id',p_order_type_id);

Line 1925: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_type_id',p_order_type_id);

1921: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_number_to',p_order_number_to);
1922: END IF;
1923:
1924: IF p_order_type_id IS NOT NULL THEN
1925: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_type_id',p_order_type_id);
1926: END IF;
1927:
1928: IF p_organization_id IS NOT NULL THEN
1929: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':sold_to_org_id',p_organization_id);

Line 1929: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':sold_to_org_id',p_organization_id);

1925: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_type_id',p_order_type_id);
1926: END IF;
1927:
1928: IF p_organization_id IS NOT NULL THEN
1929: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':sold_to_org_id',p_organization_id);
1930: END IF;
1931:
1932: IF p_process_activity_name IS NOT NULL THEN
1933: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':process_activity_name',p_process_activity_name);

Line 1933: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':process_activity_name',p_process_activity_name);

1929: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':sold_to_org_id',p_organization_id);
1930: END IF;
1931:
1932: IF p_process_activity_name IS NOT NULL THEN
1933: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':process_activity_name',p_process_activity_name);
1934: END IF;
1935:
1936: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,1,l_transaction_id);
1937: oe_debug_pub.add('Before execute ',1);

Line 1936: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,1,l_transaction_id);

1932: IF p_process_activity_name IS NOT NULL THEN
1933: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':process_activity_name',p_process_activity_name);
1934: END IF;
1935:
1936: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,1,l_transaction_id);
1937: oe_debug_pub.add('Before execute ',1);
1938: l_retval := DBMS_SQL.EXECUTE(l_cursor_id);
1939:
1940: LOOP

Line 1938: l_retval := DBMS_SQL.EXECUTE(l_cursor_id);

1934: END IF;
1935:
1936: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,1,l_transaction_id);
1937: oe_debug_pub.add('Before execute ',1);
1938: l_retval := DBMS_SQL.EXECUTE(l_cursor_id);
1939:
1940: LOOP
1941: oe_debug_pub.add('J: ' || J,1);
1942:

Line 1943: IF DBMS_SQL.FETCH_ROWS(l_cursor_id) = 0 THEN

1939:
1940: LOOP
1941: oe_debug_pub.add('J: ' || J,1);
1942:
1943: IF DBMS_SQL.FETCH_ROWS(l_cursor_id) = 0 THEN
1944: EXIT;
1945: END IF;
1946:
1947: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_transaction_id);

Line 1947: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_transaction_id);

1943: IF DBMS_SQL.FETCH_ROWS(l_cursor_id) = 0 THEN
1944: EXIT;
1945: END IF;
1946:
1947: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_transaction_id);
1948: J := J +1 ;
1949:
1950: oe_debug_pub.add('l_transaction_id: ' || l_transaction_id,1);
1951: oe_debug_pub.add('J1: ' || J,1);

Line 1959: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);

1955:
1956: END LOOP;
1957:
1958: oe_debug_pub.add('Before Close ',1);
1959: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
1960:
1961:
1962: oe_debug_pub.add('Count: ' || Transactionids.COUNT,1);
1963:

Line 2094: l_cursor_id := DBMS_SQL.OPEN_CURSOR;

2090: Transactionrowids.DELETE;
2091: commit;
2092: */
2093:
2094: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
2095:
2096:
2097:
2098: l_stmt := 'select transaction_id ' ||

Line 2139: DBMS_SQL.PARSE(l_cursor_id, l_stmt, DBMS_SQL.native);

2135: END IF;
2136:
2137: OE_DEBUG_PUB.Add(substr(l_stmt,1,length(l_stmt)),1);
2138:
2139: DBMS_SQL.PARSE(l_cursor_id, l_stmt, DBMS_SQL.native);
2140:
2141: OE_DEBUG_PUB.Add('after parse',1);
2142: IF p_order_source_id IS NOT NULL THEN
2143: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_source_id',p_order_source_id);

Line 2143: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_source_id',p_order_source_id);

2139: DBMS_SQL.PARSE(l_cursor_id, l_stmt, DBMS_SQL.native);
2140:
2141: OE_DEBUG_PUB.Add('after parse',1);
2142: IF p_order_source_id IS NOT NULL THEN
2143: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_source_id',p_order_source_id);
2144: END IF;
2145:
2146: IF p_request_id IS NOT NULL THEN
2147: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':request_id',p_request_id);

Line 2147: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':request_id',p_request_id);

2143: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_source_id',p_order_source_id);
2144: END IF;
2145:
2146: IF p_request_id IS NOT NULL THEN
2147: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':request_id',p_request_id);
2148: END IF;
2149:
2150: IF p_orig_sys_document_ref IS NOT NULL THEN
2151: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':orig_sys_document_ref',p_orig_sys_document_ref);

Line 2151: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':orig_sys_document_ref',p_orig_sys_document_ref);

2147: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':request_id',p_request_id);
2148: END IF;
2149:
2150: IF p_orig_sys_document_ref IS NOT NULL THEN
2151: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':orig_sys_document_ref',p_orig_sys_document_ref);
2152: END IF;
2153:
2154: IF p_Orig_sys_document_line_ref IS NOT NULL THEN
2155: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':Orig_sys_document_line_ref',p_Orig_sys_document_line_ref);

Line 2155: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':Orig_sys_document_line_ref',p_Orig_sys_document_line_ref);

2151: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':orig_sys_document_ref',p_orig_sys_document_ref);
2152: END IF;
2153:
2154: IF p_Orig_sys_document_line_ref IS NOT NULL THEN
2155: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':Orig_sys_document_line_ref',p_Orig_sys_document_line_ref);
2156: END IF;
2157:
2158: IF p_orig_sys_shipment_ref IS NOT NULL THEN
2159: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':orig_sys_shipment_ref',p_orig_sys_shipment_ref);

Line 2159: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':orig_sys_shipment_ref',p_orig_sys_shipment_ref);

2155: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':Orig_sys_document_line_ref',p_Orig_sys_document_line_ref);
2156: END IF;
2157:
2158: IF p_orig_sys_shipment_ref IS NOT NULL THEN
2159: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':orig_sys_shipment_ref',p_orig_sys_shipment_ref);
2160: END IF;
2161:
2162: IF p_change_sequence IS NOT NULL THEN
2163: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':change_sequence',p_change_sequence);

Line 2163: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':change_sequence',p_change_sequence);

2159: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':orig_sys_shipment_ref',p_orig_sys_shipment_ref);
2160: END IF;
2161:
2162: IF p_change_sequence IS NOT NULL THEN
2163: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':change_sequence',p_change_sequence);
2164: END IF;
2165:
2166: IF p_entity_code IS NOT NULL THEN
2167: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':entity_code',p_entity_code);

Line 2167: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':entity_code',p_entity_code);

2163: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':change_sequence',p_change_sequence);
2164: END IF;
2165:
2166: IF p_entity_code IS NOT NULL THEN
2167: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':entity_code',p_entity_code);
2168: END IF;
2169:
2170: IF p_entity_ref IS NOT NULL THEN
2171: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':entity_ref',p_entity_ref);

Line 2171: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':entity_ref',p_entity_ref);

2167: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':entity_code',p_entity_code);
2168: END IF;
2169:
2170: IF p_entity_ref IS NOT NULL THEN
2171: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':entity_ref',p_entity_ref);
2172: END IF;
2173:
2174: IF p_org_id IS NOT NULL THEN
2175: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':org_id',p_org_id);

Line 2175: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':org_id',p_org_id);

2171: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':entity_ref',p_entity_ref);
2172: END IF;
2173:
2174: IF p_org_id IS NOT NULL THEN
2175: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':org_id',p_org_id);
2176: END IF;
2177:
2178: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,1,l_transaction_id);
2179: oe_debug_pub.add('Before execute ',1);

Line 2178: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,1,l_transaction_id);

2174: IF p_org_id IS NOT NULL THEN
2175: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':org_id',p_org_id);
2176: END IF;
2177:
2178: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,1,l_transaction_id);
2179: oe_debug_pub.add('Before execute ',1);
2180: l_retval := DBMS_SQL.EXECUTE(l_cursor_id);
2181:
2182: LOOP

Line 2180: l_retval := DBMS_SQL.EXECUTE(l_cursor_id);

2176: END IF;
2177:
2178: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,1,l_transaction_id);
2179: oe_debug_pub.add('Before execute ',1);
2180: l_retval := DBMS_SQL.EXECUTE(l_cursor_id);
2181:
2182: LOOP
2183: oe_debug_pub.add('J: ' || J,1);
2184:

Line 2185: IF DBMS_SQL.FETCH_ROWS(l_cursor_id) = 0 THEN

2181:
2182: LOOP
2183: oe_debug_pub.add('J: ' || J,1);
2184:
2185: IF DBMS_SQL.FETCH_ROWS(l_cursor_id) = 0 THEN
2186: EXIT;
2187: END IF;
2188:
2189: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_transaction_id);

Line 2189: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_transaction_id);

2185: IF DBMS_SQL.FETCH_ROWS(l_cursor_id) = 0 THEN
2186: EXIT;
2187: END IF;
2188:
2189: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_transaction_id);
2190: J := J +1 ;
2191:
2192: oe_debug_pub.add('l_transaction_id: ' || l_transaction_id,1);
2193: oe_debug_pub.add('J1: ' || J,1);

Line 2201: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);

2197:
2198: END LOOP;
2199:
2200: oe_debug_pub.add('Before Close ',1);
2201: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
2202:
2203:
2204: oe_debug_pub.add('Count: ' || Transactionids.COUNT,1);
2205:

Line 2392: l_cursor_id := DBMS_SQL.OPEN_CURSOR;

2388: oe_debug_pub.add('p_sold_to_org_id: ' || p_sold_to_org_id,2);
2389: oe_debug_pub.add('p_status_code: ' || p_status_code,2);
2390: oe_debug_pub.add('p_request_id: ' || p_request_id,2);
2391:
2392: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
2393:
2394:
2395: l_stmt := 'Select transaction_id from oe_processing_msgs Where 1 = 1';
2396:

Line 2453: DBMS_SQL.PARSE(l_cursor_id,l_stmt,DBMS_SQL.NATIVE);

2449: IF p_org_id IS NOT NULL THEN
2450: l_stmt := l_stmt ||' AND org_id = :org_id';
2451: END IF;
2452:
2453: DBMS_SQL.PARSE(l_cursor_id,l_stmt,DBMS_SQL.NATIVE);
2454:
2455:
2456: IF p_request_id IS NOT NULL THEN
2457: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':request_id',p_request_id);

Line 2457: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':request_id',p_request_id);

2453: DBMS_SQL.PARSE(l_cursor_id,l_stmt,DBMS_SQL.NATIVE);
2454:
2455:
2456: IF p_request_id IS NOT NULL THEN
2457: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':request_id',p_request_id);
2458: END IF;
2459: IF p_entity_code IS NOT NULL THEN
2460: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':entity_code',p_entity_code);
2461: END IF;

Line 2460: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':entity_code',p_entity_code);

2456: IF p_request_id IS NOT NULL THEN
2457: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':request_id',p_request_id);
2458: END IF;
2459: IF p_entity_code IS NOT NULL THEN
2460: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':entity_code',p_entity_code);
2461: END IF;
2462: IF p_entity_id IS NOT NULL THEN
2463: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':entity_id',p_entity_id);
2464: END IF;

Line 2463: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':entity_id',p_entity_id);

2459: IF p_entity_code IS NOT NULL THEN
2460: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':entity_code',p_entity_code);
2461: END IF;
2462: IF p_entity_id IS NOT NULL THEN
2463: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':entity_id',p_entity_id);
2464: END IF;
2465: IF p_header_id IS NOT NULL THEN
2466: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':header_id',p_header_id);
2467: END IF;

Line 2466: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':header_id',p_header_id);

2462: IF p_entity_id IS NOT NULL THEN
2463: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':entity_id',p_entity_id);
2464: END IF;
2465: IF p_header_id IS NOT NULL THEN
2466: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':header_id',p_header_id);
2467: END IF;
2468: IF p_line_id IS NOT NULL THEN
2469: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':line_id',p_line_id);
2470: END IF;

Line 2469: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':line_id',p_line_id);

2465: IF p_header_id IS NOT NULL THEN
2466: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':header_id',p_header_id);
2467: END IF;
2468: IF p_line_id IS NOT NULL THEN
2469: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':line_id',p_line_id);
2470: END IF;
2471: IF p_order_source_id IS NOT NULL THEN
2472: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_source_id',p_order_source_id);
2473: END IF;

Line 2472: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_source_id',p_order_source_id);

2468: IF p_line_id IS NOT NULL THEN
2469: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':line_id',p_line_id);
2470: END IF;
2471: IF p_order_source_id IS NOT NULL THEN
2472: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_source_id',p_order_source_id);
2473: END IF;
2474: IF p_orig_sys_document_ref IS NOT NULL THEN
2475: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':orig_sys_document_ref',p_orig_sys_document_ref);
2476: END IF;

Line 2475: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':orig_sys_document_ref',p_orig_sys_document_ref);

2471: IF p_order_source_id IS NOT NULL THEN
2472: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_source_id',p_order_source_id);
2473: END IF;
2474: IF p_orig_sys_document_ref IS NOT NULL THEN
2475: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':orig_sys_document_ref',p_orig_sys_document_ref);
2476: END IF;
2477: IF p_orig_sys_document_line_ref IS NOT NULL THEN
2478: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':orig_sys_document_line_ref',p_orig_sys_document_line_ref);
2479: END IF;

Line 2478: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':orig_sys_document_line_ref',p_orig_sys_document_line_ref);

2474: IF p_orig_sys_document_ref IS NOT NULL THEN
2475: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':orig_sys_document_ref',p_orig_sys_document_ref);
2476: END IF;
2477: IF p_orig_sys_document_line_ref IS NOT NULL THEN
2478: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':orig_sys_document_line_ref',p_orig_sys_document_line_ref);
2479: END IF;
2480: IF p_orig_sys_shipment_ref IS NOT NULL THEN
2481: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':orig_sys_shipment_ref',p_orig_sys_shipment_ref);
2482: END IF;

Line 2481: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':orig_sys_shipment_ref',p_orig_sys_shipment_ref);

2477: IF p_orig_sys_document_line_ref IS NOT NULL THEN
2478: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':orig_sys_document_line_ref',p_orig_sys_document_line_ref);
2479: END IF;
2480: IF p_orig_sys_shipment_ref IS NOT NULL THEN
2481: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':orig_sys_shipment_ref',p_orig_sys_shipment_ref);
2482: END IF;
2483: IF p_change_sequence IS NOT NULL THEN
2484: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':change_sequence',p_change_sequence);
2485: END IF;

Line 2484: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':change_sequence',p_change_sequence);

2480: IF p_orig_sys_shipment_ref IS NOT NULL THEN
2481: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':orig_sys_shipment_ref',p_orig_sys_shipment_ref);
2482: END IF;
2483: IF p_change_sequence IS NOT NULL THEN
2484: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':change_sequence',p_change_sequence);
2485: END IF;
2486: IF p_source_document_type_id IS NOT NULL THEN
2487: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':source_document_type_id',p_source_document_type_id);
2488: END IF;

Line 2487: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':source_document_type_id',p_source_document_type_id);

2483: IF p_change_sequence IS NOT NULL THEN
2484: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':change_sequence',p_change_sequence);
2485: END IF;
2486: IF p_source_document_type_id IS NOT NULL THEN
2487: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':source_document_type_id',p_source_document_type_id);
2488: END IF;
2489: IF p_source_document_id IS NOT NULL THEN
2490: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':source_document_id',p_source_document_id);
2491: END IF;

Line 2490: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':source_document_id',p_source_document_id);

2486: IF p_source_document_type_id IS NOT NULL THEN
2487: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':source_document_type_id',p_source_document_type_id);
2488: END IF;
2489: IF p_source_document_id IS NOT NULL THEN
2490: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':source_document_id',p_source_document_id);
2491: END IF;
2492: IF p_source_document_line_id IS NOT NULL THEN
2493: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':source_document_line_id',p_source_document_line_id);
2494: END IF;

Line 2493: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':source_document_line_id',p_source_document_line_id);

2489: IF p_source_document_id IS NOT NULL THEN
2490: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':source_document_id',p_source_document_id);
2491: END IF;
2492: IF p_source_document_line_id IS NOT NULL THEN
2493: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':source_document_line_id',p_source_document_line_id);
2494: END IF;
2495: IF p_attribute_code IS NOT NULL THEN
2496: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':attribute_code',p_attribute_code);
2497: END IF;

Line 2496: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':attribute_code',p_attribute_code);

2492: IF p_source_document_line_id IS NOT NULL THEN
2493: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':source_document_line_id',p_source_document_line_id);
2494: END IF;
2495: IF p_attribute_code IS NOT NULL THEN
2496: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':attribute_code',p_attribute_code);
2497: END IF;
2498: IF p_constraint_id IS NOT NULL THEN
2499: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':constraint_id',p_constraint_id);
2500: END IF;

Line 2499: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':constraint_id',p_constraint_id);

2495: IF p_attribute_code IS NOT NULL THEN
2496: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':attribute_code',p_attribute_code);
2497: END IF;
2498: IF p_constraint_id IS NOT NULL THEN
2499: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':constraint_id',p_constraint_id);
2500: END IF;
2501: IF p_process_activity IS NOT NULL THEN
2502: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':process_activity',p_process_activity);
2503: END IF;

Line 2502: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':process_activity',p_process_activity);

2498: IF p_constraint_id IS NOT NULL THEN
2499: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':constraint_id',p_constraint_id);
2500: END IF;
2501: IF p_process_activity IS NOT NULL THEN
2502: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':process_activity',p_process_activity);
2503: END IF;
2504: IF p_sold_to_org_id IS NOT NULL THEN
2505: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':sold_to_org_id',p_sold_to_org_id);
2506: END IF;

Line 2505: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':sold_to_org_id',p_sold_to_org_id);

2501: IF p_process_activity IS NOT NULL THEN
2502: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':process_activity',p_process_activity);
2503: END IF;
2504: IF p_sold_to_org_id IS NOT NULL THEN
2505: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':sold_to_org_id',p_sold_to_org_id);
2506: END IF;
2507: IF p_org_id IS NOT NULL THEN
2508: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':org_id',p_org_id);
2509: END IF;

Line 2508: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':org_id',p_org_id);

2504: IF p_sold_to_org_id IS NOT NULL THEN
2505: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':sold_to_org_id',p_sold_to_org_id);
2506: END IF;
2507: IF p_org_id IS NOT NULL THEN
2508: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':org_id',p_org_id);
2509: END IF;
2510:
2511:
2512: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,1,l_transaction_id);

Line 2512: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,1,l_transaction_id);

2508: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':org_id',p_org_id);
2509: END IF;
2510:
2511:
2512: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,1,l_transaction_id);
2513:
2514: l_retval := DBMS_SQL.EXECUTE(l_cursor_id);
2515:
2516: LOOP

Line 2514: l_retval := DBMS_SQL.EXECUTE(l_cursor_id);

2510:
2511:
2512: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,1,l_transaction_id);
2513:
2514: l_retval := DBMS_SQL.EXECUTE(l_cursor_id);
2515:
2516: LOOP
2517: IF DBMS_SQL.FETCH_ROWS(l_cursor_id) = 0 THEN
2518: EXIT;

Line 2517: IF DBMS_SQL.FETCH_ROWS(l_cursor_id) = 0 THEN

2513:
2514: l_retval := DBMS_SQL.EXECUTE(l_cursor_id);
2515:
2516: LOOP
2517: IF DBMS_SQL.FETCH_ROWS(l_cursor_id) = 0 THEN
2518: EXIT;
2519: END IF;
2520: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_transaction_id);
2521:

Line 2520: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_transaction_id);

2516: LOOP
2517: IF DBMS_SQL.FETCH_ROWS(l_cursor_id) = 0 THEN
2518: EXIT;
2519: END IF;
2520: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_transaction_id);
2521:
2522:
2523: Update oe_processing_msgs
2524: Set message_status_code = p_status_code

Line 2528: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);

2524: Set message_status_code = p_status_code
2525: Where transaction_id = l_transaction_id;
2526:
2527: END LOOP;
2528: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
2529: EXCEPTION
2530: WHEN OTHERS THEN
2531: IF l_debug_level > 0 THEN
2532: oe_debug_pub.add('Error in Procedure Update_status_code ' || sqlerrm);