DBA Data[Home] [Help]

APPS.IPA_ASSET_MECH_APIS_PKG dependencies on PA_PROJECT_ASSET_ASSIGNMENTS

Line 124: FROM pa_project_asset_assignments ppaa

120: c_attribute6 in varchar2, --crl_inventory_item
121: c_attribute7 in varchar2 --crl_serial_number
122: ) IS
123: select 'X'
124: FROM pa_project_asset_assignments ppaa
125: WHERE ppaa.task_id = c_task_id
126: AND ppaa.project_id = c_project_id
127: AND nvl(ppaa.attribute8,'~!@#') = nvl(c_attribute8, '~!@#')
128: AND nvl(ppaa.attribute9,'~!@#') = nvl(c_attribute9, '~!@#')

Line 511: update pa_project_asset_assignments

507: -- asset. tls 5/9/99
508:
509: /* Bug#3043050. Added decode for attributes 6 and 7 based on NL Installed flag */
510: x_err_stage := 'Updating PA_PROJECT_ASSETS_ASSIGNMENTS';
511: update pa_project_asset_assignments
512: set attribute8 = ei_rec.attribute8
513: ,attribute9 = ei_rec.attribute9
514: ,attribute10 = ei_rec.attribute10
515: ,attribute6 = decode(nvl(IPA_ASSET_MECH_APIS_PKG.g_nl_installed, 'N'), 'Y',