APPS.EAM_PM_LAST_SERVICE_PUB dependencies on EAM_PM_LAST_SERVICE

Line 1: PACKAGE BODY EAM_PM_LAST_SERVICE_PUB AS

1: PACKAGE BODY EAM_PM_LAST_SERVICE_PUB AS
2: /* $Header: EAMPPLSB.pls 120.2 2005/11/28 04:55:57 kmurthy noship $ */
3: -- Start of comments
4: -- API name : EAM_PM_LAST_SERVICE_PUB
5: -- Type : Public

Line 4: -- API name : EAM_PM_LAST_SERVICE_PUB

1: PACKAGE BODY EAM_PM_LAST_SERVICE_PUB AS
2: /* $Header: EAMPPLSB.pls 120.2 2005/11/28 04:55:57 kmurthy noship $ */
3: -- Start of comments
4: -- API name : EAM_PM_LAST_SERVICE_PUB
5: -- Type : Public
6: -- Function : insert_pm_last_service, update_pm_last_service
7: -- Pre-reqs : None.
8: -- Parameters :

Line 41: G_PKG_NAME CONSTANT VARCHAR2(30):='EAM_PM_LAST_SERVICE_PUB';

37: -- Notes : Note text
38: --
39: -- End of comments
40:
41: G_PKG_NAME CONSTANT VARCHAR2(30):='EAM_PM_LAST_SERVICE_PUB';
42:
43:
44:
45: procedure validate_pm_last_service(p_meter_id in number, p_actv_assoc_id in number)

Line 153: from EAM_PM_LAST_SERVICE where meter_id = p_meter_id and activity_association_id = p_actv_assoc_id;

149:
150: CURSOR c_check_update(p_meter_id number, p_actv_assoc_id number)
151: IS
152: SELECT 'X'
153: from EAM_PM_LAST_SERVICE where meter_id = p_meter_id and activity_association_id = p_actv_assoc_id;
154:
155:
156: BEGIN
157: -- Standard Start of API savepoint

Line 195: INSERT INTO EAM_PM_LAST_SERVICE

191: open c_check_update(p_pm_last_service_tbl(i).meter_id,p_actv_assoc_id);
192: fetch c_check_update into l_dummy;
193: if c_check_update%NOTFOUND
194: THEN
195: INSERT INTO EAM_PM_LAST_SERVICE
196: (
197: METER_ID ,
198: ACTIVITY_ASSOCIATION_ID ,
199: LAST_SERVICE_READING ,

Line 225: UPDATE EAM_PM_LAST_SERVICE

221: fnd_global.user_id
222: );
223:
224: ELSE
225: UPDATE EAM_PM_LAST_SERVICE
226: SET
227: METER_ID = p_pm_last_service_tbl(i).METER_ID,
228: ACTIVITY_ASSOCIATION_ID = p_actv_assoc_id,
229: LAST_SERVICE_READING = p_pm_last_service_tbl(i).LAST_SERVICE_READING,

Line 293: END EAM_PM_LAST_SERVICE_PUB;

289: );
290: END process_pm_last_service;
291:
292:
293: END EAM_PM_LAST_SERVICE_PUB;