APPS.FEM_PARTY_PROFITABILITY_PKG dependencies on FEM_PARTY_PROFITABILITY

Line 1: PACKAGE BODY FEM_PARTY_PROFITABILITY_PKG as

1: PACKAGE BODY FEM_PARTY_PROFITABILITY_PKG as
2: -- $Header: femprfTB.pls 120.0 2005/06/06 19:52:36 appldev noship $
3:
4:
5:

Line 83: CURSOR C IS SELECT rowid FROM FEM_PARTY_PROFITABILITY

79: x_LTD3 NUMBER,
80: x_LTD4 NUMBER,
81: x_LTD5 NUMBER
82: ) IS
83: CURSOR C IS SELECT rowid FROM FEM_PARTY_PROFITABILITY
84: WHERE PARTY_ID = x_PARTY_ID;
85:
86:
87: BEGIN

Line 90: INSERT INTO FEM_PARTY_PROFITABILITY(

86:
87: BEGIN
88:
89:
90: INSERT INTO FEM_PARTY_PROFITABILITY(
91: PARTY_ID,
92: LAST_UPDATE_DATE,
93: LAST_UPDATED_BY,
94: CREATION_DATE,

Line 256: DELETE FROM FEM_PARTY_PROFITABILITY

252: PROCEDURE Delete_Row(
253: x_PARTY_ID NUMBER
254: ) IS
255: BEGIN
256: DELETE FROM FEM_PARTY_PROFITABILITY
257: WHERE PARTY_ID = x_PARTY_ID;
258: If (SQL%NOTFOUND) then
259: RAISE NO_DATA_FOUND;
260: End If;

Line 344: Update FEM_PARTY_PROFITABILITY

340: x_LTD5 NUMBER
341: ) IS
342: BEGIN
343:
344: Update FEM_PARTY_PROFITABILITY
345: SET
346: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
347: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
348: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),

Line 508: FROM FEM_PARTY_PROFITABILITY

504: x_LTD5 NUMBER
505: ) IS
506: CURSOR C IS
507: SELECT *
508: FROM FEM_PARTY_PROFITABILITY
509: WHERE rowid = x_Rowid
510: FOR UPDATE of PARTY_ID NOWAIT;
511: Recinfo C%ROWTYPE;
512: BEGIN

Line 752: END FEM_PARTY_PROFITABILITY_PKG;

748: APP_EXCEPTION.RAISE_EXCEPTION;
749: End If;
750: END Lock_Row;
751:
752: END FEM_PARTY_PROFITABILITY_PKG;