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

Line 278: NVL(FND_GLOBAL.user_id,-1),

274: l_grant_update_flag,
275: l_grant_delete_flag,
276: l_locked_flag,
277: SYSDATE,
278: NVL(FND_GLOBAL.user_id,-1),
279: NVL(FND_GLOBAL.user_id,-1),
280: SYSDATE,
281: NVL(FND_GLOBAL.login_id, -1)
282: )

Line 279: NVL(FND_GLOBAL.user_id,-1),

275: l_grant_delete_flag,
276: l_locked_flag,
277: SYSDATE,
278: NVL(FND_GLOBAL.user_id,-1),
279: NVL(FND_GLOBAL.user_id,-1),
280: SYSDATE,
281: NVL(FND_GLOBAL.login_id, -1)
282: )
283: RETURNING grant_id INTO p_grant_id;

Line 281: NVL(FND_GLOBAL.login_id, -1)

277: SYSDATE,
278: NVL(FND_GLOBAL.user_id,-1),
279: NVL(FND_GLOBAL.user_id,-1),
280: SYSDATE,
281: NVL(FND_GLOBAL.login_id, -1)
282: )
283: RETURNING grant_id INTO p_grant_id;
284:
285: -- -----------------------------------------------------------------

Line 487: NVL(FND_GLOBAL.user_id,-1),

483: l_user_attr_id,
484: p_condition,
485: p_text_value,
486: SYSDATE,
487: NVL(FND_GLOBAL.user_id,-1),
488: NVL(FND_GLOBAL.user_id,-1),
489: SYSDATE,
490: NVL(FND_GLOBAL.login_id, -1)
491: );

Line 488: NVL(FND_GLOBAL.user_id,-1),

484: p_condition,
485: p_text_value,
486: SYSDATE,
487: NVL(FND_GLOBAL.user_id,-1),
488: NVL(FND_GLOBAL.user_id,-1),
489: SYSDATE,
490: NVL(FND_GLOBAL.login_id, -1)
491: );
492:

Line 490: NVL(FND_GLOBAL.login_id, -1)

486: SYSDATE,
487: NVL(FND_GLOBAL.user_id,-1),
488: NVL(FND_GLOBAL.user_id,-1),
489: SYSDATE,
490: NVL(FND_GLOBAL.login_id, -1)
491: );
492:
493: -- -----------------------------------------------------------------
494: -- Commit the transaction if requested to via parameter value.

Line 668: NVL(FND_GLOBAL.user_id,-1),

664: VALUES (NVL(p_obj_group_id,igs_sc_obj_groups_s.nextval),
665: p_obj_group_name,
666: l_default_policy_type,
667: SYSDATE,
668: NVL(FND_GLOBAL.user_id,-1),
669: NVL(FND_GLOBAL.user_id,-1),
670: SYSDATE,
671: NVL(FND_GLOBAL.login_id, -1)
672: )

Line 669: NVL(FND_GLOBAL.user_id,-1),

665: p_obj_group_name,
666: l_default_policy_type,
667: SYSDATE,
668: NVL(FND_GLOBAL.user_id,-1),
669: NVL(FND_GLOBAL.user_id,-1),
670: SYSDATE,
671: NVL(FND_GLOBAL.login_id, -1)
672: )
673: RETURNING obj_group_id INTO p_obj_group_id;

Line 671: NVL(FND_GLOBAL.login_id, -1)

667: SYSDATE,
668: NVL(FND_GLOBAL.user_id,-1),
669: NVL(FND_GLOBAL.user_id,-1),
670: SYSDATE,
671: NVL(FND_GLOBAL.login_id, -1)
672: )
673: RETURNING obj_group_id INTO p_obj_group_id;
674:
675: -- -----------------------------------------------------------------

Line 831: NVL(FND_GLOBAL.user_id,-1),

827: VALUES (l_obj_group_id,
828: NVL(p_obj_attrib_id,igs_sc_obj_attribs_s.nextval),
829: p_obj_attrib_name,
830: SYSDATE,
831: NVL(FND_GLOBAL.user_id,-1),
832: NVL(FND_GLOBAL.user_id,-1),
833: SYSDATE,
834: NVL(FND_GLOBAL.login_id, -1),
835: p_active_flag

Line 832: NVL(FND_GLOBAL.user_id,-1),

828: NVL(p_obj_attrib_id,igs_sc_obj_attribs_s.nextval),
829: p_obj_attrib_name,
830: SYSDATE,
831: NVL(FND_GLOBAL.user_id,-1),
832: NVL(FND_GLOBAL.user_id,-1),
833: SYSDATE,
834: NVL(FND_GLOBAL.login_id, -1),
835: p_active_flag
836: )

Line 834: NVL(FND_GLOBAL.login_id, -1),

830: SYSDATE,
831: NVL(FND_GLOBAL.user_id,-1),
832: NVL(FND_GLOBAL.user_id,-1),
833: SYSDATE,
834: NVL(FND_GLOBAL.login_id, -1),
835: p_active_flag
836: )
837: RETURNING obj_attrib_id INTO p_obj_attrib_id;
838:

Line 1046: NVL(FND_GLOBAL.user_id,-1),

1042: l_obj_attrib_type,
1043: l_static_type,
1044: p_select_text,
1045: SYSDATE,
1046: NVL(FND_GLOBAL.user_id,-1),
1047: NVL(FND_GLOBAL.user_id,-1),
1048: SYSDATE,
1049: NVL(FND_GLOBAL.login_id, -1),
1050: p_null_allow_flag

Line 1047: NVL(FND_GLOBAL.user_id,-1),

1043: l_static_type,
1044: p_select_text,
1045: SYSDATE,
1046: NVL(FND_GLOBAL.user_id,-1),
1047: NVL(FND_GLOBAL.user_id,-1),
1048: SYSDATE,
1049: NVL(FND_GLOBAL.login_id, -1),
1050: p_null_allow_flag
1051: );

Line 1049: NVL(FND_GLOBAL.login_id, -1),

1045: SYSDATE,
1046: NVL(FND_GLOBAL.user_id,-1),
1047: NVL(FND_GLOBAL.user_id,-1),
1048: SYSDATE,
1049: NVL(FND_GLOBAL.login_id, -1),
1050: p_null_allow_flag
1051: );
1052: -- -----------------------------------------------------------------
1053: -- Commit the transaction if requested to via parameter value.

Line 1208: NVL(FND_GLOBAL.user_id,-1),

1204: VALUES (NVL(igs_sc_obj_functns_s.nextval,p_function_id),
1205: l_obj_group_id,
1206: p_function_name,
1207: SYSDATE,
1208: NVL(FND_GLOBAL.user_id,-1),
1209: NVL(FND_GLOBAL.user_id,-1),
1210: SYSDATE,
1211: NVL(FND_GLOBAL.login_id, -1)
1212: )

Line 1209: NVL(FND_GLOBAL.user_id,-1),

1205: l_obj_group_id,
1206: p_function_name,
1207: SYSDATE,
1208: NVL(FND_GLOBAL.user_id,-1),
1209: NVL(FND_GLOBAL.user_id,-1),
1210: SYSDATE,
1211: NVL(FND_GLOBAL.login_id, -1)
1212: )
1213: RETURNING function_id INTO p_function_id;

Line 1211: NVL(FND_GLOBAL.login_id, -1)

1207: SYSDATE,
1208: NVL(FND_GLOBAL.user_id,-1),
1209: NVL(FND_GLOBAL.user_id,-1),
1210: SYSDATE,
1211: NVL(FND_GLOBAL.login_id, -1)
1212: )
1213: RETURNING function_id INTO p_function_id;
1214:
1215: -- -----------------------------------------------------------------

Line 1417: x_created_by => NVL(fnd_global.user_id,-1),

1413: x_database_object_name => p_database_object_name,
1414: x_display_name => p_obj_name,
1415: x_description => p_obj_name,
1416: x_creation_date => SYSDATE,
1417: x_created_by => NVL(fnd_global.user_id,-1),
1418: x_last_update_date => SYSDATE,
1419: x_last_updated_by => NVL(fnd_global.user_id,-1),
1420: x_last_update_login => NVL(fnd_global.login_id, -1));
1421:

Line 1419: x_last_updated_by => NVL(fnd_global.user_id,-1),

1415: x_description => p_obj_name,
1416: x_creation_date => SYSDATE,
1417: x_created_by => NVL(fnd_global.user_id,-1),
1418: x_last_update_date => SYSDATE,
1419: x_last_updated_by => NVL(fnd_global.user_id,-1),
1420: x_last_update_login => NVL(fnd_global.login_id, -1));
1421:
1422: END IF;
1423:

Line 1420: x_last_update_login => NVL(fnd_global.login_id, -1));

1416: x_creation_date => SYSDATE,
1417: x_created_by => NVL(fnd_global.user_id,-1),
1418: x_last_update_date => SYSDATE,
1419: x_last_updated_by => NVL(fnd_global.user_id,-1),
1420: x_last_update_login => NVL(fnd_global.login_id, -1));
1421:
1422: END IF;
1423:
1424: p_object_id := l_object_id;

Line 1449: NVL(FND_GLOBAL.user_id,-1),

1445: )
1446: VALUES (l_object_id,
1447: l_obj_group_id,
1448: SYSDATE,
1449: NVL(FND_GLOBAL.user_id,-1),
1450: NVL(FND_GLOBAL.user_id,-1),
1451: SYSDATE,
1452: NVL(FND_GLOBAL.login_id, -1),
1453: p_select_flag,

Line 1450: NVL(FND_GLOBAL.user_id,-1),

1446: VALUES (l_object_id,
1447: l_obj_group_id,
1448: SYSDATE,
1449: NVL(FND_GLOBAL.user_id,-1),
1450: NVL(FND_GLOBAL.user_id,-1),
1451: SYSDATE,
1452: NVL(FND_GLOBAL.login_id, -1),
1453: p_select_flag,
1454: p_insert_flag,

Line 1452: NVL(FND_GLOBAL.login_id, -1),

1448: SYSDATE,
1449: NVL(FND_GLOBAL.user_id,-1),
1450: NVL(FND_GLOBAL.user_id,-1),
1451: SYSDATE,
1452: NVL(FND_GLOBAL.login_id, -1),
1453: p_select_flag,
1454: p_insert_flag,
1455: p_update_flag,
1456: p_delete_flag,

Line 1660: NVL(FND_GLOBAL.user_id,-1),

1656: l_user_attrib_type,
1657: l_static_type,
1658: p_select_text,
1659: SYSDATE,
1660: NVL(FND_GLOBAL.user_id,-1),
1661: NVL(FND_GLOBAL.user_id,-1),
1662: SYSDATE,
1663: NVL(FND_GLOBAL.login_id, -1),
1664: p_active_flag

Line 1661: NVL(FND_GLOBAL.user_id,-1),

1657: l_static_type,
1658: p_select_text,
1659: SYSDATE,
1660: NVL(FND_GLOBAL.user_id,-1),
1661: NVL(FND_GLOBAL.user_id,-1),
1662: SYSDATE,
1663: NVL(FND_GLOBAL.login_id, -1),
1664: p_active_flag
1665: )

Line 1663: NVL(FND_GLOBAL.login_id, -1),

1659: SYSDATE,
1660: NVL(FND_GLOBAL.user_id,-1),
1661: NVL(FND_GLOBAL.user_id,-1),
1662: SYSDATE,
1663: NVL(FND_GLOBAL.login_id, -1),
1664: p_active_flag
1665: )
1666: RETURNING user_attrib_id INTO p_user_attrib_id;
1667:

Line 2224: x_last_updated_by => nvl(fnd_global.user_id,-1),

2220: x_database_object_name => p_database_object_name,
2221: x_display_name => p_obj_name,
2222: x_description => p_obj_name,
2223: x_last_update_date => sysdate,
2224: x_last_updated_by => nvl(fnd_global.user_id,-1),
2225: x_last_update_login => nvl(fnd_global.login_id, -1));
2226:
2227:
2228: UPDATE IGS_SC_OBJECTS SET

Line 2225: x_last_update_login => nvl(fnd_global.login_id, -1));

2221: x_display_name => p_obj_name,
2222: x_description => p_obj_name,
2223: x_last_update_date => sysdate,
2224: x_last_updated_by => nvl(fnd_global.user_id,-1),
2225: x_last_update_login => nvl(fnd_global.login_id, -1));
2226:
2227:
2228: UPDATE IGS_SC_OBJECTS SET
2229: LAST_UPDATED_BY = NVL(FND_GLOBAL.user_id,-1),

Line 2229: LAST_UPDATED_BY = NVL(FND_GLOBAL.user_id,-1),

2225: x_last_update_login => nvl(fnd_global.login_id, -1));
2226:
2227:
2228: UPDATE IGS_SC_OBJECTS SET
2229: LAST_UPDATED_BY = NVL(FND_GLOBAL.user_id,-1),
2230: LAST_UPDATE_DATE = SYSDATE,
2231: LAST_UPDATE_LOGIN = NVL(FND_GLOBAL.login_id, -1),
2232: SELECT_FLAG = P_SELECT_FLAG,
2233: INSERT_FLAG = P_INSERT_FLAG,

Line 2231: LAST_UPDATE_LOGIN = NVL(FND_GLOBAL.login_id, -1),

2227:
2228: UPDATE IGS_SC_OBJECTS SET
2229: LAST_UPDATED_BY = NVL(FND_GLOBAL.user_id,-1),
2230: LAST_UPDATE_DATE = SYSDATE,
2231: LAST_UPDATE_LOGIN = NVL(FND_GLOBAL.login_id, -1),
2232: SELECT_FLAG = P_SELECT_FLAG,
2233: INSERT_FLAG = P_INSERT_FLAG,
2234: UPDATE_FLAG = P_UPDATE_FLAG,
2235: DELETE_FLAG = P_DELETE_FLAG,

Line 2768: grts.last_updated_by = NVL(FND_GLOBAL.user_id,-1),

2764: grts.grant_select_flag = l_grant_select_flag,
2765: grts.grant_delete_flag = l_grant_delete_flag,
2766: grts.grant_update_flag = l_grant_update_flag,
2767: grts.grant_insert_flag = l_grant_insert_flag,
2768: grts.last_updated_by = NVL(FND_GLOBAL.user_id,-1),
2769: grts.last_update_date = SYSDATE,
2770: grts.last_update_login = NVL(FND_GLOBAL.login_id, -1)
2771: WHERE grts.grant_id = p_grant_id;
2772:

Line 2770: grts.last_update_login = NVL(FND_GLOBAL.login_id, -1)

2766: grts.grant_update_flag = l_grant_update_flag,
2767: grts.grant_insert_flag = l_grant_insert_flag,
2768: grts.last_updated_by = NVL(FND_GLOBAL.user_id,-1),
2769: grts.last_update_date = SYSDATE,
2770: grts.last_update_login = NVL(FND_GLOBAL.login_id, -1)
2771: WHERE grts.grant_id = p_grant_id;
2772:
2773: -- -----------------------------------------------------------------
2774: -- Commit the transaction if requested to via parameter value.

Line 2996: cnds.last_updated_by = NVL(FND_GLOBAL.user_id,-1),

2992: SET cnds.obj_attrib_id = l_obj_attrib_id,
2993: cnds.user_attrib_id = l_user_attrib_id,
2994: cnds.condition = p_condition,
2995: cnds.text_value = p_text_value,
2996: cnds.last_updated_by = NVL(FND_GLOBAL.user_id,-1),
2997: cnds.last_update_date = SYSDATE,
2998: cnds.last_update_login = NVL(FND_GLOBAL.login_id, -1),
2999: cnds.grant_cond_num = p_grant_cond_num
3000: WHERE cnds.grant_id = p_grant_id

Line 2998: cnds.last_update_login = NVL(FND_GLOBAL.login_id, -1),

2994: cnds.condition = p_condition,
2995: cnds.text_value = p_text_value,
2996: cnds.last_updated_by = NVL(FND_GLOBAL.user_id,-1),
2997: cnds.last_update_date = SYSDATE,
2998: cnds.last_update_login = NVL(FND_GLOBAL.login_id, -1),
2999: cnds.grant_cond_num = p_grant_cond_num
3000: WHERE cnds.grant_id = p_grant_id
3001: AND cnds.grant_cond_num = l_old_grant_cond_num;
3002:

Line 3212: objs.last_updated_by = NVL(FND_GLOBAL.user_id,-1),

3208: IF IGS_SC_GRANTS_PVT.admin_mode <> 'Y' AND g_upgrade_mode <> 'Y' THEN
3209:
3210: UPDATE igs_sc_obj_groups objs
3211: SET objs.default_policy_type = l_default_policy_type,
3212: objs.last_updated_by = NVL(FND_GLOBAL.user_id,-1),
3213: objs.last_update_date = SYSDATE,
3214: objs.last_update_login = NVL(FND_GLOBAL.login_id, -1)
3215: WHERE objs.obj_group_id = p_obj_group_id;
3216:

Line 3214: objs.last_update_login = NVL(FND_GLOBAL.login_id, -1)

3210: UPDATE igs_sc_obj_groups objs
3211: SET objs.default_policy_type = l_default_policy_type,
3212: objs.last_updated_by = NVL(FND_GLOBAL.user_id,-1),
3213: objs.last_update_date = SYSDATE,
3214: objs.last_update_login = NVL(FND_GLOBAL.login_id, -1)
3215: WHERE objs.obj_group_id = p_obj_group_id;
3216:
3217: ELSE
3218:

Line 3222: objs.last_updated_by = NVL(FND_GLOBAL.user_id,-1),

3218:
3219: UPDATE igs_sc_obj_groups objs
3220: SET objs.obj_group_name = l_obj_group_name,
3221: objs.default_policy_type = l_default_policy_type,
3222: objs.last_updated_by = NVL(FND_GLOBAL.user_id,-1),
3223: objs.last_update_date = SYSDATE,
3224: objs.last_update_login = NVL(FND_GLOBAL.login_id, -1)
3225: WHERE objs.obj_group_id = p_obj_group_id;
3226:

Line 3224: objs.last_update_login = NVL(FND_GLOBAL.login_id, -1)

3220: SET objs.obj_group_name = l_obj_group_name,
3221: objs.default_policy_type = l_default_policy_type,
3222: objs.last_updated_by = NVL(FND_GLOBAL.user_id,-1),
3223: objs.last_update_date = SYSDATE,
3224: objs.last_update_login = NVL(FND_GLOBAL.login_id, -1)
3225: WHERE objs.obj_group_id = p_obj_group_id;
3226:
3227: END IF;
3228:

Line 3494: mthd.last_updated_by = NVL(FND_GLOBAL.user_id,-1),

3490: UPDATE igs_sc_obj_att_mths mthd
3491: SET mthd.obj_attrib_type = l_obj_attrib_type,
3492: mthd.static_type = l_static_type,
3493: mthd.select_text = l_select_text,
3494: mthd.last_updated_by = NVL(FND_GLOBAL.user_id,-1),
3495: mthd.last_update_date = SYSDATE,
3496: mthd.last_update_login = NVL(FND_GLOBAL.login_id, -1),
3497: mthd.null_allow_flag = p_null_allow_flag
3498: WHERE mthd.object_id = p_object_id

Line 3496: mthd.last_update_login = NVL(FND_GLOBAL.login_id, -1),

3492: mthd.static_type = l_static_type,
3493: mthd.select_text = l_select_text,
3494: mthd.last_updated_by = NVL(FND_GLOBAL.user_id,-1),
3495: mthd.last_update_date = SYSDATE,
3496: mthd.last_update_login = NVL(FND_GLOBAL.login_id, -1),
3497: mthd.null_allow_flag = p_null_allow_flag
3498: WHERE mthd.object_id = p_object_id
3499: AND mthd.obj_attrib_id = p_obj_attrib_id;
3500:

Line 3699: fnct.last_updated_by = NVL(FND_GLOBAL.user_id,-1),

3695: -- Update the object function values received.
3696: -- -----------------------------------------------------------------
3697: UPDATE igs_sc_obj_functns fnct
3698: SET fnct.function_name = p_function_name,
3699: fnct.last_updated_by = NVL(FND_GLOBAL.user_id,-1),
3700: fnct.last_update_date = SYSDATE,
3701: fnct.last_update_login = NVL(FND_GLOBAL.login_id, -1)
3702: WHERE fnct.function_id = p_function_id;
3703:

Line 3701: fnct.last_update_login = NVL(FND_GLOBAL.login_id, -1)

3697: UPDATE igs_sc_obj_functns fnct
3698: SET fnct.function_name = p_function_name,
3699: fnct.last_updated_by = NVL(FND_GLOBAL.user_id,-1),
3700: fnct.last_update_date = SYSDATE,
3701: fnct.last_update_login = NVL(FND_GLOBAL.login_id, -1)
3702: WHERE fnct.function_id = p_function_id;
3703:
3704: -- -----------------------------------------------------------------
3705: -- Commit the transaction if requested to via parameter value.

Line 3907: attr.last_updated_by = NVL(FND_GLOBAL.user_id,-1),

3903: -- Update the object attributes with the values received.
3904: -- ----------------------------------------------------------------
3905: UPDATE igs_sc_obj_attribs attr
3906: SET attr.obj_attrib_name = p_obj_attrib_name,
3907: attr.last_updated_by = NVL(FND_GLOBAL.user_id,-1),
3908: attr.last_update_date = SYSDATE,
3909: attr.last_update_login = NVL(FND_GLOBAL.login_id, -1),
3910: attr.active_flag = p_active_flag
3911: WHERE attr.obj_attrib_id = p_obj_attrib_id;

Line 3909: attr.last_update_login = NVL(FND_GLOBAL.login_id, -1),

3905: UPDATE igs_sc_obj_attribs attr
3906: SET attr.obj_attrib_name = p_obj_attrib_name,
3907: attr.last_updated_by = NVL(FND_GLOBAL.user_id,-1),
3908: attr.last_update_date = SYSDATE,
3909: attr.last_update_login = NVL(FND_GLOBAL.login_id, -1),
3910: attr.active_flag = p_active_flag
3911: WHERE attr.obj_attrib_id = p_obj_attrib_id;
3912:
3913: -- -----------------------------------------------------------------

Line 4168: attr.last_updated_by = NVL(FND_GLOBAL.user_id,-1),

4164: SET attr.user_attrib_name = l_user_attrib_name,
4165: attr.user_attrib_type = l_user_attrib_type,
4166: attr.static_type = l_static_type,
4167: attr.select_text = l_select_text,
4168: attr.last_updated_by = NVL(FND_GLOBAL.user_id,-1),
4169: attr.last_update_date = SYSDATE,
4170: attr.last_update_login = NVL(FND_GLOBAL.login_id, -1),
4171: attr.active_flag = p_active_flag
4172: WHERE attr.user_attrib_id = p_user_attrib_id;

Line 4170: attr.last_update_login = NVL(FND_GLOBAL.login_id, -1),

4166: attr.static_type = l_static_type,
4167: attr.select_text = l_select_text,
4168: attr.last_updated_by = NVL(FND_GLOBAL.user_id,-1),
4169: attr.last_update_date = SYSDATE,
4170: attr.last_update_login = NVL(FND_GLOBAL.login_id, -1),
4171: attr.active_flag = p_active_flag
4172: WHERE attr.user_attrib_id = p_user_attrib_id;
4173:
4174: IF l_static_type IN ('C','S') AND (p_active_flag = 'Y') THEN

Line 8419: UTL_FILE.PUT_LINE ( p_file_ptr,' x_created_by => nvl(fnd_global.user_id,-1),');

8415: UTL_FILE.PUT_LINE ( p_file_ptr,' x_database_object_name => l_obj_tbl(l_cur_num).DATABASE_OBJECT_NAME,');
8416: UTL_FILE.PUT_LINE ( p_file_ptr,' x_display_name => l_obj_tbl(l_cur_num).OBJ_NAME,');
8417: UTL_FILE.PUT_LINE ( p_file_ptr,' x_description => l_obj_tbl(l_cur_num).OBJ_NAME,');
8418: UTL_FILE.PUT_LINE ( p_file_ptr,' x_creation_date => sysdate,');
8419: UTL_FILE.PUT_LINE ( p_file_ptr,' x_created_by => nvl(fnd_global.user_id,-1),');
8420: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_update_date => sysdate,');
8421: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_updated_by => nvl(fnd_global.user_id,-1),');
8422: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_update_login => nvl(fnd_global.login_id, -1));');
8423:

Line 8421: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_updated_by => nvl(fnd_global.user_id,-1),');

8417: UTL_FILE.PUT_LINE ( p_file_ptr,' x_description => l_obj_tbl(l_cur_num).OBJ_NAME,');
8418: UTL_FILE.PUT_LINE ( p_file_ptr,' x_creation_date => sysdate,');
8419: UTL_FILE.PUT_LINE ( p_file_ptr,' x_created_by => nvl(fnd_global.user_id,-1),');
8420: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_update_date => sysdate,');
8421: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_updated_by => nvl(fnd_global.user_id,-1),');
8422: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_update_login => nvl(fnd_global.login_id, -1));');
8423:
8424: UTL_FILE.PUT_LINE ( p_file_ptr,' ELSE');
8425:

Line 8422: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_update_login => nvl(fnd_global.login_id, -1));');

8418: UTL_FILE.PUT_LINE ( p_file_ptr,' x_creation_date => sysdate,');
8419: UTL_FILE.PUT_LINE ( p_file_ptr,' x_created_by => nvl(fnd_global.user_id,-1),');
8420: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_update_date => sysdate,');
8421: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_updated_by => nvl(fnd_global.user_id,-1),');
8422: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_update_login => nvl(fnd_global.login_id, -1));');
8423:
8424: UTL_FILE.PUT_LINE ( p_file_ptr,' ELSE');
8425:
8426: UTL_FILE.PUT_LINE ( p_file_ptr,' FND_OBJECTS_PKG.UPDATE_ROW (');

Line 8444: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_updated_by => nvl(fnd_global.user_id,-1),');

8440: UTL_FILE.PUT_LINE ( p_file_ptr,' x_database_object_name => l_obj_tbl(l_cur_num).DATABASE_OBJECT_NAME,');
8441: UTL_FILE.PUT_LINE ( p_file_ptr,' x_display_name => l_obj_tbl(l_cur_num).OBJ_NAME,');
8442: UTL_FILE.PUT_LINE ( p_file_ptr,' x_description => l_obj_tbl(l_cur_num).OBJ_NAME,');
8443: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_update_date => sysdate,');
8444: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_updated_by => nvl(fnd_global.user_id,-1),');
8445: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_update_login => nvl(fnd_global.login_id, -1));');
8446:
8447: UTL_FILE.PUT_LINE ( p_file_ptr,' END IF;');
8448: UTL_FILE.PUT_LINE ( p_file_ptr,' END LOOP;');

Line 8445: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_update_login => nvl(fnd_global.login_id, -1));');

8441: UTL_FILE.PUT_LINE ( p_file_ptr,' x_display_name => l_obj_tbl(l_cur_num).OBJ_NAME,');
8442: UTL_FILE.PUT_LINE ( p_file_ptr,' x_description => l_obj_tbl(l_cur_num).OBJ_NAME,');
8443: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_update_date => sysdate,');
8444: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_updated_by => nvl(fnd_global.user_id,-1),');
8445: UTL_FILE.PUT_LINE ( p_file_ptr,' x_last_update_login => nvl(fnd_global.login_id, -1));');
8446:
8447: UTL_FILE.PUT_LINE ( p_file_ptr,' END IF;');
8448: UTL_FILE.PUT_LINE ( p_file_ptr,' END LOOP;');
8449: