DBA Data[Home] [Help]

APPS.RCV_ACCRUALUTILITIES_GRP dependencies on RCV_ACCRUALUTILITIES_GRP

Line 1: PACKAGE BODY RCV_AccrualUtilities_GRP AS

1: PACKAGE BODY RCV_AccrualUtilities_GRP AS
2: /* $Header: RCVGUTLB.pls 120.12.12020000.5 2012/12/21 10:43:10 yuyun ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'RCV_AccrualUtilities_GRP';
5: --G_DEBUG CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');

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

1: PACKAGE BODY RCV_AccrualUtilities_GRP AS
2: /* $Header: RCVGUTLB.pls 120.12.12020000.5 2012/12/21 10:43:10 yuyun ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'RCV_AccrualUtilities_GRP';
5: --G_DEBUG CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
6: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
7: G_LOG_HEAD CONSTANT VARCHAR2(40) := 'po.plsql.'||G_PKG_NAME;
8: G_MSG_LEVEL_THRESHOLD CONSTANT VARCHAR2(1):= FND_PROFILE.Value('FND_API_MSG_LEVEL_THRESHOLD');

Line 896: -- p_purge_in_rec IN RCV_AccrualUtilities_GRP.purge_in_rectype

892: -- Parameters :
893: -- p_purge_entity_type IN VARCHAR2
894: -- The table of which the entity is the primary identifier
895: -- Values: PO_HEADERS_ALL, RCV_TRANSACTIONS
896: -- p_purge_in_rec IN RCV_AccrualUtilities_GRP.purge_in_rectype
897: -- Contains the List of PO_HEADER_ID's to be evaluated
898: -- x_purge_out_rec OUT NOCOPY RCV_AccrualUtilities_GRP.purge_out_rectype
899: -- Contains c character ('Y'/'N') indicating whether records
900: -- for corresponding header_id's can be deleted or not

Line 898: -- x_purge_out_rec OUT NOCOPY RCV_AccrualUtilities_GRP.purge_out_rectype

894: -- The table of which the entity is the primary identifier
895: -- Values: PO_HEADERS_ALL, RCV_TRANSACTIONS
896: -- p_purge_in_rec IN RCV_AccrualUtilities_GRP.purge_in_rectype
897: -- Contains the List of PO_HEADER_ID's to be evaluated
898: -- x_purge_out_rec OUT NOCOPY RCV_AccrualUtilities_GRP.purge_out_rectype
899: -- Contains c character ('Y'/'N') indicating whether records
900: -- for corresponding header_id's can be deleted or not
901: ----------------------------------------------------------------------------------------------
902:

Line 911: p_purge_in_rec IN RCV_AccrualUtilities_GRP.purge_in_rectype,

907: x_return_status OUT NOCOPY VARCHAR2,
908: x_msg_count OUT NOCOPY NUMBER,
909: x_msg_data OUT NOCOPY VARCHAR2,
910: p_purge_entity_type IN VARCHAR2,
911: p_purge_in_rec IN RCV_AccrualUtilities_GRP.purge_in_rectype,
912: x_purge_out_rec OUT NOCOPY RCV_AccrualUtilities_GRP.purge_out_rectype
913: ) IS
914:
915: l_api_name constant varchar2(30) := 'Validate_PO_Purge';

Line 912: x_purge_out_rec OUT NOCOPY RCV_AccrualUtilities_GRP.purge_out_rectype

908: x_msg_count OUT NOCOPY NUMBER,
909: x_msg_data OUT NOCOPY VARCHAR2,
910: p_purge_entity_type IN VARCHAR2,
911: p_purge_in_rec IN RCV_AccrualUtilities_GRP.purge_in_rectype,
912: x_purge_out_rec OUT NOCOPY RCV_AccrualUtilities_GRP.purge_out_rectype
913: ) IS
914:
915: l_api_name constant varchar2(30) := 'Validate_PO_Purge';
916: l_api_version number := 1.0;

Line 990: -- p_purge_in_rec IN RCV_AccrualUtilities_GRP.purge_in_rectype

986: -- Parameters :
987: -- p_purge_entity_type IN VARCHAR2
988: -- The table of which the entity is the primary identifier
989: -- Values: PO_HEADERS_ALL, RCV_TRANSACTIONS
990: -- p_purge_in_rec IN RCV_AccrualUtilities_GRP.purge_in_rectype
991: -- Contains the List of PO_HEADER_ID's for which corresponding
992: -- records need to be deleted from RAE and RRS
993: ----------------------------------------------------------------------------------------------
994:

Line 1003: p_purge_in_rec IN RCV_AccrualUtilities_GRP.purge_in_rectype

999: x_return_status OUT NOCOPY VARCHAR2,
1000: x_msg_count OUT NOCOPY NUMBER,
1001: x_msg_data OUT NOCOPY VARCHAR2,
1002: p_purge_entity_type IN VARCHAR2,
1003: p_purge_in_rec IN RCV_AccrualUtilities_GRP.purge_in_rectype
1004: ) IS
1005:
1006: l_api_name constant varchar2(30) := 'Purge';
1007: l_api_version number := 1.0;

Line 1013: l_acct_events RCV_AccrualUtilities_GRP.TBL_NUM;

1009: l_stmt_num number;
1010: l_index binary_integer;
1011:
1012:
1013: l_acct_events RCV_AccrualUtilities_GRP.TBL_NUM;
1014:
1015: INCORRECT_ENTITY EXCEPTION;
1016: DELETE_FAILED EXCEPTION;
1017:

Line 1228: END RCV_AccrualUtilities_GRP;

1224: l_encReversalAmt := 0;
1225: return (l_encReversalAmt);
1226: END;
1227:
1228: END RCV_AccrualUtilities_GRP;