DBA Data[Home] [Help]

APPS.FTP_TP_PKG dependencies on FND_GLOBAL

Line 212: user_id := fnd_global.user_id;

208: l_value_set_id in number) is
209: user_id number;
210: login_id number;
211: begin
212: user_id := fnd_global.user_id;
213: login_id := fnd_global.login_id;
214: delete ftp_tp_pp_node_map where map_id = node_map_id;
215: insert into ftp_tp_pp_node_map
216: (node_map_id, line_item_id, value_set_id,

Line 213: login_id := fnd_global.login_id;

209: user_id number;
210: login_id number;
211: begin
212: user_id := fnd_global.user_id;
213: login_id := fnd_global.login_id;
214: delete ftp_tp_pp_node_map where map_id = node_map_id;
215: insert into ftp_tp_pp_node_map
216: (node_map_id, line_item_id, value_set_id,
217: currency, tp_node,

Line 238: user_id := fnd_global.user_id;

234: l_value_set_id in number) is
235: user_id number;
236: login_id number;
237: begin
238: user_id := fnd_global.user_id;
239: login_id := fnd_global.login_id;
240: update ftp_tp_pp_node_map a set pp_node =
241: (select distinct line_item_id from ftp_prepayment_rule p
242: where p.object_definition_id = pp_obj_def

Line 239: login_id := fnd_global.login_id;

235: user_id number;
236: login_id number;
237: begin
238: user_id := fnd_global.user_id;
239: login_id := fnd_global.login_id;
240: update ftp_tp_pp_node_map a set pp_node =
241: (select distinct line_item_id from ftp_prepayment_rule p
242: where p.object_definition_id = pp_obj_def
243: and p.line_item_id = a.line_item_id

Line 263: user_id := fnd_global.user_id;

259: l_value_set_id in number) is
260: user_id number;
261: login_id number;
262: begin
263: user_id := fnd_global.user_id;
264: login_id := fnd_global.login_id;
265:
266: --Merge into Node map table
267: --When found means TP assumptions exists and we need to update adjustment

Line 264: login_id := fnd_global.login_id;

260: user_id number;
261: login_id number;
262: begin
263: user_id := fnd_global.user_id;
264: login_id := fnd_global.login_id;
265:
266: --Merge into Node map table
267: --When found means TP assumptions exists and we need to update adjustment
268: --assumptions

Line 301: user_id := fnd_global.user_id;

297: login_id number;
298: cursor c is select distinct currency from ftp_transfer_price_rule
299: where object_definition_id = tp_obj_def;
300: begin
301: user_id := fnd_global.user_id;
302: login_id := fnd_global.login_id;
303: delete ftp_tp_pp_node_map where map_id = node_map_id;
304: -- move things currency by currency
305: for cur in c loop

Line 302: login_id := fnd_global.login_id;

298: cursor c is select distinct currency from ftp_transfer_price_rule
299: where object_definition_id = tp_obj_def;
300: begin
301: user_id := fnd_global.user_id;
302: login_id := fnd_global.login_id;
303: delete ftp_tp_pp_node_map where map_id = node_map_id;
304: -- move things currency by currency
305: for cur in c loop
306: insert into ftp_tp_pp_node_map

Line 367: user_id := fnd_global.user_id;

363: login_id number;
364: cursor c is select distinct currency from ftp_prepayment_rule
365: where object_definition_id = pp_obj_def;
366: begin
367: user_id := fnd_global.user_id;
368: login_id := fnd_global.login_id;
369: -- move things currency by currency
370: for cur in c loop
371: update ftp_tp_pp_node_map a set pp_node =

Line 368: login_id := fnd_global.login_id;

364: cursor c is select distinct currency from ftp_prepayment_rule
365: where object_definition_id = pp_obj_def;
366: begin
367: user_id := fnd_global.user_id;
368: login_id := fnd_global.login_id;
369: -- move things currency by currency
370: for cur in c loop
371: update ftp_tp_pp_node_map a set pp_node =
372: (select h.parent_id

Line 424: user_id := fnd_global.user_id;

420: cursor c is select distinct currency from ftp_adjustment_rule
421: where object_definition_id = adj_obj_def;
422: --l_count number;
423: begin
424: user_id := fnd_global.user_id;
425: login_id := fnd_global.login_id;
426:
427: --Merge into Node map table
428: --When found means TP assumptions exists and we need to update adjustment

Line 425: login_id := fnd_global.login_id;

421: where object_definition_id = adj_obj_def;
422: --l_count number;
423: begin
424: user_id := fnd_global.user_id;
425: login_id := fnd_global.login_id;
426:
427: --Merge into Node map table
428: --When found means TP assumptions exists and we need to update adjustment
429: --assumptions

Line 572: fnd_global.user_id,

568: adj_def_id,
569: e_s_date,
570: e_e_date,
571: sysdate,
572: fnd_global.user_id,
573: fnd_global.user_id,
574: sysdate,
575: fnd_global.login_id,
576: OBJECT_ID,

Line 573: fnd_global.user_id,

569: e_s_date,
570: e_e_date,
571: sysdate,
572: fnd_global.user_id,
573: fnd_global.user_id,
574: sysdate,
575: fnd_global.login_id,
576: OBJECT_ID,
577: REQUEST_ID,

Line 575: fnd_global.login_id,

571: sysdate,
572: fnd_global.user_id,
573: fnd_global.user_id,
574: sysdate,
575: fnd_global.login_id,
576: OBJECT_ID,
577: REQUEST_ID,
578: OBJECT_ID,
579: REQUEST_ID

Line 708: set last_updated_by = fnd_global.user_id,

704: end if;
705: --update the header table to set last_update_date.
706: if hier_updated then
707: update ftp_tp_pp_node_header a
708: set last_updated_by = fnd_global.user_id,
709: last_update_date = sysdate,
710: last_update_login = fnd_global.login_id
711: where a.node_map_id = map_id;
712: end if;

Line 710: last_update_login = fnd_global.login_id

706: if hier_updated then
707: update ftp_tp_pp_node_header a
708: set last_updated_by = fnd_global.user_id,
709: last_update_date = sysdate,
710: last_update_login = fnd_global.login_id
711: where a.node_map_id = map_id;
712: end if;
713:
714: exception

Line 756: last_updated_by = fnd_global.user_id,

752: e_date);
753: -- set end date to end date from previous.
754: update ftp_tp_pp_node_header a
755: set effective_end_date = e_date,
756: last_updated_by = fnd_global.user_id,
757: last_update_date = sysdate,
758: last_update_login = fnd_global.login_id
759: where a.node_map_id = map_id;
760: end fix_end_date;

Line 758: last_update_login = fnd_global.login_id

754: update ftp_tp_pp_node_header a
755: set effective_end_date = e_date,
756: last_updated_by = fnd_global.user_id,
757: last_update_date = sysdate,
758: last_update_login = fnd_global.login_id
759: where a.node_map_id = map_id;
760: end fix_end_date;
761: procedure VALIDATE_NODE_MAP(
762: OBJ_ID IN NUMBER,

Line 871: last_updated_by = fnd_global.user_id,

867: if e_date <> map_id.eff_end_date then
868: -- effective end date has changed, update it.
869: update ftp_tp_pp_node_header a
870: set effective_end_date = e_date,
871: last_updated_by = fnd_global.user_id,
872: last_update_date = sysdate,
873: last_update_login = fnd_global.login_id,
874: -- The object id will always be the same.
875: created_by_request_id = REQUEST_ID,

Line 873: last_update_login = fnd_global.login_id,

869: update ftp_tp_pp_node_header a
870: set effective_end_date = e_date,
871: last_updated_by = fnd_global.user_id,
872: last_update_date = sysdate,
873: last_update_login = fnd_global.login_id,
874: -- The object id will always be the same.
875: created_by_request_id = REQUEST_ID,
876: last_updated_by_request_id = REQUEST_ID
877: where a.node_map_id = validate_node_map.node_map_id;