eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_CMN_RGM_PROCESSING_PKG dependencies on FND_DATE

Line 40: to date fromat using fnd_date.canonical_to_date function.

36: and it is passed as character value.
37: Fix :-
38: Procedure signature modified to convert p_trx_from_date, p_trx_from_date from date to
39: pv_trx_from_date, pv_trx_from_date varchar2. And the varchar2 values are converted back
40: to date fromat using fnd_date.canonical_to_date function.
41:
42: 4. 14/04/2005 ssumaith - bug# 4284505 - File version 115.3
43:
44: Added code to pick the third party taxes from the jai_Rcv_tp_inv_details table in case of

Line 667: p_trx_from_date DATE; -- DEFAULT fnd_date.canonical_to_date(pv_trx_from_date) File.Sql.35 by Brathod

663: lv_process_flag VARCHAR2(2);
664: lv_process_message VARCHAR2(1000);
665:
666: /* Brathod, for Bug# 4286646*/
667: p_trx_from_date DATE; -- DEFAULT fnd_date.canonical_to_date(pv_trx_from_date) File.Sql.35 by Brathod
668: p_trx_till_date DATE; -- DEFAULT fnd_date.canonical_to_date(pv_trx_till_date) File.Sql.35 by Brathod
669: /*End of Bug# 4286646 */
670:
671: CURSOR c_regime_orgs(cp_regime_id IN NUMBER, cp_orgn_type IN VARCHAR2, cp_registration_num IN VARCHAR2,p_att_type_code jai_rgm_registrations.attribute_type_code%TYPE,cp_organization_id IN NUMBER ) IS/*Bug 5879769 bduvarag*/

Line 668: p_trx_till_date DATE; -- DEFAULT fnd_date.canonical_to_date(pv_trx_till_date) File.Sql.35 by Brathod

664: lv_process_message VARCHAR2(1000);
665:
666: /* Brathod, for Bug# 4286646*/
667: p_trx_from_date DATE; -- DEFAULT fnd_date.canonical_to_date(pv_trx_from_date) File.Sql.35 by Brathod
668: p_trx_till_date DATE; -- DEFAULT fnd_date.canonical_to_date(pv_trx_till_date) File.Sql.35 by Brathod
669: /*End of Bug# 4286646 */
670:
671: CURSOR c_regime_orgs(cp_regime_id IN NUMBER, cp_orgn_type IN VARCHAR2, cp_registration_num IN VARCHAR2,p_att_type_code jai_rgm_registrations.attribute_type_code%TYPE,cp_organization_id IN NUMBER ) IS/*Bug 5879769 bduvarag*/
672: SELECT a.organization_id org_id,a.location_id /*Bug 5879769 bduvarag*/

Line 699: p_trx_from_date := fnd_date.canonical_to_date(pv_trx_from_date); --File.Sql.35 by Brathod

695: ln_org_id NUMBER; /*5694855*/
696: /*Bug 5879769 bduvarag End*/
697: BEGIN
698:
699: p_trx_from_date := fnd_date.canonical_to_date(pv_trx_from_date); --File.Sql.35 by Brathod
700: p_trx_till_date := fnd_date.canonical_to_date(pv_trx_till_date); --File.Sql.35 by Brathod
701:
702: FND_FILE.put_line(fnd_file.log,'Value of from date is '||p_trx_from_date);
703: FND_FILE.put_line(fnd_file.log,'Value of from date is '||p_trx_till_date);

Line 700: p_trx_till_date := fnd_date.canonical_to_date(pv_trx_till_date); --File.Sql.35 by Brathod

696: /*Bug 5879769 bduvarag End*/
697: BEGIN
698:
699: p_trx_from_date := fnd_date.canonical_to_date(pv_trx_from_date); --File.Sql.35 by Brathod
700: p_trx_till_date := fnd_date.canonical_to_date(pv_trx_till_date); --File.Sql.35 by Brathod
701:
702: FND_FILE.put_line(fnd_file.log,'Value of from date is '||p_trx_from_date);
703: FND_FILE.put_line(fnd_file.log,'Value of from date is '||p_trx_till_date);
704:

Line 1760: p_delivery_date_from DATE DEFAULT fnd_date.canonical_to_date(pv_delivery_date_from);

1756:
1757: /*end bug 4702156*/
1758:
1759: -- Harshita for Bug 4918870
1760: p_delivery_date_from DATE DEFAULT fnd_date.canonical_to_date(pv_delivery_date_from);
1761: p_delivery_date_to DATE DEFAULT fnd_date.canonical_to_date(pv_delivery_date_to);
1762:
1763: BEGIN
1764: /*

Line 1761: p_delivery_date_to DATE DEFAULT fnd_date.canonical_to_date(pv_delivery_date_to);

1757: /*end bug 4702156*/
1758:
1759: -- Harshita for Bug 4918870
1760: p_delivery_date_from DATE DEFAULT fnd_date.canonical_to_date(pv_delivery_date_from);
1761: p_delivery_date_to DATE DEFAULT fnd_date.canonical_to_date(pv_delivery_date_to);
1762:
1763: BEGIN
1764: /*
1765: ||aiyer for the bug 5369250

Line 1768: ld_override_invoice_date := fnd_date.canonical_to_date(p_override_invoice_date);

1764: /*
1765: ||aiyer for the bug 5369250
1766: ||convert from canonical to date format
1767: */
1768: ld_override_invoice_date := fnd_date.canonical_to_date(p_override_invoice_date);
1769: lv_inv_num_already_generated := jai_constants.value_false; -- File.Sql.35 by Brathod
1770: lv_debug := NVL(P_DEBUG,jai_constants.no);
1771: ln_current_party_id := -9999;
1772: ln_current_party_site_id := -9999;