APPS.AMS_PARTY_SEG_LOADER_PVT dependencies on FND_GLOBAL

Line 206: , last_updated_by = FND_GLOBAL.user_id

202: FORALL i in l_exp_party_tbl.FIRST..l_exp_party_tbl.LAST
203: UPDATE AMS_PARTY_MARKET_SEGMENTS
204: SET end_date_active = SYSDATE
205: , last_update_date = SYSDATE
206: , last_updated_by = FND_GLOBAL.user_id
207: , last_update_login = FND_GLOBAL.conc_login_id
208: WHERE market_segment_id = p_mkt_seg_id
209: AND party_id = l_exp_party_tbl(i);
210: END IF;

Line 207: , last_update_login = FND_GLOBAL.conc_login_id

203: UPDATE AMS_PARTY_MARKET_SEGMENTS
204: SET end_date_active = SYSDATE
205: , last_update_date = SYSDATE
206: , last_updated_by = FND_GLOBAL.user_id
207: , last_update_login = FND_GLOBAL.conc_login_id
208: WHERE market_segment_id = p_mkt_seg_id
209: AND party_id = l_exp_party_tbl(i);
210: END IF;
211:

Line 319: , last_updated_by = FND_GLOBAL.user_id

315: FORALL i in l_sql_tbl.first .. l_sql_tbl.last
316: UPDATE AMS_PARTY_MARKET_SEGMENTS
317: SET end_date_active = SYSDATE
318: , last_update_date = SYSDATE
319: , last_updated_by = FND_GLOBAL.user_id
320: , last_update_login = FND_GLOBAL.conc_login_id
321: WHERE market_segment_id = l_old_mkt_seg_id
322: AND party_id = l_sql_tbl(i);
323: END IF;

Line 320: , last_update_login = FND_GLOBAL.conc_login_id

316: UPDATE AMS_PARTY_MARKET_SEGMENTS
317: SET end_date_active = SYSDATE
318: , last_update_date = SYSDATE
319: , last_updated_by = FND_GLOBAL.user_id
320: , last_update_login = FND_GLOBAL.conc_login_id
321: WHERE market_segment_id = l_old_mkt_seg_id
322: AND party_id = l_sql_tbl(i);
323: END IF;
324:

Line 434: , FND_GLOBAL.user_id

430: )
431: select
432: AMS_PARTY_MARKET_SEGMENTS_S.NEXTVAL
433: , SYSDATE
434: , FND_GLOBAL.user_id
435: , SYSDATE
436: , FND_GLOBAL.user_id
437: , FND_GLOBAL.conc_login_id
438: , 1

Line 436: , FND_GLOBAL.user_id

432: AMS_PARTY_MARKET_SEGMENTS_S.NEXTVAL
433: , SYSDATE
434: , FND_GLOBAL.user_id
435: , SYSDATE
436: , FND_GLOBAL.user_id
437: , FND_GLOBAL.conc_login_id
438: , 1
439: , p_mkt_seg_id
440: , 'Y' -- always put true for market_segment_flag

Line 437: , FND_GLOBAL.conc_login_id

433: , SYSDATE
434: , FND_GLOBAL.user_id
435: , SYSDATE
436: , FND_GLOBAL.user_id
437: , FND_GLOBAL.conc_login_id
438: , 1
439: , p_mkt_seg_id
440: , 'Y' -- always put true for market_segment_flag
441: , l_party_tbl(i)

Line 464: , last_updated_by = FND_GLOBAL.user_id

460: IF l_party_tbl.count > 0 THEN
461: FORALL i IN l_party_tbl.FIRST..l_party_tbl.LAST
462: UPDATE AMS_PARTY_MARKET_SEGMENTS SET
463: last_update_date = SYSDATE
464: , last_updated_by = FND_GLOBAL.user_id
465: , last_update_login = FND_GLOBAL.conc_login_id
466: , object_version_number = object_version_number + 1
467: , market_segment_id = p_mkt_seg_id
468: , party_id = l_party_tbl(i)

Line 465: , last_update_login = FND_GLOBAL.conc_login_id

461: FORALL i IN l_party_tbl.FIRST..l_party_tbl.LAST
462: UPDATE AMS_PARTY_MARKET_SEGMENTS SET
463: last_update_date = SYSDATE
464: , last_updated_by = FND_GLOBAL.user_id
465: , last_update_login = FND_GLOBAL.conc_login_id
466: , object_version_number = object_version_number + 1
467: , market_segment_id = p_mkt_seg_id
468: , party_id = l_party_tbl(i)
469: , start_date_active =SYSDATE

Line 639: last_updated_by = FND_GLOBAL.user_id,

635: UPDATE ams_cells_all_b
636: SET original_size = l_party_count,
637: object_version_number = object_version_number + 1,
638: last_update_date = SYSDATE,
639: last_updated_by = FND_GLOBAL.user_id,
640: last_update_login = FND_GLOBAL.conc_login_id
641: WHERE cell_id = l_cell_id;
642:
643: -- Keep size history

Line 640: last_update_login = FND_GLOBAL.conc_login_id

636: SET original_size = l_party_count,
637: object_version_number = object_version_number + 1,
638: last_update_date = SYSDATE,
639: last_updated_by = FND_GLOBAL.user_id,
640: last_update_login = FND_GLOBAL.conc_login_id
641: WHERE cell_id = l_cell_id;
642:
643: -- Keep size history
644: OPEN C_last_size(l_cell_id);

Line 670: fnd_global.user_id,

666: VALUES
667: (
668: ams_act_sizes_s.nextval,
669: SYSDATE,
670: fnd_global.user_id,
671: SYSDATE,
672: fnd_global.user_id,
673: fnd_global.conc_login_id,
674: l_cell_id,

Line 672: fnd_global.user_id,

668: ams_act_sizes_s.nextval,
669: SYSDATE,
670: fnd_global.user_id,
671: SYSDATE,
672: fnd_global.user_id,
673: fnd_global.conc_login_id,
674: l_cell_id,
675: 'CELL',
676: l_party_count,

Line 673: fnd_global.conc_login_id,

669: SYSDATE,
670: fnd_global.user_id,
671: SYSDATE,
672: fnd_global.user_id,
673: fnd_global.conc_login_id,
674: l_cell_id,
675: 'CELL',
676: l_party_count,
677: 'SUCCESSED',