DBA Data[Home] [Help]

APPS.OZF_PRICELIST_APPROVAL_PVT dependencies on FND_GLOBAL

Line 1023: last_updated_by = FND_GLOBAL.user_id,

1019: SET user_status_id = l_next_status_id,
1020: status_code = l_status_code,
1021: status_date = SYSDATE,
1022: last_update_date = SYSDATE,
1023: last_updated_by = FND_GLOBAL.user_id,
1024: last_update_login = FND_GLOBAL.conc_login_id,
1025: object_version_number = object_version_number + 1
1026: WHERE qp_list_header_id = l_list_header_id;
1027:

Line 1024: last_update_login = FND_GLOBAL.conc_login_id,

1020: status_code = l_status_code,
1021: status_date = SYSDATE,
1022: last_update_date = SYSDATE,
1023: last_updated_by = FND_GLOBAL.user_id,
1024: last_update_login = FND_GLOBAL.conc_login_id,
1025: object_version_number = object_version_number + 1
1026: WHERE qp_list_header_id = l_list_header_id;
1027:
1028: -- bug 3835674 make price list active in QP only when approval is passed

Line 1033: last_updated_by = FND_GLOBAL.user_id,

1029: IF l_status_code = 'ACTIVE' THEN
1030: UPDATE qp_list_headers_b
1031: SET active_flag = 'Y',
1032: last_update_date = SYSDATE,
1033: last_updated_by = FND_GLOBAL.user_id,
1034: last_update_login = FND_GLOBAL.conc_login_id
1035: WHERE list_header_id = l_list_header_id;
1036: END IF;
1037: -- bug 3835674 end

Line 1034: last_update_login = FND_GLOBAL.conc_login_id

1030: UPDATE qp_list_headers_b
1031: SET active_flag = 'Y',
1032: last_update_date = SYSDATE,
1033: last_updated_by = FND_GLOBAL.user_id,
1034: last_update_login = FND_GLOBAL.conc_login_id
1035: WHERE list_header_id = l_list_header_id;
1036: END IF;
1037: -- bug 3835674 end
1038: