163: PROCEDURE validate_and_default_gl_date(
164: p_gl_date IN date,
165: p_trx_date IN date,
166: p_invoicing_rule_id IN
167: ra_customer_trx.invoicing_rule_id%type,
168: p_default_gl_date IN OUT NOCOPY date)
169: IS
170:
171: l_result boolean;
307: p_old_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
308: p_new_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
309: p_header_gl_date IN date,
310: p_trx_date IN date,
311: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
312: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
313: p_currency_code IN fnd_currencies.currency_code%type,
314: p_precision IN fnd_currencies.precision%type,
315: p_mau IN
308: p_new_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
309: p_header_gl_date IN date,
310: p_trx_date IN date,
311: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
312: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
313: p_currency_code IN fnd_currencies.currency_code%type,
314: p_precision IN fnd_currencies.precision%type,
315: p_mau IN
316: fnd_currencies.minimum_accountable_unit%type
534: p_old_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
535: p_new_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
536: p_header_gl_date IN date,
537: p_trx_date IN date,
538: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
539: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
540: p_currency_code IN fnd_currencies.currency_code%type,
541: p_precision IN fnd_currencies.precision%type,
542: p_mau IN
535: p_new_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
536: p_header_gl_date IN date,
537: p_trx_date IN date,
538: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
539: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
540: p_currency_code IN fnd_currencies.currency_code%type,
541: p_precision IN fnd_currencies.precision%type,
542: p_mau IN
543: fnd_currencies.minimum_accountable_unit%type
910: PROCEDURE insert_dist(
911: p_form_name IN varchar2,
912: p_form_version IN number,
913: p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
914: p_exchange_rate IN ra_customer_trx.exchange_rate%type DEFAULT 1,
915: p_currency_code IN fnd_currencies.currency_code%type DEFAULT null,
916: p_precision IN fnd_currencies.precision%type DEFAULT null,
917: p_mau IN fnd_currencies.minimum_accountable_unit%type
918: DEFAULT null,
1060: p_form_version IN number,
1061: p_backout_flag IN boolean,
1062: p_cust_trx_line_gl_dist_id IN
1063: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,
1064: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1065: p_dist_rec IN OUT NOCOPY ra_cust_trx_line_gl_dist%rowtype,
1066: p_header_gl_date IN date,
1067: p_trx_date IN date,
1068: p_invoicing_rule_id IN
1065: p_dist_rec IN OUT NOCOPY ra_cust_trx_line_gl_dist%rowtype,
1066: p_header_gl_date IN date,
1067: p_trx_date IN date,
1068: p_invoicing_rule_id IN
1069: ra_customer_trx.invoicing_rule_id%type,
1070: p_backout_done_flag OUT NOCOPY boolean,
1071: p_exchange_rate IN ra_customer_trx.exchange_rate%type
1072: DEFAULT 1,
1073: p_currency_code IN fnd_currencies.currency_code%type
1067: p_trx_date IN date,
1068: p_invoicing_rule_id IN
1069: ra_customer_trx.invoicing_rule_id%type,
1070: p_backout_done_flag OUT NOCOPY boolean,
1071: p_exchange_rate IN ra_customer_trx.exchange_rate%type
1072: DEFAULT 1,
1073: p_currency_code IN fnd_currencies.currency_code%type
1074: DEFAULT null,
1075: p_precision IN fnd_currencies.precision%type
1257: l_open_rec,
1258: l_ctt_type,
1259: l_previous_customer_trx_id
1260: FROM ra_cust_trx_types ctt,
1261: ra_customer_trx ct
1262: WHERE ct.customer_trx_id = p_customer_trx_id
1263: AND ct.cust_trx_type_id = ctt.cust_trx_type_id;
1264: EXCEPTION
1265: WHEN OTHERS THEN
1471: p_form_name IN varchar2,
1472: p_form_version IN number,
1473: p_cust_trx_line_gl_dist_id IN
1474: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,
1475: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1476: p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype)
1477: IS
1478:
1479: