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.PN_VAR_RENT_CALC_PKG dependencies on FND_GLOBAL

Line 1525: ,NVL(fnd_global.user_id, 0)

1521: ,round(summ_rec.rent,g_precision)
1522: ,grp_rec.grp_date_id
1523: ,grp_rec.group_date
1524: ,SYSDATE
1525: ,NVL(fnd_global.user_id, 0)
1526: ,SYSDATE
1527: ,NVL(fnd_global.user_id, 0)
1528: ,NVL(fnd_global.login_id, 0)
1529: ,NVL(grp_rec.org_id, g_org_id))

Line 1527: ,NVL(fnd_global.user_id, 0)

1523: ,grp_rec.group_date
1524: ,SYSDATE
1525: ,NVL(fnd_global.user_id, 0)
1526: ,SYSDATE
1527: ,NVL(fnd_global.user_id, 0)
1528: ,NVL(fnd_global.login_id, 0)
1529: ,NVL(grp_rec.org_id, g_org_id))
1530: RETURNING
1531: var_rent_summ_id

Line 1528: ,NVL(fnd_global.login_id, 0)

1524: ,SYSDATE
1525: ,NVL(fnd_global.user_id, 0)
1526: ,SYSDATE
1527: ,NVL(fnd_global.user_id, 0)
1528: ,NVL(fnd_global.login_id, 0)
1529: ,NVL(grp_rec.org_id, g_org_id))
1530: RETURNING
1531: var_rent_summ_id
1532: INTO

Line 1546: ,last_updated_by = NVL(fnd_global.user_id, 0)

1542: tot_act_vol = summ_rec.sales
1543: ,tot_ded = summ_rec.ded
1544: ,act_var_rent = round(summ_rec.rent,g_precision)
1545: ,last_update_date = SYSDATE
1546: ,last_updated_by = NVL(fnd_global.user_id, 0)
1547: ,last_update_login = NVL(fnd_global.login_id, 0)
1548: WHERE
1549: var_rent_summ_id = l_vr_summ_id;
1550:

Line 1547: ,last_update_login = NVL(fnd_global.login_id, 0)

1543: ,tot_ded = summ_rec.ded
1544: ,act_var_rent = round(summ_rec.rent,g_precision)
1545: ,last_update_date = SYSDATE
1546: ,last_updated_by = NVL(fnd_global.user_id, 0)
1547: ,last_update_login = NVL(fnd_global.login_id, 0)
1548: WHERE
1549: var_rent_summ_id = l_vr_summ_id;
1550:
1551: END IF;

Line 1672: ,last_updated_by = NVL(fnd_global.user_id, 0)

1668: tot_act_vol = vr_summ_fy_rec.tot_act_vol
1669: ,tot_ded = vr_summ_fy_rec.tot_ded
1670: ,act_var_rent = round(vr_summ_fy_rec.first_yr_rent,g_precision)
1671: ,last_update_date = SYSDATE
1672: ,last_updated_by = NVL(fnd_global.user_id, 0)
1673: ,last_update_login = NVL(fnd_global.login_id, 0)
1674: WHERE
1675: var_rent_summ_id = l_vr_summ_id;
1676:

Line 1673: ,last_update_login = NVL(fnd_global.login_id, 0)

1669: ,tot_ded = vr_summ_fy_rec.tot_ded
1670: ,act_var_rent = round(vr_summ_fy_rec.first_yr_rent,g_precision)
1671: ,last_update_date = SYSDATE
1672: ,last_updated_by = NVL(fnd_global.user_id, 0)
1673: ,last_update_login = NVL(fnd_global.login_id, 0)
1674: WHERE
1675: var_rent_summ_id = l_vr_summ_id;
1676:
1677: END IF;

Line 1715: ,NVL(fnd_global.user_id, 0)

1711: ,round(vr_summ_fy_rec.first_yr_rent,g_precision)
1712: ,vr_summ_fy_rec.grp_date_id
1713: ,vr_summ_fy_rec.group_date
1714: ,SYSDATE
1715: ,NVL(fnd_global.user_id, 0)
1716: ,SYSDATE
1717: ,NVL(fnd_global.user_id, 0)
1718: ,NVL(fnd_global.login_id, 0)
1719: ,vr_summ_fy_rec.org_id

Line 1717: ,NVL(fnd_global.user_id, 0)

1713: ,vr_summ_fy_rec.group_date
1714: ,SYSDATE
1715: ,NVL(fnd_global.user_id, 0)
1716: ,SYSDATE
1717: ,NVL(fnd_global.user_id, 0)
1718: ,NVL(fnd_global.login_id, 0)
1719: ,vr_summ_fy_rec.org_id
1720: ,NULL)
1721: RETURNING

Line 1718: ,NVL(fnd_global.login_id, 0)

1714: ,SYSDATE
1715: ,NVL(fnd_global.user_id, 0)
1716: ,SYSDATE
1717: ,NVL(fnd_global.user_id, 0)
1718: ,NVL(fnd_global.login_id, 0)
1719: ,vr_summ_fy_rec.org_id
1720: ,NULL)
1721: RETURNING
1722: var_rent_summ_id

Line 1975: x_created_by => NVL(fnd_global.user_id,0),

1971: x_attribute13 => NULL,
1972: x_attribute14 => NULL,
1973: x_attribute15 => NULL,
1974: x_creation_date => SYSDATE,
1975: x_created_by => NVL(fnd_global.user_id,0),
1976: x_last_update_date => SYSDATE,
1977: x_last_updated_by => NVL(fnd_global.user_id,0),
1978: x_last_update_login => NVL(fnd_global.login_id,0),
1979: x_org_id => l_org_id );

Line 1977: x_last_updated_by => NVL(fnd_global.user_id,0),

1973: x_attribute15 => NULL,
1974: x_creation_date => SYSDATE,
1975: x_created_by => NVL(fnd_global.user_id,0),
1976: x_last_update_date => SYSDATE,
1977: x_last_updated_by => NVL(fnd_global.user_id,0),
1978: x_last_update_login => NVL(fnd_global.login_id,0),
1979: x_org_id => l_org_id );
1980:
1981: ELSIF l_exists_invoice THEN

Line 1978: x_last_update_login => NVL(fnd_global.login_id,0),

1974: x_creation_date => SYSDATE,
1975: x_created_by => NVL(fnd_global.user_id,0),
1976: x_last_update_date => SYSDATE,
1977: x_last_updated_by => NVL(fnd_global.user_id,0),
1978: x_last_update_login => NVL(fnd_global.login_id,0),
1979: x_org_id => l_org_id );
1980:
1981: ELSIF l_exists_invoice THEN
1982:

Line 2046: x_created_by => NVL(fnd_global.user_id,0),

2042: x_attribute13 => NULL,
2043: x_attribute14 => NULL,
2044: x_attribute15 => NULL,
2045: x_creation_date => SYSDATE,
2046: x_created_by => NVL(fnd_global.user_id,0),
2047: x_last_update_date => SYSDATE,
2048: x_last_updated_by => NVL(fnd_global.user_id,0),
2049: x_last_update_login => NVL(fnd_global.login_id,0),
2050: x_org_id => l_org_id );

Line 2048: x_last_updated_by => NVL(fnd_global.user_id,0),

2044: x_attribute15 => NULL,
2045: x_creation_date => SYSDATE,
2046: x_created_by => NVL(fnd_global.user_id,0),
2047: x_last_update_date => SYSDATE,
2048: x_last_updated_by => NVL(fnd_global.user_id,0),
2049: x_last_update_login => NVL(fnd_global.login_id,0),
2050: x_org_id => l_org_id );
2051:
2052: END IF; /* IF inv_rec.total_actual_rent <> l_prev_inv_rent THEN */

Line 2049: x_last_update_login => NVL(fnd_global.login_id,0),

2045: x_creation_date => SYSDATE,
2046: x_created_by => NVL(fnd_global.user_id,0),
2047: x_last_update_date => SYSDATE,
2048: x_last_updated_by => NVL(fnd_global.user_id,0),
2049: x_last_update_login => NVL(fnd_global.login_id,0),
2050: x_org_id => l_org_id );
2051:
2052: END IF; /* IF inv_rec.total_actual_rent <> l_prev_inv_rent THEN */
2053:

Line 2078: ,last_updated_by = NVL(fnd_global.user_id,0)

2074: ,tot_act_vol = ROUND(l_tot_act_vol,g_precision) -- bug # 6007571
2075: ,credit_flag = 'N' -- bug # 5937807
2076: ,actual_term_status = 'N'
2077: ,last_update_date = SYSDATE
2078: ,last_updated_by = NVL(fnd_global.user_id,0)
2079: ,last_update_login = NVL(fnd_global.login_id,0)
2080: WHERE
2081: var_rent_inv_id = l_var_rent_inv_id;
2082:

Line 2079: ,last_update_login = NVL(fnd_global.login_id,0)

2075: ,credit_flag = 'N' -- bug # 5937807
2076: ,actual_term_status = 'N'
2077: ,last_update_date = SYSDATE
2078: ,last_updated_by = NVL(fnd_global.user_id,0)
2079: ,last_update_login = NVL(fnd_global.login_id,0)
2080: WHERE
2081: var_rent_inv_id = l_var_rent_inv_id;
2082:
2083: END IF; /* if there a change in rent */

Line 2376: x_created_by => NVL(fnd_global.user_id,0),

2372: x_attribute13 => NULL,
2373: x_attribute14 => NULL,
2374: x_attribute15 => NULL,
2375: x_creation_date => SYSDATE,
2376: x_created_by => NVL(fnd_global.user_id,0),
2377: x_last_update_date => SYSDATE,
2378: x_last_updated_by => NVL(fnd_global.user_id,0),
2379: x_last_update_login => NVL(fnd_global.login_id,0),
2380: x_org_id => l_org_id );

Line 2378: x_last_updated_by => NVL(fnd_global.user_id,0),

2374: x_attribute15 => NULL,
2375: x_creation_date => SYSDATE,
2376: x_created_by => NVL(fnd_global.user_id,0),
2377: x_last_update_date => SYSDATE,
2378: x_last_updated_by => NVL(fnd_global.user_id,0),
2379: x_last_update_login => NVL(fnd_global.login_id,0),
2380: x_org_id => l_org_id );
2381: END LOOP;
2382:

Line 2379: x_last_update_login => NVL(fnd_global.login_id,0),

2375: x_creation_date => SYSDATE,
2376: x_created_by => NVL(fnd_global.user_id,0),
2377: x_last_update_date => SYSDATE,
2378: x_last_updated_by => NVL(fnd_global.user_id,0),
2379: x_last_update_login => NVL(fnd_global.login_id,0),
2380: x_org_id => l_org_id );
2381: END LOOP;
2382:
2383:

Line 2452: x_created_by => NVL(fnd_global.user_id,0),

2448: x_attribute13 => NULL,
2449: x_attribute14 => NULL,
2450: x_attribute15 => NULL,
2451: x_creation_date => SYSDATE,
2452: x_created_by => NVL(fnd_global.user_id,0),
2453: x_last_update_date => SYSDATE,
2454: x_last_updated_by => NVL(fnd_global.user_id,0),
2455: x_last_update_login => NVL(fnd_global.login_id,0),
2456: x_org_id => l_org_id );

Line 2454: x_last_updated_by => NVL(fnd_global.user_id,0),

2450: x_attribute15 => NULL,
2451: x_creation_date => SYSDATE,
2452: x_created_by => NVL(fnd_global.user_id,0),
2453: x_last_update_date => SYSDATE,
2454: x_last_updated_by => NVL(fnd_global.user_id,0),
2455: x_last_update_login => NVL(fnd_global.login_id,0),
2456: x_org_id => l_org_id );
2457:
2458: END IF; /* IF inv_rec.total_actual_rent <> l_prev_inv_rent THEN */

Line 2455: x_last_update_login => NVL(fnd_global.login_id,0),

2451: x_creation_date => SYSDATE,
2452: x_created_by => NVL(fnd_global.user_id,0),
2453: x_last_update_date => SYSDATE,
2454: x_last_updated_by => NVL(fnd_global.user_id,0),
2455: x_last_update_login => NVL(fnd_global.login_id,0),
2456: x_org_id => l_org_id );
2457:
2458: END IF; /* IF inv_rec.total_actual_rent <> l_prev_inv_rent THEN */
2459:

Line 2485: ,last_updated_by = NVL(fnd_global.user_id,0)

2481: ,tot_act_vol = ROUND(l_tot_act_vol, g_precision) -- bug # 6007571
2482: ,credit_flag = 'N' -- bug # 5937807
2483: ,actual_term_status = 'N'
2484: ,last_update_date = SYSDATE
2485: ,last_updated_by = NVL(fnd_global.user_id,0)
2486: ,last_update_login = NVL(fnd_global.login_id,0)
2487: WHERE
2488: var_rent_inv_id = l_var_rent_inv_id;
2489:

Line 2486: ,last_update_login = NVL(fnd_global.login_id,0)

2482: ,credit_flag = 'N' -- bug # 5937807
2483: ,actual_term_status = 'N'
2484: ,last_update_date = SYSDATE
2485: ,last_updated_by = NVL(fnd_global.user_id,0)
2486: ,last_update_login = NVL(fnd_global.login_id,0)
2487: WHERE
2488: var_rent_inv_id = l_var_rent_inv_id;
2489:
2490: END IF; /* if there a change in rent */

Line 2802: ,last_updated_by = NVL(fnd_global.user_id,0)

2798: SET
2799: actual_invoiced_amount = ROUND((l_abated_rent - l_prev_inv_exp), g_precision)
2800: ,actual_term_status = 'N'
2801: ,last_update_date = SYSDATE
2802: ,last_updated_by = NVL(fnd_global.user_id,0)
2803: ,last_update_login = NVL(fnd_global.login_id,0)
2804: WHERE
2805: var_rent_inv_id = inv_rec.var_rent_inv_id;
2806:

Line 2803: ,last_update_login = NVL(fnd_global.login_id,0)

2799: actual_invoiced_amount = ROUND((l_abated_rent - l_prev_inv_exp), g_precision)
2800: ,actual_term_status = 'N'
2801: ,last_update_date = SYSDATE
2802: ,last_updated_by = NVL(fnd_global.user_id,0)
2803: ,last_update_login = NVL(fnd_global.login_id,0)
2804: WHERE
2805: var_rent_inv_id = inv_rec.var_rent_inv_id;
2806:
2807: ELSIF ((l_abated_rent - l_prev_inv_exp)<>0) AND (l_is_inv_exp = 'Y') THEN

Line 2857: x_created_by => NVL(fnd_global.user_id,0),

2853: x_attribute13 => NULL,
2854: x_attribute14 => NULL,
2855: x_attribute15 => NULL,
2856: x_creation_date => SYSDATE,
2857: x_created_by => NVL(fnd_global.user_id,0),
2858: x_last_update_date => SYSDATE,
2859: x_last_updated_by => NVL(fnd_global.user_id,0),
2860: x_last_update_login => NVL(fnd_global.login_id,0),
2861: x_org_id => inv_all_rec.org_id );

Line 2859: x_last_updated_by => NVL(fnd_global.user_id,0),

2855: x_attribute15 => NULL,
2856: x_creation_date => SYSDATE,
2857: x_created_by => NVL(fnd_global.user_id,0),
2858: x_last_update_date => SYSDATE,
2859: x_last_updated_by => NVL(fnd_global.user_id,0),
2860: x_last_update_login => NVL(fnd_global.login_id,0),
2861: x_org_id => inv_all_rec.org_id );
2862: END LOOP;
2863: END IF;

Line 2860: x_last_update_login => NVL(fnd_global.login_id,0),

2856: x_creation_date => SYSDATE,
2857: x_created_by => NVL(fnd_global.user_id,0),
2858: x_last_update_date => SYSDATE,
2859: x_last_updated_by => NVL(fnd_global.user_id,0),
2860: x_last_update_login => NVL(fnd_global.login_id,0),
2861: x_org_id => inv_all_rec.org_id );
2862: END LOOP;
2863: END IF;
2864:

Line 4789: x_created_by => NVL(fnd_global.user_id,0),

4785: x_attribute13 => NULL,
4786: x_attribute14 => NULL,
4787: x_attribute15 => NULL,
4788: x_creation_date => SYSDATE,
4789: x_created_by => NVL(fnd_global.user_id,0),
4790: x_last_update_date => SYSDATE,
4791: x_last_updated_by => NVL(fnd_global.user_id,0),
4792: x_last_update_login => NVL(fnd_global.login_id,0),
4793: x_org_id => l_org_id );

Line 4791: x_last_updated_by => NVL(fnd_global.user_id,0),

4787: x_attribute15 => NULL,
4788: x_creation_date => SYSDATE,
4789: x_created_by => NVL(fnd_global.user_id,0),
4790: x_last_update_date => SYSDATE,
4791: x_last_updated_by => NVL(fnd_global.user_id,0),
4792: x_last_update_login => NVL(fnd_global.login_id,0),
4793: x_org_id => l_org_id );
4794:
4795: END LOOP;

Line 4792: x_last_update_login => NVL(fnd_global.login_id,0),

4788: x_creation_date => SYSDATE,
4789: x_created_by => NVL(fnd_global.user_id,0),
4790: x_last_update_date => SYSDATE,
4791: x_last_updated_by => NVL(fnd_global.user_id,0),
4792: x_last_update_login => NVL(fnd_global.login_id,0),
4793: x_org_id => l_org_id );
4794:
4795: END LOOP;
4796:

Line 4828: ,last_updated_by = NVL(fnd_global.user_id,0)

4824: for_per_rent = ROUND(inv_rec.total_forecasted_rent, g_precision)
4825: ,forecasted_term_status = 'N'
4826: ,credit_flag = 'N' -- bug # 5937807
4827: ,last_update_date = SYSDATE
4828: ,last_updated_by = NVL(fnd_global.user_id,0)
4829: ,last_update_login = NVL(fnd_global.login_id,0)
4830: WHERE
4831: var_rent_inv_id = l_var_rent_inv_id;
4832:

Line 4829: ,last_update_login = NVL(fnd_global.login_id,0)

4825: ,forecasted_term_status = 'N'
4826: ,credit_flag = 'N' -- bug # 5937807
4827: ,last_update_date = SYSDATE
4828: ,last_updated_by = NVL(fnd_global.user_id,0)
4829: ,last_update_login = NVL(fnd_global.login_id,0)
4830: WHERE
4831: var_rent_inv_id = l_var_rent_inv_id;
4832:
4833: END IF; /* if there a change in rent */

Line 4954: x_created_by => NVL(fnd_global.user_id,0),

4950: x_attribute13 => NULL,
4951: x_attribute14 => NULL,
4952: x_attribute15 => NULL,
4953: x_creation_date => SYSDATE,
4954: x_created_by => NVL(fnd_global.user_id,0),
4955: x_last_update_date => SYSDATE,
4956: x_last_updated_by => NVL(fnd_global.user_id,0),
4957: x_last_update_login => NVL(fnd_global.login_id,0),
4958: x_org_id => l_org_id );

Line 4956: x_last_updated_by => NVL(fnd_global.user_id,0),

4952: x_attribute15 => NULL,
4953: x_creation_date => SYSDATE,
4954: x_created_by => NVL(fnd_global.user_id,0),
4955: x_last_update_date => SYSDATE,
4956: x_last_updated_by => NVL(fnd_global.user_id,0),
4957: x_last_update_login => NVL(fnd_global.login_id,0),
4958: x_org_id => l_org_id );
4959:
4960: END IF; /* IF inv_rec.total_actual_rent <> l_prev_inv_rent THEN */

Line 4957: x_last_update_login => NVL(fnd_global.login_id,0),

4953: x_creation_date => SYSDATE,
4954: x_created_by => NVL(fnd_global.user_id,0),
4955: x_last_update_date => SYSDATE,
4956: x_last_updated_by => NVL(fnd_global.user_id,0),
4957: x_last_update_login => NVL(fnd_global.login_id,0),
4958: x_org_id => l_org_id );
4959:
4960: END IF; /* IF inv_rec.total_actual_rent <> l_prev_inv_rent THEN */
4961:

Line 4982: ,last_updated_by = NVL(fnd_global.user_id,0)

4978: ,tot_act_vol = ROUND(inv_rec.total_actual_sales, g_precision) -- bug # 6007571
4979: ,credit_flag = 'N' -- bug # 5937807
4980: ,variance_term_status = 'N'
4981: ,last_update_date = SYSDATE
4982: ,last_updated_by = NVL(fnd_global.user_id,0)
4983: ,last_update_login = NVL(fnd_global.login_id,0)
4984: WHERE
4985: var_rent_inv_id = l_var_rent_inv_id;
4986:

Line 4983: ,last_update_login = NVL(fnd_global.login_id,0)

4979: ,credit_flag = 'N' -- bug # 5937807
4980: ,variance_term_status = 'N'
4981: ,last_update_date = SYSDATE
4982: ,last_updated_by = NVL(fnd_global.user_id,0)
4983: ,last_update_login = NVL(fnd_global.login_id,0)
4984: WHERE
4985: var_rent_inv_id = l_var_rent_inv_id;
4986:
4987:

Line 6015: ,NVL(fnd_global.user_id, 0)

6011: ,round(summ_rec.rent,g_precision)
6012: ,grp_rec.grp_date_id
6013: ,grp_rec.group_date
6014: ,SYSDATE
6015: ,NVL(fnd_global.user_id, 0)
6016: ,SYSDATE
6017: ,NVL(fnd_global.user_id, 0)
6018: ,NVL(fnd_global.login_id, 0)
6019: ,NVL(grp_rec.org_id, g_org_id))

Line 6017: ,NVL(fnd_global.user_id, 0)

6013: ,grp_rec.group_date
6014: ,SYSDATE
6015: ,NVL(fnd_global.user_id, 0)
6016: ,SYSDATE
6017: ,NVL(fnd_global.user_id, 0)
6018: ,NVL(fnd_global.login_id, 0)
6019: ,NVL(grp_rec.org_id, g_org_id))
6020: RETURNING
6021: var_rent_summ_id

Line 6018: ,NVL(fnd_global.login_id, 0)

6014: ,SYSDATE
6015: ,NVL(fnd_global.user_id, 0)
6016: ,SYSDATE
6017: ,NVL(fnd_global.user_id, 0)
6018: ,NVL(fnd_global.login_id, 0)
6019: ,NVL(grp_rec.org_id, g_org_id))
6020: RETURNING
6021: var_rent_summ_id
6022: INTO

Line 6034: ,last_updated_by = NVL(fnd_global.user_id, 0)

6030: SET
6031: tot_for_vol = summ_rec.sales
6032: ,for_var_rent = round(summ_rec.rent,g_precision)
6033: ,last_update_date = SYSDATE
6034: ,last_updated_by = NVL(fnd_global.user_id, 0)
6035: ,last_update_login = NVL(fnd_global.login_id, 0)
6036: WHERE
6037: var_rent_summ_id = l_vr_summ_id;
6038:

Line 6035: ,last_update_login = NVL(fnd_global.login_id, 0)

6031: tot_for_vol = summ_rec.sales
6032: ,for_var_rent = round(summ_rec.rent,g_precision)
6033: ,last_update_date = SYSDATE
6034: ,last_updated_by = NVL(fnd_global.user_id, 0)
6035: ,last_update_login = NVL(fnd_global.login_id, 0)
6036: WHERE
6037: var_rent_summ_id = l_vr_summ_id;
6038:
6039: END IF;

Line 6201: ,last_updated_by = NVL(fnd_global.user_id, 0)

6197: SET
6198: tot_for_vol = summ_rec.sales
6199: ,for_var_rent = round(summ_rec.rent,g_precision)
6200: ,last_update_date = SYSDATE
6201: ,last_updated_by = NVL(fnd_global.user_id, 0)
6202: ,last_update_login = NVL(fnd_global.login_id, 0)
6203: WHERE
6204: var_rent_summ_id = l_vr_summ_id;
6205:

Line 6202: ,last_update_login = NVL(fnd_global.login_id, 0)

6198: tot_for_vol = summ_rec.sales
6199: ,for_var_rent = round(summ_rec.rent,g_precision)
6200: ,last_update_date = SYSDATE
6201: ,last_updated_by = NVL(fnd_global.user_id, 0)
6202: ,last_update_login = NVL(fnd_global.login_id, 0)
6203: WHERE
6204: var_rent_summ_id = l_vr_summ_id;
6205:
6206: END IF;

Line 6242: ,NVL(fnd_global.user_id, 0)

6238: ,round(summ_rec.rent,g_precision)
6239: ,l_grp_t(g).grp_date_id
6240: ,l_grp_t(g).group_date
6241: ,SYSDATE
6242: ,NVL(fnd_global.user_id, 0)
6243: ,SYSDATE
6244: ,NVL(fnd_global.user_id, 0)
6245: ,NVL(fnd_global.login_id, 0)
6246: ,NVL(l_grp_t(g).org_id, g_org_id))

Line 6244: ,NVL(fnd_global.user_id, 0)

6240: ,l_grp_t(g).group_date
6241: ,SYSDATE
6242: ,NVL(fnd_global.user_id, 0)
6243: ,SYSDATE
6244: ,NVL(fnd_global.user_id, 0)
6245: ,NVL(fnd_global.login_id, 0)
6246: ,NVL(l_grp_t(g).org_id, g_org_id))
6247: RETURNING
6248: var_rent_summ_id

Line 6245: ,NVL(fnd_global.login_id, 0)

6241: ,SYSDATE
6242: ,NVL(fnd_global.user_id, 0)
6243: ,SYSDATE
6244: ,NVL(fnd_global.user_id, 0)
6245: ,NVL(fnd_global.login_id, 0)
6246: ,NVL(l_grp_t(g).org_id, g_org_id))
6247: RETURNING
6248: var_rent_summ_id
6249: INTO

Line 9854: ,last_updated_by = NVL(fnd_global.user_id, 0)

9850: ,tot_ded = summ_rec.ded
9851: ,act_var_rent = round(summ_rec.rent,g_precision)
9852: ,first_yr_rent = round(summ_rec.first_yr_rent,g_precision)
9853: ,last_update_date = SYSDATE
9854: ,last_updated_by = NVL(fnd_global.user_id, 0)
9855: ,last_update_login = NVL(fnd_global.login_id, 0)
9856: WHERE
9857: var_rent_summ_id = l_vr_summ_id;
9858:

Line 9855: ,last_update_login = NVL(fnd_global.login_id, 0)

9851: ,act_var_rent = round(summ_rec.rent,g_precision)
9852: ,first_yr_rent = round(summ_rec.first_yr_rent,g_precision)
9853: ,last_update_date = SYSDATE
9854: ,last_updated_by = NVL(fnd_global.user_id, 0)
9855: ,last_update_login = NVL(fnd_global.login_id, 0)
9856: WHERE
9857: var_rent_summ_id = l_vr_summ_id;
9858:
9859: END IF;

Line 9899: ,NVL(fnd_global.user_id, 0)

9895: ,round(summ_rec.rent,g_precision)
9896: ,l_grp_t(g).grp_date_id
9897: ,l_grp_t(g).group_date
9898: ,SYSDATE
9899: ,NVL(fnd_global.user_id, 0)
9900: ,SYSDATE
9901: ,NVL(fnd_global.user_id, 0)
9902: ,NVL(fnd_global.login_id, 0)
9903: ,NVL(l_grp_t(g).org_id, g_org_id)

Line 9901: ,NVL(fnd_global.user_id, 0)

9897: ,l_grp_t(g).group_date
9898: ,SYSDATE
9899: ,NVL(fnd_global.user_id, 0)
9900: ,SYSDATE
9901: ,NVL(fnd_global.user_id, 0)
9902: ,NVL(fnd_global.login_id, 0)
9903: ,NVL(l_grp_t(g).org_id, g_org_id)
9904: ,round(summ_rec.first_yr_rent,g_precision))
9905: RETURNING

Line 9902: ,NVL(fnd_global.login_id, 0)

9898: ,SYSDATE
9899: ,NVL(fnd_global.user_id, 0)
9900: ,SYSDATE
9901: ,NVL(fnd_global.user_id, 0)
9902: ,NVL(fnd_global.login_id, 0)
9903: ,NVL(l_grp_t(g).org_id, g_org_id)
9904: ,round(summ_rec.first_yr_rent,g_precision))
9905: RETURNING
9906: var_rent_summ_id

Line 10428: ,last_updated_by = NVL(fnd_global.user_id,0)

10424: pn_var_rent_inv_all
10425: SET
10426: actual_term_status = 'N'
10427: ,last_update_date = SYSDATE
10428: ,last_updated_by = NVL(fnd_global.user_id,0)
10429: ,last_update_login = NVL(fnd_global.login_id,0)
10430: WHERE
10431: var_rent_inv_id = rec.var_rent_inv_id;
10432:

Line 10429: ,last_update_login = NVL(fnd_global.login_id,0)

10425: SET
10426: actual_term_status = 'N'
10427: ,last_update_date = SYSDATE
10428: ,last_updated_by = NVL(fnd_global.user_id,0)
10429: ,last_update_login = NVL(fnd_global.login_id,0)
10430: WHERE
10431: var_rent_inv_id = rec.var_rent_inv_id;
10432:
10433: ELSIF (g_invoice_on = G_INV_ON_FORECASTED AND g_calc_type = G_CALC_TYPE_CALCULATE) THEN

Line 10442: ,last_updated_by = NVL(fnd_global.user_id,0)

10438: pn_var_rent_inv_all
10439: SET
10440: forecasted_term_status = 'N'
10441: ,last_update_date = SYSDATE
10442: ,last_updated_by = NVL(fnd_global.user_id,0)
10443: ,last_update_login = NVL(fnd_global.login_id,0)
10444: WHERE
10445: var_rent_inv_id = rec.var_rent_inv_id;
10446:

Line 10443: ,last_update_login = NVL(fnd_global.login_id,0)

10439: SET
10440: forecasted_term_status = 'N'
10441: ,last_update_date = SYSDATE
10442: ,last_updated_by = NVL(fnd_global.user_id,0)
10443: ,last_update_login = NVL(fnd_global.login_id,0)
10444: WHERE
10445: var_rent_inv_id = rec.var_rent_inv_id;
10446:
10447: ELSIF (g_invoice_on = G_INV_ON_FORECASTED AND g_calc_type = G_CALC_TYPE_RECONCILE) THEN

Line 10456: ,last_updated_by = NVL(fnd_global.user_id,0)

10452: pn_var_rent_inv_all
10453: SET
10454: actual_term_status = 'N'
10455: ,last_update_date = SYSDATE
10456: ,last_updated_by = NVL(fnd_global.user_id,0)
10457: ,last_update_login = NVL(fnd_global.login_id,0)
10458: WHERE
10459: var_rent_inv_id = rec.var_rent_inv_id;
10460:

Line 10457: ,last_update_login = NVL(fnd_global.login_id,0)

10453: SET
10454: actual_term_status = 'N'
10455: ,last_update_date = SYSDATE
10456: ,last_updated_by = NVL(fnd_global.user_id,0)
10457: ,last_update_login = NVL(fnd_global.login_id,0)
10458: WHERE
10459: var_rent_inv_id = rec.var_rent_inv_id;
10460:
10461: END IF;