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.POR_UTIL_PKG dependencies on PO_REQ_DIST_INTERFACE

Line 5193: l_destination_type_code PO_REQ_DIST_INTERFACE_ALL.DESTINATION_TYPE_CODE%TYPE;

5189: p_program_id IN NUMBER
5190: )
5191: IS
5192: l_category_id PO_REQUISITIONS_INTERFACE_ALL.CATEGORY_ID%TYPE;
5193: l_destination_type_code PO_REQ_DIST_INTERFACE_ALL.DESTINATION_TYPE_CODE%TYPE;
5194: l_deliver_to_location_id PO_REQUISITIONS_INTERFACE_ALL.DELIVER_TO_LOCATION_ID%TYPE;
5195: l_destation_organization_id PO_REQ_DIST_INTERFACE_ALL.DESTINATION_ORGANIZATION_ID%TYPE;
5196: l_destination_subinventory PO_REQ_DIST_INTERFACE_ALL.DESTINATION_SUBINVENTORY%TYPE;
5197: l_i_expenditure_type PO_REQ_DIST_INTERFACE_ALL.EXPENDITURE_TYPE%TYPE;

Line 5195: l_destation_organization_id PO_REQ_DIST_INTERFACE_ALL.DESTINATION_ORGANIZATION_ID%TYPE;

5191: IS
5192: l_category_id PO_REQUISITIONS_INTERFACE_ALL.CATEGORY_ID%TYPE;
5193: l_destination_type_code PO_REQ_DIST_INTERFACE_ALL.DESTINATION_TYPE_CODE%TYPE;
5194: l_deliver_to_location_id PO_REQUISITIONS_INTERFACE_ALL.DELIVER_TO_LOCATION_ID%TYPE;
5195: l_destation_organization_id PO_REQ_DIST_INTERFACE_ALL.DESTINATION_ORGANIZATION_ID%TYPE;
5196: l_destination_subinventory PO_REQ_DIST_INTERFACE_ALL.DESTINATION_SUBINVENTORY%TYPE;
5197: l_i_expenditure_type PO_REQ_DIST_INTERFACE_ALL.EXPENDITURE_TYPE%TYPE;
5198: l_expenditure_organization_id PO_REQ_DIST_INTERFACE_ALL.EXPENDITURE_ORGANIZATION_ID%TYPE;
5199: l_expenditure_item_date PO_REQ_DIST_INTERFACE_ALL.EXPENDITURE_ITEM_DATE%TYPE;

Line 5196: l_destination_subinventory PO_REQ_DIST_INTERFACE_ALL.DESTINATION_SUBINVENTORY%TYPE;

5192: l_category_id PO_REQUISITIONS_INTERFACE_ALL.CATEGORY_ID%TYPE;
5193: l_destination_type_code PO_REQ_DIST_INTERFACE_ALL.DESTINATION_TYPE_CODE%TYPE;
5194: l_deliver_to_location_id PO_REQUISITIONS_INTERFACE_ALL.DELIVER_TO_LOCATION_ID%TYPE;
5195: l_destation_organization_id PO_REQ_DIST_INTERFACE_ALL.DESTINATION_ORGANIZATION_ID%TYPE;
5196: l_destination_subinventory PO_REQ_DIST_INTERFACE_ALL.DESTINATION_SUBINVENTORY%TYPE;
5197: l_i_expenditure_type PO_REQ_DIST_INTERFACE_ALL.EXPENDITURE_TYPE%TYPE;
5198: l_expenditure_organization_id PO_REQ_DIST_INTERFACE_ALL.EXPENDITURE_ORGANIZATION_ID%TYPE;
5199: l_expenditure_item_date PO_REQ_DIST_INTERFACE_ALL.EXPENDITURE_ITEM_DATE%TYPE;
5200: l_item_id PO_REQ_DIST_INTERFACE_ALL.ITEM_ID%TYPE;

Line 5197: l_i_expenditure_type PO_REQ_DIST_INTERFACE_ALL.EXPENDITURE_TYPE%TYPE;

5193: l_destination_type_code PO_REQ_DIST_INTERFACE_ALL.DESTINATION_TYPE_CODE%TYPE;
5194: l_deliver_to_location_id PO_REQUISITIONS_INTERFACE_ALL.DELIVER_TO_LOCATION_ID%TYPE;
5195: l_destation_organization_id PO_REQ_DIST_INTERFACE_ALL.DESTINATION_ORGANIZATION_ID%TYPE;
5196: l_destination_subinventory PO_REQ_DIST_INTERFACE_ALL.DESTINATION_SUBINVENTORY%TYPE;
5197: l_i_expenditure_type PO_REQ_DIST_INTERFACE_ALL.EXPENDITURE_TYPE%TYPE;
5198: l_expenditure_organization_id PO_REQ_DIST_INTERFACE_ALL.EXPENDITURE_ORGANIZATION_ID%TYPE;
5199: l_expenditure_item_date PO_REQ_DIST_INTERFACE_ALL.EXPENDITURE_ITEM_DATE%TYPE;
5200: l_item_id PO_REQ_DIST_INTERFACE_ALL.ITEM_ID%TYPE;
5201: l_line_type_id PO_REQUISITIONS_INTERFACE_ALL.LINE_TYPE_ID%TYPE;

Line 5198: l_expenditure_organization_id PO_REQ_DIST_INTERFACE_ALL.EXPENDITURE_ORGANIZATION_ID%TYPE;

5194: l_deliver_to_location_id PO_REQUISITIONS_INTERFACE_ALL.DELIVER_TO_LOCATION_ID%TYPE;
5195: l_destation_organization_id PO_REQ_DIST_INTERFACE_ALL.DESTINATION_ORGANIZATION_ID%TYPE;
5196: l_destination_subinventory PO_REQ_DIST_INTERFACE_ALL.DESTINATION_SUBINVENTORY%TYPE;
5197: l_i_expenditure_type PO_REQ_DIST_INTERFACE_ALL.EXPENDITURE_TYPE%TYPE;
5198: l_expenditure_organization_id PO_REQ_DIST_INTERFACE_ALL.EXPENDITURE_ORGANIZATION_ID%TYPE;
5199: l_expenditure_item_date PO_REQ_DIST_INTERFACE_ALL.EXPENDITURE_ITEM_DATE%TYPE;
5200: l_item_id PO_REQ_DIST_INTERFACE_ALL.ITEM_ID%TYPE;
5201: l_line_type_id PO_REQUISITIONS_INTERFACE_ALL.LINE_TYPE_ID%TYPE;
5202:

Line 5199: l_expenditure_item_date PO_REQ_DIST_INTERFACE_ALL.EXPENDITURE_ITEM_DATE%TYPE;

5195: l_destation_organization_id PO_REQ_DIST_INTERFACE_ALL.DESTINATION_ORGANIZATION_ID%TYPE;
5196: l_destination_subinventory PO_REQ_DIST_INTERFACE_ALL.DESTINATION_SUBINVENTORY%TYPE;
5197: l_i_expenditure_type PO_REQ_DIST_INTERFACE_ALL.EXPENDITURE_TYPE%TYPE;
5198: l_expenditure_organization_id PO_REQ_DIST_INTERFACE_ALL.EXPENDITURE_ORGANIZATION_ID%TYPE;
5199: l_expenditure_item_date PO_REQ_DIST_INTERFACE_ALL.EXPENDITURE_ITEM_DATE%TYPE;
5200: l_item_id PO_REQ_DIST_INTERFACE_ALL.ITEM_ID%TYPE;
5201: l_line_type_id PO_REQUISITIONS_INTERFACE_ALL.LINE_TYPE_ID%TYPE;
5202:
5203: l_preparer_id PO_REQUISITIONS_INTERFACE_ALL.PREPARER_ID%TYPE;

Line 5200: l_item_id PO_REQ_DIST_INTERFACE_ALL.ITEM_ID%TYPE;

5196: l_destination_subinventory PO_REQ_DIST_INTERFACE_ALL.DESTINATION_SUBINVENTORY%TYPE;
5197: l_i_expenditure_type PO_REQ_DIST_INTERFACE_ALL.EXPENDITURE_TYPE%TYPE;
5198: l_expenditure_organization_id PO_REQ_DIST_INTERFACE_ALL.EXPENDITURE_ORGANIZATION_ID%TYPE;
5199: l_expenditure_item_date PO_REQ_DIST_INTERFACE_ALL.EXPENDITURE_ITEM_DATE%TYPE;
5200: l_item_id PO_REQ_DIST_INTERFACE_ALL.ITEM_ID%TYPE;
5201: l_line_type_id PO_REQUISITIONS_INTERFACE_ALL.LINE_TYPE_ID%TYPE;
5202:
5203: l_preparer_id PO_REQUISITIONS_INTERFACE_ALL.PREPARER_ID%TYPE;
5204: l_i_project_id PO_REQ_DIST_INTERFACE_ALL.PROJECT_ID%TYPE;

Line 5204: l_i_project_id PO_REQ_DIST_INTERFACE_ALL.PROJECT_ID%TYPE;

5200: l_item_id PO_REQ_DIST_INTERFACE_ALL.ITEM_ID%TYPE;
5201: l_line_type_id PO_REQUISITIONS_INTERFACE_ALL.LINE_TYPE_ID%TYPE;
5202:
5203: l_preparer_id PO_REQUISITIONS_INTERFACE_ALL.PREPARER_ID%TYPE;
5204: l_i_project_id PO_REQ_DIST_INTERFACE_ALL.PROJECT_ID%TYPE;
5205: l_document_type_code PO_REQUISITIONS_INTERFACE_ALL.DOCUMENT_TYPE_CODE%TYPE;
5206:
5207: l_source_type_code PO_REQUISITIONS_INTERFACE_ALL.SOURCE_TYPE_CODE%TYPE;
5208: l_source_organization_id PO_REQUISITIONS_INTERFACE_ALL.SOURCE_ORGANIZATION_ID%TYPE;

Line 5210: l_i_task_id PO_REQ_DIST_INTERFACE_ALL.TASK_ID%TYPE;

5206:
5207: l_source_type_code PO_REQUISITIONS_INTERFACE_ALL.SOURCE_TYPE_CODE%TYPE;
5208: l_source_organization_id PO_REQUISITIONS_INTERFACE_ALL.SOURCE_ORGANIZATION_ID%TYPE;
5209: l_source_subventory PO_REQUISITIONS_INTERFACE_ALL.SOURCE_SUBINVENTORY%TYPE;
5210: l_i_task_id PO_REQ_DIST_INTERFACE_ALL.TASK_ID%TYPE;
5211: l_award_set_id PO_REQUISITIONS_INTERFACE_ALL.AWARD_ID%TYPE;
5212: l_deliver_to_requestor_id PO_REQUISITIONS_INTERFACE_ALL.DELIVER_TO_REQUESTOR_ID%TYPE;
5213: l_suggested_vendor_id PO_REQUISITIONS_INTERFACE_ALL.SUGGESTED_VENDOR_ID%TYPE;
5214: l_suggested_vendor_site_id PO_REQUISITIONS_INTERFACE_ALL.SUGGESTED_VENDOR_SITE_ID%TYPE;

Line 5221: l_prevent_encumbrance_flag PO_REQ_DIST_INTERFACE_ALL.PREVENT_ENCUMBRANCE_FLAG%TYPE;

5217: l_wip_line_id PO_REQUISITIONS_INTERFACE_ALL.WIP_LINE_ID%TYPE;
5218: l_wip_repetitive_schedule_id PO_REQUISITIONS_INTERFACE_ALL.WIP_REPETITIVE_SCHEDULE_ID%TYPE;
5219: l_wip_operation_seq_num PO_REQUISITIONS_INTERFACE_ALL.WIP_OPERATION_SEQ_NUM%TYPE;
5220: l_wip_resource_seq_num PO_REQUISITIONS_INTERFACE_ALL.WIP_RESOURCE_SEQ_NUM%TYPE;
5221: l_prevent_encumbrance_flag PO_REQ_DIST_INTERFACE_ALL.PREVENT_ENCUMBRANCE_FLAG%TYPE;
5222: l_gl_date PO_REQ_DIST_INTERFACE_ALL.GL_DATE%TYPE;
5223: l_header_att1 PO_REQUISITIONS_INTERFACE_ALL.HEADER_ATTRIBUTE1%TYPE;
5224: l_header_att2 PO_REQUISITIONS_INTERFACE_ALL.HEADER_ATTRIBUTE2%TYPE;
5225: l_header_att3 PO_REQUISITIONS_INTERFACE_ALL.HEADER_ATTRIBUTE3%TYPE;

Line 5222: l_gl_date PO_REQ_DIST_INTERFACE_ALL.GL_DATE%TYPE;

5218: l_wip_repetitive_schedule_id PO_REQUISITIONS_INTERFACE_ALL.WIP_REPETITIVE_SCHEDULE_ID%TYPE;
5219: l_wip_operation_seq_num PO_REQUISITIONS_INTERFACE_ALL.WIP_OPERATION_SEQ_NUM%TYPE;
5220: l_wip_resource_seq_num PO_REQUISITIONS_INTERFACE_ALL.WIP_RESOURCE_SEQ_NUM%TYPE;
5221: l_prevent_encumbrance_flag PO_REQ_DIST_INTERFACE_ALL.PREVENT_ENCUMBRANCE_FLAG%TYPE;
5222: l_gl_date PO_REQ_DIST_INTERFACE_ALL.GL_DATE%TYPE;
5223: l_header_att1 PO_REQUISITIONS_INTERFACE_ALL.HEADER_ATTRIBUTE1%TYPE;
5224: l_header_att2 PO_REQUISITIONS_INTERFACE_ALL.HEADER_ATTRIBUTE2%TYPE;
5225: l_header_att3 PO_REQUISITIONS_INTERFACE_ALL.HEADER_ATTRIBUTE3%TYPE;
5226: l_header_att4 PO_REQUISITIONS_INTERFACE_ALL.HEADER_ATTRIBUTE4%TYPE;

Line 5253: l_dist_att1 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE1%TYPE;

5249: l_line_att12 PO_REQUISITIONS_INTERFACE_ALL.LINE_ATTRIBUTE12%TYPE;
5250: l_line_att13 PO_REQUISITIONS_INTERFACE_ALL.LINE_ATTRIBUTE13%TYPE;
5251: l_line_att14 PO_REQUISITIONS_INTERFACE_ALL.LINE_ATTRIBUTE14%TYPE;
5252: l_line_att15 PO_REQUISITIONS_INTERFACE_ALL.LINE_ATTRIBUTE15%TYPE;
5253: l_dist_att1 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE1%TYPE;
5254: l_dist_att2 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE2%TYPE;
5255: l_dist_att3 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE3%TYPE;
5256: l_dist_att4 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE4%TYPE;
5257: l_dist_att5 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE5%TYPE;

Line 5254: l_dist_att2 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE2%TYPE;

5250: l_line_att13 PO_REQUISITIONS_INTERFACE_ALL.LINE_ATTRIBUTE13%TYPE;
5251: l_line_att14 PO_REQUISITIONS_INTERFACE_ALL.LINE_ATTRIBUTE14%TYPE;
5252: l_line_att15 PO_REQUISITIONS_INTERFACE_ALL.LINE_ATTRIBUTE15%TYPE;
5253: l_dist_att1 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE1%TYPE;
5254: l_dist_att2 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE2%TYPE;
5255: l_dist_att3 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE3%TYPE;
5256: l_dist_att4 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE4%TYPE;
5257: l_dist_att5 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE5%TYPE;
5258: l_dist_att6 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE6%TYPE;

Line 5255: l_dist_att3 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE3%TYPE;

5251: l_line_att14 PO_REQUISITIONS_INTERFACE_ALL.LINE_ATTRIBUTE14%TYPE;
5252: l_line_att15 PO_REQUISITIONS_INTERFACE_ALL.LINE_ATTRIBUTE15%TYPE;
5253: l_dist_att1 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE1%TYPE;
5254: l_dist_att2 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE2%TYPE;
5255: l_dist_att3 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE3%TYPE;
5256: l_dist_att4 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE4%TYPE;
5257: l_dist_att5 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE5%TYPE;
5258: l_dist_att6 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE6%TYPE;
5259: l_dist_att7 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE7%TYPE;

Line 5256: l_dist_att4 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE4%TYPE;

5252: l_line_att15 PO_REQUISITIONS_INTERFACE_ALL.LINE_ATTRIBUTE15%TYPE;
5253: l_dist_att1 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE1%TYPE;
5254: l_dist_att2 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE2%TYPE;
5255: l_dist_att3 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE3%TYPE;
5256: l_dist_att4 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE4%TYPE;
5257: l_dist_att5 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE5%TYPE;
5258: l_dist_att6 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE6%TYPE;
5259: l_dist_att7 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE7%TYPE;
5260: l_dist_att8 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE8%TYPE;

Line 5257: l_dist_att5 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE5%TYPE;

5253: l_dist_att1 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE1%TYPE;
5254: l_dist_att2 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE2%TYPE;
5255: l_dist_att3 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE3%TYPE;
5256: l_dist_att4 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE4%TYPE;
5257: l_dist_att5 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE5%TYPE;
5258: l_dist_att6 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE6%TYPE;
5259: l_dist_att7 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE7%TYPE;
5260: l_dist_att8 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE8%TYPE;
5261: l_dist_att9 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE9%TYPE;

Line 5258: l_dist_att6 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE6%TYPE;

5254: l_dist_att2 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE2%TYPE;
5255: l_dist_att3 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE3%TYPE;
5256: l_dist_att4 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE4%TYPE;
5257: l_dist_att5 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE5%TYPE;
5258: l_dist_att6 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE6%TYPE;
5259: l_dist_att7 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE7%TYPE;
5260: l_dist_att8 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE8%TYPE;
5261: l_dist_att9 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE9%TYPE;
5262: l_dist_att10 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE10%TYPE;

Line 5259: l_dist_att7 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE7%TYPE;

5255: l_dist_att3 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE3%TYPE;
5256: l_dist_att4 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE4%TYPE;
5257: l_dist_att5 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE5%TYPE;
5258: l_dist_att6 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE6%TYPE;
5259: l_dist_att7 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE7%TYPE;
5260: l_dist_att8 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE8%TYPE;
5261: l_dist_att9 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE9%TYPE;
5262: l_dist_att10 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE10%TYPE;
5263: l_dist_att11 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE11%TYPE;

Line 5260: l_dist_att8 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE8%TYPE;

5256: l_dist_att4 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE4%TYPE;
5257: l_dist_att5 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE5%TYPE;
5258: l_dist_att6 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE6%TYPE;
5259: l_dist_att7 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE7%TYPE;
5260: l_dist_att8 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE8%TYPE;
5261: l_dist_att9 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE9%TYPE;
5262: l_dist_att10 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE10%TYPE;
5263: l_dist_att11 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE11%TYPE;
5264: l_dist_att12 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE12%TYPE;

Line 5261: l_dist_att9 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE9%TYPE;

5257: l_dist_att5 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE5%TYPE;
5258: l_dist_att6 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE6%TYPE;
5259: l_dist_att7 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE7%TYPE;
5260: l_dist_att8 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE8%TYPE;
5261: l_dist_att9 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE9%TYPE;
5262: l_dist_att10 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE10%TYPE;
5263: l_dist_att11 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE11%TYPE;
5264: l_dist_att12 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE12%TYPE;
5265: l_dist_att13 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE13%TYPE;

Line 5262: l_dist_att10 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE10%TYPE;

5258: l_dist_att6 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE6%TYPE;
5259: l_dist_att7 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE7%TYPE;
5260: l_dist_att8 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE8%TYPE;
5261: l_dist_att9 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE9%TYPE;
5262: l_dist_att10 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE10%TYPE;
5263: l_dist_att11 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE11%TYPE;
5264: l_dist_att12 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE12%TYPE;
5265: l_dist_att13 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE13%TYPE;
5266: l_dist_att14 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE14%TYPE;

Line 5263: l_dist_att11 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE11%TYPE;

5259: l_dist_att7 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE7%TYPE;
5260: l_dist_att8 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE8%TYPE;
5261: l_dist_att9 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE9%TYPE;
5262: l_dist_att10 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE10%TYPE;
5263: l_dist_att11 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE11%TYPE;
5264: l_dist_att12 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE12%TYPE;
5265: l_dist_att13 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE13%TYPE;
5266: l_dist_att14 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE14%TYPE;
5267: l_dist_att15 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE15%TYPE;

Line 5264: l_dist_att12 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE12%TYPE;

5260: l_dist_att8 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE8%TYPE;
5261: l_dist_att9 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE9%TYPE;
5262: l_dist_att10 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE10%TYPE;
5263: l_dist_att11 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE11%TYPE;
5264: l_dist_att12 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE12%TYPE;
5265: l_dist_att13 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE13%TYPE;
5266: l_dist_att14 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE14%TYPE;
5267: l_dist_att15 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE15%TYPE;
5268: l_unit_price PO_REQUISITIONS_INTERFACE_ALL.UNIT_PRICE%TYPE;

Line 5265: l_dist_att13 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE13%TYPE;

5261: l_dist_att9 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE9%TYPE;
5262: l_dist_att10 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE10%TYPE;
5263: l_dist_att11 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE11%TYPE;
5264: l_dist_att12 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE12%TYPE;
5265: l_dist_att13 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE13%TYPE;
5266: l_dist_att14 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE14%TYPE;
5267: l_dist_att15 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE15%TYPE;
5268: l_unit_price PO_REQUISITIONS_INTERFACE_ALL.UNIT_PRICE%TYPE;
5269: l_batch_id PO_REQ_DIST_INTERFACE_ALL.BATCH_ID%TYPE;

Line 5266: l_dist_att14 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE14%TYPE;

5262: l_dist_att10 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE10%TYPE;
5263: l_dist_att11 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE11%TYPE;
5264: l_dist_att12 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE12%TYPE;
5265: l_dist_att13 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE13%TYPE;
5266: l_dist_att14 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE14%TYPE;
5267: l_dist_att15 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE15%TYPE;
5268: l_unit_price PO_REQUISITIONS_INTERFACE_ALL.UNIT_PRICE%TYPE;
5269: l_batch_id PO_REQ_DIST_INTERFACE_ALL.BATCH_ID%TYPE;
5270: l_transaction_id PO_REQ_DIST_INTERFACE_ALL.TRANSACTION_ID%TYPE;

Line 5267: l_dist_att15 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE15%TYPE;

5263: l_dist_att11 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE11%TYPE;
5264: l_dist_att12 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE12%TYPE;
5265: l_dist_att13 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE13%TYPE;
5266: l_dist_att14 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE14%TYPE;
5267: l_dist_att15 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE15%TYPE;
5268: l_unit_price PO_REQUISITIONS_INTERFACE_ALL.UNIT_PRICE%TYPE;
5269: l_batch_id PO_REQ_DIST_INTERFACE_ALL.BATCH_ID%TYPE;
5270: l_transaction_id PO_REQ_DIST_INTERFACE_ALL.TRANSACTION_ID%TYPE;
5271: ----

Line 5269: l_batch_id PO_REQ_DIST_INTERFACE_ALL.BATCH_ID%TYPE;

5265: l_dist_att13 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE13%TYPE;
5266: l_dist_att14 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE14%TYPE;
5267: l_dist_att15 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE15%TYPE;
5268: l_unit_price PO_REQUISITIONS_INTERFACE_ALL.UNIT_PRICE%TYPE;
5269: l_batch_id PO_REQ_DIST_INTERFACE_ALL.BATCH_ID%TYPE;
5270: l_transaction_id PO_REQ_DIST_INTERFACE_ALL.TRANSACTION_ID%TYPE;
5271: ----
5272: l_budget_account_id PO_REQ_DIST_INTERFACE_ALL.BUDGET_ACCOUNT_ID%TYPE;
5273: l_accrual_account_id PO_REQ_DIST_INTERFACE_ALL.ACCRUAL_ACCOUNT_ID%TYPE;

Line 5270: l_transaction_id PO_REQ_DIST_INTERFACE_ALL.TRANSACTION_ID%TYPE;

5266: l_dist_att14 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE14%TYPE;
5267: l_dist_att15 PO_REQ_DIST_INTERFACE_ALL.DISTRIBUTION_ATTRIBUTE15%TYPE;
5268: l_unit_price PO_REQUISITIONS_INTERFACE_ALL.UNIT_PRICE%TYPE;
5269: l_batch_id PO_REQ_DIST_INTERFACE_ALL.BATCH_ID%TYPE;
5270: l_transaction_id PO_REQ_DIST_INTERFACE_ALL.TRANSACTION_ID%TYPE;
5271: ----
5272: l_budget_account_id PO_REQ_DIST_INTERFACE_ALL.BUDGET_ACCOUNT_ID%TYPE;
5273: l_accrual_account_id PO_REQ_DIST_INTERFACE_ALL.ACCRUAL_ACCOUNT_ID%TYPE;
5274: l_variance_account_id PO_REQ_DIST_INTERFACE_ALL.VARIANCE_ACCOUNT_ID%TYPE;

Line 5272: l_budget_account_id PO_REQ_DIST_INTERFACE_ALL.BUDGET_ACCOUNT_ID%TYPE;

5268: l_unit_price PO_REQUISITIONS_INTERFACE_ALL.UNIT_PRICE%TYPE;
5269: l_batch_id PO_REQ_DIST_INTERFACE_ALL.BATCH_ID%TYPE;
5270: l_transaction_id PO_REQ_DIST_INTERFACE_ALL.TRANSACTION_ID%TYPE;
5271: ----
5272: l_budget_account_id PO_REQ_DIST_INTERFACE_ALL.BUDGET_ACCOUNT_ID%TYPE;
5273: l_accrual_account_id PO_REQ_DIST_INTERFACE_ALL.ACCRUAL_ACCOUNT_ID%TYPE;
5274: l_variance_account_id PO_REQ_DIST_INTERFACE_ALL.VARIANCE_ACCOUNT_ID%TYPE;
5275: result VARCHAR2(1);
5276: l_o_charge_success VARCHAR2(1);

Line 5273: l_accrual_account_id PO_REQ_DIST_INTERFACE_ALL.ACCRUAL_ACCOUNT_ID%TYPE;

5269: l_batch_id PO_REQ_DIST_INTERFACE_ALL.BATCH_ID%TYPE;
5270: l_transaction_id PO_REQ_DIST_INTERFACE_ALL.TRANSACTION_ID%TYPE;
5271: ----
5272: l_budget_account_id PO_REQ_DIST_INTERFACE_ALL.BUDGET_ACCOUNT_ID%TYPE;
5273: l_accrual_account_id PO_REQ_DIST_INTERFACE_ALL.ACCRUAL_ACCOUNT_ID%TYPE;
5274: l_variance_account_id PO_REQ_DIST_INTERFACE_ALL.VARIANCE_ACCOUNT_ID%TYPE;
5275: result VARCHAR2(1);
5276: l_o_charge_success VARCHAR2(1);
5277: l_o_budget_success VARCHAR2(1);

Line 5274: l_variance_account_id PO_REQ_DIST_INTERFACE_ALL.VARIANCE_ACCOUNT_ID%TYPE;

5270: l_transaction_id PO_REQ_DIST_INTERFACE_ALL.TRANSACTION_ID%TYPE;
5271: ----
5272: l_budget_account_id PO_REQ_DIST_INTERFACE_ALL.BUDGET_ACCOUNT_ID%TYPE;
5273: l_accrual_account_id PO_REQ_DIST_INTERFACE_ALL.ACCRUAL_ACCOUNT_ID%TYPE;
5274: l_variance_account_id PO_REQ_DIST_INTERFACE_ALL.VARIANCE_ACCOUNT_ID%TYPE;
5275: result VARCHAR2(1);
5276: l_o_charge_success VARCHAR2(1);
5277: l_o_budget_success VARCHAR2(1);
5278: l_o_accrual_success VARCHAR2(1);

Line 5325: FROM PO_REQUISITIONS_INTERFACE PRI, PO_REQ_DIST_INTERFACE PRDI

5321: PRDI.DISTRIBUTION_ATTRIBUTE11, PRDI.DISTRIBUTION_ATTRIBUTE12, PRDI.DISTRIBUTION_ATTRIBUTE13, PRDI.DISTRIBUTION_ATTRIBUTE14, PRDI.DISTRIBUTION_ATTRIBUTE15,
5322:
5323: PRI.UNIT_PRICE, PRDI.BATCH_ID, PRDI.TRANSACTION_ID, PRDI.BUDGET_ACCOUNT_ID, PRDI.ACCRUAL_ACCOUNT_ID, PRDI.VARIANCE_ACCOUNT_ID
5324:
5325: FROM PO_REQUISITIONS_INTERFACE PRI, PO_REQ_DIST_INTERFACE PRDI
5326: WHERE PRI.REQ_DIST_SEQUENCE_ID = PRDI.DIST_SEQUENCE_ID
5327: AND PRI.REQUEST_ID =:c_request_id AND PRDI.CHARGE_ACCOUNT_ID IS NULL '
5328: ;
5329: l_rowid ROWID;

Line 5498: UPDATE PO_REQ_DIST_INTERFACE

5494: );
5495: IF(result = 'Y') THEN
5496: --update charge account
5497: IF(l_o_charge_success ='Y' AND l_o_code_combation_id IS NOT NULL ) THEN
5498: UPDATE PO_REQ_DIST_INTERFACE
5499: SET CHARGE_ACCOUNT_ID=l_o_code_combation_id
5500: WHERE ROWID =l_rowid;
5501: END IF;
5502: --update budget account

Line 5504: UPDATE PO_REQ_DIST_INTERFACE

5500: WHERE ROWID =l_rowid;
5501: END IF;
5502: --update budget account
5503: IF(l_o_budget_success ='Y' AND l_o_budget_account_id IS NOT NULL AND l_budget_account_id IS NULL ) THEN
5504: UPDATE PO_REQ_DIST_INTERFACE
5505: SET BUDGET_ACCOUNT_ID=l_o_budget_account_id
5506: WHERE ROWID =l_rowid;
5507: END IF;
5508: --update accrual account

Line 5510: UPDATE PO_REQ_DIST_INTERFACE

5506: WHERE ROWID =l_rowid;
5507: END IF;
5508: --update accrual account
5509: IF(l_o_accrual_success ='Y' AND l_o_accrual_account_id IS NOT NULL AND l_accrual_account_id IS NULL ) THEN
5510: UPDATE PO_REQ_DIST_INTERFACE
5511: SET ACCRUAL_ACCOUNT_ID=l_o_accrual_account_id
5512: WHERE ROWID =l_rowid;
5513: END IF;
5514: --update variance account

Line 5516: UPDATE PO_REQ_DIST_INTERFACE

5512: WHERE ROWID =l_rowid;
5513: END IF;
5514: --update variance account
5515: IF(l_o_variance_success ='Y' AND l_o_variance_account_id IS NOT NULL AND l_variance_account_id IS NULL ) THEN
5516: UPDATE PO_REQ_DIST_INTERFACE
5517: SET VARIANCE_ACCOUNT_ID=l_o_variance_account_id
5518: WHERE ROWID =l_rowid;
5519: END IF;
5520: ELSE