APPS.JMF_GTA_SPLIT_TRX_PROC dependencies on RA_CUST_TRX_TYPES_ALL

Line 154: l_trx_type ra_cust_trx_types_all.type%TYPE;

150: l_trx_rate_index NUMBER; -- loop index of l_gta_rate_trx
151: l_trx_line_index NUMBER; -- loop index of trx lines
152: l_result BOOLEAN;
153:
154: l_trx_type ra_cust_trx_types_all.type%TYPE;
155: l_fp_reg_num jmf_gta_trx_headers_all.fp_tax_registration_number%TYPE;
156:
157: l_trx_group_number NUMBER;
158:

Line 1188: , ra_cust_trx_types_all ctt

1184: INTO
1185: l_trx_type
1186: FROM
1187: ra_customer_trx_all h
1188: , ra_cust_trx_types_all ctt
1189: WHERE ctt.cust_trx_type_id = h.cust_trx_type_id
1190: AND ctt.Org_Id = h.Org_Id
1191: AND h.customer_trx_id = p_gta_trx_rec.trx_header.ra_trx_id;
1192: EXCEPTION

Line 1550: -- x_trx_type out ra_cust_trx_types_all.type%TYPE

1546: -- get trx type by trx id
1547: -- PARAMETERS:
1548: -- p_org_id IN NUMBER
1549: -- p_gta_trx in JMF_GTA_TRX_UTIL.trx_tbl_type
1550: -- x_trx_type out ra_cust_trx_types_all.type%TYPE
1551: -- HISTORY:
1552: -- 10-Sep-2005 : Jim.Zheng Create
1553: --=============================================================================
1554: PROCEDURE get_trx_type

Line 1557: , x_trx_type OUT NOCOPY ra_cust_trx_types_all.type%TYPE

1553: --=============================================================================
1554: PROCEDURE get_trx_type
1555: (p_org_id IN NUMBER
1556: , p_gta_trx IN Jmf_Gta_Trx_Util.trx_rec_type
1557: , x_trx_type OUT NOCOPY ra_cust_trx_types_all.type%TYPE
1558: )
1559: IS
1560:
1561: l_procedure_name VARCHAR2(30) := 'get_trx_type';

Line 1563: l_trx_type ra_cust_trx_types_all.type%TYPE;

1559: IS
1560:
1561: l_procedure_name VARCHAR2(30) := 'get_trx_type';
1562: l_trx_id ra_customer_trx_all.customer_trx_id%TYPE;
1563: l_trx_type ra_cust_trx_types_all.type%TYPE;
1564: BEGIN
1565: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1566: THEN
1567: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE

Line 1582: ,ra_cust_trx_types_all ctt

1578: INTO
1579: l_trx_type
1580: FROM
1581: ra_customer_trx_all h
1582: ,ra_cust_trx_types_all ctt
1583: WHERE h.CUST_TRX_TYPE_ID = ctt.CUST_TRX_TYPE_ID(+)
1584: AND ctt.TYPE IN ('INV', 'CM', 'DM')
1585: AND ctt.org_id = p_org_id
1586: AND h.customer_trx_id = l_trx_id;