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 1747: l_cursor_id := DBMS_SQL.OPEN_CURSOR;

1743: ,msg.created_by);
1744: */
1745:
1746:
1747: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
1748:
1749:
1750: IF p_order_type_id is null
1751: AND p_order_number_from is null

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

1834: END IF;
1835:
1836: OE_DEBUG_PUB.Add(substr(l_stmt,1,length(l_stmt)),1);
1837:
1838: DBMS_SQL.PARSE(l_cursor_id, l_stmt, DBMS_SQL.native);
1839:
1840: OE_DEBUG_PUB.Add('after parse',1);
1841: --5121760
1842: SELECT fnd_date.chardt_to_date(p_creation_date_from),

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

1843: fnd_date.chardt_to_date(p_creation_date_to)
1844: INTO l_creation_date_from,l_creation_date_to
1845: FROM DUAL;
1846: IF p_message_source_code IS NOT NULL THEN
1847: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':message_source_code',p_message_source_code);
1848: END IF;
1849:
1850: IF p_request_id_from IS NOT NULL THEN
1851: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':request_id_from',p_request_id_from);

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

1847: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':message_source_code',p_message_source_code);
1848: END IF;
1849:
1850: IF p_request_id_from IS NOT NULL THEN
1851: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':request_id_from',p_request_id_from);
1852: END IF;
1853:
1854: IF p_request_id_to IS NOT NULL THEN
1855: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':request_id_to',p_request_id_to);

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

1851: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':request_id_from',p_request_id_from);
1852: END IF;
1853:
1854: IF p_request_id_to IS NOT NULL THEN
1855: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':request_id_to',p_request_id_to);
1856: END IF;
1857: --5121760
1858: IF p_creation_date_from IS NOT NULL THEN
1859: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':creation_date_from',trunc(l_creation_date_from));

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

1855: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':request_id_to',p_request_id_to);
1856: END IF;
1857: --5121760
1858: IF p_creation_date_from IS NOT NULL THEN
1859: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':creation_date_from',trunc(l_creation_date_from));
1860: END IF;
1861: IF p_creation_date_to IS NOT NULL THEN
1862: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':creation_date_to',trunc(l_creation_date_to));
1863: END IF;

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

1858: IF p_creation_date_from IS NOT NULL THEN
1859: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':creation_date_from',trunc(l_creation_date_from));
1860: END IF;
1861: IF p_creation_date_to IS NOT NULL THEN
1862: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':creation_date_to',trunc(l_creation_date_to));
1863: END IF;
1864:
1865: IF p_program_id IS NOT NULL THEN
1866: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':program_id',p_program_id);

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

1862: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':creation_date_to',trunc(l_creation_date_to));
1863: END IF;
1864:
1865: IF p_program_id IS NOT NULL THEN
1866: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':program_id',p_program_id);
1867: END IF;
1868:
1869: IF p_attribute_code IS NOT NULL THEN
1870: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':attribute_code',p_attribute_code);

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

1866: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':program_id',p_program_id);
1867: END IF;
1868:
1869: IF p_attribute_code IS NOT NULL THEN
1870: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':attribute_code',p_attribute_code);
1871: END IF;
1872:
1873: IF p_created_by IS NOT NULL THEN
1874: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':created_by',p_created_by);

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

1870: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':attribute_code',p_attribute_code);
1871: END IF;
1872:
1873: IF p_created_by IS NOT NULL THEN
1874: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':created_by',p_created_by);
1875: END IF;
1876:
1877: IF p_order_number_from IS NOT NULL THEN
1878: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_number_from',p_order_number_from);

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

1874: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':created_by',p_created_by);
1875: END IF;
1876:
1877: IF p_order_number_from IS NOT NULL THEN
1878: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_number_from',p_order_number_from);
1879: END IF;
1880:
1881: IF p_order_number_to IS NOT NULL THEN
1882: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_number_to',p_order_number_to);

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

1878: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_number_from',p_order_number_from);
1879: END IF;
1880:
1881: IF p_order_number_to IS NOT NULL THEN
1882: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_number_to',p_order_number_to);
1883: END IF;
1884:
1885: IF p_order_type_id IS NOT NULL THEN
1886: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_type_id',p_order_type_id);

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

1882: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_number_to',p_order_number_to);
1883: END IF;
1884:
1885: IF p_order_type_id IS NOT NULL THEN
1886: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_type_id',p_order_type_id);
1887: END IF;
1888:
1889: IF p_organization_id IS NOT NULL THEN
1890: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':sold_to_org_id',p_organization_id);

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

1886: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_type_id',p_order_type_id);
1887: END IF;
1888:
1889: IF p_organization_id IS NOT NULL THEN
1890: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':sold_to_org_id',p_organization_id);
1891: END IF;
1892:
1893: IF p_process_activity_name IS NOT NULL THEN
1894: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':process_activity_name',p_process_activity_name);

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

1890: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':sold_to_org_id',p_organization_id);
1891: END IF;
1892:
1893: IF p_process_activity_name IS NOT NULL THEN
1894: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':process_activity_name',p_process_activity_name);
1895: END IF;
1896:
1897: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,1,l_transaction_id);
1898: oe_debug_pub.add('Before execute ',1);

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

1893: IF p_process_activity_name IS NOT NULL THEN
1894: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':process_activity_name',p_process_activity_name);
1895: END IF;
1896:
1897: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,1,l_transaction_id);
1898: oe_debug_pub.add('Before execute ',1);
1899: l_retval := DBMS_SQL.EXECUTE(l_cursor_id);
1900:
1901: LOOP

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

1895: END IF;
1896:
1897: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,1,l_transaction_id);
1898: oe_debug_pub.add('Before execute ',1);
1899: l_retval := DBMS_SQL.EXECUTE(l_cursor_id);
1900:
1901: LOOP
1902: oe_debug_pub.add('J: ' || J,1);
1903:

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

1900:
1901: LOOP
1902: oe_debug_pub.add('J: ' || J,1);
1903:
1904: IF DBMS_SQL.FETCH_ROWS(l_cursor_id) = 0 THEN
1905: EXIT;
1906: END IF;
1907:
1908: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_transaction_id);

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

1904: IF DBMS_SQL.FETCH_ROWS(l_cursor_id) = 0 THEN
1905: EXIT;
1906: END IF;
1907:
1908: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_transaction_id);
1909: J := J +1 ;
1910:
1911: oe_debug_pub.add('l_transaction_id: ' || l_transaction_id,1);
1912: oe_debug_pub.add('J1: ' || J,1);

Line 1920: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);

1916:
1917: END LOOP;
1918:
1919: oe_debug_pub.add('Before Close ',1);
1920: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
1921:
1922:
1923: oe_debug_pub.add('Count: ' || Transactionids.COUNT,1);
1924:

Line 2055: l_cursor_id := DBMS_SQL.OPEN_CURSOR;

2051: Transactionrowids.DELETE;
2052: commit;
2053: */
2054:
2055: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
2056:
2057:
2058:
2059: l_stmt := 'select transaction_id ' ||

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

2096: END IF;
2097:
2098: OE_DEBUG_PUB.Add(substr(l_stmt,1,length(l_stmt)),1);
2099:
2100: DBMS_SQL.PARSE(l_cursor_id, l_stmt, DBMS_SQL.native);
2101:
2102: OE_DEBUG_PUB.Add('after parse',1);
2103: IF p_order_source_id IS NOT NULL THEN
2104: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_source_id',p_order_source_id);

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

2100: DBMS_SQL.PARSE(l_cursor_id, l_stmt, DBMS_SQL.native);
2101:
2102: OE_DEBUG_PUB.Add('after parse',1);
2103: IF p_order_source_id IS NOT NULL THEN
2104: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_source_id',p_order_source_id);
2105: END IF;
2106:
2107: IF p_request_id IS NOT NULL THEN
2108: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':request_id',p_request_id);

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

2104: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_source_id',p_order_source_id);
2105: END IF;
2106:
2107: IF p_request_id IS NOT NULL THEN
2108: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':request_id',p_request_id);
2109: END IF;
2110:
2111: IF p_orig_sys_document_ref IS NOT NULL THEN
2112: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':orig_sys_document_ref',p_orig_sys_document_ref);

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

2108: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':request_id',p_request_id);
2109: END IF;
2110:
2111: IF p_orig_sys_document_ref IS NOT NULL THEN
2112: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':orig_sys_document_ref',p_orig_sys_document_ref);
2113: END IF;
2114:
2115: IF p_Orig_sys_document_line_ref IS NOT NULL THEN
2116: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':Orig_sys_document_line_ref',p_Orig_sys_document_line_ref);

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

2112: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':orig_sys_document_ref',p_orig_sys_document_ref);
2113: END IF;
2114:
2115: IF p_Orig_sys_document_line_ref IS NOT NULL THEN
2116: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':Orig_sys_document_line_ref',p_Orig_sys_document_line_ref);
2117: END IF;
2118:
2119: IF p_orig_sys_shipment_ref IS NOT NULL THEN
2120: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':orig_sys_shipment_ref',p_orig_sys_shipment_ref);

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

2116: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':Orig_sys_document_line_ref',p_Orig_sys_document_line_ref);
2117: END IF;
2118:
2119: IF p_orig_sys_shipment_ref IS NOT NULL THEN
2120: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':orig_sys_shipment_ref',p_orig_sys_shipment_ref);
2121: END IF;
2122:
2123: IF p_change_sequence IS NOT NULL THEN
2124: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':change_sequence',p_change_sequence);

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

2120: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':orig_sys_shipment_ref',p_orig_sys_shipment_ref);
2121: END IF;
2122:
2123: IF p_change_sequence IS NOT NULL THEN
2124: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':change_sequence',p_change_sequence);
2125: END IF;
2126:
2127: IF p_entity_code IS NOT NULL THEN
2128: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':entity_code',p_entity_code);

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

2124: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':change_sequence',p_change_sequence);
2125: END IF;
2126:
2127: IF p_entity_code IS NOT NULL THEN
2128: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':entity_code',p_entity_code);
2129: END IF;
2130:
2131: IF p_entity_ref IS NOT NULL THEN
2132: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':entity_ref',p_entity_ref);

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

2128: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':entity_code',p_entity_code);
2129: END IF;
2130:
2131: IF p_entity_ref IS NOT NULL THEN
2132: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':entity_ref',p_entity_ref);
2133: END IF;
2134:
2135: IF p_org_id IS NOT NULL THEN
2136: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':org_id',p_org_id);

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

2132: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':entity_ref',p_entity_ref);
2133: END IF;
2134:
2135: IF p_org_id IS NOT NULL THEN
2136: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':org_id',p_org_id);
2137: END IF;
2138:
2139: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,1,l_transaction_id);
2140: oe_debug_pub.add('Before execute ',1);

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

2135: IF p_org_id IS NOT NULL THEN
2136: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':org_id',p_org_id);
2137: END IF;
2138:
2139: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,1,l_transaction_id);
2140: oe_debug_pub.add('Before execute ',1);
2141: l_retval := DBMS_SQL.EXECUTE(l_cursor_id);
2142:
2143: LOOP

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

2137: END IF;
2138:
2139: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,1,l_transaction_id);
2140: oe_debug_pub.add('Before execute ',1);
2141: l_retval := DBMS_SQL.EXECUTE(l_cursor_id);
2142:
2143: LOOP
2144: oe_debug_pub.add('J: ' || J,1);
2145:

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

2142:
2143: LOOP
2144: oe_debug_pub.add('J: ' || J,1);
2145:
2146: IF DBMS_SQL.FETCH_ROWS(l_cursor_id) = 0 THEN
2147: EXIT;
2148: END IF;
2149:
2150: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_transaction_id);

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

2146: IF DBMS_SQL.FETCH_ROWS(l_cursor_id) = 0 THEN
2147: EXIT;
2148: END IF;
2149:
2150: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_transaction_id);
2151: J := J +1 ;
2152:
2153: oe_debug_pub.add('l_transaction_id: ' || l_transaction_id,1);
2154: oe_debug_pub.add('J1: ' || J,1);

Line 2162: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);

2158:
2159: END LOOP;
2160:
2161: oe_debug_pub.add('Before Close ',1);
2162: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
2163:
2164:
2165: oe_debug_pub.add('Count: ' || Transactionids.COUNT,1);
2166:

Line 2353: l_cursor_id := DBMS_SQL.OPEN_CURSOR;

2349: oe_debug_pub.add('p_sold_to_org_id: ' || p_sold_to_org_id,2);
2350: oe_debug_pub.add('p_status_code: ' || p_status_code,2);
2351: oe_debug_pub.add('p_request_id: ' || p_request_id,2);
2352:
2353: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
2354:
2355:
2356: l_stmt := 'Select transaction_id from oe_processing_msgs Where 1 = 1';
2357:

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

2410: IF p_org_id IS NOT NULL THEN
2411: l_stmt := l_stmt ||' AND org_id = :org_id';
2412: END IF;
2413:
2414: DBMS_SQL.PARSE(l_cursor_id,l_stmt,DBMS_SQL.NATIVE);
2415:
2416:
2417: IF p_request_id IS NOT NULL THEN
2418: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':request_id',p_request_id);

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

2414: DBMS_SQL.PARSE(l_cursor_id,l_stmt,DBMS_SQL.NATIVE);
2415:
2416:
2417: IF p_request_id IS NOT NULL THEN
2418: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':request_id',p_request_id);
2419: END IF;
2420: IF p_entity_code IS NOT NULL THEN
2421: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':entity_code',p_entity_code);
2422: END IF;

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

2417: IF p_request_id IS NOT NULL THEN
2418: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':request_id',p_request_id);
2419: END IF;
2420: IF p_entity_code IS NOT NULL THEN
2421: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':entity_code',p_entity_code);
2422: END IF;
2423: IF p_entity_id IS NOT NULL THEN
2424: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':entity_id',p_entity_id);
2425: END IF;

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

2420: IF p_entity_code IS NOT NULL THEN
2421: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':entity_code',p_entity_code);
2422: END IF;
2423: IF p_entity_id IS NOT NULL THEN
2424: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':entity_id',p_entity_id);
2425: END IF;
2426: IF p_header_id IS NOT NULL THEN
2427: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':header_id',p_header_id);
2428: END IF;

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

2423: IF p_entity_id IS NOT NULL THEN
2424: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':entity_id',p_entity_id);
2425: END IF;
2426: IF p_header_id IS NOT NULL THEN
2427: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':header_id',p_header_id);
2428: END IF;
2429: IF p_line_id IS NOT NULL THEN
2430: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':line_id',p_line_id);
2431: END IF;

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

2426: IF p_header_id IS NOT NULL THEN
2427: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':header_id',p_header_id);
2428: END IF;
2429: IF p_line_id IS NOT NULL THEN
2430: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':line_id',p_line_id);
2431: END IF;
2432: IF p_order_source_id IS NOT NULL THEN
2433: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_source_id',p_order_source_id);
2434: END IF;

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

2429: IF p_line_id IS NOT NULL THEN
2430: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':line_id',p_line_id);
2431: END IF;
2432: IF p_order_source_id IS NOT NULL THEN
2433: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_source_id',p_order_source_id);
2434: END IF;
2435: IF p_orig_sys_document_ref IS NOT NULL THEN
2436: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':orig_sys_document_ref',p_orig_sys_document_ref);
2437: END IF;

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

2432: IF p_order_source_id IS NOT NULL THEN
2433: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_source_id',p_order_source_id);
2434: END IF;
2435: IF p_orig_sys_document_ref IS NOT NULL THEN
2436: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':orig_sys_document_ref',p_orig_sys_document_ref);
2437: END IF;
2438: IF p_orig_sys_document_line_ref IS NOT NULL THEN
2439: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':orig_sys_document_line_ref',p_orig_sys_document_line_ref);
2440: END IF;

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

2435: IF p_orig_sys_document_ref IS NOT NULL THEN
2436: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':orig_sys_document_ref',p_orig_sys_document_ref);
2437: END IF;
2438: IF p_orig_sys_document_line_ref IS NOT NULL THEN
2439: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':orig_sys_document_line_ref',p_orig_sys_document_line_ref);
2440: END IF;
2441: IF p_orig_sys_shipment_ref IS NOT NULL THEN
2442: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':orig_sys_shipment_ref',p_orig_sys_shipment_ref);
2443: END IF;

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

2438: IF p_orig_sys_document_line_ref IS NOT NULL THEN
2439: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':orig_sys_document_line_ref',p_orig_sys_document_line_ref);
2440: END IF;
2441: IF p_orig_sys_shipment_ref IS NOT NULL THEN
2442: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':orig_sys_shipment_ref',p_orig_sys_shipment_ref);
2443: END IF;
2444: IF p_change_sequence IS NOT NULL THEN
2445: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':change_sequence',p_change_sequence);
2446: END IF;

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

2441: IF p_orig_sys_shipment_ref IS NOT NULL THEN
2442: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':orig_sys_shipment_ref',p_orig_sys_shipment_ref);
2443: END IF;
2444: IF p_change_sequence IS NOT NULL THEN
2445: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':change_sequence',p_change_sequence);
2446: END IF;
2447: IF p_source_document_type_id IS NOT NULL THEN
2448: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':source_document_type_id',p_source_document_type_id);
2449: END IF;

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

2444: IF p_change_sequence IS NOT NULL THEN
2445: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':change_sequence',p_change_sequence);
2446: END IF;
2447: IF p_source_document_type_id IS NOT NULL THEN
2448: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':source_document_type_id',p_source_document_type_id);
2449: END IF;
2450: IF p_source_document_id IS NOT NULL THEN
2451: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':source_document_id',p_source_document_id);
2452: END IF;

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

2447: IF p_source_document_type_id IS NOT NULL THEN
2448: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':source_document_type_id',p_source_document_type_id);
2449: END IF;
2450: IF p_source_document_id IS NOT NULL THEN
2451: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':source_document_id',p_source_document_id);
2452: END IF;
2453: IF p_source_document_line_id IS NOT NULL THEN
2454: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':source_document_line_id',p_source_document_line_id);
2455: END IF;

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

2450: IF p_source_document_id IS NOT NULL THEN
2451: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':source_document_id',p_source_document_id);
2452: END IF;
2453: IF p_source_document_line_id IS NOT NULL THEN
2454: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':source_document_line_id',p_source_document_line_id);
2455: END IF;
2456: IF p_attribute_code IS NOT NULL THEN
2457: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':attribute_code',p_attribute_code);
2458: END IF;

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

2453: IF p_source_document_line_id IS NOT NULL THEN
2454: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':source_document_line_id',p_source_document_line_id);
2455: END IF;
2456: IF p_attribute_code IS NOT NULL THEN
2457: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':attribute_code',p_attribute_code);
2458: END IF;
2459: IF p_constraint_id IS NOT NULL THEN
2460: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':constraint_id',p_constraint_id);
2461: END IF;

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

2456: IF p_attribute_code IS NOT NULL THEN
2457: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':attribute_code',p_attribute_code);
2458: END IF;
2459: IF p_constraint_id IS NOT NULL THEN
2460: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':constraint_id',p_constraint_id);
2461: END IF;
2462: IF p_process_activity IS NOT NULL THEN
2463: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':process_activity',p_process_activity);
2464: END IF;

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

2459: IF p_constraint_id IS NOT NULL THEN
2460: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':constraint_id',p_constraint_id);
2461: END IF;
2462: IF p_process_activity IS NOT NULL THEN
2463: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':process_activity',p_process_activity);
2464: END IF;
2465: IF p_sold_to_org_id IS NOT NULL THEN
2466: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':sold_to_org_id',p_sold_to_org_id);
2467: END IF;

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

2462: IF p_process_activity IS NOT NULL THEN
2463: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':process_activity',p_process_activity);
2464: END IF;
2465: IF p_sold_to_org_id IS NOT NULL THEN
2466: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':sold_to_org_id',p_sold_to_org_id);
2467: END IF;
2468: IF p_org_id IS NOT NULL THEN
2469: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':org_id',p_org_id);
2470: END IF;

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

2465: IF p_sold_to_org_id IS NOT NULL THEN
2466: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':sold_to_org_id',p_sold_to_org_id);
2467: END IF;
2468: IF p_org_id IS NOT NULL THEN
2469: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':org_id',p_org_id);
2470: END IF;
2471:
2472:
2473: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,1,l_transaction_id);

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

2469: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':org_id',p_org_id);
2470: END IF;
2471:
2472:
2473: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,1,l_transaction_id);
2474:
2475: l_retval := DBMS_SQL.EXECUTE(l_cursor_id);
2476:
2477: LOOP

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

2471:
2472:
2473: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,1,l_transaction_id);
2474:
2475: l_retval := DBMS_SQL.EXECUTE(l_cursor_id);
2476:
2477: LOOP
2478: IF DBMS_SQL.FETCH_ROWS(l_cursor_id) = 0 THEN
2479: EXIT;

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

2474:
2475: l_retval := DBMS_SQL.EXECUTE(l_cursor_id);
2476:
2477: LOOP
2478: IF DBMS_SQL.FETCH_ROWS(l_cursor_id) = 0 THEN
2479: EXIT;
2480: END IF;
2481: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_transaction_id);
2482:

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

2477: LOOP
2478: IF DBMS_SQL.FETCH_ROWS(l_cursor_id) = 0 THEN
2479: EXIT;
2480: END IF;
2481: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_transaction_id);
2482:
2483:
2484: Update oe_processing_msgs
2485: Set message_status_code = p_status_code

Line 2489: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);

2485: Set message_status_code = p_status_code
2486: Where transaction_id = l_transaction_id;
2487:
2488: END LOOP;
2489: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
2490: EXCEPTION
2491: WHEN OTHERS THEN
2492: IF l_debug_level > 0 THEN
2493: oe_debug_pub.add('Error in Procedure Update_status_code ' || sqlerrm);