APPS.AR_INVOICE_API_PUB dependencies on RA_CUST_TRX_TYPES

Line 1106: ra_cust_trx_types.cust_trx_type_id%type

1102:
1103: PROCEDURE Cache_Transaction_Type(
1104: p_context_rec IN Context_Rec_Type,
1105: p_cust_trx_type_id IN
1106: ra_cust_trx_types.cust_trx_type_id%type
1107: ) IS
1108:
1109: l_temp BINARY_INTEGER;
1110: l_dummy_type ra_cust_trx_types%rowtype;

Line 1110: l_dummy_type ra_cust_trx_types%rowtype;

1106: ra_cust_trx_types.cust_trx_type_id%type
1107: ) IS
1108:
1109: l_temp BINARY_INTEGER;
1110: l_dummy_type ra_cust_trx_types%rowtype;
1111:
1112: BEGIN
1113:
1114: ar_invoice_utils.debug('Cache_Transaction_Type()+');

Line 1130: FROM ra_cust_trx_types

1126:
1127: BEGIN
1128: SELECT *
1129: INTO Type_Cache_Tbl( p_cust_trx_type_id )
1130: FROM ra_cust_trx_types
1131: WHERE cust_trx_type_id = p_cust_trx_type_id;
1132:
1133: ar_invoice_utils.debug('Transaction Type: ' ||
1134: Type_Cache_Tbl( p_cust_trx_type_id ).name ||

Line 1210: p_type_rec IN OUT NOCOPY ra_cust_trx_types%rowtype,

1206:
1207: PROCEDURE Get_Flags(
1208: p_context_rec IN Context_Rec_Type,
1209: p_trx_rec IN OUT NOCOPY ra_customer_trx%rowtype,
1210: p_type_rec IN OUT NOCOPY ra_cust_trx_types%rowtype,
1211: p_posted_flag IN OUT NOCOPY VARCHAR2,
1212: p_activity_flag IN OUT NOCOPY VARCHAR2,
1213: p_printed_flag IN OUT NOCOPY VARCHAR2,
1214: p_rev_recog_run_flag IN OUT NOCOPY VARCHAR2,

Line 1331: p_type_rec IN OUT NOCOPY ra_cust_trx_types%rowtype,

1327:
1328: PROCEDURE Validate_Delete_Transaction(
1329: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1330: p_trx_rec IN OUT NOCOPY ra_customer_trx%rowtype,
1331: p_type_rec IN OUT NOCOPY ra_cust_trx_types%rowtype,
1332: p_return_status OUT NOCOPY VARCHAR2
1333: ) IS
1334:
1335: l_context_rec Context_Rec_Type;

Line 1680: l_type_rec ra_cust_trx_types%rowtype;

1676: l_api_version CONSTANT NUMBER := 1.0;
1677: l_message VARCHAR2(1000);
1678: l_return_status VARCHAR2(10);
1679: l_trx_rec ra_customer_trx%rowtype;
1680: l_type_rec ra_cust_trx_types%rowtype;
1681: l_commitment_rec arp_process_commitment.commitment_rec_type;
1682: l_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
1683: l_amount ra_cust_trx_line_gl_dist.amount%type;
1684: l_dummy BINARY_INTEGER;

Line 2086: FROM ra_cust_Trx_types ctt,

2082: SELECT SUM(NVL(PS.AMOUNT_DUE_REMAINING, 0 )),
2083: SUM(NVL(PS.ACCTD_AMOUNT_DUE_REMAINING, 0 ))
2084: INTO x_amount_due_remaining,
2085: x_acctd_amount_due_remaining
2086: FROM ra_cust_Trx_types ctt,
2087: ra_customer_trx ct,
2088: ar_payment_schedules ps
2089: WHERE ctt.cust_Trx_type_id = ct.cust_trx_type_id
2090: AND ct.customer_trx_id = ps.customer_trx_id