DBA Data[Home] [Help]

APPS.AR_REVENUEADJUST_PUB dependencies on AR_LINE_CONTS

Line 866: ,p_contingency_id IN ar_line_conts.contingency_id%type DEFAULT NULL

862: ,x_msg_data OUT NOCOPY VARCHAR2
863: ,p_org_id IN NUMBER DEFAULT NULL
864: ,p_customer_trx_id IN ra_customer_trx.customer_trx_id%type
865: ,p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type DEFAULT NULL
866: ,p_contingency_id IN ar_line_conts.contingency_id%type DEFAULT NULL
867: ,p_expiration_date IN ar_line_conts.expiration_date%type DEFAULT NULL
868: ,p_expiration_days IN ar_line_conts.expiration_days%type DEFAULT NULL)
869: IS
870: l_api_name CONSTANT VARCHAR2(30) :=

Line 867: ,p_expiration_date IN ar_line_conts.expiration_date%type DEFAULT NULL

863: ,p_org_id IN NUMBER DEFAULT NULL
864: ,p_customer_trx_id IN ra_customer_trx.customer_trx_id%type
865: ,p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type DEFAULT NULL
866: ,p_contingency_id IN ar_line_conts.contingency_id%type DEFAULT NULL
867: ,p_expiration_date IN ar_line_conts.expiration_date%type DEFAULT NULL
868: ,p_expiration_days IN ar_line_conts.expiration_days%type DEFAULT NULL)
869: IS
870: l_api_name CONSTANT VARCHAR2(30) :=
871: 'Update_Contingency_Expirations';

Line 868: ,p_expiration_days IN ar_line_conts.expiration_days%type DEFAULT NULL)

864: ,p_customer_trx_id IN ra_customer_trx.customer_trx_id%type
865: ,p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type DEFAULT NULL
866: ,p_contingency_id IN ar_line_conts.contingency_id%type DEFAULT NULL
867: ,p_expiration_date IN ar_line_conts.expiration_date%type DEFAULT NULL
868: ,p_expiration_days IN ar_line_conts.expiration_days%type DEFAULT NULL)
869: IS
870: l_api_name CONSTANT VARCHAR2(30) :=
871: 'Update_Contingency_Expirations';
872: l_api_version CONSTANT NUMBER := 2.0;

Line 892: ar_line_conts lc,

888: 'SHIP_CONFIRM_DATE', trunc(t.ship_date_actual), NULL))
889: expiration_event_date
890: from ra_customer_trx t,
891: ra_customer_trx_lines tl,
892: ar_line_conts lc,
893: ar_deferral_reasons dr
894: where t.customer_trx_id = p_customer_trx_id
895: and t.customer_trx_id = tl.customer_trx_id
896: and tl.customer_trx_line_id = nvl(p_customer_trx_line_id,