APPS.PO_R12_CAT_UPG_VAL_PVT dependencies on PO_ATTR_VALUES_TLP_INTERFACE

Line 4487: UPDATE PO_ATTR_VALUES_TLP_INTERFACE POATI

4483:
4484: -- SQL What: validate create action at attr TLP level
4485: -- SQL Why : To find incorrect action
4486: -- SQL Join: processing_id, action, interface_line_id
4487: UPDATE PO_ATTR_VALUES_TLP_INTERFACE POATI
4488: SET POATI.processing_id = -POATI.processing_id,
4489: POATI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
4490: WHERE POATI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
4491: AND POATI.action = PO_R12_CAT_UPG_PVT.g_action_tlp_create

Line 4773: UPDATE PO_ATTR_VALUES_TLP_INTERFACE POATI

4769:
4770: -- SQL What: validate create action at attr TLP level
4771: -- SQL Why : To find incorrect action
4772: -- SQL Join: processing_id, action, po_line_id
4773: UPDATE PO_ATTR_VALUES_TLP_INTERFACE POATI
4774: SET POATI.processing_id = -POATI.processing_id,
4775: POATI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
4776: WHERE POATI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
4777: AND POATI.action = 'ORIGINAL'

Line 4794: p_table_name => 'PO_ATTR_VALUES_TLP_INTERFACE',

4790: p_interface_header_id => l_err_header_ids(i),
4791: p_interface_line_id => l_err_line_ids(i),
4792: p_interface_attr_values_tlp_id => l_err_attr_values_tlp_ids(i),
4793: p_error_message_name => 'PO_CAT_UPG_ORIG_NOT_ALLOWED',
4794: p_table_name => 'PO_ATTR_VALUES_TLP_INTERFACE',
4795: p_column_name => 'ACTION'
4796: );
4797: END LOOP;
4798:

Line 5060: UPDATE PO_ATTR_VALUES_TLP_INTERFACE POATI

5056:
5057: -- SQL What: validate update action at attr TLP level
5058: -- SQL Why : To find incorrect action
5059: -- SQL Join: processing_id, action, po_line_id
5060: UPDATE PO_ATTR_VALUES_TLP_INTERFACE POATI
5061: SET POATI.processing_id = -POATI.processing_id,
5062: POATI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
5063: WHERE POATI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
5064: AND POATI.action = 'UPDATE'

Line 5132: p_table_name => 'po_attr_values_tlp_interface',

5128: p_interface_header_id => l_err_header_ids(i),
5129: p_interface_line_id => l_err_line_ids(i),
5130: p_interface_attr_values_tlp_id => l_err_attr_values_tlp_ids(i),
5131: p_error_message_name => 'PO_CAT_UPG_INVALID_LINE_ID',
5132: p_table_name => 'po_attr_values_tlp_interface',
5133: p_column_name => 'PO_LINE_ID'
5134: );
5135: END LOOP;
5136:

Line 5373: UPDATE PO_ATTR_VALUES_TLP_INTERFACE POATI

5369:
5370: -- SQL What: validate delete action at attr TLP level
5371: -- SQL Why : To find incorrect action
5372: -- SQL Join: processing_id, action, ppo_line_id
5373: UPDATE PO_ATTR_VALUES_TLP_INTERFACE POATI
5374: SET POATI.processing_id = -POATI.processing_id,
5375: POATI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
5376: WHERE POATI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
5377: AND POATI.action = 'DELETE'

Line 5457: p_table_name => 'po_attr_values_tlp_interface',

5453: p_interface_header_id => l_err_header_ids(i),
5454: p_interface_line_id => l_err_line_ids(i),
5455: p_interface_attr_values_tlp_id => l_err_attr_values_tlp_ids(i),
5456: p_error_message_name => 'PO_CAT_UPG_INVALID_LINE_ID',
5457: p_table_name => 'po_attr_values_tlp_interface',
5458: p_column_name => 'PO_LINE_ID'
5459: );
5460: END LOOP;
5461: