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 4877: x_created_by => NVL(fnd_global.user_id,0),

4873: x_attribute13 => NULL,
4874: x_attribute14 => NULL,
4875: x_attribute15 => NULL,
4876: x_creation_date => SYSDATE,
4877: x_created_by => NVL(fnd_global.user_id,0),
4878: x_last_update_date => SYSDATE,
4879: x_last_updated_by => NVL(fnd_global.user_id,0),
4880: x_last_update_login => NVL(fnd_global.login_id,0),
4881: x_org_id => l_org_id );

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

4875: x_attribute15 => NULL,
4876: x_creation_date => SYSDATE,
4877: x_created_by => NVL(fnd_global.user_id,0),
4878: x_last_update_date => SYSDATE,
4879: x_last_updated_by => NVL(fnd_global.user_id,0),
4880: x_last_update_login => NVL(fnd_global.login_id,0),
4881: x_org_id => l_org_id );
4882:
4883: END LOOP;

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

4876: x_creation_date => SYSDATE,
4877: x_created_by => NVL(fnd_global.user_id,0),
4878: x_last_update_date => SYSDATE,
4879: x_last_updated_by => NVL(fnd_global.user_id,0),
4880: x_last_update_login => NVL(fnd_global.login_id,0),
4881: x_org_id => l_org_id );
4882:
4883: END LOOP;
4884:

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

4912: for_per_rent = ROUND(inv_rec.total_forecasted_rent, g_precision)
4913: ,forecasted_term_status = 'N'
4914: ,credit_flag = 'N' -- bug # 5937807
4915: ,last_update_date = SYSDATE
4916: ,last_updated_by = NVL(fnd_global.user_id,0)
4917: ,last_update_login = NVL(fnd_global.login_id,0)
4918: WHERE
4919: var_rent_inv_id = l_var_rent_inv_id;
4920:

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

4913: ,forecasted_term_status = 'N'
4914: ,credit_flag = 'N' -- bug # 5937807
4915: ,last_update_date = SYSDATE
4916: ,last_updated_by = NVL(fnd_global.user_id,0)
4917: ,last_update_login = NVL(fnd_global.login_id,0)
4918: WHERE
4919: var_rent_inv_id = l_var_rent_inv_id;
4920:
4921: END IF; /* if there a change in rent */

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

5038: x_attribute13 => NULL,
5039: x_attribute14 => NULL,
5040: x_attribute15 => NULL,
5041: x_creation_date => SYSDATE,
5042: x_created_by => NVL(fnd_global.user_id,0),
5043: x_last_update_date => SYSDATE,
5044: x_last_updated_by => NVL(fnd_global.user_id,0),
5045: x_last_update_login => NVL(fnd_global.login_id,0),
5046: x_org_id => l_org_id );

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

5040: x_attribute15 => NULL,
5041: x_creation_date => SYSDATE,
5042: x_created_by => NVL(fnd_global.user_id,0),
5043: x_last_update_date => SYSDATE,
5044: x_last_updated_by => NVL(fnd_global.user_id,0),
5045: x_last_update_login => NVL(fnd_global.login_id,0),
5046: x_org_id => l_org_id );
5047:
5048: END IF; /* IF inv_rec.total_actual_rent <> l_prev_inv_rent THEN */

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

5041: x_creation_date => SYSDATE,
5042: x_created_by => NVL(fnd_global.user_id,0),
5043: x_last_update_date => SYSDATE,
5044: x_last_updated_by => NVL(fnd_global.user_id,0),
5045: x_last_update_login => NVL(fnd_global.login_id,0),
5046: x_org_id => l_org_id );
5047:
5048: END IF; /* IF inv_rec.total_actual_rent <> l_prev_inv_rent THEN */
5049:

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

5067: ,tot_act_vol = ROUND(inv_rec.total_actual_sales, g_precision) -- bug # 6007571
5068: ,credit_flag = 'N' -- bug # 5937807
5069: ,variance_term_status = 'N'
5070: ,last_update_date = SYSDATE
5071: ,last_updated_by = NVL(fnd_global.user_id,0)
5072: ,last_update_login = NVL(fnd_global.login_id,0)
5073: WHERE
5074: var_rent_inv_id = l_var_rent_inv_id;
5075:

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

5068: ,credit_flag = 'N' -- bug # 5937807
5069: ,variance_term_status = 'N'
5070: ,last_update_date = SYSDATE
5071: ,last_updated_by = NVL(fnd_global.user_id,0)
5072: ,last_update_login = NVL(fnd_global.login_id,0)
5073: WHERE
5074: var_rent_inv_id = l_var_rent_inv_id;
5075:
5076:

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

6100: ,round(summ_rec.rent,g_precision)
6101: ,grp_rec.grp_date_id
6102: ,grp_rec.group_date
6103: ,SYSDATE
6104: ,NVL(fnd_global.user_id, 0)
6105: ,SYSDATE
6106: ,NVL(fnd_global.user_id, 0)
6107: ,NVL(fnd_global.login_id, 0)
6108: ,NVL(grp_rec.org_id, g_org_id))

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

6102: ,grp_rec.group_date
6103: ,SYSDATE
6104: ,NVL(fnd_global.user_id, 0)
6105: ,SYSDATE
6106: ,NVL(fnd_global.user_id, 0)
6107: ,NVL(fnd_global.login_id, 0)
6108: ,NVL(grp_rec.org_id, g_org_id))
6109: RETURNING
6110: var_rent_summ_id

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

6103: ,SYSDATE
6104: ,NVL(fnd_global.user_id, 0)
6105: ,SYSDATE
6106: ,NVL(fnd_global.user_id, 0)
6107: ,NVL(fnd_global.login_id, 0)
6108: ,NVL(grp_rec.org_id, g_org_id))
6109: RETURNING
6110: var_rent_summ_id
6111: INTO

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

6119: SET
6120: tot_for_vol = summ_rec.sales
6121: ,for_var_rent = round(summ_rec.rent,g_precision)
6122: ,last_update_date = SYSDATE
6123: ,last_updated_by = NVL(fnd_global.user_id, 0)
6124: ,last_update_login = NVL(fnd_global.login_id, 0)
6125: WHERE
6126: var_rent_summ_id = l_vr_summ_id;
6127:

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

6120: tot_for_vol = summ_rec.sales
6121: ,for_var_rent = round(summ_rec.rent,g_precision)
6122: ,last_update_date = SYSDATE
6123: ,last_updated_by = NVL(fnd_global.user_id, 0)
6124: ,last_update_login = NVL(fnd_global.login_id, 0)
6125: WHERE
6126: var_rent_summ_id = l_vr_summ_id;
6127:
6128: END IF;

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

6286: SET
6287: tot_for_vol = summ_rec.sales
6288: ,for_var_rent = round(summ_rec.rent,g_precision)
6289: ,last_update_date = SYSDATE
6290: ,last_updated_by = NVL(fnd_global.user_id, 0)
6291: ,last_update_login = NVL(fnd_global.login_id, 0)
6292: WHERE
6293: var_rent_summ_id = l_vr_summ_id;
6294:

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

6287: tot_for_vol = summ_rec.sales
6288: ,for_var_rent = round(summ_rec.rent,g_precision)
6289: ,last_update_date = SYSDATE
6290: ,last_updated_by = NVL(fnd_global.user_id, 0)
6291: ,last_update_login = NVL(fnd_global.login_id, 0)
6292: WHERE
6293: var_rent_summ_id = l_vr_summ_id;
6294:
6295: END IF;

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

6327: ,round(summ_rec.rent,g_precision)
6328: ,l_grp_t(g).grp_date_id
6329: ,l_grp_t(g).group_date
6330: ,SYSDATE
6331: ,NVL(fnd_global.user_id, 0)
6332: ,SYSDATE
6333: ,NVL(fnd_global.user_id, 0)
6334: ,NVL(fnd_global.login_id, 0)
6335: ,NVL(l_grp_t(g).org_id, g_org_id))

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

6329: ,l_grp_t(g).group_date
6330: ,SYSDATE
6331: ,NVL(fnd_global.user_id, 0)
6332: ,SYSDATE
6333: ,NVL(fnd_global.user_id, 0)
6334: ,NVL(fnd_global.login_id, 0)
6335: ,NVL(l_grp_t(g).org_id, g_org_id))
6336: RETURNING
6337: var_rent_summ_id

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

6330: ,SYSDATE
6331: ,NVL(fnd_global.user_id, 0)
6332: ,SYSDATE
6333: ,NVL(fnd_global.user_id, 0)
6334: ,NVL(fnd_global.login_id, 0)
6335: ,NVL(l_grp_t(g).org_id, g_org_id))
6336: RETURNING
6337: var_rent_summ_id
6338: INTO

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

9905: ,tot_ded = summ_rec.ded
9906: ,act_var_rent = round(summ_rec.rent,g_precision)
9907: ,first_yr_rent = round(summ_rec.first_yr_rent,g_precision)
9908: ,last_update_date = SYSDATE
9909: ,last_updated_by = NVL(fnd_global.user_id, 0)
9910: ,last_update_login = NVL(fnd_global.login_id, 0)
9911: WHERE
9912: var_rent_summ_id = l_vr_summ_id;
9913:

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

9906: ,act_var_rent = round(summ_rec.rent,g_precision)
9907: ,first_yr_rent = round(summ_rec.first_yr_rent,g_precision)
9908: ,last_update_date = SYSDATE
9909: ,last_updated_by = NVL(fnd_global.user_id, 0)
9910: ,last_update_login = NVL(fnd_global.login_id, 0)
9911: WHERE
9912: var_rent_summ_id = l_vr_summ_id;
9913:
9914: END IF;

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

9950: ,round(summ_rec.rent,g_precision)
9951: ,l_grp_t(g).grp_date_id
9952: ,l_grp_t(g).group_date
9953: ,SYSDATE
9954: ,NVL(fnd_global.user_id, 0)
9955: ,SYSDATE
9956: ,NVL(fnd_global.user_id, 0)
9957: ,NVL(fnd_global.login_id, 0)
9958: ,NVL(l_grp_t(g).org_id, g_org_id)

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

9952: ,l_grp_t(g).group_date
9953: ,SYSDATE
9954: ,NVL(fnd_global.user_id, 0)
9955: ,SYSDATE
9956: ,NVL(fnd_global.user_id, 0)
9957: ,NVL(fnd_global.login_id, 0)
9958: ,NVL(l_grp_t(g).org_id, g_org_id)
9959: ,round(summ_rec.first_yr_rent,g_precision))
9960: RETURNING

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

9953: ,SYSDATE
9954: ,NVL(fnd_global.user_id, 0)
9955: ,SYSDATE
9956: ,NVL(fnd_global.user_id, 0)
9957: ,NVL(fnd_global.login_id, 0)
9958: ,NVL(l_grp_t(g).org_id, g_org_id)
9959: ,round(summ_rec.first_yr_rent,g_precision))
9960: RETURNING
9961: var_rent_summ_id

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

10479: pn_var_rent_inv_all
10480: SET
10481: actual_term_status = 'N'
10482: ,last_update_date = SYSDATE
10483: ,last_updated_by = NVL(fnd_global.user_id,0)
10484: ,last_update_login = NVL(fnd_global.login_id,0)
10485: WHERE
10486: var_rent_inv_id = rec.var_rent_inv_id;
10487:

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

10480: SET
10481: actual_term_status = 'N'
10482: ,last_update_date = SYSDATE
10483: ,last_updated_by = NVL(fnd_global.user_id,0)
10484: ,last_update_login = NVL(fnd_global.login_id,0)
10485: WHERE
10486: var_rent_inv_id = rec.var_rent_inv_id;
10487:
10488: ELSIF (g_invoice_on = G_INV_ON_FORECASTED AND g_calc_type = G_CALC_TYPE_CALCULATE) THEN

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

10493: pn_var_rent_inv_all
10494: SET
10495: forecasted_term_status = 'N'
10496: ,last_update_date = SYSDATE
10497: ,last_updated_by = NVL(fnd_global.user_id,0)
10498: ,last_update_login = NVL(fnd_global.login_id,0)
10499: WHERE
10500: var_rent_inv_id = rec.var_rent_inv_id;
10501:

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

10494: SET
10495: forecasted_term_status = 'N'
10496: ,last_update_date = SYSDATE
10497: ,last_updated_by = NVL(fnd_global.user_id,0)
10498: ,last_update_login = NVL(fnd_global.login_id,0)
10499: WHERE
10500: var_rent_inv_id = rec.var_rent_inv_id;
10501:
10502: ELSIF (g_invoice_on = G_INV_ON_FORECASTED AND g_calc_type = G_CALC_TYPE_RECONCILE) THEN

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

10507: pn_var_rent_inv_all
10508: SET
10509: actual_term_status = 'N'
10510: ,last_update_date = SYSDATE
10511: ,last_updated_by = NVL(fnd_global.user_id,0)
10512: ,last_update_login = NVL(fnd_global.login_id,0)
10513: WHERE
10514: var_rent_inv_id = rec.var_rent_inv_id;
10515:

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

10508: SET
10509: actual_term_status = 'N'
10510: ,last_update_date = SYSDATE
10511: ,last_updated_by = NVL(fnd_global.user_id,0)
10512: ,last_update_login = NVL(fnd_global.login_id,0)
10513: WHERE
10514: var_rent_inv_id = rec.var_rent_inv_id;
10515:
10516: END IF;