DBA Data[Home] [Help]

APPS.AMS_PARTYIMPORT_PVT dependencies on FND_GLOBAL

Line 467: FND_GLOBAL.user_id, -- last_updated_by

463: l_party_rec.party_id,
464: l_party_rec.import_source_line_id,
465: 1, -- object_version_number
466: SYSDATE, -- last_update_date
467: FND_GLOBAL.user_id, -- last_updated_by
468: SYSDATE, -- creation_date
469: FND_GLOBAL.user_id, -- created_by
470: FND_GLOBAL.conc_login_id, -- last_update_login
471: l_party_rec.import_list_header_id,

Line 469: FND_GLOBAL.user_id, -- created_by

465: 1, -- object_version_number
466: SYSDATE, -- last_update_date
467: FND_GLOBAL.user_id, -- last_updated_by
468: SYSDATE, -- creation_date
469: FND_GLOBAL.user_id, -- created_by
470: FND_GLOBAL.conc_login_id, -- last_update_login
471: l_party_rec.import_list_header_id,
472: l_party_rec.list_source_type_id,
473: NVL (l_party_rec.used_flag, 'N'), -- Default to 'N'

Line 470: FND_GLOBAL.conc_login_id, -- last_update_login

466: SYSDATE, -- last_update_date
467: FND_GLOBAL.user_id, -- last_updated_by
468: SYSDATE, -- creation_date
469: FND_GLOBAL.user_id, -- created_by
470: FND_GLOBAL.conc_login_id, -- last_update_login
471: l_party_rec.import_list_header_id,
472: l_party_rec.list_source_type_id,
473: NVL (l_party_rec.used_flag, 'N'), -- Default to 'N'
474: NVL (l_party_rec.overlay_flag, 'N'), -- Default to 'N'

Line 1121: last_updated_by = FND_GLOBAL.user_id,

1117: party_id = l_party_rec.party_id,
1118: import_source_line_id = l_party_rec.import_source_line_id,
1119: object_version_number = l_party_rec.object_version_number,
1120: last_update_date = SYSDATE,
1121: last_updated_by = FND_GLOBAL.user_id,
1122: last_update_login = FND_GLOBAL.conc_login_id,
1123: import_list_header_id = l_party_rec.import_list_header_id,
1124: list_source_type_id = l_party_rec.list_source_type_id,
1125: used_flag = NVL (l_party_rec.used_flag, 'N'),

Line 1122: last_update_login = FND_GLOBAL.conc_login_id,

1118: import_source_line_id = l_party_rec.import_source_line_id,
1119: object_version_number = l_party_rec.object_version_number,
1120: last_update_date = SYSDATE,
1121: last_updated_by = FND_GLOBAL.user_id,
1122: last_update_login = FND_GLOBAL.conc_login_id,
1123: import_list_header_id = l_party_rec.import_list_header_id,
1124: list_source_type_id = l_party_rec.list_source_type_id,
1125: used_flag = NVL (l_party_rec.used_flag, 'N'),
1126: overlay_flag = NVL (l_party_rec.overlay_flag, 'N'),

Line 3700: FND_GLOBAL.user_id, -- last_updated_by

3696: object_version_number
3697: )
3698: SELECT party_id,
3699: SYSDATE, -- last_update_date
3700: FND_GLOBAL.user_id, -- last_updated_by
3701: SYSDATE, -- creation_date
3702: FND_GLOBAL.user_id, -- created_by
3703: FND_GLOBAL.conc_login_id, -- last_update_login
3704: 1 -- object_version_number

Line 3702: FND_GLOBAL.user_id, -- created_by

3698: SELECT party_id,
3699: SYSDATE, -- last_update_date
3700: FND_GLOBAL.user_id, -- last_updated_by
3701: SYSDATE, -- creation_date
3702: FND_GLOBAL.user_id, -- created_by
3703: FND_GLOBAL.conc_login_id, -- last_update_login
3704: 1 -- object_version_number
3705: FROM hz_parties
3706: ;

Line 3703: FND_GLOBAL.conc_login_id, -- last_update_login

3699: SYSDATE, -- last_update_date
3700: FND_GLOBAL.user_id, -- last_updated_by
3701: SYSDATE, -- creation_date
3702: FND_GLOBAL.user_id, -- created_by
3703: FND_GLOBAL.conc_login_id, -- last_update_login
3704: 1 -- object_version_number
3705: FROM hz_parties
3706: ;
3707: END Synchronize_ID;

Line 3783: last_updated_by = FND_GLOBAL.user_id,

3779: UPDATE ams_party_dedupe
3780: SET
3781: dedupe_key = l_dedupe_key,
3782: last_update_date = SYSDATE,
3783: last_updated_by = FND_GLOBAL.user_id,
3784: last_update_login = FND_GLOBAL.conc_login_id,
3785: object_version_number = object_version_number + 1
3786: WHERE party_id = l_party_id;
3787: END LOOP;

Line 3784: last_update_login = FND_GLOBAL.conc_login_id,

3780: SET
3781: dedupe_key = l_dedupe_key,
3782: last_update_date = SYSDATE,
3783: last_updated_by = FND_GLOBAL.user_id,
3784: last_update_login = FND_GLOBAL.conc_login_id,
3785: object_version_number = object_version_number + 1
3786: WHERE party_id = l_party_id;
3787: END LOOP;
3788: CLOSE c_id;

Line 4252: last_updated_by = FND_GLOBAL.user_id,

4248: UPDATE ams_imp_source_lines
4249: SET
4250: party_id = l_party_id,
4251: dedupe_key = l_dedupe_key,
4252: last_updated_by = FND_GLOBAL.user_id,
4253: last_update_date = SYSDATE,
4254: last_update_login = FND_GLOBAL.conc_login_id,
4255: object_version_number = object_version_number + 1
4256: WHERE import_source_line_id = p_import_source_line_id;

Line 4254: last_update_login = FND_GLOBAL.conc_login_id,

4250: party_id = l_party_id,
4251: dedupe_key = l_dedupe_key,
4252: last_updated_by = FND_GLOBAL.user_id,
4253: last_update_date = SYSDATE,
4254: last_update_login = FND_GLOBAL.conc_login_id,
4255: object_version_number = object_version_number + 1
4256: WHERE import_source_line_id = p_import_source_line_id;
4257:
4258: --