APPS.FEM_PARTY_PROFITABILITY_PUB dependencies on FEM_PARTY_PROFITABILITY

Line 1: package body FEM_PARTY_PROFITABILITY_PUB AS

1: package body FEM_PARTY_PROFITABILITY_PUB AS
2: /* $Header: femprfSB.pls 120.0 2005/06/06 20:46:56 appldev noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FEM_PARTY_PROFITABILITY_PUB';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FEM_PARTY_PROFITABILITY_PUB';

1: package body FEM_PARTY_PROFITABILITY_PUB AS
2: /* $Header: femprfSB.pls 120.0 2005/06/06 20:46:56 appldev noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FEM_PARTY_PROFITABILITY_PUB';
5:
6: procedure do_create_profitability(
7: p_profitability_rec IN PROFITABILITY_REC_TYPE,
8: x_party_id OUT NOCOPY NUMBER,

Line 24: p_profitability_rec IN FEM_PARTY_profitability_pub.profitability_rec_type,

20: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL
21: );
22:
23: procedure validate_profitability(
24: p_profitability_rec IN FEM_PARTY_profitability_pub.profitability_rec_type,
25: create_update_flag IN VARCHAR2,
26: x_return_status IN OUT NOCOPY VARCHAR2
27: );
28:

Line 31: x_profitability_rec OUT NOCOPY FEM_PARTY_profitability_pub.profitability_rec_type

27: );
28:
29: procedure get_current_profitability(
30: p_party_id IN NUMBER,
31: x_profitability_rec OUT NOCOPY FEM_PARTY_profitability_pub.profitability_rec_type
32: );
33:
34:
35:

Line 426: x_profitability_rec OUT NOCOPY FEM_PARTY_profitability_pub.profitability_rec_type

422: +===========================================================================*/
423:
424: procedure get_current_profitability(
425: p_party_id IN NUMBER,
426: x_profitability_rec OUT NOCOPY FEM_PARTY_profitability_pub.profitability_rec_type
427: ) IS
428: LAST_UPDATE_DATE DATE;
429: LAST_UPDATED_BY NUMBER;
430: CREATION_DATE DATE;

Line 469: FROM FEM_PARTY_profitability

465: CREATION_DATE,
466: LAST_UPDATED_BY,
467: LAST_UPDATE_DATE,
468: LAST_UPDATE_LOGIN
469: FROM FEM_PARTY_profitability
470: WHERE party_id = p_party_id;
471: */
472: END get_current_profitability;
473:

Line 519: FEM_PARTY_PROFITABILITY_PKG.INSERT_ROW(

515: END IF;
516:
517: --Call table-handler.
518:
519: FEM_PARTY_PROFITABILITY_PKG.INSERT_ROW(
520: x_Rowid => l_Rowid,
521: x_PARTY_ID => p_profitability_rec.PARTY_ID,
522: X_LAST_UPDATE_DATE => p_profitability_rec.LAST_UPDATE_DATE,
523: X_LAST_UPDATED_BY => p_profitability_rec.LAST_UPDATED_BY,

Line 637: -- record in FEM_PARTY_PROFITABILITY for

633: x_return_status IN OUT NOCOPY VARCHAR2,
634: p_validation_level NUMBER:= FND_API.G_VALID_LEVEL_FULL
635: ) IS
636: exist_last_update_date DATE; -- last_update_date of existing
637: -- record in FEM_PARTY_PROFITABILITY for
638: -- same party_id
639: l_rowid ROWID;
640: l_key VARCHAR2(2000);
641: l_party_id NUMBER;

Line 714: FROM FEM_PARTY_profitability

710:
711: ----------------------------------------------------------------------
712: /*
713: SELECT last_update_date INTO l_last_update_date
714: FROM FEM_PARTY_profitability
715: WHERE party_id = p_profitability_rec.party_id
716: AND to_char(p_last_update_date, 'DD-MON-YYYY HH:MI:SS') =
717: to_char(last_update_date, 'DD-MON-YYYY HH:MI:SS')
718: FOR UPDATE OF party_id NOWAIT;

Line 722: FND_MESSAGE.SET_TOKEN('TABLE', 'FEM_PARTY_PROFITABILITY');

718: FOR UPDATE OF party_id NOWAIT;
719:
720: EXCEPTION WHEN NO_DATA_FOUND THEN
721: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
722: FND_MESSAGE.SET_TOKEN('TABLE', 'FEM_PARTY_PROFITABILITY');
723: FND_MSG_PUB.ADD;
724: RAISE FND_API.G_EXC_ERROR; */
725: -----------------------------------------------------------------------
726:

Line 736: FROM FEM_PARTY_profitability

732: END IF;
733:
734: --Set value for geometry and rowid
735: SELECT rowid INTO l_rowid
736: FROM FEM_PARTY_profitability
737: WHERE party_id = p_profitability_rec.party_id;
738:
739: ----------------------------------------------------------------------
740: /*

Line 747: FEM_PARTY_PROFITABILITY_PKG.UPDATE_ROW(

743: ----------------------------------------------------------------------
744:
745: --Call to table-handler.
746:
747: FEM_PARTY_PROFITABILITY_PKG.UPDATE_ROW(
748: x_Rowid => l_Rowid,
749: x_PARTY_ID => p_profitability_rec.PARTY_ID,
750: X_LAST_UPDATE_DATE => p_profitability_rec.last_update_date,
751: X_LAST_UPDATED_BY => p_profitability_rec.LAST_UPDATED_BY,

Line 861: p_profitability_rec IN FEM_PARTY_profitability_pub.profitability_rec_type,

857: |
858: +===========================================================================*/
859:
860: procedure validate_profitability(
861: p_profitability_rec IN FEM_PARTY_profitability_pub.profitability_rec_type,
862: create_update_flag IN VARCHAR2,
863: x_return_status IN OUT NOCOPY VARCHAR2
864: ) IS
865:

Line 882: END FEM_PARTY_PROFITABILITY_PUB;

878: END validate_profitability;
879:
880:
881:
882: END FEM_PARTY_PROFITABILITY_PUB;