APPS.PA_PAAPIMPR_XMLP_PKG dependencies on PA_PAAPIMPR_XMLP_PKG

Line 1: PACKAGE BODY PA_PAAPIMPR_XMLP_PKG AS

1: PACKAGE BODY PA_PAAPIMPR_XMLP_PKG AS
2: /* $Header: PAAPIMPRB.pls 120.0 2008/01/02 09:57:49 krreddy noship $ */
3: FUNCTION GET_COVER_PAGE_VALUES RETURN BOOLEAN IS
4: BEGIN
5: RETURN (TRUE);

Line 108: AND BATCH_NAME = NVL(PA_PAAPIMPR_XMLP_PKG.BATCH_NAME

104: INTERFACE_ID
105: FROM
106: PA_TRANSACTION_INTERFACE
107: WHERE TRANSACTION_SOURCE = REC_C1.TRANSACTION_SOURCE
108: AND BATCH_NAME = NVL(PA_PAAPIMPR_XMLP_PKG.BATCH_NAME
109: ,BATCH_NAME)
110: AND SYSTEM_LINKAGE = PA_PAAPIMPR_XMLP_PKG.SYSTEM_LINKAGE
111: AND ORIG_TRANSACTION_REFERENCE = ORIGINAL_TRANSACTION_REFERENCE )
112: AND STATUS = 'PROCESSED';

Line 110: AND SYSTEM_LINKAGE = PA_PAAPIMPR_XMLP_PKG.SYSTEM_LINKAGE

106: PA_TRANSACTION_INTERFACE
107: WHERE TRANSACTION_SOURCE = REC_C1.TRANSACTION_SOURCE
108: AND BATCH_NAME = NVL(PA_PAAPIMPR_XMLP_PKG.BATCH_NAME
109: ,BATCH_NAME)
110: AND SYSTEM_LINKAGE = PA_PAAPIMPR_XMLP_PKG.SYSTEM_LINKAGE
111: AND ORIG_TRANSACTION_REFERENCE = ORIGINAL_TRANSACTION_REFERENCE )
112: AND STATUS = 'PROCESSED';
113: IF REC_C1.PURGEABLE_FLAG = 'Y' THEN
114: DELETE FROM PA_TRANSACTION_INTERFACE

Line 116: AND BATCH_NAME = NVL(PA_PAAPIMPR_XMLP_PKG.BATCH_NAME

112: AND STATUS = 'PROCESSED';
113: IF REC_C1.PURGEABLE_FLAG = 'Y' THEN
114: DELETE FROM PA_TRANSACTION_INTERFACE
115: WHERE TRANSACTION_SOURCE = REC_C1.TRANSACTION_SOURCE
116: AND BATCH_NAME = NVL(PA_PAAPIMPR_XMLP_PKG.BATCH_NAME
117: ,BATCH_NAME)
118: AND SYSTEM_LINKAGE = PA_PAAPIMPR_XMLP_PKG.SYSTEM_LINKAGE
119: AND ORIG_TRANSACTION_REFERENCE = ORIGINAL_TRANSACTION_REFERENCE
120: AND ( NVL(TRANSACTION_REJECTION_CODE

Line 118: AND SYSTEM_LINKAGE = PA_PAAPIMPR_XMLP_PKG.SYSTEM_LINKAGE

114: DELETE FROM PA_TRANSACTION_INTERFACE
115: WHERE TRANSACTION_SOURCE = REC_C1.TRANSACTION_SOURCE
116: AND BATCH_NAME = NVL(PA_PAAPIMPR_XMLP_PKG.BATCH_NAME
117: ,BATCH_NAME)
118: AND SYSTEM_LINKAGE = PA_PAAPIMPR_XMLP_PKG.SYSTEM_LINKAGE
119: AND ORIG_TRANSACTION_REFERENCE = ORIGINAL_TRANSACTION_REFERENCE
120: AND ( NVL(TRANSACTION_REJECTION_CODE
121: ,'-99') not in ( 'GMS_EXP_ITEM_DT_BEFORE_AWD_ST' , 'GMS_EXP_ITEM_DT_AFTER_AWD_END' , 'GMS_AWARD_IS_CLOSED' , 'EXP_TYPE_INACTIVE'
122: , 'ETYPE_SLINK_INACTIVE' , 'PA_EX_PROJECT_DATE' , 'PA_EXP_TASK_EFF' , 'PA_EXP_ORG_NOT_ACTIVE' , 'NO_ASSIGNMENT' , 'PA_REJECTED_PARENT_RECORD' )

Line 187: END PA_PAAPIMPR_XMLP_PKG;

183: BEGIN
184: RETURN CP_FUNC_CURRENCY_CODE;
185: END CP_FUNC_CURRENCY_CODE_P;
186:
187: END PA_PAAPIMPR_XMLP_PKG;
188: