DBA Data[Home] [Help]

APPS.WSH_FOLDER_EXTENSIONS_PVT dependencies on FND_GLOBAL

Line 57: user_id = nvl(p_folder_ext_rec.user_id, FND_GLOBAL.USER_ID),

53: IF c_ext_rec_cur%FOUND THEN
54:
55: UPDATE WSH_FOLDER_EXTENSIONS
56: SET
57: user_id = nvl(p_folder_ext_rec.user_id, FND_GLOBAL.USER_ID),
58: application_id = nvl(p_folder_ext_rec.application_id, 665),
59: display_dlvy_main = nvl(p_folder_ext_rec.display_dlvy_main,'Y'), -- always display
60: display_dlvy_others = nvl(p_folder_ext_rec.display_dlvy_others,'N'),
61: display_line_main = nvl(p_folder_ext_rec.display_line_main,'Y'), -- always display

Line 73: last_updated_by = nvl(p_folder_ext_rec.last_updated_by, FND_GLOBAL.USER_ID),

69: display_ship_conf_dialogue = nvl(p_folder_ext_rec.display_ship_conf_dialogue,'Y'), -- By default is visible
70: display_trip_conf_dialogue = nvl(p_folder_ext_rec.display_trip_conf_dialogue,'Y'), -- By default is visible
71: display_trip_info = nvl(p_folder_ext_rec.display_trip_info,'Y'), -- By default is visible
72: last_update_date = nvl(p_folder_ext_rec.last_update_date, SYSDATE),
73: last_updated_by = nvl(p_folder_ext_rec.last_updated_by, FND_GLOBAL.USER_ID),
74: last_update_login = nvl(p_folder_ext_rec.last_update_login, FND_GLOBAL.LOGIN_ID)
75: WHERE
76: folder_id = p_folder_ext_rec.folder_id;
77: ELSE

Line 74: last_update_login = nvl(p_folder_ext_rec.last_update_login, FND_GLOBAL.LOGIN_ID)

70: display_trip_conf_dialogue = nvl(p_folder_ext_rec.display_trip_conf_dialogue,'Y'), -- By default is visible
71: display_trip_info = nvl(p_folder_ext_rec.display_trip_info,'Y'), -- By default is visible
72: last_update_date = nvl(p_folder_ext_rec.last_update_date, SYSDATE),
73: last_updated_by = nvl(p_folder_ext_rec.last_updated_by, FND_GLOBAL.USER_ID),
74: last_update_login = nvl(p_folder_ext_rec.last_update_login, FND_GLOBAL.LOGIN_ID)
75: WHERE
76: folder_id = p_folder_ext_rec.folder_id;
77: ELSE
78:

Line 108: nvl(p_folder_ext_rec.user_id,FND_GLOBAL.USER_ID),

104: VALUES
105: (
106: wsh_folder_extension_s.nextval,
107: p_folder_ext_rec.object,
108: nvl(p_folder_ext_rec.user_id,FND_GLOBAL.USER_ID),
109: p_folder_ext_rec.folder_id,
110: nvl(p_folder_ext_rec.application_id,665),
111: nvl(p_folder_ext_rec.display_dlvy_main,'Y'), -- always display
112: nvl(p_folder_ext_rec.display_dlvy_others,'N'),

Line 125: nvl(p_folder_ext_rec.created_by, FND_GLOBAL.USER_ID),

121: nvl(p_folder_ext_rec.display_ship_conf_dialogue,'Y'), -- By default is visible
122: nvl(p_folder_ext_rec.display_trip_conf_dialogue,'Y'), -- By default is visible
123: nvl(p_folder_ext_rec.display_trip_info,'Y'), -- By default is visible
124: nvl(p_folder_ext_rec.creation_date,SYSDATE),
125: nvl(p_folder_ext_rec.created_by, FND_GLOBAL.USER_ID),
126: nvl(p_folder_ext_rec.last_update_date, SYSDATE),
127: nvl(p_folder_ext_rec.last_updated_by, FND_GLOBAL.USER_ID),
128: nvl(p_folder_ext_rec.last_update_login, FND_GLOBAL.LOGIN_ID)
129: );

Line 127: nvl(p_folder_ext_rec.last_updated_by, FND_GLOBAL.USER_ID),

123: nvl(p_folder_ext_rec.display_trip_info,'Y'), -- By default is visible
124: nvl(p_folder_ext_rec.creation_date,SYSDATE),
125: nvl(p_folder_ext_rec.created_by, FND_GLOBAL.USER_ID),
126: nvl(p_folder_ext_rec.last_update_date, SYSDATE),
127: nvl(p_folder_ext_rec.last_updated_by, FND_GLOBAL.USER_ID),
128: nvl(p_folder_ext_rec.last_update_login, FND_GLOBAL.LOGIN_ID)
129: );
130: END IF;
131:

Line 128: nvl(p_folder_ext_rec.last_update_login, FND_GLOBAL.LOGIN_ID)

124: nvl(p_folder_ext_rec.creation_date,SYSDATE),
125: nvl(p_folder_ext_rec.created_by, FND_GLOBAL.USER_ID),
126: nvl(p_folder_ext_rec.last_update_date, SYSDATE),
127: nvl(p_folder_ext_rec.last_updated_by, FND_GLOBAL.USER_ID),
128: nvl(p_folder_ext_rec.last_update_login, FND_GLOBAL.LOGIN_ID)
129: );
130: END IF;
131:
132: COMMIT;

Line 332: nvl(p_folder_cust_tab(i).user_id,FND_GLOBAL.USER_ID),

328: (p_folder_cust_tab(i).action_id,
329: p_folder_cust_tab(i).action_name,
330: p_folder_cust_tab(i).object,
331: p_folder_cust_tab(i).user_entered_prompt,
332: nvl(p_folder_cust_tab(i).user_id,FND_GLOBAL.USER_ID),
333: p_folder_cust_tab(i).folder_id,
334: p_folder_cust_tab(i).width,
335: p_folder_cust_tab(i).access_key,
336: p_folder_cust_tab(i).display_as_button_flag,

Line 339: nvl(p_folder_cust_tab(i).created_by, FND_GLOBAL.USER_ID),

335: p_folder_cust_tab(i).access_key,
336: p_folder_cust_tab(i).display_as_button_flag,
337: p_folder_cust_tab(i).default_prompt,
338: nvl(p_folder_cust_tab(i).creation_date,SYSDATE),
339: nvl(p_folder_cust_tab(i).created_by, FND_GLOBAL.USER_ID),
340: nvl(p_folder_cust_tab(i).last_update_date, SYSDATE),
341: nvl(p_folder_cust_tab(i).last_updated_by, FND_GLOBAL.USER_ID),
342: nvl(p_folder_cust_tab(i).last_update_login, FND_GLOBAL.LOGIN_ID)
343: );

Line 341: nvl(p_folder_cust_tab(i).last_updated_by, FND_GLOBAL.USER_ID),

337: p_folder_cust_tab(i).default_prompt,
338: nvl(p_folder_cust_tab(i).creation_date,SYSDATE),
339: nvl(p_folder_cust_tab(i).created_by, FND_GLOBAL.USER_ID),
340: nvl(p_folder_cust_tab(i).last_update_date, SYSDATE),
341: nvl(p_folder_cust_tab(i).last_updated_by, FND_GLOBAL.USER_ID),
342: nvl(p_folder_cust_tab(i).last_update_login, FND_GLOBAL.LOGIN_ID)
343: );
344: END LOOP;
345:

Line 342: nvl(p_folder_cust_tab(i).last_update_login, FND_GLOBAL.LOGIN_ID)

338: nvl(p_folder_cust_tab(i).creation_date,SYSDATE),
339: nvl(p_folder_cust_tab(i).created_by, FND_GLOBAL.USER_ID),
340: nvl(p_folder_cust_tab(i).last_update_date, SYSDATE),
341: nvl(p_folder_cust_tab(i).last_updated_by, FND_GLOBAL.USER_ID),
342: nvl(p_folder_cust_tab(i).last_update_login, FND_GLOBAL.LOGIN_ID)
343: );
344: END LOOP;
345:
346: ELSE