DBA Data[Home] [Help]

APPS.XTR_XTRUPREP_XMLP_PKG dependencies on XTR_CFLOW_UPDATED_RECORDS

Line 41: XTR_CFLOW_UPDATED_RECORDS

37: SELECT
38: count(*)
39: INTO L_COUNT
40: FROM
41: XTR_CFLOW_UPDATED_RECORDS
42: WHERE CASHFLOW_REQUEST_DETAILS_ID = P_CFLOW_REQUEST_DETAILS_ID;
43: EXCEPTION
44: WHEN OTHERS THEN
45: FND_MESSAGE.SET_NAME('XTR'

Line 63: XTR_CFLOW_UPDATED_RECORDS

59: SELECT
60: 'Y'
61: INTO P_NO_RECORDS_UPDATED
62: FROM
63: XTR_CFLOW_UPDATED_RECORDS
64: WHERE CASHFLOW_REQUEST_DETAILS_ID = P_CFLOW_REQUEST_DETAILS_ID
65: AND MESSAGE_NAME = 'XTR_CFLOW_ACCT_UNAUTHORIZED';
66: IF (NVL(P_NO_RECORDS_UPDATED
67: ,'N') = 'Y') THEN

Line 85: XTR_CFLOW_UPDATED_RECORDS

81: SELECT
82: 'Y'
83: INTO P_NO_RECORDS_UPDATED
84: FROM
85: XTR_CFLOW_UPDATED_RECORDS
86: WHERE CASHFLOW_REQUEST_DETAILS_ID = P_CFLOW_REQUEST_DETAILS_ID
87: AND MESSAGE_NAME = 'XTR_CFLOW_CURRENCY_MISMATCH';
88: IF (NVL(P_NO_RECORDS_UPDATED
89: ,'N') = 'Y') THEN