APPS.JA_JAINRECI_XMLP_PKG dependencies on RCV_TRANSACTIONS

Line 11: RCV_TRANSACTIONS

7: CURRENCY_CONVERSION_RATE,
8: TRANSACTION_TYPE,
9: PO_HEADER_ID
10: FROM
11: RCV_TRANSACTIONS
12: WHERE TRANSACTION_ID = PARENT_TRANSACTION_ID;
13: V_PARENT_REC PARENT_CUR%ROWTYPE;
14: BEGIN
15: OPEN PARENT_CUR;

Line 38: V_CONV_FACTOR RCV_TRANSACTIONS.CURRENCY_CONVERSION_RATE%TYPE;

34: FUNCTION CF_2FORMULA(PARENT_TRANSACTION_ID IN NUMBER
35: ,SHIPMENT_LINE_ID IN NUMBER
36: ,CF_CURRENCY_CODE IN VARCHAR2
37: ,PRIMARY_QUANTITY IN NUMBER) RETURN NUMBER IS
38: V_CONV_FACTOR RCV_TRANSACTIONS.CURRENCY_CONVERSION_RATE%TYPE;
39: V_CVD_AMT NUMBER;
40: V_CURRENCY_CONVERSION_RATE RCV_TRANSACTIONS.CURRENCY_CONVERSION_RATE%TYPE;
41: LN_VAT_TAX NUMBER;
42: CURSOR PARENT_CUR IS

Line 40: V_CURRENCY_CONVERSION_RATE RCV_TRANSACTIONS.CURRENCY_CONVERSION_RATE%TYPE;

36: ,CF_CURRENCY_CODE IN VARCHAR2
37: ,PRIMARY_QUANTITY IN NUMBER) RETURN NUMBER IS
38: V_CONV_FACTOR RCV_TRANSACTIONS.CURRENCY_CONVERSION_RATE%TYPE;
39: V_CVD_AMT NUMBER;
40: V_CURRENCY_CONVERSION_RATE RCV_TRANSACTIONS.CURRENCY_CONVERSION_RATE%TYPE;
41: LN_VAT_TAX NUMBER;
42: CURSOR PARENT_CUR IS
43: SELECT
44: CURRENCY_CODE,

Line 50: RCV_TRANSACTIONS

46: TRANSACTION_TYPE,
47: PRIMARY_QUANTITY,
48: PO_HEADER_ID
49: FROM
50: RCV_TRANSACTIONS
51: WHERE TRANSACTION_ID = PARENT_TRANSACTION_ID;
52: V_PARENT_REC PARENT_CUR%ROWTYPE;
53: BEGIN
54: OPEN PARENT_CUR;

Line 452: JAI_RCV_TRANSACTIONS JIRT

448: SELECT
449: JIRT.VAT_INVOICE_NO,
450: JIRT.VAT_INVOICE_DATE
451: FROM
452: JAI_RCV_TRANSACTIONS JIRT
453: WHERE JIRT.TRANSACTION_ID = P_TRANSACTION_ID;
454: BEGIN
455: OPEN LCU_GET_VAT_DETAILS(P_TRANSACTION_ID => TRANSACTION_ID);
456: FETCH LCU_GET_VAT_DETAILS