APPS.JL_BR_SPED_PKG dependencies on JL_BR_INV_API_TRX_LINES_T

Line 938: TYPE SERVICE_EXEC_DATE_TYPE IS TABLE OF JL_BR_INV_API_TRX_LINES_T.SRV_EXEC_DATE%TYPE; --BUG 11825724

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
939:
940: CUSTOMER_TRX_LINE_ID CUSTOMER_TRX_LINE_ID_TYPE;
941: CUSTOMER_TRX_ID CUSTOMER_TRX_ID_TYPE;
942: CUST_TRX_ID CUSTOMER_TRX_ID_TYPE; --BUG 10184720

Line 1034: JL_BR_INV_API_TRX_LINES_T T

1030: T.TOWING_VEH_PLATE_NUMBER5,
1031: T.TOWING_VEH_PLATE_STATE_CODE5,
1032: T.SRV_EXEC_DATE --BUG 11825724
1033: FROM AR_TRX_HEADER_GT GT,
1034: JL_BR_INV_API_TRX_LINES_T T
1035: WHERE GT.CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID
1036: AND GT.TRX_HEADER_ID = T.TRX_HEADER_ID
1037: AND T.TRX_LINE_ID IS NULL; --bug 10265440
1038:

Line 1072: FROM JL_BR_INV_API_TRX_LINES_T T,

1068: T.INDUSTRY_ATTRIBUTE27,
1069: T.INDUSTRY_ATTRIBUTE28,
1070: T.INDUSTRY_ATTRIBUTE29,
1071: T.INDUSTRY_ATTRIBUTE30
1072: FROM JL_BR_INV_API_TRX_LINES_T T,
1073: AR_TRX_LINES_GT ARGT
1074: WHERE T.TRX_LINE_ID = ARGT.TRX_LINE_ID
1075: AND T.TRX_HEADER_ID = ARGT.TRX_HEADER_ID
1076: AND ARGT.CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID;

Line 1334: DELETE FROM JL_BR_INV_API_TRX_LINES_T

1330:
1331: END IF;
1332: -- Deleting Data from Temporary table once it has been copied to core JL table
1333: -- BUG 10184720
1334: DELETE FROM JL_BR_INV_API_TRX_LINES_T
1335: WHERE TRX_HEADER_ID IN (SELECT TRX_HEADER_ID FROM AR_TRX_HEADER_GT
1336: WHERE CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID);
1337: END IF; -- main IF country code = 'BR'
1338: