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_DIST_PROCESS_PVT dependencies on PO_DISTRIBUTIONS_INTERFACE

Line 229: SELECT /+ INDEX (intf_dists PO_DISTRIBUTIONS_INTERFACE_N1) /

225: PO_LOG.proc_begin(d_module, 'p_max_intf_dist_id', p_max_intf_dist_id);
226: END IF;
227:
228: OPEN x_dists_csr FOR
229: SELECT /*+ INDEX (intf_dists PO_DISTRIBUTIONS_INTERFACE_N1) */
230: intf_dists.interface_distribution_id,
231: intf_dists.interface_header_id,
232: intf_dists.interface_line_id,
233: intf_dists.interface_line_location_id,

Line 419: FROM po_distributions_interface intf_dists,

415: NULL, -- gms_txn_required_flag
416: NULL, -- tax_attribute_update_code
417: NULL, -- ship_to_ou_coa_id_tbl
418: NULL -- award_set_id (bug5201306)
419: FROM po_distributions_interface intf_dists,
420: po_line_locations_interface intf_locs,
421: po_headers_interface intf_headers,
422: po_line_locations_draft_all draft_locs,
423: po_lines_draft_all draft_lines,

Line 1076: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',

1072: p_interface_line_id => x_dists.intf_line_id_tbl(i),
1073: p_interface_line_location_id => x_dists.intf_line_loc_id_tbl(i),
1074: p_interface_distribution_id => x_dists.intf_dist_id_tbl(i),
1075: p_error_message_name => 'PO_PDOI_GMS_ERROR',
1076: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',
1077: p_column_name => 'AWARD_NUMBER',
1078: p_column_value => x_dists.award_num_tbl(i),
1079: p_error_message => l_msg_data
1080: );

Line 1125: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',

1121: p_interface_line_id => x_dists.intf_line_id_tbl(i),
1122: p_interface_line_location_id => x_dists.intf_line_loc_id_tbl(i),
1123: p_interface_distribution_id => x_dists.intf_dist_id_tbl(i),
1124: p_error_message_name => 'PO_PDOI_INVALID_DEL_LOCATION',
1125: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',
1126: p_column_name => 'DELIVER_TO_LOCATION',
1127: p_column_value => x_dists.deliver_to_loc_tbl(i),
1128: p_token1_name => 'DELIVER_TO_LOCATION',
1129: p_token1_value => x_dists.deliver_to_loc_tbl(i)

Line 1151: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',

1147: p_interface_line_id => x_dists.intf_line_id_tbl(i),
1148: p_interface_line_location_id => x_dists.intf_line_loc_id_tbl(i),
1149: p_interface_distribution_id => x_dists.intf_dist_id_tbl(i),
1150: p_error_message_name => 'PO_PDOI_INVALID_DEL_PERSON',
1151: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',
1152: p_column_name => 'DELIVER_TO_PERSON',
1153: p_column_value => x_dists.deliver_to_person_name_tbl(i),
1154: p_token1_name => 'DELIVER_TO_PERSON',
1155: p_token1_value => x_dists.deliver_to_person_name_tbl(i)

Line 1177: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',

1173: p_interface_line_id => x_dists.intf_line_id_tbl(i),
1174: p_interface_line_location_id => x_dists.intf_line_loc_id_tbl(i),
1175: p_interface_distribution_id => x_dists.intf_dist_id_tbl(i),
1176: p_error_message_name => 'PO_PDOI_INVALID_DEST_TYPE',
1177: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',
1178: p_column_name => 'DESTINATION_TYPE',
1179: p_column_value => x_dists.dest_type_tbl(i),
1180: p_token1_name => 'DESTINATION_TYPE',
1181: p_token1_value => x_dists.dest_type_tbl(i)

Line 1203: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',

1199: p_interface_line_id => x_dists.intf_line_id_tbl(i),
1200: p_interface_line_location_id => x_dists.intf_line_loc_id_tbl(i),
1201: p_interface_distribution_id => x_dists.intf_dist_id_tbl(i),
1202: p_error_message_name => 'PO_PDOI_INVALID_DEST_ORG',
1203: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',
1204: p_column_name => 'DESTINATION_ORGANIZATION',
1205: p_column_value => x_dists.dest_org_tbl(i),
1206: p_token1_name => 'DESTINATION_ORGANIZATION',
1207: p_token1_value => x_dists.dest_org_tbl(i)

Line 1231: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',

1227: p_interface_line_id => x_dists.intf_line_id_tbl(i),
1228: p_interface_line_location_id => x_dists.intf_line_loc_id_tbl(i),
1229: p_interface_distribution_id => x_dists.intf_dist_id_tbl(i),
1230: p_error_message_name => 'PO_PDOI_INVALID_WIP_ENTITY',
1231: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',
1232: p_column_name => 'WIP_ENTITY',
1233: p_column_value => x_dists.wip_entity_tbl(i),
1234: p_token1_name => 'WIP_ENTITY',
1235: p_token1_value => x_dists.wip_entity_tbl(i)

Line 1257: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',

1253: p_interface_line_id => x_dists.intf_line_id_tbl(i),
1254: p_interface_line_location_id => x_dists.intf_line_loc_id_tbl(i),
1255: p_interface_distribution_id => x_dists.intf_dist_id_tbl(i),
1256: p_error_message_name => 'PO_PDOI_INVALID_WIP_LINE',
1257: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',
1258: p_column_name => 'WIP_LINE_CODE',
1259: p_column_value => x_dists.wip_line_code_tbl(i),
1260: p_token1_name => 'WIP_LINE_CODE',
1261: p_token1_value => x_dists.wip_line_code_tbl(i)

Line 1284: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',

1280: p_interface_line_id => x_dists.intf_line_id_tbl(i),
1281: p_interface_line_location_id => x_dists.intf_line_loc_id_tbl(i),
1282: p_interface_distribution_id => x_dists.intf_dist_id_tbl(i),
1283: p_error_message_name => 'PO_PDOI_INVALID_BOM_RESOURCE',
1284: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',
1285: p_column_name => 'BOM_RESOURCE_CODE',
1286: p_column_value => x_dists.bom_resource_code_tbl(i),
1287: p_token1_name => 'BOM_RESOURCE_CODE',
1288: p_token1_value => x_dists.bom_resource_code_tbl(i)

Line 1309: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',

1305: p_interface_line_id => x_dists.intf_line_id_tbl(i),
1306: p_interface_line_location_id => x_dists.intf_line_loc_id_tbl(i),
1307: p_interface_distribution_id => x_dists.intf_dist_id_tbl(i),
1308: p_error_message_name => 'PO_PDOI_INVALID_DEST_ORG',
1309: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',
1310: p_column_name => 'DESTINATION_ORGANIZATION',
1311: p_column_value => x_dists.dest_org_tbl(i),
1312: p_token1_name => 'DESTINATION_ORGANIZATION',
1313: p_token1_value => x_dists.dest_org_tbl(i)

Line 1342: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',

1338: p_interface_line_id => x_dists.intf_line_id_tbl(i),
1339: p_interface_line_location_id => x_dists.intf_line_loc_id_tbl(i),
1340: p_interface_distribution_id => x_dists.intf_dist_id_tbl(i),
1341: p_error_message_name => 'PO_PDOI_INVALID_PROJECT',
1342: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',
1343: p_column_name => 'PROJECT',
1344: p_column_value => x_dists.project_tbl(i),
1345: p_token1_name => 'PROJECT',
1346: p_token1_value => x_dists.project_tbl(i)

Line 1369: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',

1365: p_interface_line_id => x_dists.intf_line_id_tbl(i),
1366: p_interface_line_location_id => x_dists.intf_line_loc_id_tbl(i),
1367: p_interface_distribution_id => x_dists.intf_dist_id_tbl(i),
1368: p_error_message_name => 'PO_PDOI_INVALID_TASK',
1369: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',
1370: p_column_name => 'TASK',
1371: p_column_value => x_dists.task_tbl(i),
1372: p_token1_name => 'TASK',
1373: p_token1_value => x_dists.task_tbl(i)

Line 1396: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',

1392: p_interface_line_id => x_dists.intf_line_id_tbl(i),
1393: p_interface_line_location_id => x_dists.intf_line_loc_id_tbl(i),
1394: p_interface_distribution_id => x_dists.intf_dist_id_tbl(i),
1395: p_error_message_name => 'PO_PDOI_INVALID_EXPEND_TYPE',
1396: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',
1397: p_column_name => 'EXPENDITURE',
1398: p_column_value => x_dists.expenditure_tbl(i),
1399: p_token1_name => 'EXPENDITURE',
1400: p_token1_value => x_dists.expenditure_tbl(i)

Line 1423: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',

1419: p_interface_line_id => x_dists.intf_line_id_tbl(i),
1420: p_interface_line_location_id => x_dists.intf_line_loc_id_tbl(i),
1421: p_interface_distribution_id => x_dists.intf_dist_id_tbl(i),
1422: p_error_message_name => 'PO_PDOI_INVALID_EXPEND_ORG',
1423: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',
1424: p_column_name => 'EXPENDITURE_ORGANIZATION',
1425: p_column_value => x_dists.expenditure_org_tbl(i),
1426: p_token1_name => 'EXPENDITURE_ORGANIZATION',
1427: p_token1_value => x_dists.expenditure_org_tbl(i)

Line 1448: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',

1444: p_interface_line_id => x_dists.intf_line_id_tbl(i),
1445: p_interface_line_location_id => x_dists.intf_line_loc_id_tbl(i),
1446: p_interface_distribution_id => x_dists.intf_dist_id_tbl(i),
1447: p_error_message_name => 'PO_PDOI_INVALID_EXPEND_DATE',
1448: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',
1449: p_column_name => 'EXPENDITURE',
1450: p_column_value => x_dists.expenditure_tbl(i),
1451: p_token1_name => 'EXPENDITURE',
1452: p_token1_value => x_dists.expenditure_tbl(i)

Line 1716: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',

1712: p_interface_line_id => x_dists.intf_line_id_tbl(i),
1713: p_interface_line_location_id => x_dists.intf_line_loc_id_tbl(i),
1714: p_interface_distribution_id => x_dists.intf_dist_id_tbl(i),
1715: p_error_message_name => 'PO_PDOI_GMS_ERROR',
1716: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',
1717: p_column_name => 'AWARD_NUMBER',
1718: p_column_value => x_dists.award_num_tbl(i),
1719: p_error_message => l_msg_data
1720: );

Line 1764: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',

1760: p_interface_line_id => x_dists.intf_line_id_tbl(i),
1761: p_interface_line_location_id => x_dists.intf_line_loc_id_tbl(i),
1762: p_interface_distribution_id => x_dists.intf_dist_id_tbl(i),
1763: p_error_message_name => 'PO_PDOI_GMS_ERROR',
1764: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',
1765: p_column_name => 'AWARD_NUMBER',
1766: p_column_value => x_dists.award_num_tbl(i),
1767: p_error_message => l_msg_data
1768: );

Line 1981: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',

1977: p_interface_line_id => x_dists.intf_line_id_tbl(i),
1978: p_interface_line_location_id => x_dists.intf_line_loc_id_tbl(i),
1979: p_interface_distribution_id => x_dists.intf_dist_id_tbl(i),
1980: p_error_message_name => 'PO_PDOI_CHARGE_FAILED',
1981: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',
1982: p_column_name => 'CHARGE_ACCOUNT_ID',
1983: p_column_value => x_dists.charge_account_id_tbl(i)
1984: );
1985:

Line 1996: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',

1992: p_interface_line_id => x_dists.intf_line_id_tbl(i),
1993: p_interface_line_location_id => x_dists.intf_line_loc_id_tbl(i),
1994: p_interface_distribution_id => x_dists.intf_dist_id_tbl(i),
1995: p_error_message_name => 'PO_PDOI_BUDGET_FAILED',
1996: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',
1997: p_column_name => 'BUDGET_ACCOUNT_ID',
1998: p_column_value => x_dists.budget_account_id_tbl(i)
1999: );
2000:

Line 2010: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',

2006: p_interface_line_id => x_dists.intf_line_id_tbl(i),
2007: p_interface_line_location_id => x_dists.intf_line_loc_id_tbl(i),
2008: p_interface_distribution_id => x_dists.intf_dist_id_tbl(i),
2009: p_error_message_name => 'PO_PDOI_ACCRUAL_FAILED',
2010: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',
2011: p_column_name => 'ACCRUAL_ACCOUNT_ID',
2012: p_column_value => x_dists.accrual_account_id_tbl(i)
2013: );
2014:

Line 2024: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',

2020: p_interface_line_id => x_dists.intf_line_id_tbl(i),
2021: p_interface_line_location_id => x_dists.intf_line_loc_id_tbl(i),
2022: p_interface_distribution_id => x_dists.intf_dist_id_tbl(i),
2023: p_error_message_name => 'PO_PDOI_VARIANCE_FAILED',
2024: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',
2025: p_column_name => 'VARIANCE_ACCOUNT_ID',
2026: p_column_value => x_dists.variance_account_id_tbl(i)
2027: );
2028:

Line 2214: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',

2210:
2211: PO_PDOI_ERR_UTL.process_val_type_errors
2212: (
2213: x_results => l_results,
2214: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',
2215: p_distributions => x_dists
2216: );
2217:
2218: d_position := 30;

Line 3425: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',

3421: p_interface_line_id => x_dists.intf_line_id_tbl(p_index),
3422: p_interface_line_location_id => x_dists.intf_line_loc_id_tbl(p_index),
3423: p_interface_distribution_id => x_dists.intf_dist_id_tbl(p_index),
3424: p_error_message_name => l_error_msg,
3425: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',
3426: p_column_name => 'PROJECT_ID',
3427: p_column_value => x_dists.project_id_tbl(p_index)
3428: );
3429:

Line 3455: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',

3451: p_interface_line_id => x_dists.intf_line_id_tbl(p_index),
3452: p_interface_line_location_id => x_dists.intf_line_loc_id_tbl(p_index),
3453: p_interface_distribution_id => x_dists.intf_dist_id_tbl(p_index),
3454: p_error_message_name => l_error_msg,
3455: p_table_name => 'PO_DISTRIBUTIONS_INTERFACE',
3456: p_column_name => 'AWARD_ID',
3457: p_column_value => x_dists.award_id_tbl(p_index)
3458: );
3459: