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_CHG_CAL_PKG dependencies on FND_PROFILE

Line 120: NVL(fnd_profile.value('USER_ID'),0),

116: ) values (
117: pn_var_constraints_s.nextval,
118: l_constr_num,
119: sysdate,
120: NVL(fnd_profile.value('USER_ID'),0),
121: sysdate,
122: NVL(fnd_profile.value('USER_ID'),0),
123: NVL(fnd_profile.value('USER_ID'),0),
124: c1_rec.period_id,

Line 122: NVL(fnd_profile.value('USER_ID'),0),

118: l_constr_num,
119: sysdate,
120: NVL(fnd_profile.value('USER_ID'),0),
121: sysdate,
122: NVL(fnd_profile.value('USER_ID'),0),
123: NVL(fnd_profile.value('USER_ID'),0),
124: c1_rec.period_id,
125: c3_rec.constr_cat_code,
126: c3_rec.type_code,

Line 123: NVL(fnd_profile.value('USER_ID'),0),

119: sysdate,
120: NVL(fnd_profile.value('USER_ID'),0),
121: sysdate,
122: NVL(fnd_profile.value('USER_ID'),0),
123: NVL(fnd_profile.value('USER_ID'),0),
124: c1_rec.period_id,
125: c3_rec.constr_cat_code,
126: c3_rec.type_code,
127: c3_rec.amount,

Line 295: NVL(fnd_profile.value('USER_ID'),0),

291: ) values (
292: l_lineitemid,
293: l_line_num,
294: sysdate,
295: NVL(fnd_profile.value('USER_ID'),0),
296: sysdate,
297: NVL(fnd_profile.value('USER_ID'),0),
298: NVL(fnd_profile.value('USER_ID'),0),
299: c1_rec.period_id,

Line 297: NVL(fnd_profile.value('USER_ID'),0),

293: l_line_num,
294: sysdate,
295: NVL(fnd_profile.value('USER_ID'),0),
296: sysdate,
297: NVL(fnd_profile.value('USER_ID'),0),
298: NVL(fnd_profile.value('USER_ID'),0),
299: c1_rec.period_id,
300: c3_rec.sales_type_code,
301: c3_rec.item_category_code,

Line 298: NVL(fnd_profile.value('USER_ID'),0),

294: sysdate,
295: NVL(fnd_profile.value('USER_ID'),0),
296: sysdate,
297: NVL(fnd_profile.value('USER_ID'),0),
298: NVL(fnd_profile.value('USER_ID'),0),
299: c1_rec.period_id,
300: c3_rec.sales_type_code,
301: c3_rec.item_category_code,
302: c3_rec.comments,

Line 366: NVL(fnd_profile.value('USER_ID'),0),

362: org_id
363: ) values (
364: l_bkptheadid,
365: sysdate,
366: NVL(fnd_profile.value('USER_ID'),0),
367: sysdate,
368: NVL(fnd_profile.value('USER_ID'),0),
369: NVL(fnd_profile.value('USER_ID'),0),
370: l_lineitemid,

Line 368: NVL(fnd_profile.value('USER_ID'),0),

364: l_bkptheadid,
365: sysdate,
366: NVL(fnd_profile.value('USER_ID'),0),
367: sysdate,
368: NVL(fnd_profile.value('USER_ID'),0),
369: NVL(fnd_profile.value('USER_ID'),0),
370: l_lineitemid,
371: c1_rec.period_id,
372: c4_rec.break_type,

Line 369: NVL(fnd_profile.value('USER_ID'),0),

365: sysdate,
366: NVL(fnd_profile.value('USER_ID'),0),
367: sysdate,
368: NVL(fnd_profile.value('USER_ID'),0),
369: NVL(fnd_profile.value('USER_ID'),0),
370: l_lineitemid,
371: c1_rec.period_id,
372: c4_rec.break_type,
373: c4_rec.base_rent_type,

Line 454: NVL(fnd_profile.value('USER_ID'),0),

450: ) values (
451: pn_var_bkpts_det_s.nextval,
452: l_bkdt_num,
453: sysdate,
454: NVL(fnd_profile.value('USER_ID'),0),
455: sysdate,
456: NVL(fnd_profile.value('USER_ID'),0),
457: NVL(fnd_profile.value('USER_ID'),0),
458: l_bkptheadid,

Line 456: NVL(fnd_profile.value('USER_ID'),0),

452: l_bkdt_num,
453: sysdate,
454: NVL(fnd_profile.value('USER_ID'),0),
455: sysdate,
456: NVL(fnd_profile.value('USER_ID'),0),
457: NVL(fnd_profile.value('USER_ID'),0),
458: l_bkptheadid,
459: l_line_start_date,
460: l_line_end_date,

Line 457: NVL(fnd_profile.value('USER_ID'),0),

453: sysdate,
454: NVL(fnd_profile.value('USER_ID'),0),
455: sysdate,
456: NVL(fnd_profile.value('USER_ID'),0),
457: NVL(fnd_profile.value('USER_ID'),0),
458: l_bkptheadid,
459: l_line_start_date,
460: l_line_end_date,
461: c5_rec.period_bkpt_vol_start,

Line 694: NVL(fnd_profile.value('USER_ID'),0),

690: ) values (
691: pn_var_vol_hist_s.nextval,
692: l_vol_num,
693: sysdate,
694: NVL(fnd_profile.value('USER_ID'),0),
695: sysdate,
696: NVL(fnd_profile.value('USER_ID'),0),
697: NVL(fnd_profile.value('USER_ID'),0),
698: c1_rec.line_item_id,

Line 696: NVL(fnd_profile.value('USER_ID'),0),

692: l_vol_num,
693: sysdate,
694: NVL(fnd_profile.value('USER_ID'),0),
695: sysdate,
696: NVL(fnd_profile.value('USER_ID'),0),
697: NVL(fnd_profile.value('USER_ID'),0),
698: c1_rec.line_item_id,
699: c1_rec.period_id,
700: l_start_date,

Line 697: NVL(fnd_profile.value('USER_ID'),0),

693: sysdate,
694: NVL(fnd_profile.value('USER_ID'),0),
695: sysdate,
696: NVL(fnd_profile.value('USER_ID'),0),
697: NVL(fnd_profile.value('USER_ID'),0),
698: c1_rec.line_item_id,
699: c1_rec.period_id,
700: l_start_date,
701: l_end_date,

Line 1211: ,NVL(fnd_profile.value('USER_ID'),0)

1207: ,l_reset_group_id
1208: ,l_pro_reset_group_id
1209: ,l_factor
1210: ,sysdate
1211: ,NVL(fnd_profile.value('USER_ID'),0)
1212: ,sysdate
1213: ,NVL(fnd_profile.value('USER_ID'),0)
1214: ,NVL(fnd_profile.value('USER_ID'),0)
1215: ,to_number(decode(substr(userenv('CLIENT_INFO'),1,1),' ',null,substr(userenv('CLIENT_INFO'),1,10)))

Line 1213: ,NVL(fnd_profile.value('USER_ID'),0)

1209: ,l_factor
1210: ,sysdate
1211: ,NVL(fnd_profile.value('USER_ID'),0)
1212: ,sysdate
1213: ,NVL(fnd_profile.value('USER_ID'),0)
1214: ,NVL(fnd_profile.value('USER_ID'),0)
1215: ,to_number(decode(substr(userenv('CLIENT_INFO'),1,1),' ',null,substr(userenv('CLIENT_INFO'),1,10)))
1216: );*/
1217: PNP_DEBUG_PKG.DEBUG('Rows Inserted='||to_char(sql%rowcount));

Line 1214: ,NVL(fnd_profile.value('USER_ID'),0)

1210: ,sysdate
1211: ,NVL(fnd_profile.value('USER_ID'),0)
1212: ,sysdate
1213: ,NVL(fnd_profile.value('USER_ID'),0)
1214: ,NVL(fnd_profile.value('USER_ID'),0)
1215: ,to_number(decode(substr(userenv('CLIENT_INFO'),1,1),' ',null,substr(userenv('CLIENT_INFO'),1,10)))
1216: );*/
1217: PNP_DEBUG_PKG.DEBUG('Rows Inserted='||to_char(sql%rowcount));
1218:

Line 1235: ,last_updated_by = NVL(fnd_profile.value('USER_ID'),0)

1231: ,pr_grp_blended_vol_end =l_pr_prorate_end
1232: ,proration_rule_factor = l_factor
1233: ,bkpt_rate = c_bkpt.bkpt_rate
1234: ,last_update_date =sysdate
1235: ,last_updated_by = NVL(fnd_profile.value('USER_ID'),0)
1236: ,last_update_login = NVL(fnd_profile.value('USER_ID'),0 )
1237: WHERE var_rent_id = p_var_rent_id
1238: AND grp_date_id = c_grp.grp_date_id
1239: AND line_item_id = c_bkpt.line_item_id

Line 1236: ,last_update_login = NVL(fnd_profile.value('USER_ID'),0 )

1232: ,proration_rule_factor = l_factor
1233: ,bkpt_rate = c_bkpt.bkpt_rate
1234: ,last_update_date =sysdate
1235: ,last_updated_by = NVL(fnd_profile.value('USER_ID'),0)
1236: ,last_update_login = NVL(fnd_profile.value('USER_ID'),0 )
1237: WHERE var_rent_id = p_var_rent_id
1238: AND grp_date_id = c_grp.grp_date_id
1239: AND line_item_id = c_bkpt.line_item_id
1240: AND bkpt_detail_id = c_bkpt.bkpt_detail_id

Line 1593: ,last_updated_by = NVL(FND_PROFILE.VALUE('USER_ID'),0)

1589: ,prorated_grp_vol_end = l_prorate_end
1590: ,pr_grp_blended_vol_start = l_prorate_start
1591: ,pr_grp_blended_vol_end = l_prorate_end
1592: ,last_update_date = SYSDATE
1593: ,last_updated_by = NVL(FND_PROFILE.VALUE('USER_ID'),0)
1594: ,last_update_login = NVL(FND_PROFILE.VALUE('USER_ID'),0 )
1595: WHERE transaction_id = i4.transaction_id;
1596: /* DBMS_OUTPUT.PUT_LINE(' Step2 l_prorate_start='||l_prorate_start);
1597: DBMS_OUTPUT.PUT_LINE(' Step2 Rows Updated='||TO_CHAR(SQL%ROWCOUNT));

Line 1594: ,last_update_login = NVL(FND_PROFILE.VALUE('USER_ID'),0 )

1590: ,pr_grp_blended_vol_start = l_prorate_start
1591: ,pr_grp_blended_vol_end = l_prorate_end
1592: ,last_update_date = SYSDATE
1593: ,last_updated_by = NVL(FND_PROFILE.VALUE('USER_ID'),0)
1594: ,last_update_login = NVL(FND_PROFILE.VALUE('USER_ID'),0 )
1595: WHERE transaction_id = i4.transaction_id;
1596: /* DBMS_OUTPUT.PUT_LINE(' Step2 l_prorate_start='||l_prorate_start);
1597: DBMS_OUTPUT.PUT_LINE(' Step2 Rows Updated='||TO_CHAR(SQL%ROWCOUNT));
1598:

Line 1742: ,last_updated_by = NVL(FND_PROFILE.VALUE('USER_ID'),0)

1738: ,prorated_grp_vol_end = l_prorate_end
1739: ,pr_grp_blended_vol_start = l_prorate_start
1740: ,pr_grp_blended_vol_end = l_prorate_end
1741: ,last_update_date = SYSDATE
1742: ,last_updated_by = NVL(FND_PROFILE.VALUE('USER_ID'),0)
1743: ,last_update_login = NVL(FND_PROFILE.VALUE('USER_ID'),0 )
1744: WHERE transaction_id = i4.transaction_id;
1745: /* DBMS_OUTPUT.PUT_LINE(' Step2 l_prorate_start='||l_prorate_start);
1746: DBMS_OUTPUT.PUT_LINE(' Step2 Rows Updated='||TO_CHAR(SQL%ROWCOUNT));

Line 1743: ,last_update_login = NVL(FND_PROFILE.VALUE('USER_ID'),0 )

1739: ,pr_grp_blended_vol_start = l_prorate_start
1740: ,pr_grp_blended_vol_end = l_prorate_end
1741: ,last_update_date = SYSDATE
1742: ,last_updated_by = NVL(FND_PROFILE.VALUE('USER_ID'),0)
1743: ,last_update_login = NVL(FND_PROFILE.VALUE('USER_ID'),0 )
1744: WHERE transaction_id = i4.transaction_id;
1745: /* DBMS_OUTPUT.PUT_LINE(' Step2 l_prorate_start='||l_prorate_start);
1746: DBMS_OUTPUT.PUT_LINE(' Step2 Rows Updated='||TO_CHAR(SQL%ROWCOUNT));
1747:

Line 3548: X_CREATED_BY => NVL(FND_PROFILE.VALUE('USER_ID'),1),

3544: X_LINE_START_DATE => l_start_date,
3545: X_LINE_END_DATE => source_rec.line_end_date,
3546: X_PROCESSED_FLAG => NULL,
3547: X_CREATION_DATE => sysdate,
3548: X_CREATED_BY => NVL(FND_PROFILE.VALUE('USER_ID'),1),
3549: X_LAST_UPDATE_DATE => sysdate,
3550: X_LAST_UPDATED_BY => NVL(FND_PROFILE.VALUE('USER_ID'),1),
3551: X_LAST_UPDATE_LOGIN => NVL(FND_PROFILE.VALUE('LOGIN_ID'),1),
3552: X_ORG_ID => source_rec.org_id,

Line 3550: X_LAST_UPDATED_BY => NVL(FND_PROFILE.VALUE('USER_ID'),1),

3546: X_PROCESSED_FLAG => NULL,
3547: X_CREATION_DATE => sysdate,
3548: X_CREATED_BY => NVL(FND_PROFILE.VALUE('USER_ID'),1),
3549: X_LAST_UPDATE_DATE => sysdate,
3550: X_LAST_UPDATED_BY => NVL(FND_PROFILE.VALUE('USER_ID'),1),
3551: X_LAST_UPDATE_LOGIN => NVL(FND_PROFILE.VALUE('LOGIN_ID'),1),
3552: X_ORG_ID => source_rec.org_id,
3553: X_ATTRIBUTE_CATEGORY => source_rec.ATTRIBUTE_CATEGORY,
3554: X_ATTRIBUTE1 => source_rec.ATTRIBUTE1,

Line 3551: X_LAST_UPDATE_LOGIN => NVL(FND_PROFILE.VALUE('LOGIN_ID'),1),

3547: X_CREATION_DATE => sysdate,
3548: X_CREATED_BY => NVL(FND_PROFILE.VALUE('USER_ID'),1),
3549: X_LAST_UPDATE_DATE => sysdate,
3550: X_LAST_UPDATED_BY => NVL(FND_PROFILE.VALUE('USER_ID'),1),
3551: X_LAST_UPDATE_LOGIN => NVL(FND_PROFILE.VALUE('LOGIN_ID'),1),
3552: X_ORG_ID => source_rec.org_id,
3553: X_ATTRIBUTE_CATEGORY => source_rec.ATTRIBUTE_CATEGORY,
3554: X_ATTRIBUTE1 => source_rec.ATTRIBUTE1,
3555: X_ATTRIBUTE2 => source_rec.ATTRIBUTE2,

Line 3599: X_CREATED_BY => NVL(FND_PROFILE.VALUE('USER_ID'),1),

3595: X_BREAKPOINT_LEVEL => bkhd_source_rec.breakpoint_level,
3596: X_PROCESSED_FLAG => NULL,
3597: X_VAR_RENT_ID => p_new_var_rent_id,
3598: X_CREATION_DATE => sysdate,
3599: X_CREATED_BY => NVL(FND_PROFILE.VALUE('USER_ID'),1),
3600: X_LAST_UPDATE_DATE => sysdate,
3601: X_LAST_UPDATED_BY => NVL(FND_PROFILE.VALUE('USER_ID'),1),
3602: X_LAST_UPDATE_LOGIN => NVL(FND_PROFILE.VALUE('LOGIN_ID'),1),
3603: X_ORG_ID => source_rec.org_id,

Line 3601: X_LAST_UPDATED_BY => NVL(FND_PROFILE.VALUE('USER_ID'),1),

3597: X_VAR_RENT_ID => p_new_var_rent_id,
3598: X_CREATION_DATE => sysdate,
3599: X_CREATED_BY => NVL(FND_PROFILE.VALUE('USER_ID'),1),
3600: X_LAST_UPDATE_DATE => sysdate,
3601: X_LAST_UPDATED_BY => NVL(FND_PROFILE.VALUE('USER_ID'),1),
3602: X_LAST_UPDATE_LOGIN => NVL(FND_PROFILE.VALUE('LOGIN_ID'),1),
3603: X_ORG_ID => source_rec.org_id,
3604: X_ATTRIBUTE_CATEGORY => bkhd_source_rec.ATTRIBUTE_CATEGORY,
3605: X_ATTRIBUTE1 => bkhd_source_rec.ATTRIBUTE1,

Line 3602: X_LAST_UPDATE_LOGIN => NVL(FND_PROFILE.VALUE('LOGIN_ID'),1),

3598: X_CREATION_DATE => sysdate,
3599: X_CREATED_BY => NVL(FND_PROFILE.VALUE('USER_ID'),1),
3600: X_LAST_UPDATE_DATE => sysdate,
3601: X_LAST_UPDATED_BY => NVL(FND_PROFILE.VALUE('USER_ID'),1),
3602: X_LAST_UPDATE_LOGIN => NVL(FND_PROFILE.VALUE('LOGIN_ID'),1),
3603: X_ORG_ID => source_rec.org_id,
3604: X_ATTRIBUTE_CATEGORY => bkhd_source_rec.ATTRIBUTE_CATEGORY,
3605: X_ATTRIBUTE1 => bkhd_source_rec.ATTRIBUTE1,
3606: X_ATTRIBUTE2 => bkhd_source_rec.ATTRIBUTE2,

Line 3648: X_CREATED_BY => NVL(FND_PROFILE.VALUE('USER_ID'),1),

3644: X_BKPT_RATE => bkdt_source_rec.bkpt_rate,
3645: X_PROCESSED_FLAG => NULL,
3646: X_VAR_RENT_ID => p_new_var_rent_id,
3647: X_CREATION_DATE => sysdate,
3648: X_CREATED_BY => NVL(FND_PROFILE.VALUE('USER_ID'),1),
3649: X_LAST_UPDATE_DATE => sysdate,
3650: X_LAST_UPDATED_BY => NVL(FND_PROFILE.VALUE('USER_ID'),1),
3651: X_LAST_UPDATE_LOGIN => NVL(FND_PROFILE.VALUE('LOGIN_ID'),1),
3652: X_ORG_ID => source_rec.org_id,

Line 3650: X_LAST_UPDATED_BY => NVL(FND_PROFILE.VALUE('USER_ID'),1),

3646: X_VAR_RENT_ID => p_new_var_rent_id,
3647: X_CREATION_DATE => sysdate,
3648: X_CREATED_BY => NVL(FND_PROFILE.VALUE('USER_ID'),1),
3649: X_LAST_UPDATE_DATE => sysdate,
3650: X_LAST_UPDATED_BY => NVL(FND_PROFILE.VALUE('USER_ID'),1),
3651: X_LAST_UPDATE_LOGIN => NVL(FND_PROFILE.VALUE('LOGIN_ID'),1),
3652: X_ORG_ID => source_rec.org_id,
3653: X_ANNUAL_BASIS_AMOUNT => bkdt_source_rec.annual_basis_amount,
3654: X_ATTRIBUTE_CATEGORY => bkdt_source_rec.ATTRIBUTE_CATEGORY,

Line 3651: X_LAST_UPDATE_LOGIN => NVL(FND_PROFILE.VALUE('LOGIN_ID'),1),

3647: X_CREATION_DATE => sysdate,
3648: X_CREATED_BY => NVL(FND_PROFILE.VALUE('USER_ID'),1),
3649: X_LAST_UPDATE_DATE => sysdate,
3650: X_LAST_UPDATED_BY => NVL(FND_PROFILE.VALUE('USER_ID'),1),
3651: X_LAST_UPDATE_LOGIN => NVL(FND_PROFILE.VALUE('LOGIN_ID'),1),
3652: X_ORG_ID => source_rec.org_id,
3653: X_ANNUAL_BASIS_AMOUNT => bkdt_source_rec.annual_basis_amount,
3654: X_ATTRIBUTE_CATEGORY => bkdt_source_rec.ATTRIBUTE_CATEGORY,
3655: X_ATTRIBUTE1 => bkdt_source_rec.ATTRIBUTE1,

Line 3720: X_CREATED_BY => NVL(fnd_profile.value('USER_ID'),0),

3716: X_CONSTR_CAT_CODE => c_crec.CONSTR_CAT_CODE,
3717: X_TYPE_CODE => c_crec.type_code,
3718: X_AMOUNT => c_crec.amount,
3719: X_CREATION_DATE => sysdate,
3720: X_CREATED_BY => NVL(fnd_profile.value('USER_ID'),0),
3721: X_LAST_UPDATE_DATE => sysdate,
3722: X_LAST_UPDATED_BY => NVL(fnd_profile.value('USER_ID'),0),
3723: X_LAST_UPDATE_LOGIN => NVL(fnd_profile.value('LOGIN_ID'),0),
3724: X_ORG_ID => c_crec.ORG_ID,

Line 3722: X_LAST_UPDATED_BY => NVL(fnd_profile.value('USER_ID'),0),

3718: X_AMOUNT => c_crec.amount,
3719: X_CREATION_DATE => sysdate,
3720: X_CREATED_BY => NVL(fnd_profile.value('USER_ID'),0),
3721: X_LAST_UPDATE_DATE => sysdate,
3722: X_LAST_UPDATED_BY => NVL(fnd_profile.value('USER_ID'),0),
3723: X_LAST_UPDATE_LOGIN => NVL(fnd_profile.value('LOGIN_ID'),0),
3724: X_ORG_ID => c_crec.ORG_ID,
3725: X_ATTRIBUTE_CATEGORY => c_crec.ATTRIBUTE_CATEGORY,
3726: X_ATTRIBUTE1 => c_crec.ATTRIBUTE1,

Line 3723: X_LAST_UPDATE_LOGIN => NVL(fnd_profile.value('LOGIN_ID'),0),

3719: X_CREATION_DATE => sysdate,
3720: X_CREATED_BY => NVL(fnd_profile.value('USER_ID'),0),
3721: X_LAST_UPDATE_DATE => sysdate,
3722: X_LAST_UPDATED_BY => NVL(fnd_profile.value('USER_ID'),0),
3723: X_LAST_UPDATE_LOGIN => NVL(fnd_profile.value('LOGIN_ID'),0),
3724: X_ORG_ID => c_crec.ORG_ID,
3725: X_ATTRIBUTE_CATEGORY => c_crec.ATTRIBUTE_CATEGORY,
3726: X_ATTRIBUTE1 => c_crec.ATTRIBUTE1,
3727: X_ATTRIBUTE2 => c_crec.ATTRIBUTE2,

Line 3889: X_CREATED_BY => NVL(fnd_profile.value('USER_ID'),0),

3885: X_ATTRIBUTE13 => null,
3886: X_ATTRIBUTE14 => null,
3887: X_ATTRIBUTE15 => null,
3888: X_CREATION_DATE => sysdate,
3889: X_CREATED_BY => NVL(fnd_profile.value('USER_ID'),0),
3890: X_LAST_UPDATE_DATE => sysdate,
3891: X_LAST_UPDATED_BY => NVL(fnd_profile.value('USER_ID'),0),
3892: X_LAST_UPDATE_LOGIN => NVL(fnd_profile.value('LOGIN_ID'),0),
3893: X_ORG_ID => NVL(fnd_profile.value('org_id') ,239)

Line 3891: X_LAST_UPDATED_BY => NVL(fnd_profile.value('USER_ID'),0),

3887: X_ATTRIBUTE15 => null,
3888: X_CREATION_DATE => sysdate,
3889: X_CREATED_BY => NVL(fnd_profile.value('USER_ID'),0),
3890: X_LAST_UPDATE_DATE => sysdate,
3891: X_LAST_UPDATED_BY => NVL(fnd_profile.value('USER_ID'),0),
3892: X_LAST_UPDATE_LOGIN => NVL(fnd_profile.value('LOGIN_ID'),0),
3893: X_ORG_ID => NVL(fnd_profile.value('org_id') ,239)
3894: );
3895:

Line 3892: X_LAST_UPDATE_LOGIN => NVL(fnd_profile.value('LOGIN_ID'),0),

3888: X_CREATION_DATE => sysdate,
3889: X_CREATED_BY => NVL(fnd_profile.value('USER_ID'),0),
3890: X_LAST_UPDATE_DATE => sysdate,
3891: X_LAST_UPDATED_BY => NVL(fnd_profile.value('USER_ID'),0),
3892: X_LAST_UPDATE_LOGIN => NVL(fnd_profile.value('LOGIN_ID'),0),
3893: X_ORG_ID => NVL(fnd_profile.value('org_id') ,239)
3894: );
3895:
3896: END IF;

Line 3893: X_ORG_ID => NVL(fnd_profile.value('org_id') ,239)

3889: X_CREATED_BY => NVL(fnd_profile.value('USER_ID'),0),
3890: X_LAST_UPDATE_DATE => sysdate,
3891: X_LAST_UPDATED_BY => NVL(fnd_profile.value('USER_ID'),0),
3892: X_LAST_UPDATE_LOGIN => NVL(fnd_profile.value('LOGIN_ID'),0),
3893: X_ORG_ID => NVL(fnd_profile.value('org_id') ,239)
3894: );
3895:
3896: END IF;
3897: END;