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.IPA_ASSET_MECH_APIS_PKG dependencies on IPA_ASSET_MECH_APIS_PKG

Line 1: PACKAGE BODY IPA_ASSET_MECH_APIS_PKG AS

1: PACKAGE BODY IPA_ASSET_MECH_APIS_PKG AS
2: /* $Header: IPAAMAPB.pls 120.3 2006/02/14 16:56:58 dlanka noship $ */
3: /* Original Header: IPAFAXB.pls 41.8 98/02/06 17:01:21 porting ship */
4: Procedure IPA_AUTO_ASSET_CREATION (
5: x_project_num_from IN VARCHAR2,

Line 85: AND decode(IPA_ASSET_MECH_APIS_PKG.g_nl_installed,'Y',pei.expenditure_item_id,-99) = decode(IPA_ASSET_MECH_APIS_PKG.g_nl_installed,'Y',nvl(IPA_ASSET_MECH_APIS_PKG.g_expenditure_item_id,pei.expenditure_item_id), -99)

81: AND pt.project_id = ppr.project_id
82: AND ppt.org_id = ppr.org_id -- Fix for bug : 4969694
83: --AND pcdl.expenditure_item_id = pei.expenditure_item_id
84: -- dcharlto 4/21/99 crl3.1
85: AND decode(IPA_ASSET_MECH_APIS_PKG.g_nl_installed,'Y',pei.expenditure_item_id,-99) = decode(IPA_ASSET_MECH_APIS_PKG.g_nl_installed,'Y',nvl(IPA_ASSET_MECH_APIS_PKG.g_expenditure_item_id,pei.expenditure_item_id), -99)
86: -- dcharlto 4/21/99 crl3.1
87: --AND decode(nvl(IPA_ASSET_MECH_APIS_PKG.g_nl_installed,'N'),'Y','N',pei.revenue_distributed_flag) = 'N'
88: --AND pei.revenue_distributed_flag||'' = 'N'
89: --AND pcdl.line_type = DECODE(ppt.capital_cost_type_code,'R','R','B','D','R')

Line 87: --AND decode(nvl(IPA_ASSET_MECH_APIS_PKG.g_nl_installed,'N'),'Y','N',pei.revenue_distributed_flag) = 'N'

83: --AND pcdl.expenditure_item_id = pei.expenditure_item_id
84: -- dcharlto 4/21/99 crl3.1
85: AND decode(IPA_ASSET_MECH_APIS_PKG.g_nl_installed,'Y',pei.expenditure_item_id,-99) = decode(IPA_ASSET_MECH_APIS_PKG.g_nl_installed,'Y',nvl(IPA_ASSET_MECH_APIS_PKG.g_expenditure_item_id,pei.expenditure_item_id), -99)
86: -- dcharlto 4/21/99 crl3.1
87: --AND decode(nvl(IPA_ASSET_MECH_APIS_PKG.g_nl_installed,'N'),'Y','N',pei.revenue_distributed_flag) = 'N'
88: --AND pei.revenue_distributed_flag||'' = 'N'
89: --AND pcdl.line_type = DECODE(ppt.capital_cost_type_code,'R','R','B','D','R')
90: --AND pcdl.billable_flag = 'Y'
91: AND pei.billable_flag = 'Y'

Line 131: AND ( (NVL(IPA_ASSET_MECH_APIS_PKG.g_nl_installed,'N') = 'Y'

127: AND nvl(ppaa.attribute8,'~!@#') = nvl(c_attribute8, '~!@#')
128: AND nvl(ppaa.attribute9,'~!@#') = nvl(c_attribute9, '~!@#')
129: AND nvl(ppaa.attribute10,'~!@#') = nvl(c_attribute10, '~!@#')
130: /* Start Bug fix:2956569 : attribute6,7 Should be validated only when the nl_installed flag = Y*/
131: AND ( (NVL(IPA_ASSET_MECH_APIS_PKG.g_nl_installed,'N') = 'Y'
132: AND nvl(ppaa.attribute6,'~!@#') = nvl(c_attribute6, '~!@#') --crl_inventory
133: AND nvl(ppaa.attribute7,'~!@#') = nvl(c_attribute7, '~!@#') --serial_number
134: )
135: OR

Line 136: NVL(IPA_ASSET_MECH_APIS_PKG.g_nl_installed,'N') = 'N'

132: AND nvl(ppaa.attribute6,'~!@#') = nvl(c_attribute6, '~!@#') --crl_inventory
133: AND nvl(ppaa.attribute7,'~!@#') = nvl(c_attribute7, '~!@#') --serial_number
134: )
135: OR
136: NVL(IPA_ASSET_MECH_APIS_PKG.g_nl_installed,'N') = 'N'
137: );
138: /* End Bug fix:2956569 */
139:
140:

Line 169: decode(nvl(IPA_ASSET_MECH_APIS_PKG.g_nl_installed, 'N'), 'Y',

165: 'ADP',project_name,
166: 'ADGE1',attribute8,
167: 'ADGE2',attribute9,
168: 'ADGE3',attribute10)||
169: decode(nvl(IPA_ASSET_MECH_APIS_PKG.g_nl_installed, 'N'), 'Y',
170: decode(attribute6,null,null,
171: asset_naming_method_rec.asset_desc_separator||
172: attribute6|| --Inventory_item
173: decode(attribute7,null,null,

Line 437: ,X_Asset_Units =>nvl(IPA_ASSET_MECH_APIS_PKG.g_number_of_units,1)

433: ,X_Asset_Category_Id =>v_category_id
434: ,X_Asset_key_ccid => null --Added for 11i
435: ,X_Book_Type_Code =>v_book_type_code
436: -- dcharlto
437: ,X_Asset_Units =>nvl(IPA_ASSET_MECH_APIS_PKG.g_number_of_units,1)
438: -- dcharlto
439: ,X_Depreciate_Flag =>'Y'
440: ,X_Amortize_Flag =>'N'
441: ,X_Cost_Adjustment_Flag => 'N'

Line 515: ,attribute6 = decode(nvl(IPA_ASSET_MECH_APIS_PKG.g_nl_installed, 'N'), 'Y',

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',
516: ei_rec.attribute6, attribute6) --crl_inventory_item
517: ,attribute7 = decode(nvl(IPA_ASSET_MECH_APIS_PKG.g_nl_installed, 'N'), 'Y',
518: ei_rec.attribute7, attribute7) --crl_serial_number
519: where rowid = v_row_id2;

Line 517: ,attribute7 = decode(nvl(IPA_ASSET_MECH_APIS_PKG.g_nl_installed, 'N'), 'Y',

513: ,attribute9 = ei_rec.attribute9
514: ,attribute10 = ei_rec.attribute10
515: ,attribute6 = decode(nvl(IPA_ASSET_MECH_APIS_PKG.g_nl_installed, 'N'), 'Y',
516: ei_rec.attribute6, attribute6) --crl_inventory_item
517: ,attribute7 = decode(nvl(IPA_ASSET_MECH_APIS_PKG.g_nl_installed, 'N'), 'Y',
518: ei_rec.attribute7, attribute7) --crl_serial_number
519: where rowid = v_row_id2;
520:
521:

Line 577: END IPA_ASSET_MECH_APIS_PKG;

573: close check_auto_asset ;
574:
575: End;
576:
577: END IPA_ASSET_MECH_APIS_PKG;