APPS.JL_JLZZRCVI_XMLP_PKG dependencies on RA_CUSTOMER_TRX

Line 48: RA_CUSTOMER_TRX_PARTIAL_V RP

44: RP.GLOBAL_ATTRIBUTE_CATEGORY,
45: RP.GLOBAL_ATTRIBUTE20,
46: RP.DOC_SEQUENCE_VALUE DOC_SEQ_NUM
47: FROM
48: RA_CUSTOMER_TRX_PARTIAL_V RP
49: WHERE RP.BATCH_SOURCE_ID = P_IN_BATCH_SOURCE_ID
50: AND RP.CUST_TRX_TYPE_ID = NVL(P_IN_CUST_TRX_TYPE_ID
51: ,RP.CUST_TRX_TYPE_ID)
52: AND ( ( P_IN_NUMBER_TYPE = 'DOC_NUM'

Line 82: RA_CUSTOMER_TRX_PARTIAL_V RP

78: RP.GLOBAL_ATTRIBUTE_CATEGORY,
79: RP.GLOBAL_ATTRIBUTE20,
80: RP.DOC_SEQUENCE_VALUE DOC_SEQ_NUM
81: FROM
82: RA_CUSTOMER_TRX_PARTIAL_V RP
83: WHERE RP.BATCH_SOURCE_ID = P_IN_BATCH_SOURCE_ID
84: AND RP.CUST_TRX_TYPE_ID = NVL(P_IN_CUST_TRX_TYPE_ID
85: ,RP.CUST_TRX_TYPE_ID)
86: AND ( ( P_IN_NUMBER_TYPE = 'DOC_NUM'

Line 536: RA_CUSTOMER_TRX CT

532: SELECT
533: CT.CUSTOMER_TRX_ID,
534: CT.CUST_TRX_TYPE_ID
535: FROM
536: RA_CUSTOMER_TRX CT
537: WHERE CT.CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID;
538: CURSOR C_ORIG_TRX_GL_DIST_FOR_UPDATE IS
539: SELECT
540: CTGLD.CUSTOMER_TRX_ID

Line 556: L_TRX_REC RA_CUSTOMER_TRX%ROWTYPE;

552: L_CONC_LOGIN_ID NUMBER;
553: L_LOGIN_ID NUMBER;
554: L_PROG_APPL_ID NUMBER;
555: L_CONC_PROG_ID NUMBER;
556: L_TRX_REC RA_CUSTOMER_TRX%ROWTYPE;
557: BEGIN
558: L_USER_ID := FND_PROFILE.VALUE('USER_ID');
559: L_CONC_LOGIN_ID := FND_PROFILE.VALUE('CONC_LOGIN_ID');
560: L_LOGIN_ID := FND_PROFILE.VALUE('LOGIN_ID');

Line 829: RA_CUSTOMER_TRX_ALL

825: SELECT
826: MAX(DOC_SEQUENCE_VALUE)
827: INTO L_MAX_DOC_SEQ_NUM
828: FROM
829: RA_CUSTOMER_TRX_ALL
830: WHERE DOC_SEQUENCE_VALUE <= TO_NUMBER(P_NUMBER_HIGH);
831: IF L_MAX_DOC_SEQ_NUM < P_NUMBER_HIGH THEN
832: CP_ORIG_INV_NOT_FOUND_MESG := L_MAX_DOC_SEQ_NUM;
833: RETURN (TRUE);

Line 842: RA_CUSTOMER_TRX_ALL

838: SELECT
839: MAX(TRX_NUMBER)
840: INTO L_MAX_TRX_NUM
841: FROM
842: RA_CUSTOMER_TRX_ALL
843: WHERE TRX_NUMBER <= P_NUMBER_HIGH;
844: IF L_MAX_TRX_NUM < P_NUMBER_HIGH THEN
845: CP_ORIG_INV_NOT_FOUND_MESG := L_MAX_TRX_NUM;
846: RETURN (TRUE);