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.PO_PDOI_MAINPROC_PVT dependencies on PO_PDOI_UTL

Line 152: PO_PDOI_UTL.reject_unprocessed_intf

148: PO_LOG.stmt(d_module, d_position, 'Unprocessed records will be removed for header ',
149: PO_PDOI_PARAMS.g_request.interface_header_id);
150: END IF;
151:
152: PO_PDOI_UTL.reject_unprocessed_intf
153: (
154: p_intf_header_id => PO_PDOI_PARAMS.g_request.interface_header_id
155: );
156: END IF;

Line 316: PO_PDOI_UTL.reject_headers_intf

312: l_count := l_count + 1;
313: l_rej_intf_header_id_tbl(l_count) := l_headers.intf_header_id_tbl(i);
314: END IF;
315: END LOOP;
316: PO_PDOI_UTL.reject_headers_intf
317: (
318: p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_HEADER_ID,
319: p_id_tbl => l_rej_intf_header_id_tbl,
320: p_cascade => FND_API.g_TRUE

Line 327: PO_PDOI_UTL.commit_work;

323:
324: d_position := 70;
325:
326: -- conditional commit
327: PO_PDOI_UTL.commit_work;
328:
329: -- set maximal intf_header_id read so far(used in next batch read)
330: l_max_intf_header_id := l_headers.intf_header_id_tbl(l_headers.rec_count);
331:

Line 347: PO_PDOI_UTL.commit_work;

343: p_procedure_name => d_api_name || '.' || d_position
344: );
345:
346: -- commit changes
347: PO_PDOI_UTL.commit_work;
348:
349: IF (l_headers_csr%ISOPEN) THEN
350: CLOSE l_headers_csr;
351: PO_PDOI_HEADER_PROCESS_PVT.open_headers

Line 866: PO_PDOI_UTL.reject_lines_intf

862: l_rej_intf_line_id_tbl.EXTEND;
863: l_rej_intf_line_id_tbl(l_rej_intf_line_id_tbl.COUNT) := l_lines.intf_line_id_tbl(i);
864: END IF;
865: END LOOP;
866: PO_PDOI_UTL.reject_lines_intf
867: (
868: p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_LINE_ID,
869: p_id_tbl => l_rej_intf_line_id_tbl,
870: p_cascade => FND_API.g_TRUE

Line 877: PO_PDOI_UTL.commit_work;

873:
874: d_position := 110;
875:
876: -- commit changes
877: PO_PDOI_UTL.commit_work;
878:
879: -- set the maximal interface_line_id processed in this batch
880: -- bug#13367649- move line to after fetch as l_lines.rec_count
881: -- now is number of records to create, not the original number

Line 908: PO_PDOI_UTL.commit_work;

904: p_procedure_name => d_api_name || '.' || d_position
905: );
906:
907: -- commit changes
908: PO_PDOI_UTL.commit_work;
909:
910: IF (l_lines_csr%ISOPEN) THEN
911: CLOSE l_lines_csr;
912: PO_PDOI_LINE_PROCESS_PVT.open_lines

Line 946: PO_PDOI_UTL.reject_lines_intf

942: AND NVL(intf_line2.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
943: = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED
944: AND NVL(intf_line2.price_break_flag, 'N') = 'N');
945: d_position := 150;
946: PO_PDOI_UTL.reject_lines_intf
947: (
948: p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_LINE_ID,
949: p_id_tbl => l_rej_intf_line_id_tbl,
950: p_cascade => FND_API.g_TRUE

Line 1157: PO_PDOI_UTL.generate_ordered_num_list

1153:
1154: d_position := 50;
1155:
1156: -- setup table to track rows that have not been processed
1157: PO_PDOI_UTL.generate_ordered_num_list
1158: (
1159: p_size => l_lines.rec_count,
1160: x_num_list => l_processing_row_tbl
1161: );

Line 1228: PO_PDOI_UTL.commit_work;

1224: x_lines => l_update_lines
1225: );
1226: END LOOP;
1227:
1228: PO_PDOI_UTL.commit_work;
1229:
1230: -- set the maximal interface_line_id processed in this batch
1231: l_max_intf_line_id := l_lines.intf_line_id_tbl(l_lines.rec_count);
1232:

Line 1248: PO_PDOI_UTL.commit_work;

1244: p_procedure_name => d_api_name || '.' || d_position
1245: );
1246:
1247: -- commit changes
1248: PO_PDOI_UTL.commit_work;
1249:
1250: IF (l_lines_csr%ISOPEN) THEN
1251: CLOSE l_lines_csr;
1252: PO_PDOI_LINE_PROCESS_PVT.open_lines

Line 1294: PO_PDOI_UTL.reject_lines_intf

1290: = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED;
1291:
1292: d_position := 130;
1293:
1294: PO_PDOI_UTL.reject_lines_intf
1295: (
1296: p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_LINE_ID,
1297: p_id_tbl => l_rej_intf_line_id_tbl,
1298: p_cascade => FND_API.g_TRUE

Line 1482: PO_PDOI_UTL.reject_lines_intf

1478: l_count := l_count + 1;
1479: l_rej_intf_line_id_tbl(l_count) := x_lines.intf_line_id_tbl(i);
1480: END IF;
1481: END LOOP;
1482: PO_PDOI_UTL.reject_lines_intf
1483: (
1484: p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_LINE_ID,
1485: p_id_tbl => l_rej_intf_line_id_tbl,
1486: p_cascade => FND_API.g_TRUE

Line 1627: PO_PDOI_UTL.reject_lines_intf

1623: l_count := l_count + 1;
1624: l_rej_intf_line_id_tbl(l_count) := x_lines.intf_line_id_tbl(i);
1625: END IF;
1626: END LOOP;
1627: PO_PDOI_UTL.reject_lines_intf
1628: (
1629: p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_LINE_ID,
1630: p_id_tbl => l_rej_intf_line_id_tbl,
1631: p_cascade => FND_API.g_TRUE

Line 1873: PO_PDOI_UTL.reject_line_locations_intf

1869: PO_LOG.stmt(d_module, d_position, 'to-be-rejected locs',
1870: l_rej_intf_line_loc_id_tbl);
1871: END IF;
1872:
1873: PO_PDOI_UTL.reject_line_locations_intf
1874: (
1875: p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_LINE_LOCATION_ID,
1876: p_id_tbl => l_rej_intf_line_loc_id_tbl,
1877: p_cascade => FND_API.g_TRUE

Line 1897: PO_PDOI_UTL.commit_work;

1893: END IF;
1894: END LOOP;
1895:
1896: -- commit
1897: PO_PDOI_UTL.commit_work;
1898:
1899: IF (l_line_locs.rec_count < PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE) THEN
1900: EXIT;
1901: END IF;

Line 1916: PO_PDOI_UTL.commit_work;

1912: p_procedure_name => d_api_name || '.' || d_position
1913: );
1914:
1915: -- commit changes
1916: PO_PDOI_UTL.commit_work;
1917:
1918: IF (l_line_locs_csr%ISOPEN) THEN
1919: CLOSE l_line_locs_csr;
1920: PO_PDOI_LINE_LOC_PROCESS_PVT.open_line_locs

Line 2131: PO_PDOI_UTL.reject_distributions_intf

2127: END IF;
2128:
2129: d_position := 90;
2130:
2131: PO_PDOI_UTL.reject_distributions_intf
2132: (
2133: p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_DISTRIBUTION_ID,
2134: p_id_tbl => l_rej_intf_dist_id_tbl
2135: );

Line 2149: PO_PDOI_UTL.commit_work;

2145: AND l_dists.error_flag_tbl(i) = FND_API.g_FALSE;
2146:
2147: d_position := 110;
2148:
2149: PO_PDOI_UTL.commit_work;
2150:
2151: IF (l_dists.rec_count < PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE) THEN
2152: EXIT;
2153: END IF;

Line 2168: PO_PDOI_UTL.commit_work;

2164: p_procedure_name => d_api_name || '.' || d_position
2165: );
2166:
2167: -- commit changes
2168: PO_PDOI_UTL.commit_work;
2169:
2170: IF (l_dists_csr%ISOPEN) THEN
2171: CLOSE l_dists_csr;
2172: PO_PDOI_DIST_PROCESS_PVT.open_dists

Line 2353: PO_PDOI_UTL.reject_price_diff_intf

2349: PO_LOG.stmt(d_module, d_position, 'to-be-rejected price diffs',
2350: l_rej_intf_price_diff_id_tbl);
2351: END IF;
2352:
2353: PO_PDOI_UTL.reject_price_diff_intf
2354: (
2355: p_id_param_type => PO_PDOI_CONSTANTS.g_PRICE_DIFF_INTERFACE_ID,
2356: p_id_tbl => l_rej_intf_price_diff_id_tbl
2357: );

Line 2369: PO_PDOI_UTL.commit_work;

2365: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_ACCEPTED
2366: WHERE price_diff_interface_id = l_price_diffs.intf_price_diff_id_tbl(i)
2367: AND l_price_diffs.error_flag_tbl(i) = FND_API.g_FALSE;
2368:
2369: PO_PDOI_UTL.commit_work;
2370:
2371: IF (l_price_diffs.rec_count < PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE) THEN
2372: EXIT;
2373: END IF;

Line 2388: PO_PDOI_UTL.commit_work;

2384: p_procedure_name => d_api_name || '.' || d_position
2385: );
2386:
2387: -- commit changes
2388: PO_PDOI_UTL.commit_work;
2389:
2390: IF (l_price_diffs_csr%ISOPEN) THEN
2391: CLOSE l_price_diffs_csr;
2392: PO_PDOI_PRICE_DIFF_PROCESS_PVT.open_price_diffs

Line 2599: PO_PDOI_UTL.generate_ordered_num_list

2595: -- po_line_id, the record will be processed
2596: -- in different groups
2597:
2598: -- first setup table to track rows that have not been processed
2599: PO_PDOI_UTL.generate_ordered_num_list
2600: (
2601: p_size => l_attr_values.rec_count,
2602: x_num_list => l_processing_row_tbl
2603: );

Line 2655: PO_PDOI_UTL.commit_work;

2651: d_position := 55;
2652: gather_stats('PO_ATTRIBUTE_VALUES_DRAFT',d_api_name,d_position);
2653: END IF;
2654: --Bug13343886
2655: PO_PDOI_UTL.commit_work;
2656:
2657: IF (l_attr_values.rec_count < PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE) THEN
2658: EXIT;
2659: END IF;

Line 2674: PO_PDOI_UTL.commit_work;

2670: p_procedure_name => d_api_name || '.' || d_position
2671: );
2672:
2673: -- commit changes
2674: PO_PDOI_UTL.commit_work;
2675:
2676: IF (l_attr_values_csr%ISOPEN) THEN
2677: CLOSE l_attr_values_csr;
2678: PO_PDOI_ATTR_PROCESS_PVT.open_attr_values

Line 2796: PO_PDOI_UTL.generate_ordered_num_list

2792: -- po_line_id and language, the record will be processed
2793: -- in different groups
2794:
2795: -- first setup table to track rows that have not been processed
2796: PO_PDOI_UTL.generate_ordered_num_list
2797: (
2798: p_size => l_attr_values_tlp.rec_count,
2799: x_num_list => l_processing_row_tbl
2800: );

Line 2853: PO_PDOI_UTL.commit_work;

2849: gather_stats('PO_ATTRIBUTE_VALUES_TLP_DRAFT',d_api_name,d_position);
2850: END IF;
2851: --Bug13343886
2852:
2853: PO_PDOI_UTL.commit_work;
2854:
2855: IF (l_attr_values_tlp.rec_count < PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE) THEN
2856: EXIT;
2857: END IF;

Line 2872: PO_PDOI_UTL.commit_work;

2868: p_procedure_name => d_api_name || '.' || d_position
2869: );
2870:
2871: -- commit changes
2872: PO_PDOI_UTL.commit_work;
2873:
2874: IF (l_attr_values_tlp_csr%ISOPEN) THEN
2875: CLOSE l_attr_values_tlp_csr;
2876: PO_PDOI_ATTR_PROCESS_PVT.open_attr_values_tlp

Line 3093: PO_PDOI_UTL.reject_lines_intf

3089: l_rej_intf_line_id_tbl.EXTEND;
3090: l_rej_intf_line_id_tbl(l_rej_intf_line_id_tbl.COUNT) := l_lines.intf_line_id_tbl(i);
3091: END IF;
3092: END LOOP;
3093: PO_PDOI_UTL.reject_lines_intf
3094: (
3095: p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_LINE_ID,
3096: p_id_tbl => l_rej_intf_line_id_tbl,
3097: p_cascade => FND_API.g_TRUE

Line 3116: PO_PDOI_UTL.commit_work;

3112: p_procedure_name => d_api_name || '.' || d_position
3113: );
3114:
3115: -- commit changes
3116: PO_PDOI_UTL.commit_work;
3117:
3118: IF (l_lines_csr%ISOPEN) THEN
3119: CLOSE l_lines_csr;
3120: PO_PDOI_LINE_PROCESS_PVT.open_lines