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_R12_CAT_UPG_VAL_PVT dependencies on PO_ATTR_VALUES_INTERFACE

Line 4209: UPDATE PO_ATTR_VALUES_INTERFACE POAI

4205:
4206: -- SQL What: validate create action at attr level
4207: -- SQL Why : To find incorrect action
4208: -- SQL Join: processing_id, action, interface_line_id
4209: UPDATE PO_ATTR_VALUES_INTERFACE POAI
4210: SET POAI.processing_id = -POAI.processing_id,
4211: POAI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
4212: WHERE POAI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
4213: AND POAI.action = PO_R12_CAT_UPG_PVT.g_action_attr_create

Line 4242: p_table_name => 'PO_ATTR_VALUES_INTERFACE',

4238: p_interface_header_id => l_err_header_ids(i),
4239: p_interface_line_id => l_err_line_ids(i),
4240: p_interface_attr_values_id => l_err_attr_values_ids(i),
4241: p_error_message_name => 'PO_CAT_UPG_NULL_IDS',
4242: p_table_name => 'PO_ATTR_VALUES_INTERFACE',
4243: p_column_name => 'INTERFACE_ATTR_VALUES_ID'
4244: );
4245: END LOOP;
4246:

Line 4265: UPDATE PO_ATTR_VALUES_INTERFACE POAI

4261: l_err_line_ids.DELETE;
4262: l_err_header_ids.DELETE;
4263:
4264: l_progress := '071';
4265: UPDATE PO_ATTR_VALUES_INTERFACE POAI
4266: SET POAI.processing_id = -POAI.processing_id,
4267: POAI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
4268: WHERE POAI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
4269: AND POAI.action = PO_R12_CAT_UPG_PVT.g_action_attr_create

Line 4293: p_table_name => 'PO_ATTR_VALUES_INTERFACE',

4289: p_interface_header_id => l_err_header_ids(i),
4290: p_interface_line_id => l_err_line_ids(i),
4291: p_interface_attr_values_id => l_err_attr_values_ids(i),
4292: p_error_message_name => 'PO_CAT_UPG_INV_LINE_ACTION_BL',
4293: p_table_name => 'PO_ATTR_VALUES_INTERFACE',
4294: p_column_name => 'INTERFACE_ATTR_VALUES_ID'
4295: );
4296: END LOOP;
4297:

Line 4318: UPDATE PO_ATTR_VALUES_INTERFACE POAI

4314: l_err_line_ids.DELETE;
4315: l_err_header_ids.DELETE;
4316:
4317: l_progress := '07';
4318: UPDATE PO_ATTR_VALUES_INTERFACE POAI
4319: SET POAI.processing_id = -POAI.processing_id,
4320: POAI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
4321: WHERE POAI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
4322: AND POAI.action = PO_R12_CAT_UPG_PVT.g_action_attr_create

Line 4346: p_table_name => 'PO_ATTR_VALUES_INTERFACE',

4342: p_interface_header_id => l_err_header_ids(i),
4343: p_interface_line_id => l_err_line_ids(i),
4344: p_interface_attr_values_id => l_err_attr_values_ids(i),
4345: p_error_message_name => 'PO_CAT_UPG_INV_LINE_ACTION_RT',
4346: p_table_name => 'PO_ATTR_VALUES_INTERFACE',
4347: p_column_name => 'INTERFACE_ATTR_VALUES_ID'
4348: );
4349: END LOOP;
4350:

Line 4361: UPDATE PO_ATTR_VALUES_INTERFACE POAI

4357: l_err_line_ids.DELETE;
4358: l_err_header_ids.DELETE;
4359:
4360: l_progress := '073';
4361: UPDATE PO_ATTR_VALUES_INTERFACE POAI
4362: SET POAI.processing_id = -POAI.processing_id,
4363: POAI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
4364: WHERE POAI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
4365: AND POAI.action = PO_R12_CAT_UPG_PVT.g_action_attr_create

Line 4391: p_table_name => 'PO_ATTR_VALUES_INTERFACE',

4387: p_interface_header_id => l_err_header_ids(i),
4388: p_interface_line_id => l_err_line_ids(i),
4389: p_interface_attr_values_id => l_err_attr_values_ids(i),
4390: p_error_message_name => 'PO_CAT_UPG_ALL_3_FOR_REQT',
4391: p_table_name => 'PO_ATTR_VALUES_INTERFACE',
4392: p_column_name => 'INTERFACE_ATTR_VALUES_ID'
4393: );
4394: END LOOP;
4395:

Line 4406: UPDATE PO_ATTR_VALUES_INTERFACE POAI

4402: l_err_line_ids.DELETE;
4403: l_err_header_ids.DELETE;
4404:
4405: l_progress := '075';
4406: UPDATE PO_ATTR_VALUES_INTERFACE POAI
4407: SET POAI.processing_id = -POAI.processing_id,
4408: POAI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
4409: WHERE POAI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
4410: AND POAI.action = PO_R12_CAT_UPG_PVT.g_action_attr_create

Line 4438: p_table_name => 'PO_ATTR_VALUES_INTERFACE',

4434: p_interface_header_id => l_err_header_ids(i),
4435: p_interface_line_id => l_err_line_ids(i),
4436: p_interface_attr_values_id => l_err_attr_values_ids(i),
4437: p_error_message_name => 'PO_CAT_UPG_ALL_NO_REQTEMP',
4438: p_table_name => 'PO_ATTR_VALUES_INTERFACE',
4439: p_column_name => 'INTERFACE_ATTR_VALUES_ID'
4440: );
4441: END LOOP;
4442:

Line 4454: p_table_name => 'PO_ATTR_VALUES_INTERFACE',

4450: p_interface_header_id => l_err_header_ids(i),
4451: p_interface_line_id => l_err_line_ids(i),
4452: p_interface_attr_values_id => l_err_attr_values_ids(i),
4453: p_error_message_name => 'PO_CAT_UPG_INVALID_ATTR_ROW',
4454: p_table_name => 'PO_ATTR_VALUES_INTERFACE',
4455: p_column_name => 'INTERFACE_ATTR_VALUES_ID'
4456: );
4457: END LOOP;
4458:

Line 4564: p_table_name => 'PO_ATTR_VALUES_INTERFACE',

4560: p_interface_header_id => l_err_header_ids(i),
4561: p_interface_line_id => l_err_line_ids(i),
4562: p_interface_attr_values_tlp_id => l_err_attr_values_tlp_ids(i),
4563: p_error_message_name => 'PO_CAT_UPG_INVALID_TLP_ROW',
4564: p_table_name => 'PO_ATTR_VALUES_INTERFACE',
4565: p_column_name => 'INTERFACE_ATTR_VALUES_TLP_ID'
4566: );
4567: END LOOP;
4568:

Line 4729: UPDATE PO_ATTR_VALUES_INTERFACE POAI

4725:
4726: -- SQL What: validate create action at attr level
4727: -- SQL Why : To find incorrect action
4728: -- SQL Join: processing_id, action, po_line_id
4729: UPDATE PO_ATTR_VALUES_INTERFACE POAI
4730: SET POAI.processing_id = -POAI.processing_id,
4731: POAI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
4732: WHERE POAI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
4733: AND POAI.action = 'ORIGINAL'

Line 4750: p_table_name => 'PO_ATTR_VALUES_INTERFACE',

4746: p_interface_header_id => l_err_header_ids(i),
4747: p_interface_line_id => l_err_line_ids(i),
4748: p_interface_attr_values_id => l_err_attr_values_ids(i),
4749: p_error_message_name => 'PO_CAT_UPG_ORIG_NOT_ALLOWED',
4750: p_table_name => 'PO_ATTR_VALUES_INTERFACE',
4751: p_column_name => 'ACTION'
4752: );
4753: END LOOP;
4754:

Line 4970: UPDATE PO_ATTR_VALUES_INTERFACE POAI

4966:
4967: -- SQL What: validate update action at attr level
4968: -- SQL Why : To find incorrect action
4969: -- SQL Join: processing_id, action, po_line_id
4970: UPDATE PO_ATTR_VALUES_INTERFACE POAI
4971: SET POAI.processing_id = -POAI.processing_id,
4972: POAI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
4973: WHERE POAI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
4974: AND POAI.action = 'UPDATE'

Line 5032: p_table_name => 'po_attr_values_interface',

5028: p_interface_header_id => l_err_header_ids(i),
5029: p_interface_line_id => l_err_line_ids(i),
5030: p_interface_attr_values_id => l_err_attr_values_ids(i),
5031: p_error_message_name => 'PO_CAT_UPG_INVALID_LINE_ID',
5032: p_table_name => 'po_attr_values_interface',
5033: p_column_name => 'PO_LINE_ID'
5034: );
5035: END LOOP;
5036:

Line 5310: UPDATE PO_ATTR_VALUES_INTERFACE POAI

5306:
5307: -- SQL What: validate delete action at attr level
5308: -- SQL Why : To find incorrect action
5309: -- SQL Join: processing_id, action
5310: UPDATE PO_ATTR_VALUES_INTERFACE POAI
5311: SET POAI.processing_id = -POAI.processing_id,
5312: POAI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
5313: WHERE POAI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
5314: AND POAI.action = 'DELETE'

Line 5329: p_table_name => 'po_attr_values_interface',

5325: p_interface_header_id => l_err_header_ids(i),
5326: p_interface_line_id => l_err_line_ids(i),
5327: p_interface_attr_values_id => l_err_attr_values_ids(i),
5328: p_error_message_name => 'PO_CAT_UPG_CANT_DEL_ATTR',
5329: p_table_name => 'po_attr_values_interface',
5330: p_column_name => 'ATTRIBUTE_VALUE_ID'
5331: );
5332: END LOOP;
5333: