APPS.EAM_WOLCOSTING_PUB dependencies on CST_EAM_HIERARCHY_SNAPSHOT

Line 6: -- Function : Insert the hierarchy into the CST_EAM_HIERARCHY_SNAPSHOT table.

2: /* $Header: EAMWWOHB.pls 115.7 2004/04/02 03:35:41 samjain noship $ */
3: -- Start of comments
4: -- API name : insert_into_snapshot_pub
5: -- Type : Private.
6: -- Function : Insert the hierarchy into the CST_EAM_HIERARCHY_SNAPSHOT table.
7: -- Pre-reqs : None.
8: -- Parameters :
9: -- IN p_api_version IN NUMBER
10: -- p_init_msg_list VARCHAR2:= FND_API.G_FALSE

Line 102: -- Insert the data into the cst_eam_hierarchy_snapshot table

98: x_return_status := FND_API.g_ret_sts_success;
99:
100: -- API body
101:
102: -- Insert the data into the cst_eam_hierarchy_snapshot table
103:
104: SELECT MTL_EAM_ASSET_ACTIVITIES_S.nextval INTO x_group_id
105: FROM DUAL;
106:

Line 110: INSERT INTO CST_EAM_HIERARCHY_SNAPSHOT(

106:
107: -- Insert only the top level workorder in questin as level 0 for rollup cost.
108:
109:
110: INSERT INTO CST_EAM_HIERARCHY_SNAPSHOT(
111: GROUP_ID,
112: OBJECT_ID,
113: OBJECT_TYPE,
114: PARENT_OBJECT_ID,

Line 149: INSERT INTO CST_EAM_HIERARCHY_SNAPSHOT(

145: /* CHECK TO AVOID DUPLICATION OF THE SAME WORKORDER.
146: * IF NOT ALREADY INSERTED THEN ONLY IT SHOULD BE INSERTED
147: */
148:
149: INSERT INTO CST_EAM_HIERARCHY_SNAPSHOT(
150: GROUP_ID,
151: OBJECT_ID,
152: OBJECT_TYPE,
153: PARENT_OBJECT_ID,