DBA Data[Home] [Help]

APPS.JL_BR_SPED_PKG dependencies on RA_INTERFACE_LINES_ALL

Line 101: TYPE HEADER_GDF_ATTR_TYPE IS TABLE OF RA_INTERFACE_LINES_ALL.HEADER_GDF_ATTRIBUTE1%TYPE;

97: Description : This function will be called from the core AR Autoinvoice program and the Copy Transactions program
98: for inserting the Electronic Invoice attributes in the JL_BR_CUSTOMER_TRX_EXTS extension table*/
99: FUNCTION COPY_GDF_ATTRIBUTES (P_REQUEST_ID IN NUMBER, P_CALLED_FROM IN VARCHAR2) RETURN NUMBER IS
100:
101: TYPE HEADER_GDF_ATTR_TYPE IS TABLE OF RA_INTERFACE_LINES_ALL.HEADER_GDF_ATTRIBUTE1%TYPE;
102: TYPE LINE_GDF_ATTR_TYPE IS TABLE OF RA_INTERFACE_LINES_ALL.LINE_GDF_ATTRIBUTE1%TYPE; --ER 9974789
103:
104: TYPE CUSTOMER_TRX_ID_TYPE IS TABLE OF RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE;
105: TYPE CUSTOMER_TRX_LINE_ID_TYPE IS TABLE OF RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE;

Line 102: TYPE LINE_GDF_ATTR_TYPE IS TABLE OF RA_INTERFACE_LINES_ALL.LINE_GDF_ATTRIBUTE1%TYPE; --ER 9974789

98: for inserting the Electronic Invoice attributes in the JL_BR_CUSTOMER_TRX_EXTS extension table*/
99: FUNCTION COPY_GDF_ATTRIBUTES (P_REQUEST_ID IN NUMBER, P_CALLED_FROM IN VARCHAR2) RETURN NUMBER IS
100:
101: TYPE HEADER_GDF_ATTR_TYPE IS TABLE OF RA_INTERFACE_LINES_ALL.HEADER_GDF_ATTRIBUTE1%TYPE;
102: TYPE LINE_GDF_ATTR_TYPE IS TABLE OF RA_INTERFACE_LINES_ALL.LINE_GDF_ATTRIBUTE1%TYPE; --ER 9974789
103:
104: TYPE CUSTOMER_TRX_ID_TYPE IS TABLE OF RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE;
105: TYPE CUSTOMER_TRX_LINE_ID_TYPE IS TABLE OF RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE;
106:

Line 283: FROM RA_INTERFACE_LINES_ALL GT,

279: JLEXT.HEADER_GDF_ATTRIBUTE36,
280: JLEXT.HEADER_GDF_ATTRIBUTE37,
281: JLEXT.HEADER_GDF_ATTRIBUTE38,
282: JLEXT.HEADER_GDF_ATTRIBUTE39 --BUG 11825724
283: FROM RA_INTERFACE_LINES_ALL GT,
284: RA_CUSTOMER_TRX TRX,
285: JL_BR_INTERFACE_LINES_EXTS JLEXT
286: WHERE TRX.REQUEST_ID = P_REQUEST_ID
287: AND GT.CUSTOMER_TRX_ID = TRX.CUSTOMER_TRX_ID

Line 328: RA_INTERFACE_LINES_ALL ARINT,

324: JLEXT.LINE_GDF_ATTRIBUTE48,
325: JLEXT.LINE_GDF_ATTRIBUTE49,
326: JLEXT.LINE_GDF_ATTRIBUTE50
327: FROM JL_BR_INTERFACE_LINES_EXTS JLEXT,
328: RA_INTERFACE_LINES_ALL ARINT,
329: RA_CUSTOMER_TRX TRX
330: WHERE TRX.REQUEST_ID = P_REQUEST_ID
331: AND ARINT.CUSTOMER_TRX_ID = TRX.CUSTOMER_TRX_ID
332: AND ARINT.ROWID = JLEXT.JL_BR_INTERFACE_LINK_ID;

Line 934: TYPE HEADER_GDF_ATTR_TYPE IS TABLE OF RA_INTERFACE_LINES_ALL.HEADER_GDF_ATTRIBUTE1%TYPE;

930: This function will insert the Electronic Invoice attributes IN THE JL_BR_CUSTOMER_TRX_EXTS
931: the the extension table */
932: FUNCTION COPY_GDF_ATTRIBUTES_API (P_CUSTOMER_TRX_ID IN NUMBER) RETURN NUMBER IS
933:
934: TYPE HEADER_GDF_ATTR_TYPE IS TABLE OF RA_INTERFACE_LINES_ALL.HEADER_GDF_ATTRIBUTE1%TYPE;
935: TYPE CUSTOMER_TRX_ID_TYPE IS TABLE OF RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE;
936: TYPE CUSTOMER_TRX_LINE_ID_TYPE IS TABLE OF RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE;
937: TYPE INDUSTRY_ATTRIBUTE_TYPE IS TABLE OF JL_BR_CUST_TRX_LINES_EXTS.INDUSTRY_ATTRIBUTE1%TYPE;
938: TYPE SERVICE_EXEC_DATE_TYPE IS TABLE OF JL_BR_INV_API_TRX_LINES_T.SRV_EXEC_DATE%TYPE; --BUG 11825724