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 1550: p_trx_from_date DATE; -- DEFAULT fnd_date.canonical_to_date(pv_trx_from_date) File.Sql.35 by Brathod

1546: lv_process_flag VARCHAR2(2);
1547: lv_process_message VARCHAR2(1000);
1548:
1549: /* Brathod, for Bug# 4286646*/
1550: p_trx_from_date DATE; -- DEFAULT fnd_date.canonical_to_date(pv_trx_from_date) File.Sql.35 by Brathod
1551: p_trx_till_date DATE; -- DEFAULT fnd_date.canonical_to_date(pv_trx_till_date) File.Sql.35 by Brathod
1552: /*End of Bug# 4286646 */
1553:
1554: 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 1551: p_trx_till_date DATE; -- DEFAULT fnd_date.canonical_to_date(pv_trx_till_date) File.Sql.35 by Brathod

1547: lv_process_message VARCHAR2(1000);
1548:
1549: /* Brathod, for Bug# 4286646*/
1550: p_trx_from_date DATE; -- DEFAULT fnd_date.canonical_to_date(pv_trx_from_date) File.Sql.35 by Brathod
1551: p_trx_till_date DATE; -- DEFAULT fnd_date.canonical_to_date(pv_trx_till_date) File.Sql.35 by Brathod
1552: /*End of Bug# 4286646 */
1553:
1554: 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*/
1555: SELECT a.organization_id org_id,a.location_id /*Bug 5879769 bduvarag*/

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

1578: ln_org_id NUMBER; /*5694855*/
1579: /*Bug 5879769 bduvarag End*/
1580: BEGIN
1581:
1582: p_trx_from_date := fnd_date.canonical_to_date(pv_trx_from_date); --File.Sql.35 by Brathod
1583: p_trx_till_date := fnd_date.canonical_to_date(pv_trx_till_date); --File.Sql.35 by Brathod
1584:
1585: FND_FILE.put_line(fnd_file.log,'Value of from date is '||p_trx_from_date);
1586: FND_FILE.put_line(fnd_file.log,'Value of from date is '||p_trx_till_date);

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

1579: /*Bug 5879769 bduvarag End*/
1580: BEGIN
1581:
1582: p_trx_from_date := fnd_date.canonical_to_date(pv_trx_from_date); --File.Sql.35 by Brathod
1583: p_trx_till_date := fnd_date.canonical_to_date(pv_trx_till_date); --File.Sql.35 by Brathod
1584:
1585: FND_FILE.put_line(fnd_file.log,'Value of from date is '||p_trx_from_date);
1586: FND_FILE.put_line(fnd_file.log,'Value of from date is '||p_trx_till_date);
1587:

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

3297:
3298: /*end bug 4702156*/
3299:
3300: -- Harshita for Bug 4918870
3301: p_delivery_date_from DATE DEFAULT fnd_date.canonical_to_date(pv_delivery_date_from);
3302: p_delivery_date_to DATE DEFAULT fnd_date.canonical_to_date(pv_delivery_date_to);
3303:
3304: BEGIN
3305: /*

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

3298: /*end bug 4702156*/
3299:
3300: -- Harshita for Bug 4918870
3301: p_delivery_date_from DATE DEFAULT fnd_date.canonical_to_date(pv_delivery_date_from);
3302: p_delivery_date_to DATE DEFAULT fnd_date.canonical_to_date(pv_delivery_date_to);
3303:
3304: BEGIN
3305: /*
3306: ||aiyer for the bug 5369250

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

3305: /*
3306: ||aiyer for the bug 5369250
3307: ||convert from canonical to date format
3308: */
3309: ld_override_invoice_date := fnd_date.canonical_to_date(p_override_invoice_date);
3310: lv_inv_num_already_generated := jai_constants.value_false; -- File.Sql.35 by Brathod
3311: lv_debug := NVL(P_DEBUG,jai_constants.no);
3312: ln_current_party_id := -9999;
3313: ln_current_party_site_id := -9999;