DBA Data[Home] [Help]

APPS.JA_TH_AR_TAX_INVOICE dependencies on FND_DATE

Line 73: fnd_date.date_to_chardate(p_last_issued_date));

69: IF p_created_from = 'RAXTRX' THEN
70: fnd_message.set_name('JA','JA_TH_AR_INVALID_TRX_DATE');
71: fnd_message.set_token(
72: 'LAST_ISSUED_DATE',
73: fnd_date.date_to_chardate(p_last_issued_date));
74: fnd_message.set_token(
75: 'ADVANCED_DATE',
76: fnd_date.date_to_chardate(sysdate+nvl(p_advance_days,0)));
77:

Line 76: fnd_date.date_to_chardate(sysdate+nvl(p_advance_days,0)));

72: 'LAST_ISSUED_DATE',
73: fnd_date.date_to_chardate(p_last_issued_date));
74: fnd_message.set_token(
75: 'ADVANCED_DATE',
76: fnd_date.date_to_chardate(sysdate+nvl(p_advance_days,0)));
77:
78: IF insert_interface_errors(
79: p_customer_trx_id,
80: fnd_message.get,

Line 81: fnd_date.date_to_chardate(p_trx_date),

77:
78: IF insert_interface_errors(
79: p_customer_trx_id,
80: fnd_message.get,
81: fnd_date.date_to_chardate(p_trx_date),
82: 'validate_trx_date') THEN
83: return(0);
84: ELSE
85: return(-1);

Line 158: SET global_attribute2 = fnd_date.date_to_canonical(p_trx_date)

154:
155: FETCH last_issued_date INTO dummy;
156:
157: UPDATE ra_cust_trx_types
158: SET global_attribute2 = fnd_date.date_to_canonical(p_trx_date)
159: WHERE CURRENT OF last_issued_date;
160:
161: CLOSE last_issued_date;
162:

Line 183: fnd_date.date_to_chardate(p_trx_date),

179:
180: IF insert_interface_errors(
181: p_customer_trx_id,
182: fnd_message.get,
183: fnd_date.date_to_chardate(p_trx_date),
184: 'update_last_issued_date') THEN
185: return(0);
186: ELSE
187: return(-1);